public static Inspection SelectById(SQLiteConnection conn, int id) { using (SQLiteCommand cmd = new SQLiteCommand(selectById, conn)) { cmd.Parameters.AddWithValue("@Id", id); SQLiteDataReader reader = null; try { reader = cmd.ExecuteReader(); while (reader.Read()) { Inspection im = new Inspection() { Id = Convert.ToInt32(reader["rowid"].ToString()), Vehicle = VehicleDbMapper.SelectById(conn, Convert.ToInt32(reader["VehicleId"])), InspectionDate = Convert.ToDateTime(reader["InspectionDate"]), ValidTo = Convert.ToDateTime(reader["ValidTo"]), InspectionStation = InspectionStationDbMapper.SelectById(conn, Convert.ToInt32(reader["InspectionStationId"])), ProtocolNumber = reader["ProtocolNumber"].ToString(), Tachometer = Convert.ToInt32(reader["Tachometer"].ToString()), Price = Convert.ToDecimal(reader["Price"].ToString()), Defects = reader["Defects"].ToString() }; reader.Close(); return(im); } } catch (Exception e) { reader?.Close(); Trace.WriteLine($"EXCEPTION: InspectionDbMapper.SelectById: {e.Message}"); } } return(null); }
public static List <Notification> GenerateNotifications(SQLiteConnection conn, int days) { List <Notification> result = new List <Notification>(); using (SQLiteCommand cmd = new SQLiteCommand(generateNotifications, conn)) { cmd.Parameters.AddWithValue("@days", days); SQLiteDataReader reader = null; try { reader = cmd.ExecuteReader(); while (reader.Read()) { Notification nm = new Notification() { Id = -1, Inspection = InspectionDbMapper.SelectById(conn, Convert.ToInt32(reader["InspectionId"])), Destination = "", SentOn = DateTime.Now, Delivered = DateTime.Now }; var vehicle = VehicleDbMapper.SelectById(conn, Convert.ToInt32(reader["VehicleId"])); var boss = UserBossDbMapper.SelectById(conn, vehicle.Boss.Id); var email = boss.Email; nm.Destination = email; result.Add(nm); } } catch (Exception e) { Trace.WriteLine($"EXCEPTION: NotificationDbMapper.SelectAll: {e.Message}"); } finally { reader?.Close(); } } return(result); }
public static List <Inspection> SelectAll(SQLiteConnection conn) { List <Inspection> result = new List <Inspection>(); using (SQLiteCommand cmd = new SQLiteCommand(selectAll, conn)) { SQLiteDataReader reader = null; try { reader = cmd.ExecuteReader(); while (reader.Read()) { Inspection im = new Inspection() { Id = Convert.ToInt32(reader["rowid"].ToString()), Vehicle = VehicleDbMapper.SelectById(conn, Convert.ToInt32(reader["VehicleId"])), InspectionDate = Convert.ToDateTime(reader["InspectionDate"]), ValidTo = Convert.ToDateTime(reader["ValidTo"]), InspectionStation = InspectionStationDbMapper.SelectById(conn, Convert.ToInt32(reader["InspectionStationId"])), ProtocolNumber = reader["ProtocolNumber"].ToString(), Tachometer = Convert.ToInt32(reader["Tachometer"].ToString()), Price = Convert.ToDecimal(reader["Price"].ToString()), Defects = reader["Defects"].ToString() }; result.Add(im); } } catch (Exception e) { Trace.WriteLine($"EXCEPTION: InspectionDbMapper.SelectAll: {e.Message}"); } finally { reader?.Close(); } } return(result); }