protected void grdInsuranceCompaniesCostsByClientProject_RowUpdating(object sender, GridViewUpdateEventArgs e) { Page.Validate("DataEditInsuranceCompaniesByClientProject"); if (Page.IsValid) { int companyId = Int32.Parse(hdfCompanyId.Value); int refId = Int32.Parse(((Label)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("lblRefIdEditInsuranceCompaniesByClientProject")).Text); DateTime date = (DateTime)((RadDatePicker)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("tkrdpDateEditInsuranceCompaniesByClientProject")).SelectedDate; int insuranceCompanyId = Int32.Parse(((DropDownList)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("ddlInsuranceCompaniesEditInsuranceCompaniesByClientProject")).Text); string name = ((DropDownList)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("ddlInsuranceCompaniesEditInsuranceCompaniesByClientProject")).SelectedItem.Text; int projectId = Int32.Parse(((Label)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("lblProjectIdEditInsuranceCompaniesByClientProject")).Text); decimal rate = decimal.Round(decimal.Parse(((TextBox)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("tbxRateEditInsuranceCompaniesByClientProject")).Text), 2); decimal rateCad = 0; decimal rateUsd = 0; ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(projectId); if (projectGateway.GetCountryID(projectId) == 1) //Canada { rateCad = rate; } else { rateUsd = rate; } string comment = ((TextBox)grdInsuranceCompaniesCostsByClientProject.Rows[e.RowIndex].FindControl("tbxCommentEditInsuranceCompaniesByClientProject")).Text; bool deleted = false; // Update Data ActualCostsAddInsuranceCompaniesCosts actualCostsAddInsuranceCompaniesCosts = new ActualCostsAddInsuranceCompaniesCosts(actualCostsAddTDS); actualCostsAddInsuranceCompaniesCosts.Update(projectId, refId, insuranceCompanyId, date, rateCad, rateUsd, comment, deleted, companyId, name); // Store dataset Session.Remove("insuranceCompaniesCostsByClientProjectDummy"); Session["actualCostsAddTDS"] = actualCostsAddTDS; Session["insuranceCompaniesCosts"] = actualCostsAddTDS.InsuranceCompaniesCosts; insuranceCompaniesCosts = actualCostsAddTDS.InsuranceCompaniesCosts; } else { e.Cancel = true; } }
protected void grdInsuranceCompaniesCostsByClientProject_RowDeleting(object sender, GridViewDeleteEventArgs e) { // InsuranceCompanies Gridview, if the gridview is edition mode if (grdInsuranceCompaniesCostsByClientProject.EditIndex >= 0) { grdInsuranceCompaniesCostsByClientProject.UpdateRow(grdInsuranceCompaniesCostsByClientProject.EditIndex, true); } // Delete InsuranceCompanies int projectId = (int)e.Keys["ProjectID"]; int refId = (int)e.Keys["RefID"]; // Delete costs details ActualCostsAddInsuranceCompaniesCosts actualCostsAddInsuranceCompaniesCosts = new ActualCostsAddInsuranceCompaniesCosts(actualCostsAddTDS); actualCostsAddInsuranceCompaniesCosts.Delete(projectId, refId); // Store dataset Session.Remove("insuranceCompaniesCostsByClientProjectDummy"); Session["actualCostsAddTDS"] = actualCostsAddTDS; Session["insuranceCompaniesCosts"] = actualCostsAddTDS.InsuranceCompaniesCosts; insuranceCompaniesCosts = actualCostsAddTDS.InsuranceCompaniesCosts; }
private void grdInsuranceCompaniesCostsByClientProjectDetailAdd() { if (FooterValidateInsuranceCompaniesByClientProject()) { Page.Validate("DataNewInsuranceCompaniesByClientProject"); if (Page.IsValid) { int companyId = Int32.Parse(hdfCompanyId.Value); DateTime date = (DateTime)((RadDatePicker)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("tkrdpDateFooterInsuranceCompaniesByClientProject")).SelectedDate; int insuranceCompanyId = Int32.Parse(((DropDownList)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("ddlInsuranceCompaniesFooterInsuranceCompaniesByClientProject")).Text); string name = ((DropDownList)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("ddlInsuranceCompaniesFooterInsuranceCompaniesByClientProject")).SelectedItem.Text; int clientId = Int32.Parse(((DropDownList)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("ddlClientFooterInsuranceCompaniesByClientProject")).SelectedValue); string client = ((DropDownList)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("ddlClientFooterInsuranceCompaniesByClientProject")).SelectedItem.Text; int projectId = Int32.Parse(((DropDownList)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("ddlProjectFooterInsuranceCompaniesByClientProject")).SelectedValue); string project = ((DropDownList)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("ddlProjectFooterInsuranceCompaniesByClientProject")).SelectedItem.Text; decimal rate = decimal.Round(decimal.Parse(((TextBox)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("tbxRateFooterInsuranceCompaniesByClientProject")).Text), 2); string comment = ((TextBox)grdInsuranceCompaniesCostsByClientProject.FooterRow.FindControl("tbxCommentFooterInsuranceCompaniesByClientProject")).Text; bool deleted = false; bool inDatabase = false; decimal rateCad = 0; decimal rateUsd = 0; ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(projectId); if (projectGateway.GetCountryID(projectId) == 1) //Canada { rateCad = rate; rateUsd = rate; } else { rateCad = rate; rateUsd = rate; } // Insert Data ActualCostsAddInsuranceCompaniesCosts actualCostsAddInsuranceCompaniesCosts = new ActualCostsAddInsuranceCompaniesCosts(actualCostsAddTDS); actualCostsAddInsuranceCompaniesCosts.Insert(projectId, insuranceCompanyId, date, rateCad, rateUsd, comment, deleted, companyId, inDatabase, name, client, project, clientId); // Store dataset Session.Remove("insuranceCompaniesCostsByClientProjectDummy"); Session["actualCostsAddTDS"] = actualCostsAddTDS; Session["insuranceCompaniesCosts"] = actualCostsAddTDS.InsuranceCompaniesCosts; insuranceCompaniesCosts = actualCostsAddTDS.InsuranceCompaniesCosts; grdInsuranceCompaniesCostsByClientProject.DataBind(); grdInsuranceCompaniesCostsByClientProject.PageIndex = grdInsuranceCompaniesCostsByClientProject.PageCount - 1; } } }
protected void AddInsuranceCompaniesCostsNewEmptyFix(GridView grdInsuranceCompaniesCostsByClientProject) { if (grdInsuranceCompaniesCostsByClientProject.Rows.Count == 0) { int companyId = Int32.Parse(hdfCompanyId.Value); ActualCostsAddTDS.InsuranceCompaniesCostsDataTable dt = new ActualCostsAddTDS.InsuranceCompaniesCostsDataTable(); dt.AddInsuranceCompaniesCostsRow(-1, -1, DateTime.Now, -1, -1, "", false, companyId, false, "", 0, "", "", 1); Session["insuranceCompaniesCostsByClientProjectDummy"] = dt; grdInsuranceCompaniesCostsByClientProject.DataBind(); } // normally executes at all postbacks if (grdInsuranceCompaniesCostsByClientProject.Rows.Count == 1) { ActualCostsAddTDS.InsuranceCompaniesCostsDataTable dt = (ActualCostsAddTDS.InsuranceCompaniesCostsDataTable)Session["insuranceCompaniesCostsByClientProjectDummy"]; if (dt != null) { grdInsuranceCompaniesCostsByClientProject.Rows[0].Visible = false; grdInsuranceCompaniesCostsByClientProject.Rows[0].Controls.Clear(); } } }
// //////////////////////////////////////////////////////////////////////// // STEP6 - INSURANCE COMPANIES COST BY CLIENT AND PROJECT - PUBLIC METHODS // public ActualCostsAddTDS.InsuranceCompaniesCostsDataTable GetInsuranceCompaniesDetailInsuranceCompaniesByClientProject() { insuranceCompaniesCosts = (ActualCostsAddTDS.InsuranceCompaniesCostsDataTable)Session["insuranceCompaniesCostsByClientProjectDummy"]; if (insuranceCompaniesCosts == null) { insuranceCompaniesCosts = ((ActualCostsAddTDS.InsuranceCompaniesCostsDataTable)Session["insuranceCompaniesCosts"]); } return insuranceCompaniesCosts; }