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