public List <Maspe> ListarPersonalDinamico(int iDisplayLength, int iDisplayStart, int iSortCol_0, string sSortDir_0, string sSearch, string Cip, string Paterno, string Materno, string Nombres, string Dni)
{
List <Maspe> Lista = new List <Maspe>();
SqlConnection con = null;
SqlCommand cmd = null;
SqlDataReader dr = null;
try
{
con = Conexion.getInstance().ConexionBD();
cmd = new SqlCommand("Generico_BuscarPersonal", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DisplayLength", iDisplayLength);
cmd.Parameters.AddWithValue("@DisplayStart", iDisplayStart);
cmd.Parameters.AddWithValue("@SortCol", iSortCol_0);
cmd.Parameters.AddWithValue("@SortDir", sSortDir_0);
cmd.Parameters.AddWithValue("@Search", sSearch);
cmd.Parameters.AddWithValue("@Cip", Cip);
cmd.Parameters.AddWithValue("@ApPaterno", Paterno);
cmd.Parameters.AddWithValue("@ApMaterno", Materno);
cmd.Parameters.AddWithValue("@Nombres", Nombres);
cmd.Parameters.AddWithValue("@Dni", Dni);
con.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
Maspe objPersonal = new Maspe();
objPersonal.Fila = Convert.ToInt32(dr["RowNum"].ToString());
objPersonal.MASPE_CARNE = dr["MASPE_CARNE"].ToString();
objPersonal.tGrad.TGRAD_DES = dr["TGRAD_DES"].ToString();
objPersonal.tSitua.TSITUA_DESL = dr["TSITUA_DESL"].ToString();
objPersonal.MASPE_PATER = dr["MASPE_PATER"].ToString();
objPersonal.MASPE_PATER = dr["MASPE_PATER"].ToString();
objPersonal.MASPE_MATER = dr["MASPE_MATER"].ToString();
objPersonal.MASPE_NOMB = dr["MASPE_NOMB"].ToString();
objPersonal.Total = Convert.ToInt32(dr["Total"].ToString());
objPersonal.Filtro = Convert.ToInt32(dr["TotalCount"].ToString());
Lista.Add(objPersonal);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(Lista);
}
public async Task <List <Maspe> > ListarPersonal(string Cip, string Paterno, string Materno, string Nombres, string Dni)
{
List <Maspe> Lista = new List <Maspe>();
SqlConnection con = null;
SqlCommand cmd = null;
SqlDataReader reader = null;
try
{
//using (SqlConnection sql = new SqlConnection(_connectionString))
//{
// using (SqlCommand cmd = new SqlCommand("GetAllValues", sql))
// {
// cmd.CommandType = System.Data.CommandType.StoredProcedure;
// var response = new List<Maspe>();
// await sql.OpenAsync();
// using (var reader = await cmd.ExecuteReaderAsync())
// {
// while (await reader.ReadAsync())
// {
// response.Add(MapToValue(reader));
// }
// }
// return response;
// }
//}
//==============================================
//con = Conexion.getInstance().ConexionBD();
con = new SqlConnection(_connectionString);
cmd = new SqlCommand("AscensoListarPersonal2", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Cip", Cip);
cmd.Parameters.AddWithValue("@ApPaterno", Paterno);
cmd.Parameters.AddWithValue("@ApMaterno", Materno);
cmd.Parameters.AddWithValue("@Nombres", Nombres);
cmd.Parameters.AddWithValue("@Dni", Dni);
//con.Open();
await con.OpenAsync();
//reader = cmd.ExecuteReader();
reader = await cmd.ExecuteReaderAsync();
//while (await reader.Read())
while (await reader.ReadAsync())
{
// Crear objetos de tipo maspe
Maspe objMaspe = new Maspe();
objMaspe.Fila = Convert.ToInt32(reader["RowNum"].ToString());
objMaspe.MASPE_CARNE = Convert.ToInt32(reader["MASPE_CARNE"]);
objMaspe.MASPE_FASCEN = reader["MASPE_FASCEN"].ToString();
objMaspe.TGRAD_DES = reader["TGRAD_DES"].ToString();
objMaspe.TSITUA_DESL = reader["TSITUA_DESL"].ToString();
objMaspe.MASPE_PATER = reader["MASPE_PATER"].ToString();
objMaspe.MASPE_MATER = reader["MASPE_MATER"].ToString();
objMaspe.MASPE_NOMB = reader["MASPE_NOMB"].ToString();
objMaspe.MASPE_DNI = reader["MASPE_DNI"].ToString();
objMaspe.Total = Convert.ToInt32(reader["Total"].ToString());
objMaspe.Filtro = Convert.ToInt32(reader["TotalCount"].ToString());
Lista.Add(objMaspe);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(Lista);
}
