public static Product FindProduct(int Id) { using (AuerfarmDataContext db = new AuerfarmDataContext()) { return(db.Products.Where(i => i.Id == Id).FirstOrDefault()); } }
public static List <Product> GetProducts() { using (AuerfarmDataContext db = new AuerfarmDataContext()) { return(db.Products.OrderBy(i => i.Name).ToList()); } }
public static void AddMapItem(MapItem input) { using (AuerfarmDataContext db = new AuerfarmDataContext()) { MapItem target = db.MapItems.Where(i => i.Id == input.Id).FirstOrDefault() ?? null; if (target == null) { db.MapItems.Add(input); db.SaveChanges(); } else { target.Name = input.Name; target.Description = input.Description; target.Type = input.Type; if (input.Long != null) { target.Long = input.Long; } if (input.Lat != null) { target.Lat = input.Lat; } target.Image = input.Image; target.Active = input.Active; db.SaveChanges(); } } }
public static FarmInfoItem FindInfoItem(int Id) { using (AuerfarmDataContext db = new AuerfarmDataContext()) { return(db.InfoItems.Where(i => i.Id == Id).FirstOrDefault()); } }
public static bool DeleteProduct(Product input) { using (AuerfarmDataContext db = new AuerfarmDataContext()) { Product item = db.Products.Where(i => i.Id == input.Id).FirstOrDefault(); db.Products.Remove(item); db.SaveChanges(); return(true); } }
public static void AddProduct(Product input) { using (AuerfarmDataContext db = new AuerfarmDataContext()) { input.Date = input.Date ?? DateTime.Now; input.Image = input.Image ?? "rafi-filler-pic.jpg"; db.Products.Add(input); db.SaveChanges(); } }
public static bool DeleteInfoItem(FarmInfoItem input) { using (AuerfarmDataContext db = new AuerfarmDataContext()) { FarmInfoItem item = db.InfoItems.Where(i => i.Id == input.Id).FirstOrDefault(); db.InfoItems.Remove(item); db.SaveChanges(); return(true); } }
public static void UpdateProduct(Product input) { using (AuerfarmDataContext db = new AuerfarmDataContext()) { Product item = db.Products.Where(i => i.Id == input.Id).FirstOrDefault(); item.Name = input.Name; item.Description = input.Description; item.Date = input.Date ?? DateTime.Now; item.Price = input.Price; input.Image = input.Image ?? "rafi-filler-pic.jpg"; db.SaveChanges(); } }
public static void AddInfoItem(FarmInfoItem input) { using (AuerfarmDataContext db = new AuerfarmDataContext()) { input.Date = input.Date ?? DateTime.Now; input.StartDate = input.StartDate ?? DateTime.Now; input.EndDate = input.EndDate ?? DateTime.MaxValue; input.Image = input.Image ?? "rafi-filler-pic.jpg"; db.InfoItems.Add(input); db.SaveChanges(); } }
public static void UpdateInfoItem(FarmInfoItem input) { using (AuerfarmDataContext db = new AuerfarmDataContext()) { FarmInfoItem itemToChange = db.InfoItems.Where(i => i.Id == input.Id).FirstOrDefault(); itemToChange.Title = input.Title; itemToChange.Date = input.Date ?? DateTime.Now; itemToChange.Description = input.Description; itemToChange.StartDate = input.StartDate ?? DateTime.Now; itemToChange.EndDate = input.EndDate ?? DateTime.MaxValue; itemToChange.Image = input.Image ?? "rafi-filler-pic.jpg"; db.SaveChanges(); } }
public static List <MapItem> GetMapItems(string filter) { using (AuerfarmDataContext db = new AuerfarmDataContext()) { if (filter != "none") { return(db.MapItems.Where(i => i.Type == filter).OrderBy(i => i.Name).ToList()); } else { return(db.MapItems.OrderBy(i => i.Name).ToList()); } } }
public static List <FarmInfoItem> GetInfoItems(string type) { using (AuerfarmDataContext db = new AuerfarmDataContext()) { List <FarmInfoItem> items = new List <FarmInfoItem>(); switch (type) { case "calendar": case "news": items = db.InfoItems.Where(i => i.Type == type || i.Type == "both").OrderByDescending(i => i.Id).ToList(); break; case "both": items = db.InfoItems.OrderByDescending(i => i.Id).ToList(); break; case "calendaronly": case "newsonly": items = db.InfoItems.Where(i => i.Type == type).OrderByDescending(i => i.Id).ToList(); break; } return(items); } }