public static List <Vehicle> LoadList(EPVDatabase database, VehicleMark mark, string licensePlate)
{
List <Vehicle> vehicleList = new List <Vehicle>();
QueryParameters parameters = new QueryParameters("licensePlate", licensePlate);
if (mark != null)
{
parameters.Add("vehicleMark", mark.Id);
}
else
{
parameters.Add("vehicleMark", DBNull.Value);
}
using (DbDataReader reader = database.ExecuteReader(LoadListQuery, parameters))
{
while (reader.Read())
{
vehicleList.Add(new Vehicle(reader));
}
reader.Close();
}
return(vehicleList);
}
private Vehicle(int id, VehicleMark vehicleMark, string licensePlate)
{
Id = id;
VehicleMark = vehicleMark;
LicensePlate = licensePlate;
rowState = RowState.Readed;
}
public Vehicle(DbDataReader reader)
{
Id = (int)reader["id"];
VehicleMark = new VehicleMark((int)reader["vehicleMark"], (string)reader["nameMark"]);
LicensePlate = (string)reader["licensePlate"];
rowState = RowState.Readed;
}
public static VehicleMark Load(EPVDatabase database, int id)
{
VehicleMark vehicleMark = null;
QueryParameters parameters = new QueryParameters("id", id);
using (DbDataReader reader = database.ExecuteReader(LoadQuery, parameters))
{
if (reader.Read())
{
vehicleMark = new VehicleMark(reader);
}
reader.Close();
}
if (vehicleMark == null)
{
throw new ArgumentException(DispatcherService.Resources.Error.WrongIdentifier);
}
return(vehicleMark);
}
public override string ToString()
{
return(VehicleMark.ToString() + " " + LicensePlate);
}
