//Create
//Read
public User GetUser(string UserName, string Password)
{
if (UserName == "")
{
throw new Exception("There was no username given!");
}
if (Password == "")
{
throw new Exception("There was no password given!");
}
if (_dbContext.Login.Where(l => l.UserName == UserName && l.Password == Password).Count() == 0)
{
throw new Exception("There is no record of that user!");
}
Models.DataModels.Login U_L = _dbContext.Login.Where(l => l.UserName == UserName && l.Password == Password).First();
int loginID = U_L.ID;
Models.DataModels.User U = _dbContext.User.Where(u => u.LoginID == loginID).First();
return(new User()
{
FirstName = U.FirstName,
MiddleName = U.MiddleName,
LastName = U.LastName,
ID = U.ID,
Email = U.Email,
UserName = UserName,
AccountType = U.Type,
});
}
//Update
public bool UpdateUser(User User)
{
if (User.FirstName == "" || User.LastName == "" || User.Email == "" || User.AccountType == "" || User.UserName == "")
{
throw new Exception("All the values must be filled in!");
}
if (_dbContext.Login.Where(l => l.UserName == User.UserName).Count() > 0)
{
throw new Exception("This username already exists!");
}
if (_dbContext.User.Where(u => u.ID == User.ID).Count() == 0)
{
throw new Exception("There is no record of that user!");
}
Models.DataModels.User NewUser = _dbContext.User.Where(u => u.ID == User.ID).First();
Models.DataModels.Login Login = _dbContext.Login.Where(l => l.ID == NewUser.LoginID).First();
NewUser.Email = User.Email;
NewUser.FirstName = User.FirstName;
NewUser.LastName = User.LastName;
NewUser.MiddleName = User.MiddleName;
NewUser.Type = User.AccountType;
Login.UserName = User.UserName;
_dbContext.SaveChanges();
return(true);
}
public void RecoverPassword(string UserName, string Email)
{
if (_dbContext.Login.Where(l => l.UserName == UserName).Count() == 0)
{
throw new Exception("Er is geen account met deze gebruikersnaam bij ons bekent.");
}
if (_dbContext.User.Where(u => u.Email == Email).Count() == 0)
{
throw new Exception("Er is geen account met deze email bij ons bekent.");
}
if (_dbContext.User.Where(u => u.Email == Email).First().LoginID != _dbContext.Login.Where(l => l.UserName == UserName).First().ID)
{
throw new Exception("De gebruikersnaam en het email adres komt niet overeen");
}
Models.DataModels.Login Login = _dbContext.Login.Where(l => l.UserName == UserName).First();
string NewPassword = "******";
string EncryptedNewPassword = EncryptHandler.Encrypt(NewPassword, Login.Salt);
Login.Password = EncryptedNewPassword;
_dbContext.SaveChanges();
EmailHandler EmailHandler = new EmailHandler();
string Message = "Beste " + UserName + "," + Environment.NewLine +
Environment.NewLine +
"Je hebt op onze site een niew wachtwoord aangevraagd." + Environment.NewLine +
"Jouw niew wachtwoord is : " + NewPassword + Environment.NewLine +
Environment.NewLine +
"Met Vriendelijke Groet" + Environment.NewLine +
"BrightLearn";
EmailHandler.SendEmail(Email, "Wachtwoord herstel", Message);
}
public User GenerateUser()
{
string UserName = "";
while (true)
{
UserName = RandomString(5);
if (dbContext.Login.Where(l => l.UserName == UserName).Count() == 0)
{
break;
}
}
string Password = "******";
string SaltKey = EncryptHandler.RandomString(8);
Models.DataModels.Login login = new Models.DataModels.Login()
{
UserName = UserName,
Password = Password,
Salt = SaltKey
};
dbContext.SaveChanges();
int loginID = dbContext.Login.Last().ID;
//SQL.Insert("INSERT INTO `login` (`ID`, `username`, `password`, `salt`) VALUES (NULL, '" + UserName + "', '" + EncryptHandler.Encrypt(Password, SaltKey) + "', '" + SaltKey + "');");
//string loginID = SQL.Select("SELECT `ID` FROM `login` WHERE `username` = '"+UserName+"'")[0];
Models.DataModels.User user = new Models.DataModels.User()
{
Email = "*****@*****.**",
FirstName = "Voornaam",
LastName = "Achternaam",
LoginID = loginID,
Type = "user"
};
dbContext.User.Add(user);
dbContext.SaveChanges();
//SQL.Insert("INSERT INTO `user` (`ID`, `loginID`, `email`, `firstName`, `middleName`, `lastName`, `type`) VALUES (NULL, '"+loginID+"', '*****@*****.**', 'Voornaam', NULL, 'Achternaam', 'user');");
return(new User()
{
UserName = UserName,
Password = Password
});
}
public User GenerateUser()
{
string UserName = "";
while (true)
{
UserName = RandomString(5);
if (_dbContext.Login.Where(l => l.UserName == UserName).Count() == 0)
{
break;
}
}
string Password = "******";
string SaltKey = EncryptHandler.RandomString(8);
string newPass = EncryptHandler.Encrypt(Password, SaltKey);
Models.DataModels.Login login = new Models.DataModels.Login()
{
UserName = UserName,
Password = newPass,
Salt = SaltKey
};
_dbContext.Login.Add(login);
_dbContext.SaveChanges();
login = _dbContext.Login.OrderByDescending(u => u.ID).FirstOrDefault();
Models.DataModels.User User = new Models.DataModels.User()
{
Email = "*****@*****.**",
FirstName = "Voornaam",
LastName = "Achternaam",
LoginID = login.ID,
Type = "user"
};
_dbContext.User.Add(User);
_dbContext.SaveChanges();
return(new User()
{
UserName = UserName,
Password = Password
});
}
public bool UpdatePassword(string CurrentPassword, string NewPassword, string RepeatNewPassword, int UserID)
{
if (CurrentPassword == "" || NewPassword == "" || RepeatNewPassword == "" || CurrentPassword == null || NewPassword == null || RepeatNewPassword == null)
{
throw new Exception("All fields must be filled in!");
}
_loginHandler.IsValidPassword(CurrentPassword);
_loginHandler.IsValidPassword(NewPassword);
if (NewPassword != RepeatNewPassword)
{
throw new Exception("The Passwords do not match");
}
if (_dbContext.Login.Where(l => l.ID == UserID).Count() == 0)
{
throw new Exception("There is no record of that user!");
}
string UserName = _dbContext.Login.Where(l => l.ID == UserID).First().UserName;
if (!_loginHandler.Auth(UserName, CurrentPassword))
{
throw new Exception("Het wachtwoord is incorrect!");
}
Models.DataModels.Login L = _dbContext.Login.Where(l => l.ID == UserID).First();
string EncryptedPassword = _loginHandler.EncryptPass(NewPassword, UserName);
L.Password = EncryptedPassword;
L.UserName = UserName;
_dbContext.SaveChanges();
return(true);
}
