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));
}
}
