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