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);
InsuranceCompaniesAddInsuranceCompanies insuranceCompaniesAddInsuranceCompanies = new InsuranceCompaniesAddInsuranceCompanies(insuranceCompaniesAddTDS);
insuranceCompaniesAddInsuranceCompanies.Save(companyId);
DB.CommitTransaction();
// Store datasets
insuranceCompaniesAddTDS.AcceptChanges();
Session["insuranceCompaniesAddTDS"] = insuranceCompaniesAddTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private bool StepInsuranceCompaniesNext()
{
int selectedCompaniesIdForInsuranceCompanies = Int32.Parse(ddlCompaniesForInsuranceCompanies.SelectedValue);
int companyIdForInsuranceCompanies = Int32.Parse(hdfCompanyIdForInsuranceCompanies.Value);
InsuranceCompaniesAddInsuranceCompaniesGateway insuranceCompaniesAddInsuranceCompaniesGateway = new InsuranceCompaniesAddInsuranceCompaniesGateway();
if (insuranceCompaniesAddInsuranceCompaniesGateway.IsInLfs(selectedCompaniesIdForInsuranceCompanies, companyIdForInsuranceCompanies))
{
lblUserErrorMessageForInsuranceCompanies.Visible = true;
}
else
{
lblUserErrorMessageForInsuranceCompanies.Visible = false;
// Get name
int companiesIdForInsuranceCompanies = Int32.Parse(ddlCompaniesForInsuranceCompanies.SelectedValue);
DateTime dateForInsuranceCompanies = DateTime.Now;
// Insert subcontractor
hdfNameForInsuranceCompanies.Value = GetCompanyName(companiesIdForInsuranceCompanies, companyIdForInsuranceCompanies);
InsuranceCompaniesAddInsuranceCompanies model = new InsuranceCompaniesAddInsuranceCompanies(insuranceCompaniesAddTDS);
model.Insert(companiesIdForInsuranceCompanies, dateForInsuranceCompanies, hdfNameForInsuranceCompanies.Value, false, companyIdForInsuranceCompanies);
// ... Store tables
Session["insuranceCompaniesAddTDS"] = insuranceCompaniesAddTDS;
}
return true;
}
private bool StepBeginNext()
{
int selectedCompaniesId = Int32.Parse(ddlCompanies.SelectedValue);
int companyId = Int32.Parse(hdfCompanyId.Value);
InsuranceCompaniesAddInsuranceCompaniesGateway insuranceCompaniesAddInsuranceCompaniesGateway = new InsuranceCompaniesAddInsuranceCompaniesGateway();
if (insuranceCompaniesAddInsuranceCompaniesGateway.IsInLfs(selectedCompaniesId, companyId))
{
lblUserErrorMessage.Visible = true;
return false;
}
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, companyId);
hdfName.Value = companiesGatewayRAF.GetName(companiesId);
InsuranceCompaniesAddInsuranceCompanies model = new InsuranceCompaniesAddInsuranceCompanies(insuranceCompaniesAddTDS);
model.Insert(companiesId, date, hdfName.Value, false, companyId);
// ... Store tables
Session["insuranceCompaniesAddTDS"] = insuranceCompaniesAddTDS;
}
return true;
}
