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