public ResponseConsultarConductor ConsultarConductor(RequestConsultarConductor request)
{
ResponseConsultarConductor response = new ResponseConsultarConductor();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cnxANTP"].ToString());
List <Chofer> lista = new List <Chofer>();
try
{
SqlCommand com = new SqlCommand("USP_CONSULTAR_CONDUCTOR", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@Brevete", SqlDbType.VarChar, 10).Value = request.Brevete;
com.Parameters.Add("@Nombre", SqlDbType.VarChar, 60).Value = request.Nombre;
com.Parameters.Add("@DNI", SqlDbType.VarChar, 8).Value = request.DNI;
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
Chofer c = new Chofer();
c.Brevete = dr.IsDBNull(dr.GetOrdinal("Brevete")) ? "" : dr.GetString(dr.GetOrdinal("Brevete"));
c.Nombre = dr.IsDBNull(dr.GetOrdinal("Nombre")) ? "" : dr.GetString(dr.GetOrdinal("Nombre"));
c.Dni = dr.IsDBNull(dr.GetOrdinal("Dni")) ? "" : dr.GetString(dr.GetOrdinal("Dni"));
c.RucTransportista = dr.IsDBNull(dr.GetOrdinal("RucTransportista")) ? "" : dr.GetString(dr.GetOrdinal("RucTransportista"));
lista.Add(c);
}
response.listaChofer = lista;
response.Estado = true;
response.Mensaje = "Exitoso";
}
catch (Exception ex)
{
response.listaChofer = null;
response.Estado = false;
response.Mensaje = ex.Message.ToString();
}
finally
{
con.Close();
}
return(response);
}
public ResponseConsultarConductor ConsultarConductor(RequestConsultarConductor request)
{
ChoferBL bl = new ChoferBL();
return(bl.ConsultarConductor(request));
}
public ResponseConsultarConductor ConsultarConductor(RequestConsultarConductor request)
{
ChoferDA da = new ChoferDA();
return(da.ConsultarConductor(request));
}