public void GetFriend(Account account)
{
// List<Account> Acfriend = new List<Account>();
using (SPKTDataContext dc = conn.GetContext())
{
IEnumerable <Friend> fi = from f in dc.Friends where f.MyFriendAccountID == account.AccountID || f.AccountID == account.AccountID select f;
fi.ToList();
foreach (Friend i in fi)
{
FriendMutual mf = new FriendMutual();
if (i.AccountID == account.AccountID)
{
mf.AccountID = i.AccountID;
mf.AcMyFriendID = i.MyFriendAccountID;
mf.AcMutual = 0;
}
if (i.MyFriendAccountID == account.AccountID)
{
mf.AccountID = i.MyFriendAccountID;
mf.AcMyFriendID = i.AccountID;
mf.AcMutual = 0;
}
saveMutual(mf);
}
}
}
public void saveMutual(FriendMutual fm)
{
using (SPKTDataContext dc = conn.GetContext())
{
if (fm.FriendMutualID > 0)
{
dc.FriendMutuals.Attach(fm, true);
}
else
{
dc.FriendMutuals.InsertOnSubmit(fm);
}
dc.SubmitChanges();
}
}
public void saveMutual(FriendMutual fm)
{
using (SPKTDataContext dc = conn.GetContext())
{
if (fm.FriendMutualID > 0)
{
dc.FriendMutuals.Attach(fm, true);
}
else
{
dc.FriendMutuals.InsertOnSubmit(fm);
}
dc.SubmitChanges();
}
}
public void GetFriend(Account account)
{
// List<Account> Acfriend = new List<Account>();
using (SPKTDataContext dc = conn.GetContext())
{
IEnumerable<Friend> fi = from f in dc.Friends where f.MyFriendAccountID == account.AccountID || f.AccountID == account.AccountID select f;
fi.ToList();
foreach (Friend i in fi)
{
FriendMutual mf = new FriendMutual();
if (i.AccountID == account.AccountID)
{
mf.AccountID = i.AccountID;
mf.AcMyFriendID = i.MyFriendAccountID;
mf.AcMutual = 0;
}
if (i.MyFriendAccountID == account.AccountID)
{
mf.AccountID = i.MyFriendAccountID;
mf.AcMyFriendID = i.AccountID;
mf.AcMutual = 0;
}
saveMutual(mf);
}
}
}
