protected void LinkButtonSaveUser_Click(object sender, EventArgs e) { var context = new ApplicationDbContext(); var user = context.Users.Find(userId); user.UserName = this.TextBoxUserName.Text; user.Email = this.TextBoxEmail.Text; if (UploadAvatar.HasFile) { if (UploadAvatar.PostedFile.ContentType == "image/jpeg" || UploadAvatar.PostedFile.ContentType == "image/gif" || UploadAvatar.PostedFile.ContentType == "image/png") { if (UploadAvatar.PostedFile.ContentLength < 102400) { var filename = user.UserName + Path.GetExtension(UploadAvatar.FileName); UploadAvatar.SaveAs(Server.MapPath("~/Avatar_Files/") + filename); user.Avatar = filename; } else { ErrorSuccessNotifier.AddErrorMessage("Upload status: The file has to be less than 100 kb!"); return; } } else { ErrorSuccessNotifier.AddErrorMessage("Upload status: Only JPEG, Gif and PNG files are accepted!"); return; } } try { context.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage("User's data is updated!"); ErrorSuccessNotifier.ShowAfterRedirect = true; Response.Redirect("~/Admin/Users", false); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
public IQueryable <Skill> GridViewAllSkills_GetData() { var context = new ApplicationDbContext(); IOrderedQueryable <Skill> allSkills = null; try { allSkills = (from s in context.Skills select s).OrderBy(s => s.SkillId); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } return(allSkills); }
public IQueryable <Category> GridViewUsers_GetCategories() { try { var context = new NoticeboardEntities(); var categories = from category in context.Categories orderby category.CategoryId select category; return(categories); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } return(null); }
public IQueryable <DevSocialMe.Models.Group> GridViewAllGroups_GetData() { var context = new ApplicationDbContext(); IQueryable <Group> allGroups = null; try { allGroups = (from gr in context.Groups select gr).OrderBy(g => g.GroupId); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } return(allGroups); }
public void GridViewUsers_BanUser(string userId) { using (var context = new NoticeboardEntities()) { try { var user = context.AspNetUsers.Find(userId); //user.Banned = true; context.SaveChanges(); this.GridViewUsers.PageIndex = 0; ErrorSuccessNotifier.AddInfoMessage("User successfully deleted."); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } } }
protected void OnClick(object sender, EventArgs e) { var text = this.newSkill.Text; if (text.Length == 0) { ErrorSuccessNotifier.AddErrorMessage("You cannot add a skill without a name!"); return; } this.Service.Add(new Skill { Name = text }); this.newSkill.Text = ""; ErrorSuccessNotifier.ShowAfterRedirect = false; ErrorSuccessNotifier.AddSuccessMessage("Successfully added a new skill to the db!"); ErrorSuccessNotifier.ShowAfterRedirect = true; }
protected void Delete_Command(object sender, CommandEventArgs e) { try { int categoryId = Convert.ToInt32(e.CommandArgument); Entities context = new Entities(); Category category = context.Categories.Find(categoryId); this.TextBox_DeleteCategoryName.Text = category.CategoryName; this.LinkButton_YesDelete.CommandArgument = categoryId.ToString(); this.pageMode = Mode.Delete; } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
// The id parameter name should match the DataKeyNames value set on the control public void GridViewQuestions_DeleteItem(int questionId) { var context = new PollSystemEntities(); Question question = context.Questions.Include("Answers") .FirstOrDefault(q => q.QuestionId == questionId); try { context.Answers.RemoveRange(question.Answers); context.Questions.Remove(question); context.SaveChanges(); this.GridViewQuestions.PageIndex = 0; ErrorSuccessNotifier.AddInfoMessage("Question deleted."); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
protected void Delete_Command(object sender, CommandEventArgs e) { try { int bookId = Convert.ToInt32(e.CommandArgument); Entities context = new Entities(); Book book = context.Books.Find(bookId); this.TextBox_DeleteTitle.Text = book.Title; this.LinkButton_YesDelete.CommandArgument = bookId.ToString(); this.pageMode = Mode.Delete; } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
protected void UploadButton_Click(object sender, EventArgs e) { if (ImageFileUpload.HasFile) { try { if (ImageFileUpload.PostedFile.ContentType == "image/jpeg") { if (ImageFileUpload.PostedFile.ContentLength <= 16 * 1000 * 1024) { string username = User.Identity.Name; string id = User.Identity.GetUserId(); string directory = Server.MapPath("~/UploadedFiles/ProfileImages/") + id; string filename = Guid.NewGuid().ToString() + ".jpg"; string path = directory + "/" + filename; string url = "~/UploadedFiles/ProfileImages/" + id + "/" + filename; if (!Directory.Exists(directory)) { Directory.CreateDirectory(directory); } ImageFileUpload.SaveAs(path); UserService.ChangeProfilePhotoUrl(id, url); ErrorSuccessNotifier.AddSuccessMessage("Upload status: File uploaded!"); } else { ErrorSuccessNotifier.AddErrorMessage("Upload status: The file has to be less than 16 mb!"); } } else { ErrorSuccessNotifier.AddErrorMessage("Upload status: Only JPEG files are accepted!"); } } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage("Upload status: The file could not be uploaded. The following error occured: " + ex.Message); } } }
public void GridViewUsers_UpdateItem(string id) { var context = new AcademyDbContext(); Forum.Models.ApplicationUser item = context.Users.Find(id); if (item == null) { ModelState.AddModelError("", String.Format("Item with id {0} was not found", id)); return; } var editIndex = this.GridViewUsers.EditIndex; bool isLecturer = (this.GridViewUsers.Rows[editIndex].FindControl("CheckBoxIsLecturer") as CheckBox).Checked; if (isLecturer) { var lecturerRole = context.Roles.First(r => r.Name == "Lecturer"); item.Roles.Clear(); item.Roles.Add(new UserRole() { Role = lecturerRole }); } else { item.Roles.Clear(); } TryUpdateModel(item); if (ModelState.IsValid) { context.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage("User edited successfully."); } else { ErrorSuccessNotifier.AddErrorMessage("There was an error editing the user. Please try again."); } }
protected void LinkButtonCreateBook_Command(object sender, CommandEventArgs e) { var title = this.TextBoxAddBookTitle.Text; var author = TextBoxAddBookAuthor.Text; var isbn = TextBoxAddBookISBN.Text; var webSite = TextBoxAddBookWebSite.Text; var description = TextBoxAddBookDescription.Text; var category = DropDownListCategories.SelectedItem; var categoryId = Convert.ToInt32(category.Value); var context = new ApplicationDbContext(); var dbCategory = context.Categories.FirstOrDefault(c => c.CategoryId == categoryId); if (dbCategory != null) { var newBook = new Book() { Title = title, Author = author, ISBN = isbn, WebSite = webSite, Description = description, Category = dbCategory }; try { context.Books.Add(newBook); context.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage(string.Format("Book \"{0}\" created", title)); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } } else { ErrorSuccessNotifier.AddErrorMessage(string.Format("There isn't category {0} in database", category.Text)); } Response.Redirect(Request.Url.AbsoluteUri); }
protected void MainContent_LinkButtonConfirmDelete_Click(object sender, EventArgs e) { try { int selectedBookId = int.Parse(this.TextBoxDeleteBookId.Text); ApplicationDbContext context = new ApplicationDbContext(); var selectedBook = context.Books.Find(selectedBookId); context.Books.Remove(selectedBook); context.SaveChanges(); this.GridViewBooks.DataBind(); this.MainContent_PanelDelete.Visible = false; ErrorSuccessNotifier.AddInfoMessage("You have successfully deleted book with title: " + selectedBook.Title); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
protected void OnButtonShowDeleteBookPanel_Command(object sender, CommandEventArgs e) { using (var context = new LibrarySystemEntities()) { int bookId = Convert.ToInt32(e.CommandArgument); var book = context.Books.Find(bookId); if (book != null) { this.ShowDeleteBookPanel(); this.ButtonDeleteBook.CommandArgument = bookId.ToString(); this.TextBoxDeleteBookTitle.Text = book.Title; } else { ErrorSuccessNotifier.AddErrorMessage("This book does not exist anymore"); } } }
protected void ButtonDeleteGroup_Command(object sender, CommandEventArgs e) { int groupId = Convert.ToInt32(e.CommandArgument); var context = new ApplicationDbContext(); try { var selectedGroup = context.Groups.FirstOrDefault(g => g.GroupId == groupId); context.Groups.FirstOrDefault(g => g.GroupId == groupId).Messages.Clear(); context.Groups.Remove(selectedGroup); context.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage("Group deleted!"); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } Response.Redirect(Request.Url.AbsoluteUri); }
public IQueryable <Group> GridViewJoinedGroups_GetData() { var context = new ApplicationDbContext(); IQueryable <Group> groups = null; try { var currentUser = new ApplicationUser(); currentUser = context.Users.Include("Groups") .FirstOrDefault(u => u.UserName == User.Identity.Name); groups = currentUser.Groups.OrderBy(g => g.GroupId).AsQueryable(); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } return(groups); }
public IQueryable <Group> GridViewAllGroups_GetData() { var context = new ApplicationDbContext(); IQueryable <Group> allGroups = null; try { allGroups = (from gr in context.Groups where gr.Creator != User.Identity.Name && gr.Users.All(u => u.UserName != User.Identity.Name) select gr).OrderBy(g => g.GroupId); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } return(allGroups); }
protected void ButtonJoinGroup_Command(object sender, CommandEventArgs e) { int groupId = Convert.ToInt32(e.CommandArgument); var context = new ApplicationDbContext(); try { var selectedGroup = context.Groups.FirstOrDefault(g => g.GroupId == groupId); var currentUser = new ApplicationUser(); currentUser = context.Users.FirstOrDefault(u => u.UserName == User.Identity.Name); selectedGroup.Users.Add(currentUser); context.SaveChanges(); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } this.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { int categoryId; if (!int.TryParse(this.RouteData.Values["id"].ToString(), out categoryId)) { ErrorSuccessNotifier.AddErrorMessage("Missing category id or category id is not a number"); return; } Category category = this.data.Categories.GetById(categoryId); if (category == null) { ErrorSuccessNotifier.AddErrorMessage("Worng category id!"); return; } this.category = category; }
protected void OnBtnVote_Command(object sender, CommandEventArgs e) { var dbContext = new PollSystemEntities(); int answerId = Convert.ToInt32(e.CommandArgument); var answer = dbContext.Answers.Find(answerId); if (answer != null) { answer.Votes++; dbContext.SaveChanges(); ErrorSuccessNotifier.AddInfoMessage("You voted for " + answer.Text); Response.Redirect("~/VotingResults.aspx?questionId=" + answer.QuestionId); } else { ErrorSuccessNotifier.AddErrorMessage("This answer does not exist anymore"); } }
protected void OnButtonCreateCategory_Command(object sender, CommandEventArgs e) { using (var context = new LibrarySystemEntities()) { try { string categoryName = this.TextBoxCreateCategoryName.Text.Trim(); if (categoryName == "") { ErrorSuccessNotifier.AddErrorMessage("The category cannot be empty"); return; } var existingCategory = context.Categories.FirstOrDefault( cat => cat.Name.ToLower() == categoryName.ToLower()); if (existingCategory != null) { this.PanelCreateCategory.Visible = false; ErrorSuccessNotifier.AddErrorMessage("This category already exists"); return; } var newCategory = new Category() { Name = categoryName }; context.Categories.Add(newCategory); context.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage("Category created"); this.GridViewCategories.SetPageIndex(this.GridViewCategories.PageIndex); this.PanelCreateCategory.Visible = false; } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } } }
protected void Page_Load(object sender, EventArgs e) { var searchText = Request.Params["q"]; this.LiteralSearchTitle.Text = searchText; var searchTextToLower = searchText.ToLower(); var context = new ApplicationDbContext(); try { var books = context.Books .Where(x => x.Title.ToLower().Contains(searchTextToLower) || x.Author.ToLower().Contains(searchTextToLower)) .OrderBy(b => b.Title).ThenBy(t => t.Author); this.RepeaterSearchResults.DataSource = books.ToList(); this.RepeaterSearchResults.DataBind(); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
protected void SaveEdit_Command(object sender, CommandEventArgs e) { try { int categoryId = Convert.ToInt32(e.CommandArgument); Entities context = new Entities(); Category category = context.Categories.Find(categoryId); category.CategoryName = this.TextBox_CategoryName.Text != string.Empty ? this.TextBox_CategoryName.Text : null; context.SaveChanges(); this.pageMode = Mode.View; ErrorSuccessNotifier.AddSuccessMessage("The category was edited successfully!"); } catch (Exception ex) { this.pageMode = Mode.Edit; ErrorSuccessNotifier.AddErrorMessage(ex); } }
private bool ValidateISBN(string ISBN) { var isValid = true; if (string.IsNullOrEmpty(ISBN)) { return(true); } else if (ISBN.Length != 17) { ErrorSuccessNotifier.AddErrorMessage("ISBN's length is exactly 17 symbols: 978-954-400-773-7"); isValid = false; } else if (!Regex.IsMatch(ISBN, @"^[\d-]{17}$")) { ErrorSuccessNotifier.AddErrorMessage("ISBN consists only of digits and '-': 978-954-400-773-7"); isValid = false; } return(isValid); }
protected void OnButtonShowEditCategory_Command(object sender, CommandEventArgs e) { using (var context = new LibrarySystemEntities()) { int categoryId = Convert.ToInt32(e.CommandArgument); var category = context.Categories.Find(categoryId); if (category != null) { this.PanelCreateCategory.Visible = false; this.PanelDeleteCategory.Visible = false; this.PanelEditCategory.Visible = true; this.TextBoxEditCategoryName.Text = category.Name; this.ButtonSaveCategory.CommandArgument = categoryId.ToString(); } else { ErrorSuccessNotifier.AddErrorMessage("This category does not exist anymore"); } } }
protected void Page_Load(object sender, EventArgs e) { var context = new ApplicationDbContext(); ICollection <Category> categories = null; try { categories = context.Categories.OrderBy(c => c.Title).ToList(); if (categories == null || categories.Count == 0) { (this.ListViewCategories.FindControl("NoResults") as Literal).Text = "No books in this category."; } } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } this.ListViewCategories.DataSource = categories; this.ListViewCategories.DataBind(); }
public void ListViewComments_InsertItem() { try { var db = new NoticeboardEntities(); var user = db.AspNetUsers.FirstOrDefault(u => u.UserName == this.User.Identity.Name); var cont = ((TextBox)this.FindControlRecursive(this, "TextBoxComment")).Text; if (cont.Length >= 5000) { var ex = new Exception("Comment must be less than 5000 symbols!"); ErrorSuccessNotifier.AddErrorMessage(ex); return; } var comment = new Comment { Content = cont, PostId = this.postId, AspNetUser = user, CommentDate = DateTime.Now }; db.Comments.Add(comment); try { db.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage("Comment created successfully"); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex.Message); } var uPanel = (UpdatePanel)this.FindControlRecursive(this, "UpdatePanelComments"); uPanel.Update(); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
public void EditCategoryLV_InsertItem() { var newCategory = new Category(); this.TryUpdateModel(newCategory); if (this.ModelState.IsValid == false) { ErrorSuccessNotifier.AddErrorMessage(CouldNotAddCategoryMsg); return; } if (this.db.Categories.Any(c => c.Name == newCategory.Name)) { ErrorSuccessNotifier.AddErrorMessage(CategoryNameExistsMsg); return; } this.db.Categories.Add(newCategory); this.db.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage(CategoryCreatedMsg); }
protected void ButtonSave_Click(object sender, EventArgs e) { using (var context = new StichtiteForumEntities()) { var commentId = Convert.ToInt32(this.Request.Params["commentId"]); try { var comment = context.Comments.Find(commentId); comment.Content = this.TextBoxCommentContent.Text; context.SaveChanges(); ErrorSuccessNotifier.AddInfoMessage("Comment successfully edited."); ErrorSuccessNotifier.ShowAfterRedirect = true; this.Response.Redirect("Comments.aspx?postId=" + comment.PostId, false); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } } }
protected void SaveEditedCategory_Command(object sender, CommandEventArgs e) { //Edit question var textBoxEditCategory = this.FormViewEditCategory.FindControl("TextBoxEditCategory") as TextBox; var categoryTitle = textBoxEditCategory.Text; var context = new ApplicationDbContext(); var categoryId = Convert.ToInt32(e.CommandArgument); try { var category = context.Categories.FirstOrDefault(c => c.CategoryId == categoryId); category.Title = categoryTitle; context.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage(string.Format("Category \"{0}\" created!", categoryTitle)); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } Response.Redirect(Request.Url.AbsoluteUri); }