public void SignUp() { using (var db = new DatabaseBlog()) { var user = new User(); user.Username = Username; user.Password = Password; user.Email = Email; user.Country = Country; user.Userrole = Role; if (UserService.CheckEmail(Email) == true) { ErrorMessage = "The email is alredy taken"; Email = "-"; } else { if (UserService.CheckUsername(Username) == true) { ErrorMessage = "The Username is alredy Taken"; Username = "******"; } else { db.Users.Add(user); db.SaveChanges(); } } } }
public void CreateComment(int postid) { using (var db = new DatabaseBlog()) { var user = db.Users.Find(Convert.ToInt32(UserService.GetCurrentUserId())); var post = db.Posts.Find(postid); var comm = new Comment(); comm.comment = CommentText ?? "no"; comm.UserID = user.UserID; comm.Username = user.Username; comm.Date = DateTime.Now; if (comm.comment == "no") { CommentErrorColor = "red"; CommentError = "You can't publish an empty comment."; } else { post.Comment.Add(comm); db.SaveChanges(); post.CommentCount = CommentService.CommentCount(postid); db.SaveChanges(); CommentText = null; CommentErrorColor = "green"; CommentError = ""; CommentService.LoadComments(postid, Comments); PostService.LoadPost(Posts); } } }
public string GetCreatorName(int userid) { using (var db = new DatabaseBlog()) { var user = db.Users.Find(userid); return(user.Username.ToString()); } }
public string GetCreatorName() { using (var db = new DatabaseBlog()) { var user = db.Users.Find(Convert.ToInt32(Context.Parameters["Id"])); return(user.Username); } }
public void DeleteUser(int id) { using (var db = new DatabaseBlog()) { var user = db.Users.Find(id); db.Users.Remove(user); db.SaveChanges(); UserService.LoadUser(Users); } }
public void ShowChangeCategory(int id) { using (var db = new DatabaseBlog()) { postid = id; var post = db.Posts.Find(postid); OldCategory = Convert.ToString(post.Category); ChangeCategoryVisible = true; } }
public static void LoadPost(GridViewDataSet <Post> dataset) { using (var db = new DatabaseBlog()) { db.Configuration.LazyLoadingEnabled = false; var query = from p in db.Posts select p; dataset.LoadFromQueryable(query); } }
public static void LoadUser(GridViewDataSet <User> Users) { using (var db = new DatabaseBlog()) { db.Configuration.LazyLoadingEnabled = false; var query = from p in db.Users select p; Users.LoadFromQueryable(query); } }
public void Delete(int id) { using (var db = new DatabaseBlog()) { var post = db.Posts.Find(id); db.Posts.Remove(post); db.SaveChanges(); PostService.LoadMyPost(Posts); } }
public void Show(int id) { postid = id; using (var db = new DatabaseBlog()) { var post = db.Posts.Find(postid); TitlePost = post.Title; TextPost = post.Text; } IsDisplayed = true; }
public void ChangeCategory(int id) { using (var db = new DatabaseBlog()) { var post = db.Posts.Find(id); post.Category = NewPostCategory; db.SaveChanges(); ChangeCategoryVisible = false; PostService.LoadPost(Posts); } }
public static void LoadImportantPost(GridViewDataSet <Post> dataset) { using (var db = new DatabaseBlog()) { db.Configuration.LazyLoadingEnabled = false; var query = from p in db.Posts where p.Category == PostCategory.AdminPost select p; dataset.LoadFromQueryable(query); } }
public static void LoadOtherPost(int userid, GridViewDataSet <Post> dataset) { using (var db = new DatabaseBlog()) { db.Configuration.LazyLoadingEnabled = false; var query = from p in db.Posts where p.UserID == userid select p; dataset.LoadFromQueryable(query); } }
public static void CreatePost(int userid, string Title, string Text) { using (var db = new DatabaseBlog()) { var post = new Post(); post.UserID = userid; post.Title = Title; post.Text = Text; db.Posts.Add(post); db.SaveChanges(); } }
public override Task Load() { PostService.LoadMyPost(Posts); using (var db = new DatabaseBlog()) { if (!db.Posts.Any()) { Message = "You don't have any post, create one"; VisibleButton = true; } } return(base.Load()); }
public static void LoadMyPost(GridViewDataSet <Post> dataset) { var userid = Convert.ToInt32(UserService.GetCurrentUserId()); using (var db = new DatabaseBlog()) { db.Configuration.LazyLoadingEnabled = false; var query = from p in db.Posts where p.UserID == userid select p; dataset.LoadFromQueryable(query); } }
//Method for the comments public void DeleteComment(int postid, int CommentID) { using (var db = new DatabaseBlog()) { var comment = db.Comments.Find(CommentID); var post = db.Posts.Find(postid); db.Comments.Remove(comment); db.SaveChanges(); post.CommentCount = post.CommentCount = CommentService.CommentCount(postid); db.SaveChanges(); CommentService.LoadComments(postid, Comments); PostService.LoadPost(Posts); } }
public static string GetUsername() { using (var db = new DatabaseBlog()) { var user = db.Users.Find(GetCurrentUserId()); if (user == null) { return(null); } else { return(user.Username.ToString()); } } }
public static int CommentCount(int postid) { using (var db = new DatabaseBlog()) { var query = from p in db.Comments where p.PostID == postid select p; int count = 0; foreach (var item in query) { count++; } return(count); } }
public void Login() { using (var db = new DatabaseBlog()) { var identity = UserService.Login(Username, Password); if (identity != null) { Context.OwinContext.Authentication.SignIn(identity); Context.RedirectToRoute("Default"); } else { ErrorMessage = "Your Email or Password Are incorrect."; } } }
public static bool CheckUsername(string Username) { using (var db = new DatabaseBlog()) { var query = from p in db.Users where p.Username == Username select p; if (query.Count() != 0) { return(true); } else { return(false); } } }
public static bool CheckEmail(string Email) { using (var db = new DatabaseBlog()) { var query = from p in db.Users where p.Email == Email select p; if (query.Count() != 0) { return(true); } else { return(false); } } }
public void CreatePost() { var userid = Convert.ToInt32(UserService.GetCurrentUserId()); using (var db = new DatabaseBlog()) { var user = db.Users.Find(userid); var post = new Post(); post.Title = Title; post.Text = Text; post.Date = DateTime.Now; post.UserID = userid; post.Category = NewPostCategory; post.CreatorName = user.Username.ToString(); db.Posts.Add(post); db.SaveChanges(); Context.RedirectToRoute("MyProfile"); } }
public static void LoadComments(int postid, GridViewDataSet <Comment> dataset) { using (var db = new DatabaseBlog()) { var query = from p in db.Comments where p.PostID == postid select p; foreach (var item in query) { if (item.UserID == UserService.GetCurrentUserId()) { item.Delete = true; } else { item.Delete = false; } } dataset.LoadFromQueryable(query); } }
public static ClaimsIdentity Login(string Usern, string Password) { using (var db = new DatabaseBlog()) { var query = from p in db.Users where p.Username == Usern && p.Password == Password select p; var user = query.SingleOrDefault(); if (query.Count() != 0) { var claim = new List <Claim>(); claim.Add(new Claim(ClaimTypes.NameIdentifier, Convert.ToString(user.UserID))); claim.Add(new Claim(ClaimTypes.Name, user.Username)); claim.Add(new Claim(ClaimTypes.Role, Convert.ToString(user.Userrole))); var identity = new ClaimsIdentity(claim, DefaultAuthenticationTypes.ApplicationCookie); return(identity); } } return(null); }
public void Register() { using (var db = new DatabaseBlog()) { } }
//Method For Posts and Login/SignOut public void NewPost() { using (var db = new DatabaseBlog()) { } }