/// <summary> /// Добавление пользователю группы по USER_ID пользователя /// и по ACCESSGROUP_ID группы /// </summary> /// <param name="user_id"></param> /// <param name="accessgroup_id"></param> /// <returns></returns> public void AddUserInAccessGroup(Int64 user_id, Int64 accessgroup_id) { using (SecurityDBEntities db = new SecurityDBEntities()) { UsersInAccessGroups userinaccessgroup = new UsersInAccessGroups(); userinaccessgroup.USER_ID = user_id; userinaccessgroup.ACCESSGROUP_ID = accessgroup_id; db.AddToUsersInAccessGroups(userinaccessgroup); db.SaveChanges(); } }
/// <summary> /// Добавление пользователю группы по логину пользователя /// и по ACCESSGROUP_ID группы /// </summary> /// <param name="user_login"></param> /// <param name="accessgroup_id"></param> /// <returns></returns> public void AddUserInAccessGroup(String user_login, Int64 accessgroup_id) { using (SecurityDBEntities db = new SecurityDBEntities()) { long user_id = (from u in db.Users where (u.LOGIN == user_login) select u.USER_ID).First(); UsersInAccessGroups userinaccessgroup = new UsersInAccessGroups(); userinaccessgroup.USER_ID = user_id; userinaccessgroup.ACCESSGROUP_ID = accessgroup_id; db.AddToUsersInAccessGroups(userinaccessgroup); db.SaveChanges(); } }
public MembershipUser CreateUser(string first_name, string last_name, string username, string password, string email) { using (SecurityDBEntities db = new SecurityDBEntities()) { Users user = new Users(); user.LOGIN = username; user.FIRST_NAME = first_name; user.LAST_NAME = last_name; user.EMAIL = email; user.PASSWORD_SALT = CreateSalt(); user.PASSWORD = CreatePasswordHash(password,user.PASSWORD_SALT); user.CREATE_DATE = DateTime.Now; user.IS_ACTIVATED = false; user.IS_LOCKED_OUT = false; user.LAST_LOCKED_OUT_DATE = DateTime.Now; user.LAST_LOGIN_DATE = DateTime.Now; db.AddToUsers(user); db.SaveChanges(); return GetUser(username); } }
/// <summary> /// Удаление у пользователю группы. /// </summary> /// <param name="uiag_id"></param> /// <returns></returns> public bool RemoveUserInAccessGroup(Int64 uiag_id) { try { using (SecurityDBEntities db = new SecurityDBEntities()) { UsersInAccessGroups deluaig = (from a in db.UsersInAccessGroups where (a.UIAG_ID == uiag_id) select a).First(); db.UsersInAccessGroups.DeleteObject(deluaig); db.SaveChanges(); return true; } } catch (Exception ex) { return false; // Ошибка пои удалении } }
/// <summary> /// Удаление пользователя по USER_ID /// </summary> /// <param name="user_id"></param> /// <returns></returns> public bool DeleteUser(Int64 user_id) { try { using (SecurityDBEntities db = new SecurityDBEntities()) { Users del_user = (from a in db.Users where (a.USER_ID == user_id) select a).First(); db.Users.DeleteObject(del_user); db.SaveChanges(); return true; } } catch (Exception ex) { return false; // Ошибка при удалении } }