public ActionResult Create(DBDropViewModel objEntityMap)
{
var objStudentsModelList = new List<SelectListItem>();
var objStudentRepository = new DBDroupRepository();
var objStudentsModelEntity = new List<DBDropViewModel>();
objStudentsModelList.Add(new SelectListItem { Text = "Select", Value = "" });
objStudentsModelEntity = objStudentRepository.FillDBDrop(StudentFlags.DropStudent.GetHashCode(), new DBDropViewModel());
foreach (var item in objStudentsModelEntity)
{
objStudentsModelList.Add(new SelectListItem { Text = item.Name, Value = Convert.ToString(item.Id) });
}
objEntityMap.StudentsList = new SelectList(objStudentsModelList, "Value", "Text");
return View(objEntityMap);
}
public List<DBDropViewModel> FillDBDrop(int Flag, DBDropViewModel objEntity)
{
var objEntityList = new List<DBDropViewModel>();
try
{
Database objDB = base.GetDatabase();
// Create a suitable command type and add the required parameter.
using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_STUDENT_VIEWMODEL_SELECT))
{
objDB.AddInParameter(sprocCmd, COLUMN_NAME_FLAG, DbType.Int32, Flag);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_ID, DbType.Int32, objEntity.Id);
using (IDataReader reader = objDB.ExecuteReader(sprocCmd))
{
while (reader.Read())
{
var objEntityViewModel = new DBDropViewModel();
objEntityViewModel.Id = reader.GetColumnValue<int>(COLUMN_NAME_ID);
objEntityViewModel.Name = reader.GetColumnValue<string>(COLUMN_NAME_NAME);
if (objEntityViewModel != null)
{
objEntityList.Add(objEntityViewModel);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return objEntityList;
}
