public static List <ContractorContact> LoadList(Database database, Contractor contractor) { Enumeration contactTypeList = new Enumeration(database, "contactType"); List <ContractorContact> contactList = new List <ContractorContact>(); string query = EntryControl.Resources.Ref.Contractor.ContactLoadList; QueryParameters parameters = new QueryParameters("contractor", contractor.Id); using (DbDataReader reader = database.ExecuteReader(query, parameters)) { while (reader.Read()) { contactList.Add(new ContractorContact(contractor, contactTypeList, reader)); } reader.Close(); } return(contactList); }
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); }
public Contractor LoadCopy(Database database) { Contractor contractor = Contractor.Empty; QueryParameters parameters = new QueryParameters("id", Id); using (DbDataReader reader = database.ExecuteReader(LoadQuery, parameters)) { if (reader.Read()) { contractor = new Contractor(reader); } reader.Close(); } if (contractor.Equals(Contractor.Empty)) { throw new ArgumentException(EntryControl.Resources.Message.Error.WrongIdentifier); } return(contractor); }
protected override string StringDescription() { return(Contractor.ToString()); }
protected override void ReadProperties(DbDataReader reader) { contractor = new Contractor((int)reader["contractor"], (string)reader["contractorName"]); dateFrom = (DateTime)reader["dateFrom"]; dateTo = (DateTime)reader["dateTo"]; }
public ContractorContact(Contractor contractor, Enumeration typeList, DbDataReader reader) { Contractor = contractor; ContactType = typeList[(int)reader["id"]]; ContactValue = (DBNull.Value.Equals(reader["contactValue"]) ? "" : (string)reader["contactValue"]); }
public ContractorGroup(Contractor contractor, Enumeration groupList, DbDataReader reader) { Contractor = contractor; Group = groupList[(int)reader["id"]]; IsIncluded = ((int)reader["cnt"]) > 0; }