//------------------------------------------------------------------------------
// <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 EnVisage
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class EnVisageEntities : DbContext
    {
        public EnVisageEntities()
            : base("name=EnVisageEntities")
        {
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<Contact> Contacts { get; set; }
        public virtual DbSet<Contact2Project> Contact2Project { get; set; }
        public virtual DbSet<History> Histories { get; set; }
        public virtual DbSet<Company> Companies { get; set; }
        public virtual DbSet<AspNetRole> AspNetRoles { get; set; }
        public virtual DbSet<ProjectAccess> ProjectAccesses { get; set; }
        public virtual DbSet<CreditDepartment> CreditDepartments { get; set; }
        public virtual DbSet<UOM> UOMs { get; set; }
        public virtual DbSet<FiscalCalendar> FiscalCalendars { get; set; }
        public virtual DbSet<SystemSetting> SystemSettings { get; set; }
        public virtual DbSet<Expenditure> Expenditures { get; set; }
        public virtual DbSet<ExpenditureCategory> ExpenditureCategory { get; set; }
        public virtual DbSet<SystemAttribute> SystemAttributes { get; set; }
        public virtual DbSet<Expenditure2Expenditure> Expenditure2Expenditure { get; set; }
        public virtual DbSet<FeeCalculation> FeeCalculation { get; set; }
        public virtual DbSet<Security> Securities { get; set; }
        public virtual DbSet<VW_ExpCategoriesInScenario> VW_ExpCategoriesInScenario { get; set; }
        public virtual DbSet<VW_Expenditure2Category> VW_Expenditure2Category { get; set; }
        public virtual DbSet<VW_Expenditure2Calculation> VW_Expenditure2Calculation { get; set; }
        public virtual DbSet<VW_ScenarioAndProxyDetails> VW_ScenarioAndProxyDetails { get; set; }
        public virtual DbSet<VW_Expenditure2FeeCalculation> VW_Expenditure2FeeCalculation { get; set; }
        public virtual DbSet<Rate> Rates { get; set; }
        public virtual DbSet<Company2Client> Company2Client { get; set; }
        public virtual DbSet<ScenarioDetail> ScenarioDetail { get; set; }
        public virtual DbSet<Scenario2Group> Scenario2Group { get; set; }
        public virtual DbSet<Scenario> Scenarios { get; set; }
        public virtual DbSet<Team2Project> Team2Project { get; set; }
        public virtual DbSet<PeopleResourceVacation> PeopleResourceVacations { get; set; }
        public virtual DbSet<PeopleResourceAllocation> PeopleResourceAllocations { get; set; }
        public virtual DbSet<GLAccount> GLAccounts { get; set; }
        public virtual DbSet<PasswordResetRequest> PasswordResetRequests { get; set; }
        public virtual DbSet<Client> Clients { get; set; }
        public virtual DbSet<User2Team> User2Team { get; set; }
        public virtual DbSet<Type2TypeGroup> Type2TypeGroup { get; set; }
        public virtual DbSet<TypeGroup> TypeGroups { get; set; }
        public virtual DbSet<User2View> User2View { get; set; }
        public virtual DbSet<View> Views { get; set; }
        public virtual DbSet<TemplateGroup> TemplateGroups { get; set; }
        public virtual DbSet<Template2TemplateGroup> Template2TemplateGroup { get; set; }
        public virtual DbSet<Team> Teams { get; set; }
        public virtual DbSet<TeamAllocation> TeamAllocations { get; set; }
        public virtual DbSet<VW_ScenarioPerformance> VW_ScenarioPerformance { get; set; }
        public virtual DbSet<UserPreference> UserPreferences { get; set; }
        public virtual DbSet<BLL_Objects> BLL_Objects { get; set; }
        public virtual DbSet<supt_tbl_ProjectIds> supt_tbl_ProjectIds { get; set; }
        public virtual DbSet<supt_tbl_RecParser> supt_tbl_RecParser { get; set; }
        public virtual DbSet<UserQuickLink> UserQuickLinks { get; set; }
        public virtual DbSet<StrategicGoal> StrategicGoals { get; set; }
        public virtual DbSet<StrategicGoal2Company> StrategicGoal2Company { get; set; }
        public virtual DbSet<StrategicGoal2Project> StrategicGoal2Project { get; set; }
        public virtual DbSet<CostSaving> CostSavings { get; set; }
        public virtual DbSet<supt_tbl_MongoDBBackup> supt_tbl_MongoDBBackup { get; set; }
        public virtual DbSet<GLAccountClientsCount> GLAccountClientsCounts { get; set; }
        public virtual DbSet<GLAccountExpCatsCount> GLAccountExpCatsCounts { get; set; }
        public virtual DbSet<FiscalCalendarSetting> FiscalCalendarSettings { get; set; }
        public virtual DbSet<NotificationControl> NotificationControls { get; set; }
        public virtual DbSet<Skill> Skills { get; set; }
        public virtual DbSet<supt_ImportMessages> supt_ImportMessages { get; set; }
        public virtual DbSet<Vacation> Vacations { get; set; }
        public virtual DbSet<WorkWeek> WorkWeeks { get; set; }
        public virtual DbSet<PeopleResourceActual> PeopleResourceActuals { get; set; }
        public virtual DbSet<Skill2Resource> Skill2Resource { get; set; }
        public virtual DbSet<VW_Skill2Resource> VW_Skill2Resource { get; set; }
        public virtual DbSet<NonProjectTimeCategory> NonProjectTimeCategories { get; set; }
        public virtual DbSet<Holiday2ExpenditureCategory> Holiday2ExpenditureCategory { get; set; }
        public virtual DbSet<Holiday2PeopleResource> Holiday2PeopleResource { get; set; }
        public virtual DbSet<Holiday2Team> Holiday2Team { get; set; }
        public virtual DbSet<Holiday> Holidays { get; set; }
        public virtual DbSet<HolidayAllocation> HolidayAllocations { get; set; }
        public virtual DbSet<NonProjectTime> NonProjectTimes { get; set; }
        public virtual DbSet<VW_HolidayAllocation> VW_HolidayAllocation { get; set; }
        public virtual DbSet<VW_Holiday> VW_Holiday { get; set; }
        public virtual DbSet<VW_PlanningCapacityAdjusted> VW_PlanningCapacityAdjusted { get; set; }
        public virtual DbSet<PeopleResource2Team> PeopleResource2Team { get; set; }
        public virtual DbSet<VW_TeamResource> VW_TeamResource { get; set; }
        public virtual DbSet<PeopleResource> PeopleResources { get; set; }
        public virtual DbSet<VW_ExpendituresWithAdjustmentFactor> VW_ExpendituresWithAdjustmentFactor { get; set; }
        public virtual DbSet<NonProjectTime2Resource> NonProjectTime2Resource { get; set; }
        public virtual DbSet<VW_NonProjectTimeAllocation> VW_NonProjectTimeAllocation { get; set; }
        public virtual DbSet<NonProjectTimeResourceAllocation> NonProjectTimeResourceAllocations { get; set; }
        public virtual DbSet<NonProjectTime2Team> NonProjectTime2Team { get; set; }
        public virtual DbSet<NonProjectTimeTeamAllocation> NonProjectTimeTeamAllocations { get; set; }
        public virtual DbSet<VW_ActualCapacityAdjustmentByExpCats> VW_ActualCapacityAdjustmentByExpCats { get; set; }
        public virtual DbSet<VW_ActualCapacityAdjusted> VW_ActualCapacityAdjusted { get; set; }
        public virtual DbSet<VW_ActualCapacityByTeamsAdjusted> VW_ActualCapacityByTeamsAdjusted { get; set; }
        public virtual DbSet<VW_ActualCapacityByTeamsDirect> VW_ActualCapacityByTeamsDirect { get; set; }
        public virtual DbSet<VW_ActualCapacityDirect> VW_ActualCapacityDirect { get; set; }
        public virtual DbSet<VW_NonProjectTimeInvalidItems> VW_NonProjectTimeInvalidItems { get; set; }
        public virtual DbSet<Tag> Tags { get; set; }
        public virtual DbSet<TagGroup> TagGroups { get; set; }
        public virtual DbSet<TagLink> TagLinks { get; set; }
        public virtual DbSet<User2Company> User2Company { get; set; }
        public virtual DbSet<VW_ProjectNeedUnassigned> VW_ProjectNeedUnassigned { get; set; }
        public virtual DbSet<VW_User2Company> VW_User2Company { get; set; }
        public virtual DbSet<VW_User2Company4Display> VW_User2Company4Display { get; set; }
        public virtual DbSet<Company2View> Company2View { get; set; }
        public virtual DbSet<Team2View> Team2View { get; set; }
        public virtual DbSet<Note> Notes { get; set; }
        public virtual DbSet<UserDefinedField> UserDefinedFields { get; set; }
        public virtual DbSet<UserDefinedValue> UserDefinedValues { get; set; }
        public virtual DbSet<VW_Company2View> VW_Company2View { get; set; }
        public virtual DbSet<VW_Team2View> VW_Team2View { get; set; }
        public virtual DbSet<VW_ProjectPerformance> VW_ProjectPerformance { get; set; }
        public virtual DbSet<VW_Scenario2Project> VW_Scenario2Project { get; set; }
        public virtual DbSet<Project> Projects { get; set; }
        public virtual DbSet<WorkflowGlobalParameter> WorkflowGlobalParameters { get; set; }
        public virtual DbSet<WorkflowInbox> WorkflowInboxes { get; set; }
        public virtual DbSet<WorkflowProcessInstance> WorkflowProcessInstances { get; set; }
        public virtual DbSet<WorkflowProcessInstancePersistence> WorkflowProcessInstancePersistences { get; set; }
        public virtual DbSet<WorkflowProcessInstanceStatu> WorkflowProcessInstanceStatus { get; set; }
        public virtual DbSet<WorkflowProcessScheme> WorkflowProcessSchemes { get; set; }
        public virtual DbSet<WorkflowProcessTimer> WorkflowProcessTimers { get; set; }
        public virtual DbSet<WorkflowScheme> WorkflowSchemes { get; set; }
        public virtual DbSet<VW_WorkflowModelView> VW_WorkflowModelView { get; set; }
        public virtual DbSet<IntegrationConnectionInfo> IntegrationConnectionInfoes { get; set; }
        public virtual DbSet<Type2WorkFlowScheme> Type2WorkFlowScheme { get; set; }
        public virtual DbSet<WorkFlowRole> WorkFlowRoles { get; set; }
        public virtual DbSet<VW_WorkflowRoleModelView> VW_WorkflowRoleModelView { get; set; }
        public virtual DbSet<User2WorkFlowRole> User2WorkFlowRole { get; set; }
        public virtual DbSet<Integration2Prevu> Integration2Prevu { get; set; }
        public virtual DbSet<VW_ProjectTeamsResourceAllocated> VW_ProjectTeamsResourceAllocated { get; set; }
        public virtual DbSet<EmailRouting> EmailRoutings { get; set; }
        public virtual DbSet<EmailTemplate> EmailTemplates { get; set; }
        public virtual DbSet<VW_PeopleResourceAllocationsInfo> VW_PeopleResourceAllocationsInfo { get; set; }
        public virtual DbSet<PeopleResourceExpCatChange> PeopleResourceExpCatChanges { get; set; }
        public virtual DbSet<Attachment> Attachments { get; set; }
        public virtual DbSet<WorkFlowEmailStore> WorkFlowEmailStores { get; set; }
        public virtual DbSet<WorkFlowEmailStoreLink> WorkFlowEmailStoreLinks { get; set; }
        public virtual DbSet<vw_User2WorkFlowRoles> vw_User2WorkFlowRoles { get; set; }
        public virtual DbSet<vw_User2Team2WorkflowRoleContactInfo> vw_User2Team2WorkflowRoleContactInfo { get; set; }
        public virtual DbSet<Status> Status { get; set; }
        public virtual DbSet<Type> Types { get; set; }
        public virtual DbSet<Notification> Notifications { get; set; }
        public virtual DbSet<ProjectDependency> ProjectDependencies { get; set; }
        public virtual DbSet<VW_ProjectDependencies> VW_ProjectDependencies { get; set; }
        public virtual DbSet<VW_ExpenditureCategory> VW_ExpenditureCategory { get; set; }
        public virtual DbSet<VW_ProjectAccessByUserExtended> VW_ProjectAccessByUserExtended { get; set; }
        public virtual DbSet<VW_User2Team> VW_User2Team { get; set; }
        public virtual DbSet<WorkFlowContact> WorkFlowContacts { get; set; }
        public virtual DbSet<WorkFlowParallelApproval> WorkFlowParallelApprovals { get; set; }
        public virtual DbSet<MenuNavigation> MenuNavigations { get; set; }
        public virtual DbSet<NotificationToWorkFlowState> NotificationToWorkFlowStates { get; set; }
        public virtual DbSet<AspNetUser> AspNetUsers { get; set; }
        public virtual DbSet<AspNetUserClaim> AspNetUserClaims { get; set; }
        public virtual DbSet<vw_WorkflowApprovalHistoryInfo> vw_WorkflowApprovalHistoryInfo { get; set; }
    
        [DbFunction("EnVisageEntities", "resourceAvailability_f")]
        public virtual IQueryable<resourceAvailability_f_Result> resourceAvailability_f(Nullable<System.DateTime> startDate, Nullable<System.DateTime> endDate, string per, Nullable<double> availableHours, Nullable<bool> disregardNPTime)
        {
            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));
    
            var perParameter = per != null ?
                new ObjectParameter("Per", per) :
                new ObjectParameter("Per", typeof(string));
    
            var availableHoursParameter = availableHours.HasValue ?
                new ObjectParameter("AvailableHours", availableHours) :
                new ObjectParameter("AvailableHours", typeof(double));
    
            var disregardNPTimeParameter = disregardNPTime.HasValue ?
                new ObjectParameter("DisregardNPTime", disregardNPTime) :
                new ObjectParameter("DisregardNPTime", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.CreateQuery<resourceAvailability_f_Result>("[EnVisageEntities].[resourceAvailability_f](@StartDate, @EndDate, @Per, @AvailableHours, @DisregardNPTime)", startDateParameter, endDateParameter, perParameter, availableHoursParameter, disregardNPTimeParameter);
        }
    
        public virtual int DropWorkflowInbox(Nullable<System.Guid> processId)
        {
            var processIdParameter = processId.HasValue ?
                new ObjectParameter("processId", processId) :
                new ObjectParameter("processId", typeof(System.Guid));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("DropWorkflowInbox", processIdParameter);
        }
    
        public virtual int DropWorkflowProcess(Nullable<System.Guid> id)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("id", id) :
                new ObjectParameter("id", typeof(System.Guid));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("DropWorkflowProcess", idParameter);
        }
    
        public virtual int DropWorkflowProcesses()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("DropWorkflowProcesses");
        }
    
        public virtual ObjectResult<VW_ProjectAccessByUserExtended> sp_ProjectSearch(Nullable<System.Guid> userId, string searchString, Nullable<int> offset, Nullable<int> pageSize, string orderBy, Nullable<bool> orderAsc, ObjectParameter totalCount)
        {
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(System.Guid));
    
            var searchStringParameter = searchString != null ?
                new ObjectParameter("searchString", searchString) :
                new ObjectParameter("searchString", typeof(string));
    
            var offsetParameter = offset.HasValue ?
                new ObjectParameter("offset", offset) :
                new ObjectParameter("offset", typeof(int));
    
            var pageSizeParameter = pageSize.HasValue ?
                new ObjectParameter("pageSize", pageSize) :
                new ObjectParameter("pageSize", typeof(int));
    
            var orderByParameter = orderBy != null ?
                new ObjectParameter("orderBy", orderBy) :
                new ObjectParameter("orderBy", typeof(string));
    
            var orderAscParameter = orderAsc.HasValue ?
                new ObjectParameter("orderAsc", orderAsc) :
                new ObjectParameter("orderAsc", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<VW_ProjectAccessByUserExtended>("sp_ProjectSearch", userIdParameter, searchStringParameter, offsetParameter, pageSizeParameter, orderByParameter, orderAscParameter, totalCount);
        }
    
        public virtual ObjectResult<VW_ProjectAccessByUserExtended> sp_ProjectSearch(Nullable<System.Guid> userId, string searchString, Nullable<int> offset, Nullable<int> pageSize, string orderBy, Nullable<bool> orderAsc, ObjectParameter totalCount, MergeOption mergeOption)
        {
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(System.Guid));
    
            var searchStringParameter = searchString != null ?
                new ObjectParameter("searchString", searchString) :
                new ObjectParameter("searchString", typeof(string));
    
            var offsetParameter = offset.HasValue ?
                new ObjectParameter("offset", offset) :
                new ObjectParameter("offset", typeof(int));
    
            var pageSizeParameter = pageSize.HasValue ?
                new ObjectParameter("pageSize", pageSize) :
                new ObjectParameter("pageSize", typeof(int));
    
            var orderByParameter = orderBy != null ?
                new ObjectParameter("orderBy", orderBy) :
                new ObjectParameter("orderBy", typeof(string));
    
            var orderAscParameter = orderAsc.HasValue ?
                new ObjectParameter("orderAsc", orderAsc) :
                new ObjectParameter("orderAsc", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<VW_ProjectAccessByUserExtended>("sp_ProjectSearch", mergeOption, userIdParameter, searchStringParameter, offsetParameter, pageSizeParameter, orderByParameter, orderAscParameter, totalCount);
        }
    }
}