protected ArrayList PopulateUsers(DataSet ds, string idstr)
{
ArrayList list = new ArrayList();
foreach (DataRow row in ds.Tables[0].Rows)
{
User user = new User();
user.Nick = (string)row["user_nick"];
user.Mail = (string)row["user_mail"];
user.UserId = (int)row[idstr];
user.RulerId = (int)row["user_ruler_id"];
user.EloRanking = (int)row["user_rank"];
user.AllianceId = (int)row["user_alliance_id"];
user.AllianceRank = AllianceInfo.ToAllianceRank((string)row["user_alliance_rank"]);
user.Wins = (int)row["user_wins"];
user.Losses = (int)row["user_losses"];
list.Add(user);
}
return(list);
}
/// <summary>Preenche um User com os seus dados</summary>
private bool fillUserInformation( User user, string query )
{
HttpContext.Current.Trace.Write("MySQL","Query String: " + query);
try {
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = query;
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
HttpContext.Current.Trace.Write("MySQL","Has Rows: " + reader.HasRows.ToString());
user.Nick = (string) reader["user_nick"];
user.Mail = (string) reader["user_mail"];
user.UserId = (int) reader["IDUsers"];
user.RulerId = (int) reader["user_ruler_id"];
user.EloRanking = (int) reader["user_rank"];
user.AllianceId = (int) reader["user_alliance_id"];
user.AllianceRank = AllianceInfo.ToAllianceRank((string) reader["user_alliance_rank"]);
if( reader["user_regist"] != DBNull.Value ) {
user.RegistDate = (DateTime) reader["user_regist"];
} else {
user.RegistDate = DateTime.Now;
}
if( reader["user_lastLogin"] != DBNull.Value ) {
user.LastLogin = (DateTime) reader["user_lastLogin"];
} else {
user.LastLogin = DateTime.Now;
}
user.Skin = (int) reader["user_skin"];
user.Lang = (string) reader["user_lang"];
user.ImagesDir = (string) reader["user_imagesDir"];
user.Website = (string) reader["user_website"];
user.Avatar = (string) reader["user_avatar"];
user.Msn = (string) reader["user_msn"];
user.Icq = (string) reader["user_icq"];
user.Jabber = (string) reader["user_jabber"];
user.Aim = (string) reader["user_aim"];
user.Yahoo = (string) reader["user_yahoo"];
user.SetRoles( getRoles(user.UserId) );
return true;
} catch( Exception e ) {
HttpContext.Current.Trace.Warn("MySQL",e.Message);
Console.WriteLine("EXCEPTION: " + e);
return false;
} finally {
conn.Close();
}
}
/// <summary>
/// Preenche um User com os seus dados
/// </summary>
public override void fillUser( User user ) {
NpgsqlConnection conn = new NpgsqlConnection(OrionGlobals.getConnectionString("connectionStringPG"));
NpgsqlCommand cmd = new NpgsqlCommand("OrionsBelt_UsersGetUser", conn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add("@user_mail",user.Mail);
try {
conn.Open();
reader = cmd.ExecuteReader();
if( reader.HasRows ) {
reader.Read();
user.Nick = (string) getField("user_nick");
user.UserId = (int) getField("user_id");
if ( getField("user_ruler_id") != DBNull.Value )
user.RulerId = (int) getField("user_ruler_id");
user.EloRanking = (int) getField("user_rank");
user.RegistDate = (DateTime) getField("user_registDate");
user.LastLogin = (DateTime) getField("user_lastLogin");
user.Skin = (int) getField("user_skin");
user.Lang = (string) getField("user_lang");
user.ImagesDir = (string) getField("user_imagesDir");
user.Website = (string) getField("user_website");
user.Avatar = (string) getField("user_avatar");
user.Msn = (string) getField("user_msn");
user.Icq = (string) getField("user_icq");
user.Jabber = (string) getField("user_jabber");
user.Aim = (string) getField("user_aim");
user.Yahoo = (string) getField("user_yahoo");
user.AllianceId = (int) reader["user_alliance_id"];
user.AllianceRank = AllianceInfo.ToAllianceRank( reader["user_alliance_rank"].ToString() );
user.Wins = (int) reader["user_wins"];
user.Losses = (int) reader["user_losses"];
}else {
ExceptionLog.log("User não encontrado", "Mail: " + user.Mail==null?"null":user.Mail );
}
reader = null;
} catch( NpgsqlException e ) {
throw new AlnitakException("Erro ao executar o procedimento 'OrionsBelt_UsersGetUser' @ NpgsqlServerUserutility::fillUser ",e);
} finally {
conn.Close();
}
}
/// <summary>Obtém um User dado o seu id</summary>
public override User getUser( int id ) {
NpgsqlConnection conn = new NpgsqlConnection(OrionGlobals.getConnectionString("connectionStringPG"));
NpgsqlCommand cmd = new NpgsqlCommand("OrionsBelt_UsersGetUserById", conn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add("@id",id);
try {
conn.Open();
reader = cmd.ExecuteReader();
if( reader.Read() ) {
User user = new User();
user.Nick = (string) reader["user_nick"];
user.UserId = (int) reader["user_id"];
user.RulerId = (int) reader["user_ruler_id"];
user.EloRanking = (int) reader["user_rank"];
user.RegistDate = (DateTime) getField("user_registDate");
user.LastLogin = (DateTime) getField("user_lastLogin");
user.Skin = (int) reader["user_skin"];
user.Lang = (string) reader["user_lang"];
user.ImagesDir = (string) reader["user_imagesDir"];
user.Website = (string) reader["user_website"];
user.Avatar = (string) reader["user_avatar"];
user.Msn = (string) reader["user_msn"];
user.Icq = (string) reader["user_icq"];
user.Jabber = (string) reader["user_jabber"];
user.Aim = (string) reader["user_aim"];
user.Yahoo = (string) reader["user_yahoo"];
user.AllianceId = (int) reader["user_alliance_id"];
user.AllianceRank = AllianceInfo.ToAllianceRank( reader["user_alliance_rank"].ToString() );
user.Wins = (int) reader["user_wins"];
user.Losses = (int) reader["user_losses"];
return user;
}else
return null;
} catch( Exception e ) {
throw new AlnitakException("Erro ao executar o procedimento 'OrionsBelt_UsersGetUserById' @ NpgsqlServerUserutility::getUser : " + e.Message,e);
} finally {
conn.Close();
}
}