public RPDBatchProduction Get(String RPDBatchID, String MaterialCode) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@RPDBatchID", RPDBatchID), new SqlParameter("@MaterialCode", MaterialCode) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_RPDBatchProduction_By_ID", paramList); RPDBatchProduction obj = new RPDBatchProduction(); if (dt.Rows.Count > 0) { obj.RPDBatch = objRPDBatch_DL.Get(Convert.ToString(dt.Rows[0]["RPDBatchID"])); obj.MaterialQuantity = Convert.ToDecimal(dt.Rows[0]["Qty"]); obj.Material = objMaterial_DL.Get(Convert.ToString(dt.Rows[0]["MaterialCode"])); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void ClearProduction() { if (cmbMaterialInter.Items.Count > 0) { cmbMaterialInter.SelectedIndex = 0; } txtMaterialQty.Text = "0.00"; objRPDBatchProduction = null; btnMaterialDelete.Enabled = false; }
private void btnAddMaterial_Click(object sender, EventArgs e) { try { if (Convert.ToDecimal(txtMaterialQty.Text) <= 0) { MessageBox.Show(this, "Invalid Quantity", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { String OriginalMaterilCode = ""; if (objRPDBatchProduction != null) { OriginalMaterilCode = objRPDBatchProduction.Material.MaterialCode; } else { objRPDBatchProduction = new RPDBatchProduction(); } objRPDBatchProduction.Material = objMaterialDL.Get(cmbMaterialInter.SelectedValue.ToString()); objRPDBatchProduction.MaterialQuantity = Convert.ToDecimal(txtMaterialQty.Text); objRPDBatchProduction.RPDBatch = objRPDBatch; int res = objRPDBatchProductionDL.Add(objRPDBatchProduction, OriginalMaterilCode); if (res > 0) { ClearProduction(); gvProduction.AutoGenerateColumns = false; bindProduction.DataSource = objRPDBatchProductionDL.GetDataByBatchID(objRPDBatch.RPDBatchID); gvProduction.DataSource = bindProduction; bindProduction.ResetBindings(true); } } } catch (SqlException sqlex) { if (sqlex.Number == 2627) { MessageBox.Show(this, "Selected material already added", "Duplicate Data", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(this, "SQL error occured", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception) { MessageBox.Show(this, "Error occured while saving production details", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void gvProduction_CellClick(object sender, DataGridViewCellEventArgs e) { try { String Material = (gvProduction.Rows[e.RowIndex].Cells["MaterialCode"].Value.ToString()); objRPDBatchProduction = objRPDBatchProductionDL.Get(objRPDBatch.RPDBatchID, Material); txtMaterialQty.Text = objRPDBatchProduction.MaterialQuantity.ToString(); cmbMaterialInter.SelectedValue = objRPDBatchProduction.Material.MaterialCode; btnMaterialDelete.Enabled = true; } catch (Exception) { MessageBox.Show(this, "Error occured while selecting record", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public int Update(RPDBatchProduction obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@RPDBatchID", obj.RPDBatch), new SqlParameter("@MaterialCode", obj.Material), new SqlParameter("@Qty", obj.MaterialQuantity) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_RPDBatchProduction", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(RPDBatchProduction obj, String OriginalMaterialCode) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@RPDBatchID", obj.RPDBatch.RPDBatchID), new SqlParameter("@MaterialCode", obj.Material.MaterialCode), new SqlParameter("@OriginalMaterialCode", obj.Material.MaterialCode), new SqlParameter("@Qty", obj.MaterialQuantity) }; return(Execute.RunSP_RowsEffected(Connection, "SPADD_RPDBatchProduction_Update", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }