public static User CheckPasswordAndRole(string email, string password)
{
User user;
using (var db = new PeopleDBEntities())
{
try
{
user = db.User.FirstOrDefault(u => u.Email == email);
if (user != null)
{
var tempPassword = Crypto.SHA256(password);
if (user.Password == tempPassword)
{
return user;
}
else
{
user = null;
}
}
}
catch (Exception)
{
throw;
}
}
return user;
}
public override string[] GetRolesForUser(string email)
{
string[] role = new string[] { };
using (PeopleDBEntities _db = new PeopleDBEntities())
{
try
{
// Получаем пользователя
User user = (from u in _db.User
where u.Email == email
select u).FirstOrDefault();
if (user != null)
{
// получаем роль
var userRole = _db.Role.Find(user.RoleId);
if (userRole != null)
{
role = new string[] { userRole.Name };
}
}
}
catch
{
role = new string[] { };
}
}
return role;
}
public void RejectFriendship(Guid userId, Guid friendId)
{
using (var db = new PeopleDBEntities())
{
//TODO Вывод в лог
var accenpt = db.FriendRelationship.Where(f => f.UserId == userId && f.FriendId == friendId && f.status == false).Delete();
var accenpti = db.FriendRelationship.Where(f => f.UserId == friendId && f.FriendId == userId && f.status == false).Delete();
db.SaveChanges();
}
}
public void AcceptFriendship(Guid userId, Guid friendId)
{
using (var db = new PeopleDBEntities())
{
//TODO Вывод в лог
var accenpt = db.FriendRelationship.Where(f => f.UserId == userId && f.FriendId == friendId && f.status == false).Update(f => new FriendRelationship{ status = true});
var accenptі = db.FriendRelationship.Where(f => f.UserId == friendId && f.FriendId == userId && f.status == false).Update(f => new FriendRelationship { status = true });
db.SaveChanges();
}
}
public bool AddUserToFriend(Guid userId, Guid friendId)
{
bool result = false;
using (var db = new PeopleDBEntities())
{
var check = (from friend in db.FriendRelationship
.Where(f => (f.FriendId == friendId && f.UserId == userId) || (f.FriendId == userId && f.UserId == friendId))
select friend).ToList();
if (check.Count == 0)
{
var entity1 = new FriendRelationship
{
Id = Guid.NewGuid(),
FriendId = friendId,
UserId = userId,
status = false
};
var entity2 = new FriendRelationship
{
Id = Guid.NewGuid(),
FriendId = userId,
UserId = friendId,
status = false
};
try
{
db.FriendRelationship.Add(entity1);
db.FriendRelationship.Add(entity2);
db.SaveChanges();
result = true;
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
}
return result;
}
public IEnumerable<User> GetFriends(Guid userId)
{
IEnumerable<User> friends = null;
using (var db = new PeopleDBEntities())
{
var friendList = (from f in db.FriendRelationship
where f.UserId == userId && f.status == true
join u in db.User on f.FriendId equals u.Id
select u).ToList();
friends = friendList;
}
return friends;
}
public IEnumerable<User> GetNotifications(Guid userId)
{
IEnumerable<User> notify;
using (var db = new PeopleDBEntities())
{
var notifications = (from n in db.FriendRelationship
where userId == n.UserId && n.status == false
join u in db.User on n.FriendId equals u.Id
select u).ToList();
notify = notifications;
}
return notify;
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
User user = null;
using (var db = new PeopleDBEntities())
{
try
{
HttpCookie authCookie = filterContext.HttpContext.Request.Cookies[FormsAuthentication.FormsCookieName];
FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value);
string email = ticket.Name;
user = db.User.FirstOrDefault(e => e.Email == email);
}
catch (NullReferenceException)
{
new HttpException(403, "Forbidden");
}
}
}
public void AddUserToDb(CustomUser model)
{
using (var db = new PeopleDBEntities())
{
var entity = new User()
{
Id = Guid.NewGuid(),
FirstName = model.FirstName,
LastName = model.LastName,
Age = model.Age,
City = model.City,
AboutUser = model.Description,
Email = model.Email,
Password = Crypto.SHA256(model.Password),
Gender = CheckGender(model.Sex),
ImageBase64 = model.ImageBase64,
ImageContentType = model.ImageContentType,
RoleId = GetRole("user")
};
try
{
db.User.Add(entity);
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
}
protected override void Initialize(RequestContext requestContext)
{
ControllerContext = new ControllerContext(requestContext, this);
using (var db = new PeopleDBEntities())
{
try
{
HttpCookie authCookie = requestContext.HttpContext.Request.Cookies[FormsAuthentication.FormsCookieName];
FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value);
string email = ticket.Name;
_user = db.User.FirstOrDefault(e => e.Email == email);
}
catch (NullReferenceException)
{
new HttpException(403, "Forbidden");
}
}
}
public void RemoveUserFromFriend(Guid userId, Guid friendId)
{
using (var db = new PeopleDBEntities())
{
var accenpt = db.FriendRelationship.Where(f => f.UserId == userId && f.FriendId == friendId && f.status == true).Delete();
var accenptі = db.FriendRelationship.Where(f => f.UserId == friendId && f.FriendId == userId && f.status == true).Delete();
db.SaveChanges();
}
}
//public IEquatable<CustomUser> GetAllFriends()
//{
//}
//TODO life dropdown list
public IEnumerable<User> GetSeekingUser(string name)
{
IEnumerable<User> usersList;
using (var entity = new PeopleDBEntities())
{
usersList = (from users in entity.User
where (users.FirstName + users.LastName).Contains(name)
select users).ToList();
}
return usersList;
}
public Guid GetRole(string role)
{
var roleId = new Guid();
using (var db = new PeopleDBEntities())
{
((IObjectContextAdapter)db).ObjectContext.CommandTimeout = 180;
try
{
var user = db.Role.FirstOrDefault(u => u.Name == role);
if (user != null)
{
roleId = user.RoleId;
}
}
catch (Exception)
{
throw;
}
}
return roleId;
}
public bool CheckEmail(string email)
{
User emailDb;
bool flag = false;
using (var db = new PeopleDBEntities())
{
emailDb = db.User.FirstOrDefault(u => u.Email.ToLower() == email.ToLower());
}
if (emailDb == null)
{
flag = true;
}
return flag;
}
public override bool IsUserInRole(string email, string roleName)
{
bool outputResult = false;
// Находим пользователя
using (PeopleDBEntities _db = new PeopleDBEntities())
{
try
{
// Получаем пользователя
User user = (from u in _db.User
where u.Email == email
select u).FirstOrDefault();
if (user != null)
{
// получаем роль
var userRole = _db.Role.Find(user.RoleId);
//сравниваем
if (userRole != null && userRole.Name == roleName)
{
outputResult = true;
}
}
}
catch
{
outputResult = false;
}
}
return outputResult;
}
