private bool StepSubcontractorsNext() { int selectedCompaniesId = Int32.Parse(ddlCompanies.SelectedValue); int companyIdForSubcontractors = Int32.Parse(hdfCompanyIdForSubcontractors.Value); SubcontractorsAddSubcontractorsGateway subcontractorsAddSubcontractorsGateway = new SubcontractorsAddSubcontractorsGateway(); if (subcontractorsAddSubcontractorsGateway.IsInLfs(selectedCompaniesId, companyIdForSubcontractors)) { lblUserErrorMessage.Visible = true; } else { lblUserErrorMessage.Visible = false; // Get name int companiesId = Int32.Parse(ddlCompanies.SelectedValue); DateTime date = DateTime.Now; // Insert subcontractor CompaniesGatewayRAF companiesGatewayRAF = new CompaniesGatewayRAF(); companiesGatewayRAF.LoadByCompaniesId(companiesId, companyIdForSubcontractors); hdfNameForSubcontractors.Value = GetCompanyName(companiesId, companyIdForSubcontractors); SubcontractorsAddSubcontractors model = new SubcontractorsAddSubcontractors(subcontractorsAddTDS); model.Insert(companiesId, date, hdfNameForSubcontractors.Value, true, companiesGatewayRAF.GetActive(companiesId), false, companyIdForSubcontractors); // ... Store tables Session["subcontractorsAddTDS"] = subcontractorsAddTDS; } return true; }
private void UpdateDatabase() { DB.Open(); DB.BeginTransaction(); try { // For Subcontractors if ((cbxSubcontractor.Checked) && (hdfNameForSubcontractors .Value !="")) { int companyIdForSubcontractors = Int32.Parse(hdfCompanyIdForSubcontractors.Value); SubcontractorsAddSubcontractors subcontractorsAddSubcontractors = new SubcontractorsAddSubcontractors(subcontractorsAddTDS); subcontractorsAddSubcontractors.Save(companyIdForSubcontractors); // Store datasets subcontractorsAddTDS.AcceptChanges(); Session["subcontractorsAddTDS"] = subcontractorsAddTDS; } // For Hotels if ((cbxHotels.Checked) && (hdfNameForHotels .Value !="")) { int companyIdForHotels = Int32.Parse(hdfCompanyIdForHotels.Value); HotelsAddHotels hotelsAddHotels = new HotelsAddHotels(hotelsAddTDS); hotelsAddHotels.Save(companyIdForHotels); // Store datasets hotelsAddTDS.AcceptChanges(); Session["hotelsAddTDS"] = hotelsAddTDS; } // For bonding Companies if ((cbxBondingCompanies.Checked) && (hdfNameForBondingCompanies .Value !="")) { int companyIdForBondingCompanies = Int32.Parse(hdfCompanyIdForBondingCompanies.Value); BondingCompaniesAddBondingCompanies bondingCompaniesAddBondingCompanies = new BondingCompaniesAddBondingCompanies(bondingCompaniesAddTDS); bondingCompaniesAddBondingCompanies.Save(companyIdForBondingCompanies); // Store datasets bondingCompaniesAddTDS.AcceptChanges(); Session["bondingCompaniesAddTDS"] = bondingCompaniesAddTDS; } // For insurance Companies if ((cbxInsuranceCompanies.Checked) && (hdfNameForInsuranceCompanies .Value !="")) { int companyIdForInsuranceCompanies = Int32.Parse(hdfCompanyIdForInsuranceCompanies.Value); InsuranceCompaniesAddInsuranceCompanies insuranceCompaniesAddInsuranceCompanies = new InsuranceCompaniesAddInsuranceCompanies(insuranceCompaniesAddTDS); insuranceCompaniesAddInsuranceCompanies.Save(companyIdForInsuranceCompanies); // Store datasets insuranceCompaniesAddTDS.AcceptChanges(); Session["insuranceCompaniesAddTDS"] = insuranceCompaniesAddTDS; } DB.CommitTransaction(); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private void UpdateDatabase() { DB.Open(); DB.BeginTransaction(); try { int companyId = Int32.Parse(hdfCompanyId.Value); SubcontractorsAddSubcontractors subcontractorsAddSubcontractors = new SubcontractorsAddSubcontractors(subcontractorsAddTDS); subcontractorsAddSubcontractors.Save(companyId); DB.CommitTransaction(); // Store datasets subcontractorsAddTDS.AcceptChanges(); Session["subcontractorsAddTDS"] = subcontractorsAddTDS; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }