public AdminPanelViewModel ReceiveUserById(int id) { try { User user = (from u in db.User where u.id == id select u).First(); int userinrole = (from uir in db.UserInRole where user.id == uir.User_id select uir.Role_id).First(); var adminuser = new AdminPanelViewModel() { id = user.id, First_Name = user.First_Name, Last_Name = user.Last_Name, Email = user.Email, Reg_Date = user.Reg_Date, Last_Date = user.Last_Date, Delete_Date = user.Delete_Date, Status = user.Status, Role = (from r in db.Role where r.id == userinrole select r.Role_Name).First().ToString() }; return(adminuser); } catch (Exception ex) { logger.Error(ex.Message + " for user:" + auth.curUser.ToString()); return(null); } }
public IEnumerable <AdminPanelViewModel> ReceiveUsers() { try { List <AdminPanelViewModel> adminusers = new List <AdminPanelViewModel>(); IEnumerable <User> users = (from u in db.User where u.id != auth.curUser select u); var userinrole = (from uir in db.UserInRole where uir.User_id != auth.curUser select uir).ToList(); foreach (User u in users) { var adminuser = new AdminPanelViewModel() { id = u.id, First_Name = u.First_Name, Last_Name = u.Last_Name, Email = u.Email, Reg_Date = u.Reg_Date, Last_Date = u.Last_Date, Delete_Date = u.Delete_Date, Status = u.Status, Role = (from r in db.Role where r.id == (from d in userinrole where u.id == d.User_id select d.Role_id).First() select r.Role_Name).First().ToString() }; adminusers.Add(adminuser); } return(adminusers); } catch (Exception ex) { logger.Error(ex.Message + " for user:" + auth.curUser.ToString()); return(null); } }
public void Restore(AdminPanelViewModel userToReStore) { try { User user = (from u in db.User where u.id == userToReStore.id select u).First(); user.Status = 0; // устанавливаем статус аккаунта на 0 (активен) user.Delete_Date = DateTime.MaxValue; db.SubmitChanges(); } catch (Exception ex) { logger.Error(ex.Message + " for user:" + userToReStore.id.ToString()); } }
public void Freeze(AdminPanelViewModel userToDel) { try { User user = (from u in db.User where u.id == userToDel.id select u).First(); user.Status = 1; // устанавливаем статус аккаунта на 1 (удалён), для последубщей возможности его восстановления пользователем user.Delete_Date = DateTime.Now; db.SubmitChanges(); } catch (Exception ex) { logger.Error(ex.Message + " for user:" + userToDel.id.ToString()); } }
public void SaveChanges(AdminPanelViewModel user) { try { User us = (from u in db.User where user.id == u.id select u).First(); us.First_Name = user.First_Name; us.Last_Name = user.Last_Name; us.Email = user.Email; db.SubmitChanges(); User_in_Role uir = (from i in db.UserInRole where user.id == i.User_id select i).First(); uir.Role_id = (from r in db.Role where r.Role_Name == user.Role select r.id).First(); db.SubmitChanges(); } catch (Exception ex) { logger.Error(ex.Message + " for user:" + user.id); } }