public override ObservableCollection <Isso> BindIssos()
{
var issos = new ObservableCollection <Isso>();
var issosTable = App.CreateDatabase().Query <IssosList>("SELECT I_ISSO.C_ISSO, NAME, DORNAME, W_ISSO, coalesce(RATINGS, -1) as RATINGS_1, N_OTC_EXP, LATITUDE, LONGITUDE, LENGTH, OBSTACLE from I_ISSO " +
"left outer join RATING on (RATING.C_ISSO = I_ISSO.C_ISSO and RATING.RATINGDATE = (select MAX(RATINGDATE) from RATING where C_ISSO = I_ISSO.C_ISSO))" +
(SelectedRoad.Equals("[Все]") ? "" : "where DORNAME = '" + SelectedRoad + "'" + " order by DORNAME, W_ISSO")).ToList();
foreach (var isso in issosTable)
{
var info =
$"{isso.NAME} (ОТС: {isso.N_OTC_EXP}) \n{isso.DORNAME} км {isso.W_ISSO>> 16}+{isso.W_ISSO& 0xFFFF} ({isso.OBSTACLE})";
issos.Add(new Isso(isso.C_ISSO, info, (Otc)isso.RATINGS_1, App.AppType));
}
return(issos);
}
public override ObservableCollection <Isso> BindIssos()
{
var issos = new ObservableCollection <Isso>();
var connection = ConnectionClass.CreateDatabase();
var issosTable = connection.Query <IssosList>("SELECT I_ISSO.C_ISSO, NAME, CTYPEISSO, DORNAME, W_ISSO, N_OTC_EXP, C_OTC_EXP, LATITUDE, LONGITUDE, LENGTH, OBSTACLE, NAME_ISSO from I_ISSO " +
(SelectedRoad.Equals("[Все]") ? "" : "where DORNAME = '" + SelectedRoad + "'" + " order by DORNAME, W_ISSO")).ToList();
foreach (var isso in issosTable)
{
var info =
$"{isso.NAME} (ОТС: {isso.N_OTC_EXP}) \n{isso.DORNAME} км {isso.W_ISSO >> 16}+{isso.W_ISSO & 0xFFFF} ({isso.OBSTACLE})" +
$"\n(Код ИССО: {isso.C_ISSO}) {(isso.NAME_ISSO != null && !isso.NAME_ISSO.Equals("") ? $"({isso.NAME_ISSO})" : "")}";
issos.Add(new Isso(isso.C_ISSO, info, (Otc)isso.C_OTC_EXP, App.AppType));
}
connection.Close();
return(issos);
}