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