public bool IsNameTaken(string name)
{
if (name.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
DataTable dt = new DataTable();
int taken = 0;
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(UserStringsSql.IsNameTaken(name));
}
foreach (DataRow ms in dt.Rows)
{
taken = int.Parse(ms[0].ToString());
}
if (taken == 0)
{
return(false);
}
else
{
return(true);
}
}
public UserModel AddUser(UserModel userModel)
{
string orPass = userModel.userPassword;
userModel.userPassword = ComputeHash.ComputeNewHash(userModel.userPassword);
if (userModel.userLevel < 1)
{
userModel.userLevel = 1;
}
DataTable dt = new DataTable();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(UserStringsSql.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 GetOneUserByLogin(string userNickName, string userPassword)
{
if (userNickName.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
if (userPassword.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
if (!CheckStringFormat.IsBase64String(userPassword))
{
userPassword = ComputeHash.ComputeNewHash(userPassword);
}
DataTable dt = new DataTable();
UserModel userModel = new UserModel();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(UserStringsSql.GetOneUserByLogin(userNickName, userPassword));
}
foreach (DataRow ms in dt.Rows)
{
userModel = UserModel.ToObject(ms);
}
return(userModel);
}
public int DeleteUser(string id)
{
int i = 0;
using (SqlCommand command = new SqlCommand())
{
i = ExecuteNonQuery(UserStringsSql.DeleteUser(id));
}
return(i);
}
public UserModel GetOneUserForMessageById(string id)
{
DataTable dt = new DataTable();
UserModel userModel = new UserModel();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(UserStringsSql.GetOneUserForMessageById(id));
}
foreach (DataRow ms in dt.Rows)
{
userModel = UserModel.ToObjectMessage(ms);
}
return(userModel);
}
public List <UserModel> GetAllUsers()
{
DataTable dt = new DataTable();
List <UserModel> arrUser = new List <UserModel>();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(UserStringsSql.GetAllUsers());
}
foreach (DataRow ms in dt.Rows)
{
arrUser.Add(UserModel.ToObject(ms));
}
return(arrUser);
}
public UserModel UploadUserImage(string id, string img)
{
DataTable dt = new DataTable();
UserModel userModel = new UserModel();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(UserStringsSql.UploadUserImage(id, img));
}
foreach (DataRow ms in dt.Rows)
{
userModel = UserModel.ToObject(ms);
}
return(userModel);
}
public UserModel GetOneUserById(string id)
{
if (id.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
DataTable dt = new DataTable();
UserModel userModel = new UserModel();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(UserStringsSql.GetOneUserById(id));
}
foreach (DataRow ms in dt.Rows)
{
userModel = UserModel.ToObject(ms);
}
return(userModel);
}
public LoginModel ReturnUserByNameLevel(string username, int userLevel = 0)
{
if (username == null || username.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
DataTable dt = new DataTable();
LoginModel loginModel = new LoginModel();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(UserStringsSql.ReturnUserByNameLevel(username, userLevel));
}
foreach (DataRow ms in dt.Rows)
{
loginModel = LoginModel.ToObjectNameLevel(ms);
}
return(loginModel);
}
public LoginModel ReturnUserByNamePassword(LoginModel checkUser)
{
checkUser.userPassword = ComputeHash.ComputeNewHash(checkUser.userPassword);
if (checkUser == null)
{
throw new ArgumentOutOfRangeException();
}
DataTable dt = new DataTable();
LoginModel loginModel = new LoginModel();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(UserStringsSql.ReturnUserByNamePassword(checkUser));
}
foreach (DataRow ms in dt.Rows)
{
loginModel = LoginModel.ToObject(ms);
}
return(loginModel);
}
