protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
decimal mat_id = db_lookup.MAT_ID(txtMatCode.Text, Decimal.Parse(Session["PROJECT_ID"].ToString()));
if (mat_id == -1)
{
Master.ShowWarn("There are two materials with the same code! try to use the unique one.");
return;
}
else if (mat_id == 0)
{
Master.ShowWarn("Material Code not found!");
return;
}
//if (WebTools.GetExpr("HEAT_NO", "PIP_HEAT_NO", " WHERE HEAT_NO='" + txtHeatNo.Text +
// "' AND PROJECT_ID=" + Session["PROJECT_ID"].ToString()) == "")
//{
// Master.ShowWarn("Heat number not found!");
// return;
//}
//else
//{
// //Find TC_CODE for selected heat number
//}
int irn_id = int.Parse(ddlIRN.SelectedValue);
string po_item = txtPoItem.Text;
decimal bal_to_rec = decimal.Parse(WebTools.GetExpr("BAL_TO_RECV", "VIEW_IRN_BAL_TO_RECV", " WHERE IRN_ID=" + irn_id + " AND PO_ITEM='" + po_item + "'"));
if (decimal.Parse(txtQty.Text) > bal_to_rec)
{
RadWindowManager1.RadAlert("Receive Quantity cannot be more than IRN Qty:" + bal_to_rec, 300, 150, "Warning", "");
return;
}
VIEW_ADAPTER_MAT_RCV_DETAILTableAdapter items = new VIEW_ADAPTER_MAT_RCV_DETAILTableAdapter();
string pieces = txtPieces.Text;
if (pieces == "N/A" || pieces == "")
{
pieces = "0";
}
items.InsertQuery(Decimal.Parse(Request.QueryString["MAT_RCV_ID"]),
mat_id, Decimal.Parse(txtQty.Text),
null, null,
txtPoItem.Text, txtRemarks.Text,
txtMrItem.Text, txtCableDrumNo.Text, decimal.Parse(ddlIRN.SelectedValue), decimal.Parse(pieces));
Master.ShowMessage(txtMatCode.Text + " added.");
}
catch (Exception ex)
{
Master.ShowWarn(ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
VIEW_ADAPTER_MAT_RCV_DETAILTableAdapter mrr = new VIEW_ADAPTER_MAT_RCV_DETAILTableAdapter();
decimal mat_id;
string mat_code1;
string bal_to_recv, mr_item;
string rel_qty;
string irn_id = "";
try
{
foreach (GridDataItem item in itemsGrid.SelectedItems)
{
mat_code1 = item["MAT_CODE1"].Text;
//mat_id = WebTools.GetMatId(mat_code1, decimal.Parse(Session["PROJECT_ID"].ToString()));
mat_id = decimal.Parse(WebTools.GetExpr("MAT_ID", "PIP_MAT_STOCK", " WHERE MAT_CODE1='" + mat_code1 + "'"));
//irn_id = WebTools.GetExpr("IRN_ID", "PIP_MAT_RECEIVE_IRN", " WHERE MAT_RCV_ID = '" + Request.QueryString["MAT_RCV_ID"].ToString()+ "'");
irn_id = WebTools.GetExpr("IRN_ID", "PIP_PO_IRN", " WHERE IRN_NO = '" + item["IRN_NO"].Text + "'");
bal_to_recv = WebTools.GetExpr("BAL_TO_RECV", "VIEW_IRN_BAL_TO_RECV", " WHERE IRN_ID = '" + irn_id + "' AND PO_ITEM='" + item["PO_ITEM"].Text +
"' AND MAT_ID='" + mat_id + "'");
//bal_to_recv = (item["BAL_TO_RECV"].FindControl("BAL_TO_RECVLabel") as TextBox).Text;
mr_item = WebTools.CountExpr("(1)", "PIP_MAT_RECEIVE_DETAIL", " WHERE MAT_RCV_ID='" + Request.QueryString["MAT_RCV_ID"].ToString() + "'");
string RECV_QTY = (item["BAL_TO_RECV"].FindControl("BAL_TO_RECVLabel") as TextBox).Text;
if ((decimal.Parse(item["RELEASE_QTY"].Text) - decimal.Parse(item["RECV_QTY"].Text)) < decimal.Parse(bal_to_recv))
{
Master.ShowError("Receive Quantity cannot be more than release qty. ");
return;
}
string pieces = (item["BAL_TO_RECV_PIECES"].FindControl("BAL_TO_RECV_PIECESLabel") as TextBox).Text;
if (pieces == "N/A" || pieces == "")
{
pieces = "0";
}
mrr.InsertQuery(decimal.Parse(Request.QueryString["MAT_RCV_ID"]), mat_id, decimal.Parse(RECV_QTY), null, null,
item["PO_ITEM"].Text, null, (Decimal.Parse(mr_item) + 1).ToString(), null, (decimal.Parse(item["IRN_ID"].Text)), decimal.Parse(pieces));
}
Master.ShowMessage("Selected Items Added to MRR.");
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
finally {
itemsGrid.Rebind();
}
}
