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);
}
}
