Пример #1
0
 public void WriteUser(User user)
 {
     string sqlstr;
     DataRowCollection result = null;
     if (user != null && this.isConnected()==true )
     {
         sqlstr = "SELECT * FROM login WHERE username='******'";
         try
         {
             result = db.GetDataTable(sqlstr).Rows;
         }
         catch (Exception)
         {
             Console.WriteLine("Error: can't get user from database");
             this.isconnected = false;
             throw new Exception("can't get user from database");
         }
         if (result.Count > 0)
         {
             sqlstr = string.Format("UPDATE login set password='******',sex={1},lastlogin='******' WHERE username='******'", user.Password, (int)user.Sex, user.lastLogin,user.Name );
             try
             {
                 db.ExeSql(sqlstr);
             }
             catch (Exception)
             {
                 Console.WriteLine("Error: can't create new user in database");
                 this.isconnected = false;
                 throw new Exception("can't create new user in database");
             }
         }
         else
         {
             sqlstr = string.Format("INSERT INTO login(username,password,sex,lastlogin) VALUES ('{0}','{1}',{2},'{3}')",user.Name, user.Password,(int)user.Sex, user.lastLogin);
             try
             {
                 db.ExeSql(sqlstr);
             }
             catch (Exception ex)
             {
                 Console.WriteLine("Error: can't create new user in database:" + ex.Message );
                 throw new Exception("can't create new user in database");
             }
         }
     }
 }
Пример #2
0
        public void WriteUser(User user)
        {
            string sqlstr;
            DataRowCollection result = null;
            if (user != null && this.isConnected()==true )
            {
                sqlstr = "SELECT * FROM `login` WHERE `username`='" + user.Name + "'";
                try
                {
                    result = SQLExecuteQuery(sqlstr);
                }
                catch (Exception)
                {
                    Console.WriteLine("Error: can't get user from database");
                    this.isconnected = false;
                    throw new Exception("can't get user from database");
                }
                if (result.Count > 0)
                {
                    sqlstr = string.Format("UPDATE `login` set `password`='{0}',`sex`='{1}',`lastlogin`='{2}' WHERE `username`='{3}'", user.Password, (int)user.Sex, user.lastLogin,user.Name );
                    try
                    {
                        MySqlHelper.ExecuteNonQuery(db, sqlstr, null);

                    }
                    catch (Exception)
                    {
                        Console.WriteLine("Error: can't create new user in database");
                        this.isconnected = false;
                        throw new Exception("can't create new user in database");
                    }
                }
                else
                {
                    sqlstr = string.Format("INSERT INTO `login`(`username`,`password`,`sex`,`lastlogin`) VALUES ('{0}','{1}','{2}','{3}')",user.Name, user.Password,(int)user.Sex, user.lastLogin);
                    try
                    {
                        SQLExecuteNonQuery(sqlstr);
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine("Error: can't create new user in database:" + ex.Message );
                        throw new Exception("can't create new user in database");
                    }
                }
            }
        }
Пример #3
0
        public User GetUser(string username)
        {
            User user=new User(username);
            string sqlstr;
            DataRow result;
            if (user != null && this.isConnected() == true)
            {
                sqlstr = "SELECT * FROM login WHERE username = '******'";
                try
                {
                    result = db.GetDataTable(sqlstr).Rows[0];
                }
                catch (Exception)
                {
                    return null;
                }
                try
                {
                    user.AccountID = Convert.ToInt32(result["account_id"]);
                    user.Password = (string)result["password"];
                    user.Sex = byte2Gender((byte)result["sex"]);
                    user.lastLogin = (string)result["lastlogin"];
                    user.Banned = Convert.ToBoolean(result["Banned"]);
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }

                return user;
            }
            return null;
        }
Пример #4
0
        public User GetUser(User user)
        {
            string sqlstr;
            DataRow result;
            if (user != null && this.isConnected() == true)
            {
                sqlstr = "SELECT * FROM `login` WHERE `username`='" + user.Name + "'";
                try
                {
                    result = SQLExecuteQuery(sqlstr)[0];
                }
                catch (Exception)
                {
                    return null;
                }
                try
                {
                    user.AccountID = Convert.ToInt32(result["account_id"]);
                    user.Password = (string)result["password"];
                    user.Sex = byte2Gender((byte)result["sex"]);

                    user.lastLogin = (string)result["lastlogin"];
                    user.Banned = Convert.ToBoolean(result["Banned"]);
                }
                catch (Exception ex)
                {
                    Logger.ShowError(ex);
                }
                return user;
            }
            return null;
        }