private void DisplaySchedulingGrid()
{
Whitfieldcore wc = new Whitfieldcore();
DataSet _dsScheduling = new DataSet();
lblTotScheduledHours.Text = wc.GetTotalscheduledHours(twc_project_number);
if (wc.IsScheduleDataExists(Convert.ToInt32(ViewState["twc_project_number"].ToString())))
{
pnlActSchedule.Visible = true;
_dsScheduling = wc.GetScheduleListing(ViewState["twc_project_number"].ToString());
this.PopulateDataGrid(_dsScheduling, grdSchedule);
}
}
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;
}