public void paises(long country_id = 0) { exist_countries exist_countries = new exist_countries(); var collection_countries = exist_countries.Consultar(0); collection_countries.Insert(0, new CountriesDto { name = GeralResource.RecRes(623), country_id = 0 }); var arrSelectList = new SelectList(collection_countries, "country_id", "name", country_id); ViewBag.userLog = getUser(); ViewBag.paises = arrSelectList; }
private Exist_UsersDtoCollection GetExist_UsersDtoCollection(DataTable tabela) { try { Exist_UsersDtoCollection usuarios = new Exist_UsersDtoCollection(); foreach (DataRow item in tabela.Rows) { Exist_UsersDto usuario = new Exist_UsersDto(); usuario.user_id = Convert.ToInt64(item["user_id"]); usuario.user_email = item["user_email"].ToString(); usuario.user_company = item["user_company"].ToString(); usuario.user_name = item["user_name"].ToString(); usuario.user_phone = item["user_phone"].ToString(); usuario.dose = Convert.ToInt64(item["dose"]); usuario.user_blocked = Convert.ToBoolean(item["user_blocked"]); usuario.currency_id = Convert.ToInt64(item["currency_id"]); if (item["user_accesslevel"] != DBNull.Value) { usuario.user_accesslevel = Convert.ToInt32(item["user_accesslevel"]); } if (item["user_date_expire"] != DBNull.Value) { usuario.user_date_expire = Convert.ToDateTime(item["user_date_expire"]); } if (item["user_date_register"] != DBNull.Value) { usuario.user_date_register = Convert.ToDateTime(item["user_date_register"]); } if (item["date_answer"] != DBNull.Value) { usuario.date_answer = Convert.ToDateTime(item["date_answer"]); } if (item["last_name"] != DBNull.Value) { usuario.last_name = item["last_name"].ToString(); } if (item["treatment"] != DBNull.Value) { usuario.treatment = item["treatment"].ToString(); } usuario.user_blocked = Convert.ToBoolean(item["user_blocked"]); exist_countries paises = new exist_countries(); long user_country = Convert.ToInt64(item["user_country"]); usuario.user_country = user_country; var collection = paises.Consultar(user_country); if (collection.Count > 0) { usuario.countries = collection[0]; } if (item["comments"] != DBNull.Value) { usuario.comments = item["comments"].ToString(); } if (item["user_admin"] != DBNull.Value) { usuario.user_admin = Convert.ToBoolean(item["user_admin"]); } usuario.user_password = item["user_password"].ToString(); if (tabela.Columns.Contains("chbx")) { usuario.chbx = Convert.ToBoolean(item["chbx"]); } usuarios.Add(usuario); } return(usuarios); } catch (Exception ex) { throw ex; } }