//------------------------------------------------------------------------------
// <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.Admin.Crm
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class AfxAdminCrmContext : DbContext
    {
        public AfxAdminCrmContext()
            : base("name=AfxAdminCrmContext")
        {
            this.Configuration.LazyLoadingEnabled = false;
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<Comment> Comments { get; set; }
        public virtual DbSet<Message> Messages { get; set; }
        public virtual DbSet<MessageTemplate> MessageTemplates { get; set; }
        public virtual DbSet<MessageType> MessageTypes { get; set; }
        public virtual DbSet<Query> Queries { get; set; }
        public virtual DbSet<QuerySource> QuerySources { get; set; }
        public virtual DbSet<QueryStatus> QueryStatus { get; set; }
        public virtual DbSet<QueryType> QueryTypes { get; set; }
    
        public virtual ObjectResult<MessageTemplateSqlTest> Pr_MessageTemplateSqlTester(Nullable<long> messageTemplateID)
        {
            var messageTemplateIDParameter = messageTemplateID.HasValue ?
                new ObjectParameter("MessageTemplateID", messageTemplateID) :
                new ObjectParameter("MessageTemplateID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<MessageTemplateSqlTest>("Pr_MessageTemplateSqlTester", messageTemplateIDParameter);
        }
    
        public virtual ObjectResult<MessageTemplate> Pr_MessageTemplateTester(Nullable<short> entityID, Nullable<long> itemID, Nullable<long> messageTemplateID)
        {
            var entityIDParameter = entityID.HasValue ?
                new ObjectParameter("EntityID", entityID) :
                new ObjectParameter("EntityID", typeof(short));
    
            var itemIDParameter = itemID.HasValue ?
                new ObjectParameter("ItemID", itemID) :
                new ObjectParameter("ItemID", typeof(long));
    
            var messageTemplateIDParameter = messageTemplateID.HasValue ?
                new ObjectParameter("MessageTemplateID", messageTemplateID) :
                new ObjectParameter("MessageTemplateID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<MessageTemplate>("Pr_MessageTemplateTester", entityIDParameter, itemIDParameter, messageTemplateIDParameter);
        }
    
        public virtual ObjectResult<MessageTemplate> Pr_MessageTemplateTester(Nullable<short> entityID, Nullable<long> itemID, Nullable<long> messageTemplateID, MergeOption mergeOption)
        {
            var entityIDParameter = entityID.HasValue ?
                new ObjectParameter("EntityID", entityID) :
                new ObjectParameter("EntityID", typeof(short));
    
            var itemIDParameter = itemID.HasValue ?
                new ObjectParameter("ItemID", itemID) :
                new ObjectParameter("ItemID", typeof(long));
    
            var messageTemplateIDParameter = messageTemplateID.HasValue ?
                new ObjectParameter("MessageTemplateID", messageTemplateID) :
                new ObjectParameter("MessageTemplateID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<MessageTemplate>("Pr_MessageTemplateTester", mergeOption, entityIDParameter, itemIDParameter, messageTemplateIDParameter);
        }
    
        public virtual ObjectResult<Pr_MessageSearch_Result> Pr_MessageSearch(Nullable<int> entityID, Nullable<long> itemID, string sender, string recipients, Nullable<bool> isHtml, Nullable<System.DateTime> startDate, Nullable<System.DateTime> endDate)
        {
            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 senderParameter = sender != null ?
                new ObjectParameter("Sender", sender) :
                new ObjectParameter("Sender", typeof(string));
    
            var recipientsParameter = recipients != null ?
                new ObjectParameter("Recipients", recipients) :
                new ObjectParameter("Recipients", typeof(string));
    
            var isHtmlParameter = isHtml.HasValue ?
                new ObjectParameter("IsHtml", isHtml) :
                new ObjectParameter("IsHtml", typeof(bool));
    
            var startDateParameter = startDate.HasValue ?
                new ObjectParameter("StartDate", startDate) :
                new ObjectParameter("StartDate", typeof(System.DateTime));
    
            var endDateParameter = endDate.HasValue ?
                new ObjectParameter("EndDate", endDate) :
                new ObjectParameter("EndDate", typeof(System.DateTime));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_MessageSearch_Result>("Pr_MessageSearch", entityIDParameter, itemIDParameter, senderParameter, recipientsParameter, isHtmlParameter, startDateParameter, endDateParameter);
        }
    }
}