public static Models.Inventory GetInventory(int id, int?qty) { var result = new Models.Inventory(); using (var ctx = new Data.AMEntDataContext()) { result = ctx.Inventories .Where(x => x.ID == id) .Select(x => new Models.Inventory { Id = x.ID, ItemCode = x.ItemCode, Description = x.Remarks.Trim().Length > 0 ? x.Remarks : x.Description, ShortDescription = x.ShortDescription, UOfM = x.UnitOfMeasure.UOMCode, Quantity = qty, ListPrice = x.InventoryPrices != null ? x.InventoryPrices.FirstOrDefault() != null ? x.InventoryPrices.FirstOrDefault().InventoryListPrices != null && x.InventoryPrices.FirstOrDefault().InventoryListPrices.Count() > 0 ? x.InventoryPrices.FirstOrDefault().InventoryListPrices.Max(a => a.ListPrice) : 0 : 0 : 0, ImagePath = Resource.StaticResource.ImagePath }).SingleOrDefault(); } return(result); }
public ActionResult Index(Models.Customer customer) { if (ModelState.IsValid) { //TODO login authentication and process bool isAuth = false; using (var ctx = new Data.AMEntDataContext()) { isAuth = ctx.Customers.Where(x => x.CustomerCode.ToLower() == customer.CustomerCode.ToLower()).Any(); if (isAuth) { return(RedirectToAction("Index", "Home")); } else { return(RedirectToAction("Index", "Login")); } } } return(View(customer)); }
private static List <Models.ShoppingCart> GetShoppingCart() { int ctr = 0; var shoppingCart = new List <Models.ShoppingCart>(); using (var ctx = new Data.AMEntDataContext()) { foreach (var x in ctx.Inventories) { if (ctr < 3) { var qty = 1; //new Random().Next(1, 5); var lstPrice = x.InventoryPrices != null? x.InventoryPrices.FirstOrDefault() != null? x.InventoryPrices.FirstOrDefault().InventoryListPrices != null && x.InventoryPrices.FirstOrDefault().InventoryListPrices.Count() > 0 ? x.InventoryPrices.FirstOrDefault().InventoryListPrices.Max(a => a.ListPrice) : 0 : 0 : 0; var totalPrice = qty * lstPrice; shoppingCart.Add(new Models.ShoppingCart() { CartId = x.ID, ProductCode = x.ItemCode, ProductName = x.Description, Size = Resource.StaticResource.Size[new Random().Next(0, 2)], Color = Resource.StaticResource.Color[new Random().Next(0, 4)], Quantity = qty, CurrencyName = "USD", ListPrice = lstPrice, TotalPrice = totalPrice, ImagePath = Resource.StaticResource.ImagePath }); } else { break; } ctr++; } } return(shoppingCart); }
public static void AddItemToShoppingCart(Models.Inventory model, bool isBuy = false) { using (var ctx = new Data.AMEntDataContext()) { var prod = ctx.Inventories.Where(x => x.ID == model.Id).SingleOrDefault(); if (isBuy) { Cart = null; Cart = new List <Models.ShoppingCart>(); } //var qty = new Random().Next(1, 5); int?qty = model.Quantity; var lstPrice = prod.InventoryPrices != null? prod.InventoryPrices.FirstOrDefault() != null? prod.InventoryPrices.FirstOrDefault().InventoryListPrices != null && prod.InventoryPrices.FirstOrDefault().InventoryListPrices.Count() > 0 ? prod.InventoryPrices.FirstOrDefault().InventoryListPrices.Max(a => a.ListPrice) : 0 : 0 : 0; var totalPrice = (qty ?? 0) * lstPrice; Cart.Add(new Models.ShoppingCart() { CartId = prod.ID, ProductCode = prod.ItemCode, ProductName = prod.Description, Size = Resource.StaticResource.Size[new Random().Next(0, 2)], Color = Resource.StaticResource.Color[new Random().Next(0, 4)], Quantity = qty ?? 0, CurrencyName = "USD", ListPrice = lstPrice, TotalPrice = totalPrice, ImagePath = Resource.StaticResource.ImagePath }); } }
public static List <Models.Inventory> GetAllActiveInventories(string search, Models.Page.Pager pagedModel) { var result = new List <Models.Inventory>(); using (var ctx = new Data.AMEntDataContext()) { var data = ctx.Inventories .Where(x => x.Status == 1 && x.InventoryWarehouses.Sum(y => y.OnhandQty) > 0); _AllActiveInventoriesCount = data.Count(); if (string.IsNullOrWhiteSpace(search)) { result = data .Select(x => new Models.Inventory { Id = x.ID, ItemCode = x.ItemCode, Description = x.Description, ListPrice = x.InventoryPrices != null ? x.InventoryPrices.FirstOrDefault() != null ? x.InventoryPrices.FirstOrDefault().InventoryListPrices != null && x.InventoryPrices.FirstOrDefault().InventoryListPrices.Count() > 0 ? x.InventoryPrices.FirstOrDefault().InventoryListPrices.Max(a => a.ListPrice) : 0 : 0 : 0, ImagePath = Resource.StaticResource.ImagePath }) .Skip(pagedModel.Start) .Take(pagedModel.ItemsPerPage) .ToList(); } else { var newData = data .Where(x => x.ItemCode.ToLower().Contains(search.ToLower())); _AllActiveInventoriesCount = newData.Count(); result = newData .Select(x => new Models.Inventory { Id = x.ID, ItemCode = x.ItemCode, Description = x.Description, ListPrice = x.InventoryPrices != null ? x.InventoryPrices.FirstOrDefault() != null ? x.InventoryPrices.FirstOrDefault().InventoryListPrices != null && x.InventoryPrices.FirstOrDefault().InventoryListPrices.Count() > 0 ? x.InventoryPrices.FirstOrDefault().InventoryListPrices.Max(a => a.ListPrice) : 0 : 0 : 0, ImagePath = Resource.StaticResource.ImagePath }) .Skip(pagedModel.Start) .Take(pagedModel.ItemsPerPage) .ToList(); } } return(result); }