public virtual int Fill(CloudAccountDA.ReportRecurringAnnualDataTable dataTable, int?ComapnyID, int?ClientID) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (ComapnyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = ComapnyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (ClientID.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = ClientID.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
public virtual CloudAccountDA.ReportRecurringAnnualDataTable GetData(int?ComapnyID, int?ClientID) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (ComapnyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = ComapnyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (ClientID.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = ClientID.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } CloudAccountDA.ReportRecurringAnnualDataTable dataTable = new CloudAccountDA.ReportRecurringAnnualDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }