public static List <Candidate> GetCandidates()
{
using (var db = new ElectionsEntities())
{
var query = from candidate in db.Candidates
select candidate;
return(query.ToList());
}
}
public static Electorate GetElectorate(Electorate electorateTemplate)
{
using (var db = new ElectionsEntities())
{
var query = from b in db.Electorates
where b.pesel == electorateTemplate.pesel &&
(electorateTemplate.name == null || b.name == electorateTemplate.name) &&
(electorateTemplate.surname == null || b.surname == electorateTemplate.surname)
select b;
return(query.SingleOrDefault());
}
}
public static void RegisterLoginAttemp(string pesel, bool succesful, bool valid)
{
using (var db = new ElectionsEntities())
{
Loginattemp loginattemp = new Loginattemp()
{
date = DateTime.Now,
pesel = pesel,
valid = (valid == true ? (byte)1 : (byte)0),
succesful = (succesful == true ? (byte)1 : (byte)0),
};
db.Loginattemps.Add(loginattemp);
db.SaveChanges();
}
}
public static void RegisterAttempToVoteWitoutRights()
{
using (var db = new ElectionsEntities())
{
Vote vote = new Vote()
{
date = DateTime.Now,
idcandidate = null,
valid = 0,
withRights = 0,
};
db.Votes.Add(vote);
db.SaveChanges();
}
}
public static void UpdateElector(Electorate electorate)
{
using (var db = new ElectionsEntities())
{
var result = db.Electorates.SingleOrDefault(b => b.idelectorate == electorate.idelectorate);
if (result != null)
{
result.name = electorate.name;
result.surname = electorate.surname;
result.pesel = electorate.pesel;
result.voted = electorate.voted;
result.logged = electorate.logged;
db.SaveChanges();
}
}
}
public static Electorate AddNewElectorate(Electorate electorateTemplate)
{
using (var db = new ElectionsEntities())
{
Electorate check = new Electorate();
check.pesel = electorateTemplate.pesel;
if (GetElectorate(check) != null)
{
//there already is electorate with provided pesel
return(null);
}
db.Electorates.Add(electorateTemplate);
db.SaveChanges();
return(electorateTemplate);
}
}
public static void Vote(ref Electorate electorate, Candidate candidate)
{
using (var db = new ElectionsEntities())
{
Vote vote = new Vote()
{
date = DateTime.Now,
idcandidate = candidate?.idcandidates,
valid = candidate != null ? (byte)1 : (byte)0,
withRights = 1,
};
db.Votes.Add(vote);
electorate.voted = 1;
ElectorateFacade.UpdateElector(electorate);
db.SaveChanges();
}
}
