/// <summary>
/// Created By: Bhushan Dod
/// Created Date: Oct-13-2017
/// List of Passenger tracking route according to service type in jqgrid list.
/// </summary>
/// <param name="UserId"></param>
/// <param name="pageIndex"></param>
/// <param name="numberOfRows"></param>
/// <param name="sortColumnName"></param>
/// <param name="sortOrderBy"></param>
/// <param name="locationId"></param>
/// <param name="textSearch"></param>
/// <param name="statusType"></param>
/// <returns></returns>
public JQGridModel <eFleetPassengerTrackingCountModel> GetListeFleetPassengerCountwithJQGridDetails(int?pageIndex, int?numberOfRows, string sortColumnName, string sortOrderBy, string textSearch, long?statusType)
{
try
{
workorderEMSEntities db = new workorderEMSEntities();
var objeFleetPassengerTrackingCountModel = new JQGridModel <eFleetPassengerTrackingCountModel>();
int pageindex = Convert.ToInt32(pageIndex) - 1;
int pageSize = Convert.ToInt32(numberOfRows);
var objeFleetRouteCount = new eFleetPassengerTrackingCountModel();
var Results = db.eFleetPassengerTrackingCounts.Join(db.eFleetPassengerTrackingRoutes, ep => ep.RouteID, ec => ec.RouteID, (ep, ec) => new { ep, ec }).Where(a => (a.ep.IsDeleted == false && a.ec.IsDeleted == false) &&
(((statusType == 0) ? null : statusType) == null || a.ec.ServiceType == statusType)).Select(a => new eFleetPassengerTrackingCountModel()
{
DropPoint = a.ec.DropPoint,
PickUpPoint = a.ec.PickUpPoint,
ServiceTypeName = a.ec.GlobalCode.CodeName,
PassengerCountID = a.ep.PassengerCountID,
RouteName = a.ec.RouteName,
CreatedDate = a.ep.CreatedDate,
EmployeeName = a.ep.EmployeeName,
PassengerCount = a.ep.PassengerCount,
VehicleNumber = a.ep.VehicleNumber,
ServiceType = a.ep.ServiceType,
}).OrderByDescending(x => x.CreatedDate).ToList();
int totRecords = Results.Count();
var totalPages = (int)Math.Ceiling((float)totRecords / (float)numberOfRows);
objeFleetPassengerTrackingCountModel.pageindex = pageindex;
objeFleetPassengerTrackingCountModel.total = totalPages;
objeFleetPassengerTrackingCountModel.records = totRecords;
objeFleetPassengerTrackingCountModel.rows = Results.ToList();
return(objeFleetPassengerTrackingCountModel);
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public JQGridModel<eFleetPassengerTrackingCountModel> GetListeFleetPassengerCountwithJQGridDetails(int? pageIndex, int? numberOfRows, string sortColumnName, string sortOrderBy, string textSearch, long? statusType)", "Exception While fetching ", statusType);
throw;
}
}
public JsonResult GetPassengerCountList(string _search, int?rows = 20, int?page = 1, int?TotalRecords = 10, string sord = null, string txtSearch = null, string sidx = null, string statusType = null)
{
var objeFleetPassengerTrackingCountModel = new eFleetPassengerTrackingCountModel();
JQGridResults result = new JQGridResults();
List <JQGridRow> rowss = new List <JQGridRow>();
sord = string.IsNullOrEmpty(sord) ? "desc" : sord;
sidx = string.IsNullOrEmpty(sidx) ? "StartDate" : sidx;
txtSearch = string.IsNullOrEmpty(txtSearch) ? "" : txtSearch; //UserType = Convert.ToInt64(Helper.UserType.ITAdministrator);
try
{
var eFleetPTCountList = _IPassengerTracking.GetListeFleetPassengerCountwithJQGridDetails(rows, TotalRecords, sidx, sord, txtSearch, Convert.ToInt64(statusType));
foreach (var eFleetPT in eFleetPTCountList.rows)
{
JQGridRow row = new JQGridRow();
row.id = Cryptography.GetEncryptedData(Convert.ToString(eFleetPT.PassengerCountID), true);
row.cell = new string[8];
row.cell[0] = eFleetPT.RouteName;
row.cell[1] = eFleetPT.ServiceTypeName;
row.cell[2] = eFleetPT.VehicleNumber;
row.cell[3] = eFleetPT.PickUpPoint; //ToString("dd/MM/yyyy");
row.cell[4] = eFleetPT.DropPoint;
row.cell[5] = eFleetPT.PassengerCount.ToString();
row.cell[6] = eFleetPT.EmployeeName;
row.cell[7] = eFleetPT.CreatedDate.ToString("MM'/'dd'/'yyyy hh:mm tt");
rowss.Add(row);
}
result.rows = rowss.ToArray();
result.page = Convert.ToInt32(page);
result.total = (int)Math.Ceiling((decimal)Convert.ToInt32(TotalRecords.Value) / rows.Value);
result.records = Convert.ToInt32(TotalRecords.Value);
}
catch (Exception ex)
{ return(Json(ex.Message, JsonRequestBehavior.AllowGet)); }
return(Json(result, JsonRequestBehavior.AllowGet));
}
