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 StoreViewModel AddProduct(AddProductViewModel userProduct)
{
var dalModel = new StoreDALModel();
dalModel.ProductName = userProduct.ProductName;
dalModel.Quantity = userProduct.Quantity;
dalModel.Price = userProduct.Price;
_inventoryStore.InsertNewProduct(dalModel);
var dalProducts = _inventoryStore.SelectAllProducts();
return(MapDalToProduct(dalProducts));
}
public bool InsertNewProduct(StoreDALModel dalModel)
{
var sql = $@"INSERT INTO inventory (ProductName, Quantity, Price)
Values (@{nameof(dalModel.ProductName)}, @{nameof(dalModel.Quantity)},@{nameof(dalModel.Price)})";
using (var connection = new SqlConnection(_config.ConnectionString))
{
var result = connection.Execute(sql, dalModel);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public bool DeleteProduct(StoreDALModel dalModel)
{
var sql = $@"DELETE FROM inventory where ProductID = @ProductID";
using (var connection = new SqlConnection(_config.ConnectionString))
{
var result = connection.Execute(sql, dalModel);
//return true;
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public bool UpdateProduct(StoreDALModel dalModel)
{
var sql = @"UPDATE inventory SET ProductName = @ProductName,
Quantity = @Quantity, Price = @Price
WHERE ProductID = @ProductID";
using (var connection = new SqlConnection(_config.ConnectionString))
{
var result = connection.Execute(sql, dalModel);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public bool InsertIntoCart(StoreDALModel dalModel)
{
var sql = $@"INSERT INTO cart (ProductID, ProductName, Quantity, Price)
VALUES (
@{nameof(dalModel.ProductID)},
@{nameof(dalModel.ProductName)},
@{nameof(dalModel.Quantity)},
@{nameof(dalModel.Price)}
)";
using (var connection = new SqlConnection(_config.ConnectionString))
{
var result = connection.Execute(sql, dalModel);
if (result == 1)
{
return(true);
}
return(false);
}
}
