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