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); } }