mekasu0124

Untitled

Jan 8th, 2024
297
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.13 KB | None | 0 0
  1. // in database file
  2. public List<string> GetTotals()
  3. {
  4.     using SQLiteConnection conn = new(_dbPath);
  5.     using SQLiteCommand shiftInfo = conn.CreateCommand();
  6.     using SQLiteCommand gasInfo = conn.CreateCommand();
  7.     using SQLiteCommand maintenanceInfo = conn.CreateCommand();
  8.  
  9.     SQLiteDataReader reader;
  10.     SQLiteDataReader reader2;
  11.     SQLiteDataReader reader3;
  12.  
  13.     TotalsModel totals = new();
  14.  
  15.     conn.Open();
  16.  
  17.     shiftInfo.CommandText = @"SELECT * FROM shifts";
  18.     gasInfo.CommandText = @"SELECT * FROM gas";
  19.     maintenanceInfo.CommandText = @"SELECT * FROM maintenance";
  20.  
  21.     reader = shiftInfo.ExecuteReader();
  22.     reader2 = gasInfo.ExecuteReader();
  23.     reader3 = maintenanceInfo.ExecuteReader();
  24.  
  25.     try
  26.     {
  27.         while (reader.Read())
  28.         {
  29.         }
  30.     }
  31.     catch (Exception ex)
  32.     {
  33.         ColorPrint.WriteLine(ex.Message, ConsoleColor.Red);
  34.     }
  35. }
  36.  
  37. // model being used
  38. public class TotalsModel
  39. {
  40.     public double TotalGas { get; set; }
  41.     public double TotalMaintenance { get; set; }
  42.     public TimeSpan TotalTime { get; set; }
  43.     public int TotalMileage { get; set; }
  44. }
Advertisement
Add Comment
Please, Sign In to add comment