protected void LinkButtonUpdate_Command(object sender, CommandEventArgs e) { try { int channelId = Convert.ToInt32(e.CommandArgument); TwitterEntities context = new TwitterEntities(); var channel = context.Channels.FirstOrDefault(x => x.ChannelId == channelId); var button = sender as LinkButton; var tr = button.Parent.Parent; var textBox = tr.FindControl("TextBoxEditChannel") as TextBox; string newChannelName = textBox.Text; Verificator.ValidateChannel(newChannelName); channel.Name = newChannelName; context.SaveChanges(); ErrorSuccessNotifier.AddInfoMessage("Channel name updated successfully."); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
// The id parameter name should match the DataKeyNames value set on the control public void GridViewMyChannels_DeleteItem(int ChannelId) { try { int channelId = ChannelId; TwitterEntities context = new TwitterEntities(); var channel = context.Channels.Include("Messages").FirstOrDefault(x => x.ChannelId == channelId); string currentUsername = User.Identity.Name; if (channel.AspNetUser.UserName != currentUsername) { throw new Exception("Different owner of the channel."); } var messages = channel.Messages; context.Messages.RemoveRange(messages); context.Channels.Remove(channel); context.SaveChanges(); ErrorSuccessNotifier.AddInfoMessage("Channel successfully removed."); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } //Response.Redirect(Request.RawUrl); }
// The id parameter name should match the DataKeyNames value set on the control public void ListViewAllUsers_UpdateItem(string Id) { TwitterEntities context = new TwitterEntities(); Twitter.Models.AspNetUser item = null; // Load the item here, e.g. item = MyDataLayer.Find(id); item = context.AspNetUsers.Find(Id); if (item == null) { // The item wasn't found ModelState.AddModelError("", String.Format("Item with id {0} was not found", Id)); return; } TryUpdateModel(item); if (ModelState.IsValid) { try { context.SaveChanges(); ErrorSuccessNotifier.AddInfoMessage("User has been successfully edited"); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex.Message); } // Save changes here, e.g. MyDataLayer.SaveChanges(); } }
protected void CreateUser_Click(object sender, EventArgs e) { TwitterEntities context = new TwitterEntities(); string userName = UserName.Text; var manager = new AuthenticationIdentityManager(new IdentityStore()); User u = new User(userName) { UserName = userName }; IdentityResult result = manager.Users.CreateLocalUser(u, Password.Text); var role = context.AspNetRoles.FirstOrDefault(x => x.Name == "User"); if (result.Success) { string userId = u.Id; AspNetUser currentUser = context.AspNetUsers.FirstOrDefault(x => x.Id == userId); currentUser.AspNetRoles.Add(role); context.SaveChanges(); manager.Authentication.SignIn(Context.GetOwinContext().Authentication, u.Id, isPersistent: false); OpenAuthProviders.RedirectToReturnUrl(Request.QueryString["ReturnUrl"], Response); } else { ErrorMessage.Text = result.Errors.FirstOrDefault(); } }
protected void ButtonCreateMessage_Click(object sender, EventArgs e) { try { int channelId = Convert.ToInt32(this.DropDownListChannels.SelectedValue); TwitterEntities context = new TwitterEntities(); Message msg = new Message(); Channel channel = context.Channels.Find(channelId); msg.Channel = channel; string msgText = MessageContent.Text; Verificator.ValidateMessage(msgText); msg.MessageContent = msgText; var currentUserName = this.User.Identity.Name; var author = context.AspNetUsers.FirstOrDefault(x => x.UserName == currentUserName); msg.AspNetUser = author; msg.Date = DateTime.Now; context.Messages.Add(msg); context.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage("Message created successfully."); ErrorSuccessNotifier.ShowAfterRedirect = true; Response.Redirect("ChannelMessages.aspx?channelId=" + channelId, false); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
protected void ButtonCreateChannel_Click(object sender, EventArgs e) { try { TwitterEntities context = new TwitterEntities(); Channel channel = new Channel(); var currentUserName = this.User.Identity.Name; var author = context.AspNetUsers.FirstOrDefault(x => x.UserName == currentUserName); Verificator.ValidateChannel(ChannelName.Text); channel.AspNetUser = author; channel.Name = ChannelName.Text; context.Channels.Add(channel); context.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage("Channel created successfully."); ErrorSuccessNotifier.ShowAfterRedirect = true; Response.Redirect("../Messages/ChannelMessages.aspx?channelId=" + channel.ChannelId, false); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
// The id parameter name should match the DataKeyNames value set on the control public void GridViewMyChannels_UpdateItem(int ChannelId) { TwitterEntities context = new TwitterEntities(); Twitter.Models.Channel item = null; // Load the item here, e.g. item = MyDataLayer.Find(id); item = context.Channels.Find(ChannelId); if (item == null) { // The item wasn't found ModelState.AddModelError("", String.Format("Item with id {0} was not found", ChannelId)); return; } TryUpdateModel(item); if (ModelState.IsValid) { try { Verificator.ValidateChannel(item.Name); context.SaveChanges(); ErrorSuccessNotifier.AddInfoMessage("Channel updated successfully"); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex.Message); } // Save changes here, e.g. MyDataLayer.SaveChanges(); } }
protected void UploadPicture_ServerClick(object sender, EventArgs e) { var username = User.Identity.Name; if ((avatarPicture.PostedFile != null) && (avatarPicture.PostedFile.ContentLength > 0)) { TwitterEntities context = new TwitterEntities(); var user = context.AspNetUsers.FirstOrDefault(x => x.UserName == username); var userId = user.Id; string fn = userId + System.IO.Path.GetExtension(avatarPicture.PostedFile.FileName); string SaveLocation = Server.MapPath("Data") + "\\" + fn; try { avatarPicture.PostedFile.SaveAs(SaveLocation); Response.Write("The file has been uploaded."); user.ProfilePicture = fn; context.SaveChanges(); Response.Write(fn); Response.Redirect("Manage"); } catch (Exception ex) { Response.Write("Error: " + ex.Message); //Note: Exception.Message returns a detailed message that describes the current exception. //For security reasons, we do not recommend that you return Exception.Message to end users in //production environments. It would be better to put a generic error message. } } else { Response.Write("Please select a file to upload."); } }
public void Create(Hashtag hashtag) { using (var context = new TwitterEntities()) { context.Hashtags.Add(hashtag); context.SaveChanges(); } }
//dohvaća komentare za t public void Create(Comment comment) { using (var context = new TwitterEntities()) { context.Comments.Add(comment); context.SaveChanges(); } }
public void Create(User user) { using (var context = new TwitterEntities()) { context.Users.Add(user); context.SaveChanges(); } }
public void Create(Location location) { using (var context = new TwitterEntities()) { context.Locations.Add(location); context.SaveChanges(); } }
public void Create(Tweet tweet) { using (var context = new TwitterEntities()) { context.Tweets.Add(tweet); context.SaveChanges(); } }
public string SignUp(Person model) { Person oldUser = new Person(); oldUser = context.People.FirstOrDefault(p => p.UserId == model.UserId || p.Email == model.Email); if (oldUser == null) { model.Active = true; model.Joined = DateTime.Now; context.People.Add(model); context.SaveChanges(); return("Success"); } else { return("Duplicate User"); } }
protected void HyperLinkAddMessage_Click(object sender, EventArgs e) { try { int channelId = Convert.ToInt32(Request.Params["channelId"]); TwitterEntities context = new TwitterEntities(); string currentUserName = User.Identity.Name; LinkButton button = sender as LinkButton; var tr = button.Parent.Parent; var trControls = tr.Controls; string messageContent = null; foreach (Control tdControl in trControls) { foreach (Control control in tdControl.Controls) { if (control.ID == "MessageContent") { messageContent = (control as TextBox).Text; } } } Verificator.ValidateMessage(messageContent); string userId = context.AspNetUsers.FirstOrDefault(x => x.UserName == currentUserName).Id; Message message = new Message() { ChannelId = channelId, Date = DateTime.Now, MessageContent = messageContent, UserId = userId }; context.Messages.Add(message); context.SaveChanges(); this.GridViewMessages.DataBind(); this.InfoHolder.Visible = false; //ErrorSuccessNotifier.ShowAfterRedirect = false; //ErrorSuccessNotifier.AddSuccessMessage("Message created successfully."); } catch (Exception ex) { this.InfoHolder.InnerText = ex.Message; this.InfoHolder.Attributes.Add("class", "alert alert-error"); this.InfoHolder.Visible = true; //ErrorSuccessNotifier.ShowAfterRedirect = false; //ErrorSuccessNotifier.AddErrorMessage(ex); } }
// The id parameter name should match the DataKeyNames value set on the control public void GridViewMessages_DeleteItem(int MessageId) { int messageId = MessageId; TwitterEntities context = new TwitterEntities(); var message = context.Messages.Find(messageId); context.Messages.Remove(message); context.SaveChanges(); }
public bool Delete(int id) { bool result = false; using (context = new TwitterEntities()) { var tweet = GetById(id); context.Tweets.Remove(tweet); result = context.SaveChanges() > 0; Logger.Log.Debug("user ID:" + tweet.User_Id + " " + userDao.GetById(tweet.User_Id).Email + " deleted a tweet ID:" + tweet.Id); } return result; }
public bool Delete(User user) { bool result = false; using (var context = new TwitterEntities()) { context.Users.Attach(user); context.Entry(user).State = EntityState.Deleted; result = context.SaveChanges() > 0; Logger.Log.Debug("user ID:" + user.Id + " " + user.Email + " was deleted successfully"); } return result; }
public bool AddNewTwit(int id, string content) { Twit t = new Twit(); t.UserId = id; t.TwitContent = content; t.Date = DateTime.Now; db.Twits.Add(t); db.SaveChanges(); return(true); }
public bool Delete(Tweet tweet) { bool result = false; using (context = new TwitterEntities()) { tweet.User = userDao.GetById(tweet.User_Id); context.Tweets.Attach(tweet); context.Tweets.Remove(tweet); //context.Entry(tweet).State = EntityState.Deleted; result = context.SaveChanges() > 0; Logger.Log.Debug("user ID:" + tweet.User_Id + " " + userDao.GetById(tweet.User_Id).Email + " deleted a tweet ID:" + tweet.Id); } return result; }
public bool Delete(int id) { bool result = false; using (var context = new TwitterEntities()) { var follow = GetById(id); context.Follows.Attach(follow); context.Follows.Remove(follow); result = context.SaveChanges() > 0; Logger.Log.Debug("A new follow pair deleted with publisherId " + follow.Publisher_Id + " and subscriberId " + follow.Subscriber_Id); } return result; }
protected void LinkButtonDeleteChannel_Command(object sender, CommandEventArgs e) { int channelId = Convert.ToInt32(e.CommandArgument); TwitterEntities context = new TwitterEntities(); var channel = context.Channels.Include("Messages").FirstOrDefault(x => x.ChannelId == channelId); var messages = channel.Messages; context.Messages.RemoveRange(messages); context.Channels.Remove(channel); context.SaveChanges(); Response.Redirect(Request.RawUrl); }
public bool Update(User user) { var pass = GetById(user.Id).Passwrd; bool result = false; user.Passwrd = pass; using (var context = new TwitterEntities()) { context.Users.Attach(user); context.Entry(user).State = EntityState.Modified; result = context.SaveChanges() > 0; Logger.Log.Debug("User ID:" + user.Id + " " + user.Email + " was updated successfully"); } return result; }
public bool Add(User user) { if (user == null) return false; bool result = false; using (var context = new TwitterEntities()) { context.Users.Attach(user); context.Entry(user).State = EntityState.Added; result = context.SaveChanges() > 0; Logger.Log.Debug("new user ID:" + user.Id + " " + user.Email + " was added successfully"); } return result; }
public void Delete(Tweet tweet, User user) { using (var context = new TwitterEntities()) { var exisitngFavouriteTweet = (from favs in context.FavouriteTweets where (favs.Tweet1 == tweet && favs.User == user) select favs).SingleOrDefault(); if (exisitngFavouriteTweet != null ) { context.FavouriteTweets.Remove(exisitngFavouriteTweet); context.SaveChanges(); } } }
protected void FollowButton_Click(object sender, EventArgs e) { string username = Request.Params["username"]; string currentUserName = User.Identity.Name; TwitterEntities context = new TwitterEntities(); AspNetUser currentUser = context.AspNetUsers.Include("AspNetUsers").FirstOrDefault(x => x.UserName == currentUserName); var followingUser = context.AspNetUsers.FirstOrDefault(x => x.UserName == username); currentUser.AspNetUsers1.Add(followingUser); context.SaveChanges(); Response.Redirect(Request.RawUrl); }
public void Update(int id) { using (var context = new TwitterEntities()) { var tweet = context.Tweets.SingleOrDefault(t => t.ID == id); if(tweet != null) { context.FavouriteTweets.RemoveRange(tweet.FavouriteTweets); context.Comments.RemoveRange(tweet.Comments); context.Tweets.Remove(tweet); context.SaveChanges(); } } }
// The id parameter name should match the DataKeyNames value set on the control public void GridViewMyMessages_DeleteItem(int MessageId) { try { TwitterEntities context = new TwitterEntities(); var message = context.Messages.FirstOrDefault(x => x.MessageId == MessageId); context.Messages.Remove(message); context.SaveChanges(); ErrorSuccessNotifier.AddInfoMessage("Message has been deleted successfully"); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
public void Create(Tweet tweet, User user) { using (var context = new TwitterEntities()) { var existingTweet = context.Tweets.SingleOrDefault(x => x.ID == tweet.ID); var existingUser = context.Users.SingleOrDefault(x => x.Id == user.Id); if(existingTweet != null && existingUser != null) { var favourite = new FavouriteTweet { Tweet1 = existingTweet, User = existingUser }; context.FavouriteTweets.Add(favourite); context.SaveChanges(); } } }
public bool Add(Tweet tweet) { bool result = false; using (context = new TwitterEntities()) { tweet.User = userDao.GetById(tweet.User_Id); context.Tweets.Attach(tweet); context.Tweets.Add(tweet); result = context.SaveChanges() > 0; Logger.Log.Debug("user ID:" + tweet.User_Id + " " + userDao.GetById(tweet.User_Id).Email + " added a new tweet ID:" + tweet.Id); } return result; }
protected void DemoteAdmin_Command(object sender, CommandEventArgs e) { TwitterEntities context = new TwitterEntities(); string id = e.CommandArgument.ToString(); var user = context.AspNetUsers.Find(id); this.messageDiv.Visible = true; var adminRole = context.AspNetRoles.FirstOrDefault(r => r.Name == "Admin"); user.AspNetRoles.Remove(adminRole); context.SaveChanges(); this.ListViewAdmins.DataBind(); this.ListViewRegularUsers.DataBind(); this.messageText.InnerText = "Admin successfully demoted!"; this.messageDiv.Attributes["class"] = "alert alert-success"; }
public void Update(User user) { using (var context = new TwitterEntities()) { var existingUser = context.Users.SingleOrDefault(x => x.Id == user.Id); if(existingUser != null) { existingUser.Nickname = user.Nickname; existingUser.Location1 = user.Location1; existingUser.Picture_URL = user.Picture_URL; existingUser.FollowedBy = user.FollowedBy; existingUser.Following = user.Following; context.SaveChanges(); } } }
// The id parameter name should match the DataKeyNames value set on the control public void GridViewMyChannels_DeleteItem(int ChannelId) { int channelId = ChannelId; TwitterEntities context = new TwitterEntities(); var channel = context.Channels.Include("Messages").FirstOrDefault(x => x.ChannelId == channelId); string currentUsername = User.Identity.Name; var messages = channel.Messages; context.Messages.RemoveRange(messages); context.Channels.Remove(channel); context.SaveChanges(); //Response.Redirect(Request.RawUrl); }
protected void LinkButtonUpdate_Command(object sender, CommandEventArgs e) { int channelId = Convert.ToInt32(e.CommandArgument); TwitterEntities context = new TwitterEntities(); var channel = context.Channels.FirstOrDefault(x => x.ChannelId == channelId); var button = sender as LinkButton; var tr = button.Parent.Parent; var textBox = tr.FindControl("TextBoxEditChannel") as TextBox; string newChannelName = textBox.Text; channel.Name = newChannelName; context.SaveChanges(); }
// The id parameter name should match the DataKeyNames value set on the control public void GridViewMessages_UpdateItem(int MessageId) { TwitterEntities context = new TwitterEntities(); Twitter.Models.Message item = null; // Load the item here, e.g. item = MyDataLayer.Find(id); item = context.Messages.Find(MessageId); if (item == null) { // The item wasn't found ModelState.AddModelError("", String.Format("Item with id {0} was not found", MessageId)); return; } TryUpdateModel(item); if (ModelState.IsValid) { context.SaveChanges(); // Save changes here, e.g. MyDataLayer.SaveChanges(); } }
// The id parameter name should match the DataKeyNames value set on the control public void ListViewAllUsers_DeleteItem(string Id) { string userId = Id; TwitterEntities context = new TwitterEntities(); var user = context.AspNetUsers.Find(userId); context.Messages.RemoveRange(user.Messages); var channels = user.Channels; foreach (var channel in channels) { context.Messages.RemoveRange(channel.Messages); } context.Channels.RemoveRange(channels); context.AspNetUserLogins.RemoveRange(user.AspNetUserLogins); context.AspNetUserManagements.Remove(user.AspNetUserManagement); context.AspNetUsers.Remove(user); context.SaveChanges(); }
public bool Add(int publisherId, int subscriberId) { bool result = false; var follow = new Follow { Publisher_Id = publisherId, Subscriber_Id = subscriberId, User = user.GetById(publisherId), User1 = user.GetById(subscriberId) }; using (var context = new TwitterEntities()) { context.Follows.Attach(follow); context.Follows.Add(follow); result = context.SaveChanges() > 0; Logger.Log.Debug("A new follow pair created with publisherId " + follow.Publisher_Id + " and subscriberId " + follow.Subscriber_Id); } return result; }
protected void HyperLinkAddMessage_Click(object sender, EventArgs e) { int channelId = Convert.ToInt32(Request.Params["channelId"]); TwitterEntities context = new TwitterEntities(); string currentUserName = User.Identity.Name; string userId = context.AspNetUsers.FirstOrDefault(x => x.UserName == currentUserName).Id; Message message = new Message() { ChannelId = channelId, Date = DateTime.Now, MessageContent = this.MessageContent.Text, UserId = userId }; context.Messages.Add(message); context.SaveChanges(); Response.Redirect(Request.RawUrl); }
// The id parameter name should match the DataKeyNames value set on the control public void GridViewMyMessages_UpdateItem(int MessageId) { TwitterEntities context = new TwitterEntities(); Twitter.Models.Message item = null; // Load the item here, e.g. item = MyDataLayer.Find(id); item = context.Messages.FirstOrDefault(x => x.MessageId == MessageId); if (item == null) { // The item wasn't found ModelState.AddModelError("", String.Format("Item with id {0} was not found", MessageId)); return; } TryUpdateModel(item); if (ModelState.IsValid) { // Save changes here, e.g. MyDataLayer.SaveChanges(); try { Verificator.ValidateMessage(item.MessageContent); context.SaveChanges(); ErrorSuccessNotifier.AddInfoMessage("Message has been edited successfully"); } catch (Exception ex) { if (ex.Message != null) { ErrorSuccessNotifier.AddErrorMessage(ex.Message); } else { ErrorSuccessNotifier.AddErrorMessage(ex); } } } }
protected void LinkButtonDeleteChannel_Command(object sender, CommandEventArgs e) { try { int channelId = Convert.ToInt32(e.CommandArgument); TwitterEntities context = new TwitterEntities(); var channel = context.Channels.Include("Messages").FirstOrDefault(x => x.ChannelId == channelId); var messages = channel.Messages; context.Messages.RemoveRange(messages); context.Channels.Remove(channel); context.SaveChanges(); ErrorSuccessNotifier.AddInfoMessage("Channel successfully removed"); ErrorSuccessNotifier.ShowAfterRedirect = true; Response.Redirect(Request.RawUrl, false); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
public bool Save(int id, string text) { bool result = false; using (context = new TwitterEntities()) { var tweet = GetById(id); tweet.Body = text; context.Entry(tweet).State = EntityState.Modified; result = context.SaveChanges() > 0; Logger.Log.Debug("user ID:" + tweet.User_Id + " " + userDao.GetById(tweet.User_Id).Email + " edited a tweet ID:" + tweet.Id); } return result; }