//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated from a template.
//
//     Manual changes to this file may cause unexpected behavior in your application.
//     Manual changes to this file will be overwritten if the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

namespace Neo.Afx.Services.Notifications.Entities
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class NotificationsContext : DbContext
    {
        public NotificationsContext()
            : base("name=NotificationsContext")
        {
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<Vw_Notifications> Vw_Notifications { get; set; }
        public virtual DbSet<NotificationCategory> NotificationCategories { get; set; }
        public virtual DbSet<Notification> Notifications { get; set; }
    
        public virtual ObjectResult<Nullable<long>> Pr_NotificationCreate(Nullable<long> userID, Nullable<int> entityID, Nullable<long> itemID, Nullable<short> notificationCategoryID, Nullable<short> notificationTypeID, string notification, string notificationCreatedByUserName)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var entityIDParameter = entityID.HasValue ?
                new ObjectParameter("EntityID", entityID) :
                new ObjectParameter("EntityID", typeof(int));
    
            var itemIDParameter = itemID.HasValue ?
                new ObjectParameter("ItemID", itemID) :
                new ObjectParameter("ItemID", typeof(long));
    
            var notificationCategoryIDParameter = notificationCategoryID.HasValue ?
                new ObjectParameter("NotificationCategoryID", notificationCategoryID) :
                new ObjectParameter("NotificationCategoryID", typeof(short));
    
            var notificationTypeIDParameter = notificationTypeID.HasValue ?
                new ObjectParameter("NotificationTypeID", notificationTypeID) :
                new ObjectParameter("NotificationTypeID", typeof(short));
    
            var notificationParameter = notification != null ?
                new ObjectParameter("Notification", notification) :
                new ObjectParameter("Notification", typeof(string));
    
            var notificationCreatedByUserNameParameter = notificationCreatedByUserName != null ?
                new ObjectParameter("NotificationCreatedByUserName", notificationCreatedByUserName) :
                new ObjectParameter("NotificationCreatedByUserName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_NotificationCreate", userIDParameter, entityIDParameter, itemIDParameter, notificationCategoryIDParameter, notificationTypeIDParameter, notificationParameter, notificationCreatedByUserNameParameter);
        }
    
        public virtual ObjectResult<Nullable<long>> Pr_NotificationMarkAsRead(Nullable<long> notificationID, string notificationReadByUserName)
        {
            var notificationIDParameter = notificationID.HasValue ?
                new ObjectParameter("NotificationID", notificationID) :
                new ObjectParameter("NotificationID", typeof(long));
    
            var notificationReadByUserNameParameter = notificationReadByUserName != null ?
                new ObjectParameter("NotificationReadByUserName", notificationReadByUserName) :
                new ObjectParameter("NotificationReadByUserName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_NotificationMarkAsRead", notificationIDParameter, notificationReadByUserNameParameter);
        }
    
        public virtual ObjectResult<Vw_Notifications> Pr_NotificationSearch(Nullable<long> userID, Nullable<int> entityID, Nullable<long> itemID, Nullable<bool> unreadOnly)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var entityIDParameter = entityID.HasValue ?
                new ObjectParameter("EntityID", entityID) :
                new ObjectParameter("EntityID", typeof(int));
    
            var itemIDParameter = itemID.HasValue ?
                new ObjectParameter("ItemID", itemID) :
                new ObjectParameter("ItemID", typeof(long));
    
            var unreadOnlyParameter = unreadOnly.HasValue ?
                new ObjectParameter("UnreadOnly", unreadOnly) :
                new ObjectParameter("UnreadOnly", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_Notifications>("Pr_NotificationSearch", userIDParameter, entityIDParameter, itemIDParameter, unreadOnlyParameter);
        }
    
        public virtual ObjectResult<Vw_Notifications> Pr_NotificationSearch(Nullable<long> userID, Nullable<int> entityID, Nullable<long> itemID, Nullable<bool> unreadOnly, MergeOption mergeOption)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var entityIDParameter = entityID.HasValue ?
                new ObjectParameter("EntityID", entityID) :
                new ObjectParameter("EntityID", typeof(int));
    
            var itemIDParameter = itemID.HasValue ?
                new ObjectParameter("ItemID", itemID) :
                new ObjectParameter("ItemID", typeof(long));
    
            var unreadOnlyParameter = unreadOnly.HasValue ?
                new ObjectParameter("UnreadOnly", unreadOnly) :
                new ObjectParameter("UnreadOnly", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_Notifications>("Pr_NotificationSearch", mergeOption, userIDParameter, entityIDParameter, itemIDParameter, unreadOnlyParameter);
        }
    }
}