public void grdActivity_DeleteCommand(object sender, DataGridCommandEventArgs e) { String activity_id = ""; activity_id = grdActivity.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString(); whitfield_reports _wRep = new whitfield_reports(); _wRep.DeleteProjectActivity(activity_id); this.DisplayReportGrid(); DisplayHistoryGrid(); }
protected void btnSearch_Click(object sender, EventArgs e) { whitfield_reports _wRep = new whitfield_reports(); if (_wRep.IsReportExists(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim())) { DataSet _dsDailyRpt = _wRep.GetReportForProject(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim()); txtwhitPrjNumber.Text = ViewState["twc_project_number"].ToString(); 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)); } } DisplayReportGrid(); DisplayManPowerGrid(); DisplayHistoryGrid(); } else { txtRptNotes.Text = ""; txtRptIssues.Text = ""; txtRptChangeOrderNotes.Text = ""; txtManHours.Text = ""; //txtQty.Text = ""; DisplayReportGrid(); DisplayManPowerGrid(); DisplayHistoryGrid(); } }
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 btnmpdetails_Click(object sender, EventArgs e) { whitfield_reports _wc = new whitfield_reports(); Boolean IsInsertSuccess = false; IsInsertSuccess = _wc.ManageManpower(_wc.GetReportNumber(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim()), Convert.ToInt32(ddlEmplType.SelectedItem.Value), txtManHours.Text.Trim(), 0); DisplayReportGrid(); DisplayManPowerGrid(); DisplayHistoryGrid(); }
protected void btnactivity_Click(object sender, EventArgs e) { whitfield_reports _wc = new whitfield_reports(); Boolean IsInsertSuccess = false; IsInsertSuccess = _wc.ManageReportMain(txtReportDate.Text.Trim(), Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtRptNotes.Text.Trim(), txtRptIssues.Text.Trim(), txtRptChangeOrderNotes.Text.Trim(), chkActive.SelectedItem.Value.Trim(), Request.Cookies["UserId"].Value); if (IsInsertSuccess) { if (ddlworkorders.SelectedItem.Value != "0") { IsInsertSuccess = _wc.ManageReportActivityMain(_wc.GetReportNumber(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim()),ViewState["twc_project_number"].ToString(), ddlworkorders.SelectedItem.Value, txtHours.Text.Trim(), txtActComments.Text.Trim(), Request.Cookies["UserId"].Value); } if (ddlEmplType.SelectedItem.Value != "0") { Boolean isManPowerInsert = _wc.ManageManpower(_wc.GetReportNumber(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim()), Convert.ToInt32(ddlEmplType.SelectedItem.Value), txtManHours.Text.Trim(), 0); } } DisplayReportGrid(); DisplayManPowerGrid(); DisplayHistoryGrid(); }
public void sendEmail() { Whitfieldcore wCore = new Whitfieldcore(); whitfield_reports _wRep = new whitfield_reports(); MailMessage message = new MailMessage(); message.To.Add(System.Configuration.ConfigurationManager.AppSettings["devEmail"]); //Here is where we add the receipients. using (DataSet ds = wCore.GetRightDistributionList(Convert.ToInt32(ViewState["twc_project_number"].ToString())) ) //HHS Uncomment this portion when there is an email list. { DataTable dtUsr = ds.Tables[0]; if (dtUsr.Rows.Count > 0) { foreach (DataRow dRow in dtUsr.Rows) { string _email = dRow["Email"] == DBNull.Value ? "" : dRow["Email"].ToString(); message.To.Add(_email); } } } message.To.Add(System.Configuration.ConfigurationManager.AppSettings["AdminEmail"].ToString()); //This is commented by Harish on Friday, January 27th with the request of Jammie. //message.To.Add(System.Configuration.ConfigurationManager.AppSettings["PMEmail"].ToString()); message.From = new MailAddress(System.Configuration.ConfigurationManager.AppSettings["DFR_fromEmail"]); message.Subject = txtReportDate.Text.Trim() + " Daily Field Report:" + lblPrjHeader.Text.Trim(); message.IsBodyHtml = true; StringBuilder sb = new StringBuilder(); sb.Append("<html><head></head>"); sb.Append("<body>"); //Header sb.Append("<TABLE cellSpacing='0' cellPadding='0' width='100%' border='0'><TR>"); sb.Append("<TD><IMG height='80' alt='' src='http://www.whitfield-co.com/whitfield-co/assets/img/TWC%20Primary%20Logo1.JPG' border='0'></TD>"); sb.Append("<TD class='form1' vAlign='bottom' align='right' width='100%'><b>The Whitfield Corporation, Inc.,<br>"); sb.Append("P.O. Box 0385<br>"); sb.Append("Fulton, MD 20759<br>"); sb.Append("(301)-483-0791<br>"); sb.Append("(301)-483-0792</b><br>"); sb.Append("<IMG height='9' alt='' src='http://www.whitfield-co.com/whitfield-co/assets/img/images.gif' width='1'>"); sb.Append("</TD>"); sb.Append("</TR></TABLE>"); //EmployeeHours System.Drawing.ColorConverter colConvert = new ColorConverter(); DataGrid dgWorkOrders = new DataGrid(); dgWorkOrders.Font.Size = 9; dgWorkOrders.CssClass = "data"; dgWorkOrders.HeaderStyle.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("#60829F"); dgWorkOrders.HeaderStyle.CssClass = "subnav"; dgWorkOrders.HeaderStyle.Font.Bold = true; dgWorkOrders.ItemStyle.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("#EAEFF3"); dgWorkOrders.FooterStyle.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("#D9D9D9"); dgWorkOrders.DataSource = _wRep.GetReportActivityForProjectMail(_wRep.GetReportNumber(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim()), Convert.ToInt32(ViewState["twc_project_number"].ToString())); dgWorkOrders.DataBind(); StringBuilder SBEmployeeHours = new StringBuilder(); StringWriter SWEmployeeHours = new StringWriter(SBEmployeeHours); HtmlTextWriter htmlTWEmployeeHours = new HtmlTextWriter(SWEmployeeHours); dgWorkOrders.RenderControl(htmlTWEmployeeHours); string EmployeeHoursString = SBEmployeeHours.ToString(); sb.Append("<br><B>Work Executed for Today:</b><br>" + EmployeeHoursString); //Daily Work Performed Notes/Comments String StrRptNotes = ""; if (txtRptNotes.Text == "") { StrRptNotes = "None."; } else { StrRptNotes = txtRptNotes.Text.Trim(); } sb.Append("<TABLE cellSpacing='0' cellPadding='0' width='100%' border='0'><TR>"); sb.Append("<TD>"); sb.Append("<br><b>Daily Work Performed Notes/Comments:</b>" + StrRptNotes + "<br>"); sb.Append("</TD>"); sb.Append("</TR></TABLE>"); //Significant Issues/Impediments Notes/Comments: String StrRptIssues = ""; if (txtRptIssues.Text == "") { StrRptIssues = "None."; } else { StrRptIssues = txtRptIssues.Text.Trim(); } sb.Append("<TABLE cellSpacing='0' cellPadding='0' width='100%' border='0'><TR>"); sb.Append("<TD>"); sb.Append("<br><b>Significant Issues/Impediments Notes/Comments:</b>" + StrRptIssues + "<br>"); sb.Append("</TD>"); sb.Append("</TR></TABLE>"); //Change Order Work Notes/Comments String StrRptChangeOrderNotes = ""; if (txtRptChangeOrderNotes.Text == "") { StrRptChangeOrderNotes = "None."; } else { StrRptChangeOrderNotes = txtRptChangeOrderNotes.Text.Trim(); } sb.Append("<TABLE cellSpacing='0' cellPadding='0' width='100%' border='0'><TR>"); sb.Append("<TD>"); sb.Append("<br><b>Change Order Work Notes/Comments:</b>" + StrRptChangeOrderNotes + "<br>"); sb.Append("</TD>"); sb.Append("</TR></TABLE>"); //Man Power Detail DataGrid dg = new DataGrid(); dg.Font.Size = 9; dg.CssClass = "data"; dg.HeaderStyle.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("#60829F"); dg.HeaderStyle.CssClass = "subnav"; dg.HeaderStyle.Font.Bold = true; dg.ItemStyle.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("#EAEFF3"); dg.FooterStyle.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("#D9D9D9"); dg.DataSource = _wRep.GetManPowerEntriesMail(_wRep.GetReportNumber(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim())); dg.DataBind(); StringBuilder SBActivity = new StringBuilder(); StringWriter SWActivity = new StringWriter(SBActivity); HtmlTextWriter htmlTWActivity = new HtmlTextWriter(SWActivity); dg.RenderControl(htmlTWActivity); string ActivityString = SBActivity.ToString(); ////EmployeeHours //DataGrid dgWorkOrders = new DataGrid(); //dgWorkOrders.Font.Size = 9; //dgWorkOrders.CssClass = "data"; //dgWorkOrders.HeaderStyle.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("#60829F"); //dgWorkOrders.HeaderStyle.CssClass = "subnav"; //dgWorkOrders.HeaderStyle.Font.Bold = true; //dgWorkOrders.ItemStyle.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("#EAEFF3"); //dgWorkOrders.FooterStyle.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("#D9D9D9"); //dgWorkOrders.DataSource = _wRep.GetReportActivityForProjectMail(_wRep.GetReportNumber(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim()), Convert.ToInt32(ViewState["twc_project_number"].ToString())); //dgWorkOrders.DataBind(); //StringBuilder SBEmployeeHours = new StringBuilder(); //StringWriter SWEmployeeHours = new StringWriter(SBEmployeeHours); //HtmlTextWriter htmlTWEmployeeHours = new HtmlTextWriter(SWEmployeeHours); //dgWorkOrders.RenderControl(htmlTWEmployeeHours); //string EmployeeHoursString = SBEmployeeHours.ToString(); sb.Append("<br><b>Man Power Detail:</b><br>" + ActivityString); sb.Append("</body></html>"); message.Body = sb.ToString(); SmtpClient smtp = new SmtpClient(System.Configuration.ConfigurationManager.AppSettings["smtp"]); smtp.Send(message); }
public void grdManPower_UpdateCommand(object sender, DataGridCommandEventArgs e) { String ManPower_id = ""; ManPower_id = grdManPower.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString(); whitfield_reports _wRep = new whitfield_reports(); _wRep.UpdateManPowerActivity(Convert.ToInt32(ManPower_id), ((TextBox)(e.Item.FindControl("txtinstallhours"))).Text, 0); grdManPower.EditItemIndex = -1; grdManPower.ShowFooter = true; this.DisplayManPowerGrid(); }
public void grdManPower_DeleteCommand(object sender, DataGridCommandEventArgs e) { String ManPower_id = ""; ManPower_id = grdManPower.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString(); whitfield_reports _wRep = new whitfield_reports(); _wRep.DeleteManPowerEntries(ManPower_id); this.DisplayManPowerGrid(); }
public void grdActivity_UpdateCommand(object sender, DataGridCommandEventArgs e) { String activity_id = ""; activity_id = grdActivity.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString(); whitfield_reports _wRep = new whitfield_reports(); _wRep.UpdateReportActivity(Convert.ToInt32(activity_id), ((TextBox)(e.Item.FindControl("txtinstallhours"))).Text, (((TextBox)(e.Item.FindControl("txtNotes"))).Text).ToString()); grdActivity.EditItemIndex = -1; grdActivity.ShowFooter = true; this.DisplayReportGrid(); DisplayHistoryGrid(); }
private void DisplayReportGrid() { whitfield_reports _wRep = new whitfield_reports(); DataSet _dsRep = new DataSet(); _dsRep = _wRep.GetReportActivityForProject(_wRep.GetReportNumber(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim()), Convert.ToInt32(ViewState["twc_project_number"].ToString())); this.PopulateRepDataGrid(_dsRep); }
private void DisplayManPowerGrid() { whitfield_reports _wRep = new whitfield_reports(); DataSet _dsRep = new DataSet(); _dsRep = _wRep.GetManPowerEntries(_wRep.GetReportNumber(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim())); this.PopulateManPowerDataGrid(_dsRep); }
private void DisplayHistoryGrid() { whitfield_reports _wRep = new whitfield_reports(); DataSet _dsRep = new DataSet(); _dsRep = _wRep.GetFieldDailyReports(Convert.ToInt32(ViewState["twc_project_number"].ToString())); this.PopulateDataGrid(_dsRep, grdHistoryRpt); }
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; }
protected void ddlworkorders_SelectedIndexChanged(object sender, EventArgs e) { whitfield_reports _wr = new whitfield_reports(); DataSet dsNormal = new DataSet(); DataSet dsBudget = new DataSet(); dsNormal = _wr.GetBudgetHoursForWO(ViewState["EstNum"].ToString(), ddlworkorders.SelectedItem.Value); dsBudget = _wr.GetHoursTDForWO(ViewState["EstNum"].ToString(), ddlworkorders.SelectedItem.Value); DataSet dsCummTD = new DataSet(); DataSet dsCummBudget = new DataSet(); dsCummBudget = _wr.GetCummulativeBudgetHoursForWO(txtReportDate.Text.Trim()); dsCummTD = _wr.GetCummulativeHoursTDForWO(txtReportDate.Text.Trim()); lblinstbud.Text = "0"; lblInstbudTD.Text = "0"; lblInstdiffbud.Text = "0"; lblCummHoursTD.Text = "0"; lblCummBudgetHours.Text = "0"; lblCummDiffTD.Text = "0"; DataTable dtNormal = dsNormal.Tables[0]; foreach (DataRow dRow in dtNormal.Rows) { lblinstbud.Text = dRow["install_hours"] == DBNull.Value ? "0" : dRow["install_hours"].ToString(); } DataTable dtTD = dsBudget.Tables[0]; foreach (DataRow dRow1 in dtTD.Rows) { lblInstbudTD.Text = dRow1["install_hours"] == DBNull.Value ? "0" : dRow1["install_hours"].ToString(); } //cumulative Daily Hours DataTable dtCummBudget = dsCummBudget.Tables[0]; foreach (DataRow dRow1 in dtCummBudget.Rows) { lblCummBudgetHours.Text = dRow1["install_hours"] == DBNull.Value ? "0" : dRow1["install_hours"].ToString(); } //dumulative Daily Hours DataTable dtCummTD = dsCummTD.Tables[0]; foreach (DataRow dRow2 in dtCummTD.Rows) { lblCummHoursTD.Text = dRow2["install_hours"] == DBNull.Value ? "0" : dRow2["install_hours"].ToString(); } txtHours.Text = txtHours.Text.Trim() == "" ? "0" : txtHours.Text.Trim().ToString(); lblInstdiffbud.Text = (Convert.ToDecimal(lblinstbud.Text) - (Convert.ToDecimal(txtHours.Text) + Convert.ToDecimal(lblInstbudTD.Text))).ToString(); lblCummDiffTD.Text = (Convert.ToDecimal(lblCummBudgetHours.Text) - Convert.ToDecimal(lblCummHoursTD.Text)).ToString(); }
protected void btnwodetails_Click(object sender, EventArgs e) { whitfield_reports _wc = new whitfield_reports(); Boolean IsInsertSuccess = false; IsInsertSuccess = _wc.ManageReportActivityMain(_wc.GetReportNumber(Convert.ToInt32(ViewState["twc_project_number"].ToString()), txtReportDate.Text.Trim()),ViewState["twc_project_number"].ToString(), ddlworkorders.SelectedItem.Value, txtHours.Text.Trim(), txtActComments.Text.Trim(), Request.Cookies["UserId"].Value); DisplayReportGrid(); DisplayManPowerGrid(); DisplayHistoryGrid(); }
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; } }