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;
}
}
