public virtual CloudAccountDA.ChangeUsernameDataTable GetData(string ApplicationName, string OldUserName, string NewUserName) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (ApplicationName == null) { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ApplicationName; } if (OldUserName == null) { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = OldUserName; } if (NewUserName == null) { this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = NewUserName; } CloudAccountDA.ChangeUsernameDataTable dataTable = new CloudAccountDA.ChangeUsernameDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Fill(CloudAccountDA.ChangeUsernameDataTable dataTable, string ApplicationName, string OldUserName, string NewUserName) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (ApplicationName == null) { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ApplicationName; } if (OldUserName == null) { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = OldUserName; } if (NewUserName == null) { this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = NewUserName; } if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }