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