public static List <Permit> LoadList(Database database, Cargo cargo, VehicleMark mark, string licensePlate) { string query = EntryControl.Resources.Doc.Permit.LoadPrevious; QueryParameters parameters = new QueryParameters("cargo", cargo.Id); if (mark != null) { parameters.Add("mark", mark.Id); } else { parameters.Add("mark", DBNull.Value); } parameters.Add("licensePlate", licensePlate); List <Permit> permitList = new List <Permit>(); using (DbDataReader reader = database.ExecuteReader(query, parameters)) { while (reader.Read()) { permitList.Add(new Permit(reader)); } reader.Close(); } return(permitList); }
public VehicleMark LoadCopy(Database database) { VehicleMark mark = VehicleMark.Empty; QueryParameters parameters = new QueryParameters("id", Id); using (DbDataReader reader = database.ExecuteReader(LoadQuery, parameters)) { if (reader.Read()) mark = new VehicleMark(reader); reader.Close(); } if (mark.Equals(VehicleMark.Empty)) throw new ArgumentException(EntryControl.Resources.Message.Error.WrongIdentifier); return mark; }
public static List <Vehicle> LoadList(Database database, Contractor owner, VehicleMark mark, string license) { List <Vehicle> vehicleList = new List <Vehicle>(); QueryParameters parameters = new QueryParameters(); if (owner == null || owner.Equals(Contractor.Empty)) { parameters.Add("owner", null); } else { parameters.Add("owner", owner.Id); } if (mark == null || mark.Equals(EntryControl.Classes.VehicleMark.Empty)) { parameters.Add("mark", null); } else { parameters.Add("mark", mark.Id); } parameters.Add("license", license); using (DbDataReader reader = database.ExecuteReader(LoadListQuery, parameters)) { while (reader.Read()) { vehicleList.Add(new Vehicle(reader)); } reader.Close(); } return(vehicleList); }
protected override string StringDescription() { return(VehicleMark.ToString() + " " + LicensePlate); }