private void MAIN_Load(object sender, EventArgs e)
{
DataAccess.SystemFunction oVotingSchedule = new DataAccess.SystemFunction();
foreach (DataRow row in oVotingSchedule.GetVotingSchedule().Rows)
{
lblDateTime.Text = row["DATE_END"].ToString().Trim() + " / " + row["TIME_END"].ToString().Trim();
}
GetUser();
}
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)
{
}
}
void GetVotingSchedule()
{
oVotingSched = new DataAccess.SystemFunction();
foreach (DataRow row in oVotingSched.GetVotingSchedule().Rows)
{
dDateEnd = row["DATE_END"].ToString();
dDateStart = row["DATE_START"].ToString();
tTimeStart = row["TIME_START"].ToString();
tTimeEnd = row["TIME_END"].ToString();
sStatus = row["STATUS"].ToString().Trim();
}
if (sStatus != "CLOSED")
{
if (Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")) > Convert.ToDateTime(dDateEnd))
{
oVotingSched.UpdateScheduleStatus();
}
}
lblCurrentDate.Text = DateTime.Now.ToString("yyyy-MM-dd h:mm:ss tt");
GetScheduleStatus();
}
