public KnockoutBootStrap.Core.ViewModels.InventoryViewModel SaveInventoryViewModel(KnockoutBootStrap.Core.ViewModels.InventoryViewModel newInventory) { KnockoutBootStrap.Core.Inventory obj = new Inventory(); KnockoutBootStrap.Core.ViewModels.InventoryViewModel objnew = new ViewModels.InventoryViewModel(); using (KnockoutBootStrap.Core.KnockoutBootStrapcoreDataContext dbContext = new KnockoutBootStrapcoreDataContext(Common.ConnString)) { if (newInventory.UpdateCase == "UpdateCase") { KnockoutBootStrap.Core.Inventory existingContract = dbContext.Inventories.SingleOrDefault(m => m.Id == newInventory.Id); existingContract.ItemName = newInventory.ItemName; existingContract.ReorderPoint = newInventory.ReorderPoint; dbContext.SubmitChanges(); } else { obj.ItemName = newInventory.ItemName; obj.ReorderPoint = newInventory.ReorderPoint; obj.CreatedDate = DateTime.UtcNow; dbContext.Inventories.InsertOnSubmit(obj); dbContext.SubmitChanges(); } } return objnew; }
public void DeleteInventory(int id) { using (KnockoutBootStrap.Core.KnockoutBootStrapcoreDataContext dbContext = new KnockoutBootStrapcoreDataContext(Common.ConnString)) { KnockoutBootStrap.Core.Inventory obj = new Inventory(); obj = dbContext.Inventories.Where(m => m.Id == id).FirstOrDefault(); dbContext.Inventories.DeleteOnSubmit(obj); dbContext.SubmitChanges(); } }
public KnockoutBootStrap.Core.ViewModels.InventoryViewModel GetInventoryViewModel(int id) { KnockoutBootStrap.Core.Inventory obj = new Inventory(); KnockoutBootStrap.Core.ViewModels.InventoryViewModel objnew = new ViewModels.InventoryViewModel(); using (KnockoutBootStrap.Core.KnockoutBootStrapcoreDataContext dbContext = new KnockoutBootStrapcoreDataContext(Common.ConnString)) { obj = dbContext.Inventories.Where(x => x.Id == id).SingleOrDefault(); } objnew.CreatedDate = obj.CreatedDate; objnew.Id = obj.Id; objnew.ItemName = obj.ItemName; objnew.ReorderPoint = obj.ReorderPoint; return objnew; }
public IEnumerable<KnockoutBootStrap.Core.ViewModels.InventoryViewModel> GetContractList() { IList<KnockoutBootStrap.Core.ViewModels.InventoryViewModel> returList = new List<KnockoutBootStrap.Core.ViewModels.InventoryViewModel>(); using (KnockoutBootStrap.Core.KnockoutBootStrapcoreDataContext dbContext = new KnockoutBootStrapcoreDataContext(Common.ConnString)) { returList = dbContext.Inventories.Select(x => new KnockoutBootStrap.Core.ViewModels.InventoryViewModel() { CreatedDate = x.CreatedDate, ReorderPoint = x.ReorderPoint, ItemName = x.ItemName, Id = x.Id, text = x.ItemName, }).ToList(); } return returList.OrderByDescending(s => s.CreatedDate); }