public ProductDetailsViewModel UpdateProduct(UpdateProductViewModel userModel)
{
var dalModel = new StoreDALModel();
dalModel.ProductID = userModel.ProductID;
dalModel.ProductName = userModel.ProductName;
dalModel.Quantity = userModel.Quantity;
dalModel.Price = userModel.Price;
_inventoryStore.UpdateProduct(dalModel);
var cartDAL = new CartDALModel();
cartDAL.ProductID = userModel.ProductID;
cartDAL.ProductName = userModel.ProductName;
cartDAL.Quantity = userModel.Quantity;
cartDAL.Price = userModel.Price;
_cartStore.UpdateOtherProperties(cartDAL);
var productDetails = new ProductDetailsViewModel();
productDetails.ProductID = dalModel.ProductID;
productDetails.ProductName = dalModel.ProductName;
productDetails.Quantity = dalModel.Quantity;
productDetails.Price = dalModel.Price;
return(productDetails);
}
public bool DeleteFromCart(CartDALModel dalModel)
{
var sql = @"DELETE FROM cart
WHERE ProductID = @ProductID";
using (var connection = new SqlConnection(_config.ConnectionString))
{
var result = connection.Execute(sql, dalModel);
if (result == 1)
{
return(true);
}
return(false);
}
}
public bool UpdateQuantityInCart(CartDALModel dalModel)
{
var sql = @"UPDATE cart
SET Quantity = @Quantity";
using (var connection = new SqlConnection(_config.ConnectionString))
{
var result = connection.Execute(sql, dalModel);
if (result == 1)
{
return(true);
}
return(false);
}
}
public bool UpdateOtherProperties(CartDALModel dalModel)
{
var sql = @"UPDATE cart SET ProductName = @ProductName, Quantity = @Quantity,
Price = @Price";
using (var connection = new SqlConnection(_config.ConnectionString))
{
var result = connection.Execute(sql, dalModel);
if (result == 1)
{
return(true);
}
return(false);
}
}
