/// <summary>l um valor</summary>
internal static int executeNonQuery(string query)
{
string connectionString = OrionGlobals.getConnectionString("connectiostring-mysql");
MySqlConnection conn = new MySqlConnection(connectionString);
try {
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = query;
cmd.CommandType = CommandType.Text;
object obj = cmd.ExecuteScalar();
if (obj == null)
{
return(0);
}
return(int.Parse(obj.ToString()));
} catch (Exception e) {
Chronos.Utils.Log.log("Connection String: {0}", connectionString);
Chronos.Utils.Log.log("Error: " + e.Message);
throw;
} 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();
}
}
/// <summary>Retorna todos os tuplos de uma tabela</summary>
internal static DataSet getQuery(string query)
{
string connectionString = OrionGlobals.getConnectionString("connectiostring-mysql");
string queryString = query;
DataSet dsSections = null;
try {
MySqlDataAdapter sections = new MySqlDataAdapter(queryString, connectionString);
dsSections = new DataSet();
sections.Fill(dsSections);
} catch (Exception e) {
Chronos.Utils.Log.log("Connection String: {0}", connectionString);
Chronos.Utils.Log.log("Error: " + e.Message);
throw;
}
return(dsSections);
}
/// <summary>Construtor</summary>
public MySqlAllianceUtility()
{
conn = new MySqlConnection(OrionGlobals.getConnectionString("connectiostring-mysql"));
}
/// <summary>Construtor</summary>
public MySqlExceptionLogUtility()
{
conn = new MySqlConnection(OrionGlobals.getConnectionString("connectiostring-mysql"));
}