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;
}
}
