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