//------------------------------------------------------------------------------
// <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.Performance.Entities
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class PerformanceContext : DbContext
    {
        public PerformanceContext()
            : base("name=PerformanceContext")
        {
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
    
        public virtual int Pr_PerformanceHistoryCreate(Nullable<long> performanceMeasureID, Nullable<long> userID, Nullable<int> entityID, Nullable<long> itemID, Nullable<bool> allowDuplicate, Nullable<long> createdByID)
        {
            var performanceMeasureIDParameter = performanceMeasureID.HasValue ?
                new ObjectParameter("PerformanceMeasureID", performanceMeasureID) :
                new ObjectParameter("PerformanceMeasureID", typeof(long));
    
            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 allowDuplicateParameter = allowDuplicate.HasValue ?
                new ObjectParameter("AllowDuplicate", allowDuplicate) :
                new ObjectParameter("AllowDuplicate", typeof(bool));
    
            var createdByIDParameter = createdByID.HasValue ?
                new ObjectParameter("CreatedByID", createdByID) :
                new ObjectParameter("CreatedByID", typeof(long));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Pr_PerformanceHistoryCreate", performanceMeasureIDParameter, userIDParameter, entityIDParameter, itemIDParameter, allowDuplicateParameter, createdByIDParameter);
        }
    
        public virtual ObjectResult<Pr_PerformanceStatisticsGet_Result> Pr_PerformanceStatisticsGet(Nullable<long> userID, Nullable<long> roleID, string groupBy, Nullable<System.DateTime> dateFrom, Nullable<System.DateTime> dateTo)
        {
            var userIDParameter = userID.HasValue ?
                new ObjectParameter("UserID", userID) :
                new ObjectParameter("UserID", typeof(long));
    
            var roleIDParameter = roleID.HasValue ?
                new ObjectParameter("RoleID", roleID) :
                new ObjectParameter("RoleID", typeof(long));
    
            var groupByParameter = groupBy != null ?
                new ObjectParameter("GroupBy", groupBy) :
                new ObjectParameter("GroupBy", typeof(string));
    
            var dateFromParameter = dateFrom.HasValue ?
                new ObjectParameter("DateFrom", dateFrom) :
                new ObjectParameter("DateFrom", typeof(System.DateTime));
    
            var dateToParameter = dateTo.HasValue ?
                new ObjectParameter("DateTo", dateTo) :
                new ObjectParameter("DateTo", typeof(System.DateTime));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Pr_PerformanceStatisticsGet_Result>("Pr_PerformanceStatisticsGet", userIDParameter, roleIDParameter, groupByParameter, dateFromParameter, dateToParameter);
        }
    }
}