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);
}
}
