public RawMaterialPurchase SearchRawMaterialPurchase(int id)
{
return(RawMaterialPurchase
.Include(e => e.RawMaterial)
.Where(e => e.RawMaterialPurchaseId == id)
.FirstOrDefault());
}
public IActionResult OnPostUpdateQty()
{
int id = Int32.Parse(Request.Form["id"]);
double remaining;
try
{
remaining = double.Parse(Request.Form["RemainingInventory"]);
}
catch (Exception e)
{
ErrorMessage = "Amount remaining invalid. Please try again.";
return(OnGet(id));
}
RawMaterialPurchase purchase = _db.SearchRawMaterialPurchase(id);
purchase.CurrentInventory = remaining;
if (_db.AddPurchase(purchase))
{
SuccessMessage = "Inventory updated succesfully.";
}
else
{
ErrorMessage = "Purchase updated unsuccesfully. Please try again or contact sysadmin.";
}
return(OnGet(Material.RawMaterialItemId));
}
public IEnumerable <RawMaterialPurchase> GetRawMaterialPurchases(int PageNumber, int ResultsPerPage = Int32.MaxValue, string search = null)
{
return(RawMaterialPurchase
.Where(e => search == null || e.RawMaterial.MaterialName == search)
.Include(e => e.RawMaterial)
.OrderBy(e => e.RawMaterial.MaterialName)
.ThenByDescending(e => e.DateRecieved)
.Skip(ResultsPerPage * (PageNumber - 1))
.Take(ResultsPerPage));
}
public bool AddPurchase(RawMaterialPurchase rawMaterialPurchase)
{
try
{
RawMaterialPurchase.Update(rawMaterialPurchase);
SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public IActionResult OnGet(int?Id = null)
{
if (Id.HasValue)
{
Editing = true;
Purchase = _db.SearchRawMaterialPurchase(Id.Value);
if (Purchase == default)
{
Editing = false;
ErrorMessage = "Purchase not found. Please return to the previous page and try again.";
Purchase = new RawMaterialPurchase();
}
}
else
{
Editing = false;
Purchase = new RawMaterialPurchase();
}
return(Page());
}
public int CountRawMaterialPurchases(string search = null)
{
return(RawMaterialPurchase
.Where(e => search == null || e.RawMaterial.MaterialName == search)
.Count());
}
