public void CreateHtmlAnchor_Test()
{
var text = "@twitterapi #BreakingMyTwitter https://t.co/mIJcSoVSK3";
var entities = new TwitterEntities
{
UserMentions = new[]
{
new TwitterEntityMention {
Indices = new[] { 0, 11 }, ScreenName = "twitterapi"
},
},
Hashtags = new[]
{
new TwitterEntityHashtag {
Indices = new[] { 12, 30 }, Text = "BreakingMyTwitter"
},
},
Urls = new[]
{
new TwitterEntityUrl
{
Indices = new[] { 31, 54 },
Url = "https://t.co/mIJcSoVSK3",
DisplayUrl = "apps-of-a-feather.com",
ExpandedUrl = "http://apps-of-a-feather.com/",
},
},
};
var expectedHtml = @"<a class=""mention"" href=""https://twitter.com/twitterapi"">@twitterapi</a>"
+ @" <a class=""hashtag"" href=""https://twitter.com/search?q=%23BreakingMyTwitter"">#BreakingMyTwitter</a>"
+ @" <a href=""https://t.co/mIJcSoVSK3"" title=""https://t.co/mIJcSoVSK3"">apps-of-a-feather.com</a>";
Assert.Equal(expectedHtml, Twitter.CreateHtmlAnchor(text, entities, quotedStatusLink: null));
}
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);
}
}
private async Task SetDescriptionAsync(string descriptionText, TwitterEntities entities, CancellationToken cancellationToken)
{
if (descriptionText != null)
{
foreach (var entity in entities.Urls)
{
entity.ExpandedUrl = await ShortUrl.Instance.ExpandUrlAsync(entity.ExpandedUrl);
}
// user.entities には urls 以外のエンティティが含まれていないため、テキストをもとに生成する
entities.Hashtags = TweetExtractor.ExtractHashtagEntities(descriptionText).ToArray();
entities.UserMentions = TweetExtractor.ExtractMentionEntities(descriptionText).ToArray();
var html = TweetFormatter.AutoLinkHtml(descriptionText, entities);
html = this.mainForm.createDetailHtml(html);
if (cancellationToken.IsCancellationRequested)
{
return;
}
this.DescriptionBrowser.DocumentText = html;
}
else
{
this.DescriptionBrowser.DocumentText = "";
}
}
public void CreateAccessibleText_QuotedUrlWithPermelinkTest()
{
var text = "hoge";
var entities = new TwitterEntities();
var quotedStatus = new TwitterStatus
{
Id = 1234567890L,
IdStr = "1234567890",
User = new TwitterUser
{
Id = 1111,
IdStr = "1111",
ScreenName = "foo",
},
FullText = "test",
};
var quotedStatusLink = new TwitterQuotedStatusPermalink
{
Url = "https://t.co/hoge",
Display = "twitter.com/hoge/status/1…",
Expanded = "https://twitter.com/hoge/status/1234567890",
};
var expectedText = "hoge " + string.Format(Properties.Resources.QuoteStatus_AccessibleText, "foo", "test");
Assert.Equal(expectedText, Twitter.CreateAccessibleText(text, entities, quotedStatus, quotedStatusLink));
}
// 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);
}
public void CreateHtmlAnchor_QuotedUrlWithPermelinkTest()
{
var text = "hoge";
var entities = new TwitterEntities();
var quotedStatus = new TwitterStatus
{
Id = 1234567890L,
IdStr = "1234567890",
User = new TwitterUser
{
Id = 1111,
IdStr = "1111",
ScreenName = "foo",
},
FullText = "test",
};
var quotedStatusLink = new TwitterQuotedStatusPermalink
{
Url = "https://t.co/hoge",
Display = "twitter.com/hoge/status/1…",
Expanded = "https://twitter.com/hoge/status/1234567890",
};
var expectedHtml = @"hoge"
+ @" <a href=""https://t.co/hoge"" title=""https://t.co/hoge"">twitter.com/hoge/status/1…</a>";
Assert.Equal(expectedHtml, Twitter.CreateHtmlAnchor(text, entities, quotedStatusLink));
}
public List <TwitLocal> GetAllTwits(int id)
{
using (db = new TwitterEntities())
{
List <TwitLocal> twits = new List <TwitLocal>();
foreach (var u in db.UserFollows.Where(x => x.FollowerId == id))
{
foreach (var t in db.Twits.Where(x => x.UserId == u.FollowedId))
{
TwitLocal tl = new TwitLocal();
tl.Id = t.Id;
tl.Content = t.TwitContent;
tl.Date = t.Date;
tl.Fav = db.TwitFavs.Count(x => x.TwitId == t.Id && x.UserId == id);
User user = db.Users.FirstOrDefault(x => x.Id == t.UserId);
tl.Username = user.Username;
tl.Name = user.Name;
if (db.TwitFavs.Any(x => x.TwitId == t.Id && x.UserId == id))
{
tl.isFav = true;
}
else
{
tl.isFav = false;
}
twits.Add(tl);
}
}
return(twits.OrderByDescending(x => x.Id).ToList());
}
}
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 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 Location Get(int id)
{
using (var context = new TwitterEntities())
{
return context.Locations.SingleOrDefault(x => x.ID == id);
}
}
public IQueryable <Twitter.Models.AspNetUser> ListViewRegularUsers_GetData()
{
TwitterEntities context = new TwitterEntities();
string username = User.Identity.Name;
HashSet <AspNetUser> users = new HashSet <AspNetUser>();
var allUsers = context.AspNetUsers.
Where(x => x.UserName != username);
foreach (AspNetUser user in allUsers)
{
bool isAdmin = false;
foreach (var role in user.AspNetRoles)
{
if (role.Name == "Admin")
{
isAdmin = true;
break;
}
}
if (!isAdmin)
{
users.Add(user);
}
}
return(users.AsQueryable());
}
private static JToken DeserializeEntities(JToken relevant)
{
var results = new TwitterEntities();
var entities = relevant["entities"];
if (entities != null)
{
var mentions = entities["user_mentions"];
if (mentions != null)
{
DeserializeMentions(results, mentions);
}
var urls = entities["urls"];
if (urls != null)
{
DeserializeUrls(results, urls);
}
var hashtags = entities["hashtags"];
if (hashtags != null)
{
DeserializeHashtags(results, hashtags);
}
}
if (results.Count() > 0)
{
var replacer = JsonConvert.SerializeObject(results);
return(JObject.Parse(replacer));
}
return(null);
}
// 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();
}
}
private static void DeserializeHashtags(TwitterEntities results, JToken hashtags)
{
var value = hashtags.ToString();
if (value.Equals("Null", StringComparison.InvariantCultureIgnoreCase))
{
return;
}
var inner = hashtags["hashtag"];
if (inner.Type == JTokenType.Array)
{
var array = JArray.Parse(inner.ToString());
foreach (var hashtag in from item in array
let indices = ParseEntityIndices(item)
select ParseHashTag(indices, item))
{
results.HashTags.Add(hashtag);
}
}
switch (inner.Type)
{
case JTokenType.Object:
{
var item = JObject.Parse(inner.ToString());
var indices = ParseEntityIndices(item);
results.HashTags.Add(ParseHashTag(indices, item));
}
break;
}
}
private static void DeserializeMentions(TwitterEntities results, JToken mentions)
{
var value = mentions.ToString();
if (value.Equals("Null", StringComparison.InvariantCultureIgnoreCase))
{
return;
}
var inner = mentions["user_mention"];
if (inner.Type == JTokenType.Array)
{
var array = JArray.Parse(inner.ToString());
foreach (var mention in from item in array
let indices = ParseEntityIndices(item)
select ParseMention(indices, item))
{
results.Mentions.Add(mention);
}
}
switch (inner.Type)
{
case JTokenType.Object:
{
var item = JObject.Parse(inner.ToString());
var indices = ParseEntityIndices(item);
results.Mentions.Add(ParseMention(indices, item));
}
break;
}
}
public IQueryable <Channel> GridViewChannels_GetData()
{
TwitterEntities context = new TwitterEntities();
string currentUser = User.Identity.Name;
return(context.Channels.Include("AspNetUser").OrderBy(ch => ch.ChannelId).Where(x => x.AspNetUser.UserName == currentUser));
}
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);
}
}
public IList<User> GetAll()
{
using (var context = new TwitterEntities())
{
return context.Users.ToList();
}
}
// 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();
}
}
public IList<Location> GetAll()
{
using (var context = new TwitterEntities())
{
return context.Locations.ToList();
}
}
public void CreateAccessibleText_QuotedUrlTest()
{
var text = "https://t.co/hoge";
var entities = new TwitterEntities
{
Urls = new[]
{
new TwitterEntityUrl
{
Indices = new[] { 0, 17 },
Url = "https://t.co/hoge",
DisplayUrl = "twitter.com/hoge/status/1…",
ExpandedUrl = "https://twitter.com/hoge/status/1234567890",
},
},
};
var quotedStatus = new TwitterStatus
{
Id = 1234567890L,
IdStr = "1234567890",
User = new TwitterUser
{
Id = 1111,
IdStr = "1111",
ScreenName = "foo",
},
FullText = "test",
};
var expectedText = string.Format(Properties.Resources.QuoteStatus_AccessibleText, "foo", "test");
Assert.Equal(expectedText, Twitter.CreateAccessibleText(text, entities, quotedStatus, quotedStatusLink: null));
}
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 IQueryable<Tweet> LatestTweetsListView_GetLatestTweets()
{
var context = new TwitterEntities();
return context.Tweets
.Include("Comments")
.Include("AspNetUser")
.OrderByDescending(t => t.DatePosted);
}
public User Get(int id)
{
using (var context = new TwitterEntities())
{
return context.Users
.SingleOrDefault(u => u.Id == id);
}
}
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 void Create(User user)
{
using (var context = new TwitterEntities())
{
context.Users.Add(user);
context.SaveChanges();
}
}
public ICollection<Tweet> GetList()
{
ICollection<Tweet> result;
using (context = new TwitterEntities())
{
result = context.Tweets.ToList();
}
return result;
}
public void AutoLinkHtml_EntityNullTest()
{
var text = "てすとてすとー";
TwitterEntities entities = null;
var expected = "てすとてすとー";
Assert.Equal(expected, TweetFormatter.AutoLinkHtml(text, entities));
}
public void AutoLinkHtml_BreakLineTest()
{
var text = "てすと\nてすと\nてすと";
TwitterEntities entities = null;
var expected = "てすと<br>てすと<br>てすと";
Assert.Equal(expected, TweetFormatter.AutoLinkHtml(text, entities));
}
public void CreateHtmlAnchor_NicovideoTest()
{
var text = "sm9";
var entities = new TwitterEntities();
var expectedHtml = @"<a href=""https://www.nicovideo.jp/watch/sm9"">sm9</a>";
Assert.Equal(expectedHtml, Twitter.CreateHtmlAnchor(text, entities, quotedStatusLink: null));
}
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);
}
}
public ICollection<User> GetList()
{
ICollection<User> result;
using (var context = new TwitterEntities())
{
result = context.Users.ToList();
}
return result;
}
public IQueryable <Message> GridViewChannels_GetData()
{
TwitterEntities context = new TwitterEntities();
string currentUserName = User.Identity.Name;
var messages = context.AspNetUsers.Include("Messages").
FirstOrDefault(x => x.UserName == currentUserName).Messages.OrderBy(m => m.MessageId).AsQueryable();
return(messages);
}
public IQueryable <Twitter.Models.AspNetUser> ListViewUsers_GetData()
{
TwitterEntities context = new TwitterEntities();
string username = User.Identity.Name;
var allUsers = context.AspNetUsers.
Where(x => x.UserName != username).AsQueryable();
return(allUsers);
}
protected void Page_PreRender(object sender, EventArgs e)
{
TwitterEntities context = new TwitterEntities();
var channels = context.Channels.ToList();
this.DropDownListChannels.DataSource = channels;
this.DropDownListChannels.DataTextField = "Name";
this.DropDownListChannels.DataValueField = "ChannelId";
this.DropDownListChannels.DataBind();
}
public IQueryable <Message> GridViewChannels_GetData()
{
TwitterEntities context = new TwitterEntities();
int channelId = Convert.ToInt32(Request.Params["channelId"]);
var messages = context.Messages.Include("Channel").
Where(x => x.ChannelId == channelId);
return(messages.OrderBy(m => m.MessageId));
}
public User GetById(int id)
{
User result = null;
using (var context = new TwitterEntities())
{
result = context.Users.FirstOrDefault(x => x.Id == id);
}
return result;
}
protected void Page_Load(object sender, EventArgs e)
{
TwitterEntities context = new TwitterEntities();
string username = User.Identity.Name;
var currentUser = context.AspNetUsers.FirstOrDefault(x => x.UserName == username);
var following = currentUser.AspNetUsers1.ToList();
this.UsersControlFriends.DataSource = following;
}
protected void Page_Load(object sender, EventArgs e)
{
TwitterEntities context = new TwitterEntities();
string username = User.Identity.Name;
var allUsers = context.AspNetUsers.Where(x => x.UserName != username).ToList();
this.ListViewAllUsers.DataSource = allUsers;
this.ListViewAllUsers.DataBind();
}
// 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 static TwitterEntities ParseTwitterageToEntities(this string text)
{
var entities = new TwitterEntities
{
HashTags = new List<TwitterHashTag>(ParseTwitterageToHashTags(text)),
Mentions = new List<TwitterMention>(ParseTwitterageToMentions(text)),
Urls = new List<TwitterUrl>(ParseTwitterageToUrls(text))
};
return entities;
}
public IList<Tweet> GetAll()
{
using (var context = new TwitterEntities())
{
return context.Tweets
.Include("Author")
.Include("Comments")
.Include("Comments.User")
.Include("FavouriteTweets")
.Include("FavouriteTweets.User")
.ToList();
}
}
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 Tweet Get(int id)
{
using (var context = new TwitterEntities())
{
return context.Tweets
.Include("Author")
.Include("Comments")
.Include("Comments.User")
.Include("FavouriteTweets")
.Include("FavouriteTweets.User")
.SingleOrDefault(t => t.ID == id);
}
}
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;
}
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 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();
}
}
}
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();
}
}
}
public AspNetUser UserDetailsFormView_GetUserInfo([QueryString] string Username)
{
var context = new TwitterEntities();
if (!string.IsNullOrEmpty(Username))
{
return context.AspNetUsers
.FirstOrDefault(u => u.UserName == Username);
}
else
{
var userID = User.Identity.GetUserId();
return context.AspNetUsers
.FirstOrDefault(u => u.Id == userID);
}
}
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;
}
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 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();
}
}
}
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;
}
public IQueryable<Tweet> UserTweetsListView_GetUserTweets([QueryString] string Username)
{
var context = new TwitterEntities();
if (!string.IsNullOrEmpty(Username))
{
return context.Tweets
.Include("Comments")
.Include("AspNetUser")
.Where(t => t.AspNetUser.UserName == Username)
.OrderByDescending(t => t.DatePosted)
.AsQueryable();
}
else
{
var userID = User.Identity.GetUserId();
return context.Tweets
.Include("Comments")
.Include("AspNetUser")
.Where(t => t.AspNetUser.Id == userID)
.OrderByDescending(t => t.DatePosted)
.AsQueryable();
}
}
