public JsonResult GetLocationData(string type, string startDate, string endDate)
{
string json = string.Empty;
ReportsStatisticsModel reportsModel = new ReportsStatisticsModel();
List <ReportsStatisticsModel> reportsList = new List <ReportsStatisticsModel>();
ReportsStatisticsBase reportsBase = new ReportsStatisticsBase();
reportsBase.Type = type;
reportsBase.StartDate = startDate;
reportsBase.EndDate = endDate;
actionResult = reportsAction.LocationCount_Graph(reportsBase);
if (actionResult.IsSuccess)
{
json += "{\"LocationCount\":[ ";
foreach (DataRow dr in actionResult.dtResult.Rows)
{
json += "{\"results\":\"" + dr["results"].ToString() + "\",\"ShortLocation\":\"" + dr["Location"].ToString() + "\"},";
}
json = json.TrimEnd(',') + "]}";
}
return(Json(json, JsonRequestBehavior.AllowGet));
}
public JsonResult EmployeeVariance_print(string type, string startDate, string endDate)
{
ReportsStatisticsModel reportsModel = new ReportsStatisticsModel();
string json = string.Empty;
List <ReportsStatisticsModel> reportsList = new List <ReportsStatisticsModel>();
try
{
ReportsStatisticsBase reportsBase = new ReportsStatisticsBase();
reportsBase.Type = type;
reportsBase.StartDate = startDate;
reportsBase.EndDate = endDate;
actionResult = reportsAction.EmployeeVariance_print(reportsBase);
if (actionResult.IsSuccess)
{
reportsList = CommonMethods.ConvertTo <ReportsStatisticsModel>(actionResult.dtResult);
}
else
{
json = "fail";
}
reportsModel.reportsStatisticsList = reportsList;
}
catch (Exception ex)
{
json = "-1";
ErrorReporting.WebApplicationError(ex);
}
return(Json(reportsList, JsonRequestBehavior.AllowGet));
}
