public List <Track_Movil> Track_GetAllTransportistas(string _all, string v_transportista)
{
var consultaComercial = new List <Track_Movil>();
SqlDataAdapter var_adaptador = new SqlDataAdapter();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BD_Produccion"].ConnectionString.ToString()))
{
using (SqlCommand cmd = new SqlCommand("spu_GpsTrack_GetAllTransportistas", conn))
{
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Transportista", v_transportista);
cmd.Parameters.AddWithValue("@all", _all);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
foreach (var item in reader)
{
Track_Movil rows = new Track_Movil
{
//Patente = Convert.ToString(reader["Patente"]),
//IdTipoMovil = Convert.ToInt32(reader["IdTipoMovil"]),
//ProveedorGPS = Convert.ToString(reader["ProveedorGPS"]),
Transportista = Convert.ToString(reader["Transportista"])
//RutTransportista = Convert.ToString(reader["RutTransportista"]),
//Opcional = Convert.ToString(reader["Opcional"]),
};
consultaComercial.Add(rows);
}
conn.Close();
}
catch (Exception ex)
{
//throw ex;
// consultaComercial.respuesta = ex.Message;
}
}
}
return(consultaComercial);
}
public List <Track_Movil> GetAllPatentes(string transportista, bool _all = false)
{
try
{
List <Track_Movil> _listaPatentes = (from c in _context.Track_Movil where (c.Transportista == transportista || transportista == "Todos" || transportista == "") select c).ToList();
if (_all)
{
Track_Movil newItem = new Track_Movil {
Patente = "Todas"
};
_listaPatentes.Insert(0, newItem);
}
return(_listaPatentes);
}
catch (Exception)
{
return(new List <Track_Movil>());
}
}
