protected void grdCompaniesSetup_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Delete subcontractor
int companiesId = (int)e.Keys["COMPANIES_ID"];
DateTime date = (DateTime)e.Keys["Date"];
InsuranceCompaniesSetupInsuranceCompaniesSetup model = new InsuranceCompaniesSetupInsuranceCompaniesSetup(insuranceCompaniesSetupTDS);
model.Delete(companiesId, date);
// Store dataset
Session["insuranceCompaniesSetupTDS"] = insuranceCompaniesSetupTDS;
Session["insuranceCompaniesSetupTable"] = insuranceCompaniesSetupTDS.InsuranceCompaniesSetup;
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_RESOURCES_INSURANCECOMPANIES_VIEW"]) && Convert.ToBoolean(Session["sgLFS_RESOURCES_INSURANCECOMPANIES_EDIT"])) && Convert.ToBoolean(Session["sgLFS_RESOURCES_INSURANCECOMPANIES_DELETE"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if ((string)Request.QueryString["source_page"] == null)
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in insuranceCompanies_navigator.aspx");
}
// Tag page
hdfCompanyId.Value = Session["companyID"].ToString();
// Prepare initial data
Session.Remove("insuranceCompaniesSetupTableDummy");
tdNoResults.Visible = false;
// If coming from
// ... Left Menu or select_project
if (Request.QueryString["source_page"] == "out")
{
// Load
insuranceCompaniesSetupTDS = new InsuranceCompaniesSetupTDS();
InsuranceCompaniesSetupInsuranceCompaniesSetup model = new InsuranceCompaniesSetupInsuranceCompaniesSetup(insuranceCompaniesSetupTDS);
int companyId = Int32.Parse(hdfCompanyId.Value);
model.LoadAll(companyId);
// Check if there is data
InsuranceCompaniesSetupInsuranceCompaniesSetup modelForMessage = new InsuranceCompaniesSetupInsuranceCompaniesSetup(insuranceCompaniesSetupTDS);
modelForMessage.Load(companyId);
if (modelForMessage.Table.Rows.Count > 0)
{
tdNoResults.Visible = false;
}
else
{
tdNoResults.Visible = true;
}
// Store tables
Session["insuranceCompaniesSetupTDS"] = insuranceCompaniesSetupTDS;
Session["insuranceCompaniesSetupTable"] = insuranceCompaniesSetupTDS.InsuranceCompaniesSetup;
}
}
else
{
// Restore datasets
insuranceCompaniesSetupTDS = (InsuranceCompaniesSetupTDS)Session["insuranceCompaniesSetupTDS"];
Session["insuranceCompaniesSetupTable"] = insuranceCompaniesSetupTDS.InsuranceCompaniesSetup;
}
}
private void UpdateDatabase()
{
int companyId = Int32.Parse(hdfCompanyId.Value);
DB.Open();
DB.BeginTransaction();
try
{
// Save subcontractors
InsuranceCompaniesSetupInsuranceCompaniesSetup insuranceCompaniesSetupInsuranceCompaniesSetup = new InsuranceCompaniesSetupInsuranceCompaniesSetup(insuranceCompaniesSetupTDS);
insuranceCompaniesSetupInsuranceCompaniesSetup.Save(companyId);
DB.CommitTransaction();
// Store datasets
insuranceCompaniesSetupTDS.AcceptChanges();
Session["insuranceCompaniesSetupTDS"] = insuranceCompaniesSetupTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}