protected void itemsGrid_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
if (e.CommandName == "Update")
{
try
{
GridDataItem row = (GridDataItem)e.Item;
string mat_code = ((TextBox)row["MAT_CODE1"].Controls[0]).Text;
string mat_id = WebTools.GetExpr("MAT_ID", "PIP_MAT_STOCK", " WHERE MAT_CODE1='" + mat_code + "'");
string jc_qty = WebTools.GetExpr("JC_QTY", "VIEW_BULK_PAINT_ISSUE_BAL", " WHERE PAINT_ID='" + HiddenPaintID.Value + "' AND MAT_ID = '" + mat_id + "'");
string issue_qty = ((TextBox)(row["ISSUE_QTY"].Controls[0])).Text;
if (decimal.Parse(jc_qty) < decimal.Parse(issue_qty))
{
Master.ShowWarn("Issued qty cannot exceed required qty.");
return;
}
string heat_no = ((TextBox)(row["HEAT_NO"].Controls[0])).Text;
string remarks = ((TextBox)(row["REMARKS"].Controls[0])).Text;
string paint_code = ((TextBox)(row["PAINT_CODE"].Controls[0])).Text;
dsPaintingMatTableAdapters.VIEW_BULK_PAINT_ISSUE_DETAILTableAdapter miv = new dsPaintingMatTableAdapters.VIEW_BULK_PAINT_ISSUE_DETAILTableAdapter();
miv.UpdateQuery(decimal.Parse(issue_qty), heat_no, remarks, paint_code, decimal.Parse(row.GetDataKeyValue("ISSUE_ITEM_ID").ToString()));
Master.ShowSuccess("Item Updated.");
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
txtReqQty.Text = WebTools.GetExpr("BAL_ISSUE", "VIEW_BULK_PAINT_ISSUE_BAL", " WHERE PAINT_ID='" + HiddenPaintID.Value + "' AND MAT_ID = '" + HiddenMatID.Value + "'");
string item = WebTools.GetExpr("ITEM_NAM", "VIEW_STOCK", " WHERE MAT_ID= '" + HiddenMatID.Value + "'");
if (decimal.Parse(txtIssueQty.Text) > decimal.Parse(txtReqQty.Text) && !item.ToUpper().Contains("PIPE"))
{
Master.ShowError("Issue qty cannot exceed required qty.");
return;
}
if (string.IsNullOrEmpty(txtIssueQty.Text) || decimal.Parse(txtIssueQty.Text) == 0)
{
Master.ShowError("Issue Qty cannot be blank or Zero.");
}
//Stock Qty to check.
if (txtPipePiece.Enabled)
{
double min = 0, max = 0;
bool flag = PipePieceQty(out min, out max);
if (!flag)
{
Master.ShowError("Pipe piece quantity can be between " + min + " and " + max);
return;
}
}
string heat_no, ps;
heat_no = cboHeatNo.SelectedIndex > 0 ? cboHeatNo.SelectedItem.Text : "";
ps = cboPaintSystem.SelectedIndex > 0 ? cboPaintSystem.SelectedItem.Text : "";
dsPaintingMatTableAdapters.VIEW_BULK_PAINT_ISSUE_DETAILTableAdapter issue = new dsPaintingMatTableAdapters.VIEW_BULK_PAINT_ISSUE_DETAILTableAdapter();
issue.InsertQuery(decimal.Parse(Request.QueryString["ISSUE_ID"]), decimal.Parse(HiddenMatID.Value), decimal.Parse(txtIssueQty.Text),
heat_no, txtRemarks.Text, ps);
Master.ShowMessage("Item Added.");
itemsGrid.Rebind();
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
protected void btnCreateTransfer_Click(object sender, EventArgs e)
{
if (itemsGrid.SelectedIndexes.Count == 0)
{
Master.ShowMessage("Select MIV to continue.");
return;
}
string doc = WebTools.GetExpr("ISSUE_NO", "PIP_BULK_PAINT_ISSUE", " WHERE ISSUE_ID = '" + itemsGrid.SelectedValue + "'");
string trans_id = WebTools.GetExpr("TRANSF_ID", "PIP_MAT_TRANSF", " WHERE DOC_REF_NO='" + doc + "'");
if (!string.IsNullOrEmpty(trans_id))
{
Master.ShowError("Transfer Number for Selected MIV is already created.");
return;
}
string from_store = WebTools.GetExpr("STORE_ID", "STORES_DEF", " WHERE SC_ID = '" +
WebTools.GetExpr("SC_ID", "PIP_BULK_PAINT_ISSUE", " WHERE ISSUE_ID = " + itemsGrid.SelectedValue) + "'");
string to_sc = WebTools.GetExpr("TO_SC", "PIP_PAINTING_MAT", " WHERE PAINT_ID='" +
WebTools.GetExpr("PAINT_JC_ID", "PIP_BULK_PAINT_ISSUE", " WHERE ISSUE_ID = " + itemsGrid.SelectedValue) + "'");
string to_store = WebTools.GetExpr("STORE_ID", "STORES_DEF", " WHERE SC_ID=" + to_sc);
//Get New Transfer NO
string prefix = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " WHERE PROJECT_ID='" + Session["PROJECT_ID"] + "'");
string sc_id = WebTools.GetExpr("SC_ID", "STORES_DEF", " WHERE STORE_ID='" + from_store + "'");
prefix += "-";
prefix += WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " WHERE SUB_CON_ID = '" + sc_id + "'");
prefix += "-MAT-TRANS-";
string trans_no = WebTools.NextSerialNo("PIP_MAT_TRANSF", "TRANSF_NO", prefix, 4, " WHERE A_STORE_ID IN (SELECT STORE_ID FROM STORES_DEF WHERE SC_ID = '" + sc_id + "')");
try
{
dsMaterialBTableAdapters.PIP_MAT_TRANSFTableAdapter item = new dsMaterialBTableAdapters.PIP_MAT_TRANSFTableAdapter();
item.InsertQuery(decimal.Parse(Session["PROJECT_ID"].ToString()), trans_no, System.DateTime.Now, Session["USER_NAME"].ToString(), decimal.Parse(from_store),
decimal.Parse(to_store), null, "MAIN", 3, doc);
trans_id = WebTools.GetExpr("TRANSF_ID", "PIP_MAT_TRANSF", " WHERE TRANSF_NO='" + trans_no + "'");
if (!string.IsNullOrEmpty(trans_id))
{
//Update Transfer Detail
dsMaterialBTableAdapters.PIP_MAT_TRANSF_DETAILTableAdapter detail = new dsMaterialBTableAdapters.PIP_MAT_TRANSF_DETAILTableAdapter();
dsPaintingMat.VIEW_BULK_PAINT_ISSUE_DETAILDataTable dt = new dsPaintingMat.VIEW_BULK_PAINT_ISSUE_DETAILDataTable();
dsPaintingMatTableAdapters.VIEW_BULK_PAINT_ISSUE_DETAILTableAdapter issue = new dsPaintingMatTableAdapters.VIEW_BULK_PAINT_ISSUE_DETAILTableAdapter();
dt = issue.GetData(decimal.Parse(itemsGrid.SelectedValue.ToString()));
foreach (DataRow r in dt.Rows)
{
detail.InsertQuery(decimal.Parse(trans_id), decimal.Parse(r["MAT_ID"].ToString()), r["HEAT_NO"].ToString(), decimal.Parse(r["ISSUE_QTY"].ToString()), "XXX", 1,
null, null, r["PAINT_CODE"].ToString().Length == 0 ? "XXX" : r["PAINT_CODE"].ToString());
}
}
Master.ShowMessage(trans_no + " Created Successfully.");
}
catch (Exception ex)
{
trans_id = WebTools.GetExpr("TRANSF_ID", "PIP_MAT_TRANSF", " WHERE TRANSF_NO='" + trans_no + "'");
string sql = "DELETE FROM PIP_MAT_TRANSF_DETAIL WHERE TRANSF_ID = '" + trans_id + "'";
WebTools.ExeSql(sql);
sql = "DELETE FROM PIP_MAT_TRANSF WHERE TRANSF_ID = '" + trans_id + "'";
WebTools.ExeSql(sql);
Master.ShowError(ex.Message);
}
}
