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