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