using Company.Domain.AdminMonthlyOverviewAgg;
using Company.Domain.AndroidApkVersionAgg;
using Company.Domain.AuthorizedBankDetailsAgg;
using Company.Domain.BankAgg;
using Company.Domain.BillAgg;
using Company.Domain.Board;
using Company.Domain.BoardType;
using Company.Domain.ChapterAgg;
using Company.Domain.CheckoutAgg;
using Company.Domain.ClassifiedSalaryAgg;
using Company.Domain.ClientEmployeeWorkshopAgg;
using Company.Domain.Contact2Agg;
using Company.Domain.ContactUsAgg;
using Company.Domain.ContarctingPartyAgg;
using Company.Domain.ContractAgg;
using Company.Domain.ContractingPartyAccountAgg;
using Company.Domain.ContractingPartyBankAccountsAgg;
using Company.Domain.CrossJobAgg;
using Company.Domain.CrossJobGuildAgg;
using Company.Domain.CrossJobItemsAgg;
using Company.Domain.CustomizeCheckoutAgg;
using Company.Domain.CustomizeCheckoutTempAgg;
using Company.Domain.CustomizeWorkshopEmployeeSettingsAgg.Entities;
using Company.Domain.CustomizeWorkshopGroupSettingsAgg.Entities;
using Company.Domain.CustomizeWorkshopSettingsAgg.Entities;
using Company.Domain.DateSalaryAgg;
using Company.Domain.DateSalaryItemAgg;
using Company.Domain.EmployeeAccountAgg;
using Company.Domain.EmployeeAgg;
using Company.Domain.EmployeeAuthorizeTempAgg;
using Company.Domain.EmployeeBankInformationAgg;
using Company.Domain.EmployeeChildrenAgg;
using Company.Domain.EmployeeClientTempAgg;
using Company.Domain.EmployeeComputeOptionsAgg;
using Company.Domain.EmployeeDocumentItemAgg;
using Company.Domain.EmployeeDocumentsAgg;
using Company.Domain.EmployeeInsuranceRecordAgg;
using Company.Domain.EmployeeInsurancListDataAgg;
using Company.Domain.EmployerAccountAgg;
using Company.Domain.empolyerAgg;
using Company.Domain.EvidenceDetail;
using Company.Domain.FileAlert;
using Company.Domain.FileEmployeeAgg;
using Company.Domain.FileEmployerAgg;
using Company.Domain.FileState;
using Company.Domain.FileTiming;
using Company.Domain.FileTitle;
using Company.Domain.FinancialInvoiceAgg;
using Company.Domain.FinancialStatmentAgg;
using Company.Domain.FinancialTransactionAgg;
using Company.Domain.FineAgg;
using Company.Domain.FineSubjectAgg;
using Company.Domain.GroupPlanAgg;
using Company.Domain.GroupPlanJobItemAgg;
using Company.Domain.HolidayAgg;
using Company.Domain.HolidayItemAgg;
using Company.Domain.InstitutionContractAgg;
using Company.Domain.InstitutionContractContactInfoAgg;
using Company.Domain.InstitutionPlanAgg;
using Company.Domain.InsuranceAgg;
using Company.Domain.InsuranceEmployeeInfoAgg;
using Company.Domain.InsuranceJobAndJobsAgg;
using Company.Domain.InsuranceJobItemAgg;
using Company.Domain.InsuranceListAgg;
using Company.Domain.InsuranceWorkshopAgg;
using Company.Domain.InsuranceYearlySalaryAgg;
using Company.Domain.InsurancJobAgg;
using Company.Domain.InsurancWorkshopInfoAgg;
using Company.Domain.JobAgg;
using Company.Domain.LawAgg;
using Company.Domain.LeaveAgg;
using Company.Domain.LeftWorkAgg;
using Company.Domain.LeftWorkInsuranceAgg;
using Company.Domain.LeftWorkTempAgg;
using Company.Domain.LoanAgg.Entities;
using Company.Domain.MandatoryHoursAgg;
using Company.Domain.MasterPenaltyTitle;
using Company.Domain.MasterPetition;
using Company.Domain.MasterWorkHistory;
using Company.Domain.ModuleAgg;
using Company.Domain.ModuleTextManagerAgg;
using Company.Domain.OriginalTitleAgg;
using Company.Domain.PaymentInstrumentAgg;
using Company.Domain.PaymentToEmployeeAgg;
using Company.Domain.PaymentToEmployeeItemAgg;
using Company.Domain.PaymentTransactionAgg;
using Company.Domain.PenaltyTitle;
using Company.Domain.PercentageAgg;
using Company.Domain.PersonnelCodeAgg;
using Company.Domain.Petition;
using Company.Domain.ProceedingSession;
using Company.Domain.RepresentativeAgg;
using Company.Domain.RewardAgg;
using Company.Domain.RollCallAgg;
using Company.Domain.RollCallEmployeeAgg;
using Company.Domain.RollCallEmployeeStatusAgg;
using Company.Domain.RollCallPlanAgg;
using Company.Domain.RollCallServiceAgg;
using Company.Domain.SalaryAidAgg;
using Company.Domain.SmsResultAgg;
using Company.Domain.SubtitleAgg;
using Company.Domain.TaxJobCategoryAgg;
using Company.Domain.TaxLeftWorkCategoryAgg;
using Company.Domain.TaxLeftWorkItemAgg;
using Company.Domain.TemporaryClientRegistrationAgg;
using Company.Domain.TextManagerAgg;
using Company.Domain.WorkHistory;
using Company.Domain.WorkingHoursAgg;
using Company.Domain.WorkingHoursItemsAgg;
using Company.Domain.WorkingHoursTempAgg;
using Company.Domain.WorkingHoursTempItemAgg;
using Company.Domain.WorkshopAccountAgg;
using Company.Domain.WorkshopAgg;
using Company.Domain.WorkshopEmployerAgg;
using Company.Domain.WorkshopPlanAgg;
using Company.Domain.WorkshopPlanEmployeeAgg;
using Company.Domain.WorkshopSubAccountAgg;
using Company.Domain.YearlySalaryAgg;
using Company.Domain.YearlySalaryItemsAgg;
using Company.Domain.YearlysSalaryTitleAgg;
using Company.Domain.CameraBugReportAgg;
using CompanyManagment.EFCore.Mapping;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Conventions;
using Company.Domain.AuthorizedPersonAgg;
using Evidence = Company.Domain.Evidence.Evidence;
using Zone = Company.Domain.ZoneAgg.Zone;

