using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.Entity;
using System.Data.Entity.Infrastructure;
using System.ComponentModel.DataAnnotations;
using OSS.Models;   

namespace OSS.Models
{
    public class OSSDBContext : DbContext
    {
        public OSSDBContext()
            : base("name=OSSDBConnectionString")
        {
            Configuration.ProxyCreationEnabled = false;
        }
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Sector>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_Sector"))
           .Update(d => d.HasName("Update_Sector")));

            //=======================Sector Creation=================================================

           

             modelBuilder.Entity<District>()
            .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_District"))
            .Update(d => d.HasName("Update_District")));


            //==========================================================Project Profile====================
            modelBuilder.Entity<ProjectProfile>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_ProjectProfile"))
           .Update(d => d.HasName("Update_ProjectProfile")));
            //=======================Steps Management=================================================



            modelBuilder.Entity<StepsManagement>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_StepsManagement"))
           .Update(d => d.HasName("Update_StepsManagement")));

            //=======================Region Creation=================================================
            modelBuilder.Entity<Region>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_Region"))
           .Update(d => d.HasName("Update_Region")));

            //=======================Region Creation=================================================
           
            //==========================================================Investor's Profile====================
            modelBuilder.Entity<CompanyProfileExternal>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_CompanyProfileExternal"))
           .Update(d => d.HasName("Update_CompanyProfileExternal")));

            //==========================================================Company Profile====================
            modelBuilder.Entity<InvestorProfileExternal>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_InvestorProfileExternal"))
           .Update(d => d.HasName("Update_InvestorProfilexternal")));
            //==========================================================Shareholding Profile====================
            modelBuilder.Entity<CompanyShareholderExternal>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_CompanyShareholder"))
           .Update(d => d.HasName("Update_CompanyShareholder")));


            //==========================================================Project Profile====================
            modelBuilder.Entity<ProjectProfileExternal>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_ProjectProfileExternal"))
           .Update(d => d.HasName("Update_ProjectProfileExternal")));


            //==========================================================Invoice====================
            modelBuilder.Entity<ApplicationManager>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_Application"))
           .Update(d => d.HasName("Update_Application")));

            //==========================================================Financing Profile====================
            modelBuilder.Entity<FinancingProfileExternal>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_FinancialExternal"))
           .Update(d => d.HasName("Update_FinancialExternal")));

            //==========================================================Attachments====================
            modelBuilder.Entity<Attachments>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_Attachments"))
           .Update(d => d.HasName("Update_Attachments")));
            //==========================================================Amendment External====================
            modelBuilder.Entity<CompanyAmmendmentExternal>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_CompanyAmmendmentExternal"))
           .Update(d => d.HasName("Update_CompanyAmmendmentExternal")));

            //========================================================== Deffrement History ====================
            modelBuilder.Entity<DefferementHistory>()
           .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_DefferementHistory"))
           .Update(d => d.HasName("Update_DefferementHistory")));
            //===========================================================Company Amendment=====================
            modelBuilder.Entity<CompanyAmmendment>()
          .MapToStoredProcedures(s => s.Insert(i => i.HasName("Add_CompanyAmmendment"))
          .Update(d => d.HasName("Update_CompanyAmmendment")));
        }
        public virtual DbSet<Sector> Sectors { get; set; }
        public virtual DbSet<CompanyAmmendment> CompanyAmmendments { get; set; }
        public virtual DbSet<ApplicationManager> ApplicationManagers{ get; set; }
        public virtual DbSet<Attachments> AttachmentsList { get; set; }
        public virtual DbSet<CompanyProfileExternal> CompanyProfileExternal { get; set; }
        public virtual DbSet<InvestorProfileExternal> InvestorExternl { get; set; }
        public virtual DbSet<ProjectProfile> ProjectProfiles { get; set; }
        public virtual DbSet<CompanyShareholderExternal> CompanyShareholder { get; set; }
        public virtual DbSet<ProjectProfileExternal> ProjectProfilesExternal { get; set; }
        public virtual DbSet<FinancingProfileExternal> FinancingProfilesExternals { get; set; }
        public virtual DbSet<Region> Regions { get; set; }
        public virtual DbSet<District> Districts { get; set; }
        public virtual DbSet<Country> Countries { get; set; }
        public virtual DbSet<Ward> Wards { get; set; }
        public virtual DbSet<DefferementHistory> DefferementHistorys { get; set; }
        public virtual DbSet<SubSector> SubSectors { get; set; }
        public virtual DbSet<StepsManagement> StepsManagements { get; set; }
        public virtual DbSet<CompanyAmmendmentExternal> CompanyAmmendmentsExternal { get; set; }
        public virtual DbSet<CountryInvestment> CountryInvestments { get; set; }
        public virtual DbSet<COIPrice> COIPrices { get; set; }
        public virtual DbSet<ExchangeRate> ExchangeRates { get; set; }
        public virtual DbSet<ServiceFee> ServiceFees { get; set; }

    }
}