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