internal int postUser(User user)
{
HashAndSalt pwSecurity = new HashAndSalt();
int result = -999999;
string password = user.Password;
string salt = pwSecurity.getSalt();
//.GenerateHash(password, salt, 0) the last 0 is the starting value for the recursive iteration counter
string saltedPassword = pwSecurity.GenerateHash(password, salt, 0);
password = ""; //ERASING IT FROM MEMORY
user.Password = saltedPassword;
user.Salt = salt;
rulesencyclopediaDBEntities1 context = new rulesencyclopediaDBEntities1();
try
{
//getting back the key for the created user.
context.User.Add(user);
result = context.SaveChanges();
}
catch (EntityException ex)
{
exHandler.exceptionHandlerEntity(ex, "something went wrong when posting user");
}
finally
{
context.Dispose();
}
return(result);
}
internal int editUser(User alteredUser)
{
int result = -999999;
rulesencyclopediaDBEntities1 context = new rulesencyclopediaDBEntities1();
var user = context.User.First(a => a.Id == alteredUser.Id);
user.FirstName = alteredUser.FirstName;
user.MiddleName = alteredUser.MiddleName;
user.LastName = alteredUser.LastName;
user.UserName = alteredUser.UserName;
user.Password = alteredUser.Password;
user.Date = alteredUser.Date;
try
{
result = context.SaveChanges();
} catch (EntityException ex)
{
exHandler.exceptionHandlerEntity(ex, "something went wrong when editing user");
}
finally
{
context.Dispose();
}
return(result);
}
internal int deleteUser(int ID)
{
int result = -999999;
try
{
var context = new rulesencyclopediaDBEntities1();
{
var user = new User {
Id = ID
};
context.User.Attach(user);
context.User.Remove(user);
result = context.SaveChanges();
}
}catch (EntityException ex)
{
exHandler.exceptionHandlerEntity(ex, "Something went wrong while deleting the user");
}
return(result);
}