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