public virtual dsInvoiceSummary.uspInvoiceSummaryDataTable GetData(global::System.Nullable <int> ClientId) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((ClientId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((int)(ClientId.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } dsInvoiceSummary.uspInvoiceSummaryDataTable dataTable = new dsInvoiceSummary.uspInvoiceSummaryDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Fill(dsInvoiceSummary.uspInvoiceSummaryDataTable dataTable, global::System.Nullable <int> ClientId) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((ClientId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((int)(ClientId.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return(returnValue); }