/*
* Function: GetMonthlyChartData
*
* Get total number of mugs borrowed for each month.
*
* Returns:
*
* model - total number of mugs borrowed for each month
*/
public static MonthlyDataModel GetMonthlyChartData()
{
SqlConnection dbconnection = new SqlConnection();
SqlCommand dbcommand = new SqlCommand();
SqlDataReader dbreader;
string connectionstring = ConfigurationManager.ConnectionStrings["MugShareDB"].ToString();
string queryString = "SELECT * FROM MonthlyStatistics WHERE pKey = 1";
MonthlyDataModel model = new MonthlyDataModel();
try
{
if (dbconnection.State == ConnectionState.Closed)
{
dbconnection.ConnectionString = connectionstring; dbconnection.Open();
}
dbcommand.Connection = dbconnection;
dbcommand.CommandTimeout = 600;
dbcommand.CommandText = queryString;
dbcommand.CommandType = CommandType.Text;
dbreader = dbcommand.ExecuteReader();
if (dbreader.HasRows)
{
dbreader.Read();
if (!string.IsNullOrEmpty(dbreader["January"].ToString()))
{
model.January = Convert.ToInt32(dbreader["January"]);
}
if (!string.IsNullOrEmpty(dbreader["February"].ToString()))
{
model.February = Convert.ToInt32(dbreader["February"]);
}
if (!string.IsNullOrEmpty(dbreader["March"].ToString()))
{
model.March = Convert.ToInt32(dbreader["March"]);
}
if (!string.IsNullOrEmpty(dbreader["April"].ToString()))
{
model.April = Convert.ToInt32(dbreader["April"]);
}
if (!string.IsNullOrEmpty(dbreader["May"].ToString()))
{
model.May = Convert.ToInt32(dbreader["May"]);
}
if (!string.IsNullOrEmpty(dbreader["June"].ToString()))
{
model.June = Convert.ToInt32(dbreader["June"]);
}
if (!string.IsNullOrEmpty(dbreader["July"].ToString()))
{
model.July = Convert.ToInt32(dbreader["July"]);
}
if (!string.IsNullOrEmpty(dbreader["August"].ToString()))
{
model.August = Convert.ToInt32(dbreader["August"]);
}
if (!string.IsNullOrEmpty(dbreader["September"].ToString()))
{
model.September = Convert.ToInt32(dbreader["September"]);
}
if (!string.IsNullOrEmpty(dbreader["October"].ToString()))
{
model.October = Convert.ToInt32(dbreader["October"]);
}
if (!string.IsNullOrEmpty(dbreader["November"].ToString()))
{
model.November = Convert.ToInt32(dbreader["November"]);
}
if (!string.IsNullOrEmpty(dbreader["December"].ToString()))
{
model.December = Convert.ToInt32(dbreader["December"]);
}
}
return(model);
}
catch (Exception e)
{
throw new Exception(@"Mug-Share Application GetMonthlyChartData() failed : ", e);
}
finally
{
if (dbconnection.State == ConnectionState.Open)
{
dbconnection.Close();
}
}
}
public JsonResult MonthlyChartData()
{
MonthlyDataModel model = mugreturn.GetMonthlyChartData();
return(ResultJson(model));
}