void LoadRecordDetails()
{
try
{
oVotingSchedule = new DataAccess.SystemFunction();
oMVotingSchedule = new Model.VotingSchedule();
dgDetails.Rows.Clear();
if (!oVotingSchedule.IsScheduleExists())
{
oMVotingSchedule.DATE_END = DateTime.Now.ToString("yyyy-MM-dd");
oMVotingSchedule.TIME_END = DateTime.Now.ToString("h:mm:ss tt");
oMVotingSchedule.DATE_START = DateTime.Now.ToString("yyyy-MM-dd");
oMVotingSchedule.TIME_END = DateTime.Now.ToString("h:mm:ss tt");
oMVotingSchedule.STATUS = "CLOSED";
oVotingSchedule.InsertSchedule(oMVotingSchedule);
}
foreach (DataRow row in oVotingSchedule.GetVotingSchedule().Rows)
{
dgDetails.Rows.Add(row["DATE_START"].ToString().Trim(), row["TIME_START"].ToString().Trim(), row["DATE_END"].ToString().Trim(), row["TIME_END"].ToString().Trim(), row["STATUS"].ToString().Trim());
sScheduleStatus = row["STATUS"].ToString().Trim();
}
if (CheckDateTime())
{
oMVotingSchedule = new Model.VotingSchedule();
oMVotingSchedule.STATUS = "CLOSED";
oVotingSchedule.UpdateSchedule(oMVotingSchedule);
}
if (sScheduleStatus != "CLOSED")
{
lblStatus.ForeColor = Color.Lime;
lblStatus.Text = "OPEN";
}
else
{
lblStatus.ForeColor = Color.Red;
lblStatus.Text = "CLOSED";
}
}
catch (Exception ex)
{
}
}
