// GET: /BusMonitor/
public ActionResult Dashboard()
{
BusMonitorAnalysis objBusMonitor = new BusMonitorAnalysis();
BusMonitorAnalysisList objList = new BusMonitorAnalysisList();
try
{
objBusMonitor.AgencyId = new Guid(Session["AgencyId"].ToString());
objBusMonitor.UserId = new Guid(Session["UserID"].ToString());
objList = new BusMonitorData().GetBusMonitorData(objBusMonitor);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(View(objList));
}
public BusMonitorAnalysisList GetBusMonitorData(BusMonitorAnalysis busmonitor)
{
List <BusMonitorAnalysis> busmonitorList = new List <BusMonitorAnalysis>();
BusMonitorAnalysisList getbusmonitorList = new BusMonitorAnalysisList();
BusMonitorAnalysis busmonitorData = null;
BusMonitorAnalysisTotal objTotal = new BusMonitorAnalysisTotal();
try
{
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@AgencyId", busmonitor.AgencyId));
command.Parameters.Add(new SqlParameter("@UserId", busmonitor.UserId));
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "USP_GetBusMonitor";
DataAdapter = new SqlDataAdapter(command);
_dataset = new DataSet();
DataAdapter.Fill(_dataset);
if (_dataset.Tables[0] != null)
{
if (_dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in _dataset.Tables[0].Rows)
{
busmonitorData = new BusMonitorAnalysis();
busmonitorData.RouteName = dr["RouteName"].ToString();
busmonitorData.CenterId = Convert.ToInt64(dr["CenterId"]);
// busmonitorData.Riders = Convert.ToInt32(dr["RidersCount"]);
busmonitorData.PickUp = Convert.ToInt32(dr["PickUpCount"]);
busmonitorData.Drop = Convert.ToInt32(dr["DropCount"]);
busmonitorData.RouteType = Convert.ToInt32(dr["RouteType"]);
busmonitorList.Add(busmonitorData);
}
}
if (busmonitorList.Count() > 0)
{
// objTotal.RidersTotal = busmonitorList.Sum(x => x.Riders);
objTotal.PickUpTotal = busmonitorList.Sum(x => x.PickUp);
objTotal.DropOffTotal = busmonitorList.Sum(x => x.Drop);
}
else
{
// objTotal.RidersTotal = 0;
objTotal.PickUpTotal = 0;
objTotal.DropOffTotal = 0;
}
getbusmonitorList.ListBusMonitor = busmonitorList;
getbusmonitorList.AnalysisTotal = objTotal;
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
DataAdapter.Dispose();
command.Dispose();
}
return(getbusmonitorList);
}