public FileStreamResult PrintReport(int RptId) { DataTable Reportsdt = SQLFUNC.GetIncidentReport(RptId); ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/ProjectReports"), "EquipmentReport.rpt")); rd.SetDataSource(Reportsdt); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "EquipmentReport.pdf")); //PrintEqReport(RptId); //DataSet dtReport = SQLFUNC.GetIncidentReport(RptId); //ReportDocument rd = new ReportDocument(); //rd.Load(Path.Combine(Server.MapPath("~/ProjectReports"), "IncidentReport.rpt")); //rd.SetDataSource(dtReport.Tables["Complaints"]); //Response.Buffer = false; //Response.ClearContent(); //Response.ClearHeaders(); //Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); //stream.Seek(0, SeekOrigin.Begin); //return File(stream, "application/pdf", "IncidentReport.pdf"); }
public JsonResult GetIncident(int ComplaintId) { return(new JsonResult() { Data = SQLFUNC.GetComplaints(ComplaintId), MaxJsonLength = 2147483647 }); }
public JsonResult GetGridData(int tableId) { List <ViewModel_DropDownGrid> dropDownGrid = null; string tableName = GetGridName(tableId); dropDownGrid = SQLFUNC.GetTableValues(tableName).Select(x => new ViewModel_DropDownGrid() { TableId = x.TableId, Description = x.Description, Active = x.Active }).ToList(); return(Json(dropDownGrid)); }
public JsonResult NewComplaint(Complaint cmpt) { if (cmpt.Id == 0) { SQLFUNC.InsertNewComplaint(cmpt); } else { SQLFUNC.UpdateComplaint(cmpt); } return(Json(true)); }
public JsonResult UpdateGridData(int tableId, List <ViewModel_DropDownGrid> gridData) { string tableName = GetGridName(tableId); foreach (ViewModel_DropDownGrid viewModel in gridData) { if (viewModel.TableId == 0) { SQLFUNC.InsertTableValues(tableName, viewModel); } else { SQLFUNC.UpdateTableValues(tableName, viewModel); } } return(Json(true)); }
//[Authorize] public ActionResult Index() { dynamic dropdowndata = new ExpandoObject(); dropdowndata.Gender = SQLFUNC.GetTableValues("INCIDENT_Gender").Select(x => new ViewModel_DropDownGrid() { TableId = x.TableId, Description = x.Description, Active = x.Active }).ToList(); dropdowndata.Disposition = SQLFUNC.GetTableValues("INCIDENT_Disposition").Select(x => new ViewModel_DropDownGrid() { TableId = x.TableId, Description = x.Description, Active = x.Active }).ToList(); dropdowndata.IncidentType = SQLFUNC.GetTableValues("INCIDENT_TYPE").Select(x => new ViewModel_DropDownGrid() { TableId = x.TableId, Description = x.Description, Active = x.Active }).ToList(); dropdowndata.Location = SQLFUNC.GetTableValues("INCIDENT_Location").Select(x => new ViewModel_DropDownGrid() { TableId = x.TableId, Description = x.Description, Active = x.Active }).ToList(); dropdowndata.POI_Type = SQLFUNC.GetTableValues("INCIDENT_POI_TYPE").Select(x => new ViewModel_DropDownGrid() { TableId = x.TableId, Description = x.Description, Active = x.Active }).ToList(); dropdowndata.Report_Written_By = SQLFUNC.GetTableValues("INCIDENT_Report_Written_By").Select(x => new ViewModel_DropDownGrid() { TableId = x.TableId, Description = x.Description, Active = x.Active }).ToList(); dropdowndata.Report_Reviewed_By = SQLFUNC.GetTableValues("INCIDENT_Report_Reviewed_By").Select(x => new ViewModel_DropDownGrid() { TableId = x.TableId, Description = x.Description, Active = x.Active }).ToList(); dropdowndata.EquipmentType = SQLFUNC.GetTableValues("INCIDENT_Equipment_Type").Select(x => new ViewModel_DropDownGrid() { TableId = x.TableId, Description = x.Description, Active = x.Active }).ToList(); dropdowndata.EquipmentStatus = SQLFUNC.GetTableValues("INCIDENT_Equipment_Status").Select(x => new ViewModel_DropDownGrid() { TableId = x.TableId, Description = x.Description, Active = x.Active }).ToList(); dropdowndata.POIType = SQLFUNC.GetTableValues("INCIDENT_POI_Type").Select(x => new ViewModel_DropDownGrid() { TableId = x.TableId, Description = x.Description, Active = x.Active }).ToList(); return(View(dropdowndata)); }
public JsonResult UpdateGridData(int tableId, List <ViewModel_DropDownGrid> gridData) { string tableName = GetGridName(tableId); foreach (ViewModel_DropDownGrid viewModel in gridData) { if (viewModel.TableId == 0) { Response.Write("<script>alert('add')</script>"); SQLFUNC.InsertTableValues(tableName, viewModel); // SqlFunctions.InsertTableValues(tableName, viewModel); } else { Response.Write("<script>alert('upd')</script>"); SQLFUNC.UpdateTableValues(tableName, viewModel); } } return(Json(true)); }
public JsonResult GetMaingridIncident() { return(Json(SQLFUNC.GetMaingridComplaints())); }