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(); }