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 SingleItemResponse<PositionDTO> UpdatePosition(PositionDTO updateData) { var updateDataFull = new Position() { PositionId = updateData.PositionId, PositionTitle = updateData.PositionTitle, Section = updateData.Section, Order = updateData.Order, EditedBy = GetUserId(), EditDate = DateTime.Now }; using (var context = new AF_Context()) { try { Position pos = context.Positions.First(p => p.PositionId == updateData.PositionId); context.Entry(pos).CurrentValues.SetValues(updateDataFull); context.SaveChanges(); int id = updateData.PositionId; return GetPosition(id); } catch (Exception ex) { throw; } } }
public SingleItemResponse<PlayDataDTO> UpdatePlay(PlayDataDTO updateData) { var updateDataFull = new Play() { PlayId = updateData.PlayId, Title = updateData.Title, Author = updateData.Author, FestivalId = updateData.FestivalId, Day = updateData.Day, Order = updateData.Order, PlayedBy = updateData.PlayedBy, Motto = updateData.Motto, EditedBy = GetUserId(), EditDate = DateTime.Now }; using (var context = new AF_Context()) { try { Play pla = context.Plays.First(p => p.PlayId == updateData.PlayId); context.Entry(pla).CurrentValues.SetValues(updateDataFull); context.SaveChanges(); int id = updateData.PlayId; return GetPlay(id); } catch (Exception ex) { throw; } } }
public SingleItemResponse<JobDTO> UpdateJob(JobDTO updateData) { var updateDataFull = new Job() { JobId = updateData.JobId, JobTitle = updateData.JobTitle, EditedBy = GetUserId(), EditDate = DateTime.Now }; using (var context = new AF_Context()) { try { Job jo = context.Jobs.First(j => j.JobId == updateData.JobId); context.Entry(jo).CurrentValues.SetValues(updateDataFull); context.SaveChanges(); int id = updateData.JobId; return GetJob(id); } catch (Exception ex) { throw; } } }
public SingleItemResponse<FestivalDTO> UpdateFestival(FestivalDTO updateData) { var updateDataFull = new Festival() { FestivalId = updateData.FestivalId, Year = updateData.Year, BeginningDate = updateData.BeginningDate, EndDate = updateData.EndDate, EditedBy = GetUserId(), EditDate = DateTime.Now }; using (var context = new AF_Context()) { try { Festival fes = context.Festivals.First(f => f.FestivalId == updateData.FestivalId); context.Entry(fes).CurrentValues.SetValues(updateDataFull); context.SaveChanges(); int id = updateData.FestivalId; return GetFestival(id); } catch (Exception ex) { throw; } } }
public SingleItemResponse<CategoryDTO> UpdateCategory(CategoryDTO updateData) { var updateDataFull = new Category { CategoryId = updateData.CategoryId, Title = updateData.Title, EditDate = DateTime.Now, EditedBy = GetUserId(), Group = updateData.Group, Order = updateData.Order }; using (var context = new AF_Context()) { try { Category cat = context.Categories.First(c => c.CategoryId == updateData.CategoryId); context.Entry(cat).CurrentValues.SetValues(updateDataFull); context.SaveChanges(); int id = updateData.CategoryId; return GetCategory(id); } catch (Exception ex) { throw; } } }
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 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 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 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 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 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 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 SingleItemResponse<AwardDataDTO> UpdateAward(AwardDataDTO updateData) { var updateDataFull = new Award() { AwardId = updateData.AwardId, CategoryId = updateData.CategoryId, PlayId = updateData.PlayId, EditedBy = GetUserId(), EditDate = DateTime.Now }; using (var context = new AF_Context()) { try { Award awa = context.Awards.First(a => a.AwardId == updateData.AwardId); context.Entry(awa).CurrentValues.SetValues(updateDataFull); context.SaveChanges(); int id = updateData.AwardId; return GetAward(id); } catch (Exception ex) { throw; } } }
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 ActionResult Edit([Bind(Include = "FestivalId,Year,BeginningDate,EndDate")] FestivalDTO updateData) { if (ModelState.IsValid) { var updateDataFull = new Festival() { FestivalId = updateData.FestivalId, Year = updateData.Year, BeginningDate = updateData.BeginningDate, EndDate = updateData.EndDate, EditedBy = 1,//GetUserId(), EditDate = DateTime.Now }; using (var context = new AF_Context()) { Festival fes = context.Festivals.Find(updateData.FestivalId); context.Entry(fes).CurrentValues.SetValues(updateDataFull); context.SaveChanges(); return RedirectToAction("Index"); } } //ViewBag.EditedBy = new SelectList(db.Users, "UserId", "Login", play.EditedBy); //ViewBag.FestivalId = new SelectList(db.Festivals, "FestivalId", "FestivalId", play.FestivalId); return View(updateData); }
public ActionResult Edit([Bind(Include = "PlayId,Title,Author,FestivalId,Day,Order,PlayedBy,Motto")] PlayDataDTO updateData) { if (ModelState.IsValid) { var updateDataFull = new Play() { PlayId = updateData.PlayId, Title = updateData.Title, Author = updateData.Author, FestivalId = updateData.FestivalId, Day = updateData.Day, Order = updateData.Order, PlayedBy = updateData.PlayedBy, Motto = updateData.Motto, EditedBy = 1, //EditedBy = GetUserId(), //??????? EditDate = DateTime.Now }; using (var context = new AF_Context()) { Play pla = context.Plays.Find(updateData.PlayId);// First(p => p.PlayId == updateData.PlayId); string return_s = "Details/" + pla.FestivalId; context.Entry(pla).CurrentValues.SetValues(updateDataFull); //check for substituding only edited //context.Entry(updateDataFull).State = EntityState.Modified; context.SaveChanges(); //int id = updateData.PlayId; //return Redirect(Request.UrlReferrer.ToString()); //RedirectToAction("Index") //return RedirectToAction(return_s); return RedirectToAction(return_s, "Festival"); } } //ViewBag.EditedBy = new SelectList(db.Users, "UserId", "Login", festival.EditedBy); return View(updateData); }