protected void btnSave_Click(object sender, EventArgs e)
{
Procurement_CTableAdapters.VIEW_PO_BATCH_PLAN_DTTableAdapter batch_dt = new Procurement_CTableAdapters.VIEW_PO_BATCH_PLAN_DTTableAdapter();
try
{
//Check Qty
string bal_qty = WebTools.GetExpr("BAL_QTY", "VIEW_PO_BATCH_BAL", " WHERE PO_ITEM_ID='" + ddlPOItemList.SelectedValue + "'");
if (decimal.Parse(txtBatchQty.Text) > decimal.Parse(bal_qty))
{
Master.show_error("Batch quantity cannot exceed balance quantity. Balance Qty is " + bal_qty);
return;
}
//batch_dt.InsertQuery(decimal.Parse(Request.QueryString["BATCH_ID"].ToString()), decimal.Parse(ddlPOItemList.SelectedItem.Value),
// decimal.Parse(txtBatchQty.Text), txtRemarks.Text);
Master.show_success("Item Added.");
}
catch (Exception ex)
{
Master.show_error(ex.Message);
}
finally {
batch_dt.Dispose();
GC.Collect();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Procurement_CTableAdapters.VIEW_PO_BATCH_PLAN_DTTableAdapter batch = new Procurement_CTableAdapters.VIEW_PO_BATCH_PLAN_DTTableAdapter();
CheckBox cb;
decimal mat_id;
string batch_qty;
try
{
string po_id = WebTools.GetExpr("PO_ID", "PIP_PO_BATCH_PLAN", " WHERE BATCH_ID='" + Request.QueryString["BATCH_ID"] + "'");
foreach (GridDataItem item in itemsGrid.Items)
{
cb = ((CheckBox)item["checkCol"].FindControl("checkItems"));
if (cb.Checked)
{
string po_item_id = WebTools.GetExpr("PO_ITEM_ID", "PIP_PO_DETAIL", " WHERE PO_ID='" + po_id + "' AND PO_ITEM='" + item["PO_ITEM_NO"].Text + "'");
mat_id = WebTools.GetMatId(item["MAT_CODE1"].Text, decimal.Parse(Session["PROJECT_ID"].ToString()));
batch_qty = (item["BAL_QTY"].FindControl("BAL_QTYTextBox") as TextBox).Text;
batch.InsertQuery(decimal.Parse(Request.QueryString["BATCH_ID"]), decimal.Parse(po_item_id), decimal.Parse(batch_qty), null, decimal.Parse(po_id), mat_id, item["PO_ITEM_NO"].Text);
}
}
Master.ShowMessage("Selected Items Added.");
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
finally
{
// insp.Dispose();
itemsGrid.Rebind();
}
}
