public virtual int FillByAccountNumber(ATM.AccountDataTable dataTable, int AccountNumber) { this.Adapter.SelectCommand = this.CommandCollection[1]; this.Adapter.SelectCommand.Parameters[0].Value = ((int)(AccountNumber)); if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public virtual int FillTransactions(ATM.TransactionDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public virtual int FillByCustomerNumber(ATM.AccountDataTable dataTable, System.Nullable<int> CustomerNumber) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((CustomerNumber.HasValue == true)) { this.Adapter.SelectCommand.Parameters[0].Value = ((int)(CustomerNumber.Value)); } else { this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value; } if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public virtual int FillBySecurerInfo(ATM.CustomerDataTable dataTable, string UserId, System.Nullable<int> Pin) { this.Adapter.SelectCommand = this.CommandCollection[1]; if ((UserId == null)) { this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[0].Value = ((string)(UserId)); } if ((Pin.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((int)(Pin.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value; } if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }