public static int DeleteProductFromCart(int productId, int userId) { CartDataModel model = GetOpenCart(userId); if (model != null) //Adding products to open cart { CartProductsDataModel data = new CartProductsDataModel { ProductId = productId, CartId = model.Id }; string sql = @"delete FROM [dbo].[CartProducts] where CartId=@CartId and ProductId=@ProductId"; return(SQLDataAccess.SaveData(sql, data)); } else { return(0); } }
public static int AddProductToCart(int userId, int productId, int productQty, float productPrice) { CartDataModel model = GetOpenCart(userId); if (model != null) //Adding products to open cart { CartProductsDataModel data = new CartProductsDataModel { CartId = model.Id, ProductId = productId, ProductQty = productQty, ProductPrice = productPrice, AddedDate = DateTime.Now }; string sql = @"INSERT INTO [dbo].[CartProducts] ([CartId] ,[ProductId] ,[ProductQty] ,[ProductPrice] ,[AddedDate]) VALUES (@CartId ,@ProductId ,@ProductQty ,@ProductPrice ,@AddedDate)"; return(SQLDataAccess.SaveData(sql, data)); } else //Saving New Cart { CartDataModel cartData = new CartDataModel { UserId = userId, IsOpen = true, DateCreated = DateTime.Now }; string sql = @"INSERT INTO [dbo].[Cart] ([UserId] ,[IsOpen] ,[DateCreated]) VALUES (@UserId ,@IsOpen ,@DateCreated)"; SQLDataAccess.SaveData(sql, cartData); CartDataModel newCart = GetOpenCart(userId); CartProductsDataModel data = new CartProductsDataModel { CartId = newCart.Id, ProductId = productId, ProductQty = productQty, ProductPrice = productPrice, AddedDate = DateTime.Now }; sql = @"INSERT INTO [dbo].[CartProducts] ([CartId] ,[ProductId] ,[ProductQty] ,[ProductPrice] ,[AddedDate]) VALUES (@CartId ,@ProductId ,@ProductQty ,@ProductPrice ,@AddedDate)"; return(SQLDataAccess.SaveData(sql, data)); } }