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