private void btXemBaoCao_Click(object sender, RoutedEventArgs e)
{
var itemSelected = cbGroup.SelectedItem;
if (itemSelected != null)
{
conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path);
double TongCong = 0;
double TongCong2 = 0;
string queryString = "Select * From KilometManager Where Ngay >= '" + TuNgay.Date.ToString("yyyy-MM-dd") + "' And Ngay <= '" + DenNgay.Date.ToString("yyyy-MM-dd") + "' And [Group] = '" + cbGroup.SelectedItem.ToString() + "'";
List <KilometManager> listKM = conn.Query <KilometManager>(queryString).ToList();
foreach (var item in listKM)
{
TongCong += item.SoKmDiDuoc;
}
if (TongCong == 0)
{
btViewOnMap.Visibility = Visibility.Collapsed;
}
else
{
btViewOnMap.Visibility = Visibility.Visible;
}
string queryString2 = "Select * From KilometManager Where Ngay >= '" + TuNgay.Date.ToString("yyyy-MM-dd") + "' And Ngay <= '" + DenNgay.Date.ToString("yyyy-MM-dd") + "'";
List <KilometManager> listKM2 = conn.Query <KilometManager>(queryString2).ToList();
foreach (var item in listKM2)
{
TongCong2 += item.SoKmDiDuoc;
}
txtKetQua.Text = TongCong.ToString() + " Km";
txtTotalAllgroup.Text = TongCong2.ToString() + " Km";
conn.Dispose();
}
else
{
ShowMessage("Please select a group to view report");
btViewOnMap.Visibility = Visibility.Collapsed;
}
}
public void Dispose()
{
_conexao.Dispose();
}
public void Dispose()
{
connection.Dispose();
}