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