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