protected void btnYes_Click(object sender, EventArgs e)
{
try
{
dsMaterialETableAdapters.VIEW_MAT_TRANSFER_RCV_DTTableAdapter receive = new dsMaterialETableAdapters.VIEW_MAT_TRANSFER_RCV_DTTableAdapter();
receive.DeleteQuery(decimal.Parse(itemsGrid.SelectedValue.ToString()));
Master.ShowMessage("Item Deleted.");
itemsGrid.Rebind();
btnYes.Visible = false;
btnNo.Visible = false;
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
decimal excess = 0, shortage = 0, damage = 0;
bool ex = decimal.TryParse(txtExcess.Text, out excess);
bool sh = decimal.TryParse(txtShort.Text, out shortage);
bool dm = decimal.TryParse(txtDamage.Text, out damage);
dsMaterialETableAdapters.VIEW_MAT_TRANSFER_RCV_DTTableAdapter receive = new dsMaterialETableAdapters.VIEW_MAT_TRANSFER_RCV_DTTableAdapter();
receive.InsertQuery(decimal.Parse(Request.QueryString["id"]), decimal.Parse(HiddenMatID.Value), decimal.Parse(txtReceiveQty.Text), txtAutoHeatNo.Entries[0].Text,
txtAutoPS.Text, "", decimal.Parse(Session["PROJECT_ID"].ToString()), sh?excess:0, dm?damage:0, ex?excess:0);
Master.ShowMessage("Item Added.");
itemsGrid.Rebind();
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string mr_item = ddlMR.SelectedValue;
int mat_id = int.Parse(WebTools.GetExpr("MAT_ID", "PIP_MAT_STOCK", " MAT_CODE1='" + cboMatCode.SelectedItem.Text + "'"));
int TRANSF_ID = int.Parse(WebTools.GetExpr("TRANSF_ID", "PIP_MAT_TRANSFER_RCV", "RCV_ID=" + Request.QueryString["id"]));
trans_qty = WebTools.DSum("TRANSF_QTY", "PIP_MAT_TRANSF_DETAIL", " TRANSF_ID=" + TRANSF_ID + " AND MAT_ID=" + mat_id + " AND mr_item_no=" + mr_item);
rcv_qty = WebTools.DSum("rcv_qty", "PIP_MAT_TRANSFER_RCV_DT", "RCV_ID=" + Request.QueryString["id"] + " AND MAT_ID=" + mat_id + " AND mr_item_no=" + mr_item);
txtReceiveQty.Text = (trans_qty - rcv_qty).ToString();
decimal result = decimal.Parse(txtReceiveQty.Text);
if (result > 0)
{
try
{
decimal excess = 0, shortage = 0, damage = 0;
bool ex = decimal.TryParse(txtExcess.Text, out excess);
bool sh = decimal.TryParse(txtShort.Text, out shortage);
bool dm = decimal.TryParse(txtDamage.Text, out damage);
dsMaterialETableAdapters.VIEW_MAT_TRANSFER_RCV_DTTableAdapter receive = new dsMaterialETableAdapters.VIEW_MAT_TRANSFER_RCV_DTTableAdapter();
receive.InsertQuery(decimal.Parse(Request.QueryString["id"]), decimal.Parse(HiddenMatID.Value), decimal.Parse(txtReceiveQty.Text), ddlHeatNo.SelectedText, ddlCableDrum.SelectedText,
ddlps.SelectedText, "", decimal.Parse(Session["PROJECT_ID"].ToString()), sh?excess:0, dm?damage:0, ex?excess:0, decimal.Parse(ddlPO.SelectedValue)
, decimal.Parse(mr_item), decimal.Parse(txtPieces.Text));
Master.ShowMessage("Item Added.");
itemsGrid.Rebind();
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
else
{
Master.ShowError("Receive QTY More than Transfer Qty");
}
}
//protected void checkPOItem_CheckedChanged(object sender, EventArgs e)
//{
// CheckBox cb = (CheckBox)sender;
//}
protected void btnSave_Click(object sender, EventArgs e)
{
if (itemsGrid.SelectedIndexes.Count == 0)
{
Master.ShowMessage("Select Material to Import.");
return;
}
string mat_id;
string drum_no;
string heat_no;
string paint_sys;
string bal_rcv_qty;
string excess_qty;
string short_qty;
string damage_qty;
string po_id;
string mr_item_no;
string no_of_piece;
string transf_qty;
string recv_qty;
dsMaterialETableAdapters.VIEW_MAT_TRANSFER_RCV_DTTableAdapter receive_transf = new dsMaterialETableAdapters.VIEW_MAT_TRANSFER_RCV_DTTableAdapter();
string sql = string.Empty;
try
{
foreach (GridDataItem item in itemsGrid.SelectedItems)
{
heat_no = (item["HEAT_NO"].FindControl("ddlHeatNo") as RadDropDownList).SelectedValue;
drum_no = (item["CABLE_DRUM_NO"].FindControl("ddlCableNo") as RadDropDownList).SelectedValue;
paint_sys = item["PAINT_SYS"].Text;
po_id = item["PO_ID"].Text;
mat_id = WebTools.GetExpr("MAT_ID", "PIP_MAT_STOCK", " WHERE MAT_CODE1='" + item["MAT_CODE1"].Text + "'");
bal_rcv_qty = ((item["BAL_QTY"].FindControl("BAL_QTYLabel")) as RadTextBox).Text;
excess_qty = ((item["EXCESS_QTY"].FindControl("EXCESS_QTYLabel")) as RadTextBox).Text;
short_qty = ((item["SHORT_QTY"].FindControl("SHORT_QTYLabel")) as RadTextBox).Text;
damage_qty = ((item["DAMAGE_QTY"].FindControl("DAMAGE_QTYLabel")) as RadTextBox).Text;
mr_item_no = item["MR_ITEM_NO"].Text;
transf_qty = WebTools.GetExpr("TRANSF_QTY", "view_mat_transfer_rcv_bal", " WHERE TRANSF_ID = '" + Request.QueryString["TRANSF_ID"] + "' AND MR_ITEM_NO='" + mr_item_no + "'");
recv_qty = WebTools.GetExpr("rcv_qty", "view_mat_transfer_rcv_bal", " WHERE TRANSF_ID = '" + Request.QueryString["TRANSF_ID"] + "' AND MR_ITEM_NO='" + mr_item_no + "'");
no_of_piece = ((item["NO_OF_PIECE"].FindControl("NO_OF_PIECELabel")) as RadTextBox).Text;
if (decimal.Parse(transf_qty) - decimal.Parse(recv_qty) >= decimal.Parse(bal_rcv_qty))
{
receive_transf.InsertQuery(decimal.Parse(Request.QueryString["rcv_id"]), decimal.Parse(mat_id), decimal.Parse(bal_rcv_qty), heat_no, drum_no,
paint_sys, "", decimal.Parse(Session["PROJECT_ID"].ToString()), decimal.Parse(short_qty), decimal.Parse(damage_qty), decimal.Parse(excess_qty), decimal.Parse(po_id),
decimal.Parse(mr_item_no), decimal.Parse(no_of_piece));
}
else
{
Master.ShowError("Receive Quantity cannot be more than Transfer qty. ");
return;
}
//if (decimal.Parse(rcv_qty) >= ((insp_qty.Trim() == "" ? 0 : decimal.Parse(insp_qty)) + decimal.Parse(bal_to_insp)))
//{
// receive_transf.InsertQuery(decimal.Parse(Request.QueryString["rcv_id"]), mat_id, decimal.Parse(rcv_qty), heat_no,
//paint_sys, "", decimal.Parse(Session["PROJECT_ID"].ToString()), decimal.Parse(EXCESS_QTYTextBox.Text));
//}
//else
//{
// Master.ShowError("Inspection quantity cannot be more than received qty.");
//}
}
itemsGrid.Rebind();
Master.ShowSuccess("Selected Item(s) Imported");
// Response.Redirect("ImportFromMTNTransf.aspx?TRANSF_ID=" + Request.QueryString["TRANSF_ID"] + "&RCV_ID=" + Request.QueryString["RCV_ID"]);
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
