public void ChangeRole(int uid, short role)
{
DBModel.OXUserDataContext context = new OXUserDataContext();
User user = context.User.Single(d => d.Id == uid);
user.role = role;
context.SubmitChanges();
}
public User FindUserByEmail(string email)
{
DBModel.OXUserDataContext context = new OXUserDataContext();
try
{
User user = context.User.Single(d => d.email == email);
return(user);
}
catch (InvalidOperationException e)
{
return(null);
}
}
public bool addUser(String email, String pwd, int role)
{
DBModel.OXUserDataContext context = new OXUserDataContext();
try
{
context.User.InsertOnSubmit(new User {
email = email, pwd = pwd, role = Convert.ToInt16(role)
});
context.SubmitChanges();
return(true);
}
catch (InvalidOperationException e)
{
return(false);
}
}
