//------------------------------------------------------------------------------
// <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.Queries.Entities
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class QueriesContext : DbContext
    {
        public QueriesContext()
            : base("name=QueriesContext")
        {
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        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 DbSet<Vw_Queries> Vw_Queries { get; set; }
    
        public virtual ObjectResult<Nullable<long>> Pr_QueryCreate(Nullable<short> queryTypeID, Nullable<short> querySourceID, Nullable<int> entityID, Nullable<long> itemID, Nullable<short> assignedToUserRoleID, Nullable<long> assignedToUserID, Nullable<System.DateTime> assignedToUserDate, string description, string responseEmailAddresses, string responseContactNumbers, string queryByUserName)
        {
            var queryTypeIDParameter = queryTypeID.HasValue ?
                new ObjectParameter("QueryTypeID", queryTypeID) :
                new ObjectParameter("QueryTypeID", typeof(short));
    
            var querySourceIDParameter = querySourceID.HasValue ?
                new ObjectParameter("QuerySourceID", querySourceID) :
                new ObjectParameter("QuerySourceID", typeof(short));
    
            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 assignedToUserRoleIDParameter = assignedToUserRoleID.HasValue ?
                new ObjectParameter("AssignedToUserRoleID", assignedToUserRoleID) :
                new ObjectParameter("AssignedToUserRoleID", typeof(short));
    
            var assignedToUserIDParameter = assignedToUserID.HasValue ?
                new ObjectParameter("AssignedToUserID", assignedToUserID) :
                new ObjectParameter("AssignedToUserID", typeof(long));
    
            var assignedToUserDateParameter = assignedToUserDate.HasValue ?
                new ObjectParameter("AssignedToUserDate", assignedToUserDate) :
                new ObjectParameter("AssignedToUserDate", typeof(System.DateTime));
    
            var descriptionParameter = description != null ?
                new ObjectParameter("Description", description) :
                new ObjectParameter("Description", typeof(string));
    
            var responseEmailAddressesParameter = responseEmailAddresses != null ?
                new ObjectParameter("ResponseEmailAddresses", responseEmailAddresses) :
                new ObjectParameter("ResponseEmailAddresses", typeof(string));
    
            var responseContactNumbersParameter = responseContactNumbers != null ?
                new ObjectParameter("ResponseContactNumbers", responseContactNumbers) :
                new ObjectParameter("ResponseContactNumbers", typeof(string));
    
            var queryByUserNameParameter = queryByUserName != null ?
                new ObjectParameter("QueryByUserName", queryByUserName) :
                new ObjectParameter("QueryByUserName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<long>>("Pr_QueryCreate", queryTypeIDParameter, querySourceIDParameter, entityIDParameter, itemIDParameter, assignedToUserRoleIDParameter, assignedToUserIDParameter, assignedToUserDateParameter, descriptionParameter, responseEmailAddressesParameter, responseContactNumbersParameter, queryByUserNameParameter);
        }
    
        public virtual ObjectResult<Nullable<bool>> Pr_QueryDelete(Nullable<long> queryID, string queryByUserName)
        {
            var queryIDParameter = queryID.HasValue ?
                new ObjectParameter("QueryID", queryID) :
                new ObjectParameter("QueryID", typeof(long));
    
            var queryByUserNameParameter = queryByUserName != null ?
                new ObjectParameter("QueryByUserName", queryByUserName) :
                new ObjectParameter("QueryByUserName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<bool>>("Pr_QueryDelete", queryIDParameter, queryByUserNameParameter);
        }
    
        public virtual ObjectResult<Nullable<bool>> Pr_QueryUpdate(Nullable<long> queryID, Nullable<short> queryTypeID, Nullable<short> querySourceID, Nullable<short> assignedToUserRoleID, Nullable<long> assignedToUserID, Nullable<System.DateTime> assignedToUserDate, string description, string responseEmailAddresses, string responseContactNumbers, string queryByUserName)
        {
            var queryIDParameter = queryID.HasValue ?
                new ObjectParameter("QueryID", queryID) :
                new ObjectParameter("QueryID", typeof(long));
    
            var queryTypeIDParameter = queryTypeID.HasValue ?
                new ObjectParameter("QueryTypeID", queryTypeID) :
                new ObjectParameter("QueryTypeID", typeof(short));
    
            var querySourceIDParameter = querySourceID.HasValue ?
                new ObjectParameter("QuerySourceID", querySourceID) :
                new ObjectParameter("QuerySourceID", typeof(short));
    
            var assignedToUserRoleIDParameter = assignedToUserRoleID.HasValue ?
                new ObjectParameter("AssignedToUserRoleID", assignedToUserRoleID) :
                new ObjectParameter("AssignedToUserRoleID", typeof(short));
    
            var assignedToUserIDParameter = assignedToUserID.HasValue ?
                new ObjectParameter("AssignedToUserID", assignedToUserID) :
                new ObjectParameter("AssignedToUserID", typeof(long));
    
            var assignedToUserDateParameter = assignedToUserDate.HasValue ?
                new ObjectParameter("AssignedToUserDate", assignedToUserDate) :
                new ObjectParameter("AssignedToUserDate", typeof(System.DateTime));
    
            var descriptionParameter = description != null ?
                new ObjectParameter("Description", description) :
                new ObjectParameter("Description", typeof(string));
    
            var responseEmailAddressesParameter = responseEmailAddresses != null ?
                new ObjectParameter("ResponseEmailAddresses", responseEmailAddresses) :
                new ObjectParameter("ResponseEmailAddresses", typeof(string));
    
            var responseContactNumbersParameter = responseContactNumbers != null ?
                new ObjectParameter("ResponseContactNumbers", responseContactNumbers) :
                new ObjectParameter("ResponseContactNumbers", typeof(string));
    
            var queryByUserNameParameter = queryByUserName != null ?
                new ObjectParameter("QueryByUserName", queryByUserName) :
                new ObjectParameter("QueryByUserName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<bool>>("Pr_QueryUpdate", queryIDParameter, queryTypeIDParameter, querySourceIDParameter, assignedToUserRoleIDParameter, assignedToUserIDParameter, assignedToUserDateParameter, descriptionParameter, responseEmailAddressesParameter, responseContactNumbersParameter, queryByUserNameParameter);
        }
    
        public virtual ObjectResult<Nullable<bool>> Pr_QueryUpdateStatus(Nullable<long> queryID, Nullable<short> queryStatusID, string queryByUserName)
        {
            var queryIDParameter = queryID.HasValue ?
                new ObjectParameter("QueryID", queryID) :
                new ObjectParameter("QueryID", typeof(long));
    
            var queryStatusIDParameter = queryStatusID.HasValue ?
                new ObjectParameter("QueryStatusID", queryStatusID) :
                new ObjectParameter("QueryStatusID", typeof(short));
    
            var queryByUserNameParameter = queryByUserName != null ?
                new ObjectParameter("QueryByUserName", queryByUserName) :
                new ObjectParameter("QueryByUserName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<bool>>("Pr_QueryUpdateStatus", queryIDParameter, queryStatusIDParameter, queryByUserNameParameter);
        }
    
        public virtual ObjectResult<Vw_Queries> Pr_QuerySearch(Nullable<long> entityID, Nullable<long> itemID, string queryStatusID, string assignedToUserRoleID, string assignedToUserID)
        {
            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 queryStatusIDParameter = queryStatusID != null ?
                new ObjectParameter("QueryStatusID", queryStatusID) :
                new ObjectParameter("QueryStatusID", typeof(string));
    
            var assignedToUserRoleIDParameter = assignedToUserRoleID != null ?
                new ObjectParameter("AssignedToUserRoleID", assignedToUserRoleID) :
                new ObjectParameter("AssignedToUserRoleID", typeof(string));
    
            var assignedToUserIDParameter = assignedToUserID != null ?
                new ObjectParameter("AssignedToUserID", assignedToUserID) :
                new ObjectParameter("AssignedToUserID", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_Queries>("Pr_QuerySearch", entityIDParameter, itemIDParameter, queryStatusIDParameter, assignedToUserRoleIDParameter, assignedToUserIDParameter);
        }
    
        public virtual ObjectResult<Vw_Queries> Pr_QuerySearch(Nullable<long> entityID, Nullable<long> itemID, string queryStatusID, string assignedToUserRoleID, string assignedToUserID, MergeOption mergeOption)
        {
            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 queryStatusIDParameter = queryStatusID != null ?
                new ObjectParameter("QueryStatusID", queryStatusID) :
                new ObjectParameter("QueryStatusID", typeof(string));
    
            var assignedToUserRoleIDParameter = assignedToUserRoleID != null ?
                new ObjectParameter("AssignedToUserRoleID", assignedToUserRoleID) :
                new ObjectParameter("AssignedToUserRoleID", typeof(string));
    
            var assignedToUserIDParameter = assignedToUserID != null ?
                new ObjectParameter("AssignedToUserID", assignedToUserID) :
                new ObjectParameter("AssignedToUserID", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Vw_Queries>("Pr_QuerySearch", mergeOption, entityIDParameter, itemIDParameter, queryStatusIDParameter, assignedToUserRoleIDParameter, assignedToUserIDParameter);
        }
    }
}