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