public static List <Message> Read()
{
using (var db = new MakerContext())
{
var messages = db.Messages.ToList();
return(messages);
}
}
public static List <Printer> Read()
{
using (var db = new MakerContext())
{
var printers = db.Printers.Include(u => u.Bookings).ToList();
return(printers);
}
}
public static IEnumerable <Booking> Read()
{
using (var db = new MakerContext())
{
var bookings = db.Bookings.Include(u => u.User).ToList();
return(bookings);
}
}
public static void Delete(User user)
{
using (var db = new MakerContext())
{
db.Users.Attach(user);
db.Users.Remove(user);
db.SaveChanges();
}
}
public static void Delete(Message message)
{
using (var db = new MakerContext())
{
db.Messages.Attach(message);
db.Messages.Remove(message);
db.SaveChanges();
}
}
public static void Delete(Booking booking)
{
using (var db = new MakerContext())
{
db.Bookings.Attach(booking);
db.Bookings.Remove(booking);
db.SaveChanges();
}
}
public static void Delete(Printer printer)
{
using (var db = new MakerContext())
{
db.Printers.Attach(printer);
db.Printers.Remove(printer);
db.SaveChanges();
}
}
public static async Task Delete(UserRole userRole)
{
using (var db = new MakerContext())
{
db.UserRoles.Attach(userRole);
db.UserRoles.Remove(userRole);
await db.SaveChangesAsync();
}
}
public static UserRole Read(int id)
{
using (var db = new MakerContext())
{
var userRole = db.UserRoles.Include(u => u.Users).SingleOrDefault(u => u.Id == id);
return(userRole);
}
}
public static List <UserRole> Read()
{
using (var db = new MakerContext())
{
var userRoles = db.UserRoles
.Include(u => u.Users);
return(userRoles.ToList());
}
}
public static User FindByEmail(string mail)
{
using (var db = new MakerContext())
{
var user = db.Users.Include(u => u.UserRole)
.Include(u => u.Bookings).SingleOrDefault(u => u.Email == mail);
return(user);
}
}
public static Booking Create(Booking booking)
{
using (var db = new MakerContext())
{
db.Bookings.Add(booking);
db.SaveChanges();
return(booking);
}
}
public static User Create(User user)
{
using (var db = new MakerContext())
{
db.Users.Add(user);
db.SaveChanges();
return(user);
}
}
public static Printer Create(Printer printer)
{
using (var db = new MakerContext())
{
db.Printers.Add(printer);
db.SaveChanges();
return(printer);
}
}
public static async Task <UserRole> Create(UserRole userRole)
{
using (var db = new MakerContext())
{
db.UserRoles.Add(userRole);
await db.SaveChangesAsync();
return(userRole);
}
}
public static Printer Read(string uuid)
{
using (var db = new MakerContext())
{
var printer = db.Printers.Include(u => u.Bookings)
.Include(u => u.Bookings).SingleOrDefault(u => u.UuId == uuid);
return(printer);
}
}
public static Message Create(Message message)
{
using (var db = new MakerContext())
{
db.Messages.Add(message);
db.SaveChanges();
return(message);
}
}
public static IEnumerable <User> Read()
{
using (var db = new MakerContext())
{
var persons = db.Users
.Include(u => u.UserRole)
.Include(u => u.Bookings)
.ToList();
return(persons);
}
}
public static Booking Update(Booking booking)
{
using (var db = new MakerContext())
{
db.Bookings.Attach(booking);
var updatedPrinter = db.Entry(booking);
updatedPrinter.State = EntityState.Modified;
db.SaveChanges();
return(updatedPrinter.Entity);
}
}
public static User Update(User user)
{
using (var db = new MakerContext())
{
db.Users.Attach(user);
var updatedUser = db.Entry(user);
updatedUser.State = EntityState.Modified;
db.SaveChanges();
return(updatedUser.Entity);
}
}
public static Printer Update(Printer printer)
{
using (var db = new MakerContext())
{
db.Printers.Attach(printer);
var updatedPrinter = db.Entry(printer);
updatedPrinter.State = EntityState.Modified;
db.SaveChanges();
return(updatedPrinter.Entity);
}
}
public static async Task <UserRole> Update(UserRole userRole)
{
using (var db = new MakerContext())
{
db.UserRoles.Attach(userRole);
var updatedUser = db.Entry(userRole);
updatedUser.State = EntityState.Modified;
await db.SaveChangesAsync();
return(updatedUser.Entity);
}
}
