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