protected void btnUpdate_Click(object sender, EventArgs e)
{
ReceivedItemsLogic ameh = new ReceivedItemsLogic();
properties RecievedItemsOrderObject = new properties();
int originalOTEOID = Convert.ToInt32(hdnFieldOTEOID.Value);
//int ReceivedItemsOTEOID = Convert.ToInt32(tbOtEONumber.Text);//new
RecievedItemsOrderObject.ReceivedItemsOTEOID = Convert.ToInt32(tbOtEONumber.Text);
RecievedItemsOrderObject.Date = tbOTEODate.Text;
RecievedItemsOrderObject.SupplyOderRef = tbSupplyOrderReference.Text;
RecievedItemsOrderObject.SupplyDate = tbSupplyDate.Text;
RecievedItemsOrderObject.Supplier = tbSupplierName.Text;
// RecievedItemsOrderObject.ChargeableHeadName = ddlChargeableHead.SelectedItem.ToString();
// RecievedItemsOrderObject.IssueHeadName = ddlIssueHead.SelectedItem.ToString();
if (ddlChargeableHead.SelectedIndex > 0)
{
RecievedItemsOrderObject.ChargeableHeadName = ddlChargeableHead.SelectedItem.ToString();
}
else
{
RecievedItemsOrderObject.ChargeableHeadName = lblChargeableHead.Text; //same old value populated
}
if (ddlIssueHead.SelectedIndex > 0)
{
RecievedItemsOrderObject.IssueHeadName = ddlIssueHead.SelectedItem.ToString();
}
else
{
RecievedItemsOrderObject.IssueHeadName = lblIssueHeadOld.Text; //same old value populated
}
RecievedItemsOrderObject.ModifiedBy = Convert.ToInt16(Session["USERID"]);
//getting all the values of controls values inside gridview control
StringBuilder sb = new StringBuilder();
// sb.Append("<root>");
string insertStatement = "INSERT INTO ReceivedItemsDetails(RECEIVEDITEMSOTEOID,ITEMID, ITEMNAME,QUANTITY,UNIT,RATE, AMOUNT) values('@RECEIVEDITEMSOTEOID','@ITEMID', '@ITEMNAME', '@QUANTITY', '@UNIT', '@RATE', '@AMOUNT')";
for (int i = 0; i < gvItems.Rows.Count; i++)
{
// TextBox tbItemID = gvItems.Rows[i].FindControl("tbItemID") as TextBox;
HiddenField hdnFieldItemID = gvItems.Rows[i].FindControl("hdnFieldItemID") as HiddenField;
DropDownList itemName = gvItems.Rows[i].FindControl("_ddItems") as DropDownList;
TextBox _tbUnit = gvItems.Rows[i].FindControl("_tbUnit") as TextBox;
// Label lblUnit = gvItems.Rows[i].FindControl("lblUnit") as Label;
TextBox tbQuantity = gvItems.Rows[i].FindControl("_tbQuantity") as TextBox;
TextBox tbRate = gvItems.Rows[i].FindControl("tbRate") as TextBox;
TextBox tbAmount = gvItems.Rows[i].FindControl("tbAmount") as TextBox;
// Label lblAmount = gvItems.Rows[i].FindControl("lblAmount") as Label;
//CODE TO CHECK NULL VALUES
//SAVE CODE
if (itemName.SelectedValue.ToString() != "0")
{
sb.Append(insertStatement.Replace("@RECEIVEDITEMSOTEOID", tbOtEONumber.Text).Replace("@ITEMID", hdnFieldItemID.Value).Replace("@ITEMNAME", Utilities.ValidSql(itemName.SelectedItem.ToString())).Replace("@QUANTITY", tbQuantity.Text).Replace("@UNIT", _tbUnit.Text).Replace("@RATE", tbRate.Text).Replace("@AMOUNT", tbAmount.Text));
}
}
//now save it to db
if (sb.ToString() != "")
{
//getting total amount from footer
TextBox tbtotalAmount = gvItems.FooterRow.FindControl("tbtotalAmount") as TextBox;
RecievedItemsOrderObject.TotalAmount = Convert.ToDouble(tbtotalAmount.Text);
ameh.UpdateReceivedItemsDetails(RecievedItemsOrderObject, originalOTEOID, sb.ToString());
}
else //no new items received so, can save primary table only
{
//getting total amount from single label
RecievedItemsOrderObject.TotalAmount = Convert.ToDouble(tbtotalAmountAddedItems.Text);
ameh.UpdateReceivedItemsDetails(RecievedItemsOrderObject, originalOTEOID); //originalOTEOID
}
// Session["OTEONUMBER"] = tbOtEONumber.Text;
Response.Redirect("~/Admin/ReceivedEntriesList.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ReceivedItemsLogic ameh = new ReceivedItemsLogic();
properties RecievedItemsOrderObject = new properties();
int originalOTEOID = Convert.ToInt32(hdnFieldOTEOID.Value);
//int ReceivedItemsOTEOID = Convert.ToInt32(tbOtEONumber.Text);//new
RecievedItemsOrderObject.ReceivedItemsOTEOID = Convert.ToInt32(tbOtEONumber.Text);
RecievedItemsOrderObject.Date = tbOTEODate.Text;
RecievedItemsOrderObject.SupplyOderRef = tbSupplyOrderReference.Text;
RecievedItemsOrderObject.SupplyDate = tbSupplyDate.Text;
RecievedItemsOrderObject.Supplier = tbSupplierName.Text;
// RecievedItemsOrderObject.ChargeableHeadName = ddlChargeableHead.SelectedItem.ToString();
// RecievedItemsOrderObject.IssueHeadName = ddlIssueHead.SelectedItem.ToString();
if (ddlChargeableHead.SelectedIndex > 0)
{
RecievedItemsOrderObject.ChargeableHeadName = ddlChargeableHead.SelectedItem.ToString();
}
else
{
RecievedItemsOrderObject.ChargeableHeadName = lblChargeableHead.Text; //same old value populated
}
if (ddlIssueHead.SelectedIndex > 0)
{
RecievedItemsOrderObject.IssueHeadName = ddlIssueHead.SelectedItem.ToString();
}
else
{
RecievedItemsOrderObject.IssueHeadName = lblIssueHeadOld.Text; //same old value populated
}
RecievedItemsOrderObject.ModifiedBy = Convert.ToInt16(Session["USERID"]);
StringBuilder sb = new StringBuilder();
string insertStatement = "INSERT INTO ReceivedItemsDetails(RECEIVEDITEMSOTEOID,ITEMID, ITEMNAME,QUANTITY,UNIT,RATE, AMOUNT) values('@RECEIVEDITEMSOTEOID','@ITEMID', '@ITEMNAME', '@QUANTITY', '@UNIT', '@RATE', '@AMOUNT')";
string insertRateMaster = "INSERT into ItemsRateMaster (itemname,MaxOrderNO,IssueHeadName) values('@ITEMNAME','@odNo','@issueHead')";
string UpdateRateMaster = "update ItemsRateMaster set MaxOrderNO='@odNo' where itemname='@ITEMNAME' AND IssueHeadName='@issueHead'";
string insertRateSecondary = "INSERT into ItemsRateSecondary (ITEMNAME,Rate,OrderNO,Quantity,IssueHeadName) values('@ITEMNAME','@RATE','@odNo','@QUANTITY','@issueHead')";
for (int i = 0; i < gvItems.Rows.Count; i++)
{
HiddenField hdnFieldItemID = gvItems.Rows[i].FindControl("_hdnFieldItemID") as HiddenField;
DropDownList itemName = gvItems.Rows[i].FindControl("_ddItems") as DropDownList;
TextBox _tbUnit = gvItems.Rows[i].FindControl("_tbUnit") as TextBox;
// Label lblUnit = gvItems.Rows[i].FindControl("lblUnit") as Label;
TextBox tbQuantity = gvItems.Rows[i].FindControl("_tbQuantity") as TextBox;
TextBox tbRate = gvItems.Rows[i].FindControl("tbRate") as TextBox;
TextBox tbAmount = gvItems.Rows[i].FindControl("tbAmount") as TextBox;
TextBox tbOrderNo = gvItems.Rows[i].FindControl("_tbOrderNo") as TextBox;
CheckExistingItem = tbOrderNo.Text;
if (itemName.SelectedValue.ToString() != "0")
{
double result;
if (!double.TryParse(tbQuantity.Text, out result))
{
panelError.Visible = true;
lblError.Text = "Should Be Numeric";
panelSuccess.Visible = false;
tbQuantity.Focus();
tbQuantity.Style.Add("background", "Pink");
return;
}
else
{
tbQuantity.Style.Add("background", "White");
}
double result1;
if (!double.TryParse(tbRate.Text, out result1))
{
panelError.Visible = true;
lblError.Text = "Should Be Numeric";
panelSuccess.Visible = false;
tbRate.Focus();
tbRate.Style.Add("background", "Pink");
return;
}
else
{
tbRate.Style.Add("background", "White");
}
sb.Append(insertStatement.Replace("@RECEIVEDITEMSOTEOID", tbOtEONumber.Text).Replace("@ITEMID", hdnFieldItemID.Value).Replace("@ITEMNAME", Utilities.ValidSql(itemName.SelectedItem.ToString())).Replace("@QUANTITY", tbQuantity.Text).Replace("@UNIT", _tbUnit.Text).Replace("@RATE", tbRate.Text).Replace("@AMOUNT", tbAmount.Text));
if (CheckExistingItem == "1")
{
sb.Append(insertRateMaster.Replace("@ITEMNAME", Utilities.ValidSql(itemName.SelectedItem.ToString())).Replace("@odNo", tbOrderNo.Text).Replace("@issueHead", RecievedItemsOrderObject.IssueHeadName));
sb.Append(insertRateSecondary.Replace("@ITEMNAME", Utilities.ValidSql(itemName.SelectedItem.ToString())).Replace("@RATE", tbRate.Text).Replace("@odNo", tbOrderNo.Text).Replace("@QUANTITY", tbQuantity.Text).Replace("@issueHead", RecievedItemsOrderObject.IssueHeadName));
}
else
{
sb.Append(UpdateRateMaster.Replace("@ITEMNAME", Utilities.ValidSql(itemName.SelectedItem.ToString())).Replace("@odNo", tbOrderNo.Text).Replace("@issueHead", RecievedItemsOrderObject.IssueHeadName));
sb.Append(insertRateSecondary.Replace("@ITEMNAME", Utilities.ValidSql(itemName.SelectedItem.ToString())).Replace("@RATE", tbRate.Text).Replace("@odNo", tbOrderNo.Text).Replace("@QUANTITY", tbQuantity.Text).Replace("@issueHead", RecievedItemsOrderObject.IssueHeadName));
}
}
}
//now save it to db
if (sb.ToString() != "")
{
TextBox tbtotalAmount = gvItems.FooterRow.FindControl("tbtotalAmount") as TextBox;
RecievedItemsOrderObject.TotalAmount = Convert.ToDouble(tbtotalAmount.Text);
ameh.UpdateReceivedItemsDetails(RecievedItemsOrderObject, originalOTEOID, sb.ToString());
}
else
{
RecievedItemsOrderObject.TotalAmount = Convert.ToDouble(tbtotalAmountAddedItems.Text);
ameh.UpdateReceivedItemsDetails(RecievedItemsOrderObject, originalOTEOID); //originalOTEOID
}
Response.Redirect("~/Admin/ReceivedEntriesList.aspx");
}
/// <summary>
/// save to db
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
///
protected void _btnSave_Click(object sender, EventArgs e)
{
try
{
ReceivedItemsLogic ameh = new ReceivedItemsLogic();
properties RecievedItemsOrderObject = new properties();
int originalOTEOID = Convert.ToInt32(hdnFieldOTEOID.Value);
int ReceivedItemsOTEOID = Convert.ToInt32(tbOtEONumber.Text);//new
RecievedItemsOrderObject.ReceivedItemsOTEOID = Convert.ToInt32(tbOtEONumber.Text);
RecievedItemsOrderObject.Date = tbOTEODate.Text;
RecievedItemsOrderObject.SupplyOderRef = tbSupplyOrderReference.Text;
RecievedItemsOrderObject.SupplyDate = tbSupplyDate.Text;
RecievedItemsOrderObject.Supplier = tbSupplierName.Text;
// RecievedItemsOrderObject.ChargeableHeadName = ddlChargeableHead.SelectedItem.ToString();
// RecievedItemsOrderObject.IssueHeadName = ddlIssueHead.SelectedItem.ToString();
if (ddlChargeableHead.SelectedIndex > 0)
{
RecievedItemsOrderObject.ChargeableHeadName = ddlChargeableHead.SelectedItem.ToString();
}
else
{
RecievedItemsOrderObject.ChargeableHeadName = lblChargeableHead.Text; //same old value populated
}
if (ddlIssueHead.SelectedIndex > 0)
{
RecievedItemsOrderObject.IssueHeadName = ddlIssueHead.SelectedItem.ToString();
}
else
{
RecievedItemsOrderObject.IssueHeadName = lblIssueHeadOld.Text; //same old value populated
}
RecievedItemsOrderObject.ModifiedBy = Convert.ToInt16(Session["USERID"]);
//getting all the values of controls values inside gridview control
StringBuilder sb = new StringBuilder();
// sb.Append("<root>");
string insertStatement = "INSERT INTO ReceivedItemsDetails(RECEIVEDITEMSOTEOID,ITEMID, ITEMNAME,QUANTITY,UNIT,RATE, AMOUNT) values('@RECEIVEDITEMSOTEOID','@ITEMID', '@ITEMNAME', '@QUANTITY', '@UNIT', '@RATE', '@AMOUNT')";
for (int i = 0; i < gvItems.Rows.Count; i++)
{
// TextBox tbItemID = gvItems.Rows[i].FindControl("tbItemID") as TextBox;
HiddenField hdnFieldItemID = gvItems.Rows[i].FindControl("hdnFieldItemID") as HiddenField;
DropDownList itemName = gvItems.Rows[i].FindControl("_ddItems") as DropDownList;
TextBox _tbUnit = gvItems.Rows[i].FindControl("_tbUnit") as TextBox;
// Label lblUnit = gvItems.Rows[i].FindControl("lblUnit") as Label;
TextBox tbQuantity = gvItems.Rows[i].FindControl("_tbQuantity") as TextBox;
TextBox tbRate = gvItems.Rows[i].FindControl("tbRate") as TextBox;
TextBox tbAmount = gvItems.Rows[i].FindControl("tbAmount") as TextBox;
// Label lblAmount = gvItems.Rows[i].FindControl("lblAmount") as Label;
//CODE TO CHECK NULL VALUES
//SAVE CODE
if (itemName.SelectedValue.ToString() != "0")
{
sb.Append(insertStatement.Replace("@RECEIVEDITEMSOTEOID", tbOtEONumber.Text).Replace("@ITEMID", hdnFieldItemID.Value).Replace("@ITEMNAME", Utilities.ValidSql(itemName.SelectedItem.ToString())).Replace("@QUANTITY", tbQuantity.Text).Replace("@UNIT", _tbUnit.Text).Replace("@RATE", tbRate.Text).Replace("@AMOUNT", tbAmount.Text));
}
}
//now save it to db
if (sb.ToString() != "")
{
//getting total amount from footer
TextBox tbtotalAmount = gvItems.FooterRow.FindControl("tbtotalAmount") as TextBox;
RecievedItemsOrderObject.TotalAmount = Convert.ToDouble(tbtotalAmount.Text);
ameh.UpdateReceivedItemsDetails(RecievedItemsOrderObject, originalOTEOID, sb.ToString());
}
else //no new items received so, can save primary table only
{
//getting total amount from single label
RecievedItemsOrderObject.TotalAmount = Convert.ToDouble(tbtotalAmountAddedItems.Text);
ameh.UpdateReceivedItemsDetails(RecievedItemsOrderObject, ReceivedItemsOTEOID); //originalOTEOID
}
Session["OTEONUMBER"] = tbOtEONumber.Text;
// Response.Redirect(Request.Url.ToString());
Response.Redirect("~/Admin/ReceivedItemsEdit.aspx?Id=" + tbOtEONumber.Text);
//temp code to display properly in local as well as in hosting environment
//string appPath = HttpRuntime.AppDomainAppVirtualPath;
//if (appPath != "/")
// ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open(' " + appPath + "/Print/ePrint.aspx?Id=" + Session["OTEONUMBER"].ToString() + "');", true);
//else
// ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('/Print/ePrint.aspx?Id=" + Session["OTEONUMBER"].ToString() + "');", true);
//Session["OTEONUMBER"] = null;
}
//catch (System.Threading.ThreadAbortException)
//{
// //do nothing
//}
catch (SqlException ex)
{
if (ex.Message.Contains("duplicate key"))
{
panelError.Visible = true;
lblError.Text = "Error! The OTEO ID already exists. Please use another ID";
panelSuccess.Visible = false;
tbOtEONumber.BorderColor = System.Drawing.Color.Red;
}
else
{
Session["ERRORMSG"] = ex.ToString();
Response.Redirect("Error.aspx");
}
}
catch (Exception ex)
{
panelError.Visible = true;
lblError.Text = ex.Message;
panelSuccess.Visible = false;
}
}
