// AF_Context context = new AF_Context(); #region Award public async Task AddAward(Award newAward) { using (var context = new AF_Context()) { try { context.Awards.Add(newAward); int recordsAffected = await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task UpdateAward(Award updateData) { using (var context = new AF_Context()) { try { /*Award awa = await (from a in context.Awards where a.AwardId == updateData.AwardId select a).ToListAsync();*/ Award awa = context.Awards.First(a => a.AwardId == updateData.AwardId); context.Entry(awa).CurrentValues.SetValues(updateData); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task RemoveAward(int id) { using (var context = new AF_Context()) { try { /*List<Award> awa = await (from a in context.Awards where a.AwardId == id select a).ToListAsync();*/ Award awa = context.Awards.First(a => a.AwardId == id); context.Awards.Remove(awa); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task AddRelationPersonPlayRole(RelationPersonPlayRole newRelationPersonPlayRole) { using (var context = new AF_Context()) { try { context.RelationsPersonPlayRole.Add(newRelationPersonPlayRole); int recordsAffected = await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task UpdatePosition(Position updateData) { using (var context = new AF_Context()) { try { Position pos = context.Positions.First(p => p.PositionId == updateData.PositionId); context.Entry(pos).CurrentValues.SetValues(updateData); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task AddPosition(Position newPosition) { using (var context = new AF_Context()) { try { context.Positions.Add(newPosition); int recordsAffected = await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task RemovePlay(int id) { using (var context = new AF_Context()) { try { Play pla = context.Plays.First(p => p.PlayId == id); context.Plays.Remove(pla); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task RemovePerson(int id) { using (var context = new AF_Context()) { try { Person per = context.People.First(p => p.PersonId == id); context.People.Remove(per); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task AddNews(News newNews) { using (var context = new AF_Context()) { try { context.News.Add(newNews); int recordsAffected = await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task AddCategory(Category newCategory) { using (var context = new AF_Context()) { try { context.Categories.Add(newCategory); int recordsAffected = await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task UpdateUser(User updateData) { using (var context = new AF_Context()) { try { User us = context.Users.First(u => u.UserId == updateData.UserId); context.Entry(us).CurrentValues.SetValues(updateData); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task RemoveUser(int id) { using (var context = new AF_Context()) { try { User us = context.Users.First(u => u.UserId == id); context.Users.Remove(us); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task AddUser(User newUser) { using (var context = new AF_Context()) { try { context.Users.Add(newUser); int recordsAffected = await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task UpdateRelationPersonPlayRole(RelationPersonPlayRole updateData) { using (var context = new AF_Context()) { try { RelationPersonPlayRole rel = context.RelationsPersonPlayRole.First(r => r.RelationPersonPlayRoleId == updateData.RelationPersonPlayRoleId); context.Entry(rel).CurrentValues.SetValues(updateData); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task RemoveRelationPersonPlayRole(int id) { using (var context = new AF_Context()) { try { RelationPersonPlayRole rel = context.RelationsPersonPlayRole.First(r => r.RelationPersonPlayRoleId == id); context.RelationsPersonPlayRole.Remove(rel); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task RemoveJob(int id) { using (var context = new AF_Context()) { try { Job jo = context.Jobs.First(j => j.JobId == id); context.Jobs.Remove(jo); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task UpdateJob(Job updateData) { using (var context = new AF_Context()) { try { Job jo = context.Jobs.First(j => j.JobId == updateData.JobId); context.Entry(jo).CurrentValues.SetValues(updateData); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task RemoveCategory(int id) { using (var context = new AF_Context()) { try { Category cat = context.Categories.First(c => c.CategoryId == id); context.Categories.Remove(cat); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task RemoveNews(int id) { using (var context = new AF_Context()) { try { News ne = context.News.First(n => n.NewsId == id); context.News.Remove(ne); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task UpdateCategory(Category updateData) { using (var context = new AF_Context()) { try { //TODO: wyczyscic lol //Category cat = context.Categories.Find(updateData.CategoryId); Category cat = context.Categories.First(c => c.CategoryId==updateData.CategoryId); cat.CategoryId = updateData.CategoryId; cat.EditDate = updateData.EditDate; cat.EditedBy = updateData.EditedBy; cat.Group = updateData.Group; cat.Order = updateData.Order; cat.Title = updateData.Title; await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task UpdateNews(News updateData) { using (var context = new AF_Context()) { try { News ne = context.News.First(n => n.NewsId == updateData.NewsId); context.Entry(ne).CurrentValues.SetValues(updateData); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task AddFestival(Festival newFestival) { using (var context = new AF_Context()) { try { context.Festivals.Add(newFestival); int recordsAffected = await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task UpdatePerson(Person updateData) { using (var context = new AF_Context()) { try { Person per = context.People.First(a => a.PersonId == updateData.PersonId); context.Entry(per).CurrentValues.SetValues(updateData); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task RemoveFestival(int id) { using (var context = new AF_Context()) { try { Festival fes = context.Festivals.First(f => f.FestivalId == id); context.Festivals.Remove(fes); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task UpdatePlay(Play updateData) { using (var context = new AF_Context()) { try { Play pla = context.Plays.First(p => p.PlayId == updateData.PlayId); context.Entry(pla).CurrentValues.SetValues(updateData); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task UpdateFestival(Festival updateData) { using (var context = new AF_Context()) { try { Festival fes = context.Festivals.First(f => f.FestivalId == updateData.FestivalId); context.Entry(fes).CurrentValues.SetValues(updateData); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task RemovePosition(int id) { using (var context = new AF_Context()) { try { Position pos = context.Positions.First(p => p.PositionId == id); context.Positions.Remove(pos); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task AddJob(Job newJob) { using (var context = new AF_Context()) { try { context.Jobs.Add(newJob); int recordsAffected = await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task AddRelationFestivalPersonPosition(RelationFestivalPersonPosition newRelationFestivalPersonPosition) { using (var context = new AF_Context()) { try { context.RelationsFestivalPersonPosition.Add(newRelationFestivalPersonPosition); int recordsAffected = await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }
public async Task RemoveRelationFestivalPersonPosition(int id) { using (var context = new AF_Context()) { try { RelationFestivalPersonPosition rel = context.RelationsFestivalPersonPosition.First(r => r.RelationFestivalPersonPositionId == id); context.RelationsFestivalPersonPosition.Remove(rel); await context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } } }