public JsonResult PaceAudit_print(string Game, string startDate, string endDate, string SortOrder)
{
ReportsModel reportModel = new ReportsModel();
string json = string.Empty;
List <ReportsModel> reportsList = new List <ReportsModel>();
try
{
ReportsBase reportsBase = new ReportsBase();
reportsBase.Game = Game;
reportsBase.StartDate = startDate;
reportsBase.EndDate = endDate;
reportsBase.SortOrder = SortOrder;
actionResult = reportsAction.PaceAudit_print(reportsBase);
if (actionResult.IsSuccess)
{
reportsList = CommonMethods.ConvertTo <ReportsModel>(actionResult.dtResult);
}
else
{
json = "fail";
}
reportModel.reportsList = reportsList;
}
catch (Exception ex)
{
json = "-1";
ErrorReporting.WebApplicationError(ex);
}
return(Json(reportsList, JsonRequestBehavior.AllowGet));
}
public JsonResult BannedPictures_print(string startDate, string endDate, string datacolumn)
{
ReportsModel reportModel = new ReportsModel();
string json = string.Empty;
List <ReportsModel> reportsList = new List <ReportsModel>();
try
{
ReportsBase reportsBase = new ReportsBase();
reportsBase.StartDate = startDate;
reportsBase.EndDate = endDate;
reportsBase.TypeOfBan = datacolumn;
ViewBag.datacolumn = datacolumn;
actionResult = reportsAction.Banned_Pictures(reportsBase);
if (actionResult.IsSuccess)
{
reportsList = CommonMethods.ConvertTo <ReportsModel>(actionResult.dtResult);
}
else
{
json = "fail";
}
reportModel.reportsList = reportsList;
}
catch (Exception ex)
{
json = "-1";
ErrorReporting.WebApplicationError(ex);
}
return(Json(reportsList, JsonRequestBehavior.AllowGet));
}
public DataTable Dispatch_print(ReportsBase reports)
{
dtContainer = new DataTable();
dsContainer = new DataSet();
try
{
MyParameter[] myParams =
{
new MyParameter("@StartDate", reports.StartDate),
new MyParameter("@EndDate", reports.EndDate),
new MyParameter("@StartTime", reports.StartTime),
new MyParameter("@EndTime", reports.EndTime),
new MyParameter("@SortOrder", reports.SortOrder)
};
Common.Set_Procedures("Dispatch_print");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}
public JsonResult LicenseExpiry_print(string startDate, string endDate, string sortValue)
{
ReportsModel reportModel = new ReportsModel();
string json = string.Empty;
List <EmployeeModel> employeeList = new List <EmployeeModel>();
try
{
ReportsBase reportsBase = new ReportsBase();
reportsBase.StartDate = startDate;
reportsBase.EndDate = endDate;
reportsBase.SortOrder = sortValue;
actionResult = reportsAction.LicenseExpiry_print(reportsBase);
if (actionResult.IsSuccess)
{
employeeList = CommonMethods.ConvertTo <EmployeeModel>(actionResult.dtResult);
}
else
{
json = "fail";
}
reportModel.EmployeeList = employeeList;
}
catch (Exception ex)
{
json = "-1";
ErrorReporting.WebApplicationError(ex);
}
return(Json(employeeList, JsonRequestBehavior.AllowGet));
}
public ActionResult PaceAudit_print(ReportsBase ReportBase)
{
actionResult = new ActionResult();
try
{
actionResult.dtResult = reportsDL.PaceAudits_print(ReportBase);
if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0)
{
actionResult.IsSuccess = true;
}
}
catch (Exception ex)
{
}
return(actionResult);
}
public ActionResult EmailLog_Print(ReportsBase reports)
{
actionResult = new ActionResult();
try
{
actionResult.dtResult = reportsDL.EmailLog_Print(reports);
if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0)
{
actionResult.IsSuccess = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(actionResult);
}
public ActionResult Banned_Pictures(ReportsBase reports)
{
actionResult = new ActionResult();
try
{
actionResult.dtResult = reportsDL.Banned_Pictures(reports);
if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0)
{
actionResult.IsSuccess = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(actionResult);
}
public DataTable PaceAudits_print(ReportsBase report)
{
dtContainer = new DataTable();
try
{
MyParameter[] myParams =
{
new MyParameter("@Game", report.Game),
new MyParameter("@StartDate", report.StartDate),
new MyParameter("@EndDate", report.EndDate),
new MyParameter("@SortBy", report.SortOrder)
};
Common.Set_Procedures("sp_GetPaceAuditReport");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}
public DataTable Banned_Pictures(ReportsBase reports)
{
dtContainer = new DataTable();
dsContainer = new DataSet();
try
{
MyParameter[] myParams =
{
new MyParameter("@StartDate", reports.StartDate),
new MyParameter("@EndDate", reports.EndDate),
new MyParameter("@BanName", reports.TypeOfBan)
};
Common.Set_Procedures("BannedPictures");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}
