Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        public static List <Vehicle> SelectAll(SQLiteConnection conn)
        {
            List <Vehicle> result = new List <Vehicle>();

            using (SQLiteCommand cmd = new SQLiteCommand(selectAll, conn))
            {
                SQLiteDataReader reader = null;
                try
                {
                    reader = cmd.ExecuteReader();
                    while (reader.Read())
                    {
                        Vehicle vm = new Vehicle()
                        {
                            Id           = Convert.ToInt32(reader["rowid"].ToString()),
                            VehicleType  = VehicleTypeXmlMapper.SelectById(Convert.ToInt32(reader["VehicleTypeId"])),
                            VehicleBrand = VehicleBrandXmlMapper.SelectById(Convert.ToInt32(reader["VehicleBrandId"])),
                            Title        = reader["Title"].ToString(),
                            Vin          = reader["Vin"].ToString(),
                            LicensePlate = reader["LicensePlate"].ToString(),
                            Vintage      = Convert.ToInt16(reader["Vintage"]),
                            PurchasedOn  = Convert.ToDateTime(reader["PurchasedOn"]),
                            Price        = Convert.ToDecimal(reader["Price"].ToString()),
                            Boss         = UserBossDbMapper.SelectById(conn, Convert.ToInt32(reader["AdminId"])),
                            Driver       = UserDriverDbMapper.SelectById(conn, Convert.ToInt32(reader["DriverId"]))
                        };
                        result.Add(vm);
                    }
                }
                catch (Exception e)
                {
                    Trace.WriteLine($"EXCEPTION: VehicleDbMapper.SelectAll: {e.Message}");
                }
                finally
                {
                    reader?.Close();
                }
            }

            return(result);
        }
Esempio n. 3
0
 public static Vehicle 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())
             {
                 Vehicle vm = new Vehicle()
                 {
                     Id           = Convert.ToInt32(reader["rowid"].ToString()),
                     VehicleType  = VehicleTypeXmlMapper.SelectById(Convert.ToInt32(reader["VehicleTypeId"])),
                     VehicleBrand = VehicleBrandXmlMapper.SelectById(Convert.ToInt32(reader["VehicleBrandId"])),
                     Title        = reader["Title"].ToString(),
                     Vin          = reader["Vin"].ToString(),
                     LicensePlate = reader["LicensePlate"].ToString(),
                     Vintage      = Convert.ToInt16(reader["Vintage"]),
                     PurchasedOn  = Convert.ToDateTime(reader["PurchasedOn"]),
                     Price        = Convert.ToDecimal(reader["Price"].ToString()),
                     Boss         = UserBossDbMapper.SelectById(conn, Convert.ToInt32(reader["AdminId"])),
                     Driver       = UserDriverDbMapper.SelectById(conn, Convert.ToInt32(reader["DriverId"]))
                 };
                 reader.Close();
                 return(vm);
             }
         }
         catch (Exception e)
         {
             reader?.Close();
             Trace.WriteLine($"EXCEPTION: VehicleDbMapper.SelectById: {e.Message}");
         }
     }
     return(null);
 }