public ActionResult Create(OptGroupViewModel objEntity)
{
var objProjectEntity = new List<OptGroupViewModel>();
var objProjectList = new List<SelectListItem>();
objProjectList.Add(new SelectListItem { Text = "Select", Value = "", });
OptGroupRepository objStateRepository = new OptGroupRepository();
objProjectEntity = objStateRepository.OptGroupSelect(StudentFlags.OptDroupStudent.GetHashCode());
foreach (var item in objProjectEntity)
{
objProjectList.Add(new SelectListItem { Text = item.StateName, Value = Convert.ToString(item.StateId), Group = new SelectListGroup { Name = item.CountryName } });
}
objEntity.SelectCountryList = new SelectList(objProjectEntity, "StateId", "StateName", "CountryName", 1); //new SelectList(objTaskList);
objEntity.StateList = objProjectEntity;
return View(objEntity);
}
public List<OptGroupViewModel> OptGroupSelect(int flag)
{
var objEntityList = new List<OptGroupViewModel>();
try
{
Database objDB = base.GetDatabase();
// Create a suitable command type and add the required parameter.
using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SP_StateOptionSelectViewModelSelect))
{
objDB.AddInParameter(sprocCmd, PARAM_Flag, DbType.Int32, flag);
using (IDataReader reader = objDB.ExecuteReader(sprocCmd))
{
while (reader.Read())
{
var objEntityViewModel = new OptGroupViewModel();
objEntityViewModel.CountryId = reader.GetColumnValue<int>(PARAM_CountryId);
objEntityViewModel.CountryName = reader.GetColumnValue<string>(PARAM_CountryName);
objEntityViewModel.StateId = reader.GetColumnValue<int>(PARAM_StateId);
objEntityViewModel.StateName = reader.GetColumnValue<string>(PARAM_Name);
if (objEntityViewModel != null)
{
objEntityList.Add(objEntityViewModel);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return objEntityList;
}