public bool Login(string username, string password)
{
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
spDoLoginResult result = oDC.spDoLogin(username, password).FirstOrDefault();
if (result.Id != null)
{
tblUser user = (from u in oDC.tblUsers where u.Id == result.Id select u).FirstOrDefault();
Id = user.Id;
Username = user.Username;
FirstName = user.FirstName;
MiddleInitial = user.MiddleInitial;
LastName = user.LastName;
Zip = user.Zip;
Address = user.Address;
IsAddressPrivate = user.IsAddressPrivate;
Email = user.EmailAddress;
UserImgId = user.UserImgId;
return(true);
}
else
{
return(false);
}
}
}
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 LoadData(int userImgId)
{
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
spGetImageDataResult result = oDC.spGetImageData(userImgId).FirstOrDefault();
Content = result.ImageContent.ToArray();
}
}
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())
{
tblCity city = (from c in oDC.tblCities where c.Id == Id select c).FirstOrDefault();
oDC.tblCities.DeleteOnSubmit(city);
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())
{
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())
{
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())
{
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 string GetCity(Guid cityId)
{
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
tblCity city = (from c in oDC.tblCities where c.Id == Id select c).FirstOrDefault();
CityName = city.CityName;
return(CityName);
}
}
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 int Create()
{
try
{
WorkWithMeDataContext oDC = new WorkWithMeDataContext();
return(oDC.spCreatePost(OwnerUserId, TargetGroupId, ReplyPostId, Title, Content, IsSticky, EventTimeStamp));
}
catch (Exception ex)
{
throw ex;
}
}
public void Load()
{
Clear();
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
List <tblGroupType> results = (from g in oDC.tblGroupTypes select g).ToList();
foreach (tblGroupType g in results)
{
Add(new CGroupType(g.Id, g.Description));
}
}
}
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())
{
tblInviteStatus invitestatus = (from i in oDC.tblInviteStatus where i.Id == Id select i).FirstOrDefault();
invitestatus.Id = Id;
invitestatus.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 SearchForUser(string searchString, Guid originUserId)
{
Clear();
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
List <spSearchUserResult> results = oDC.spSearchUser(searchString, originUserId).ToList();
foreach (spSearchUserResult r in results)
{
Add(new CUser(r.Id, r.Username, r.FirstName, r.MiddleInitial, r.LastName, r.EmailAddress));
}
}
}
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 Load()
{
Clear();
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
List <tblUser> users = (from u in oDC.tblUsers select u).ToList();
foreach (tblUser user in users)
{
Add(new CUser(user.Id, user.Username, user.FirstName, user.MiddleInitial, user.LastName, user.Zip, user.Address, user.IsAddressPrivate, user.EmailAddress, user.UserImgId));
}
}
}
public void LoadRepliesForPost(Guid postId)
{
Clear();
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
List <spGetRepliesForPostResult> list = oDC.spGetRepliesForPost(postId).ToList();
foreach (spGetRepliesForPostResult item in list)
{
CPost post = new CPost(item.Id, item.OwnerUserId, item.TargetGroupId, item.ReplyPostId, item.Title, item.Content, item.OwnerFullName, item.IsSticky, item.IsDeleted, item.TimeStamp, item.EventTimeStamp);
Add(post);
}
}
}
public void GetInfo()
{
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
tblZip zip = (from z in oDC.tblZips where z.Id == Zip select z).FirstOrDefault();
tblCity city = (from c in oDC.tblCities where c.Id == zip.CityId select c).FirstOrDefault();
tblState state = (from s in oDC.tblStates where s.Id == zip.StateId select s).FirstOrDefault();
CityName = city.CityName;
StateName = state.StateName;
}
}
public bool Create(string password, string city, string state, ref string response)
{
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
if (oDC.spCreateUser(Username, password, FirstName, MiddleInitial, LastName, Zip, Address, city, state, IsAddressPrivate, Email, ref response) == 0)
{
return(false);
}
else
{
return(true);
}
}
}
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 bool Delete(string username, string password)
{
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
int result = oDC.spDeleteUser(username, password);
if (result == 0)
{
return(false);
}
else
{
return(true);
}
}
}
public void Load()
{
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
tblUser user = (from u in oDC.tblUsers where u.Id == Id select u).FirstOrDefault();
Username = user.Username;
FirstName = user.FirstName;
MiddleInitial = user.MiddleInitial;
LastName = user.LastName;
Zip = user.Zip;
Address = user.Address;
IsAddressPrivate = user.IsAddressPrivate;
Email = user.EmailAddress;
UserImgId = user.UserImgId;
}
}
public bool Update(string password, string city, string state, ref string response, string imageName, string imageSize, byte[] imageContent)
{
using (WorkWithMeDataContext oDC = new WorkWithMeDataContext())
{
if (oDC.spUpdateUserWithImage(Id, Username, password, FirstName, MiddleInitial, LastName, Zip, Address, city, state, IsAddressPrivate, Email, imageName, imageSize, imageContent, ref response) == 0)
{
return(false);
}
else
{
tblUser user = (from u in oDC.tblUsers where u.Id == Id select u).FirstOrDefault();
UserImgId = user.UserImgId;
return(true);
}
}
}
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();
}
}
