//// //////////////////////////////////////////////////////////////////////// //// PRIVATE METHODS //// /// <summary> /// Save all subcontractors to database (direct) /// </summary> /// <param name="companyId">companyId</param> public void Save(int companyId) { SubcontractorsAddTDS subcontractorChanges = (SubcontractorsAddTDS)Data.GetChanges(); if (subcontractorChanges.Subcontractors.Rows.Count > 0) { SubcontractorsAddSubcontractorsGateway subcontractorsAddSubcontractorsGateway = new SubcontractorsAddSubcontractorsGateway(subcontractorChanges); foreach (SubcontractorsAddTDS.SubcontractorsRow row in (SubcontractorsAddTDS.SubcontractorsDataTable)subcontractorChanges.Subcontractors) { //Insert companies SubcontractorsResoucesSubcontractors subcontractorsResoucesSubcontractors = new SubcontractorsResoucesSubcontractors(null); subcontractorsResoucesSubcontractors.InsertDirect(row.COMPANIES_ID, row.Date, row.Name, row.Active, row.Udf, row.Deleted, row.COMPANY_ID); } } }
/// <summary> /// Save all subcontractors to database (direct) /// </summary> /// <param name="companyId">companyId</param> public void Save(int companyId) { SubcontractorsSetupTDS subcontractorSetupChanges = (SubcontractorsSetupTDS)Data.GetChanges(); if (subcontractorSetupChanges != null) { if (subcontractorSetupChanges.SubcontractorsSetup.Rows.Count > 0) { SubcontractorsSetupSubcontractorsSetupGateway subcontractorsSetupSubcontractorsSetupGateway = new SubcontractorsSetupSubcontractorsSetupGateway(subcontractorSetupChanges); foreach (SubcontractorsSetupTDS.SubcontractorsSetupRow row in (SubcontractorsSetupTDS.SubcontractorsSetupDataTable)subcontractorSetupChanges.SubcontractorsSetup) { //Update subcontractors if (!row.Deleted) { int companiesId = row.COMPANIES_ID; DateTime date = row.Date; bool deleted = row.Deleted; // original values bool originalActive = subcontractorsSetupSubcontractorsSetupGateway.GetActiveOriginal(companiesId, date); // new values bool newActive = subcontractorsSetupSubcontractorsSetupGateway.GetActive(companiesId, date); SubcontractorsResoucesSubcontractors subcontractorsResoucesSubcontractors = new SubcontractorsResoucesSubcontractors(null); subcontractorsResoucesSubcontractors.UpdateDirect(companiesId, date, originalActive, row.Udf, deleted, companyId, companiesId, date, newActive, row.Udf, deleted, companyId); } // Delete subcontractors if (row.Deleted) { SubcontractorsResoucesSubcontractors subcontractorsResoucesSubcontractorsDelete = new SubcontractorsResoucesSubcontractors(null); subcontractorsResoucesSubcontractorsDelete.DeleteDirect(row.COMPANIES_ID, row.Date); } } } } }