private void buttonSave_Click(object sender, EventArgs e)
{
bool hasError = false;
foreach (DataGridViewRow row in dataGridViewItems.Rows)
{
var item = new ItemBO();
item.ItemID = int.Parse(row.Cells[0].Value.ToString());
item.QtyInHand = decimal.Parse(row.Cells[4].Value.ToString());
var result =new ItemDAL().UpdateQuantityInHand(item);
if (!result)
{
MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_021"), false);
hasError = true;
return;
}
}
if (!hasError)
{
MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_022"), false);
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
try
{
if (ItemID > 0 && !ScreenFunctions.Update)
{
MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_020"), false);
return;
}
DialogResult dialogResult = MessageBoxClass.ShowDialog(CommonMethods.GetError("INV_018"));
if (dialogResult == DialogResult.Yes)
{
if (CommonMethods.IsEmpty(textBoxItemDescription.Text))
{
MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_001"), false);
return;
}
if (CommonMethods.IsEmpty(textBoxItemNo.Text))
{
MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_002"), false);
return;
}
if (CommonMethods.IsEmpty(textBoxMeasuringUnit.Text))
{
MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_003"), false);
return;
}
var item = new ItemBO();
if (ItemID > 0)
item.ItemID = ItemID;
else
item.ItemID = -1;
item.ItemSerial = textBoxItemNo.Text.Trim();
item.MeasuringUnit = MeasuringUnit;
item.QtyInHand = numericUpDownQtyInHand.Value;
item.UnitPrice = numericUpDownUnitPrice.Value;
item.BreakEven = numericUpDownBreakEvenPoint.Value;
item.CreatedUser = 0;
item.Description = textBoxItemDescription.Text.Trim();
var objItemDAL = new ItemDAL();
bool result = objItemDAL.AddItem(item);
if (result)
{
MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_004"), false);
button1_Click(null, null);
}
else
{
MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_005"), false);
}
}
}
catch
{
MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true);
}
}
public bool UpdateQuantityInHand(ItemBO item)
{
DBEgine objDbAccess = new DBEgine();
bool result = false;
try
{
SqlParameter[] parms = new SqlParameter[2];
SqlParameter parmItemID = new SqlParameter();
parmItemID.Value = item.ItemID;
parmItemID.SqlDbType = SqlDbType.Int;
parmItemID.Direction = ParameterDirection.Input;
parmItemID.ParameterName = "@ItemID";
parms[0] = parmItemID;
SqlParameter parmBreakEven = new SqlParameter();
parmBreakEven.Value = item.QtyInHand;
parmBreakEven.SqlDbType = SqlDbType.Decimal;
parmBreakEven.Direction = ParameterDirection.Input;
parmBreakEven.ParameterName = "@QtyInHand";
parms[1] = parmBreakEven;
objDbAccess.DBOpen();
if (objDbAccess.ExecNonQueryStoredProc("Inventory.UpdateQtyInhandByItemId", parms) > 0)
{
result = true;
}
return result;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
public ItemBO GetItemByItemNo(string itemNo)
{
DBEgine objDbAccess = new DBEgine();
var item = new ItemBO();
try
{
SqlParameter[] parms = new SqlParameter[1];
SqlParameter parmItemID = new SqlParameter();
parmItemID.Value = itemNo;
parmItemID.SqlDbType = SqlDbType.VarChar;
parmItemID.Direction = ParameterDirection.Input;
parmItemID.ParameterName = "@ItemSerial";
parms[0] = parmItemID;
objDbAccess.DBOpen();
SqlDataReader dr = objDbAccess.ExecuteReader("Inventory.GetItemByItemNo", parms);
while (dr.Read())
{
item.ItemID = int.Parse(dr["ItemID"].ToString());
item.ItemSerial = dr["ItemSerial"].ToString();
item.Description = dr["ItemDescription"].ToString();
item.UnitPrice = Convert.ToDecimal(dr["UnitPrice"].ToString());
item.MeasuringUnit = Convert.ToInt16(dr["MeasureUnit"].ToString());
item.QtyInHand = Convert.ToDecimal(dr["QtyInHand"].ToString());
item.BreakEven = Convert.ToDecimal(dr["BreakEven"].ToString());
}
return item;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
public bool AddItem(ItemBO item)
{
DBEgine objDbAccess = new DBEgine();
bool result = false;
try
{
SqlParameter[] parms = new SqlParameter[8];
SqlParameter parmItemID = new SqlParameter();
parmItemID.Value = item.ItemID;
parmItemID.SqlDbType = SqlDbType.Int;
parmItemID.Direction = ParameterDirection.Input;
parmItemID.ParameterName = "@ItemID";
parms[0] = parmItemID;
SqlParameter parmItemSerial = new SqlParameter();
parmItemSerial.Value = item.ItemSerial;
parmItemSerial.SqlDbType = SqlDbType.NVarChar;
parmItemSerial.Direction = ParameterDirection.Input;
parmItemSerial.ParameterName = "@ItemSerial";
parms[1] = parmItemSerial;
SqlParameter parmDescription = new SqlParameter();
parmDescription.Value = item.Description;
parmDescription.SqlDbType = SqlDbType.NVarChar;
parmDescription.Direction = ParameterDirection.Input;
parmDescription.ParameterName = "@Description";
parms[2] = parmDescription;
SqlParameter parmMeasuringUnit = new SqlParameter();
parmMeasuringUnit.Value = item.MeasuringUnit;
parmMeasuringUnit.SqlDbType = SqlDbType.Int;
parmMeasuringUnit.Direction = ParameterDirection.Input;
parmMeasuringUnit.ParameterName = "@MeasuringUnit";
parms[3] = parmMeasuringUnit;
SqlParameter parmCreatedUser = new SqlParameter();
parmCreatedUser.Value = item.CreatedUser;
parmCreatedUser.SqlDbType = SqlDbType.Int;
parmCreatedUser.Direction = ParameterDirection.Input;
parmCreatedUser.ParameterName = "@CreatedUser";
parms[4] = parmCreatedUser;
SqlParameter parmQtyInHand = new SqlParameter();
parmQtyInHand.Value = item.QtyInHand;
parmQtyInHand.SqlDbType = SqlDbType.Decimal;
parmQtyInHand.Direction = ParameterDirection.Input;
parmQtyInHand.ParameterName = "@QtyInHand";
parms[5] = parmQtyInHand;
SqlParameter parmUnitPrice = new SqlParameter();
parmUnitPrice.Value = item.UnitPrice;
parmUnitPrice.SqlDbType = SqlDbType.Decimal;
parmUnitPrice.Direction = ParameterDirection.Input;
parmUnitPrice.ParameterName = "@UnitPrice";
parms[6] = parmUnitPrice;
SqlParameter parmBreakEven = new SqlParameter();
parmBreakEven.Value = item.BreakEven;
parmBreakEven.SqlDbType = SqlDbType.Decimal;
parmBreakEven.Direction = ParameterDirection.Input;
parmBreakEven.ParameterName = "@BreakEven";
parms[7] = parmBreakEven;
objDbAccess.DBOpen();
if (objDbAccess.ExecNonQueryStoredProc("Inventory.AddItems", parms) > 0)
{
result = true;
}
return result;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
public List<ItemBO> CheckInventory()
{
DBEgine objDbAccess = new DBEgine();
var list= new List<ItemBO>();
try
{
objDbAccess.DBOpen();
SqlDataReader dr = objDbAccess.ExecuteReader("Inventory.CheckInventory", null);
while (dr.Read())
{
var item = new ItemBO();
item.ItemID = int.Parse(dr["ItemID"].ToString());
item.ItemSerial = dr["ItemSerial"].ToString();
item.Description = dr["ItemDescription"].ToString();
item.UnitPrice = Convert.ToDecimal(dr["UnitPrice"].ToString());
item.MeasuringUnit = Convert.ToInt16(dr["MeasureUnit"].ToString());
item.QtyInHand = Convert.ToDecimal(dr["QtyInHand"].ToString());
item.BreakEven = Convert.ToDecimal(dr["BreakEven"].ToString());
list.Add(item);
}
return list;
}
catch
{
throw;
}
finally
{
objDbAccess.DBClose();
}
}