public ActionResult DataSourceGetAll(DataManager dm)
        {
            SMCModels   obj   = new SMCModels();
            IEnumerable data  = obj.GetAll(null, null, null).ToList();
            int         count = obj.GetAll(null, null, null).ToList().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 SMC(string sdate, string edate, int?_emmergency)
        {
            bool?emergency = null;

            if (_emmergency == 1)
            {
                emergency = false;
            }
            else if (_emmergency == 2)
            {
                emergency = true;
            }
            SMCModels obj       = new SMCModels();
            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\SMC.rdlc";
            reportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("sMC", obj.GetAll(StartDate, EndDate, emergency).ToList()));

            ViewBag.ReportViewer = reportViewer;
            return(View());
        }