// GET: DBDrop public ActionResult Create() { var objEntityMap = new DBDropViewModel(); 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); }