//показывает, связан ли пользователь с данной ролью
public override bool IsUserInRole(string username, string roleName)
{
bool outputResult = false;
// Находим пользователя
using (EntityDataModel db = new EntityDataModel())
{
try
{
// Получаем пользователя
tbl_1_User user = (from u in db.tbl_1_User
where u.Login == username
select u).FirstOrDefault();
if (user != null)
{
// получаем роль
tbl_2_Roles userRole = db.tbl_2_Roles.Find(user.RoleId);
//сравниваем
if (userRole != null && userRole.RoleName == roleName)
{
outputResult = true;
}
}
}
catch
{
outputResult = false;
}
}
return(outputResult);
}
//возвращает роль пользователя
public override string[] GetRolesForUser(string login)
{
string[] role = new string[] { };
using (EntityDataModel db = new EntityDataModel())
{
try
{
// Получаем пользователя
tbl_1_User user = (from u in db.tbl_1_User
where u.Login == login
select u).FirstOrDefault();
if (user != null)
{
// получаем роль
tbl_2_Roles userRole = db.tbl_2_Roles.Find(user.RoleId);
if (userRole != null)
{
role = new string[] { userRole.RoleName };
}
}
}
catch
{
role = new string[] { };
}
}
return(role);
}
// сохраняем инфу по зарегистрированному пользователю
private void SaveOrganization(int idOrganization)
{
int userId = WebSecurity.CurrentUserId;
tbl_1_User modified_user = db.tbl_1_User.Where(p => p.UserId == userId).FirstOrDefault();
modified_user.OrganizationId = idOrganization;
db.SaveChanges();
}
public ActionResult ProfileUser(string returnUrl)
{
int userId = WebSecurity.CurrentUserId;
tbl_1_User user = db.tbl_1_User.Where(p => p.UserId == userId).FirstOrDefault();
var spisok = db.tbl_1_User.Where(r => r.UserId == userId);
return(View(spisok.ToList()));
}
public ActionResult DeleteListUser(int id)
{
tbl_1_User user = db.tbl_1_User.Find(id);
db.tbl_1_User.Remove(user);
db.SaveChanges();
return(RedirectToAction("ViewListUser"));
}
public ActionResult EditListUser(int id)
{
tbl_1_User user = db.tbl_1_User.Find(id);
SelectList roles = new SelectList(db.tbl_2_Roles, "RoleId", "RoleName", user.RoleId);
ViewBag.tbl_2_Roles = roles;
return(View(user));
}
public tbl_1_User Login(string userName)
{
tbl_1_User retUser = Repository.Users.FirstOrDefault(p => string.Compare(p.Email, userName, true) == 0);
if (retUser != null)
{
CreateCookie(userName);
}
return(retUser);
}
public tbl_1_User Login(string userName, string Password, bool isPersistent)
{
tbl_1_User retUser = Repository.Login(userName, Password);
if (retUser != null)
{
CreateCookie(userName, isPersistent);
}
return(retUser);
}
public ActionResult EditProfileUser(tbl_1_User user)
{
if (ModelState.IsValid)
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ProfileUser"));
}
SelectList roles = new SelectList(db.tbl_2_Roles, "RoleId", "RoleName");
ViewBag.tbl_2_Roles = roles;
return(View(user));
}
public ActionResult EditProfileUser()
{
int userId = WebSecurity.CurrentUserId;
tbl_1_User user = db.tbl_1_User.Find(userId);
if (user == null)
{
return(HttpNotFound());
}
SelectList roles = new SelectList(db.tbl_2_Roles, "RoleId", "RoleName", user.RoleId);
ViewBag.tbl_2_Roles = roles;
return(View(user));
}
public ActionResult EditProfileOrganization()
{
int userId = WebSecurity.CurrentUserId;
tbl_1_User user = db.tbl_1_User.Where(p => p.UserId == userId).FirstOrDefault();
if (user.OrganizationId == null)
{
return(RedirectToAction("AddInfOrganization", "UserAccount"));
}
else
{
var id = user.OrganizationId;
tbl_5_Organization organization = db.tbl_5_Organization.Where(p => p.OrganizationId == id).FirstOrDefault();
return(View(organization));
}
}
private void SaveCity(int idCity)
{
int userId = WebSecurity.CurrentUserId;
tbl_1_User modified_user = db.tbl_1_User.Where(p => p.UserId == userId).FirstOrDefault();
if (modified_user.RoleId == null)
{
tbl_2_Roles roles = db.tbl_2_Roles.FirstOrDefault(p => p.RoleName == "User");
modified_user.RoleId = roles.RoleId;
}
else
{
modified_user.CityId = idCity;
}
db.SaveChanges();
}
public ActionResult EditProfileCity()
{
int userId = WebSecurity.CurrentUserId;
tbl_1_User user = db.tbl_1_User.Where(p => p.UserId == userId).FirstOrDefault();
if (user.CityId == null)
{
AddInfCity();
return(RedirectToAction("ProfileUser"));
}
else
{
var id = user.CityId;
tbl_6_City city = db.tbl_6_City.Where(p => p.CityId == id).FirstOrDefault();
return(View(city));
}
}
public ActionResult CreateNewUser(tbl_1_User user)
{
if (ModelState.IsValid)
{
try
{
db.tbl_1_User.Add(user);
db.SaveChanges();
//return RedirectToAction("ViewListUser");
return(RedirectToAction("AddInfOrganization", "UserAccount"));
}
catch (MembershipCreateUserException e)
{
ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
}
}
SelectList roles = new SelectList(db.tbl_2_Roles, "RoleId", "RoleName");
ViewBag.tbl_2_Roles = roles;
return(View(user));
}
