public ActionResult TBSummary(string sdate, string edate, int?_emmergency)
{
bool?emergency = null;
if (_emmergency == 1)
{
emergency = false;
}
else if (_emmergency == 2)
{
emergency = true;
}
TBModels obj = new TBModels();
DateTime?StartDate = DateTime.ParseExact(sdate, "dd/MM/yyyy", null);
DateTime?EndDate = DateTime.ParseExact(edate, "dd/MM/yyyy", null);
// obj.GetAll(StartDate, EndDate);
//obj.EndDate = EndDate;
Microsoft.Reporting.WebForms.ReportViewer reportViewer = new Microsoft.Reporting.WebForms.ReportViewer();
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.SizeToReportContent = true;
reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Views\Queries\TB_Summary.rdlc";
reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("tBSummary", obj.GetTBSummary(StartDate, EndDate, emergency).ToList()));
ViewBag.ReportViewer = reportViewer;
return(View());
}
//GetOrder_Add
public ActionResult GetOrderCustom(Syncfusion.JavaScript.DataManager dm, string param_on)
{
//string a = start_date.ToString();
//string b = end_date.ToString();
TBModels obj = new TBModels();
//IEnumerable DataSource = obj.getOrders(18, DateTime.Parse("2017-04-01 00:00:00.000"), DateTime.Parse("2017-05-31 00:00:00.000"));
context.Configuration.ProxyCreationEnabled = false;
IEnumerable data = obj.GetOrderCustom(param_on);
int count = obj.GetOrderCustom(param_on).Count();
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
var filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
var searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetOrderTestSummary(Syncfusion.JavaScript.DataManager dm, string param_on)
{
TBModels obj = new TBModels();
IEnumerable data = obj.GetOrderTBSummary(param_on);
int count = obj.GetOrderTBSummary(param_on).Count();
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
var filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
var searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet));
}
