public static OfficeKeyInfo GetPreviousOfficeKeyInfoByRunningMateKey(
string runningMateKey, int commandTimeout = -1)
{
var cmdText =
"SELECT ElectionsPoliticians.ElectionKey,ElectionsPoliticians.OfficeKey" +
" FROM ElectionsPoliticians,Elections" +
" WHERE ElectionsPoliticians.RunningMateKey=@RunningMateKey" +
" AND ElectionsPoliticians.ElectionKey = Elections.ElectionKey" +
" AND Elections.ElectionDate<@Today" +
" ORDER BY Elections.ElectionDate DESC";
cmdText = VoteDb.InjectSqlLimit(cmdText, 1);
var cmd = VoteDb.GetCommand(cmdText, commandTimeout);
VoteDb.AddCommandParameter(cmd, "RunningMateKey", runningMateKey);
VoteDb.AddCommandParameter(cmd, "Today", DateTime.Today);
var table = FillTable(cmd, ElectionsPoliticiansTable.ColumnSet.OfficeKey);
if (table.Count == 0)
{
return(OfficeKeyInfo.Empty);
}
return(new OfficeKeyInfo
{
ElectionKey = table[0].ElectionKey,
OfficeKey = table[0].OfficeKey
});
}
public static OfficeKeyInfo GetFutureOfficeKeyInfoByRunningMateKey(
string runningMateKey, bool isViewable, int commandTimeout = -1)
{
var cmdText =
"SELECT ElectionsPoliticians.ElectionKey,ElectionsPoliticians.OfficeKey" +
" FROM ElectionsPoliticians,Elections" +
" WHERE ElectionsPoliticians.RunningMateKey=@RunningMateKey" +
" AND ElectionsPoliticians.ElectionKey = Elections.ElectionKey" +
" AND Elections.ElectionDate>=@Today" +
" AND Elections.IsViewable=@IsViewable" +
" ORDER BY Elections.ElectionDate";
cmdText = VoteDb.InjectSqlLimit(cmdText, 1);
var cmd = VoteDb.GetCommand(cmdText, commandTimeout);
VoteDb.AddCommandParameter(cmd, "RunningMateKey", runningMateKey);
VoteDb.AddCommandParameter(cmd, "Today",
DateTime.Today.AddDays(-DaysAfterElectionToShowAsUpcoming));
VoteDb.AddCommandParameter(cmd, "IsViewable", isViewable);
var table = FillTable(cmd, ElectionsPoliticiansTable.ColumnSet.OfficeKey);
if (table.Count == 0)
{
return(OfficeKeyInfo.Empty);
}
return(new OfficeKeyInfo
{
ElectionKey = table[0].ElectionKey,
OfficeKey = table[0].OfficeKey
});
}
public static int GetNextOrderOnBallot(string electionKey)
{
var cmdText =
"SELECT OrderOnBallot FROM Referendums WHERE ElectionKey=@ElectionKey" +
" ORDER BY OrderOnBallot DESC";
cmdText = VoteDb.InjectSqlLimit(cmdText, 1);
var cmd = VoteDb.GetCommand(cmdText);
VoteDb.AddCommandParameter(cmd, "ElectionKey", electionKey);
var result = VoteDb.ExecuteScalar(cmd);
return(result == null ? 10 : Convert.ToInt32(result) + 10);
}
public static string GetIncumbentOfficeKeyByRunningMateKey(
string runningMateKey, int commandTimeout = -1)
{
var cmdText = "SELECT OfficesOfficials.OfficeKey" +
" FROM OfficesOfficials,Offices" +
" WHERE OfficesOfficials.RunningMateKey=@RunningMateKey" +
" AND OfficesOfficials.OfficeKey = Offices.OfficeKey" +
" ORDER BY OfficesOfficials.DataLastUpdated DESC";
cmdText = VoteDb.InjectSqlLimit(cmdText, 1);
var cmd = VoteDb.GetCommand(cmdText, commandTimeout);
VoteDb.AddCommandParameter(cmd, "RunningMateKey", runningMateKey);
var table = FillTable(cmd, OfficesOfficialsTable.ColumnSet.OfficeKey);
return(table.Count == 0 ? null : table[0].OfficeKey);
}
public static string GetLatestViewableElectionKeyStateByOfficeKey(
string officeKey, string defaultValue = null)
{
var cmdText = "SELECT ElectionsOffices.ElectionKeyState" +
" FROM Elections,ElectionsOffices" +
" WHERE ElectionsOffices.OfficeKey=@OfficeKey" +
" AND Elections.IsViewable='1'" +
" ORDER BY ElectionsOffices.ElectionKeyState DESC";
cmdText = VoteDb.InjectSqlLimit(cmdText, 1);
var cmd = VoteDb.GetCommand(cmdText, -1);
VoteDb.AddCommandParameter(cmd, "OfficeKey", officeKey);
var result = VoteDb.ExecuteScalar(cmd);
if ((result == null) || (result == DBNull.Value))
{
return(defaultValue);
}
return(result as string);
}