public static double getTotalItem()
{
var dc = new SQLLINQ.Models.InventoryManagementContext();
var stock = dc.Inventory.Where(x => x.IsDeleted == false).Sum(x => x.StockIn);
return(stock);
}
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());
}
