public SubcontractorHoursAddTDS.SubcontractorHoursDataTable GetSubcontractorsDetail() { projectSubcontractorCost = (SubcontractorHoursAddTDS.SubcontractorHoursDataTable)Session["projectSubcontractorCostDummyByClientProject"]; if (projectSubcontractorCost == null) { projectSubcontractorCost = ((SubcontractorHoursAddTDS.SubcontractorHoursDataTable)Session["projectSubcontractorCostByClientProject"]); } return projectSubcontractorCost; }
protected void AddSubcontractorsNewEmptyFix(GridView grdSubcontractors) { if (grdSubcontractors.Rows.Count == 0) { SubcontractorHoursAddTDS.SubcontractorHoursDataTable dt = new SubcontractorHoursAddTDS.SubcontractorHoursDataTable(); dt.AddSubcontractorHoursRow(-1, -1, -1, DateTime.Now, -1, -1, -1, -1, -1, "", false, -1, false, "", 0, 0, "", "", 1); Session["projectSubcontractorCostDummyByClientProject"] = dt; grdSubcontractors.DataBind(); } // normally executes at all postbacks if (grdSubcontractors.Rows.Count == 1) { SubcontractorHoursAddTDS.SubcontractorHoursDataTable dt = (SubcontractorHoursAddTDS.SubcontractorHoursDataTable)Session["projectSubcontractorCostDummyByClientProject"]; if (dt != null) { grdSubcontractors.Rows[0].Visible = false; grdSubcontractors.Rows[0].Controls.Clear(); } } }
private void GrdSubcontractorsDetailAdd() { Page.Validate("generalData"); if (Page.IsValid) { if (FooterValidate()) { Page.Validate("DataNew"); if (Page.IsValid) { int companyId = Int32.Parse(hdfCompanyId.Value); DateTime date = (DateTime)((RadDatePicker)grdSubcontractors.FooterRow.FindControl("tkrdpDateFooter")).SelectedDate; int subcontractorId = Int32.Parse(((DropDownList)grdSubcontractors.FooterRow.FindControl("ddlSubcontractorFooter")).SelectedValue); string name = ((DropDownList)grdSubcontractors.FooterRow.FindControl("ddlSubcontractorFooter")).SelectedItem.Text; string quantityString = ((TextBox)grdSubcontractors.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)grdSubcontractors.FooterRow.FindControl("tbxRateFooter")).Text), 2); decimal total = decimal.Round(decimal.Parse(((TextBox)grdSubcontractors.FooterRow.FindControl("tbxTotalFooter")).Text), 2); string comment = ((TextBox)grdSubcontractors.FooterRow.FindControl("tbxCommentFooter")).Text; bool deleted = false; bool inDatabase = false; int projectId = Int32.Parse(ddlProject.SelectedValue); 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 SubcontractorHoursAddSubcontractorHours subcontractorAddProjectSubcontractorsCosts = new SubcontractorHoursAddSubcontractorHours(subcontractorAddTDS); subcontractorAddProjectSubcontractorsCosts.Insert(projectId, subcontractorId, date, quantity, rateCad, totalCad, rateUsd, totalUsd, comment, deleted, companyId, inDatabase, name, ddlClient.SelectedItem.Text, ddlProject.SelectedItem.Text, Int32.Parse(ddlClient.SelectedValue)); // Store dataset Session["subcontractorAddTDSByClientProject"] = subcontractorAddTDS; Session.Remove("projectSubcontractorCostDummyByClientProject"); projectSubcontractorCost = subcontractorAddTDS.SubcontractorHours; Session["projectSubcontractorCostByClientProject"] = subcontractorAddTDS.SubcontractorHours; grdSubcontractors.DataBind(); grdSubcontractors.PageIndex = grdSubcontractors.PageCount - 1; } } } }
// //////////////////////////////////////////////////////////////////////// // INITIAL EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_SUBCONTRACTOR_HOURS_ADMIN"]))) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_SUBCONTRACTOR_HOURS_ADD"]))) { 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 subcontractor_hours_add_by_client_project.aspx"); } } // Tag page Session.Remove("projectSubcontractorCostDummyByClientProject"); hdfCompanyId.Value = Session["companyID"].ToString(); // Store datasets subcontractorAddTDS = new SubcontractorHoursAddTDS(); Session["subcontractorAddTDSByClientProject"] = subcontractorAddTDS; Session["projectSubcontractorCostByClientProject"] = subcontractorAddTDS.SubcontractorHours; StoreNavigatorState(); } else { // Restore datasets subcontractorAddTDS = (SubcontractorHoursAddTDS)Session["subcontractorAddTDSByClientProject"]; projectSubcontractorCost = subcontractorAddTDS.SubcontractorHours; Session["projectSubcontractorCostByClientProject"] = subcontractorAddTDS.SubcontractorHours; } }
protected void grdSubcontractors_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)grdSubcontractors.Rows[e.RowIndex].FindControl("lblRefIdEdit")).Text); DateTime date = (DateTime)((RadDatePicker)grdSubcontractors.Rows[e.RowIndex].FindControl("tkrdpDateEdit")).SelectedDate; int subcontractorId = Int32.Parse(((DropDownList)grdSubcontractors.Rows[e.RowIndex].FindControl("ddlSubcontractorEdit")).SelectedValue); string name = ((DropDownList)grdSubcontractors.Rows[e.RowIndex].FindControl("ddlSubcontractorEdit")).SelectedItem.Text; string quantityString = ((TextBox)grdSubcontractors.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)grdSubcontractors.Rows[e.RowIndex].FindControl("tbxRateEdit")).Text), 2); decimal total = decimal.Round(decimal.Parse(((TextBox)grdSubcontractors.Rows[e.RowIndex].FindControl("tbxTotalEdit")).Text), 2); decimal rateCad = 0; decimal totalCad = 0; decimal rateUsd = 0; decimal totalUsd = 0; int projectId = Int32.Parse(ddlProject.SelectedValue); 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)grdSubcontractors.Rows[e.RowIndex].FindControl("tbxCommentEdit")).Text; bool deleted = false; // Update Data SubcontractorHoursAddSubcontractorHours subcontractorAddProjectSubcontractorsCosts = new SubcontractorHoursAddSubcontractorHours(subcontractorAddTDS); subcontractorAddProjectSubcontractorsCosts.Update(projectId, refId, subcontractorId, date, quantity, rateCad, totalCad, rateUsd, totalUsd, comment, deleted, companyId, name, ddlClient.SelectedItem.Text, ddlProject.SelectedItem.Text, Int32.Parse(ddlClient.SelectedValue)); // Store dataset Session["subcontractorAddTDSByClientProject"] = subcontractorAddTDS; Session.Remove("projectSubcontractorCostDummyByClientProject"); projectSubcontractorCost = subcontractorAddTDS.SubcontractorHours; Session["projectSubcontractorCostByClientProject"] = subcontractorAddTDS.SubcontractorHours; } else { e.Cancel = true; } } else { e.Cancel = true; } }
protected void grdSubcontractors_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Project Time Gridview, if the gridview is edition mode if (grdSubcontractors.EditIndex >= 0) { grdSubcontractors.UpdateRow(grdSubcontractors.EditIndex, true); } // Delete subcontractor int projectId = (int)e.Keys["ProjectID"]; int refId = (int)e.Keys["RefID"]; // Delete team project time details SubcontractorHoursAddSubcontractorHours subcontractorAddProjectSubcontractorsCosts = new SubcontractorHoursAddSubcontractorHours(subcontractorAddTDS); subcontractorAddProjectSubcontractorsCosts.Delete(projectId, refId); // Store dataset Session["subcontractorAddTDSByClientProject"] = subcontractorAddTDS; Session.Remove("projectSubcontractorCostDummyByClientProject"); projectSubcontractorCost = subcontractorAddTDS.SubcontractorHours; Session["projectSubcontractorCostByClientProject"] = subcontractorAddTDS.SubcontractorHours; }