protected void ddlMR_SelectedIndexChanged(object sender, DropDownListEventArgs e)
{
string mr_item = ddlMR.SelectedValue;
if (mr_item.Equals("-1"))
{
return;
}
int mat_id = int.Parse(WebTools.GetExpr("MAT_ID", "PIP_MAT_STOCK", " MAT_CODE1='" + ddlMatCode.SelectedItem.Text + "'"));
int mat_req_id = int.Parse(WebTools.GetExpr("MAT_REQ_ID", "PIP_MAT_TRANSF", "PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " AND TRANSF_ID=" + Request.QueryString["TRANSF_ID"]));
req_qty = WebTools.DSum("REQ_QTY", "MATERIAL_REQUEST_DETAIL", " MAT_REQ_ID=" + mat_req_id + " AND MAT_ID=" + mat_id + " AND mr_item_no=" + mr_item);
issued_qty = WebTools.DSum("TRANSF_QTY", "VIEW_MAT_ISSUE_BALANCE_MAIN2", " MAT_REQ_ID=" + mat_req_id + " AND MAT_ID=" + mat_id + " AND mr_item_no=" + mr_item);
string item_id = WebTools.GetExpr("ITEM_ID", "PIP_MAT_STOCK", " MAT_CODE1='" + ddlMatCode.SelectedItem.Text + "'");
item_name = WebTools.GetExpr("SG_GROUP", "PIP_MAT_ITEM", " ITEM_ID=" + item_id);
if (item_name.ToUpper().Contains("PIP"))
{
lblbalqty.Text = "Can Issue Approximately: " + (req_qty - issued_qty);
}
else
{
lblbalqty.Text = "Can Issue Max Qty: " + (req_qty - issued_qty);
}
}
protected void ddlPOItems_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
txtMatCode.Text = WebTools.GetExpr("MAT_CODE1", "VIEW_ADAPTER_PO_DETAIL", " WHERE PO_ITEM_ID='" + ddlPOItems.SelectedValue + "'");
txtPOItemNO.Text = WebTools.GetExpr("PO_ITEM", "VIEW_ADAPTER_PO_DETAIL", " PO_ITEM_ID='" + ddlPOItems.SelectedValue + "'");
string RFI_ID = WebTools.GetExpr("RFI_ID", "PRC_MAT_INSP", " WHERE MIR_ID='" + Session["popUp_MIR_ID"].ToString() + "'");
txtRcvQty.Text = WebTools.DSum("BAL_MRIR_QTY", "VIEW_MRIR_BAL_FROM_RFI", " WHERE RFI_ID='" + RFI_ID + "' AND PO_ITEM = '" + txtPOItemNO.Text + "'").ToString();
string pieces = WebTools.GetExpr("BAL_PIECES", "VIEW_MRIR_BAL_FROM_RFI", " WHERE RFI_ID='" + RFI_ID + "' AND PO_ITEM = '" + txtPOItemNO.Text + "'").ToString();
if (pieces == "N/A" || pieces == "")
{
pieces = "0";
}
txtPieces.Text = pieces;
txtMatDescr.Text = WebTools.GetExpr("MAT_DESCR", "PIP_MAT_STOCK", " MAT_CODE1='" + txtMatCode.Text + "'");
}
protected void ddlMR_SelectedIndexChanged(object sender, DropDownListEventArgs e)
{
decimal pieces = 0;
string mr_item = ddlMR.SelectedValue;
if (mr_item.Equals("-1"))
{
return;
}
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();
pieces = WebTools.DSum("NO_OF_PIECE", "PIP_MAT_TRANSF_DETAIL", " TRANSF_ID=" + TRANSF_ID + " AND MAT_ID=" + mat_id + " AND mr_item_no=" + mr_item);
txtPieces.Text = pieces.ToString();
}
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 Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Master.HeadingMessage("Material Details(" + Request.QueryString["MAT_CODE1"] + ")");
MR.MasterTableView.AllowPaging = false;
MR.Rebind();
decimal mr_sum = WebTools.DSum("MR_QTY", "VIEW_MAT_REQUISITION", "CLIENT_PART_NO='" + Request.QueryString["MAT_CODE1"] + "'");
lblMrCnt.Text = "Count :" + MR.MasterTableView.Items.Count.ToString();
lblMrSum.Text = "Sum :" + mr_sum.ToString();
PO.MasterTableView.AllowPaging = false;
PO.Rebind();
decimal po_sum = WebTools.DSum("PO_QTY", "VIEW_PO_REPORT_MAIN", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'");
lblPoCnt.Text = "Count :" + PO.MasterTableView.Items.Count.ToString();
lblPoSum.Text = "Sum :" + po_sum.ToString();
Batch.MasterTableView.AllowPaging = false;
Batch.Rebind();
decimal batch_sum = WebTools.DSum("BATCH_QTY", "VIEW_PO_BATCH_PLAN_DETAIL", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'");
lblBatchCnt.Text = "Count :" + Batch.MasterTableView.Items.Count.ToString();
lblBatchSum.Text = "Sum :" + batch_sum.ToString();
IRN.MasterTableView.AllowPaging = false;
IRN.Rebind();
decimal irn_sum = WebTools.DSum("RELEASE_QTY", "VIEW_PO_IRN_DETAIL_REP", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'");
lblIrnCnt.Text = "Count :" + IRN.MasterTableView.Items.Count.ToString();
lblIrnSum.Text = "Sum :" + irn_sum.ToString();
MRR.MasterTableView.AllowPaging = false;
MRR.Rebind();
decimal mrr_sum = WebTools.DSum("RECV_QTY", "VIEW_MAT_RCV_REPORT_DT", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'");
lblMrrCnt.Text = "Count :" + MRR.MasterTableView.Items.Count.ToString();
lblMrrSum.Text = "Sum :" + mrr_sum.ToString();
RFI.MasterTableView.AllowPaging = false;
RFI.Rebind();
decimal rfi_sum = WebTools.DSum("INSP_QTY", "VIEW_MAT_RFI_REPORT", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'");
lblRfiCnt.Text = "Count :" + RFI.MasterTableView.Items.Count.ToString();
lblRfiSum.Text = "Sum :" + rfi_sum.ToString();
MRIR.MasterTableView.AllowPaging = false;
MRIR.Rebind();
decimal mrir_sum = WebTools.DSum("ACPT_QTY", "VIEW_MAT_MRIR_REPORT", "MAT_CODE='" + Request.QueryString["MAT_CODE1"] + "'");
lblMrirCnt.Text = "Count :" + MRIR.MasterTableView.Items.Count.ToString();
lblMrirSum.Text = "Sum :" + mrir_sum.ToString();
MaterialRequest.MasterTableView.AllowPaging = false;
MaterialRequest.Rebind();
decimal mat_req_sum = WebTools.DSum("REQ_QTY", "VIEW_MATERIAL_REQUEST_DT1", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'");
lblMaterialRequestCnt.Text = "Count :" + MaterialRequest.MasterTableView.Items.Count.ToString();
lblMaterialRequestSum.Text = "Sum :" + mat_req_sum.ToString();
MTN.MasterTableView.AllowPaging = false;
MTN.Rebind();
decimal mtn_sum = WebTools.DSum("TRANSF_QTY", "VIEW_ADAPTER_MAT_TRANSF_DT1", "MATERIAL_CODE='" + Request.QueryString["MAT_CODE1"] + "'");
lblMtnCnt.Text = "Count :" + MTN.MasterTableView.Items.Count.ToString();
lblMtnSum.Text = "Sum :" + mtn_sum.ToString();
MTNreceive.MasterTableView.AllowPaging = false;
MTNreceive.Rebind();
decimal mtn_recv_sum = WebTools.DSum("RCV_QTY", "VIEW_MAT_TRANSFER_RCV_DT", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'");
lblMtnRcvCnt.Text = "Count :" + MTNreceive.MasterTableView.Items.Count.ToString();
lblMtnRcvSum.Text = "Sum :" + mtn_recv_sum.ToString();
MIV.MasterTableView.AllowPaging = false;
MIV.Rebind();
decimal miv_sum = WebTools.DSum("ISSUE_QTY", "VIEW_ADAPTER_ISSUE_ADD_DETAIL", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'");
lblMivCnt.Text = "Count :" + MIV.MasterTableView.Items.Count.ToString();
lblMivSum.Text = "Sum :" + miv_sum.ToString();
Reconcilation.MasterTableView.AllowPaging = false;
Reconcilation.Rebind();
decimal recon_sum = WebTools.DSum("BAL_QTY", "VIEW_ITEM_REP_A", "MAT_CODE1='" + Request.QueryString["MAT_CODE1"] + "'");
lblReconCnt.Text = "Count :" + Reconcilation.MasterTableView.Items.Count.ToString();
lblReconSum.Text = "Sum :" + recon_sum.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Master.HeadingMessage = "Home";
if (!IsPostBack)
{
if (WebTools.UserInRole("FATA"))
{
FataRow.Visible = true;
}
else
{
FataRow.Visible = false;
}
//RadHtmlChart1_EPIC.DataSource = dsISOPlanningReport_EPIC;
//RadHtmlChart1_EPIC.DataBind();
PieChart1.DataSource = sqlIsomeSheetStatus;
PieChart1.DataBind();
PieChart2.DataSource = sqlInchDiaStatus;
PieChart2.DataBind();
PieChart3.DataSource = FabMatAvlStatus;
PieChart3.DataBind();
//PieChart4.DataSource = SpoolFabStatus;
//PieChart4.DataBind();
//DivWiseScope1.DataSource = DivWiseMatAvlStatus;
//DivWiseScope1.DataBind();
//DivWiseScope2.DataSource = DivWiseSplStatus;
//DivWiseScope2.DataBind();
//PieChart5.DataSource = dsISOPlanningReport;
//PieChart5.DataBind();
//PieChart6.DataSource = dsISOPlanningReport;
//PieChart6.DataBind();
//PieChart5.PlotArea.XAxis.AxisCrossingPoints[0].Value = 100;
//PieChart5.PlotArea.XAxis.AxisCrossingPoints[1].Value = decimal.Parse("100");
ddlPriority.DataSource = PriorityDataSource;
ddlPriority.DataBind();
ddlArea.DataSource = AreaDataSource;
ddlArea.DataBind();
//ddlPriority.DataSource = PriorityDataSource;
//ddlPriority.DataTextField = "AREA_PRIORITY";
//ddlPriority.DataValueField = "AREA_PRIORITY";
//ddlArea.DataSource = AreaDataSource;
//ddlArea.DataTextField = "AREA";
//ddlArea.DataValueField = "AREA";
Decimal total_scope = WebTools.DSum("CNT", "VIEW_SPOOLS_DASHBOARD", "1=1");
//lblSplFabStatus.Text = lblSplFabStatus.Text + String.Format(CultureInfo.InvariantCulture,
// "{0:0,0}", total_scope);
//lblDivWiseStatus2.Text = lblDivWiseStatus2.Text + String.Format(CultureInfo.InvariantCulture,
// "{0:0,0}", total_scope);
//PieChart4.DataBind();
total_scope = WebTools.DSum("CNT", "VIEW_FAB_INCH_DIA_DASHBOARD", "1=1");
lblFabMatStatus.Text = lblFabMatStatus.Text + String.Format(CultureInfo.InvariantCulture,
"{0:0,0}", total_scope);
//lblDivWiseStatus.Text = lblFabMatStatus.Text;
total_scope = WebTools.DSum("CNT", "VIEW_INCH_DIA_DASHBOARD", "1=1");
lblInchDiaStatus.Text = lblInchDiaStatus.Text + String.Format(CultureInfo.InvariantCulture,
"{0:0,0}", total_scope);
total_scope = WebTools.DSum("CNT", "VIEW_ISO_SHT_STATUS_DASHBOARD", "1=1");
lblIsomeShtStatus.Text = lblIsomeShtStatus.Text + String.Format(CultureInfo.InvariantCulture,
"{0:0,0}", total_scope);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Procurement_BTableAdapters.VIEW_PO_IRN_DETAILTableAdapter irn = new Procurement_BTableAdapters.VIEW_PO_IRN_DETAILTableAdapter();
CheckBox cb;
decimal mat_id;
string insp_qty, rel_qty, pieces;
decimal po_qty, released_qty;
int count = 0;
int success_cnt = 0;
string err_po_item_no = "";
string po_id = WebTools.GetExpr("PO_ID", "PIP_PO_IRN", " WHERE IRN_ID = '" + Request.QueryString["IRN_ID"] + "'");
try
{
foreach (GridDataItem item in itemsGrid.Items)
{
cb = ((CheckBox)item["checkCol"].FindControl("checkItems"));
if (cb.Checked)
{
//Label lbl1 = (Label)item.FindControl("PO_QTY");
// po_qty = decimal.Parse(lbl1.Text);
//Label lbl2 = (Label)item.FindControl("REL_QTY");
//released_qty = decimal.Parse(lbl2.Text);
mat_id = WebTools.GetMatId(item["MAT_CODE1"].Text, decimal.Parse(Session["PROJECT_ID"].ToString()));
string bal_qty_left = WebTools.GetExpr("BAL_REL_QTY", "VIEW_PO_IRN_BAL", " WHERE PO_ID = '" + decimal.Parse(po_id) + "' AND PO_ITEM_NO='" + item["PO_ITEM_NO"].Text + "'");
insp_qty = (item["BAL_REL_QTY"].FindControl("BAL_REL_QTYTextBox") as TextBox).Text;
rel_qty = (item["BAL_REL_QTY"].FindControl("BAL_REL_QTYTextBox") as TextBox).Text;
pieces = (item["BAL_PIECES"].FindControl("BAL_PIECESTextBox") as TextBox).Text;
if (pieces == "N/A")
{
pieces = "0";
}
if (bal_qty_left == "" || bal_qty_left == string.Empty)
{
bal_qty_left = "0";
}
if (rel_qty == "" || rel_qty == string.Empty)
{
rel_qty = "0";
}
// ELECTRICAL==2
po_qty = decimal.Parse(WebTools.GetExpr("PO_QTY", "PIP_PO_DETAIL", " WHERE PO_ID = '" + decimal.Parse(po_id) + "' AND PO_ITEM='" + item["PO_ITEM_NO"].Text + "'"));
released_qty = WebTools.DSum("RELEASE_QTY", "PIP_PO_IRN_DETAIL", " WHERE PO_ID=" + decimal.Parse(po_id) + " AND PO_ITEM='" + item["PO_ITEM_NO"] + "'");
string discipline = WebTools.GetExpr("DISCIPLINE_ID", "PIP_PO", " WHERE PO_ID=" + decimal.Parse(po_id));
string chk_discipline = WebTools.GetExpr("DISCIPLINE_ID", "PIP_PO_DISCIPLINE", " WHERE DISCIPLINE_ID=" + discipline);
if ((decimal.Parse(bal_qty_left) >= decimal.Parse(rel_qty) && decimal.Parse(rel_qty) > 0) || (chk_discipline != string.Empty))
{
if (decimal.Parse(bal_qty_left) < decimal.Parse(rel_qty))
{
err_po_item_no += item["PO_ITEM_NO"].Text + " , ";
}
irn.InsertQuery(decimal.Parse(Request.QueryString["IRN_ID"]), item["PO_ITEM_NO"].Text, mat_id, decimal.Parse(rel_qty), decimal.Parse(insp_qty), decimal.Parse(po_id), decimal.Parse(pieces));
success_cnt++;
}
else
{
count++;
err_po_item_no += item["PO_ITEM_NO"].Text + " , ";
}
}
}
string msg = "";
if (err_po_item_no.Length > 0)
{
msg += "Rel Qty greater than PO Qty for Po Item No : " + err_po_item_no + "<br/> ";
}
if (success_cnt > 0)
{
msg = "Selected Item(s) Imported, <br/> ";
Master.ShowSuccess("Selected Item(s) Imported");
}
else
{
Master.ShowWarn(msg);
}
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
finally {
irn.Dispose();
itemsGrid.Rebind();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
decimal mat_id = db_lookup.MAT_ID(ddlMatCode.SelectedItem.Text, Decimal.Parse(Session["PROJECT_ID"].ToString()));
string mr_item = ddlMR.SelectedValue.ToString();
if (mat_id == 0)
{
Master.ShowWarn("Material Code not found!");
return;
}
if (mr_item == "-1")
{
Master.ShowWarn("Please select Mr Item No");
return;
}
int mat_req_id = int.Parse(WebTools.GetExpr("MAT_REQ_ID", "PIP_MAT_TRANSF", "PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " AND TRANSF_ID=" + Request.QueryString["TRANSF_ID"]));
req_qty = WebTools.DSum("REQ_QTY", "MATERIAL_REQUEST_DETAIL", " MAT_REQ_ID=" + mat_req_id + " AND MAT_ID=" + mat_id + " AND MR_ITEM_NO=" + mr_item);
issued_qty = WebTools.DSum("TRANSF_QTY", "PIP_MAT_TRANSF_DETAIL", "TRANSF_ID=" + Request.QueryString["TRANSF_ID"] + " AND MAT_ID=" + mat_id + " AND MR_ITEM_NO=" + mr_item);
string item_id = WebTools.GetExpr("ITEM_ID", "PIP_MAT_STOCK", " MAT_CODE1='" + ddlMatCode.SelectedItem.Text + "'");
item_name = WebTools.GetExpr("SG_GROUP", "PIP_MAT_ITEM", " ITEM_ID=" + item_id);
//bal qty to check before transfer
string from_store = WebTools.GetExpr("A_STORE_ID", "PIP_MAT_TRANSF", " TRANSF_ID='" + Request.QueryString["TRANSF_ID"] + "'");
string from_sc = WebTools.GetExpr("SC_ID", "STORES_DEF", " STORE_ID='" + from_store + "'");
string bal_qty_left = WebTools.GetExpr("BAL_QTY", "VIEW_ITEM_REP_A", " MAT_CODE1='" + ddlMatCode.SelectedItem.Text + "' AND SUB_CON_ID='" + from_sc + "'");
if (bal_qty_left == "" || bal_qty_left == string.Empty)
{
bal_qty_left = "0";
}
decimal bal_qty = decimal.Parse(bal_qty_left);
string po_bal_qty_left = WebTools.GetExpr("WHC_PO_BAL_QTY", "VIEW_MAT_ISSUE_BALANCE_MAIN2", " MAT_CODE1='" + ddlMatCode.SelectedItem.Text + "' AND SUB_CON_ID='" + from_sc + "' AND PO_ID = '" + ddlPO.SelectedValue + "'");
if (po_bal_qty_left == "" || po_bal_qty_left == string.Empty)
{
po_bal_qty_left = "0";
}
decimal po_bal_qty = decimal.Parse(po_bal_qty_left);
if (bal_qty - decimal.Parse(txtQty.Text) >= 0)
{
if (((req_qty - issued_qty) < decimal.Parse(txtQty.Text)) && (!item_name.ToUpper().Contains("PIP")))
{
Master.ShowError("Other than Pipe cannot issue more than requested qty");
return;
}
else
{
VIEW_ADAPTER_MAT_TRANSF_DTTableAdapter items = new VIEW_ADAPTER_MAT_TRANSF_DTTableAdapter();
items.InsertQuery(
Decimal.Parse(Request.QueryString["TRANSF_ID"]),
mat_id, ddlHeatNo.SelectedValue, ddlCabledrum.SelectedValue,
Decimal.Parse(txtQty.Text),
txtBoxNo.Text,
decimal.Parse(txtNO_OF_PIECE.Text),
decimal.Parse("0"),
txtRemarks.Text,
txtPaintCode.Text,
decimal.Parse(ddlPO.SelectedValue),
decimal.Parse(ddlMR.SelectedValue)
);
itemsGridView.DataBind();
Master.ShowMessage(ddlMatCode.SelectedItem.Text + " Saved!");
}
}
else
{
Master.ShowWarn(ddlMatCode.SelectedItem.Text + " Stock Not Available");
}
}
catch (Exception ex)
{
Master.ShowWarn(ex.Message);
}
}
