protected void grdHotelCostsByClientProject_RowUpdating(object sender, GridViewUpdateEventArgs e) { Page.Validate("DataEditHotelByClientProject"); if (Page.IsValid) { int companyId = Int32.Parse(hdfCompanyId.Value); int refId = Int32.Parse(((Label)grdHotelCostsByClientProject.Rows[e.RowIndex].FindControl("lblRefIdEditHotelByClientProject")).Text); DateTime date = (DateTime)((RadDatePicker)grdHotelCostsByClientProject.Rows[e.RowIndex].FindControl("tkrdpDateEditHotelByClientProject")).SelectedDate; int hotelId = Int32.Parse(((DropDownList)grdHotelCostsByClientProject.Rows[e.RowIndex].FindControl("ddlHotelEditHotelByClientProject")).Text); string name = ((DropDownList)grdHotelCostsByClientProject.Rows[e.RowIndex].FindControl("ddlHotelEditHotelByClientProject")).SelectedItem.Text; int projectId = Int32.Parse(((Label)grdHotelCostsByClientProject.Rows[e.RowIndex].FindControl("lblProjectIdEditHotelByClientProject")).Text); decimal rate = decimal.Round(decimal.Parse(((TextBox)grdHotelCostsByClientProject.Rows[e.RowIndex].FindControl("tbxRateEditHotelByClientProject")).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)grdHotelCostsByClientProject.Rows[e.RowIndex].FindControl("tbxCommentEditHotelByClientProject")).Text; bool deleted = false; // Update Data ActualCostsAddHotelCosts actualCostsAddHotelCosts = new ActualCostsAddHotelCosts(actualCostsAddTDS); actualCostsAddHotelCosts.Update(projectId, refId, hotelId, date, rateCad, rateUsd, comment, deleted, companyId, name); // Store dataset Session.Remove("hotelCostsByClientProjectDummy"); Session["actualCostsAddTDS"] = actualCostsAddTDS; Session["hotelCosts"] = actualCostsAddTDS.HotelCosts; hotelCosts = actualCostsAddTDS.HotelCosts; } else { e.Cancel = true; } }
protected void grdHotelCostsByClientProject_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Hotel Gridview, if the gridview is edition mode if (grdHotelCostsByClientProject.EditIndex >= 0) { grdHotelCostsByClientProject.UpdateRow(grdHotelCostsByClientProject.EditIndex, true); } // Delete Hotel int projectId = (int)e.Keys["ProjectID"]; int refId = (int)e.Keys["RefID"]; // Delete costs details ActualCostsAddHotelCosts actualCostsAddHotelCosts = new ActualCostsAddHotelCosts(actualCostsAddTDS); actualCostsAddHotelCosts.Delete(projectId, refId); // Store dataset Session.Remove("hotelCostsByClientProjectDummy"); Session["actualCostsAddTDS"] = actualCostsAddTDS; Session["hotelCosts"] = actualCostsAddTDS.HotelCosts; hotelCosts = actualCostsAddTDS.HotelCosts; }
private void grdHotelCostsByClientProjectDetailAdd() { if (FooterValidateHotelByClientProject()) { Page.Validate("DataNewHotelByClientProject"); if (Page.IsValid) { int companyId = Int32.Parse(hdfCompanyId.Value); DateTime date = (DateTime)((RadDatePicker)grdHotelCostsByClientProject.FooterRow.FindControl("tkrdpDateFooterHotelByClientProject")).SelectedDate; int hotelId = Int32.Parse(((DropDownList)grdHotelCostsByClientProject.FooterRow.FindControl("ddlHotelFooterHotelByClientProject")).Text); string name = ((DropDownList)grdHotelCostsByClientProject.FooterRow.FindControl("ddlHotelFooterHotelByClientProject")).SelectedItem.Text; int clientId = Int32.Parse(((DropDownList)grdHotelCostsByClientProject.FooterRow.FindControl("ddlClientFooterHotelByClientProject")).SelectedValue); string client = ((DropDownList)grdHotelCostsByClientProject.FooterRow.FindControl("ddlClientFooterHotelByClientProject")).SelectedItem.Text; int projectId = Int32.Parse(((DropDownList)grdHotelCostsByClientProject.FooterRow.FindControl("ddlProjectFooterHotelByClientProject")).SelectedValue); string project = ((DropDownList)grdHotelCostsByClientProject.FooterRow.FindControl("ddlProjectFooterHotelByClientProject")).SelectedItem.Text; decimal rate = decimal.Round(decimal.Parse(((TextBox)grdHotelCostsByClientProject.FooterRow.FindControl("tbxRateFooterHotelByClientProject")).Text), 2); string comment = ((TextBox)grdHotelCostsByClientProject.FooterRow.FindControl("tbxCommentFooterHotelByClientProject")).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 ActualCostsAddHotelCosts actualCostsAddHotelCosts = new ActualCostsAddHotelCosts(actualCostsAddTDS); actualCostsAddHotelCosts.Insert(projectId, hotelId, date, rateCad, rateUsd, comment, deleted, companyId, inDatabase, name, client, project, clientId); // Store dataset Session.Remove("hotelCostsByClientProjectDummy"); Session["actualCostsAddTDS"] = actualCostsAddTDS; Session["hotelCosts"] = actualCostsAddTDS.HotelCosts; hotelCosts = actualCostsAddTDS.HotelCosts; grdHotelCostsByClientProject.DataBind(); grdHotelCostsByClientProject.PageIndex = grdHotelCostsByClientProject.PageCount - 1; } } }
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 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; }