public CabRequestCurrData GetCurrCabRequests(int?patientId)
{
List <CabRequestDataItem> currMonthData = new List <CabRequestDataItem>();
List <CabRequestDataItem> currWeekData = null;
DataSet dataset = new DataSet();
DataTable dtCabRequests;
DateTime monthStartDate, monthEndDate, weekStartDate, weekEndDate, currDate;
CabRequestCurrData response = null;
currDate = DateTime.Now;
weekStartDate = currDate.AddDays(-(int)currDate.DayOfWeek).Date;
weekEndDate = weekStartDate.AddDays(7).AddSeconds(-1);
monthStartDate = new DateTime(currDate.Year, currDate.Month, 1);
monthEndDate = monthStartDate.AddMonths(1).AddDays(-1);
monthEndDate = (currDate.Day <= monthEndDate.Day) ? currDate : monthEndDate;
weekEndDate = (currDate.Day <= weekEndDate.Day) ? currDate : weekEndDate;
using (SqlConnection conn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand("dashboard_get_cab_requests", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@fromDate", SqlDbType.DateTime).Value = monthStartDate;
cmd.Parameters.Add("@toDate", SqlDbType.DateTime).Value = monthEndDate;
if (patientId != null)
{
cmd.Parameters.Add("@patientId", SqlDbType.NVarChar).Value = patientId.Value;
}
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
cmd.Connection = conn;
adapter.Fill(dataset);
dtCabRequests = dataset.Tables[0];
foreach (DataRow row in dtCabRequests.Rows)
{
currMonthData.Add(new CabRequestDataItem
{
TotalRequests = Convert.ToInt32(row["TotalRequests"]),
Date = Convert.ToDateTime(row["CreatedOn"])
});
}
}
if (currMonthData != null)
{
currWeekData = currMonthData.FindAll(a => a.Date >= weekStartDate && a.Date <= weekEndDate);
}
response = new CabRequestCurrData();
response.CurrentWeekData = new CabRequestData {
Data = currWeekData, StartDate = weekStartDate, EndDate = weekEndDate
};
response.CurrentMonthData = new CabRequestData {
Data = currMonthData, StartDate = monthStartDate, EndDate = monthEndDate
};
return(response);
}
public JsonResult CabRequests(int?patientId)
{
CabRequestCurrData cabRequests = null;
try
{
cabRequests = clinicService.GetCurrCabRequests(patientId);
}
catch (Exception ex)
{
//TODO: Handle exception
}
return(Json(cabRequests, JsonRequestBehavior.AllowGet));
}
