public static List <CategoryModel> GetCategories(int year)
{
using (var dbContext = new JojoscarDbContext(year))
{
return(dbContext.Categories.AsNoTracking().ToList());
}
}
public static CategoryModel GetCategory(int year, int CategoryNb)
{
using (var dbContext = new JojoscarDbContext(year))
{
return(dbContext.Categories.AsNoTracking().FirstOrDefault(g => g.CategoryNb == CategoryNb));
}
}
public static void DeleteGuest(int year, int guestId)
{
using (var dbContext = new JojoscarDbContext(year))
{
dbContext.Database.ExecuteSqlCommand("exec DeleteGuest @guestId = {0}", guestId);
}
}
public static GuestModel GetGuest(int year, int guestId)
{
using (var dbContext = new JojoscarDbContext(year))
{
return(dbContext.Guests.AsNoTracking().FirstOrDefault(g => g.GuestID == guestId));
}
}
public static List <GuestModel> GetGuests(int year)
{
using (var dbContext = new JojoscarDbContext(year))
{
return(dbContext.Guests.AsNoTracking().ToList());
}
}
public static void EditCategory(int year, CategoryModel CategoryToModify)
{
using (var dbContext = new JojoscarDbContext(year))
{
dbContext.Entry(CategoryToModify).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public static void DeleteCategory(int year, int categoryId)
{
using (var dbContext = new JojoscarDbContext(year))
{
dbContext.Database.ExecuteSqlCommand("exec DeleteCategory @categoryId = {0}", categoryId);
dbContext.SaveChanges();
}
}
public static void AddCategory(int year, CategoryModel CategoryToAdd)
{
using (var dbContext = new JojoscarDbContext(year))
{
dbContext.Categories.Add(CategoryToAdd);
dbContext.SaveChanges();
}
}
public static void EditGuest(int year, GuestModel guestToModify)
{
using (var dbContext = new JojoscarDbContext(year))
{
dbContext.Entry(guestToModify).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public static void AddGuest(int year, GuestModel guestToAdd)
{
using (var dbContext = new JojoscarDbContext(year))
{
dbContext.Guests.Add(guestToAdd);
dbContext.SaveChanges();
}
}
public static void ReplaceCategoryNominees(int year, List <CategoryNomineeModel> nominees)
{
using (var dbContext = new JojoscarDbContext(year))
{
dbContext.CategoryNominees.RemoveRange(dbContext.CategoryNominees);
dbContext.CategoryNominees.AddRange(nominees);
dbContext.SaveChanges();
}
}