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