public IActionResult GetResultsDataSet()
{
var member = HttpContext.Session.GetObjectFromJson <MemberModel>("Member");
if (member == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
var list = new List <ResultDatasetModel>();
try
{
using (TWHContext dbContext = new TWHContext())
{
list = dbContext.GetResultsDataSet(DateTime.Now.Year);
}
}
catch (Exception ex)
{
AddException(ex, "GetResultsDataSet");
}
return(Ok(list));
}
}
public IActionResult VoteAll(VotingModel voting)
{
voting.VotingTime = DateTime.Now;
var member = HttpContext.Session.GetObjectFromJson <MemberModel>("Member");
if (member == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
try
{
using (TWHContext dbContext = new TWHContext())
{
dbContext.InternalRegimeVoteAll(voting);
}
}
catch (Exception ex)
{
AddException(ex, "VoteAll");
}
return(Ok());
}
}
public IActionResult GetItemById(ItemModel item)
{
try
{
using (TWHContext dbContext = new TWHContext())
{
item = dbContext.GetItemById(item.ID);
}
}
catch (Exception ex)
{
AddException(ex, "GetItemById");
}
return(Ok(item));
}
public IActionResult VerifyMember(MemberModel Member)
{
var memberId = Request.Query["memberId"];
var pin = Request.Query["password"];
MemberModel member = null;
try
{
using (TWHContext dbContext = new TWHContext())
{
member = dbContext.VerifyMember(Convert.ToInt64(memberId), Convert.ToInt32(pin));
}
if (member != null)
{
if (member.Locked.HasValue)
{
if (member.Locked.Value)
{
TempData["locked"] = "true";
return(RedirectToAction("Login", "Login"));
}
else
{
HttpContext.Session.SetObjectAsJson("Member", member);
TempData["verified"] = "true";
return(RedirectToAction("Index", "Home"));
}
}
else
{
TempData["locked"] = "true";
return(RedirectToAction("Login", "Login"));
}
}
}
catch (Exception ex)
{
throw ex;
}
TempData["verified"] = "false";
return(RedirectToAction("Login", "Login"));
}
public IActionResult GetItemList()
{
var list = new List <ItemModel>();
try
{
using (TWHContext dbContext = new TWHContext())
{
list = dbContext.GetItems();
}
}
catch (Exception ex)
{
AddException(ex, "GetItemList");
}
return(Ok(list));
}
public int AddException(Exception ex, string absoluteURL)
{
var member = HttpContext.Session.GetObjectFromJson <MemberModel>("Member");
int id = 0;
ExceptionModel model = new ExceptionModel();
model.StackTrace = ex.StackTrace;
model.AbsoluteUrl = absoluteURL;
model.MemberId = member.MemberID;
model.MemberFullName = member.FullName;
using (TWHContext context = new TWHContext())
{
id = context.AddException(model);
}
return(id);
}
public IActionResult GetMembersByUnit(UnitModel unit)
{
var list = new List <MemberModel>();
try
{
using (TWHContext dbContext = new TWHContext())
{
list = dbContext.GetMembersByUnit(unit.UnitId, unit.ItemId);
}
}
catch (Exception ex)
{
AddException(ex, "GetMembersByUnit");
}
return(Ok(list));
}
public IActionResult GetVotings(MemberModel Member)
{
var list = new List <VotingModel>();
try
{
using (TWHContext dbContext = new TWHContext())
{
list = dbContext.GetVotings(Member.MemberID);
}
}
catch (Exception ex)
{
AddException(ex, "GetVotings");
}
return(Ok(list));
}
public IActionResult GetUnits(UnitModel unit)
{
var list = new List <UnitModel>();
try
{
using (TWHContext dbContext = new TWHContext())
{
list = dbContext.GetUnits();
}
}
catch (Exception ex)
{
AddException(ex, "GetUnits");
}
return(Ok(list));
}
