Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using COServer.Database;
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace MangSystem
- {
- public class Accounts
- {
- public enum AccountState : byte
- {
- NotActivated = 100,
- Chef = 6,
- Food = 7,
- drinks = 8,
- ProjectManager = 4,
- Cashier = 5,
- Water = 3,
- User = 2,
- Banned = 1,
- DoesntExist = 0
- }
- public string Username = "", Password = "", Mobile = "", Email = "", Full_Name = "";
- public DateTime LastCheck;
- public AccountState State;
- public uint UID;
- public void DB_Where(string user)
- {
- if (user == null) return;
- this.Username = "";
- this.Password = "";
- this.Mobile = "";
- this.Email = "";
- this.Full_Name = "";
- this.LastCheck = DateTime.Now;
- this.State = AccountState.DoesntExist;
- this.UID = 0;
- MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(Program.connection("db_sql", ""));
- conn.Open();
- string sql = "SELECT * FROM accounts WHERE Username = '" + user + "'";
- MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, conn);
- MySql.Data.MySqlClient.MySqlDataReader rdr = cmd.ExecuteReader();
- while (rdr.Read())
- {
- this.UID = rdr.GetUInt32(0);
- this.Username = rdr.GetString(1);
- this.Password = rdr.GetString(2);
- this.Mobile = rdr.GetString(3);
- this.Email = rdr.GetString(4);
- this.LastCheck = rdr.GetDateTime("LastCheck");
- this.State = (AccountState)rdr.GetUInt32(6);
- this.Full_Name = rdr.GetString(7);
- }
- rdr.Close();
- conn.Close();
- }
- public void UpdatePssword(string NewPass, string user)
- {
- using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE))
- cmd.Update("accounts").Set("Password", NewPass).Where("Username", user).Execute();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement