//получение категорий из БД
public static IEnumerable<CategoriesViewModel> GetCategories(String sidx, String sord)
{
using (var db = new RecipeManagmentSystemEntities())
{
var result = (from p in db.Category.OrderBy(x => x.CategoryID)
select new CategoriesViewModel
{
CategoryID = p.CategoryID,
ParentCategoryID = p.ParentCategoryID,
Title = p.Title
}).ToList();
return result;
}
}
public static IEnumerable<UserViewModel> GetUsers(String sidx, String sord)
{
using (var db = new RecipeManagmentSystemEntities())
{
String orderBytext = String.Format("it.{0} {1}", sidx, sord);
var result = (from p in db.User.OrderBy(x => x.FirstName)
select new UserViewModel
{
UserID = p.UserID,
FirstName = p.FirstName.Trim(),
LastName = p.LastName.Trim(),
Birthday = p.Birthday,
Telephone = p.Telephone.Trim(),
Mail = p.Mail.Trim()
}).ToList();
return result;
}
}
public UserRepository()
{
using (var db = new RecipeManagmentSystemEntities())
{
var result = (from p in db.User.OrderBy(x => x.FirstName)
select new UserViewModel
{
UserID = p.UserID,
FirstName = p.FirstName,
LastName = p.LastName,
Birthday = p.Birthday,
Telephone = p.Telephone,
Mail = p.Mail
}).ToList();
_users = result;
}
}
public static IEnumerable<IngredientsViewModel> GetIngredients(String sidx, String sord)
{
using (var db = new RecipeManagmentSystemEntities())
{
String orderBytext = String.Format("it.{0} {1}", sidx, sord);
var result = (from p in db.Ingredient.OrderBy(x => x.Title)
select new IngredientsViewModel
{
IngredientID = p.IngredientID,
Title = p.Title,
LongDescription = p.LongDescription,
Cost = p.Cost,
Weight = p.Weight,
CategoryID = p.CategoryID,
CategoryName = p.Category.Title
}).ToList();
return result;
}
}
