public virtual int Fill(CloudAccountDA.ReportExpensesDataTable dataTable, int?CompanyID, int?SubCategoryID, DateTime?FromDate, DateTime?ToDate) { 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 (SubCategoryID.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = SubCategoryID.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } if (FromDate.HasValue) { this.Adapter.SelectCommand.Parameters[3].Value = FromDate.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value; } if (ToDate.HasValue) { this.Adapter.SelectCommand.Parameters[4].Value = ToDate.Value; } else { this.Adapter.SelectCommand.Parameters[4].Value = DBNull.Value; } if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
public virtual CloudAccountDA.ReportExpensesDataTable GetData(int?CompanyID, int?SubCategoryID, DateTime?FromDate, DateTime?ToDate) { 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 (SubCategoryID.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = SubCategoryID.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } if (FromDate.HasValue) { this.Adapter.SelectCommand.Parameters[3].Value = FromDate.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value; } if (ToDate.HasValue) { this.Adapter.SelectCommand.Parameters[4].Value = ToDate.Value; } else { this.Adapter.SelectCommand.Parameters[4].Value = DBNull.Value; } CloudAccountDA.ReportExpensesDataTable dataTable = new CloudAccountDA.ReportExpensesDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }