public bool IsNameTaken(string name)
{
DataTable dt = new DataTable();
if (name.Equals(string.Empty) || name.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
using (MySqlCommand command = new MySqlCommand())
{
dt = GetMultipleQuery(UserStringsMySql.IsNameTaken(name));
}
int num = 0;
foreach (DataRow ms in dt.Rows)
{
num = int.Parse(ms[0].ToString());
}
if (num == 0)
{
return(false);
}
else
{
return(true);
}
}
public UserModel ReturnUserByNamePassword(string userNickName, string userPassword)
{
if (userNickName == null || userNickName.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
if (userPassword == null || userPassword.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
if (!CheckStringFormat.IsBase64String(userPassword))
{
userPassword = ComputeHash.ComputeNewHash(userPassword);
}
DataTable dt = new DataTable();
UserModel userModel = new UserModel();
using (MySqlCommand command = new MySqlCommand())
{
dt = GetMultipleQuery(UserStringsMySql.ReturnUserByNamePassword(userNickName, userPassword));
}
foreach (DataRow ms in dt.Rows)
{
userModel = UserModel.ToObject(ms);
}
return(userModel);
}
public int DeleteUser(string id)
{
int i = 0;
using (MySqlCommand command = new MySqlCommand())
{
i = ExecuteNonQuery(UserStringsMySql.DeleteUser(id));
}
return(i);
}
public UserModel UploadUserImage(string id, string img)
{
UserModel userModel = new UserModel();
DataTable dt = new DataTable();
using (MySqlCommand command = new MySqlCommand())
{
dt = GetMultipleQuery(UserStringsMySql.UploadUserImage(id, img));
}
foreach (DataRow ms in dt.Rows)
{
userModel = UserModel.ToObject(ms);
}
return(userModel);
}
public List <UserModel> GetAllUsers()
{
DataTable dt = new DataTable();
List <UserModel> arrUser = new List <UserModel>();
using (MySqlCommand command = new MySqlCommand())
{
dt = GetMultipleQuery(UserStringsMySql.GetAllUsers());
}
foreach (DataRow ms in dt.Rows)
{
arrUser.Add(UserModel.ToObject(ms));
}
return(arrUser);
}
public string ReturnUserIdByImdbPass(string imdbPass)
{
DataTable dt = new DataTable();
string userId = "";
if (imdbPass.Equals(string.Empty) || imdbPass.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
using (MySqlCommand command = new MySqlCommand())
{
dt = GetMultipleQuery(UserStringsMySql.ReturnUserIdByImdbPass(imdbPass));
}
foreach (DataRow ms in dt.Rows)
{
userId = ms[0].ToString();
}
return(userId);
}
public UserModel AddUser(UserModel userModel)
{
string orPass = userModel.userPassword;
DataTable dt = new DataTable();
userModel.userPassword = ComputeHash.ComputeNewHash(userModel.userPassword);
using (MySqlCommand command = new MySqlCommand())
{
dt = GetMultipleQuery(UserStringsMySql.AddUser(userModel));
}
foreach (DataRow ms in dt.Rows)
{
userModel = UserModel.ToObject(ms);
}
if (ComputeHash.ComputeNewHash(orPass).Equals(userModel.userPassword))
{
userModel.userPassword = orPass;
}
return(userModel);
}
public UserModel GetOneUserById(string id)
{
DataTable dt = new DataTable();
if (id.Equals(string.Empty) || id.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
UserModel userModel = new UserModel();
using (MySqlCommand command = new MySqlCommand())
{
dt = GetMultipleQuery(UserStringsMySql.GetOneUserById(id));
}
foreach (DataRow ms in dt.Rows)
{
userModel = UserModel.ToObject(ms);
}
return(userModel);
}
public string ReturnImdbPassByNamePassword(LoginModel checkUser)
{
DataTable dt = new DataTable();
checkUser.userPassword = ComputeHash.ComputeNewHash(checkUser.userPassword);
if (checkUser == null)
{
throw new ArgumentOutOfRangeException();
}
LoginModel loginModel = new LoginModel();
using (MySqlCommand command = new MySqlCommand())
{
dt = GetMultipleQuery(UserStringsMySql.ReturnUserByNamePassword(checkUser));
}
foreach (DataRow ms in dt.Rows)
{
loginModel = LoginModel.ToObject(ms);
}
return(loginModel.userImdbPass);
}
public string ReturnUserIdByUserPass(string userPass)
{
DataTable dt = new DataTable();
string userId = "";
if (userPass.Equals(string.Empty) || userPass.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
userPass = ComputeHash.ComputeNewHash(userPass);
UserModel userModel = new UserModel();
using (MySqlCommand command = new MySqlCommand())
{
dt = GetMultipleQuery(UserStringsMySql.ReturnUserIdByUserPass(userPass));
}
foreach (DataRow ms in dt.Rows)
{
userId = ms[0].ToString();
}
return(userId);
}