void PopulateLastBatchInfo() { dbProcedures db = new dbProcedures(); System.Data.SqlClient.SqlDataReader reader = db.GetLastBatchHistory(); if (reader.Read()) { if ((!object.ReferenceEquals(reader[0], System.DBNull.Value))) { string strServiceStatus = new System.ServiceProcess.ServiceController("EOBProcessing").Status.ToString(); // Populate content if (strServiceStatus.ToUpper() == "STOPPED") { lblWindowsServiceStatus.ForeColor = System.Drawing.Color.Red; } lblWindowsServiceStatus.Text = strServiceStatus; string strMembersProcessed = reader[2].ToString(); string strNewEOBDownloads = reader[3].ToString(); if (strMembersProcessed.Length == 0) { lblLastRunDuration.Text = "Currently running..."; lblMembersProcessed.Text = "Currently running..."; lblNewEOBDownloads.Text = "Currently running..."; } else { lblMembersProcessed.Text = strMembersProcessed; lblNewEOBDownloads.Text = strNewEOBDownloads; } linkEOBRepository.Text = System.Configuration.ConfigurationManager.AppSettings.Get("EOBRepository"); linkEOBRepository.PostBackUrl = System.Configuration.ConfigurationManager.AppSettings.Get("EOBRepository"); DateTime startTime; DateTime endTime; startTime = Convert.ToDateTime(reader[0].ToString()); lblLastRunDate.Text = startTime.DayOfWeek.ToString() + ", " + startTime.ToString(); try { endTime = Convert.ToDateTime(reader[1].ToString()); lblLastRunDuration.Text = endTime.Subtract(startTime).Hours.ToString() + " hrs, " + endTime.Subtract(startTime).Minutes.ToString() + " mins"; } catch (Exception e) { } } } reader.Close(); db.Close(); }