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();
}
private void BindItemNumber()
{
project_invoice _pi = new project_invoice();
DataSet dsGrp = new DataSet();
dsGrp = _pi.GetHashtableData();
if (dsGrp.Tables[0].Rows.Count > 0)
{
ddlNo.DataSource = dsGrp;
ddlNo.DataValueField = "seq_value";
ddlNo.DataTextField = "seq_value";
ddlNo.DataBind();
}
}
private void BindItemNumber()
{
project_invoice _pi = new project_invoice();
DataSet dsGrp = new DataSet();
dsGrp = _pi.GetHashtableData();
if (dsGrp.Tables[0].Rows.Count > 0)
{
ddlNo.DataSource = dsGrp;
ddlNo.DataValueField = "seq_value";
ddlNo.DataTextField = "seq_value";
ddlNo.DataBind();
}
}
protected void btnnew_Click(object sender, EventArgs e)
{
try
{
Boolean BoolIns = false;
project_invoice _pi = new project_invoice();
BoolIns = _pi.MaintainInvoiceRecords(ViewState["twc_project_number"].ToString(), txtSubmitDate.Text.Trim(), txtReceivedDate.Text.Trim(), txtApprDate.Text.Trim(), txtfabCost.Text.Trim(), txtInstCost.Text.Trim(), txtMatCost.Text.Trim(), txtBseContract.Text.Trim(), txtChangeOrder.Text.Trim(), txtDescription.Text.Trim(), ddlNo.SelectedItem.Value);
if (BoolIns)
{
lblMsg.Text = "Invoice 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();
BoolIns = _pi.MaintainInvoiceRecords(ViewState["twc_project_number"].ToString(),txtSubmitDate.Text.Trim(),txtReceivedDate.Text.Trim(),txtApprDate.Text.Trim(), txtfabCost.Text.Trim(),txtInstCost.Text.Trim(),txtMatCost.Text.Trim(),txtBseContract.Text.Trim(),txtChangeOrder.Text.Trim(), txtDescription.Text.Trim(),ddlNo.SelectedItem.Value);
if (BoolIns)
{
lblMsg.Text = "Invoice 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());
}
}
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 Summary_Queue()
{
DataSet dsRpAdvances = new DataSet();
try
{
project_invoice _wc = new project_invoice();
dsRpAdvances = _wc.GetProjectInvoices();
}
catch (Exception exp)
{
Response.Write(exp.Message.ToString());
}
return dsRpAdvances;
}
public void grdProjects_Itemcommand(Object sender, DataGridCommandEventArgs e)
{
Int32 _twc_proj_number_ID = 0;
DataSet dsExpand = new DataSet();
project_invoice _pi = new project_invoice();
switch (e.CommandName)
{
case "Expand":
{
_twc_proj_number_ID = Convert.ToInt32(grdProjects.DataKeys[Convert.ToInt32(e.Item.ItemIndex)]);
_twc_proj_number_ID = Convert.ToInt32(grdProjects.DataKeys[e.Item.ItemIndex]);
dsExpand = _pi.GetInvoiceforProject(Convert.ToInt32(_twc_proj_number_ID.ToString()));
PlaceHolder exp = new PlaceHolder();
exp = (System.Web.UI.WebControls.PlaceHolder)e.Item.Cells[10].FindControl("ExpandedContent");
ImageButton img = new ImageButton();
img = (System.Web.UI.WebControls.ImageButton)e.Item.Cells[0].FindControl("btnExpand");
if (dsExpand.Tables[0].Rows.Count > 0)
{
if (img.ImageUrl == "assets/img/Plus.gif")
{
img.ImageUrl = "assets/img/Minus.gif";
exp.Visible = true;
((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).Visible = true;
((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).ProjectNumber = _twc_proj_number_ID;
((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).FetchSubMaterials(dsExpand);
}
else
{
exp.Visible = false;
((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).Visible = false;
img.ImageUrl = "assets/img/Plus.gif";
}
}
else
{
if (img.ImageUrl == "assets/img/Plus.gif")
{
//((ViewDesignAdmin)(e.Item.FindControl("DynamicTable1"))).Visible = true;
img.ImageUrl = "assets/img/Minus.gif";
exp.Visible = true;
((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).Visible = true;
((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).ProjectNumber = _twc_proj_number_ID;
((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).FetchSubMaterials(dsExpand);
}
else
{
exp.Visible = false;
((Whitfield_financialmgmt_child)(e.Item.FindControl("DynamicTable1"))).Visible = false;
img.ImageUrl = "assets/img/Plus.gif";
}
}
break;
}
default:
{
break;
}
}
}
private void DisplayGrid(Int32 material_id)
{
try
{
project_invoice _pi = new project_invoice();
DataSet _dsInvoices = new DataSet();
_dsInvoices = _pi.GetInvoiceforProject(Convert.ToInt32(ViewState["twc_project_number"].ToString()));
PopulateDataGrid(_dsInvoices, grdinv);
}
catch (Exception exp)
{
Response.Write(exp.Message.ToString());
}
}
public void grdpl1_DeleteCommand(object sender, DataGridCommandEventArgs e)
{
String DetailId = "";
DetailId = grdpl1.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString();
project_invoice _dbClass = new project_invoice();
_dbClass.DeleteInvoice(Convert.ToInt32(ViewState["twc_project_number"].ToString()),DetailId);
this.DisplayGrid();
}
private void DisplaySOVGrid()
{
try
{
project_invoice _pi = new project_invoice();
DataSet _dsSOV = new DataSet();
_dsSOV = _pi.GetInvoiceSOVforProject(Convert.ToInt32(ViewState["twc_project_number"].ToString()));
PopulateDataGrid(_dsSOV, grdSOV);
}
catch (Exception exp)
{
Response.Write(exp.Message.ToString());
}
}
protected void btnnew_Click(object sender, EventArgs e)
{
try
{
project_invoice _pi = new project_invoice();
_pi.UpdateProjectInfo(Convert.ToInt32(ViewState["EstNum"].ToString()),Convert.ToInt32(ViewState["twc_project_number"].ToString()),txtInitialPaymentDate.Text.Trim(),txtFinalPaymentDate.Text.Trim(),ddlContacts.SelectedItem.Value,txtOrigContract.Text.Trim(),txtChangeOrder.Text.Trim());
BindPage(Convert.ToInt32(ViewState["EstNum"].ToString()), Convert.ToInt32(ViewState["twc_project_number"].ToString()));
}
catch (Exception exp)
{
Response.Write(exp.Message.ToString());
}
}
public void grdpl1_UpdateCommand(object sender, DataGridCommandEventArgs e)
{
String InvoiceID = grdpl1.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString();
project_invoice _pi = new project_invoice();
_pi.MaintainInvoiceRecords(ViewState["twc_project_number"].ToString(), ((TextBox)(e.Item.FindControl("txtDate_Submited"))).Text, ((TextBox)(e.Item.FindControl("txtDate_Received"))).Text, ((TextBox)(e.Item.FindControl("txtDate_Approved"))).Text, ((TextBox)(e.Item.FindControl("txtfab_lab_Cost"))).Text, ((TextBox)(e.Item.FindControl("txtIns_lab_Cost"))).Text, ((TextBox)(e.Item.FindControl("txtMaterial_cost"))).Text, ((TextBox)(e.Item.FindControl("txtBase_contract"))).Text, ((TextBox)(e.Item.FindControl("txtChange_order"))).Text, ((TextBox)(e.Item.FindControl("txtInvoice_comments"))).Text, InvoiceID);
grdpl1.EditItemIndex = -1;
grdpl1.ShowFooter = true;
this.DisplayGrid();
}
public Boolean UpdateCostUpdates(String EstNum, String TWC_Proj_Number)
{
try
{
project_invoice _pi = new project_invoice();
String sqlCommand = "";
Database db = DatabaseFactory.CreateDatabase();
sqlCommand = " UPDATE Whitfield_ProjectInfo SET " +
" [O_Contract_Value] = @O_Contract_Value " +
" ,[Change_Order_Value] = @Change_Order_Value " +
" WHERE EstNum = @EstNum and TWC_proj_number=@TWC_proj_number";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
db.AddInParameter(dbCommand, "@EstNum", DbType.Int32, Convert.ToInt32(EstNum));
db.AddInParameter(dbCommand, "@TWC_proj_number", DbType.Int32, Convert.ToInt32(TWC_Proj_Number));
db.AddInParameter(dbCommand, "@O_Contract_Value", DbType.String, _pi.GetOriginalContractValue(Convert.ToInt32(TWC_Proj_Number)).ToString());
db.AddInParameter(dbCommand, "@Change_Order_Value", DbType.String, _pi.GetChangeOrderValue(Convert.ToInt32(TWC_Proj_Number)).ToString());
db.ExecuteNonQuery(dbCommand);
return true;
}
catch (Exception ex)
{
HttpResponse objResponse = HttpContext.Current.Response;
objResponse.Write(ex.Message);
return false;
}
}
