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