public override IList<Group> GetAllGroups(string user)
{
var context = new FriendsEntities();
var list =
context.tblFriends_Groups.Where(item => item.CreatedBy == user).OrderBy(item => item.Name).ToList();
return Convert(list);
}
public override IList<Friend> GetFriends(string user)
{
var context = new FriendsEntities();
var list =
context.tblFriends_Friends.Include("Groups").Where(item => item.CreatedBy == user).OrderBy(
item => item.Letter).ToList();
return Convert(list);
}
public override void DeleteGroup(int id)
{
var context = new FriendsEntities();
var obj = context.tblFriends_Groups.Include("Friends").Where(item => item.Id == id).FirstOrDefault();
if (obj != null)
{
obj.Friends.Clear();
context.DeleteObject(obj);
context.SaveChanges();
}
}
public override int InsertFriend(Friend friend)
{
var context = new FriendsEntities();
var obj = new tblFriends_Friends();
context.AddTotblFriends_Friends(obj);
friend.CopyToObject(obj);
if (friend.Groups != null)
{
foreach (var group in friend.Groups)
{
var item = new tblFriends_Groups {Id = group.Id};
context.AttachTo("tblFriends_Groups", item);
obj.Groups.Add(item);
}
}
context.SaveChanges();
return obj.Id;
}
public override void UpdateFriend(Friend friend)
{
var context = new FriendsEntities();
var obj = context.tblFriends_Friends.Include("Groups").Where(item => item.Id == friend.Id).FirstOrDefault();
if (obj != null)
{
obj.Groups.Clear();
friend.CopyToObject(obj);
if (friend.Groups.Count > 0)
{
var groups =
context.tblFriends_Groups.Where(
Utils.BuildContainsExpression<tblFriends_Groups, int>(item => item.Id,
friend.Groups.Select(item => item.Id)));
foreach (var group in groups)
{
obj.Groups.Add(group);
}
}
context.SaveChanges();
}
}
public override int InsertGroup(Group group)
{
var context = new FriendsEntities();
var obj = new tblFriends_Groups();
group.CopyToObject(obj);
context.AddTotblFriends_Groups(obj);
context.SaveChanges();
return obj.Id;
}
public override Group GetGroupById(int id)
{
var context = new FriendsEntities();
var obj = context.tblFriends_Groups.Where(item => item.Id == id).FirstOrDefault();
return Convert(obj);
}
public override void UpdateGroup(Group group)
{
var context = new FriendsEntities();
var obj = new tblFriends_Groups {Id = group.Id};
context.AttachTo("tblFriends_Groups", obj);
group.CopyToObject(obj);
context.SaveChanges();
}