public void Delete()
{
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
tblUserContact contact = (from c in oDC.tblUserContacts where c.Id == Id select c).FirstOrDefault();
oDC.tblUserContacts.DeleteOnSubmit(contact);
oDC.SubmitChanges();
}
}
public void Update()
{
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
tblUserContact contact = (from c in oDC.tblUserContacts where c.Id == Id select c).FirstOrDefault();
contact.Id = Id;
contact.OwnerUserId = OwnerUserId;
contact.TargetUserId = TargetUserId;
contact.InviteStatusId = InviteStatusId;
tblInviteStatus inviteStatus = (from i in oDC.tblInviteStatus where i.Id == InviteStatusId select i).FirstOrDefault();
InviteStatusDescription = inviteStatus.Description;
tblUser user = (from u in oDC.tblUsers where u.Id == OwnerUserId select u).FirstOrDefault();
OwnerUserFullName = user.FirstName + " " + user.LastName;
tblUser targetUser = (from u in oDC.tblUsers where u.Id == TargetUserId select u).FirstOrDefault();
TargetUserFullName = targetUser.FirstName + " " + targetUser.LastName;
oDC.SubmitChanges();
}
}