namespace CompanyManagment.EFCore;

public class CompanyContext : DbContext
{
    //-----Text-Manager--------------------------------------
    public DbSet<EntitySubtitle> EntitySubtitles { get; set; }
    public DbSet<EntityChapter> EntityChapters { get; set; }
    public DbSet<EntityOriginalTitle> EntityOriginalTitles { get; set; }
    public DbSet<EntityTextManager> EntityTextManagers { get; set; }
    public DbSet<EntityModule> EntityModules { get; set; }
    public DbSet<EntityModuleTextManager> EntityModuleTextManagers { get; set; }
    public DbSet<EntityBill> EntityBills { get; set; }
    public DbSet<EntityContact> EntityContacts { get; set; }
    //---------Files------------------------------
    public DbSet<Board> Boards { get; set; }
    public DbSet<BoardType> BoardTypes { get; set; }
    public DbSet<Company.Domain.File1.File1> Files { get; set; }
    public DbSet<PenaltyTitle> PenaltyTitles { get; set; }
    public DbSet<Petition> Petitions { get; set; }
    public DbSet<ProceedingSession> ProceedingSessions { get; set; }
    public DbSet<WorkHistory> WorkHistory { get; set; }
    public DbSet<MasterPetition> MasterPetitions { get; set; }
    public DbSet<MasterPenaltyTitle> MasterPenaltyTitles { get; set; }
    public DbSet<MasterWorkHistory> MasterWorkHistories { get; set; }
    public DbSet<Evidence> Evidences { get; set; }
    public DbSet<EvidenceDetail> EvidenceDetails { get; set; }
    public DbSet<FileTitle> FileTitles { get; set; }
    public DbSet<FileTiming> FileTimings { get; set; }
    public DbSet<FileState> FileStates { get; set; }
    public DbSet<FileAlert> FileAlerts { get; set; }
    //-------Task Manager----------------------------
    //public DbSet<Task> Tasks { get; set; }
    //public DbSet<TaskStatus> TaskStatuses { get; set; }
    //public DbSet<TaskTitle> TaskTitles { get; set; }


    //-------Main-Project----------------------------

    #region SmsSettings

    public DbSet<SmsSetting> SmsSettings { get; set; }

    #endregion

    #region Mahan

    //-----------------------------RollCallWorkshopSettings-----------------------------
    public DbSet<CustomizeWorkshopSettings> CustomizeWorkshopSettings { get; set; }
    public DbSet<CustomizeWorkshopGroupSettings> CustomizeWorkshopGroupSettings { get; set; }
    public DbSet<CustomizeWorkshopEmployeeSettings> CustomizeWorkshopEmployeeSettings { get; set; }

    public DbSet<Fine> Fines { get; set; }
    public DbSet<FineSubject> FinesSubject { get; set; }


    public DbSet<Loan> Loans { get; set; }

    public DbSet<SalaryAid> SalaryAids { get; set; }

