예제 #1
0
        public ActionResult AjReport(string cboDoct, string startDate, string endDate, string orderBy, string order, string searchBy, string keyword)
        {
            DoctorOperationModels objViewsModels = null;

            try
            {
                orderBy = orderBy.Replace(" ", "") ?? Common.defaultOrderBy;
                order   = order ?? Common.defaultListOrder;

                var totalRecords = 0;
                var lstRecords   = objDoctorOperationRepository.Search(cboDoct, searchBy, keyword, startDate, endDate, orderBy, order, out totalRecords);

                objViewsModels = new DoctorOperationModels()
                {
                    lstRecords   = lstRecords,
                    order        = order,
                    orderBy      = orderBy,
                    totalRecords = totalRecords,
                    startDate    = startDate,
                    endDate      = endDate,
                };
            }
            catch (Exception ex)
            {
                log.Error(ex);
                ModelState.AddModelError("error", Translator.UnexpectedError);
            }

            return(View("Ajreport", "_LayoutBlank", objViewsModels));
        }
예제 #2
0
        public ActionResult ReportCsv(string cboDoct, string startDate, string endDate, string orderBy, string order, string searchBy, string keyword)
        {
            DoctorOperationModels objViewsModels = null;

            try
            {
                orderBy = orderBy.Replace(" ", "") ?? Common.defaultOrderBy;
                order   = order ?? Common.defaultListOrder;

                var totalRecords = 0;
                var lstRecords   = objDoctorOperationRepository.Search(cboDoct, searchBy, keyword, startDate, endDate, orderBy, order, out totalRecords);

                objViewsModels = new DoctorOperationModels()
                {
                    lstRecords   = lstRecords,
                    order        = order,
                    orderBy      = orderBy,
                    totalRecords = totalRecords,
                    startDate    = startDate,
                    endDate      = endDate,
                };
            }
            catch (Exception ex)
            {
                log.Error(ex);
                ModelState.AddModelError("error", Translator.UnexpectedError);
            }

            Response.ContentEncoding = System.Text.Encoding.UTF8;
            Response.AddHeader("content-disposition", "attachment;filename=doctor-report.xls");
            Response.AddHeader("Content-Type", "application/vnd.ms-excel");
            return(View("ReportCsv", "_LayoutCsv", objViewsModels));
        }
예제 #3
0
        public ActionResult Report()
        {
            DoctorOperationModels objViewsModels = null;

            try
            {
                string searchBy     = "";
                string keyword      = "";
                var    cboDoct      = "";
                var    orderBy      = Common.defaultOrderBy;
                var    order        = Common.defaultListOrder;
                var    objCurDate   = DateTime.Today;
                var    objPreDate   = objCurDate.AddDays(-1);
                string startDate    = Common.GetDatePickerDisplay(objPreDate);
                string endDate      = Common.GetDatePickerDisplay(objCurDate);
                var    totalRecords = 0;
                IEnumerable <Employee> doctorRecords = employeeRepository.Get();
                var lstRecords = objDoctorOperationRepository.Search(cboDoct, searchBy, keyword, startDate, endDate, orderBy, order, out totalRecords);

                objViewsModels = new DoctorOperationModels()
                {
                    lstRecords    = lstRecords,
                    doctorRecords = doctorRecords,
                    order         = order,
                    orderBy       = orderBy,
                    totalRecords  = totalRecords,
                    startDate     = startDate,
                    endDate       = endDate,
                };
            }
            catch (Exception ex)
            {
                log.Error(ex);
                ModelState.AddModelError("error", Translator.UnexpectedError);
            }
            return(View(objViewsModels));
        }