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