public CartDTO UpdateCart(CartItemDTO cart) { using (var dbContext = new OMHRDModel()) { var cartItem = dbContext.Cart_T.FirstOrDefault(x => x.ProductId == cart.ProductId && x.UserId == cart.UserId && x.SizeId == cart.SizeId && (!x.ColorId.HasValue || x.ColorId.Value == cart.ColorId.Value)); if (cartItem != null) { cartItem.Quantity = cart.IsQuantityForAddition ? cartItem.Quantity + cart.Quantity : cart.Quantity; dbContext.SaveChanges(); } else { cartItem = new Cart_T() { ProductId = cart.ProductId, ColorId = cart.ColorId, SizeId = cart.SizeId, Quantity = cart.Quantity, UserId = cart.UserId }; dbContext.Cart_T.Add(cartItem); dbContext.SaveChanges(); } return(GetCartTotal(cart.UserId)); } }
public List <CartItemDTO> GetCartItems(int userId) { using (var dbContext = new OMHRDModel()) { var cartItems = (from cart in dbContext.Cart_T join price in dbContext.ProductPrice_T on new { ProductId = cart.ProductId, SizeId = cart.SizeId, ColorId = cart.ColorId } equals new { price.ProductId, SizeId = price.ProductSizeId, ColorId = price.ProductColorId } join prodcut in dbContext.Product_T on cart.ProductId equals prodcut.Id where cart.UserId == userId select new CartItemDTO { Id = cart.Id, ColorId = cart.ColorId, ColorName = cart.ColorId.HasValue ? cart.ProductColor_T.Name : "", ColorCode = cart.ColorId.HasValue ? cart.ProductColor_T.Code : "", Price = price.Price - price.Discount, Discount = price.Discount, ProductId = prodcut.Id, ProductName = prodcut.Name, Quantity = cart.Quantity, SizeId = cart.SizeId, SizeName = cart.ProductSize_T.Name, SizeCode = cart.ProductSize_T.Code, UserId = userId }).ToList(); return(cartItems); } }
public UserProfile_T Login(string username, string password) { using (var dbContext = new OMHRDModel()) { return(dbContext.UserProfile_T.FirstOrDefault(x => x.Username.ToLower() == username.ToLower() && x.Password == password)); } }
public ProductDTO GetProductById(int productId) { using (dbContext = new OMHRDModel()) { using (dbContext = new OMHRDModel()) { var product = dbContext.Product_T.Where(x => (x.Id == productId)) .Select(x => new ProductDTO { Id = x.Id, Code = x.Code, Name = x.Name, HSN = x.HSN, ShortDescription = x.Description, Description = x.Description, PriceList = x.ProductPrice_T.Select(y => new ProductPriceDTO { Id = y.Id, Price = y.Price, Discount = y.Discount, Quantity = y.Quantity, SizeId = y.ProductSizeId, SizeCode = y.ProductSize_T.Code, SizeName = y.ProductSize_T.Name, ColorId = y.ProductColorId, ColorCode = y.ProductColorId != null ? y.ProductColor_T.Code : string.Empty, ColorName = y.ProductColorId != null ? y.ProductColor_T.Name : string.Empty }).ToList() }).FirstOrDefault(); return(product); } } }
public List <ProductDTO> GetProducts(ProductSearchDTO searchDto) { using (dbContext = new OMHRDModel()) { var products = dbContext.Product_T.Where(x => (searchDto.SubCategoryId == 0 || x.SubCategoryId == searchDto.SubCategoryId) && (searchDto.CategoryId == 0 || x.ProductSubCategory_T.CategoryId == searchDto.CategoryId)) .Select(x => new ProductDTO { Id = x.Id, Code = x.Code, Name = x.Name, HSN = x.HSN, ShortDescription = x.Description, Description = x.Description, PriceList = x.ProductPrice_T.Select(y => new ProductPriceDTO { Price = y.Price, Discount = y.Discount, Quantity = y.Quantity, SizeId = y.ProductSizeId, SizeCode = y.ProductSize_T.Code, ColorId = y.ProductColorId, ColorCode = y.ProductColorId == null ? y.ProductColor_T.Code : string.Empty }).ToList() }).ToList(); return(products); } }
public int InsertCart(Cart_T cart) { using (var dbContext = new OMHRDModel()) { dbContext.Cart_T.Add(cart); return(dbContext.SaveChanges()); } }
public int Register(UserProfile_T user) { using (var dbContext = new OMHRDModel()) { dbContext.UserProfile_T.Add(user); return(dbContext.SaveChanges()); } }
public CartDTO GetCartTotal(int userId) { using (var dbContext = new OMHRDModel()) { var cartItems = (from cartDB in dbContext.Cart_T join price in dbContext.ProductPrice_T on new { ProductId = cartDB.ProductId, SizeId = cartDB.SizeId, ColorId = cartDB.ColorId } equals new { price.ProductId, SizeId = price.ProductSizeId, ColorId = price.ProductColorId } join prodcut in dbContext.Product_T on cartDB.ProductId equals prodcut.Id where cartDB.UserId == cartDB.UserId select new { Price = (price.Price - price.Discount) * cartDB.Quantity, Quantity = cartDB.Quantity }); return(new CartDTO { TotalPrice = cartItems.Sum(x => x.Price), Quantity = cartItems.Sum(x => x.Quantity) }); } }