public static List <MenuItem> GetItemsSortByCategory(NetFrameworkMenuContext context) { return(context.MenuItems .AsNoTracking() .OrderBy(mi => mi.Category) .ToList()); }
public static List <string> ReturnAllDisplayNames(NetFrameworkMenuContext context) { return(context.Css .AsNoTracking() .Select(o => o.DisplayName) .ToList()); }
public static string ReturnSelectedCSS(NetFrameworkMenuContext context) { return(context.SystemOptions .AsNoTracking() .Single(o => o.Key.Equals(SystemOption.CSS_KEY)) .Value); }
public static List <Coupon> GetItemsSortByCategory(NetFrameworkMenuContext context) { return(context.Coupons .AsNoTracking() .OrderBy(mi => mi.CouponNumber) .ToList()); }
public CouponForm(NetFrameworkMenuContext context) { InitializeComponent(); _context = context; setupListColumns(); loadMenuData(); showMenuList(); }
public static List <String> GetCategories(NetFrameworkMenuContext context) { return(context.MenuItems .AsNoTracking() .Select(m => m.Category) .Distinct() .ToList()); }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); NetFrameworkMenuContext context = NetFrameworkMenuContext.GetContext(); context.Database.CreateIfNotExists(); Application.Run(new MenuForm(context)); }
public static void UpdateActiveCSS(NetFrameworkMenuContext context, string newValue) { var settingToUpdate = context.SystemOptions .Single(o => o.Key.Equals(SystemOption.CSS_KEY)); settingToUpdate.Value = newValue; context.SaveChanges(); }
internal static void UpdateItemByObject(NetFrameworkMenuContext context, int activeID, Coupon obj) { var itemToUpdate = context.Coupons .SingleOrDefault(m => m.CouponID == activeID); itemToUpdate.CouponNumber = obj.CouponNumber; itemToUpdate.DiscountPrice = obj.DiscountPrice; itemToUpdate.StartDate = obj.StartDate; itemToUpdate.EndDate = obj.EndDate; itemToUpdate.Status = obj.Status; context.SaveChanges(); }
static void Main(string[] args) { using (var context = NetFrameworkMenuContext.GetContext()) { context.Database.CreateIfNotExists(); var ta = from e in context.Table select e; foreach (var t in ta) { Console.WriteLine("Table ID: " + t.TableID + " ~ IsEmpty: " + t.IsEmpty + "\n"); } } Console.ReadLine(); }
public static void UpdateItemByObject(NetFrameworkMenuContext context, int id, MenuItem obj) { var itemToUpdate = context.MenuItems .SingleOrDefault(m => m.MenuItemID == id); itemToUpdate.Category = obj.Category; itemToUpdate.Description = obj.Description; itemToUpdate.DiscountPrice = obj.DiscountPrice; itemToUpdate.IsAvailable = obj.IsAvailable; itemToUpdate.IsSpecialty = obj.IsSpecialty; itemToUpdate.Price = obj.Price; itemToUpdate.Title = obj.Title; context.SaveChanges(); }
public static bool DeleteItemById(NetFrameworkMenuContext context, int id) { var menuItem = context.MenuItems .SingleOrDefault(m => m.MenuItemID == id); if (menuItem == null) { return(false); } try { context.MenuItems.Remove(menuItem); context.SaveChanges(); return(true); } catch (DbUpdateException) { return(false); } }
internal static bool DeleteItemById(NetFrameworkMenuContext context, int activeID) { var coupon = context.Coupons .SingleOrDefault(m => m.CouponID == activeID); if (coupon == null) { return(false); } try { context.Coupons.Remove(coupon); context.SaveChanges(); return(true); } catch (DbUpdateException) { return(false); } }
public static void CreateItem(NetFrameworkMenuContext context, MenuItem m) { context.MenuItems.Add(m); context.SaveChanges(); }
internal static Coupon GetOneById(NetFrameworkMenuContext context, int activeID) { return(context.Coupons .AsNoTracking(). Single(m => m.CouponID == activeID)); }
public static MenuItem GetOneById(NetFrameworkMenuContext context, int id) { return(context.MenuItems .AsNoTracking(). Single(m => m.MenuItemID == id)); }
public static void CreateItem(NetFrameworkMenuContext context, Coupon m) { context.Coupons.Add(m); context.SaveChanges(); }