protected void btnSubmit_Click(object sender, EventArgs e)
{
decimal mat_id = db_lookup.MAT_ID(txtMatSearch.Text, Decimal.Parse(Session["PROJECT_ID"].ToString()));
if (mat_id == 0)
{
Master.ShowWarn("Material Code not found!");
return;
}
//decimal bal_qty = db_lookup.DSum("BAL_QTY", "VIEW_ITEM_REP_A", " WHERE MAT_ID=" + mat_id + " AND SUB_CON_ID=" + Request.QueryString["SC_ID"]);
//if (bal_qty < decimal.Parse(txtQty.Text) && Request.QueryString["SC_ID"] != "2")
//{
// Master.ShowWarn("Material not found in stock!, Please check the quantity carefully.");
// return;
//}
string sc_id = WebTools.GetExpr("SC_ID", "PIP_MAT_ISSUE_ADD", " WHERE ADD_ISSUE_ID='" + Request.QueryString["ADD_ISSUE_ID"].ToString() + "'");
string stock_qty = WebTools.GetExpr("BAL_QTY", "VIEW_ITEM_REP_A", " WHERE MAT_ID= '" + HiddenMatID.Value + "' AND SUB_CON_ID='" + sc_id + "'");
if (stock_qty == null || decimal.Parse(stock_qty) < decimal.Parse(txtQty.Text))
{
Master.ShowError("Issue quantity is more than current available stock qty. Current stock quantity is " + stock_qty + ".");
return;
}
string HeatNo, PaintSys;
PIP_MAT_ISSUE_ADD_DETAILTableAdapter items = new PIP_MAT_ISSUE_ADD_DETAILTableAdapter();
try
{
HeatNo = txtAutoHeatNo.Entries[0].Text;
if (txtAutoPaintSys.Entries.Count > 0)
{
PaintSys = txtAutoPaintSys.Entries[0].Text;
}
else
{
PaintSys = string.Empty;
}
items.InsertQuery(
Decimal.Parse(Request.QueryString["ADD_ISSUE_ID"]),
mat_id,
decimal.Parse(txtQty.Text),
HeatNo,
PaintSys,
txtRemarks.Text);
Master.ShowMessage(txtMatSearch.Text + " Saved.");
itemsGridView.Rebind();
}
catch (Exception ex)
{
Master.ShowWarn(ex.Message);
}
finally
{
items.Dispose();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
decimal mat_id = db_lookup.MAT_ID(txtMatCode.Text, Decimal.Parse(Session["PROJECT_ID"].ToString()));
if (mat_id == 0)
{
//Master.ShowWarn("Material Code not found!");
RadWindowManager1.RadAlert("Material Code not found!", 400, 150, "Warning", "");
return;
}
//if (ddlMatRequestNo.SelectedValue == "")
//{
// //Master.ShowWarn("Select Material Request Number!");
// RadWindowManager1.RadAlert("Select Material Request Number!", 400, 150, "Warning", "");
// return;
//}
string sub_con_id = WebTools.GetExpr("SC_ID", "PIP_MAT_ISSUE_ADD", " WHERE ADD_ISSUE_ID='" + Request.QueryString["ADD_ISSUE_ID"] + "'");
decimal bal_qty = db_lookup.DSum("BAL_QTY", "VIEW_ITEM_REP_A", " WHERE MAT_ID=" + mat_id + " AND SUB_CON_ID=" + sub_con_id);
if (bal_qty < decimal.Parse(txtQty.Text))
{
// Master.ShowWarn("Material not found in stock!, Please check the quantity carefully.");
RadWindowManager1.RadAlert("Material not found in stock!, Please check the quantity carefully.", 00, 150, "Warning", "");
return;
}
PIP_MAT_ISSUE_ADD_DETAILTableAdapter items = new PIP_MAT_ISSUE_ADD_DETAILTableAdapter();
try
{
items.InsertQuery(
Decimal.Parse(Request.QueryString["ADD_ISSUE_ID"]),
mat_id,
decimal.Parse(txtQty.Text),
txtHeatNo.Text,
txtPaintCode.Text,
txtRemarks.Text, txtCableDrumNo.Text
);
Master.ShowMessage(txtMatCode.Text + " Saved.");
itemsGridView.DataBind();
}
catch (Exception ex)
{
Master.ShowWarn(ex.Message);
}
finally
{
items.Dispose();
}
}
