public void Delete() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblInviteStatus invitestatus = (from i in oDC.tblInviteStatus where i.Id == Id select i).FirstOrDefault(); oDC.tblInviteStatus.DeleteOnSubmit(invitestatus); oDC.SubmitChanges(); } }
public void Update() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblInviteStatus invitestatus = (from i in oDC.tblInviteStatus where i.Id == Id select i).FirstOrDefault(); invitestatus.Id = Id; invitestatus.Description = Description; oDC.SubmitChanges(); } }
public void Create() { try { WorkWithMeDataContext oDC = new WorkWithMeDataContext(); tblInviteStatus i = new tblInviteStatus(); i.Id = Id; i.Description = Description; oDC.tblInviteStatus.InsertOnSubmit(i); oDC.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void LoadInvitesForUser(Guid id) { Clear(); using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { List <tblUserContact> contacts = (from c in oDC.tblUserContacts where c.TargetUserId == id && c.InviteStatusId == 0 select c).ToList(); foreach (tblUserContact c in contacts) { tblInviteStatus inviteStatus = (from i in oDC.tblInviteStatus where i.Id == c.InviteStatusId select i).FirstOrDefault(); string inviteStatusDescription = inviteStatus.Description; tblUser user = (from u in oDC.tblUsers where u.Id == c.OwnerUserId select u).FirstOrDefault(); string ownerUserFullName = user.FirstName + " " + user.LastName; tblUser targetUser = (from u in oDC.tblUsers where u.Id == c.TargetUserId select u).FirstOrDefault(); string targetUserFullName = targetUser.FirstName + " " + targetUser.LastName; Add(new CUserContact(c.Id, c.OwnerUserId, c.TargetUserId, c.InviteStatusId, ownerUserFullName, targetUserFullName, inviteStatusDescription)); } } }
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(); } }