public static List <MenuDTO> GetANewMenu() { using (restaurantEntities db = new restaurantEntities()) { //Where(u => u.DateAdded < DateTime.Today.AddDays(-8)). List <Menu> newM = db.Menu.Where(u => DateTime.Compare(u.DateAdded.Value, DateTime.Now) > 1).ToList(); return(MenuCast.ListToDTO(newM)); } }
public static void Add(MenuDTO menu) { if (menu.ImageBase64 != null) { int index = menu.ImageBase64.IndexOf(','); if (index > 0) { menu.ImageBase64 = menu.ImageBase64.Substring(index + 1); } var bytes = Convert.FromBase64String(menu.ImageBase64); using (var imageFile = new FileStream( @"C:\Users\user-pc\Documents\GitHub\finalPoject\server\WEB_API\WEB_API\src\images\products\" + menu.Category + @"\" + menu.image, FileMode.Create )) { imageFile.Write(bytes, 0, bytes.Length); imageFile.Flush(); } } MenuDAL.Add(MenuCast.ToDAL(menu)); }
//חישוב המנות עם הדירוג הגבוהה ביתר public static List <MenuDTO> GetFavoriteMenu() { using (restaurantEntities db = new restaurantEntities()) { int?TotalsumRating = 0; int?sumRating = 0; List <RatingMenu> LRatingMenu = new List <RatingMenu>(); RatingMenu ratingM = new RatingMenu(); List <Menu> menuList = db.Menu.ToList(); foreach (var menu in menuList) { ratingM = new RatingMenu(); TotalsumRating = 0; sumRating = 0; List <Rating> ratingList = db.Rating.Where(m => m.doseId == menu.Id).ToList(); foreach (var r in ratingList) { sumRating++; TotalsumRating += r.rate; } if (TotalsumRating != 0) { ratingM.MenuID = menu.Id; ratingM.Rate = TotalsumRating / sumRating; LRatingMenu.Add(ratingM); } } var c = LRatingMenu.OrderByDescending(u => u.Rate).Take(5).ToList(); List <Menu> List = new List <Menu>(); foreach (var item in c) { Menu m = db.Menu.FirstOrDefault(t => t.Id == item.MenuID); if (List.FirstOrDefault(w => w.Id == m.Id) == null) { List.Add(m); } } return(MenuCast.ListToDTO(List)); } }
public static List <MenuDTO> GetByCategory(int id) { return(MenuCast.ListToDTO(MenuDAL.GetByCategory(id))); }
public static MenuDTO GetById(int id) { return(MenuCast.ToDTO(MenuDAL.GetById(id))); }
public static void Delete(MenuDTO menu) { MenuDAL.Delete(MenuCast.ToDAL(menu)); }
public static void Update(MenuDTO menu) { MenuDAL.Update(MenuCast.ToDAL(menu)); }
public static List <MenuDTO> GetAll() { return(MenuCast.ListToDTO(MenuDAL.GetAll())); }