// GET: StudentSearch public ActionResult ReportWithOutPaging(string strStartDate, string strEndDate) { StudentSearchReportViewModel objEntity = new StudentSearchReportViewModel(); // Install-Package PagedList.Mvc if (!string.IsNullOrEmpty(strStartDate) && !string.IsNullOrEmpty(strEndDate)) { objEntity.StartDate = Convert.ToDateTime(strStartDate); objEntity.EndDate = Convert.ToDateTime(strEndDate); var objStudentRepository = new StudentSearchReportRepository(); objEntity.StudentViewModelList = new List <StudentSearchReportViewModel>(); objEntity.StudentViewModelList = objStudentRepository.Search(StudentFlags.SelectAllByReport.GetHashCode(), objEntity); if (objEntity.StudentViewModelList.Count == 0) { } } else { objEntity.StartDate = DateTime.Now; objEntity.EndDate = DateTime.Now; objEntity.StudentViewModelList = new List <StudentSearchReportViewModel>(); } return(View(objEntity)); }
public List <StudentSearchReportViewModel> Search(int flag, StudentSearchReportViewModel entity) { var objEntityList = new List <StudentSearchReportViewModel>(); try { Database objDB = base.GetDatabase(); // Create a suitable command type and add the required parameter. using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_STUDENT_VIEWMODEL_REPORT)) { objDB.AddInParameter(sprocCmd, COLUMN_NAME_FLAG, DbType.String, flag); objDB.AddInParameter(sprocCmd, COLUMN_NAME_STARTDATE, DbType.DateTime, entity.StartDate); objDB.AddInParameter(sprocCmd, COLUMN_NAME_ENDDATE, DbType.DateTime, entity.EndDate); using (IDataReader reader = objDB.ExecuteReader(sprocCmd)) { while (reader.Read()) { var objEntityViewModel = new StudentSearchReportViewModel(); objEntityViewModel.Id = reader.GetColumnValue <int>(COLUMN_NAME_ID); objEntityViewModel.Name = reader.GetColumnValue <string>(COLUMN_NAME_NAME); objEntityViewModel.Age = reader.GetColumnValue <int>(COLUMN_NAME_AGE); objEntityViewModel.DOB = reader.GetColumnValue <DateTime>(COLUMN_NAME_DOB); objEntityViewModel.Gender = reader.GetColumnValue <GenderEnum>(COLUMN_NAME_GENDER); if (objEntityViewModel != null) { objEntityList.Add(objEntityViewModel); } } } } } catch (Exception ex) { throw ex; } finally { } return(objEntityList); }