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) { } }