//Update VotingCard
public JsonResult Vote(VotingCardDto votingCardDto)
{
object result = null;
var votingCard = _context.VotingCards
.Include("VotingCardLines").Where(v => v.Id == votingCardDto.Id).FirstOrDefault();
if (votingCard == null)
{
throw new InvalidOperationException();
}
//Validate VotingCardVM on server here
try
{
var votingCardLines = VotingCardHelper.ToVotingCardLines(votingCardDto.VotingCardLines);
votingCard.Vote(votingCardDto.IsInvalid, votingCardLines);
_context.SaveChanges();
var returnedObj = new { AmtAlreadyVoted = votingCard.AmtAlreadyVoted };
result = new { Status = true, Message = "", ReturnedObj = returnedObj };
}
catch (Exception ex)
{
result = new { Status = false, Message = ex.Message };
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveAFileToDB(HttpPostedFileBase upload)
{
if (upload != null && upload.ContentLength > 0)
{
try
{
var file = new CandidateFile
{
FileType = FileType.Picture,
FileName = upload.FileName,
CandidateId = 1,
ContentType = ""
};
using (var reader = new System.IO.BinaryReader(upload.InputStream))
{
file.Content = reader.ReadBytes(upload.ContentLength);
}
_ctx.CandidateFiles.Add(file);
_ctx.SaveChanges();
}
catch (Exception)
{
//
}
}
return(RedirectToAction("SaveAFileToDB"));
}
public HttpResponseMessage Post([FromBody] ShareHolder shareHolder)
{
//Validate and returnn errors if any
var response = new HttpResponseMessage();
var brokerRules = _shareHolderValidator.BrokenRules(shareHolder);
if (brokerRules.Count() > 0)
{
var message = CoreHelper.MergeErrors(brokerRules);
response = Request.CreateErrorResponse(HttpStatusCode.BadRequest, message);
return(response);
}
//Persist
try
{
_context.ShareHolders.Add(shareHolder);
_context.SaveChanges();
response = Request.CreateResponse <ShareHolder>(HttpStatusCode.Created, shareHolder);
response.Headers.Location = new Uri(Request.RequestUri, "/Api/ShareHolderDS/" + shareHolder.ShareHolderId.ToString());
}
catch (Exception ex)
{
response = Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message, ex);
}
return(response);
}
public Result <int> Create(StatementDto vm)
{
var entity = new Statement(vm.Description);
try
{
_context.Statements.Add(entity);
_context.SaveChanges();
return(Result.OK <int>(entity.Id));
}
catch (Exception ex)
{
return(Result.Fail <int>(ex.Message));
}
}
public void GenerateVotingByHands()
{
RemoveVotingByHands();
var shareHolders = _context.ShareHolders
.Where(m => m.StatusAtMeeting != StatusAtMeeting.Absent)
.ToList();
var statements = _context.Statements.ToList();
foreach (var sh in shareHolders)
{
CreateVotingByHand(sh, statements);
}
_context.SaveChanges();
}
public void ChangeShareHolderStatus(int shareHolderId, int newStatus)
{
ShareHolder sh = _context.ShareHolders
.Include("VotingCards")
.Include("VotingByHands")
.Where(s => s.ShareHolderId == shareHolderId)
.FirstOrDefault();
var newStatusInEnum = (StatusAtMeeting)newStatus;
if (sh == null || sh.StatusAtMeeting == newStatusInEnum)
{
return;
}
if ((sh.StatusAtMeeting == StatusAtMeeting.Attended && newStatusInEnum == StatusAtMeeting.Delegated) ||
sh.StatusAtMeeting == StatusAtMeeting.Delegated && newStatusInEnum == StatusAtMeeting.Attended)
{
sh.StatusAtMeeting = newStatusInEnum;
_context.SaveChanges();
return;
}
//Update Status
sh.StatusAtMeeting = newStatusInEnum;
StatusAtMeeting newStateInEnum = (StatusAtMeeting)newStatus;
switch (newStateInEnum)
{
case StatusAtMeeting.Absent:
//sh.RemoveAllVotingCardsAndVotingByHands();
_context.RemoveVotingCardsAndVotingByHands(sh.ShareHolderId);
break;
case StatusAtMeeting.Attended:
CreateVotingCardsAndVotingByHands(sh);
break;
case StatusAtMeeting.Delegated:
CreateVotingCardsAndVotingByHands(sh);
break;
default:
throw new ArgumentOutOfRangeException();
}
_context.SaveChanges();
}
public Result <Candidate> Handler(RemoveCandidateCommand cmd)
{
var id = cmd.CandidateId;
var candidate = _context.Candidates.Find(id);
if (candidate == null)
{
return(Result <Candidate> .Fail <Candidate>($"Candidate with id of {id} not found"));
}
try
{
_context.Candidates.Remove(candidate);
_context.SaveChanges();
return(Result <Candidate> .OK <Candidate>(candidate));
}
catch (Exception ex)
{
return(Result <Candidate> .Fail <Candidate>(ex.Message));
}
}
public void SaveToLogTable(string message)
{
_ctx.ExceptionLogs.Add(new ExceptionLog(message));
_ctx.SaveChanges();
}
public void Commit()
{
context.SaveChanges();
}