protected void btnSubmit_Click(object sender, EventArgs e) { decimal mat_id = db_lookup.MAT_ID(txtMatSearch.Text, Decimal.Parse(Session["PROJECT_ID"].ToString())); if (mat_id == 0) { Master.ShowWarn("Material Code not found!"); return; } //decimal bal_qty = db_lookup.DSum("BAL_QTY", "VIEW_ITEM_REP_A", " WHERE MAT_ID=" + mat_id + " AND SUB_CON_ID=" + Request.QueryString["SC_ID"]); //if (bal_qty < decimal.Parse(txtQty.Text) && Request.QueryString["SC_ID"] != "2") //{ // Master.ShowWarn("Material not found in stock!, Please check the quantity carefully."); // return; //} string sc_id = WebTools.GetExpr("SC_ID", "PIP_MAT_ISSUE_ADD", " WHERE ADD_ISSUE_ID='" + Request.QueryString["ADD_ISSUE_ID"].ToString() + "'"); string stock_qty = WebTools.GetExpr("BAL_QTY", "VIEW_ITEM_REP_A", " WHERE MAT_ID= '" + HiddenMatID.Value + "' AND SUB_CON_ID='" + sc_id + "'"); if (stock_qty == null || decimal.Parse(stock_qty) < decimal.Parse(txtQty.Text)) { Master.ShowError("Issue quantity is more than current available stock qty. Current stock quantity is " + stock_qty + "."); return; } string HeatNo, PaintSys; PIP_MAT_ISSUE_ADD_DETAILTableAdapter items = new PIP_MAT_ISSUE_ADD_DETAILTableAdapter(); try { HeatNo = txtAutoHeatNo.Entries[0].Text; if (txtAutoPaintSys.Entries.Count > 0) { PaintSys = txtAutoPaintSys.Entries[0].Text; } else { PaintSys = string.Empty; } items.InsertQuery( Decimal.Parse(Request.QueryString["ADD_ISSUE_ID"]), mat_id, decimal.Parse(txtQty.Text), HeatNo, PaintSys, txtRemarks.Text); Master.ShowMessage(txtMatSearch.Text + " Saved."); itemsGridView.Rebind(); } catch (Exception ex) { Master.ShowWarn(ex.Message); } finally { items.Dispose(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { decimal mat_id = db_lookup.MAT_ID(txtMatCode.Text, Decimal.Parse(Session["PROJECT_ID"].ToString())); if (mat_id == 0) { //Master.ShowWarn("Material Code not found!"); RadWindowManager1.RadAlert("Material Code not found!", 400, 150, "Warning", ""); return; } //if (ddlMatRequestNo.SelectedValue == "") //{ // //Master.ShowWarn("Select Material Request Number!"); // RadWindowManager1.RadAlert("Select Material Request Number!", 400, 150, "Warning", ""); // return; //} string sub_con_id = WebTools.GetExpr("SC_ID", "PIP_MAT_ISSUE_ADD", " WHERE ADD_ISSUE_ID='" + Request.QueryString["ADD_ISSUE_ID"] + "'"); decimal bal_qty = db_lookup.DSum("BAL_QTY", "VIEW_ITEM_REP_A", " WHERE MAT_ID=" + mat_id + " AND SUB_CON_ID=" + sub_con_id); if (bal_qty < decimal.Parse(txtQty.Text)) { // Master.ShowWarn("Material not found in stock!, Please check the quantity carefully."); RadWindowManager1.RadAlert("Material not found in stock!, Please check the quantity carefully.", 00, 150, "Warning", ""); return; } PIP_MAT_ISSUE_ADD_DETAILTableAdapter items = new PIP_MAT_ISSUE_ADD_DETAILTableAdapter(); try { items.InsertQuery( Decimal.Parse(Request.QueryString["ADD_ISSUE_ID"]), mat_id, decimal.Parse(txtQty.Text), txtHeatNo.Text, txtPaintCode.Text, txtRemarks.Text, txtCableDrumNo.Text ); Master.ShowMessage(txtMatCode.Text + " Saved."); itemsGridView.DataBind(); } catch (Exception ex) { Master.ShowWarn(ex.Message); } finally { items.Dispose(); } }