public static int Create(SQLiteConnection conn, Vehicle vh, int typeId, int brandId, int driverId, int bossId) { // kontrola existence VIN v databázi bool vinExists = VehicleDbMapper.VinExists(conn, vh.Vin); if (vinExists) { return(-1); } vh.VehicleType = VehicleTypeXmlMapper.SelectById(typeId); vh.VehicleBrand = VehicleBrandXmlMapper.SelectById(brandId); vh.Driver = UserDriverDbMapper.SelectById(conn, 4); vh.Boss = UserBossDbMapper.SelectById(conn, 1); int result = VehicleDbMapper.Insert(conn, vh); return(result); }
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); }
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); }