public void Insert(CPost post) { try { WorkWithMeDataContext oDC = new WorkWithMeDataContext(); tblPost p = new tblPost(); p.Id = Id; p.OwnerUserId = OwnerUserId; p.TargetGroupId = TargetGroupId; p.Title = Title; p.Content = Content; p.IsSticky = IsSticky; p.IsDeleted = IsDeleted; p.TimeStamp = TimeStamp; p.EventTimeStamp = EventTimeStamp; oDC.tblPosts.InsertOnSubmit(p); oDC.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void Create() { try { WorkWithMeDataContext oDC = new WorkWithMeDataContext(); tblGroup g = new tblGroup(); g.Id = Id; g.Name = Name; g.Description = Description; g.GroupType = GroupType; g.OwnerGroupId = OwnerGroupId; g.CanPostDefault = CanPostDefault; g.CanInviteDefault = CanInviteDefault; g.CanDeleteDefault = CanDeleteDefault; g.GroupImgId = GroupImgId; oDC.tblGroups.InsertOnSubmit(g); oDC.SubmitChanges(); } catch (Exception ex) { throw ex; } }
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 Delete() { WorkWithMeDataContext oDC = new WorkWithMeDataContext(); tblPost post = (from p in oDC.tblPosts where p.Id == Id select p).FirstOrDefault(); oDC.tblPosts.DeleteOnSubmit(post); oDC.SubmitChanges(); }
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()) * { * tblGroup group = (from g in oDC.tblGroups where g.Id == Id select g).FirstOrDefault(); * * //group.Id = Id; * group.Description = Description; * group.GroupType = GroupType; * group.OwnerGroupId = OwnerGroupId; * //group.CanPostDefault = CanPostDefault; * // group.CanInviteDefault = CanInviteDefault; * // group.CanDeleteDefault = CanDeleteDefault; * * * oDC.SubmitChanges(); * } * } */ public void Delete() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { // tblGroup group = (from g in oDC.tblGroups where g.Id == Id select g).FirstOrDefault(); // oDC.tblGroups.DeleteOnSubmit(group); oDC.SubmitChanges(); } }
public void Delete() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblZip zip = (from z in oDC.tblZips where z.Id == Id select z).FirstOrDefault(); oDC.tblZips.DeleteOnSubmit(zip); oDC.SubmitChanges(); } }
public void Delete() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblUser user = (from u in oDC.tblUsers where u.Id == Id select u).FirstOrDefault(); oDC.tblUsers.DeleteOnSubmit(user); oDC.SubmitChanges(); } }
public void Delete() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblState state = (from s in oDC.tblStates where s.Id == Id select s).FirstOrDefault(); oDC.tblStates.DeleteOnSubmit(state); oDC.SubmitChanges(); } }
public void Delete() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblCity city = (from c in oDC.tblCities where c.Id == Id select c).FirstOrDefault(); oDC.tblCities.DeleteOnSubmit(city); oDC.SubmitChanges(); } }
public void Update() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblCity city = (from c in oDC.tblCities where c.Id == Id select c).FirstOrDefault(); city.Id = Id; city.CityName = CityName; oDC.SubmitChanges(); } }
public void Create() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblState s = new tblState(); s.Id = Guid.NewGuid(); s.StateName = StateName; oDC.tblStates.InsertOnSubmit(s); oDC.SubmitChanges(); } }
public void Update() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblGroupType grouptype = (from g in oDC.tblGroupTypes where g.Id == Id select g).FirstOrDefault(); grouptype.Id = Id; grouptype.Description = Description; oDC.SubmitChanges(); } }
public void Update() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblState state = (from s in oDC.tblStates where s.Id == Id select s).FirstOrDefault(); state.Id = Id; state.StateName = StateName; 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 Delete() { WorkWithMeDataContext oDC = new WorkWithMeDataContext(); tblPost post = (from p in oDC.tblPosts where p.Id == Id select p).FirstOrDefault(); oDC.tblPosts.DeleteOnSubmit(post); List <tblPost> replies = (from p in oDC.tblPosts where p.ReplyPostId == Id select p).ToList(); oDC.tblPosts.DeleteAllOnSubmit(replies); oDC.SubmitChanges(); }
public void Update() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblUser user = (from u in oDC.tblUsers where u.Id == Id select u).FirstOrDefault(); user.Username = Username; user.FirstName = FirstName; user.MiddleInitial = MiddleInitial; user.LastName = LastName; user.Zip = Zip; user.Address = Address; user.IsAddressPrivate = IsAddressPrivate; 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 Insert(CState state) { try { WorkWithMeDataContext oDC = new WorkWithMeDataContext(); tblState s = new tblState(); s.Id = Id; s.StateName = StateName; oDC.tblStates.InsertOnSubmit(s); oDC.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void Create() { try { WorkWithMeDataContext oDC = new WorkWithMeDataContext(); tblCity c = new tblCity(); c.Id = Guid.NewGuid(); c.CityName = CityName; oDC.tblCities.InsertOnSubmit(c); oDC.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void Update() { WorkWithMeDataContext oDC = new WorkWithMeDataContext(); tblPost post = (from p in oDC.tblPosts where p.Id == Id select p).FirstOrDefault(); post.Id = Id; post.OwnerUserId = OwnerUserId; post.TargetGroupId = TargetGroupId; post.Title = Title; post.Content = Content; post.IsSticky = IsSticky; post.IsDeleted = IsDeleted; post.TimeStamp = TimeStamp; post.EventTimeStamp = EventTimeStamp; oDC.SubmitChanges(); }
public void Create() { try { WorkWithMeDataContext oDC = new WorkWithMeDataContext(); tblZip z = new tblZip(); z.Id = Id; oDC.tblZips.InsertOnSubmit(z); oDC.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void Insert(CGroupType grouptype) { try { WorkWithMeDataContext oDC = new WorkWithMeDataContext(); tblGroupType g = new tblGroupType(); g.Id = Id; g.Description = Description; oDC.tblGroupTypes.InsertOnSubmit(g); oDC.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public void Update() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblGroup group = (from g in oDC.tblGroups where g.Id == Id select g).FirstOrDefault(); group.Id = Id; group.Name = Name; group.Description = Description; group.GroupType = GroupType; group.OwnerGroupId = OwnerGroupId; group.CanPostDefault = CanPostDefault; group.CanInviteDefault = CanInviteDefault; group.CanDeleteDefault = CanDeleteDefault; group.GroupImgId = GroupImgId; 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(); } }