public Tuple <string, bool> NewReferendum(string name, string detail, string images) { Referendum newItem = new Referendum() { Name = name, Detail = detail, Images = images, Active = true }; using (var ctx = _dbContext = new votingBackendDbContext(builder.Options)) { try { var update = (from r in ctx.ReferendumSet where r.Active == true select new Referendum { Id = r.Id, Name = r.Name, Detail = r.Detail, Images = r.Images, Active = r.Active }).ToList(); foreach (var item in update) { item.Active = false; ctx.Entry(item).State = EntityState.Modified; } ctx.ReferendumSet.Add(newItem); ctx.SaveChanges(); if (newItem.Id >= 0) { return(Tuple.Create("Success", true)); } else { return(Tuple.Create("Unable to register Referendum", false)); } } catch (Exception ex) { return(Tuple.Create(ex.Message, false)); } } }
public Tuple <Referendum, string, bool> GetReferendum() { Referendum listItems = new Referendum(); using (var ctx = _dbContext = new votingBackendDbContext(builder.Options)) { try { var result = (from i in ctx.ReferendumSet where i.Active == true select new Referendum { Id = i.Id, Name = i.Name, Detail = i.Detail, Images = i.Images }).ToList(); if (result.Count != 0) { if (result.FirstOrDefault() != null) { listItems = result.FirstOrDefault(); return(Tuple.Create(listItems, "Success", true)); } else { return(Tuple.Create(listItems, "Unable to get Referendum", false)); } } else { return(Tuple.Create(listItems, "Unable to get Referendum", false)); } } catch (Exception ex) { return(Tuple.Create(listItems, ex.Message, false)); } } }
public IActionResult AddReferendum([FromBody] Referendum referendum) { db.AddReferendum(referendum); return(Ok(referendum)); }
public IActionResult ChangeDeadLine([FromBody] Referendum edittedReferendum) { db.ChangeDeadLineDb(edittedReferendum); return(Ok(edittedReferendum)); }
public IActionResult ChangeMaxAmountAnswers([FromBody] Referendum edittedReferendum) { db.ChangeMaxAmountAnswersDb(edittedReferendum); return(Ok(edittedReferendum)); }