public static List <System.Web.Mvc.SelectListItem> Types() { List <UserTypeModel> lis = UserTypeModel.GetUserType(); List <System.Web.Mvc.SelectListItem> items = new List <System.Web.Mvc.SelectListItem>(); items.Add(new System.Web.Mvc.SelectListItem { Text = lis[0].Type, Value = lis[0].TypeId.ToString(), Selected = true }); items.Add(new System.Web.Mvc.SelectListItem { Text = lis[1].Type, Value = lis[1].TypeId.ToString() }); return(items); }
public static List <UserTypeModel> GetUserType() { List <UserTypeModel> list = new List <UserTypeModel>(); Database d = DatabaseConnection.Connection.Connect(); { using (DbCommand command = d.GetStoredProcCommand("GetUserType")) { using (IDataReader reader = (IDataReader)d.ExecuteReader(command)) { while (reader.Read()) { UserTypeModel us = new UserTypeModel(); us.TypeId = (Convert.ToInt32(reader["TypeId"])); us.Type = ((reader["Type"].ToString())); list.Add(us); } } } } return(list); }