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; }