public static List <Notification> SelectAll(SQLiteConnection conn) { List <Notification> result = new List <Notification>(); using (SQLiteCommand cmd = new SQLiteCommand(selectAll, conn)) { SQLiteDataReader reader = null; try { reader = cmd.ExecuteReader(); while (reader.Read()) { Notification nm = new Notification() { Id = Convert.ToInt32(reader["Id"].ToString()), Inspection = InspectionDbMapper.SelectById(conn, Convert.ToInt32(reader["InspectionId"])), Destination = reader["Destination"].ToString(), SentOn = Convert.ToDateTime(reader["SentOn"]), Delivered = Convert.ToDateTime(reader["Delivered"]) }; result.Add(nm); } } catch (Exception e) { Trace.WriteLine($"EXCEPTION: NotificationDbMapper.SelectAll: {e.Message}"); } finally { reader?.Close(); } } return(result); }
public static Notification 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()) { Notification nm = new Notification() { Id = Convert.ToInt32(reader["Id"].ToString()), Inspection = InspectionDbMapper.SelectById(conn, Convert.ToInt32(reader["InspectionId"])), Destination = reader["Destination"].ToString(), SentOn = Convert.ToDateTime(reader["SentOn"]), Delivered = Convert.ToDateTime(reader["Delivered"]) }; reader.Close(); return(nm); } } catch (Exception e) { reader?.Close(); Trace.WriteLine($"EXCEPTION: NotificationDbMapper.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); }