Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // in database file
- public List<string> GetTotals()
- {
- using SQLiteConnection conn = new(_dbPath);
- using SQLiteCommand shiftInfo = conn.CreateCommand();
- using SQLiteCommand gasInfo = conn.CreateCommand();
- using SQLiteCommand maintenanceInfo = conn.CreateCommand();
- SQLiteDataReader reader;
- SQLiteDataReader reader2;
- SQLiteDataReader reader3;
- TotalsModel totals = new();
- conn.Open();
- shiftInfo.CommandText = @"SELECT * FROM shifts";
- gasInfo.CommandText = @"SELECT * FROM gas";
- maintenanceInfo.CommandText = @"SELECT * FROM maintenance";
- reader = shiftInfo.ExecuteReader();
- reader2 = gasInfo.ExecuteReader();
- reader3 = maintenanceInfo.ExecuteReader();
- try
- {
- while (reader.Read())
- {
- }
- }
- catch (Exception ex)
- {
- ColorPrint.WriteLine(ex.Message, ConsoleColor.Red);
- }
- }
- // model being used
- public class TotalsModel
- {
- public double TotalGas { get; set; }
- public double TotalMaintenance { get; set; }
- public TimeSpan TotalTime { get; set; }
- public int TotalMileage { get; set; }
- }
Advertisement
Add Comment
Please, Sign In to add comment