private void UpdateDatabase() { DB.Open(); DB.BeginTransaction(); try { int companyId = Int32.Parse(hdfCompanyId.Value); int loginId = Convert.ToInt32(Session["loginID"]); // Save costs information if (cbxSubcontractorCosts.Checked) { if (rbtnSubcontractorCostsBySubcontractor.Checked) { ActualCostsAddSubcontractorCosts actualCostsAddSubcontractorCosts = new ActualCostsAddSubcontractorCosts(actualCostsAddTDS); actualCostsAddSubcontractorCosts.Save(companyId); } else { if (rbtnSubcontractorCostsByProjectAndClient.Checked) { ActualCostsAddSubcontractorCosts actualCostsAddSubcontractorCosts = new ActualCostsAddSubcontractorCosts(actualCostsAddTDS); actualCostsAddSubcontractorCosts.Save(companyId); } } } if (cbxHotelCosts.Checked) { ActualCostsAddHotelCosts actualCostsAddHotelCosts = new ActualCostsAddHotelCosts(actualCostsAddTDS); actualCostsAddHotelCosts.Save(companyId); } if (cbxBondingCosts.Checked) { ActualCostsAddBondingCompaniesCosts actualCostsAddBondingCompaniesCosts = new ActualCostsAddBondingCompaniesCosts(actualCostsAddTDS); actualCostsAddBondingCompaniesCosts.Save(companyId); } if (cbxInsuranceCosts.Checked) { ActualCostsAddInsuranceCompaniesCosts actualCostsAddInsuranceCompaniesCosts = new ActualCostsAddInsuranceCompaniesCosts(actualCostsAddTDS); actualCostsAddInsuranceCompaniesCosts.Save(companyId); } if (cbxOtherCosts.Checked) { ActualCostsAddOtherCosts actualCostsAddOtherCosts = new ActualCostsAddOtherCosts(actualCostsAddTDS); actualCostsAddOtherCosts.Save(companyId); } DB.CommitTransaction(); // Store datasets actualCostsAddTDS.AcceptChanges(); Session["actualCostsAddTDS"] = actualCostsAddTDS; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private void grdSubcontractorCostsBySubcontractorDetailAdd() { Page.Validate("generalData"); if (Page.IsValid) { if (FooterValidate()) { Page.Validate("DataNew"); if (Page.IsValid) { int companyId = Int32.Parse(hdfCompanyId.Value); DateTime date = (DateTime)((RadDatePicker)grdSubcontractorCostsBySubcontractor.FooterRow.FindControl("tkrdpDateFooter")).SelectedDate; int subcontractorId = Int32.Parse(ddlSubcontractor.SelectedValue); string name = ddlSubcontractor.SelectedItem.Text; int clientId = Int32.Parse(((DropDownList)grdSubcontractorCostsBySubcontractor.FooterRow.FindControl("ddlClientFooter")).SelectedValue); string client = ((DropDownList)grdSubcontractorCostsBySubcontractor.FooterRow.FindControl("ddlClientFooter")).SelectedItem.Text; int projectId = Int32.Parse(((DropDownList)grdSubcontractorCostsBySubcontractor.FooterRow.FindControl("ddlProjectFooter")).SelectedValue); string project = ((DropDownList)grdSubcontractorCostsBySubcontractor.FooterRow.FindControl("ddlProjectFooter")).SelectedItem.Text; string quantityString = ((TextBox)grdSubcontractorCostsBySubcontractor.FooterRow.FindControl("tbxQuantityFooter")).Text; decimal quantity1 = decimal.Round(decimal.Parse(quantityString), 1); double quantity = double.Parse(quantity1.ToString()); decimal rate = decimal.Round(decimal.Parse(((TextBox)grdSubcontractorCostsBySubcontractor.FooterRow.FindControl("tbxRateFooter")).Text), 2); decimal total = decimal.Round(decimal.Parse(((TextBox)grdSubcontractorCostsBySubcontractor.FooterRow.FindControl("tbxTotalFooter")).Text), 2); string comment = ((TextBox)grdSubcontractorCostsBySubcontractor.FooterRow.FindControl("tbxCommentFooter")).Text; bool deleted = false; bool inDatabase = false; decimal rateCad = 0; decimal totalCad = 0; decimal rateUsd = 0; decimal totalUsd = 0; ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(projectId); if (projectGateway.GetCountryID(projectId) == 1) //Canada { rateCad = rate; totalCad = total; rateUsd = rate; totalUsd = total; } else { rateCad = rate; totalCad = total; rateUsd = rate; totalUsd = total; } // Insert Data ActualCostsAddSubcontractorCosts actualCostsAddSubcontractorCosts = new ActualCostsAddSubcontractorCosts(actualCostsAddTDS); actualCostsAddSubcontractorCosts.Insert(projectId, subcontractorId, date, quantity, rateCad, totalCad, rateUsd, totalUsd, comment, deleted, companyId, inDatabase, name, client, project, clientId); // Store dataset Session["actualCostsAddTDS"] = actualCostsAddTDS; Session.Remove("subcontractorCostsBySubcontractorDummy"); subcontractorCosts = actualCostsAddTDS.SubcontractorCosts; Session["subcontractorCosts"] = actualCostsAddTDS.SubcontractorCosts; grdSubcontractorCostsBySubcontractor.DataBind(); grdSubcontractorCostsBySubcontractor.PageIndex = grdSubcontractorCostsBySubcontractor.PageCount - 1; } } } }
protected void grdSubcontractorCostsBySubcontractor_RowUpdating(object sender, GridViewUpdateEventArgs e) { Page.Validate("generalData"); if (Page.IsValid) { Page.Validate("DataEdit"); if (Page.IsValid) { int companyId = Int32.Parse(hdfCompanyId.Value); int refId = Int32.Parse(((Label)grdSubcontractorCostsBySubcontractor.Rows[e.RowIndex].FindControl("lblRefIdEdit")).Text); DateTime date = (DateTime)((RadDatePicker)grdSubcontractorCostsBySubcontractor.Rows[e.RowIndex].FindControl("tkrdpDateEdit")).SelectedDate; int subcontractorId = Int32.Parse(ddlSubcontractor.SelectedValue); string name = ddlSubcontractor.SelectedItem.Text; int projectId = Int32.Parse(((Label)grdSubcontractorCostsBySubcontractor.Rows[e.RowIndex].FindControl("lblProjectIdEdit")).Text); string quantityString = ((TextBox)grdSubcontractorCostsBySubcontractor.Rows[e.RowIndex].FindControl("tbxQuantityEdit")).Text; decimal quantity1 = decimal.Round(decimal.Parse(quantityString), 1); double quantity = double.Parse(quantity1.ToString()); decimal rate = decimal.Round(decimal.Parse(((TextBox)grdSubcontractorCostsBySubcontractor.Rows[e.RowIndex].FindControl("tbxRateEdit")).Text), 2); decimal total = decimal.Round(decimal.Parse(((TextBox)grdSubcontractorCostsBySubcontractor.Rows[e.RowIndex].FindControl("tbxTotalEdit")).Text), 2); decimal rateCad = 0; decimal totalCad = 0; decimal rateUsd = 0; decimal totalUsd = 0; ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(projectId); if (projectGateway.GetCountryID(projectId) == 1) //Canada { rateCad = rate; totalCad = total; } else { rateUsd = rate; totalUsd = total; } string comment = ((TextBox)grdSubcontractorCostsBySubcontractor.Rows[e.RowIndex].FindControl("tbxCommentEdit")).Text; bool deleted = false; // Update Data ActualCostsAddSubcontractorCosts subcontractorAddProjectSubcontractorsCosts = new ActualCostsAddSubcontractorCosts(actualCostsAddTDS); subcontractorAddProjectSubcontractorsCosts.Update(projectId, refId, subcontractorId, date, quantity, rateCad, totalCad, rateUsd, totalUsd, comment, deleted, companyId, name); // Store dataset Session["actualCostsAddTDS"] = actualCostsAddTDS; Session.Remove("subcontractorCostsBySubcontractorDummy"); subcontractorCosts = actualCostsAddTDS.SubcontractorCosts; Session["subcontractorCosts"] = actualCostsAddTDS.SubcontractorCosts; } else { e.Cancel = true; } } else { e.Cancel = true; } }
private string GetSummary() { string summary = ""; int companyId = Int32.Parse(hdfCompanyId.Value); // Summary for Subcontractor costs if (cbxSubcontractorCosts.Checked) { if (rbtnSubcontractorCostsBySubcontractor.Checked) { summary += "NEW SUBCONTRACTORS COSTS \n"; summary += "SUBCONTRACTOR: " + ddlSubcontractor.SelectedItem.Text + "\n"; ActualCostsAddSubcontractorCosts actualCostsAddSubcontractorCosts = new ActualCostsAddSubcontractorCosts(actualCostsAddTDS); summary += actualCostsAddSubcontractorCosts.GetSummary(companyId, "\n", "BySubcontractor"); } else { if (rbtnSubcontractorCostsByProjectAndClient.Checked) { summary += "NEW SUBCONTRACTORS COSTS \n"; summary += "CLIENT: " + ddlClientByClientProject.SelectedItem.Text + "\n"; summary += "PROJECT: " + ddlProjectByClientProject.SelectedItem.Text + "\n"; ActualCostsAddSubcontractorCosts actualCostsAddSubcontractorCosts = new ActualCostsAddSubcontractorCosts(actualCostsAddTDS); summary += actualCostsAddSubcontractorCosts.GetSummary(companyId, "\n", "ByClientProject"); } } } if (cbxHotelCosts.Checked) { summary += "NEW HOTEL COSTS \n"; ActualCostsAddHotelCosts actualCostsAddHotelCosts = new ActualCostsAddHotelCosts(actualCostsAddTDS); summary += actualCostsAddHotelCosts.GetSummary(companyId, "\n"); } if (cbxBondingCosts.Checked) { summary += "NEW BONDING COMPANIES COSTS \n"; ActualCostsAddBondingCompaniesCosts actualCostsAddBondingCompaniesCosts = new ActualCostsAddBondingCompaniesCosts(actualCostsAddTDS); summary += actualCostsAddBondingCompaniesCosts.GetSummary(companyId, "\n"); } if (cbxInsuranceCosts.Checked) { summary += "NEW INSURANCE COMPANIES COSTS \n"; ActualCostsAddInsuranceCompaniesCosts actualCostsAddInsuranceCompaniesCosts = new ActualCostsAddInsuranceCompaniesCosts(actualCostsAddTDS); summary += actualCostsAddInsuranceCompaniesCosts.GetSummary(companyId, "\n"); } if (cbxOtherCosts.Checked) { summary += "NEW OTHER COSTS \n"; ActualCostsAddOtherCosts actualCostsAddOtherCosts = new ActualCostsAddOtherCosts(actualCostsAddTDS); summary += actualCostsAddOtherCosts.GetSummary(companyId, "\n"); } return summary; }
protected void grdSubcontractorCostsBySubcontractor_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Subcontractor Gridview, if the gridview is edition mode if (grdSubcontractorCostsBySubcontractor.EditIndex >= 0) { grdSubcontractorCostsBySubcontractor.UpdateRow(grdSubcontractorCostsBySubcontractor.EditIndex, true); } // Delete subcontractor int projectId = (int)e.Keys["ProjectID"]; int refId = (int)e.Keys["RefID"]; // Delete costs details ActualCostsAddSubcontractorCosts subcontractorAddProjectSubcontractorsCosts = new ActualCostsAddSubcontractorCosts(actualCostsAddTDS); subcontractorAddProjectSubcontractorsCosts.Delete(projectId, refId); // Store dataset Session["actualCostsAddTDS"] = actualCostsAddTDS; Session.Remove("subcontractorCostsBySubcontractorDummy"); subcontractorCosts = actualCostsAddTDS.SubcontractorCosts; Session["subcontractorCosts"] = actualCostsAddTDS.SubcontractorCosts; }