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