public static bool CheckAccount(string login, string password) { password = AddSymbols.ComputeSha256Hash(password); MySqlConnection conn = DbWorker.getMysqlConnection(); conn.Open(); string query = $"SELECT account.login, account.password FROM account WHERE account.login='******' AND account.password='******';"; MySqlCommand command = new MySqlCommand(); command.Connection = conn; command.CommandText = query; using (DbDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { reader.Read(); int loginO = reader.GetOrdinal("login"); string login_for_check = reader.GetString(loginO); int passwordO = reader.GetOrdinal("password"); string password_for_check = reader.GetString(passwordO); if (login_for_check.Equals(login) && password_for_check.Equals(password)) { return(true); } } } conn.Close(); return(false); }
public static bool CheckLogin(string login) { MySqlConnection conn = DbWorker.getMysqlConnection(); conn.Open(); string query = $"SELECT account.login FROM account WHERE account.login='******';"; MySqlCommand command = new MySqlCommand(); command.Connection = conn; command.CommandText = query; using (DbDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { reader.Read(); int loginO = reader.GetOrdinal("login"); string login_for_check = reader.GetString(loginO); if (login_for_check.Equals(login)) { return(true); } } } conn.Close(); return(false); }
public static bool EditAccount(UserModel user, string repeat_password) { bool error = false; if (!user.password.Equals(repeat_password)) { error = true; } if (user.age < 0) { error = true; } if (!user.name.Any(c => char.IsLetter(c))) { error = true; } if (!user.address.Any(c => char.IsLetter(c))) { error = true; } if (user.name.Length < 4) { error = true; } if (user.password.Length < 5) { error = true; } if (user.address.Length < 4) { error = true; } if (!double.TryParse(Convert.ToString(user.age), out double num)) { error = true; } if (!user.gender.Equals("male") && !user.gender.Equals("female")) { error = true; } if (!error) { user.password = AddSymbols.ComputeSha256Hash(user.password); MySqlConnection conn = DbWorker.getMysqlConnection(); conn.Open(); string query = $"UPDATE account SET name='{user.name}',password='******',address='{user.address}',age={user.age},gender='{user.gender}' WHERE login='******';"; MySqlCommand command = new MySqlCommand(); command.Connection = conn; command.CommandText = query; command.ExecuteNonQuery(); conn.Close(); return(true); } return(false); }
public static bool AddAccount(UserModel user, string repeat_password) { bool error = false; if (CheckLogin(user.login)) { error = true; } if (!user.password.Equals(repeat_password)) { error = true; } if (user.age < 0) { error = true; } if (!user.name.Any(c => char.IsLetter(c))) { error = true; } if (!user.address.Any(c => char.IsLetter(c))) { error = true; } if (!user.login.Any(c => char.IsLetter(c))) { error = true; } if (!user.login.Contains('@')) { error = true; } if (user.name.Length < 4) { error = true; } if (user.login.Length < 4) { error = true; } if (user.password.Length < 5) { error = true; } if (user.address.Length < 4) { error = true; } if (!double.TryParse(Convert.ToString(user.age), out double num)) { error = true; } if (!user.gender.Equals("male") && !user.gender.Equals("female")) { error = true; } if (!error) { user.password = AddSymbols.ComputeSha256Hash(user.password); MySqlConnection conn = DbWorker.getMysqlConnection(); conn.Open(); string query = $"INSERT INTO account(name,login,password,address,age,gender) VALUES('{user.name}','{user.login}','{user.password}','{user.address}',{user.age},'{user.gender}');"; MySqlCommand command = new MySqlCommand(); command.Connection = conn; command.CommandText = query; command.ExecuteNonQuery(); conn.Close(); return(true); } return(false); }