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);
}