protected void saveBtn_Click(object sender, EventArgs e)
{
BlogSystemEntities db = new BlogSystemEntities();
var currCategory = new BlogSystem.Models.Category();
currCategory.Description = descr.Text;
currCategory.Name = name.Text;
if (this.PostImgUpload.HasFile)
{
string extension = Path.GetExtension(PostImgUpload.FileName.ToString())
.Trim().ToLower();
if (extension == ".png" || extension == ".jpg")
{
string fileName = Guid.NewGuid() + "_"
+ PostImgUpload.FileName.ToString();
this.PostImgUpload.SaveAs(Server.MapPath("~/Images/" + fileName));
currCategory.Image = fileName;
}
}
db.Categories.Add(currCategory);
db.SaveChanges();
descr.Text = string.Empty;
name.Text = string.Empty;
}
protected void saveBtn_Click(object sender, EventArgs e)
{
BlogSystemEntities db = new BlogSystemEntities();
var currNews = GetNews(Id, db);
if (currNews != null)
{
currNews.Text = text.Text;
currNews.Title = title.Text;
if (this.PostImgUpload.HasFile)
{
string extension = Path.GetExtension(PostImgUpload.FileName.ToString())
.Trim().ToLower();
if (extension == ".png" || extension == ".jpg")
{
string fileName = Guid.NewGuid() + "_"
+ PostImgUpload.FileName.ToString();
this.PostImgUpload.SaveAs(Server.MapPath("~/Images/" + fileName));
currNews.Image = fileName;
}
}
db.SaveChanges();
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
BlogSystemEntities db = new BlogSystemEntities();
categories.DataSource = db.Categories.ToList();
categories.DataBind();
}
protected void saveBtn_Click(object sender, EventArgs e)
{
BlogSystemEntities db = new BlogSystemEntities();
var currPost = GetPost(Id, db);
if (currPost != null)
{
currPost.PostContent = content.Text;
if (this.PostImgUpload.HasFile)
{
string extension = Path.GetExtension(PostImgUpload.FileName.ToString())
.Trim().ToLower();
if (extension == ".png" || extension == ".jpg")
{
string fileName = currPost.PostContent.Take(10) + "_" + DateTime.Now.ToLongTimeString()
+ PostImgUpload.FileName.ToString();
this.PostImgUpload.SaveAs(Server.MapPath("~/Images/" + fileName));
currPost.Image = fileName;
}
}
db.SaveChanges();
}
}
public IQueryable<BlogSystem.Models.Post> CurrentTopicListView_GetData1()
{
int id=0;
try
{
id = int.Parse(Request.Params["id"].ToString());
}
catch (Exception)
{
Response.Redirect("~/Default.aspx");
}
var context = new BlogSystemEntities();
var posts = context.Posts.Include("Topic").Include("AspNetUser").Where(post => post.TopicId == id);
if (posts.Count() > 0)
{
this.TopicName.InnerText = posts.FirstOrDefault().Topic.Name;
}
return posts;
}
protected void saveBtn_Click(object sender, EventArgs e)
{
BlogSystemEntities db = new BlogSystemEntities();
var currCategory = GetCategory(Id, db);
if (currCategory != null)
{
currCategory.Description = descr.Text;
currCategory.Name = name.Text;
if (this.PostImgUpload.HasFile)
{
string extension = Path.GetExtension(PostImgUpload.FileName.ToString())
.Trim().ToLower();
if (extension == ".png" || extension == ".jpg")
{
string fileName = Guid.NewGuid() + "_"
+ PostImgUpload.FileName.ToString();
this.PostImgUpload.SaveAs(Server.MapPath("~/Images/" + fileName));
currCategory.Image = fileName;
}
}
db.SaveChanges();
Response.Redirect("~/Admin/ControlPanel.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
var id = Convert.ToInt32(Request.QueryString["id"]);
BlogSystemEntities db = new BlogSystemEntities();
var currCategory = db.Categories.FirstOrDefault(c => c.Id == id);
if (currCategory != null)
{
name.InnerText = currCategory.Name;
descr.InnerText = currCategory.Description;
if (currCategory.Image == null)
{
imgCategory.Visible = false;
}
else
{
imgCategory.Src = "~/Images/" + currCategory.Image;
}
var allTopics = currCategory.Topics.ToList();
topics.DataSource = allTopics;
topics.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
var db = new BlogSystemEntities();
var allNews = db.News.ToList();
allNews.Reverse();
NewsRepeater.DataSource = allNews;
NewsRepeater.DataBind();
}
// The return type can be changed to IEnumerable, however to support
// paging and sorting, the following parameters must be added:
// int maximumRows
// int startRowIndex
// out int totalRowCount
// string sortByExpression
public IQueryable<Topic> AllTopicsListView_GetData()
{
var context = new BlogSystemEntities();
var id = int.Parse(Request.Params["id"]);
var topics = context.Topics.Include("AspNetUser").Where(topic => topic.CategoryId == id);
return topics;
}
protected void deleteBtn_Click(object sender, EventArgs e)
{
BlogSystemEntities db = new BlogSystemEntities();
var currPost = GetPost(Id, db);
if (currPost != null)
{
db.Posts.Remove(currPost);
db.SaveChanges();
}
}
protected void Page_Load(object sender, EventArgs e)
{
BlogSystemEntities ctx = new BlogSystemEntities();
using (ctx)
{
var news = ctx.News.OrderByDescending(n => n.Id).Take(5).ToList();
lvNews.DataSource = news;
lvNews.DataBind();
}
}
protected void ButtonRestoreUser_Click(object sender, EventArgs e)
{
string userId = Request.QueryString["id"];
BlogSystemEntities ctx = new BlogSystemEntities();
using (ctx)
{
var user = ctx.AspNetUsers.FirstOrDefault(usr => usr.Id == userId);
user.IsActive = true;
ctx.SaveChanges();
}
}
protected void deleteNews_Command(object sender, CommandEventArgs e)
{
BlogSystemEntities db = new BlogSystemEntities();
var id = Convert.ToInt32(e.CommandArgument);
var currNews = db.News.FirstOrDefault(t => t.Id == id);
if (currNews != null)
{
db.News.Remove(currNews);
db.SaveChanges();
}
}
protected void deleteBtn_Click(object sender, EventArgs e)
{
BlogSystemEntities db = new BlogSystemEntities();
var currNews = db.News.FirstOrDefault(t => t.Id == Id);
if (currNews != null)
{
db.News.Remove(currNews);
db.SaveChanges();
Response.Redirect("~/Admin/News.aspx");
}
}
protected void deleteBtn_Click(object sender, EventArgs e)
{
BlogSystemEntities db = new BlogSystemEntities();
var currTopic = db.Topics.Include("Posts").
FirstOrDefault(t => t.Id == Id);
if (currTopic != null)
{
db.Posts.RemoveRange(currTopic.Posts);
db.Topics.Remove(currTopic);
db.SaveChanges();
}
}
protected void deleteCategory_Click(object sender, CommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument);
BlogSystemEntities db = new BlogSystemEntities();
var currCategory = db.Categories.Include("Topics").Include("Topics.Posts").
FirstOrDefault(c => c.Id == id);
if (currCategory != null)
{
db.Posts.RemoveRange(currCategory.Topics.SelectMany(t => t.Posts));
db.Topics.RemoveRange(currCategory.Topics);
db.Categories.Remove(currCategory);
db.SaveChanges();
}
}
protected void Page_Load(object sender, EventArgs e)
{
var db = new BlogSystemEntities();
var found = (from u in db.AspNetUsers
orderby u.Posts.Count
select new UserModel()
{
Username = u.UserName,
PostsCount = u.Posts.Count
}).Take(100).ToList();
found.Reverse();
UserRatingControl.DataSource = found;
UserRatingControl.DataBind();
}
protected void ButtonMakeAdmin_Click(object sender, EventArgs e)
{
string userId = Request.QueryString["id"];
BlogSystemEntities ctx = new BlogSystemEntities();
using (ctx)
{
var adminRole = ctx.AspNetRoles.Single(x => x.Name == "Admin");
var user = ctx.AspNetUsers.FirstOrDefault(usr => usr.Id == userId);
user.AspNetRoles.Add(adminRole);
ctx.SaveChanges();
}
}
protected void InsertTopicBtn_Click(object sender, EventArgs e)
{
if (IsValid)
{
var topicTitle = this.TopicTitle.Text;
var topicDescription = this.TopicDescription.Text;
int id = int.Parse(Request.Params["id"]);
var context = new BlogSystemEntities();
var author = context.AspNetUsers.FirstOrDefault(user => user.UserName == User.Identity.Name);
var topic = new Topic()
{
CategoryId = id,
Name = topicTitle,
Description = topicDescription,
AspNetUser = author
};
if (this.TopicImgUpload.FileName != string.Empty)
{
string extension = Path.GetExtension(TopicImgUpload.FileName.ToString());
if (extension.Trim().ToLower() == ".png")
{
this.TopicImgUpload.SaveAs(Server.MapPath("~/Images/" + TopicImgUpload.FileName.ToString()));
Server.MapPath("~/Images/" + TopicImgUpload.FileName.ToString());
topic.Image = TopicImgUpload.FileName.ToString();
}
}
context.Topics.Add(topic);
context.SaveChanges();
this.TopicTitle.Text = "";
this.TopicDescription.Text = "";
this.AllTopicsListView.DataBind();
}
}
protected void InsertPostBtn_Click(object sender, EventArgs e)
{
if (IsValid)
{
var postContent = this.PostContent.Text;
int id = int.Parse(Request.Params["id"]);
var context = new BlogSystemEntities();
var author = context.AspNetUsers.FirstOrDefault(user => user.UserName == User.Identity.Name);
Post post = new Post()
{
PostContent = postContent,
AspNetUser = author,
TopicId = id
};
//if (this.PostImgUpload.HasFile)
//{
// string extension = Path.GetExtension(PostImgUpload.FileName.ToString());
// if (extension.Trim().ToLower() == ".png")
// {
// this.PostImgUpload.SaveAs(Server.MapPath("~/Images/" + PostImgUpload.FileName.ToString()));
// Server.MapPath("~/Images/" + PostImgUpload.FileName.ToString());
// post.Image = PostImgUpload.FileName.ToString();
// }
//}
context.Posts.Add(post);
context.SaveChanges();
this.PostContent.Text = "";
this.CurrentTopicListView.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Id = Convert.ToInt32(Request.QueryString["id"]);
BlogSystemEntities db = new BlogSystemEntities();
var currPost = GetPost(Id, db);
if (currPost != null)
{
content.Text = currPost.PostContent;
if (currPost.Image == null)
{
img.Visible = false;
}
else
{
img.Src = "~/Images/" + currPost.Image;
}
}
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
string username = Context.User.Identity.Name;
BlogSystemEntities ctx = new BlogSystemEntities();
using (ctx)
{
var user = ctx.AspNetUsers.FirstOrDefault(usr => usr.UserName == username);
if (user != null)
{
if (!user.IsActive)
{
Context.GetOwinContext().Authentication.SignOut();
Response.Redirect("~/Account/Login.aspx");
}
}
}
}
private BlogSystem.Models.Category GetCategory(int id, BlogSystemEntities db)
{
var currCategory = db.Categories.FirstOrDefault(t => t.Id == id);
return currCategory;
}
private BlogSystem.Models.Post GetPost(int id, BlogSystemEntities db)
{
var currPost = db.Posts.FirstOrDefault(t => t.Id == Id);
return currPost;
}
private BlogSystem.Models.Topic GetTopic(int id, BlogSystemEntities db)
{
var currTopic = db.Topics.FirstOrDefault(t => t.Id == id);
return currTopic;
}
private BlogSystem.Models.News GetNews(int id, BlogSystemEntities db)
{
var currNews = db.News.FirstOrDefault(n => n.Id == id);
return currNews;
}
