public List <string> GetAllCategories() { using (Baby_BEntities1 db = new Baby_BEntities1()) { var Categories = db.Category.Select(c => c.NameCategory).ToList <String>(); return(Categories); } }
public int GetIdSubCategory(string nameSubCategory) { using (Baby_BEntities1 db = new Baby_BEntities1()) { int idSubCategory = db.SubCategory.Where(c => c.NameSubCategory == nameSubCategory).Select(c => c.IdSubCategory).FirstOrDefault(); return(idSubCategory); } }
public int AddProducts([FromBody] Products product) { using (Baby_BEntities1 db = new Baby_BEntities1()) { try { db.Products.Add(product); db.SaveChanges(); return(product.IdProduct); } catch (Exception e) { return(0); } } }
public List <string> GetSubCategories([FromUri] string selectedCategory) { using (Baby_BEntities1 db = new Baby_BEntities1()) { Category ccc = db.Category.First(cc => cc.NameCategory == selectedCategory); int id = ccc.IdCategory; List <SubCategory> subcategory = new List <SubCategory>(); subcategory = db.SubCategory.Where(ss => ss.IdCategory == id).ToList(); List <string> subcategorys = new List <string>(); foreach (var item in subcategory) { subcategorys.Add(item.NameSubCategory); } return(subcategorys); //string idCategoryw = db.Category.Where(cc => cc.NameCategory == selectedCategory).Select(cc => cc.IdCategory).ToString(); //int idCategorywj =Convert.ToInt32(db.Category.Where(c => c.NameCategory == selectedCategory).Select(c => c.IdCategory).ToString()); //int idCategory =Convert.ToInt32( db.Category.Where(c=>c.NameCategory==selectedCategory).Select(c => c.IdCategory)); //var SubCategory = db.SubCategory.Where(c => c.IdCategory==idCategory).Select(c=>c.NameSubCategory).ToList<String>(); // return SubCategory; } }