public List<SubItemDetailBO> GetSubItemDetailBySubItemID(int id)
{
DBEgine objDbAccess = new DBEgine();
var list = new List<SubItemDetailBO>();
try
{
SqlParameter[] parms = new SqlParameter[1];
SqlParameter parmItemID = new SqlParameter();
parmItemID.Value = id;
parmItemID.SqlDbType = SqlDbType.Int;
parmItemID.Direction = ParameterDirection.Input;
parmItemID.ParameterName = "@SubItemID";
parms[0] = parmItemID;
objDbAccess.DBOpen();
SqlDataReader dr = objDbAccess.ExecuteReader("Inventory.GetSubItemDetailBySubItemID", parms);
while (dr.Read())
{
var subItemDetail = new SubItemDetailBO();
subItemDetail.SubItemID = int.Parse(dr["SubItemID"].ToString());
subItemDetail.Serial = dr["ItemSerial"].ToString();
subItemDetail.UnitOfMeasureID = int.Parse(dr["UnitOfMeasureID"].ToString());
subItemDetail.SubItemDetailID = int.Parse(dr["SubItemDetailID"].ToString());
subItemDetail.ItemID = int.Parse(dr["ItemID"].ToString());
subItemDetail.QtyForUnit = decimal.Parse(dr["QtyForUnit"].ToString());
subItemDetail.Description = dr["ItemDescription"].ToString();
subItemDetail.UnitOfMeasureName = dr["UnitDescription"].ToString();
list.Add(subItemDetail);
}
return list;
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDbAccess.DBClose();
}
}
public bool SaveSubItemWithTransaction(SubItemDetailBO subItemDetail, DBEgine objDbAccess)
{
bool result = false;
try
{
SqlParameter[] parms = new SqlParameter[4];
SqlParameter parmSubItemID = new SqlParameter();
parmSubItemID.Value = subItemDetail.SubItemID;
parmSubItemID.SqlDbType = SqlDbType.Int;
parmSubItemID.Direction = ParameterDirection.Input;
parmSubItemID.ParameterName = "@SubItemID";
parms[0] = parmSubItemID;
SqlParameter parmItemID = new SqlParameter();
parmItemID.Value = subItemDetail.ItemID;
parmItemID.SqlDbType = SqlDbType.Int;
parmItemID.Direction = ParameterDirection.Input;
parmItemID.ParameterName = "@ItemID";
parms[1] = parmItemID;
SqlParameter parmQtyForUnit = new SqlParameter();
parmQtyForUnit.Value = subItemDetail.QtyForUnit;
parmQtyForUnit.SqlDbType = SqlDbType.Decimal;
parmQtyForUnit.Direction = ParameterDirection.Input;
parmQtyForUnit.ParameterName = "@QtyForUnit";
parms[2] = parmQtyForUnit;
SqlParameter parmMeasuringUnit = new SqlParameter();
parmMeasuringUnit.Value = subItemDetail.UnitOfMeasureID;
parmMeasuringUnit.SqlDbType = SqlDbType.Int;
parmMeasuringUnit.Direction = ParameterDirection.Input;
parmMeasuringUnit.ParameterName = "@UnitOfMeasureID";
parms[3] = parmMeasuringUnit;
if (objDbAccess.ExecNonQueryStoredProc("Inventory.SaveSubItemDetail", parms) > 0)
{
result = true;
}
return result;
}
catch (Exception ex)
{
throw ex;
}
}
private void buttonAddSubItem_Click(object sender, EventArgs e)
{
try
{
var subItemDetailBO = new SubItemDetailBO();
subItemDetailBO.ItemID = ItemID;
subItemDetailBO.SubItemID = SubItemID;
subItemDetailBO.SubItemDetailID = -1;
subItemDetailBO.UnitOfMeasureID = ItemMeasuringUnit;
subItemDetailBO.UnitOfMeasureName = textBoxItemMesuringUnit.Text;
subItemDetailBO.QtyForUnit = numericUpDownQtyAllocated.Value;
subItemDetailBO.Description = textBoxItemDescription.Text;
subItemDetailBO.Serial = textBoxItemNo.Text;
var list=new List<SubItemDetailBO>();
if(SubItemDetailBOList!=null)
list = SubItemDetailBOList.FindAll(s => s.ItemID == ItemID);
if (list.Count() > 0)
{
MessageBoxClass.ShowMessage(CommonMethods.GetError("INV_009"), false);
}
else
{
SubItemDetailBOList.Add(subItemDetailBO);
BindDataToGridView();
ClearItem();
}
}
catch
{
MessageBoxClass.ShowMessage(CommonMethods.GetError("U_007"), true);
}
}
