public static List <EmpleadoAvance> FetchEmpleadosAvance(int n_idpro
, int n_idemp
, string n_idtraIn
, int n_idtar
, DateTime d_fchini
, DateTime d_fchfin)
{
string c_fchini = d_fchini.ToString("yyyy-MM-dd");
string c_fchfin = d_fchfin.ToString("yyyy-MM-dd");
List <EmpleadoAvance> m_listaentidad = new List <EmpleadoAvance>();
using (MySqlConnection connection
= new MySqlConnection(
ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "pla_empleados_listaravance";
command.Parameters.Add(new MySqlParameter("@n_idpro", n_idpro));
command.Parameters.Add(new MySqlParameter("@n_idemp", n_idemp));
command.Parameters.Add(new MySqlParameter("@n_idtraIn", n_idtraIn));
command.Parameters.Add(new MySqlParameter("@n_idtar", n_idtar));
command.Parameters.Add(new MySqlParameter("@c_fchini", c_fchini));
command.Parameters.Add(new MySqlParameter("@c_fchfin", c_fchfin));
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
m_listaentidad.Add(new EmpleadoAvance
{
n_idper = Genericas.GetInt(reader, "n_idper"),
c_apenom = Genericas.GetString(reader, "c_apenom"),
d_fchtra = Genericas.GetDateTime(reader, "d_fchtra"),
n_can = Genericas.GetDouble(reader, "n_can"),
c_horini = Genericas.GetString(reader, "c_horini"),
c_horter = Genericas.GetString(reader, "c_horter")
});
}
}
}
}
return(m_listaentidad);
}
private static Empleado SetObject(MySqlDataReader reader)
{
return(new Empleado
{
n_id = reader.GetInt32("n_id"),
n_idemp = reader.GetInt32("n_idemp"),
n_idtipdocide = reader.GetInt32("n_idtipdocide"),
c_numdocide = reader.GetString("c_numdocide"),
c_ape1 = Genericas.GetString(reader, "c_ape1"),
c_ape2 = Genericas.GetString(reader, "c_ape2"),
c_nom1 = Genericas.GetString(reader, "c_nom1"),
c_nom2 = Genericas.GetString(reader, "c_nom2"),
d_fchnac = Genericas.GetDateTime(reader, "d_fchnac"),
n_idsex = Genericas.GetInt(reader, "n_idsex"),
c_numtel = Genericas.GetString(reader, "c_numtel"),
c_numesa = Genericas.GetString(reader, "c_numesa"),
d_fching = Genericas.GetDateTime(reader, "d_fching"),
n_asigfam = Genericas.GetInt(reader, "n_asigfam"),
n_suebas = Genericas.GetDouble(reader, "n_suebas"),
n_bon = Genericas.GetInt(reader, "n_bon"),
n_imphornor = Genericas.GetDouble(reader, "n_imphornor"),
n_imphorext = Genericas.GetDouble(reader, "n_imphorext"),
n_activo = Genericas.GetInt(reader, "n_activo"),
n_destajo = Genericas.GetInt(reader, "n_destajo"),
c_dir = Genericas.GetString(reader, "c_dir"),
c_email = Genericas.GetString(reader, "c_email"),
n_idnacpro = Genericas.GetInt(reader, "n_idnacpro"),
n_idnacdep = Genericas.GetInt(reader, "n_idnacdep"),
n_idnacdis = Genericas.GetInt(reader, "n_idnacdis"),
n_idrespro = Genericas.GetInt(reader, "n_idrespro"),
n_idresdep = Genericas.GetInt(reader, "n_idresdep"),
n_idresdis = Genericas.GetInt(reader, "n_idresdis"),
n_destacado = Genericas.GetInt(reader, "n_destacado"),
d_fchbaj = Genericas.GetDateTime(reader, "d_fchbaj")
});
}
