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();
}
