//------------------------------------------------------------------------------
// <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.Correspondence.Entities
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class CorrespondenceContext : DbContext
    {
        public CorrespondenceContext()
            : base("name=CorrespondenceContext")
        {
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<Message> Messages { get; set; }
        public virtual DbSet<MessageType> MessageTypes { get; set; }
        public virtual DbSet<MessageTemplate> MessageTemplates { get; set; }
        public virtual DbSet<MessageUser> MessageUsers { get; set; }
    
        public virtual ObjectResult<Nullable<long>> Pr_MessageCreate(Nullable<int> entityID, Nullable<long> itemID, Nullable<byte> messageTypeID, string recipients, string cC, string bCC, string subject, string message, Nullable<bool> isHtml, string messageByUserName)
        {
            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 messageTypeIDParameter = messageTypeID.HasValue ?
                new ObjectParameter("MessageTypeID", messageTypeID) :
                new ObjectParameter("MessageTypeID", typeof(byte));
    
            var recipientsParameter = recipients != null ?
                new ObjectParameter("Recipients", recipients) :
                new ObjectParameter("Recipients", typeof(string));
    
            var cCParameter = cC != null ?
                new ObjectParameter("CC", cC) :
                new ObjectParameter("CC", typeof(string));
    
            var bCCParameter = bCC != null ?
                new ObjectParameter("BCC", bCC) :
                new ObjectParameter("BCC", typeof(string));
    
            var subjectParameter = subject != null ?
                new ObjectParameter("Subject", subject) :
                new ObjectParameter("Subject", typeof(string));
    
            var messageParameter = message != null ?
                new ObjectParameter("Message", message) :
                new ObjectParameter("Message", typeof(string));
    
            var isHtmlParameter = isHtml.HasValue ?
                new ObjectParameter("IsHtml", isHtml) :
                new ObjectParameter("IsHtml", typeof(bool));
    
            var messageByUserNameParameter = messageByUserName != null ?
                new ObjectParameter("MessageByUserName", messageByUserName) :
                new ObjectParameter("MessageByUserName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_MessageCreate", entityIDParameter, itemIDParameter, messageTypeIDParameter, recipientsParameter, cCParameter, bCCParameter, subjectParameter, messageParameter, isHtmlParameter, messageByUserNameParameter);
        }
    
        public virtual ObjectResult<Nullable<bool>> Pr_MessageDelete(Nullable<long> messageID, string messageByUserName)
        {
            var messageIDParameter = messageID.HasValue ?
                new ObjectParameter("MessageID", messageID) :
                new ObjectParameter("MessageID", typeof(long));
    
            var messageByUserNameParameter = messageByUserName != null ?
                new ObjectParameter("MessageByUserName", messageByUserName) :
                new ObjectParameter("MessageByUserName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<bool>>("Pr_MessageDelete", messageIDParameter, messageByUserNameParameter);
        }
    
        public virtual ObjectResult<Nullable<bool>> Pr_MessageUpdate(Nullable<long> messageID, string recipients, string cC, string bCC, string subject, string message, string messageByUserName)
        {
            var messageIDParameter = messageID.HasValue ?
                new ObjectParameter("MessageID", messageID) :
                new ObjectParameter("MessageID", typeof(long));
    
            var recipientsParameter = recipients != null ?
                new ObjectParameter("Recipients", recipients) :
                new ObjectParameter("Recipients", typeof(string));
    
            var cCParameter = cC != null ?
                new ObjectParameter("CC", cC) :
                new ObjectParameter("CC", typeof(string));
    
            var bCCParameter = bCC != null ?
                new ObjectParameter("BCC", bCC) :
                new ObjectParameter("BCC", typeof(string));
    
            var subjectParameter = subject != null ?
                new ObjectParameter("Subject", subject) :
                new ObjectParameter("Subject", typeof(string));
    
            var messageParameter = message != null ?
                new ObjectParameter("Message", message) :
                new ObjectParameter("Message", typeof(string));
    
            var messageByUserNameParameter = messageByUserName != null ?
                new ObjectParameter("MessageByUserName", messageByUserName) :
                new ObjectParameter("MessageByUserName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<bool>>("Pr_MessageUpdate", messageIDParameter, recipientsParameter, cCParameter, bCCParameter, subjectParameter, messageParameter, messageByUserNameParameter);
        }
    
        public virtual int Pr_MessageCreateAttachment(Nullable<long> messageID, Nullable<long> createdByID, byte[] contentBLOB, string mimeType, Nullable<long> size, string name, string ext)
        {
            var messageIDParameter = messageID.HasValue ?
                new ObjectParameter("MessageID", messageID) :
                new ObjectParameter("MessageID", typeof(long));
    
            var createdByIDParameter = createdByID.HasValue ?
                new ObjectParameter("CreatedByID", createdByID) :
                new ObjectParameter("CreatedByID", typeof(long));
    
            var contentBLOBParameter = contentBLOB != null ?
                new ObjectParameter("ContentBLOB", contentBLOB) :
                new ObjectParameter("ContentBLOB", typeof(byte[]));
    
            var mimeTypeParameter = mimeType != null ?
                new ObjectParameter("MimeType", mimeType) :
                new ObjectParameter("MimeType", typeof(string));
    
            var sizeParameter = size.HasValue ?
                new ObjectParameter("Size", size) :
                new ObjectParameter("Size", typeof(long));
    
            var nameParameter = name != null ?
                new ObjectParameter("Name", name) :
                new ObjectParameter("Name", typeof(string));
    
            var extParameter = ext != null ?
                new ObjectParameter("Ext", ext) :
                new ObjectParameter("Ext", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_MessageCreateAttachment", messageIDParameter, createdByIDParameter, contentBLOBParameter, mimeTypeParameter, sizeParameter, nameParameter, extParameter);
        }
    
        public virtual ObjectResult<string> Pr_EntityRecipientGet(Nullable<short> messageTypeID, Nullable<long> entityID, Nullable<long> itemID, Nullable<long> userID)
        {
            var messageTypeIDParameter = messageTypeID.HasValue ?
                new ObjectParameter("MessageTypeID", messageTypeID) :
                new ObjectParameter("MessageTypeID", typeof(short));
    
            var entityIDParameter = entityID.HasValue ?
                new ObjectParameter("EntityID", entityID) :
                new ObjectParameter("EntityID", typeof(long));
    
            var itemIDParameter = itemID.HasValue ?
                new ObjectParameter("ItemID", itemID) :
                new ObjectParameter("ItemID", typeof(long));
    
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("Pr_EntityRecipientGet", messageTypeIDParameter, entityIDParameter, itemIDParameter, userIDParameter);
        }
    }
}