public static bool SaveTweet(TweetMessageViewModel tweetMsg)
{
bool IsSuccess = false;
try
{
using (var _context = new TwitterCloneDBEntities())
{
var tweets = _context.People.Where(x => x.user_id.Trim().ToUpper() == tweetMsg.userid.Trim().ToUpper()).FirstOrDefault();
var tweet = tweets.TWEETs.Where(x => x.tweet_id == tweetMsg.TweetId).FirstOrDefault();//_context.TWEETs.Where(x => x.tweet_id == tweetMsg.TweetId).FirstOrDefault();
if (tweet == null && tweetMsg.TweetId == 0)
{
tweet = new TWEET();
tweet.user_id = tweetMsg.userid;
tweet.message = tweetMsg.TweetMessage;
tweet.created = DateTime.Now;
_context.Entry(tweet).State = EntityState.Added;
}
else
{
tweet.message = tweetMsg.TweetMessage;
}
IsSuccess = true;
_context.SaveChanges();
}
}
catch (Exception ex)
{
}
return(IsSuccess);
}
public static void TransToTweetData()
{
for (int i = 0; i < Info.items.Count; i++)
{
TWEET a = Info.items [i];
TweetData tweet = new TweetData();
tweet.id = a.tweet_id;
tweet.userId = a.user_id;
tweet.info = a.tweet_info;
tweet.order = a.order;
tweet.isSecret = a.is_secret;
tweet.pics = new int[a.pic_array.Count];
for (int m = 0; m < tweet.pics.Length; m++)
{
tweet.pics[m] = a.pic_array[m];
}
tweet.location = a.location;
List <TweetData> tweets;
if (ZoneManager.Instance.id2Tweet.TryGetValue(a.user_id, out tweets))
{
}
else
{
tweets = new List <TweetData> ();
ZoneManager.Instance.id2Tweet.Add(a.user_id, tweets);
}
tweets.Add(tweet);
}
}
public void DeleteTweet(int id)
{
TWEET tweet = db.TWEET.Find(id);
db.TWEET.Remove(tweet);
db.SaveChanges();
}
public JsonResult UpdateTweet(TWEET tweet)
{
tweet.user_id = Session["UserId"].ToString();
tweet.created = DateTime.Now;
tweetObj.UpdateTweet(tweet);
return(Json("", JsonRequestBehavior.AllowGet));
}
public JsonResult AddTweet(TWEET tweet)
{
tweet.user_id = Session["UserId"].ToString();
tweet.created = DateTime.Now;
tweetObj.AddTweet(tweet);
Session["MessageCount"] = tweetObj.GetById(tweet.user_id).Count();
return(Json("", JsonRequestBehavior.AllowGet));
}
public void AddTweet(TWEET tweet)
{
using (TweetContext db = new TweetContext())
{
db.tweets.Add(tweet);
db.SaveChanges();
}
}
public ActionResult DeleteConfirmed(int id)
{
TWEET tWEET = db.TWEETs.Find(id);
db.TWEETs.Remove(tWEET);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(TWEET Tweet)
{
if (ModelState.IsValid)
{
twitterBAL.UpdateTweet(Tweet);
}
return(RedirectToAction("Home"));
}
public void DeleteTweet(TWEET tweet)
{
using (TweetContext db = new TweetContext())
{
TWEET obj = db.tweets.Find(tweet.tweet_id);
db.tweets.Remove(obj);
db.SaveChanges();
}
}
public void UpdateTweet(TWEET tweet)
{
using (TweetContext db = new TweetContext())
{
TWEET obj = db.tweets.Find(tweet.tweet_id);
obj.message = tweet.message;
obj.created = tweet.created;
db.SaveChanges();
}
}
public ActionResult EditTweet(int id, string userId, TWEET tweet)
{
var p = db.Person.FirstOrDefault(t => t.user_id == userId);
var tw = db.TWEETs.FirstOrDefault(a => a.tweet_id == id);
tw.message = tweet.message;
db.SaveChanges();
return(RedirectToAction("Index", "Home", p));
}
public ActionResult Create(TWEET tweet)
{
if (ModelState.IsValid)
{
tweet.User_ID = System.Web.HttpContext.Current.User.Identity.Name;
tweet.Created = DateTime.Now;
twitterBAL.AddTweet(tweet);
}
return(RedirectToAction("Home"));
}
public ActionResult PostTwitte(string messagePost)
{
TWEET twts = new TWEET();
twts.message = messagePost;
twts.Created = DateTime.Now;
twts.user_id = User.Identity.Name;
db.TWEETs.Add(twts);
db.SaveChanges();
string message = "SUCCESS";
return(Json(new { Message = message, JsonRequestBehavior.AllowGet }));
}
// GET: TWEETs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TWEET tWEET = db.TWEETs.Find(id);
if (tWEET == null)
{
return(HttpNotFound());
}
return(View(tWEET));
}
public ActionResult Edit([Bind(Include = "tweet_id,user_id,message,created")] TWEET tWEET)
{
if (ModelState.IsValid)
{
tWEET.user_id = Session["user"].ToString();
tWEET.created = DateTime.Now;
db.Entry(tWEET).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.user_id = new SelectList(db.People, "user_id", "password", tWEET.user_id);
return(View(tWEET));
}
public ActionResult Create(TWEET tWEET)
{
if (ModelState.IsValid)
{
tWEET.user_id = Session["user"].ToString();
tWEET.created = DateTime.Now;
db.TWEETs.Add(tWEET);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.user_id = new SelectList(db.People, "user_id", "password", tWEET.user_id);
return(View(tWEET));
}
public Profile NewTweet(Tweet tweet, string user)
{
TwitterDBContext twitterDBContext = new TwitterDBContext();
Assignment1.TWEET tObj = new TWEET();
tObj.user_id = user;
tObj.message = tweet.message;
tObj.created = DateTime.Now;
twitterDBContext.TWEETs.Add(tObj);
twitterDBContext.SaveChanges();
var person = twitterDBContext.People.Where(m => m.user_id == user).FirstOrDefault();
Profile pObj = new Profile();
var selfTweets = person.TWEETs;
pObj.selfTweets = new List <Tweet>();
foreach (var item in selfTweets)
{
pObj.selfTweets.Add(new Tweet {
created = item.created, message = item.message, user_id = item.user_id
});
}
var following = person.FOLLOWINGs1;
pObj.following = new List <Person>();
foreach (var item in following)
{
pObj.following.Add(new Person {
user_id = item.following_id
});
}
pObj.allTweets = new List <Tweet>();
pObj.allTweets.AddRange(pObj.selfTweets);
foreach (var item in pObj.following)
{
var followingTweet = twitterDBContext.TWEETs.Where(m => m.user_id == item.user_id);
foreach (var value in followingTweet)
{
pObj.allTweets.Add(new Tweet {
created = value.created, message = value.message, user_id = value.user_id
});
}
}
pObj.allTweets = pObj.allTweets.OrderByDescending(m => m.created).ToList();
return(pObj);
}
// GET: TWEETs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TWEET tWEET = db.TWEETs.Find(id);
if (tWEET == null)
{
return(HttpNotFound());
}
ViewBag.user_id = new SelectList(db.People, "user_id", "password", tWEET.user_id);
return(View(tWEET));
}
public ActionResult Tweet(TweetsViewModel objModel)
{
if (ModelState.IsValid)
{
var objTweet = new TWEET();
objTweet.message = objModel.message;
objTweet.created = DateTime.Now;
objTweet.user_id = User.Identity.Name;
var tRep = new TweetRepository();
tRep.AddTweet(objTweet);
ViewBag.msg = "Tweeted!!";
}
return(View(objModel));
}
public ActionResult EditTweet(TweetsViewModel objTweetModel)
{
if (ModelState.IsValid)
{
var objTweet = new TWEET();
objTweet.message = objTweetModel.message;
objTweet.created = DateTime.Now;
objTweet.user_id = User.Identity.Name;
objTweet.tweet_id = objTweetModel.tweet_id;
var tRep = new TweetRepository();
tRep.EditTweet(objTweet);
ViewBag.msg = "Editted Successfully";
}
else
{
ViewBag.msg = "Error Occured";
}
return(View(objTweetModel));
}
public string UpdateTweet(TweetEntity tweets)
{
try
{
var person = new TWEET()
{
tweet_id = tweets.tweet_id,
user_id = tweets.user_id,
message = tweets.message,
created = tweets.created
};
using (var Connection = new TwitterApplicationEntities())
{
Connection.TWEETs.Add(person);
Connection.SaveChanges();
}
return("Tweet Updated Successfully");
}
catch (Exception exception)
{
throw new Exception(exception.Message.ToString(), exception);
}
}
public void UpdateTweet(TWEET tweet)
{
db.TWEET.Find(tweet.Tweet_ID).Message = tweet.Message;
db.SaveChanges();
}
public void SetMessage(TWEET obj)
{
db.TWEETs.Add(obj);
db.SaveChanges();
}
public void AddTweet(TWEET tweet)
{
db.TWEET.Add(tweet);
db.SaveChanges();
}
public void guardaTweets()
{
List <TWEET> tweets = new List <TWEET>();
try
{
// 1. LEE CUENTAS BDD
List <TWEETER_ACCOUNT> cuentas = new List <TWEETER_ACCOUNT>();
cuentas = bdd.getAccountsTwitter();
foreach (TWEETER_ACCOUNT a in cuentas)
{
Console.WriteLine("");
Console.WriteLine("CUENTA " + a.accountName);
// 2.1 GUARDA ULTIMOS TWEETS.
var httpClient = new HttpClient();
var request = new HttpRequestMessage(HttpMethod.Post, "https://api.twitter.com/oauth2/token ");
var customerInfo = Convert.ToBase64String(new UTF8Encoding().GetBytes("xx" + ":" + "yy"));
request.Headers.Add("Authorization", "Basic " + customerInfo);
request.Content = new StringContent("grant_type=client_credentials", Encoding.UTF8, "application/x-www-form-urlencoded");
HttpResponseMessage response = httpClient.SendAsync(request).Result;
string json = response.Content.ReadAsStringAsync().Result;
var serializer = new JavaScriptSerializer();
dynamic item = serializer.Deserialize <object>(json);
var token = item["access_token"];
var requestUserTimeline = new HttpRequestMessage(HttpMethod.Get, string.Format("https://api.twitter.com/1.1/statuses/user_timeline.json?count={0}&screen_name={1}&trim_user=1&exclude_replies=1", 20, a.accountName));
requestUserTimeline.Headers.Add("Authorization", "Bearer " + token);
httpClient = new HttpClient();
HttpResponseMessage responseUserTimeLine = httpClient.SendAsync(requestUserTimeline).Result;
serializer = new JavaScriptSerializer();
dynamic json2 = serializer.Deserialize <object>(responseUserTimeLine.Content.ReadAsStringAsync().Result);
var enumerableTwitts = (json2 as IEnumerable <dynamic>);
//IEnumerable<string> twitts = Twitter_ .GetTwitts(a.accountName, 20).Result;
foreach (var t in enumerableTwitts)
{
TWEET tt = new TWEET();
tt.idCuenta = a.id;
tweetElemet pepe = (tweetElemet)t;
tt.texto = t[3].Value;
tweets.Add(tt);
Console.WriteLine(tt.texto);
}
}
// bdd.altaTweets(tweets);
}
catch (Exception ex)
{
throw;
}
}
public JsonResult DeleteTweet(TWEET tweet)
{
tweetObj.DeleteTweet(tweet);
return(Json("", JsonRequestBehavior.AllowGet));
}
