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