    public DbSet<Reward> Rewards { get; set; }

    public DbSet<AndroidApkVersion> AndroidApkVersions { get; set; }

    public DbSet<EmployeeClientTemp> EmployeeClientTemps { get; set; }
    public DbSet<LeftWorkTemp> LeftWorkTemps { get; set; }
    public DbSet<ContactUs> ContactUs { get; set; }


    public DbSet<EmployeeAuthorizeTemp> EmployeeAuthorizeTemps { get; set; }
    public DbSet<AdminMonthlyOverview> AdminMonthlyOverviews { get; set; }
    public DbSet<PaymentTransaction> PaymentTransactions { get; set; }

    public DbSet<ContractingPartyBankAccount> ContractingPartyBankAccounts { get; set; }
    
    public DbSet<Law> Laws { get; set; }
    

    public DbSet<PaymentInstrument> PaymentInstruments { get; set; }
    public DbSet<PaymentInstrumentGroup> PaymentInstrumentGroups { get; set; }
    public DbSet<AuthorizedPerson> AuthorizedPersons { get; set; }
    

    public DbSet<InstitutionContractContactInfoTemp> InstitutionContractContactInfoTemps { get; set; }
    
    public DbSet<AuthorizedBankDetails> AuthorizedBankDetails { get; set; }
    
    public DbSet<FinancialInvoice> FinancialInvoices { get; set; }

	#endregion

	#region Pooya

	public DbSet<EmployeeDocumentItem> EmployeeDocumentItems { get; set; }
    public DbSet<EmployeeDocuments> EmployeeDocuments { get; set; }

    public DbSet<WorkshopSubAccount> WorkshopSubAccounts { get; set; }

    public DbSet<Bank> Banks { get; set; }
    public DbSet<EmployeeBankInformation> EmployeeBankInformationSet { get; set; }

    #endregion

    public DbSet<PlanPercentage> PlanPercentages { get; set; }

    #region TemporaryClientRegisteration

    public DbSet<ContractingPartyTemp> ContractingPartyTemps { get; set; }
    public DbSet<WorkshopTemp> WorkshopTemps { get; set; }
    public DbSet<WorkshopServicesTemp> WorkshopServicesTemps { get; set; }
    public DbSet<InstitutionContractTemp> InstitutionContractTemps { get; set; }

    #endregion

    public DbSet<CheckoutWarningMessage> CheckoutWarningMessages { get; set; }

    public DbSet<CustomizeCheckout> CustomizeCheckouts { get; set; }
    public DbSet<CustomizeCheckoutTemp> CustomizeCheckoutTemps { get; set; }
    public DbSet<TaxLeftWorkItem> TaxLeftWorkItems { get; set; }
    public DbSet<TaxLeftWorkCategory> TaxLeftWorkCategories { get; set; }
    public DbSet<TaxJobCategory> TaxJobCategories { get; set; }
    public DbSet<RollCallEmployeeStatus> RollCallEmployeesStatus { get; set; }
    public DbSet<RollCallEmployee> RollCallEmployees { get; set; }
    public DbSet<RollCallPlan> RollCallPlans { get; set; }
    public DbSet<InstitutionPlan> InstitutionPlans { get; set; }
    public DbSet<RollCallService> RollCallServices { get; set; }
    public DbSet<InsuranceYearlySalary> InsuranceYearlySalaries { get; set; }
    public DbSet<RollCall> RollCalls { get; set; }
    public DbSet<EmployeeComputeOptions> EmployeeComputeOptionsSet { get; set; }
    public DbSet<PaymentToEmployeeItem> PaymentToEmployeeItems { get; set; }
    public DbSet<PaymentToEmployee> PaymentToEmployees { get; set; }
    public DbSet<ContractingPartyAccount> ContractingPartyAccounts { get; set; }
    public DbSet<GroupPlanJobItem> GroupPlanJobItems { get; set; }
    public DbSet<GroupPlan> GroupPlans { get; set; }
    public DbSet<WorkshopPlanEmployee> WorkshopPlanEmployees { get; set; }
    public DbSet<WorkshopPlan> WorkshopPlans { get; set; }
    public DbSet<ClassifiedSalary> ClassifiedSalaries { get; set; }

    public DbSet<SmsResult> SmsResults { get; set; }
    public DbSet<FinancialTransaction> FinancialTransactions { get; set; }
    public DbSet<FinancialStatment> FinancialStatments { get; set; }
    public DbSet<ClientEmployeeWorkshop> ClientEmployeeWorkshops { get; set; }
    public DbSet<EmployerAccount> EmployerAccounts { get; set; }
    public DbSet<EmployeeAccount> EmployeeAccounts { get; set; }
    public DbSet<WorkingHoursTempItem> WorkingHoursTempItems { get; set; }
    public DbSet<WorkingHoursTemp> WorkingHoursTemps { get; set; }
    public DbSet<Zone> ZoneSet { get; set; }
    public DbSet<PersonnelCodeDomain> PersonnelCodeSet { get; set; }
    public DbSet<LeftWorkInsurance> LeftWorkInsuranceList { get; set; }
    public DbSet<EmployeeInsurancListData> EmployeeInsurancListDataSet { get; set; }
    public DbSet<InsuranceEmployeeInfo> InsuranceEmployeeInformationSet { get; set; }
    public DbSet<InsuranceWorkshopInfo> InsuranceWorkshopInformationSet { get; set; }
    public DbSet<InsuranceListWorkshop> InsuranceListWorkshopSet { get; set; }
    public DbSet<InsuranceList> InsuranceListSet { get; set; }

    public DbSet<DateSalary> DateSalaries { get; set; }
    public DbSet<DateSalaryItem> DateSalaryItems { get; set; }
        
    public DbSet<Percentage> Percentages { get; set; }
    public DbSet<InsuranceJobItem> InsuranceJobItems { get; set; }
    public DbSet<InsuranceJob> InsuranceJobs { get; set; }
    public DbSet<InsuranceJobAndJobs> InsuranceJobAndJobsSet { get; set; }
    public DbSet<InstitutionContractContactInfo> InstitutionContractContactInfos { get; set; }
    public DbSet<InstitutionContract> InstitutionContractSet { get; set; }
    public DbSet<InstitutionContractWorkshopGroup> InstitutionContractWorkshopGroups { get; set; }
    public DbSet<InstitutionContractWorkshopInitial> InstitutionContractWorkshopInitials { get; set; }
    public DbSet<InstitutionContractWorkshopCurrent> InstitutionContractWorkshopCurrents { get; set; }
    public DbSet<FileEmployer> FileEmployerSet { get; set; }
    public DbSet<FileEmployee> FileEmployeeSet { get; set; }
    public DbSet<Representative> RepresentativeSet { get; set; }
    public DbSet<Checkout> CheckoutSet { get; set; }
    public DbSet<Leave> LeaveList { get; set; }
    public DbSet<LeftWork> LeftWorkList { get; set; }
    public DbSet<WorkshopAccount> WorkshopAccounts { get; set; }
    public DbSet<WorkingHoursItems> WorkingHoursItemsSet { get; set; }
    public DbSet<WorkingHours> WorkingHoursSet { get; set; }
    public DbSet<HolidayItem> HolidayItems { get; set; }
    public DbSet<Holiday> Holidays { get; set; }
    public DbSet<MandatoryHours> MandatoryHoursDbSet { get; set; } 
    public DbSet<WorkshopEmployer> WorkshopEmployers { get; set; }
    public DbSet<Job> Jobs { get; set; }    
    public DbSet<Contract> Contracts { get; set; }
    public DbSet<YearlySalaryTitle> YearlySalaryTitles { get; set; }
    public DbSet<YearlySalaryItem> YearlySalaryItems { get; set; }
    public DbSet<YearlySalary> YearlySalaries { get; set; }
    public DbSet<EmployeeChildren> EmployeeChildrenSet { get; set; }    
    public DbSet<Employee> Employees { get; set; }
    public DbSet<Workshop> Workshops { get; set; }
    public DbSet<PersonalContractingParty> PersonalContractingParties { get; set; }

    //-------Cross-Job----------------------------
    public DbSet<CrossJobGuild> CrossJobGuilds { get; set; }
    public DbSet<CrossJob> CrossJobs { get; set; }
    public DbSet<CrossJobItems> CrossJobItems { get; set; }
    public DbSet<Insurance> Insurances { get; set; }
    public DbSet<EmployeeInsuranceRecord> EmployeeInsuranceRecords { get; set; }

    public DbSet<Employer> Employers { get; set; }

    #region BugReport
    public DbSet<CameraBugReport> CameraBugReports { get; set; }
    public DbSet<CameraBugReportLog> CameraBugReportLogs { get; set; }
    public DbSet<CameraBugReportScreenshot> CameraBugReportScreenshots { get; set; }
    #endregion
    public CompanyContext(DbContextOptions<CompanyContext> options) :base(options)
    {
            
    }


    public CompanyContext()
    {

    }
        

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        var assembly = typeof(PersonalContractingpartyMapping).Assembly;
        modelBuilder.ApplyConfigurationsFromAssembly(assembly);
        modelBuilder.Entity<RollCall>().HasQueryFilter(x => x.RollCallModifyType != RollCallModifyType.Undefined);
        base.OnModelCreating(modelBuilder);
         
    }
}