protected void Page_Load(object sender, EventArgs e) { Whitfield_Project _wc = new Whitfield_Project(); if (!Page.IsPostBack) { BindCompetition(); // 1 Get collection NameValueCollection n = Request.QueryString; // 2 See if any query string exists if (n.HasKeys()) { // 3 Get first key and value string k = n.GetKey(0); string v = n.Get(0); string v1 = n.Get(1); // 4 // Test different keys EstNum = Convert.ToInt32(v); twc_project_number = Convert.ToInt32(v1); hidEstNum.Value = EstNum.ToString(); hidtwcProjNumber.Value = twc_project_number.ToString(); ViewState["EstNum"] = EstNum.ToString(); ViewState["twc_project_number"] = twc_project_number.ToString(); } } }
protected void btnnew_Click(object sender, EventArgs e) { Whitfield_Project _wc = new Whitfield_Project(); _wc.AddBidAmount(Convert.ToInt32(ViewState["EstNum"].ToString()), Convert.ToInt32(ViewState["twc_proj_number"].ToString()), Convert.ToInt32(ViewState["Compeid"].ToString()), txtBidAmt.Text); // lblMsg.Text = "Your record is added successfully."; Response.Write("<script language='javascript'>parent.location.replace('Whitfield_projectInfo.aspx?EstNum=" + ViewState["EstNum"].ToString() + "&twc_project_number=" + ViewState["twc_proj_number"].ToString() + "');</script>"); }
public DataSet FetchReportActivity() { DataSet dsGrp = new DataSet(); Whitfield_Project wUser = new Whitfield_Project(); dsGrp = wUser.GetWorkOrders(ViewState["EstNum"].ToString(), Convert.ToInt32(ViewState["twc_project_number"].ToString())); return dsGrp; }
protected void Page_Load(object sender, EventArgs e) { Whitfield_Project _wc = new Whitfield_Project(); if (!Page.IsPostBack) { // 1 Get collection NameValueCollection n = Request.QueryString; // 2 See if any query string exists if (n.HasKeys()) { // 3 Get first key and value string k = n.GetKey(0); string v = n.Get(0); string v1 = n.Get(1); string v2 = n.Get(2); // 4 // Test different keys Compeid = Convert.ToInt32(v); EstNum = Convert.ToInt32(v1); twc_proj_number = Convert.ToInt32(v2); hidEstNum.Value = EstNum.ToString(); hidProjNumber.Value = twc_proj_number.ToString(); txtBidAmt.Text = _wc.GetBidAmt(EstNum, Compeid,twc_proj_number); txtClientName.Text = _wc.GetClientName(EstNum,twc_proj_number); txtEstName.Text = _wc.GetProjectName(EstNum,twc_proj_number); } ViewState["EstNum"] = EstNum.ToString(); ViewState["twc_proj_number"] = twc_proj_number.ToString(); ViewState["Compeid"] = Compeid.ToString(); } }
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(); }
protected void btnnew_Click(object sender, EventArgs e) { Whitfield_Project _wc = new Whitfield_Project(); //ArrayList chkArray = GetSelectedItems(ChkProjContacts for (int i = 0; i < RdoPrjClient.Items.Count; i++) { if (RdoPrjClient.Items[i].Selected) _wc.AddPrimaryContact(Convert.ToInt32(ViewState["EstNum"].ToString()), Convert.ToInt32(ViewState["twc_project_number"].ToString()), Convert.ToInt32(ViewState["Clientid"].ToString()), Convert.ToInt32(RdoPrjClient.Items[i].Value)); } Response.Write("<script language='javascript'>parent.location.replace('Whitfield_projectInfo.aspx?EstNum=" + ViewState["EstNum"].ToString() + "&twc_project_number=" + ViewState["twc_project_number"].ToString() + "');</script>"); }
protected void btnnew_Click(object sender, EventArgs e) { Whitfield_Project _wc = new Whitfield_Project(); _wc.DeleteProjectCompe(Convert.ToInt32(ViewState["EstNum"].ToString()), Convert.ToInt32(ViewState["twc_project_number"].ToString())); for (int i = 0; i < ChkProjContacts.Items.Count; i++) { if (ChkProjContacts.Items[i].Selected) _wc.PopulateProject_compe(Convert.ToInt32(ViewState["EstNum"].ToString()),Convert.ToInt32(ViewState["twc_project_number"].ToString()), Convert.ToInt32(ChkProjContacts.Items[i].Value)); } //lblMsg.Text = "Your record is added successfully."; Response.Write("<script language='javascript'>parent.location.replace('Whitfield_projectInfo.aspx?EstNum=" + ViewState["EstNum"].ToString() + "&twc_project_number=" + ViewState["twc_project_number"].ToString() + "');</script>"); }
public void BindProjects() { DataSet dsGrp = new DataSet(); Whitfield_Project wProjects = new Whitfield_Project(); dsGrp = wProjects.GetProjectInfo(); if (dsGrp.Tables[0].Rows.Count > 0) { ddlProject.DataSource = dsGrp; ddlProject.DataTextField = "ProjName"; ddlProject.DataValueField = "EstNum"; ddlProject.DataBind(); ddlProject.Items.Insert(0, common.AddItemToList("Select Project", "0")); } }
public void BindWorkOrders() { DataSet dsGrp = new DataSet(); Whitfield_Project wUser = new Whitfield_Project(); dsGrp = wUser.GetWorkOrders(ViewState["EstNum"].ToString(), Convert.ToInt32(ViewState["twc_project_number"].ToString())); if (dsGrp.Tables[0].Rows.Count > 0) { ddlworkorders.DataSource = dsGrp; ddlworkorders.DataTextField = "WODesc"; ddlworkorders.DataValueField = "work_order_id"; ddlworkorders.DataBind(); ddlworkorders.Items.Insert(0, common.AddItemToList("Select WorkOrder", "0")); } }
protected void btnnew_Click(object sender, EventArgs e) { Int32 twc_prj_number=0; String EstNum = ""; Whitfield_Project wUser = new Whitfield_Project(); // wUser.DeleteProjectClient(Convert.ToInt32(ViewState["EstNum"].ToString())); //ArrayList chkArray = GetSelectedItems(ChkProjContacts for (int i = 0; i < RdoAwdProjects.Items.Count; i++) { if (RdoAwdProjects.Items[i].Selected) { EstNum = RdoAwdProjects.Items[i].Value.ToString(); twc_prj_number = wUser.SetUpProjecs(Convert.ToInt32(RdoAwdProjects.Items[i].Value)); } } //Server.Transfer("Whitfield_projectInfo.aspx?EstNum=" + EstNum + "&twc_project_number=" + twc_prj_number.ToString()); Response.Write("<script language='javascript'>parent.location.replace('Whitfield_projectInfo.aspx?EstNum=" + EstNum + "&twc_project_number=" + twc_prj_number.ToString() + "');</script>"); }
protected void Page_Load(object sender, EventArgs e) { Whitfield_Project _wc = new Whitfield_Project(); // 1 // Get collection NameValueCollection n = Request.QueryString; if (!Page.IsPostBack) { // See if any query string exists if (n.HasKeys()) { // 3 // Get first key and value string k = n.GetKey(0); string v = n.Get(0); string v1 = n.Get(1); string v2 = n.Get(2); ShowTheFile(v.ToString(), v1.ToString(),v2.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 Project_clients() { DataSet dsRpAdvances = new DataSet(); try { Whitfield_Project _wc = new Whitfield_Project(); dsRpAdvances = _wc.GetContactsForProject(Convert.ToInt32(ViewState["EstNum"].ToString()), Convert.ToInt32(ViewState["twc_project_number"].ToString()),Convert.ToInt32(ddlwonclient.SelectedItem.Value)); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } return dsRpAdvances; }
protected void btnsaveparameters_Click(object sender, EventArgs e) { Whitfield_Project wc = new Whitfield_Project(); try { Boolean IsUpdateSuccess = false; IsUpdateSuccess = wc.UpdateCostUpdates( ViewState["EstNum"].ToString(), ViewState["twc_project_number"].ToString(), txtOrigContract.Text.Trim(), txtChangeOrder.Text.Trim() ); } catch (Exception ex) { Response.Write(ex.Message); } }
public void FetchAndBind(Int32 _estNum, Int32 twc_project_number) { DataSet dsInstallers; Whitfield_Project _wc = new Whitfield_Project(); whitfield_reports _wr = new whitfield_reports(); bindcontrols(_estNum,twc_project_number); IDataReader iReader = _wc.GetProjectInfo(_estNum, twc_project_number); // ' Loop through the DataReader and write out each entry while (iReader.Read()) { txttwcPrjNumber.Text = twc_project_number.ToString().Trim(); txtrealPrjNumber.Text = iReader["Real_proj_Number"] == DBNull.Value ? "" : iReader["Real_proj_Number"].ToString(); txtClientPrjNumber.Text = iReader["client_proj_number"] == DBNull.Value ? "" : iReader["client_proj_number"].ToString(); txtContractNumber.Text = iReader["contract_number"] == DBNull.Value ? "" : iReader["contract_number"].ToString(); txtprjname.Text = iReader["ProjName"] == DBNull.Value ? "" : iReader["ProjName"].ToString(); lblPrjHeader.Text = iReader["ProjName"] == DBNull.Value ? "" : iReader["ProjName"].ToString(); txtfinalbid.Text = iReader["FinalPrice"] == DBNull.Value ? "" : iReader["FinalPrice"].ToString(); txtdesc.Text = iReader["ProjDescr"] == DBNull.Value ? "" : iReader["ProjDescr"].ToString(); txtNotes.Text = iReader["Notes"] == DBNull.Value ? "" : iReader["Notes"].ToString(); txtConstStdate.Text = iReader["ConstrStart"] == DBNull.Value ? "" : iReader["ConstrStart"].ToString(); txtConstDuration.Text = iReader["ConstrDur"] == DBNull.Value ? "" : iReader["ConstrDur"].ToString(); txtConstEndDate.Text = iReader["ConstrCompl"] == DBNull.Value ? "" : iReader["ConstrCompl"].ToString(); txtOverheadCost.Text = iReader["OverheadCost"] == DBNull.Value ? "" : iReader["OverheadCost"].ToString(); txtMatContCost.Text = iReader["MatContCost"] == DBNull.Value ? "" : iReader["MatContCost"].ToString(); //txtCurrentContract.Text = iReader["C_Contract_Value"] == DBNull.Value ? "" : iReader["C_Contract_Value"].ToString(); txtOrigContract.Text = iReader["O_Contract_Value"] == DBNull.Value ? "0" : iReader["O_Contract_Value"].ToString(); txtChangeOrder.Text = iReader["Change_Order_Value"] == DBNull.Value ? "0" : iReader["Change_Order_Value"].ToString(); lblCurrentContract.Text = (Convert.ToDecimal(txtOrigContract.Text) + Convert.ToDecimal(txtChangeOrder.Text)).ToString(); //Construction_Start_Date = iReader["ConstrStart"] == DBNull.Value ? "" : iReader["ConstrStart"].ToString(); //Construction_End_Date = iReader["ConstrCompl"] == DBNull.Value ? "" : iReader["ConstrCompl"].ToString(); ViewState["Construction_Start_Date"] = iReader["ConstrStart"] == DBNull.Value ? "" : iReader["ConstrStart"].ToString(); ViewState["Construction_End_Date"] = iReader["ConstrCompl"] == DBNull.Value ? "" : iReader["ConstrCompl"].ToString(); String wincompe = iReader["WinMill"] == DBNull.Value ? "" : iReader["WinMill"].ToString(); String winclient = iReader["WinClient"] == DBNull.Value ? "" : iReader["WinClient"].ToString(); String prjType = iReader["ProjType"] == DBNull.Value ? "" : iReader["ProjType"].ToString(); ; String prjArch = iReader["Architect"] == DBNull.Value ? "" : iReader["Architect"].ToString(); String Status = iReader["Status"] == DBNull.Value ? "" : iReader["Status"].ToString(); ddlwonclient.SelectedIndex = ddlwonclient.Items.IndexOf(ddlwonclient.Items.FindByValue(winclient.ToString())); ddlprjtype.SelectedIndex = ddlprjtype.Items.IndexOf(ddlprjtype.Items.FindByValue(prjType.ToString())); ddlarchitect.SelectedIndex = ddlarchitect.Items.IndexOf(ddlarchitect.Items.FindByValue(prjArch.ToString())); ddlPrjStatus.SelectedIndex = ddlPrjStatus.Items.IndexOf(ddlPrjStatus.Items.FindByValue(Status.ToString())); dsInstallers = _wc.SelectInstallers(twc_project_number); if (dsInstallers.Tables[0].Rows.Count > 0) { foreach (DataRow dRow in dsInstallers.Tables[0].Rows) { String _cntlVal = dRow["Userid"].ToString(); ListItem currentCheckBox = chkInstallers.Items.FindByValue(_cntlVal.ToString().Trim()); if (currentCheckBox != null) { currentCheckBox.Selected = true; } } } } }
protected void btnnew_Click(object sender, EventArgs e) { Whitfield_Project _wc = new Whitfield_Project(); if (Page.IsValid) { Boolean IsInsertSuccess = false; IsInsertSuccess = _wc.InsertEstimateMain( ViewState["EstNum"].ToString(), ViewState["twc_project_number"].ToString(), txtprjname.Text.Trim(), txtdesc.Text.Trim(), txtNotes.Text.Trim(), ddlprjtype.SelectedItem.Value, txtConstStdate.Text.Trim(), txtConstEndDate.Text.Trim(), txtConstDuration.Text.Trim(), "0", ddlPrjStatus.SelectedItem.Value, "0", ddlwonclient.SelectedItem.Value, txtfinalbid.Text.Trim(), "N", ddlarchitect.SelectedItem.Value, "Y", "Y" ,txtClientPrjNumber.Text.Trim() ,txtContractNumber.Text.Trim(),txtMatContCost.Text.Trim(),txtOverheadCost.Text.Trim()); InsertInstallers(); lblMsg.Text = "Your record is added successfully."; } }
protected void Page_Load(object sender, EventArgs e) { Whitfield_Project _wc = new Whitfield_Project(); whitfield_prod_reports _wr = new whitfield_prod_reports(); NameValueCollection n = Request.QueryString; if (!Page.IsPostBack) { //Logic Here for the Project Daily Field Report if (n.HasKeys()) { // 3 // Get first key and value string k = n.GetKey(0); string v = n.Get(0); txtReportDate.Text = v; } else { txtReportDate.Text = _wr.GetCurrentDate().Trim(); } bindcontrols(); if (_wr.IsReportExists(txtReportDate.Text.Trim())) { DataSet _dsDailyRpt = _wr.GetReportForProject(txtReportDate.Text.Trim()); //txtReportDate.Text = _wr.GetCurrentDate(); DataTable dtUsr = _dsDailyRpt.Tables[0]; String _chkStatus = ""; foreach (DataRow dRow in dtUsr.Rows) { //txtRptNotes.Text = dRow["Daily_notes"] == DBNull.Value ? "" : dRow["Daily_notes"].ToString(); txtRptIssues.Text = dRow["Daily_comments"] == DBNull.Value ? "" : dRow["Daily_comments"].ToString(); //txtRptChangeOrderNotes.Text = dRow["Change_order_notes"] == DBNull.Value ? "" : dRow["Change_order_notes"].ToString(); _chkStatus = dRow["is_locked"] == DBNull.Value ? "" : dRow["is_locked"].ToString(); if (_chkStatus.Trim() == "Y") { chkActive.SelectedIndex = chkActive.Items.IndexOf(chkActive.Items.FindByValue(_chkStatus)); // btnWO.Visible = false; } } } //Logic for Project Daily Field Report Ends. } }
public Boolean InsertInstallers() { try { Whitfield_Project _wc = new Whitfield_Project(); _wc.DeleteInstallers(Convert.ToInt32(ViewState["twc_project_number"].ToString())); //ArrayList chkArray = GetSelectedItems(ChkProjContacts for (int i = 0; i < chkInstallers.Items.Count; i++) { if (chkInstallers.Items[i].Selected) _wc.PopulateProject_Installers(Convert.ToInt32(ViewState["twc_project_number"].ToString()), Convert.ToInt32(chkInstallers.Items[i].Value)); } return true; } catch (Exception ex) { HttpResponse objResponse = HttpContext.Current.Response; objResponse.Write(ex.Message); return false; } }
public void grdpl1_UpdateCommand(object sender, DataGridCommandEventArgs e) { //Response.Write("Comes In"); String DetailId = ""; DetailId = grdpl1.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString(); Whitfield_Project _wc = new Whitfield_Project(); _wc.UpdateWorkorders(DetailId, Convert.ToInt32(ViewState["EstNum"].ToString()), Convert.ToInt32(((TextBox)(e.Item.FindControl("txtMatCost"))).Text), (((TextBox)(e.Item.FindControl("txtLongDesc1"))).Text).ToString(), Convert.ToInt32(((TextBox)(e.Item.FindControl("txtfabhours"))).Text), Convert.ToInt32(((TextBox)(e.Item.FindControl("txtfinhours"))).Text), Convert.ToInt32(((TextBox)(e.Item.FindControl("txtinstallhours"))).Text), Convert.ToInt32(((TextBox)(e.Item.FindControl("txtEngHours"))).Text), Convert.ToInt32(((TextBox)(e.Item.FindControl("txtMiscHours"))).Text), (((TextBox)(e.Item.FindControl("txtNotes"))).Text).ToString(), "1"); grdpl1.EditItemIndex = -1; grdpl1.ShowFooter = true; this.DisplayGrid(); }
public void grdpl1_DeleteCommand(object sender, DataGridCommandEventArgs e) { String DetailId = ""; DetailId = grdpl1.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString(); Whitfield_Project _wc = new Whitfield_Project(); _wc.DeleteWorkOrders(DetailId, ViewState["twc_project_number"].ToString()); this.DisplayGrid(); }
private void BindPage(Int32 EstNum, Int32 ProjectNumber) { Whitfield_Project _wc = new Whitfield_Project(); try { IDataReader iReader = _wc.GetProjectInfo(Convert.ToInt32(EstNum), Convert.ToInt32(ProjectNumber)); while (iReader.Read()) { BindWinClientinfo(Convert.ToInt32(EstNum), Convert.ToInt32(ProjectNumber)); txtOrigContract.Text = iReader["O_Contract_Value"] == DBNull.Value ? "0" : iReader["O_Contract_Value"].ToString(); txtChangeOrder.Text = iReader["Change_Order_Value"] == DBNull.Value ? "0" : iReader["Change_Order_Value"].ToString(); lblCurrentContract.Text = (Convert.ToDecimal(txtOrigContract.Text) + Convert.ToDecimal(txtChangeOrder.Text)).ToString(); lblPrjHeader.Text = iReader["ProjName"] == DBNull.Value ? "" : iReader["ProjName"].ToString(); txtInitialPaymentDate.Text = iReader["Init_Payment_Date"] == DBNull.Value ? "" : iReader["Init_Payment_Date"].ToString(); txtFinalPaymentDate.Text = iReader["Final_Payment_Date"] == DBNull.Value ? "" : iReader["Final_Payment_Date"].ToString(); //String winclient = iReader["WinClient"] == DBNull.Value ? "" : iReader["WinClient"].ToString(); String winclient = _wc.GetWinningClient(Convert.ToInt32(EstNum)); String Payment_point_of_contact = iReader["Payment_point_of_contact"] == DBNull.Value ? "" : iReader["Payment_point_of_contact"].ToString(); //Response.Write("Wining Client:" + winclient); BindContacts(Convert.ToInt32(winclient)); ddlContacts.SelectedIndex = ddlContacts.Items.IndexOf(ddlContacts.Items.FindByValue(Payment_point_of_contact.ToString())); BindYears(); BindMonths(); BindWeeks(); string strMonth = DateTime.Now.ToString("MMMM"); string strYear = DateTime.Now.ToString("yyyy"); ddlMonth.SelectedIndex = ddlMonth.Items.IndexOf(ddlMonth.Items.FindByValue(strMonth.ToString())); ddlYear.SelectedIndex = ddlYear.Items.IndexOf(ddlYear.Items.FindByValue(strYear.ToString())); } DisplayGrid(); DisplaySOVGrid(); DisplayCOSOVGrid(); DisplayHistoryNotes(); DisplaySchedulingGrid(); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } }
public void BindWorkOrders() { DataSet dsGrp = new DataSet(); Whitfield_Project wUser = new Whitfield_Project(); ddlworkorders.Items.Clear(); dsGrp = wUser.GetWorkOrders(ddlProject.SelectedItem.Value); if (dsGrp.Tables[0].Rows.Count > 0) { ddlworkorders.DataSource = dsGrp; ddlworkorders.DataTextField = "woid"; ddlworkorders.DataValueField = "work_order_id"; ddlworkorders.DataBind(); ddlworkorders.Items.Insert(0, common.AddItemToList("Select WorkOrder", "0")); } else { ddlworkorders.Items.Insert(0, common.AddItemToList("No workorders available", "0")); } }
private DataSet Summary_Queue() { DataSet dsRpAdvances = new DataSet(); try { Whitfield_Project _wc = new Whitfield_Project(); dsRpAdvances = _wc.GetInsallerAssignedProjects(Convert.ToInt32(Request.Cookies["useridentifier"].Value.Trim())); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } return dsRpAdvances; }
private void BindInstallers() { DataSet dsGrp = new DataSet(); Whitfield_Project wUser = new Whitfield_Project(); dsGrp = wUser.GetInstallers(); if (dsGrp.Tables[0].Rows.Count > 0) { chkInstallers.DataSource = dsGrp; chkInstallers.DataTextField = "InstallerName"; chkInstallers.DataValueField = "UserId"; chkInstallers.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { Whitfield_Project _wc = new Whitfield_Project(); whitfield_reports _wr = new whitfield_reports(); // 1 // Get collection NameValueCollection n = Request.QueryString; if (!Page.IsPostBack) { // See if any query string exists if (n.HasKeys()) { // 3 // Get first key and value string k = n.GetKey(0); string v = n.Get(0); string k1 = n.GetKey(1); string v1 = n.Get(1); if (Request.QueryString["hFlag"] == "D") { _wc.DeleteProjDocument(Convert.ToInt32(Request.QueryString["EstNum"]), Convert.ToInt32(Request.QueryString["seqno"]), Convert.ToInt32(Request.QueryString["twcProjNumber"])); ViewState["EstNum"] = Request.QueryString["EstNum"].ToString(); ViewState["twc_project_number"] = Request.QueryString["twcProjNumber"].ToString(); twc_project_number = Convert.ToInt32(Request.QueryString["twcProjNumber"].ToString()); DataSet dsGridResults = this.GetDocs(); this.PopulateDataGrid(dsGridResults, grddocs); } //Check for QueryString Date if (k == "ReportDate") { txtReportDate.Text = v; twc_project_number = Convert.ToInt32(v1); EstNum = Convert.ToInt32(Request.QueryString["EstNum"].ToString()); ViewState["EstNum"] = Request.QueryString["EstNum"].ToString(); ViewState["twc_project_number"] = twc_project_number; txtwhitPrjNumber.Text = twc_project_number.ToString() ; txtrealPrjNumber.Text = _wc.GetReal_proj_Number(twc_project_number).ToString(); this.FetchAndBind(EstNum, twc_project_number); ActiveIndexNumber = 4; } else { txtReportDate.Text = _wr.GetCurrentDate().Trim(); twc_project_number = Convert.ToInt32(v1); ViewState["EstNum"] = EstNum; ViewState["twc_project_number"] = twc_project_number; txtwhitPrjNumber.Text = ViewState["twc_project_number"].ToString(); txtrealPrjNumber.Text = _wc.GetReal_proj_Number(Convert.ToInt32(ViewState["twc_project_number"].ToString())).ToString(); this.FetchAndBind(EstNum, twc_project_number); } if (k == "EstNum") { EstNum = Convert.ToInt32(v); // Here goes the code for the creation of new EstNum twc_project_number = Convert.ToInt32(v1); ViewState["EstNum"] = EstNum; ViewState["twc_project_number"] = twc_project_number; //txtReportDate.Text = _wr.GetCurrentDate().Trim(); txtwhitPrjNumber.Text = ViewState["twc_project_number"].ToString(); txtrealPrjNumber.Text = _wc.GetReal_proj_Number(Convert.ToInt32(ViewState["twc_project_number"].ToString())).ToString(); this.FetchAndBind(EstNum, twc_project_number); } } else { if (n.HasKeys()) { string k = n.GetKey(0); string v = n.Get(0); string k1 = n.GetKey(1); string v1 = n.Get(1); if (k == "EstNum") { EstNum = Convert.ToInt32(v); // Here goes the code for the creation of new EstNum twc_project_number = Convert.ToInt32(v1); ViewState["EstNum"] = EstNum; ViewState["twc_project_number"] = twc_project_number; //txtReportDate.Text = _wr.GetCurrentDate().Trim(); txtwhitPrjNumber.Text = ViewState["twc_project_number"].ToString(); txtrealPrjNumber.Text = _wc.GetReal_proj_Number(Convert.ToInt32(ViewState["twc_project_number"].ToString())).ToString(); this.FetchAndBind(EstNum, twc_project_number); } } else { EstNum = Convert.ToInt32(ViewState["EstNum"].ToString()); twc_project_number = Convert.ToInt32(ViewState["twc_project_number"].ToString()); //txtReportDate.Text = _wr.GetCurrentDate().Trim(); txtwhitPrjNumber.Text = ViewState["twc_project_number"].ToString(); txtrealPrjNumber.Text = _wc.GetReal_proj_Number(Convert.ToInt32(ViewState["twc_project_number"].ToString())).ToString(); this.FetchAndBind(EstNum, twc_project_number); } } Response.Cookies["EstNum"].Value = EstNum.ToString(); Response.Cookies["twc_project_number"].Value = twc_project_number.ToString(); hdnEstNum.Value = EstNum.ToString(); hdntwcProjNumber.Value = twc_project_number.ToString(); //Bind the clients and competition and Conversation Log try { grdclients.PageSize = _DEFAULTPAGESIZE; DataSet dsGridResults; dsGridResults = this.Project_clients(); this.PopulateDataGrid(dsGridResults, grdclients); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } //GetDocumentsforProject try { grddocs.PageSize = _DEFAULTPAGESIZE; DataSet dsGridResults; dsGridResults = this.GetDocs(); this.PopulateDataGrid(dsGridResults, grddocs); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } //Logic Here for the Project Daily Field Report // if (_wr.IsReportExists(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text)) if (_wr.IsReportExists(twc_project_number, txtReportDate.Text)) { DataSet _dsDailyRpt = _wr.GetReportForProject(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim()); //txtReportDate.Text = _wr.GetCurrentDate(); DataTable dtUsr = _dsDailyRpt.Tables[0]; String _chkStatus = ""; foreach (DataRow dRow in dtUsr.Rows) { txtRptNotes.Text = dRow["Daily_notes"] == DBNull.Value ? "" : dRow["Daily_notes"].ToString(); txtRptIssues.Text = dRow["Daily_comments"] == DBNull.Value ? "" : dRow["Daily_comments"].ToString(); txtRptChangeOrderNotes.Text = dRow["Change_order_notes"] == DBNull.Value ? "" : dRow["Change_order_notes"].ToString(); _chkStatus = dRow["is_locked"] == DBNull.Value ? "" : dRow["is_locked"].ToString(); if (_chkStatus.Trim() == "Y") { chkActive.SelectedIndex = chkActive.Items.IndexOf(chkActive.Items.FindByValue(_chkStatus)); } } } //Logic for Project Daily Field Report Ends. Whitfieldcore _wc1 = new Whitfieldcore(); lblTotAnnFabHours.Text = _wc1.GetTotalFabricationHours(twc_project_number.ToString()); lblTotScheduledHours.Text = _wc1.GetTotalscheduledHours(twc_project_number); //GetTotalFabricationHours } else { //pHprojClient.Visible = true; //pHprojcompe.Visible = true; } tabgeneral.ActiveTabIndex = ActiveIndexNumber; }
private DataSet Project_competition() { DataSet dsRpAdvances = new DataSet(); try { Whitfield_Project _wc = new Whitfield_Project(); dsRpAdvances = _wc.GetCompetitonForProject(Convert.ToInt32(ViewState["EstNum"].ToString()), Convert.ToInt32(ViewState["twc_project_number"].ToString())); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } return dsRpAdvances; }
protected void Page_Load(object sender, EventArgs e) { Whitfield_Project _wc = new Whitfield_Project(); whitfield_reports _wr = new whitfield_reports(); // 1 // Get collection NameValueCollection n = Request.QueryString; if (!Page.IsPostBack) { // See if any query string exists if (n.HasKeys()) { // 3 // Get first key and value string k = n.GetKey(0); string v = n.Get(0); string k1 = n.GetKey(1); string v1 = n.Get(1); //Check for QueryString Date if (k == "ReportDate") { txtReportDate.Text = v; twc_project_number = Convert.ToInt32(v1); EstNum = Convert.ToInt32(Request.QueryString["EstNum"].ToString()); ViewState["EstNum"] = Request.QueryString["EstNum"].ToString(); ViewState["twc_project_number"] = twc_project_number; txtwhitPrjNumber.Text = twc_project_number.ToString(); //this.FetchAndBind(EstNum, twc_project_number); bindcontrols(EstNum, twc_project_number); } else { txtReportDate.Text = _wr.GetCurrentDate().Trim(); twc_project_number = Convert.ToInt32(v1); ViewState["EstNum"] = EstNum; ViewState["twc_project_number"] = twc_project_number; txtwhitPrjNumber.Text = ViewState["twc_project_number"].ToString(); //this.FetchAndBind(EstNum, twc_project_number); bindcontrols(EstNum, twc_project_number); } if (k == "EstNum") { EstNum = Convert.ToInt32(v); // Here goes the code for the creation of new EstNum twc_project_number = Convert.ToInt32(v1); ViewState["EstNum"] = EstNum; ViewState["twc_project_number"] = twc_project_number; //txtReportDate.Text = _wr.GetCurrentDate().Trim(); txtwhitPrjNumber.Text = ViewState["twc_project_number"].ToString(); //this.FetchAndBind(EstNum, twc_project_number); bindcontrols(EstNum, twc_project_number); } } else { if (n.HasKeys()) { string k = n.GetKey(0); string v = n.Get(0); string k1 = n.GetKey(1); string v1 = n.Get(1); if (k == "EstNum") { EstNum = Convert.ToInt32(v); // Here goes the code for the creation of new EstNum twc_project_number = Convert.ToInt32(v1); ViewState["EstNum"] = EstNum; ViewState["twc_project_number"] = twc_project_number; txtwhitPrjNumber.Text = ViewState["twc_project_number"].ToString(); //this.FetchAndBind(EstNum, twc_project_number); bindcontrols(EstNum, twc_project_number); } } else { EstNum = Convert.ToInt32(ViewState["EstNum"].ToString()); twc_project_number = Convert.ToInt32(ViewState["twc_project_number"].ToString()); //txtReportDate.Text = _wr.GetCurrentDate().Trim(); txtwhitPrjNumber.Text = ViewState["twc_project_number"].ToString(); //this.FetchAndBind(EstNum, twc_project_number); bindcontrols(EstNum, twc_project_number); } } Response.Cookies["EstNum"].Value = EstNum.ToString(); Response.Cookies["twc_project_number"].Value = twc_project_number.ToString(); hdnEstNum.Value = EstNum.ToString(); hdntwcProjNumber.Value = twc_project_number.ToString(); //Logic Here for the Project Daily Field Report if (_wr.IsReportExists(twc_project_number, txtReportDate.Text)) { DataSet _dsDailyRpt = _wr.GetReportForProject(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim()); //txtReportDate.Text = _wr.GetCurrentDate(); DataTable dtUsr = _dsDailyRpt.Tables[0]; String _chkStatus = ""; foreach (DataRow dRow in dtUsr.Rows) { txtRptNotes.Text = dRow["Daily_notes"] == DBNull.Value ? "" : dRow["Daily_notes"].ToString(); txtRptIssues.Text = dRow["Daily_comments"] == DBNull.Value ? "" : dRow["Daily_comments"].ToString(); txtRptChangeOrderNotes.Text = dRow["Change_order_notes"] == DBNull.Value ? "" : dRow["Change_order_notes"].ToString(); _chkStatus = dRow["is_locked"] == DBNull.Value ? "" : dRow["is_locked"].ToString(); if (_chkStatus.Trim() == "Y") { chkActive.SelectedIndex = chkActive.Items.IndexOf(chkActive.Items.FindByValue(_chkStatus)); } } } //Logic for Project Daily Field Report Ends. } else { //pHprojClient.Visible = true; //pHprojcompe.Visible = true; } }
private void BindWinClientinfo(Int32 EstNum,Int32 twc_project_number) { DataSet dsGrp = new DataSet(); Whitfield_Project wUser = new Whitfield_Project(); dsGrp = wUser.GetClientlistForProject(EstNum.ToString(),twc_project_number); if (dsGrp.Tables[0].Rows.Count > 0) { ddlwonclient.DataSource = dsGrp; ddlwonclient.DataTextField = "Name1"; ddlwonclient.DataValueField = "ClientID"; ddlwonclient.DataBind(); //ddlwonclient.Items.Insert(0, common.AddItemToList("Select", "0")); } else { ddlwonclient.Items.Insert(0, common.AddItemToList("No Clients Yet", "0")); } }
private void DisplayGrid() { Whitfield_Project _wc = new Whitfield_Project(); DataSet _dsWorkOrders = new DataSet(); _dsWorkOrders = _wc.GetWorkOrders(ViewState["EstNum"].ToString(), Convert.ToInt32(ViewState["twc_project_number"].ToString())); this.PopulateDataGrid(_dsWorkOrders); }