public virtual int Fill(CloudAccountDA.ReportRecurringDetailedDataTable dataTable, int?ComapnyID, int?ClientID, DateTime?FromDate, DateTime?ToDate)
{
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 (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.ReportRecurringDetailedDataTable GetData(int?ComapnyID, int?ClientID, DateTime?FromDate, DateTime?ToDate)
{
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 (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.ReportRecurringDetailedDataTable dataTable = new CloudAccountDA.ReportRecurringDetailedDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
