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