public List<StudentSearchViewModel> Search(int flag, StudentSearchViewModel entity, int pageIndex, int pageSize, out int totalCount)
{
totalCount = 0;
var objEntityList = new List<StudentSearchViewModel>();
try
{
Database objDB = base.GetDatabase();
// Create a suitable command type and add the required parameter.
using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_STUDENT_VIEWMODEL_SEARCH))
{
objDB.AddInParameter(sprocCmd, COLUMN_NAME_KEYWORD, DbType.String, entity.Keyword);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_PAGEINDEX, DbType.Int32, pageIndex);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_PAGESIZE, DbType.Int32, pageSize);
objDB.AddOutParameter(sprocCmd, COLUMN_NAME_TOTALCOUNT, DbType.Int32, totalCount);
using (IDataReader reader = objDB.ExecuteReader(sprocCmd))
{
while (reader.Read())
{
var objEntityViewModel = new StudentSearchViewModel();
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);
}
}
}
totalCount = Convert.ToInt32(objDB.GetParameterValue(sprocCmd, COLUMN_NAME_TOTALCOUNT));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return objEntityList;
}
public ActionResult SearchWithOutPaging(string Keyword)
{
// Install-Package PagedList.Mvc
var objEntity = new StudentSearchViewModel()
{
Keyword = Keyword
};
//
var objStudentRepository = new StudentSearchRepository();
objEntity.StudentViewModelList = new List<StudentSearchViewModel>();
objEntity.StudentViewModelList = objStudentRepository.Search(StudentFlags.SelectAllByKeyword.GetHashCode(), objEntity);
if (objEntity.StudentViewModelList.Count == 0)
{
//flash message
}
return View(objEntity);
}
public ActionResult Search(int? page, string Keyword)
{
// Install-Package PagedList.Mvc
var objEntity = new StudentSearchViewModel()
{
Name = Keyword
};
var pageIndex = (page ?? 1) - 1; //MembershipProvider expects a 0 for the first page
var pageSize = 2;
int totalCount; // will be set by call to GetAllUsers due to _out_ paramter :-|
//
var objStudentRepository = new StudentSearchRepository();
objEntity.StudentViewModelList = new List<StudentSearchViewModel>();
objEntity.StudentViewModelList = objStudentRepository.Search(StudentFlags.SelectAll.GetHashCode(), objEntity, pageIndex, pageSize, out totalCount);
if (objEntity.StudentViewModelList.Count == 0)
{
}
return View(objEntity);
}
public List<StudentSearchViewModel> Search(int flag, StudentSearchViewModel objEntity)
{
var objEntityList = new List<StudentSearchViewModel>();
try
{
Database objDB = base.GetDatabase();
// Create a suitable command type and add the required parameter.
using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_STUDENT_VIEWMODEL_SEARCHWITHOUTPAGING))
{
objDB.AddInParameter(sprocCmd, COLUMN_NAME_FLAG, DbType.String, flag);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_KEYWORD, DbType.String, objEntity.Keyword);
using (IDataReader reader = objDB.ExecuteReader(sprocCmd))
{
while (reader.Read())
{
var objEntityViewModel = new StudentSearchViewModel();
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.Gender = reader.GetColumnValue<GenderEnum>(COLUMN_NAME_GENDER);
if (objEntityViewModel != null)
{
objEntityList.Add(objEntityViewModel);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return objEntityList;
}