public ActionResult MenuProduct() { var list = productTypeRepositoryFE.GetAllChildByParent(Convert.ToInt32(Resources.ResourceID.ProductRoot)); var menu = new MenuProductModel() { ListProductType = list.Where(t => t.ID != Convert.ToInt32(Resources.ResourceID.ProductRoot)).ToList(), RootType = list.FirstOrDefault(t => t.ID == Convert.ToInt32(Resources.ResourceID.ProductRoot)) }; return(View(menu)); }
public Task RemoveProduct(MenuProductModel product) { string sql = "delete from products_table where ProductId=@ProductId"; return(_db.ExecuteSQLQuery(sql, product)); }
public Task UpdateProduct(MenuProductModel product) { string sql = @"update products_table set ProductName=@ProductName, ProductPrice=@ProductPrice, ProductDescription=@ProductDescription, ProductMarks=@ProductMarks where ProductId=@ProductId"; return(_db.ExecuteSQLQuery(sql, product)); }
public Task <int> AddProduct(MenuProductModel product) { string sql = "insert into products_table (ProductName, ProductPrice, ProductDescription, ProductMarks) values (@ProductName, @ProductPrice, @ProductDescription, @ProductMarks); select scope_identity()"; return(_db.InsertDataIntoDatabase(sql, product)); }