public void InsertContactList(ContactList newcontact)
{
int? RecipientID = GetUserIDByEmail(newcontact.RecipientEmailAddress);
newcontact.RecipientUserID = RecipientID;
dbmeals.ContactLists.Add(newcontact);
}
public int FriendIDUpdate(ContactList cls)
{
int intResult = 0;
try
{
ContactList objTblUser = new ContactList();
objTblUser.UserID = cls.UserID;
objTblUser.RecipientUserID = cls.RecipientUserID;
objTblUser.RequestAccepted = 1;
dbmeals.ContactLists.Add(objTblUser);
intResult = dbmeals.SaveChanges();
return intResult;
}
catch (Exception ex)
{
return intResult;
}
}
private void InsertRequestInfo(int userid, string SenderEmailAddress, string EmailTo)
{
try
{
ContactList ct = new ContactList();
ct.UserID = userid;
ct.SenderEmailAddress = SenderEmailAddress;
ct.RecipientEmailAddress = EmailTo;
dbmeals.ContactLists.Add(ct);
dbmeals.SaveChanges();
}
catch (Exception ex)
{
string message = ex.Message;
}
}
public int CheckFriend(ContactList cls)
{
var objUsrTbl = (from a in dbmeals.ContactLists
where a.UserID == cls.UserID && a.RecipientUserID == cls.RecipientUserID
select a).Count();
return objUsrTbl;
}
