//Read User with Id.
public User Read(int id)
{
using (var db = new GakuenContext())
{
return(db.Users.Include(user => user.Address).Include(user => user.OrderLists).Include(user => user.SchoolEvents).FirstOrDefault(customer => customer.Id == id));
}
}
//Read OrderLists with Id.
public OrderList Read(int id)
{
using (var db = new GakuenContext())
{
return(db.OrderLists.Include(orderList => orderList.User).Include(orderList => orderList.ItemsList).FirstOrDefault(list => list.Id == id));
}
}
//Read Address with Id.
public Address Read(int id)
{
using (var db = new GakuenContext())
{
return(db.Addresses.FirstOrDefault(address => address.Id == id));
}
}
//Read NewsMessages with Id.
public NewsMessage Read(int id)
{
using (var db = new GakuenContext())
{
return(db.NewsMessages.Include("ImageToHost").Include("VideoToHost").FirstOrDefault(message => message.Id == id));
}
}
//Read EventMessages with Id.
public EventMessage Read(int id)
{
using (var db = new GakuenContext())
{
return(db.EventMessages.Include(eventMessage => eventMessage.ImageToHost).Include(newsMessage => newsMessage.VideoToHost).FirstOrDefault(message => message.Id == id));
}
}
//Read List of all VideoToHosts.
public VideoToHost Read(int id)
{
using (var db = new GakuenContext())
{
return(db.VideoToHosts.FirstOrDefault(videoToHost => videoToHost.Id == id));
}
}
//Read ImageToHost with Id.
public ImageToHost Read(int id)
{
using (var db = new GakuenContext())
{
return(db.Images.FirstOrDefault(image => image.Id == id));
}
}
//Creates SchoolEvent and save changes.
public SchoolEvent Create(SchoolEvent o)
{
using (var db = new GakuenContext())
{
if (db.SchoolEvents == null)
{
return(null);
}
o.Schedule = db.Schedules.Include(schedule => schedule.SchoolEvents).FirstOrDefault(schedule => schedule.Id == o.Schedule.Id);
var tmpList = new List <User>();
foreach (var user1 in o.Users)
{
tmpList.Add(db.Users.Include(user => user.Address).Include(user => user.OrderLists).Include(user => user.SchoolEvents).FirstOrDefault(user => user.Id == user1.Id));
}
o.Users = tmpList;
db.SchoolEvents.Add(o);
db.SaveChanges();
return(o);
}
}
//Read Schedules with Id.
public Schedule Read(int id)
{
using (var db = new GakuenContext())
{
return(db.Schedules.Include(schedule => schedule.SchoolEvents).FirstOrDefault(schedule => schedule.Id == id));
}
}
//Read AdminUser with Id.
public AdminUser Read(int id)
{
using (var db = new GakuenContext())
{
return(db.AdminUsers.FirstOrDefault(user => user.Id == id));
}
}
//Read Products with Id.
public Product Read(int id)
{
using (var db = new GakuenContext())
{
return(db.Products.FirstOrDefault(product => product.Id == id));
}
}
//Deletes a Schedule and save changes.
public bool Delete(Schedule o)
{
using (var db = new GakuenContext())
{
db.Entry(o).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(Read(o.Id) == null);
}
}
//Updates a VideoToHost and save changes.
public VideoToHost Update(VideoToHost o)
{
using (var db = new GakuenContext())
{
db.Entry(o).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(o);
}
}
//Updates a Schedule and save changes.
public Schedule Update(Schedule o)
{
using (var db = new GakuenContext())
{
db.Entry(o).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(o);
}
}
//Read List of all Addresses.
public List <Address> ReadAll()
{
using (var db = new GakuenContext())
{
if (db.Addresses != null)
{
return(db.Addresses.ToList());
}
return(new List <Address>());
}
}
//Read List of all Users.
public List <User> ReadAll()
{
using (var db = new GakuenContext())
{
if (db.Users != null)
{
return(db.Users.Include(user => user.Address).Include(user => user.OrderLists).Include(user => user.SchoolEvents).ToList());
}
return(new List <User>());
}
}
//Read List of all Products.
public List <Product> ReadAll()
{
using (var db = new GakuenContext())
{
if (db.Products != null)
{
return(db.Products.ToList());
}
return(new List <Product>());
}
}
//Read VideoToHost with Id.
public List <VideoToHost> ReadAll()
{
using (var db = new GakuenContext())
{
if (db.VideoToHosts != null)
{
return(db.VideoToHosts.ToList());
}
return(new List <VideoToHost>());
}
}
//Read List of all OrderLists.
public List <OrderList> ReadAll()
{
using (var db = new GakuenContext())
{
if (db.OrderLists != null)
{
return(db.OrderLists.Include(orderList => orderList.User).Include(orderList => orderList.ItemsList).ToList());
}
return(new List <OrderList>());
}
}
//Read List of all AdminUsers.
public List <AdminUser> ReadAll()
{
using (var db = new GakuenContext())
{
if (db.AdminUsers != null)
{
return(db.AdminUsers.ToList());
}
return(new List <AdminUser>());
}
}
//Read List of all ImageToHosts.
public List <ImageToHost> ReadAll()
{
using (var db = new GakuenContext())
{
if (db.Images != null)
{
return(db.Images.ToList());
}
return(new List <ImageToHost>());
}
}
//Read List of all Schedules.
public List <Schedule> ReadAll()
{
using (var db = new GakuenContext())
{
if (db.Schedules != null)
{
return(db.Schedules.Include(schedule => schedule.SchoolEvents).ToList());
}
return(new List <Schedule>());
}
}
//Read List of all EventMessages.
public List <EventMessage> ReadAll()
{
using (var db = new GakuenContext())
{
if (db.EventMessages != null)
{
return(db.EventMessages.Include(eventMessage => eventMessage.ImageToHost).Include(newsMessage => newsMessage.VideoToHost).ToList());
}
return(new List <EventMessage>());
}
}
//Creates EventMessage and save changes.
public EventMessage Create(EventMessage o)
{
using (var db = new GakuenContext())
{
if (db.EventMessages == null)
{
return(null);
}
db.EventMessages.Add(o);
db.SaveChanges();
return(o);
}
}
//Creates AdminUser and save changes.
public AdminUser Create(AdminUser o)
{
using (var db = new GakuenContext())
{
if (db.AdminUsers == null)
{
return(null);
}
db.AdminUsers.Add(o);
db.SaveChanges();
return(o);
}
}
//Creates ImageToHost and save changes.
public ImageToHost Create(ImageToHost o)
{
using (var db = new GakuenContext())
{
if (db.Images == null)
{
return(null);
}
db.Images.Add(o);
db.SaveChanges();
return(o);
}
}
//Creates Address and save changes.
public Address Create(Address o)
{
using (var db = new GakuenContext())
{
if (db.Addresses == null)
{
return(null);
}
db.Addresses.Add(o);
db.SaveChanges();
return(o);
}
}
//Creates Product and save changes.
public Product Create(Product o)
{
using (var db = new GakuenContext())
{
if (db.Products == null)
{
return(null);
}
db.Products.Add(o);
db.SaveChanges();
return(o);
}
}
//Creates VideoToHost and save changes.
public VideoToHost Create(VideoToHost o)
{
using (var db = new GakuenContext())
{
if (db.VideoToHosts == null)
{
return(null);
}
db.VideoToHosts.Add(o);
db.SaveChanges();
return(o);
}
}
//Creates Schedule and save changes.
public Schedule Create(Schedule o)
{
using (var db = new GakuenContext())
{
if (db.Schedules == null)
{
return(null);
}
foreach (var schoolEvent in o.SchoolEvents)
{
db.Entry(schoolEvent).State = EntityState.Unchanged;
}
db.Schedules.Add(o);
db.SaveChanges();
return(o);
}
}
