public virtual Memberships.OfficesDataTable FindOfficeByName(string OfficeName) {
this.Adapter.SelectCommand = this.CommandCollection[2];
if ((OfficeName == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(OfficeName));
}
Memberships.OfficesDataTable dataTable = new Memberships.OfficesDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual Memberships.OfficesDataTable GetOfficesByType(System.Nullable<System.Guid> OfficeTypeId) {
this.Adapter.SelectCommand = this.CommandCollection[4];
if ((OfficeTypeId.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(OfficeTypeId.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
}
Memberships.OfficesDataTable dataTable = new Memberships.OfficesDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual Memberships.OfficesDataTable GetOffices() {
this.Adapter.SelectCommand = this.CommandCollection[0];
Memberships.OfficesDataTable dataTable = new Memberships.OfficesDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
