389 lines
16 KiB
C#
389 lines
16 KiB
C#
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.ClassificationSchemeAgg;
|
||
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 ClassificationScheme
|
||
|
||
/// <summary>
|
||
/// جدول طرح طبقه بندی
|
||
/// </summary>
|
||
public DbSet<ClassificationScheme> ClassificationSchemes { get; set; }
|
||
|
||
/// <summary>
|
||
/// جدول گروه های طرح
|
||
/// </summary>
|
||
public DbSet<ClassificationGroup> ClassificationGroups { get; set; }
|
||
|
||
/// <summary>
|
||
/// جدول ضرایب ریالی
|
||
/// </summary>
|
||
public DbSet<ClassificationRialCoefficient> ClassificationRialCoefficients { get; set; }
|
||
|
||
|
||
/// <summary>
|
||
/// جدول شغل های گروه
|
||
/// </summary>
|
||
public DbSet<ClassificationGroupJob> ClassificationGroupJobs { get; set; }
|
||
|
||
/// <summary>
|
||
/// جدول مزد شغل گروه ها
|
||
/// </summary>
|
||
public DbSet<ClassificationGroupSalary> ClassificationGroupSalaries { get; set; }
|
||
|
||
/// <summary>
|
||
/// جدول پرسنل طرح
|
||
/// </summary>
|
||
public DbSet<ClassificationEmployee> ClassificationEmployees { get; set; }
|
||
|
||
|
||
#endregion
|
||
|
||
#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);
|
||
|
||
}
|
||
} |