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