public FormulaBasicProduct Get(long FormulaID, String BasicProductCode, String FormulaPart) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@FormulaID", FormulaID), new SqlParameter("@FormulaBasicProductCode", BasicProductCode), new SqlParameter("@FormulaPart", FormulaPart) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_FormulaBasicProductByID", paramList); FormulaBasicProduct objFormulaBasicProduct = new FormulaBasicProduct(); for (int i = 0; i < dt.Rows.Count; i++) { objFormulaBasicProduct.BasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[0]["FormulaBasicProductCode"])); objFormulaBasicProduct.Formula = objFormula_DL.Get(Convert.ToInt32(dt.Rows[0]["FormulaID"])); objFormulaBasicProduct.FormulaPart = Convert.ToString(dt.Rows[0]["FormulaPart"]); objFormulaBasicProduct.FormulaProductQty = Convert.ToDecimal(dt.Rows[0]["FormulaProductQty"]); } return(objFormulaBasicProduct); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void btnBasicAdd_Click(object sender, EventArgs e) { FormulaBasicProduct objFormulaBasicProduct = new FormulaBasicProduct(); try { if (cmbBasicProducts.Items.Count > 0 && DataValidation.Is3DecimalPointNumber(txtBasicProductQty.Text)) { objFormulaBasicProduct.BasicProduct = objBasicProductDL.Get(cmbBasicProducts.SelectedValue.ToString()); objFormulaBasicProduct.Formula = objFormula; objFormulaBasicProduct.FormulaPart = cmbBasicPart.SelectedItem.ToString(); objFormulaBasicProduct.FormulaProductQty = Convert.ToDecimal(txtBasicProductQty.Text); objFormulaBasicProductDL.Add(objFormulaBasicProduct, CurrentUser.UserEmp); bindBasicProduct.DataSource = objFormulaBasicProductDL.GetDataView_FormulaID(objFormula.FormulaID); bindItemList.DataSource = objFormulaDL.GetDataView_Items(objFormula.FormulaID); } else { MessageBox.Show(this, "Quantity should be a Numaric value", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (FormatException fex) { MessageBox.Show(this, "Quantity should be a Numaric value", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { objFormulaBasicProduct = null; } }
public int Update(FormulaBasicProduct obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@FormulaPart", obj.Formula.FormulaID), new SqlParameter("@FormulaProductQty", obj.BasicProduct.BasicProductCode), new SqlParameter("@Original_FormulaID", obj.FormulaPart), new SqlParameter("@Original_FormulaBasicProductCode", obj.FormulaProductQty) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_FormulaBasicProduct", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(FormulaBasicProduct obj, Employee objEmployee) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@FormulaID", obj.Formula.FormulaID), new SqlParameter("@FormulaBasicProductCode", obj.BasicProduct.BasicProductCode), new SqlParameter("@FormulaPart", obj.FormulaPart), new SqlParameter("@FormulaProductQty", obj.FormulaProductQty), new SqlParameter("@FormulaInstructedBy", objEmployee.EmployeeID) }; return(Execute.RunSP_RowsEffected(Connection, "SPADD_FormulaBasicProduct", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void cmbBasicPart_SelectedIndexChanged(object sender, EventArgs e) { FormulaBasicProduct objFormulaBasicProduct = new FormulaBasicProduct(); try { if (cmbBasicPart.SelectedIndex != -1) { txtBasicProductQty.Text = "0.00"; lblBasicProductUnit.Text = ""; SelectBasic = false; if (cmbBasicProducts.Items.Count > 0 && cmbBasicProducts.SelectedItem != null) { BasicProduct objBasic = objBasicProductDL.Get(cmbBasicProducts.SelectedValue.ToString()); lblBasicProductUnit.Text = objBasic.BasicProductUnit.UnitCode; if (objFormula.FormulaID != 0) { objFormulaBasicProduct = objFormulaBasicProductDL.Get(objFormula.FormulaID, objBasic.BasicProductCode, cmbBasicPart.SelectedItem.ToString()); if (objFormulaBasicProduct.Formula != null) { txtBasicProductQty.Text = objFormulaBasicProduct.FormulaProductQty.ToString(); //cmbBasicPart.SelectedItem = objFormulaBasicProduct.FormulaPart.Trim(); SelectBasic = true; } } } } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { objFormulaBasicProduct = null; } }