public List <Models.UsuarioModels> ListarUsuarios() { SqlConnection conn = new SqlConnection(); SqlCommand sqlCom = new SqlCommand(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["DB_SW"].ToString(); StringBuilder cmd = new StringBuilder(); cmd.Append("SELECT * FROM dbo.AspNetUsers"); sqlCom.CommandText = cmd.ToString(); sqlCom.CommandType = System.Data.CommandType.Text; try { Models.UsuarioModels objUsuario; List <Models.UsuarioModels> objRetorno = new List <UsuarioModels>(); conn.Open(); sqlCom.Connection = conn; SqlDataReader reader = sqlCom.ExecuteReader(); while (reader.Read()) { objUsuario = new Models.UsuarioModels(); objUsuario.Email = reader["Email"].ToString(); objUsuario.Id = reader["Id"].ToString(); objUsuario.UserName = reader["UserName"].ToString(); objRetorno.Add(objUsuario); } conn.Close(); conn.Dispose(); return(objRetorno); } catch (Exception ex) { throw ex; } }
public UsuarioModels ObterUsario(string id) { SqlConnection conn = new SqlConnection(); SqlCommand sqlCom = new SqlCommand(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["DB_SW"].ToString(); StringBuilder cmd = new StringBuilder(); cmd.Append("SELECT * FROM DB_SW.dbo.AspNetUsers WHERE ID = @ID"); sqlCom.CommandText = cmd.ToString(); sqlCom.CommandType = System.Data.CommandType.Text; sqlCom.Parameters.Add(new SqlParameter("@ID", System.Data.SqlDbType.VarChar)); sqlCom.Parameters["@ID"].Value = id; try { Models.UsuarioModels objUsuario = new UsuarioModels(); conn.Open(); sqlCom.Connection = conn; SqlDataReader reader = sqlCom.ExecuteReader(); while (reader.Read()) { objUsuario = new Models.UsuarioModels(); objUsuario.Email = reader["Email"].ToString(); objUsuario.Id = reader["Id"].ToString(); objUsuario.UserName = reader["Username"].ToString(); } conn.Close(); conn.Dispose(); return(objUsuario); } catch (Exception ex) { throw ex; } }