public virtual int Fill(dsCreditPackageRestrition.tblCreditPackageRestrictionDataTable dataTable, string CreditPackage, global::System.Nullable <decimal> Balance)
{
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((CreditPackage == null))
{
throw new global::System.ArgumentNullException("CreditPackage");
}
else
{
this.Adapter.SelectCommand.Parameters[0].Value = ((string)(CreditPackage));
}
if ((Balance.HasValue == true))
{
this.Adapter.SelectCommand.Parameters[1].Value = ((decimal)(Balance.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);
}
public virtual dsCreditPackageRestrition.tblCreditPackageRestrictionDataTable GetData(string CreditPackage, global::System.Nullable<decimal> Balance) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((CreditPackage == null)) {
throw new global::System.ArgumentNullException("CreditPackage");
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = ((string)(CreditPackage));
}
if ((Balance.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((decimal)(Balance.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
dsCreditPackageRestrition.tblCreditPackageRestrictionDataTable dataTable = new dsCreditPackageRestrition.tblCreditPackageRestrictionDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
