public bool DeleteTheProduct(FarmDALModel dalModel)
{
var sql = @"Delete from Produce where produceID = @ProduceID";
using (var connection = new SqlConnection(_config.ConnectionString))
{
var result = connection.Execute(sql, new { ProduceID = $"%{dalModel.ProduceID}%" });
return(true);
}
}
private Products MapProductViewModel(FarmDALModel dalProduct)
{
var product = new Products();
product.ProduceName = dalProduct.ProduceName;
product.ProduceID = dalProduct.ProduceID;
product.UnitPrice = dalProduct.UnitPrice;
product.StockQuantity = dalProduct.StockQuantity;
product.InSeason = dalProduct.InSeason;
return(product);
}
private FarmDALModel MapToFarmDalModel(AddProductViewModel src)
{
var dalProduct = new FarmDALModel();
dalProduct.ProduceName = src.ProduceName;
dalProduct.ProduceID = src.ProduceID;
dalProduct.StockQuantity = src.StockQuantity;
dalProduct.UnitPrice = src.UnitPrice;
dalProduct.InSeason = src.InSeason;
return(dalProduct);
}
public bool InsertNewProduct(FarmDALModel dalModel)
{
//ADD PRODUCT
var sql = $@"Insert INTO Produce (ProduceName) Values (@{nameof(dalModel.ProduceName)})";
using (var connection = new SqlConnection(_config.ConnectionString))
{
var result = connection.Execute(sql, dalModel);
return(true);
}
}
public ProductViewModel AddNewProduct(Products model)
{
var dalModel = new FarmDALModel();
dalModel.ProduceName = model.ProduceName;
_farmStore.InsertNewProduct(dalModel);
//MAPPING
var dalProducts = _farmStore.SelectAllProducts();
var products = new List <Products>();
foreach (var dalProduct in dalProducts)
{
var product = new Products();
product.ProduceName = dalProduct.ProduceName;
products.Add(product);
}
var ProductViewModel = new ProductViewModel();
ProductViewModel.Products = products;
return(ProductViewModel);
}
public ProductListItemViewModel(FarmDALModel dalModel)
{
ID = dalModel.ProduceID;
Name = dalModel.ProduceName;
}
