public static bool CreateAdjustmentVoucher(int sessionID, string itemNo, int qty, string reason)
{
bool result = false;
try
{
LussisEntities context = new LussisEntities();
Employee employee = AndroidAuthenticationController.GetDetailsOfEmployee(sessionID);
StationeryCatalogue itemToChange = context.StationeryCatalogues.Where(item => item.ItemNo.Equals(itemNo)).FirstOrDefault();
// Create new Adjustment Voucher
AdjustmentVoucher newVoucher = new AdjustmentVoucher()
{
DateIssued = DateTime.Today,
IssueEmpNo = employee.EmpNo,
Status = "Pending"
};
context.AdjustmentVouchers.Add(newVoucher);
context.SaveChanges();
result = true;
if (result == true)
{
try
{
// Add Voucher Detail
AdjustmentVoucherDetail newAdjustment = new AdjustmentVoucherDetail()
{
AvNo = newVoucher.AvNo,
ItemNo = itemNo,
Qty = qty - itemToChange.CurrentQty,
Reason = reason
};
context.AdjustmentVoucherDetails.Add(newAdjustment);
context.SaveChanges();
result = true;
}
catch (Exception)
{
result = false;
}
}
}
catch (Exception)
{
result = false;
}
return(result);
}
public static int GetQuantityInStock(String ItemNo)
{
LussisEntities context = new LussisEntities();
int result = 0;
StationeryCatalogue item = context.StationeryCatalogues
.Where(stationeryItem => stationeryItem.ItemNo.Equals(ItemNo))
.FirstOrDefault();
if (item != null)
{
result = item.CurrentQty.Value;
}
return(result);
}
public static bool IsThereEnoughItemsInStock(int qty, String ItemNo)
{
LussisEntities context = new LussisEntities();
bool result = false;
StationeryCatalogue item = context.StationeryCatalogues
.Where(stationeryItem => stationeryItem.ItemNo.Equals(ItemNo))
.FirstOrDefault();
if (item != null)
{
result = item.CurrentQty >= qty;
}
return(result);
}