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));
 }