public virtual OfficesMaster.OfficeTypes_LKPDataTable GetOfficeTypes() {
     this.Adapter.SelectCommand = this.CommandCollection[4];
     OfficesMaster.OfficeTypes_LKPDataTable dataTable = new OfficesMaster.OfficeTypes_LKPDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
 public virtual OfficesMaster.OfficeTypes_LKPDataTable GetOfficeTypeById(System.Guid OfficeTypeId) {
     this.Adapter.SelectCommand = this.CommandCollection[3];
     this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(OfficeTypeId));
     OfficesMaster.OfficeTypes_LKPDataTable dataTable = new OfficesMaster.OfficeTypes_LKPDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }