public static UsersS GetUsers()
{
UsersS userse = new UsersS();
ServHCR shcr = new ServHCR();
userse = shcr.UsersGrid();
return userse;
}
public UsersS UsersGrid()
{
UsersS userse = new UsersS();
string connectionString = UtilSh.strCnn; //System.Configuration.ConfigurationManager.ConnectionStrings["cnnSql2"].ToString();
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "Exec dbo.UsersGrid";
command.CommandType = CommandType.Text;
connection.Open();
using (SqlDataReader dataReader = command.ExecuteReader())
{
UsersDTO user;
while (dataReader.Read())
{
user = new UsersDTO();//Creación de un nuevo objeto del tipo de nuestro DTO en donde cargaremos toda la información proveniente de nuestro comando de DB, discriminando cada elemento con 'request'
user.ID = Convert.ToInt32(dataReader["ID"]);
user.CemexID = Convert.ToString(dataReader["CemexID"]);
user.NUsuario = Convert.ToString(dataReader["NUsuario"]);
user.Email = Convert.ToString(dataReader["Email"]);
user.Rol = Convert.ToString(dataReader["Rol"]);
userse.Add(user);
}
}
//Convert.ToInt32(paramTotalRecords.Value);
}
}
return userse;
}
