public List <ANSWER> GetAnswersForParty(int partyId)
{
using (ElectionSqliteContext ctx = new ElectionSqliteContext())
{
return(ctx.ANSWERs.Where(d => d.PARTY == partyId).ToList());
}
}
public void AddParty(PARTY newParty)
{
using (var ctx = new ElectionSqliteContext())
{
ctx.PARTies.Add(newParty);
ctx.SaveChanges();
}
}
public List <DbParty> GetPartiesFilter(int?id, string nameShort, string nameLong)
{
using (var ctx = new ElectionSqliteContext())
{
return(ctx.PARTies.Where(d => (d.ID == id || id == null) &&
(d.NAME_SHORT == nameShort ||
string.IsNullOrEmpty(nameShort)) &&
(d.NAME_LONG == nameLong ||
string.IsNullOrEmpty(nameLong))).ToList());
}
}
public ICollection <DbParty> GetParties()
{
ICollection <DbParty> retList = new Collection <DbParty>();
using (var ctx = new ElectionSqliteContext())
{
// since the context gets disposed, before the navigation attributes are queried,
// all elements have to be added manually at this point, hence this stupid function..
retList = getParties(ctx.PARTies.ToList());
}
return(retList);
}
