public void grdCOSOV_DeleteCommand(object sender, DataGridCommandEventArgs e) { Whitfield_Project _wc = new Whitfield_Project(); String DetailId = ""; DetailId = grdCOSOV.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString(); project_invoice _dbClass = new project_invoice(); _dbClass.DeleteCOSOV(Convert.ToInt32(ViewState["twc_project_number"].ToString()), DetailId); _wc.UpdateCostUpdates(ViewState["EstNum"].ToString(), ViewState["twc_project_number"].ToString()); this.DisplayCOSOVGrid(); }
public void grdCOSOV_UpdateCommand(object sender, DataGridCommandEventArgs e) { Whitfield_Project _wc = new Whitfield_Project(); String SeqNo = grdCOSOV.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString(); project_invoice _pi = new project_invoice(); _pi.MaintainChangeOrderSOVRecords(ViewState["twc_project_number"].ToString(), SeqNo, ((TextBox)(e.Item.FindControl("txtco_number"))).Text, ((TextBox)(e.Item.FindControl("txtDescription"))).Text, ((TextBox)(e.Item.FindControl("txtsov_amount"))).Text, ((TextBox)(e.Item.FindControl("txtDate_Submited"))).Text, ((TextBox)(e.Item.FindControl("txtDate_Approved"))).Text, ((TextBox)(e.Item.FindControl("txtNotes"))).Text); grdCOSOV.EditItemIndex = -1; grdCOSOV.ShowFooter = true; _wc.UpdateCostUpdates(ViewState["EstNum"].ToString(), ViewState["twc_project_number"].ToString()); this.DisplayCOSOVGrid(); }
private void BindItemNumber() { project_invoice _pi = new project_invoice(); DataSet dsGrp = new DataSet(); dsGrp = _pi.GetHashtableData(); if (dsGrp.Tables[0].Rows.Count > 0) { ddlNo.DataSource = dsGrp; ddlNo.DataValueField = "seq_value"; ddlNo.DataTextField = "seq_value"; ddlNo.DataBind(); } }
private void BindItemNumber() { project_invoice _pi = new project_invoice(); DataSet dsGrp = new DataSet(); dsGrp = _pi.GetHashtableData(); if (dsGrp.Tables[0].Rows.Count > 0) { ddlNo.DataSource = dsGrp; ddlNo.DataValueField = "seq_value"; ddlNo.DataTextField = "seq_value"; ddlNo.DataBind(); } }
protected void btnnew_Click(object sender, EventArgs e) { try { Boolean BoolIns = false; project_invoice _pi = new project_invoice(); BoolIns = _pi.MaintainInvoiceRecords(ViewState["twc_project_number"].ToString(), txtSubmitDate.Text.Trim(), txtReceivedDate.Text.Trim(), txtApprDate.Text.Trim(), txtfabCost.Text.Trim(), txtInstCost.Text.Trim(), txtMatCost.Text.Trim(), txtBseContract.Text.Trim(), txtChangeOrder.Text.Trim(), txtDescription.Text.Trim(), ddlNo.SelectedItem.Value); if (BoolIns) { lblMsg.Text = "Invoice is added"; } else { lblMsg.Text = "There is an error occured"; } Response.Write("<script language='javascript'>parent.location.replace('Whitfield_projectInvoice.aspx?EstNum=" + ViewState["EstNum"].ToString() + "&twc_project_number=" + ViewState["twc_project_number"].ToString() + "');</script>"); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } }
protected void btnnew_Click(object sender, EventArgs e) { try { Boolean BoolIns = false; project_invoice _pi = new project_invoice(); BoolIns = _pi.MaintainInvoiceRecords(ViewState["twc_project_number"].ToString(),txtSubmitDate.Text.Trim(),txtReceivedDate.Text.Trim(),txtApprDate.Text.Trim(), txtfabCost.Text.Trim(),txtInstCost.Text.Trim(),txtMatCost.Text.Trim(),txtBseContract.Text.Trim(),txtChangeOrder.Text.Trim(), txtDescription.Text.Trim(),ddlNo.SelectedItem.Value); if (BoolIns) { lblMsg.Text = "Invoice is added"; } else { lblMsg.Text = "There is an error occured"; } Response.Write("<script language='javascript'>parent.location.replace('Whitfield_projectInvoice.aspx?EstNum=" + ViewState["EstNum"].ToString() + "&twc_project_number=" + ViewState["twc_project_number"].ToString() + "');</script>"); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } }
protected void btnnew_Click(object sender, EventArgs e) { try { Boolean BoolIns = false; project_invoice _pi = new project_invoice(); Whitfield_Project _wc = new Whitfield_Project(); BoolIns = _pi.MaintainChangeOrderSOVRecords(ViewState["twc_project_number"].ToString(), ddlNo.SelectedItem.Value, txtCONumber.Text.Trim(), txtDescription.Text.Trim(), txtAmt.Text.Trim(),txtSubmitDate.Text.Trim(),txtApprDate.Text.Trim(),txtComments.Text.Trim()); _wc.UpdateCostUpdates(ViewState["EstNum"].ToString(), ViewState["twc_project_number"].ToString()); if (BoolIns) { lblMsg.Text = "Schedule of Value is added"; } else { lblMsg.Text = "There is an error occured"; } Response.Write("<script language='javascript'>parent.location.replace('Whitfield_projectInvoice.aspx?EstNum=" + ViewState["EstNum"].ToString() + "&twc_project_number=" + ViewState["twc_project_number"].ToString() + "');</script>"); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } }
protected void btnnew_Click(object sender, EventArgs e) { try { Boolean BoolIns = false; project_invoice _pi = new project_invoice(); Whitfield_Project _wc = new Whitfield_Project(); BoolIns = _pi.MaintainChangeOrderSOVRecords(ViewState["twc_project_number"].ToString(), ddlNo.SelectedItem.Value, txtCONumber.Text.Trim(), txtDescription.Text.Trim(), txtAmt.Text.Trim(), txtSubmitDate.Text.Trim(), txtApprDate.Text.Trim(), txtComments.Text.Trim()); _wc.UpdateCostUpdates(ViewState["EstNum"].ToString(), ViewState["twc_project_number"].ToString()); if (BoolIns) { lblMsg.Text = "Schedule of Value is added"; } else { lblMsg.Text = "There is an error occured"; } Response.Write("<script language='javascript'>parent.location.replace('Whitfield_projectInvoice.aspx?EstNum=" + ViewState["EstNum"].ToString() + "&twc_project_number=" + ViewState["twc_project_number"].ToString() + "');</script>"); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } }
private DataSet Summary_Queue() { DataSet dsRpAdvances = new DataSet(); try { project_invoice _wc = new project_invoice(); dsRpAdvances = _wc.GetProjectInvoices(); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } return dsRpAdvances; }
public void grdProjects_Itemcommand(Object sender, DataGridCommandEventArgs e) { Int32 _twc_proj_number_ID = 0; DataSet dsExpand = new DataSet(); project_invoice _pi = new project_invoice(); switch (e.CommandName) { case "Expand": { _twc_proj_number_ID = Convert.ToInt32(grdProjects.DataKeys[Convert.ToInt32(e.Item.ItemIndex)]); _twc_proj_number_ID = Convert.ToInt32(grdProjects.DataKeys[e.Item.ItemIndex]); dsExpand = _pi.GetInvoiceforProject(Convert.ToInt32(_twc_proj_number_ID.ToString())); PlaceHolder exp = new PlaceHolder(); exp = (System.Web.UI.WebControls.PlaceHolder)e.Item.Cells[10].FindControl("ExpandedContent"); ImageButton img = new ImageButton(); img = (System.Web.UI.WebControls.ImageButton)e.Item.Cells[0].FindControl("btnExpand"); if (dsExpand.Tables[0].Rows.Count > 0) { if (img.ImageUrl == "assets/img/Plus.gif") { img.ImageUrl = "assets/img/Minus.gif"; exp.Visible = true; ((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).Visible = true; ((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).ProjectNumber = _twc_proj_number_ID; ((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).FetchSubMaterials(dsExpand); } else { exp.Visible = false; ((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).Visible = false; img.ImageUrl = "assets/img/Plus.gif"; } } else { if (img.ImageUrl == "assets/img/Plus.gif") { //((ViewDesignAdmin)(e.Item.FindControl("DynamicTable1"))).Visible = true; img.ImageUrl = "assets/img/Minus.gif"; exp.Visible = true; ((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).Visible = true; ((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).ProjectNumber = _twc_proj_number_ID; ((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).FetchSubMaterials(dsExpand); } else { exp.Visible = false; ((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).Visible = false; img.ImageUrl = "assets/img/Plus.gif"; } } break; } default: { break; } } }
private void DisplayGrid(Int32 material_id) { try { project_invoice _pi = new project_invoice(); DataSet _dsInvoices = new DataSet(); _dsInvoices = _pi.GetInvoiceforProject(Convert.ToInt32(ViewState["twc_project_number"].ToString())); PopulateDataGrid(_dsInvoices, grdinv); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } }
public void grdpl1_DeleteCommand(object sender, DataGridCommandEventArgs e) { String DetailId = ""; DetailId = grdpl1.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString(); project_invoice _dbClass = new project_invoice(); _dbClass.DeleteInvoice(Convert.ToInt32(ViewState["twc_project_number"].ToString()),DetailId); this.DisplayGrid(); }
private void DisplaySOVGrid() { try { project_invoice _pi = new project_invoice(); DataSet _dsSOV = new DataSet(); _dsSOV = _pi.GetInvoiceSOVforProject(Convert.ToInt32(ViewState["twc_project_number"].ToString())); PopulateDataGrid(_dsSOV, grdSOV); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } }
protected void btnnew_Click(object sender, EventArgs e) { try { project_invoice _pi = new project_invoice(); _pi.UpdateProjectInfo(Convert.ToInt32(ViewState["EstNum"].ToString()),Convert.ToInt32(ViewState["twc_project_number"].ToString()),txtInitialPaymentDate.Text.Trim(),txtFinalPaymentDate.Text.Trim(),ddlContacts.SelectedItem.Value,txtOrigContract.Text.Trim(),txtChangeOrder.Text.Trim()); BindPage(Convert.ToInt32(ViewState["EstNum"].ToString()), Convert.ToInt32(ViewState["twc_project_number"].ToString())); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } }
public void grdpl1_UpdateCommand(object sender, DataGridCommandEventArgs e) { String InvoiceID = grdpl1.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString(); project_invoice _pi = new project_invoice(); _pi.MaintainInvoiceRecords(ViewState["twc_project_number"].ToString(), ((TextBox)(e.Item.FindControl("txtDate_Submited"))).Text, ((TextBox)(e.Item.FindControl("txtDate_Received"))).Text, ((TextBox)(e.Item.FindControl("txtDate_Approved"))).Text, ((TextBox)(e.Item.FindControl("txtfab_lab_Cost"))).Text, ((TextBox)(e.Item.FindControl("txtIns_lab_Cost"))).Text, ((TextBox)(e.Item.FindControl("txtMaterial_cost"))).Text, ((TextBox)(e.Item.FindControl("txtBase_contract"))).Text, ((TextBox)(e.Item.FindControl("txtChange_order"))).Text, ((TextBox)(e.Item.FindControl("txtInvoice_comments"))).Text, InvoiceID); grdpl1.EditItemIndex = -1; grdpl1.ShowFooter = true; this.DisplayGrid(); }
public Boolean UpdateCostUpdates(String EstNum, String TWC_Proj_Number) { try { project_invoice _pi = new project_invoice(); String sqlCommand = ""; Database db = DatabaseFactory.CreateDatabase(); sqlCommand = " UPDATE Whitfield_ProjectInfo SET " + " [O_Contract_Value] = @O_Contract_Value " + " ,[Change_Order_Value] = @Change_Order_Value " + " WHERE EstNum = @EstNum and TWC_proj_number=@TWC_proj_number"; DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand); db.AddInParameter(dbCommand, "@EstNum", DbType.Int32, Convert.ToInt32(EstNum)); db.AddInParameter(dbCommand, "@TWC_proj_number", DbType.Int32, Convert.ToInt32(TWC_Proj_Number)); db.AddInParameter(dbCommand, "@O_Contract_Value", DbType.String, _pi.GetOriginalContractValue(Convert.ToInt32(TWC_Proj_Number)).ToString()); db.AddInParameter(dbCommand, "@Change_Order_Value", DbType.String, _pi.GetChangeOrderValue(Convert.ToInt32(TWC_Proj_Number)).ToString()); db.ExecuteNonQuery(dbCommand); return true; } catch (Exception ex) { HttpResponse objResponse = HttpContext.Current.Response; objResponse.Write(ex.Message); return false; } }