private void btnAdd_Click(object sender, EventArgs e)
{
try
{
POMaterials objPOMaterials = new POMaterials();
bool duplicatefound = false;
int x = -1;
objPOMaterials.MaterialCode = cmbMaterials.SelectedValue.ToString();
objPOMaterials.PONO = txtPONO.Text;
objPOMaterials.POQty = Convert.ToDecimal(txtReqQty.Text);
objPOMaterials.UnitPrice = Convert.ToDecimal(txtUnitPrice.Text);
objPOMaterials.Material = objMaterial_DL.Get(cmbMaterials.SelectedValue.ToString()).MaterialCode + " - " + objMaterial_DL.Get(cmbMaterials.SelectedValue.ToString()).MaterialDescription;
foreach (POMaterials obj in objPOMaterialsCollec)
{
x = x + 1;
if (obj.MaterialCode == objPOMaterials.MaterialCode)
{
duplicatefound = true;
break;
}
}
if (duplicatefound == true)
{
DialogResult theResult = MessageBox.Show(this, "Confirmation", "Do you want to add this product with the new qty", MessageBoxButtons.YesNo);
if (theResult == System.Windows.Forms.DialogResult.Yes)
{
objPOMaterialsCollec.RemoveAt(x);
objPOMaterialsCollec.Add(objPOMaterials);
}
}
else
{
objPOMaterialsCollec.Add(objPOMaterials);
}
gvMaterialList.AutoGenerateColumns = false;
objSourceMaterialList.DataSource = objPOMaterialsCollec;
gvMaterialList.DataSource = objSourceMaterialList;
objSourceMaterialList.ResetBindings(true);
txtReqQty.Text = "";
txtUnitPrice.Text = "";
}
catch (Exception ex)
{
}
}
public long Add(POMaterials obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@PONO", obj.PONO),
new SqlParameter("@MaterialCode", obj.MaterialCode),
new SqlParameter("@POQty", obj.POQty),
new SqlParameter("@UnitPrice", obj.UnitPrice)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_POMaterials", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
