public InventoryModel Save(InventoryModel package) { var dc = new SQLLINQ.Models.InventoryManagementContext(); var dbPackage = new SQLLINQ.Models.Inventory(); if (package.PackageId == -1) { dbPackage.Image = package.Image; dbPackage.PackageName = package.PackageName; dbPackage.Category = package.Category; dbPackage.Description = package.Description; dbPackage.StockIn = package.StockIn; dbPackage.StockOut = package.StockOut; dbPackage.Date = package.Date; dc.Inventory.Add(dbPackage); } else { dbPackage = dc.Inventory.Where(x => x.PackageId == package.PackageId).SingleOrDefault(); if (dbPackage != null) { dbPackage.Image = package.Image; dbPackage.PackageName = package.PackageName; dbPackage.Category = package.Category; dbPackage.Description = package.Description; dbPackage.StockIn = package.StockIn; dbPackage.StockOut = package.StockOut; dbPackage.Date = package.Date; } } dc.SaveChanges(); return(package); }
public InventoryModel StockIn(InventoryModel stock) { var dc = new SQLLINQ.Models.InventoryManagementContext(); var dbItem = new SQLLINQ.Models.Inventory(); var payload = stock; dbItem = dc.Inventory.Where(x => x.PackageId == payload.PackageId).SingleOrDefault(); if (dbItem != null) { dbItem.StockIn = dbItem.StockIn + payload.StockIn; } dc.SaveChanges(); return(payload); }
public static bool setRestore(string id) { try { var dc = new SQLLINQ.Models.InventoryManagementContext(); var dbItem = new SQLLINQ.Models.Inventory(); dbItem = dc.Inventory.Where(x => x.PackageId == Convert.ToInt64(id)).SingleOrDefault(); if (dbItem != null) { dbItem.IsDeleted = false; } dc.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public static new List <SQLLINQ.Models.Inventory> ListDeleted() { var dc = new SQLLINQ.Models.InventoryManagementContext(); var dbInventory = dc.Inventory.Where(x => x.IsDeleted == true).ToList(); var inventoryList = new List <SQLLINQ.Models.Inventory>(); foreach (var inv in dbInventory) { var model = new SQLLINQ.Models.Inventory(); model.PackageId = inv.PackageId; model.PackageName = inv.PackageName; model.Image = inv.Image; model.Category = inv.Category; model.Description = inv.Description; model.StockIn = inv.StockIn; model.StockOut = inv.StockOut; model.Date = inv.Date; inventoryList.Add(model); } return(inventoryList.OrderBy(x => x.PackageName).ToList()); }