//получение категорий из БД 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; } }