// 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;
}
