public tblPost AddPost(tblPost post) { try { using (BetweenUsEntities context = new BetweenUsEntities()) { if (post.PostID == 0) { tblPost newPost = new tblPost { PostID = post.PostID, PostText = post.PostText, DateTimePost = post.DateTimePost, VisiblePost = post.VisiblePost, UserPost = post.UserPost }; context.tblPosts.Add(newPost); context.SaveChanges(); post.PostID = newPost.PostID; return(post); } else { return(null); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public List <Tuple <string, string, string, string, DateTime> > GetMyPost(int id) { try { using (BetweenUsEntities context = new BetweenUsEntities()) { List <Tuple <string, string, string, string, DateTime> > list = new List <Tuple <string, string, string, string, DateTime> >(); list = ( from a in context.tblPosts join c in context.tblUsers on a.UserPost equals c.UserID where c.UserID == id orderby a.DateTimePost descending select(new { a.PostText, c.UserName, c.UserSurname, c.UserUsername, a.DateTimePost }) ) .AsEnumerable() .Select(t => new Tuple <string, string, string, string, DateTime>(t.PostText, t.UserName, t.UserSurname, t.UserUsername, t.DateTimePost)) .ToList(); return(list); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public tblUser AddUser(tblUser user) { try { using (BetweenUsEntities context = new BetweenUsEntities()) { if (user.UserID == 0) { tblUser newUser = new tblUser { UserID = user.UserID, UserName = user.UserName, UserSurname = user.UserSurname, UserUsername = user.UserUsername, UserPassword = user.UserPassword, DateOfBirth = user.DateOfBirth, VisibleDate = user.VisibleDate, Gender = user.Gender, VisibleGender = user.VisibleGender }; context.tblUsers.Add(newUser); context.SaveChanges(); user.UserID = newUser.UserID; return(user); } else { tblUser userToEdit = (from r in context.tblUsers where r.UserID == user.UserID select r).First(); userToEdit.UserID = user.UserID; userToEdit.UserName = user.UserName; userToEdit.UserSurname = user.UserSurname; userToEdit.UserUsername = user.UserUsername; userToEdit.UserPassword = user.UserPassword; userToEdit.DateOfBirth = user.DateOfBirth; userToEdit.VisibleDate = user.VisibleDate; userToEdit.Gender = user.Gender; userToEdit.VisibleGender = user.VisibleGender; context.SaveChanges(); return(user); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
/// <summary> /// Gets all posts from view vwPost in database. /// </summary> /// <returns></returns> public List <vwPost> GetAllPosts() { try { using (BetweenUsEntities context = new BetweenUsEntities()) { return((from l in context.vwPosts select l).ToList()); } } catch { return(null); } }
/// <summary> /// Adds new post to tblPost in database. /// </summary> /// <param name="account"></param> /// <param name="text"></param> public void Post(tblAccount account, string text) { using (BetweenUsEntities context = new BetweenUsEntities()) { tblPost post = new tblPost { AccountID = account.AccountID, Content = text, PostTime = DateTime.Now, LikesNumber = 0 }; context.tblPosts.Add(post); context.SaveChanges(); } }
/// <summary> /// Adds new account to a database table. /// </summary> /// <param name="account"></param> public void AddAccount(tblAccount account) { using (BetweenUsEntities context = new BetweenUsEntities()) { tblAccount newAccount = new tblAccount { FirstName = account.FirstName, LastName = account.LastName, Gender = account.Gender, UserName = account.UserName, Pass = account.Pass }; context.tblAccounts.Add(newAccount); context.SaveChanges(); } }
public List <tblUser> GetAllUserSurname(string surname) { try { using (BetweenUsEntities context = new BetweenUsEntities()) { List <tblUser> list = new List <tblUser>(); list = (from e in context.tblUsers where e.UserSurname == surname orderby e.UserUsername ascending select e).ToList(); return(list); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public tblUser GetAllUserID(int ID) { try { using (BetweenUsEntities context = new BetweenUsEntities()) { tblUser user = (from e in context.tblUsers where e.UserID == ID select e).First(); return(user); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// Checks if account with username and password exists in tblAccount in database BetweenUs. /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public bool IsUser(string username, string password, out tblAccount account) { try { using (BetweenUsEntities context = new BetweenUsEntities()) { tblAccount accountToLogIn = (from a in context.tblAccounts where a.UserName == username && a.Pass == password select a).First(); account = accountToLogIn; return(true); } } catch { account = null; return(false); } }
public tblUser GetUserUsername(string username) { try { using (BetweenUsEntities context = new BetweenUsEntities()) { string usernameFromDB = (from e in context.tblUsers where e.UserUsername == username select e.UserUsername).FirstOrDefault(); if (username == usernameFromDB) { return((from e in context.tblUsers where e.UserUsername == username select e).FirstOrDefault()); } return(null); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public void Like(vwPost post, tblAccount account) { using (BetweenUsEntities context = new BetweenUsEntities()) { try { tblLike like = (from l in context.tblLikes where l.PostID == post.PostID && l.AccountID == account.AccountID select l).First(); MessageBox.Show("You already like this post"); } catch { tblLike like = new tblLike { PostID = post.PostID, AccountID = account.AccountID }; context.tblLikes.Add(like); tblPost postToLike = (from p in context.tblPosts where p.PostID == post.PostID select p).First(); postToLike.LikesNumber++; context.SaveChanges(); } } }