// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS - DATASET // /// <summary> /// LoadAll /// </summary> /// <param name="companyId">companyId</param> public void LoadAll(int companyId) { SubcontractorsSetupSubcontractorsSetupGateway subcontractorsSetupSubcontractorsSetupGateway = new SubcontractorsSetupSubcontractorsSetupGateway(Data); subcontractorsSetupSubcontractorsSetupGateway.LoadAll(companyId); UpdateDataForNavigators(); }
protected void grdCompaniesSetup_RowDataBound(object sender, GridViewRowEventArgs e) { // Normal rows if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Normal) || (e.Row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate)))) { int subcontractorId = int.Parse(((Label)e.Row.FindControl("lblCOMPANIES_IDId")).Text); int companyId = Int32.Parse(hdfCompanyId.Value); SubcontractorsSetupSubcontractorsSetupGateway subcontractorsSetupSubcontractorsSetupGateway = new SubcontractorsSetupSubcontractorsSetupGateway(); if (subcontractorsSetupSubcontractorsSetupGateway.IsUsedInSubcontractorCosts(subcontractorId, companyId)) { ((ImageButton)e.Row.FindControl("ibtnDelete")).Visible = false; } else { ((ImageButton)e.Row.FindControl("ibtnDelete")).Visible = true; } } }
/// <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); } } } } }