//Enable Edits to the users public ActionResult Edit(string sUserName, bool bAlert, bool bDM) { try { // TODO: Add update logic here Unfollower.Models.TwitterUserContext dbContext = new Models.TwitterUserContext(); Unfollower.Models.TwitterUser myUser = null; try { if (dbContext.Tweeps.Count() > 0) { List<Unfollower.Models.TwitterUser> userlist = dbContext.Tweeps.ToList(); foreach (Unfollower.Models.TwitterUser us in userlist) { if (us.Username == sUserName) { myUser = us; break; } } } } catch { } // create user if (myUser != null) { myUser.DoAlert = bAlert; myUser.DirectMessage = bDM; if (myUser.Username.IndexOf("@") > -1) myUser.Username = myUser.Username.Replace("@", ""); dbContext.Entry(myUser).State = System.Data.EntityState.Modified; dbContext.SaveChanges(); ViewBag.Result = "Good"; } return View(); } catch { ViewBag.Result = "Exception"; return View(); } }
public ActionResult DeleteUser(string sUserName) { Database.DefaultConnectionFactory = new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0"); Unfollower.Models.TwitterUserContext dbContext = new Models.TwitterUserContext(); Unfollower.Models.TwitterUser myUser = null; try { if (dbContext.Tweeps.Count() > 0) { List<Unfollower.Models.TwitterUser> userlist = dbContext.Tweeps.ToList(); foreach (Unfollower.Models.TwitterUser us in userlist) { if (us.Username == sUserName) { myUser = us; break; } } } } catch { } if (myUser != null) { while (myUser.Unfollowers.Count > 0) { Models.Unfollowers foll = myUser.Unfollowers.ElementAt(0); dbContext.Entry(foll).State = System.Data.EntityState.Deleted; } while (myUser.Followers.Count > 0) { Models.Follower unf = myUser.Followers.ElementAt(0); dbContext.Entry(unf).State = System.Data.EntityState.Deleted; } while (myUser.Alerts.Count > 0) { Models.Alert ale = myUser.Alerts.ElementAt(0); dbContext.Entry(ale).State = System.Data.EntityState.Deleted; } dbContext.Entry(myUser).State = System.Data.EntityState.Deleted; dbContext.SaveChanges(); } return View(); }
// // GET: /Tweeps/Create public ActionResult Create() { Database.DefaultConnectionFactory = new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0"); Unfollower.Models.TwitterUserContext dbContext = new Models.TwitterUserContext(); Unfollower.Models.TwitterUser myUser = null; if (dbContext.Tweeps.Count() > 0) { List<Unfollower.Models.TwitterUser> userlist = dbContext.Tweeps.ToList(); foreach (Unfollower.Models.TwitterUser us in userlist) { // Has alerts if (us.DoAlert == true) { if (us.Alerts.Count() > 0) { // Send a tweet with all alerts string sMessage = "@" + us.Username + " list of users that unfollowed you: "; string slast = ""; foreach (Models.Alert unf in us.Alerts) { if (unf.Username.ToLower() != slast.ToLower()) { if ( !sMessage.Contains(unf.Username) ) sMessage += " @" + unf.Username; } slast = unf.Username; } if (sMessage.Length > 140) { sMessage = sMessage.Substring(0, 135); sMessage += "..."; } try { // Send Notification if (us.DeviceToken != null) { if (us.DeviceToken.Length > 4) Utils.AppleNotification.SendNotification(us.DeviceToken, sMessage); } } catch { } if (us.DirectMessage == true) { ViewBag.Result += "DM " + sMessage + "</BR>"; Utils.TwitterUtils.SendTweet(sMessage, Int32.Parse(us.ID)); } else if (us.DoAlert == true) { ViewBag.Result += "Tweet " + sMessage + "</BR>"; Utils.TwitterUtils.SendTweet(sMessage, 0); } // Delete all alerts while (us.Alerts.Count > 0) { Models.Alert alert = us.Alerts.ElementAt(0); dbContext.Entry(alert).State = System.Data.EntityState.Deleted; } dbContext.SaveChanges(); } } else { if (us.Alerts.Count() > 0) { while (us.Alerts.Count > 0) { Models.Alert alert = us.Alerts.ElementAt(0); dbContext.Entry(alert).State = System.Data.EntityState.Deleted; } dbContext.SaveChanges(); } } } } return View(); }
public ActionResult CleanUsers() { Database.DefaultConnectionFactory = new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0"); Unfollower.Models.TwitterUserContext dbContext = new Models.TwitterUserContext(); List<Unfollower.Models.TwitterUser> userlist = dbContext.Tweeps.ToList(); for (int i = 0; i < userlist.Count; i++) { if (i + 1 < userlist.Count) { Unfollower.Models.TwitterUser myUser = userlist[i]; Unfollower.Models.TwitterUser myUser2 = userlist[i + 1]; if (myUser.Username == myUser2.Username) { //dbContext.Entry(myUser.Unfollowers).State = System.Data.EntityState.Deleted; //dbContext.Entry(myUser.Followers).State = System.Data.EntityState.Deleted; //dbContext.Entry(myUser.Alerts).State = System.Data.EntityState.Deleted; while (myUser.Unfollowers.Count > 0) { Models.Unfollowers foll = myUser.Unfollowers.ElementAt(0); dbContext.Entry(foll).State = System.Data.EntityState.Deleted; } while (myUser.Followers.Count > 0) { Models.Follower unf = myUser.Followers.ElementAt(0); dbContext.Entry(unf).State = System.Data.EntityState.Deleted; } while (myUser.Alerts.Count > 0) { Models.Alert ale = myUser.Alerts.ElementAt(0); dbContext.Entry(ale).State = System.Data.EntityState.Deleted; } dbContext.Entry(myUser).State = System.Data.EntityState.Deleted; } } } dbContext.SaveChanges(); return View(); }
public ActionResult CleanUnfollowers() { Database.DefaultConnectionFactory = new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0"); Unfollower.Models.TwitterUserContext dbContext = new Models.TwitterUserContext(); List<Unfollower.Models.TwitterUser> userlist = dbContext.Tweeps.ToList(); for (int i = 0; i < userlist.Count; i++) { Unfollower.Models.TwitterUser myUser = userlist[i]; for (int u = 0; u < myUser.Unfollowers.Count; u++) { ViewBag.Results += "#" + myUser.Username + " cleaning: "; if (u + 1 < myUser.Unfollowers.Count) { Models.Unfollowers unfollow = myUser.Unfollowers.ElementAt(u); Models.Unfollowers unfollow2 = myUser.Unfollowers.ElementAt(u + 1); if (unfollow2.Username == unfollow.Username) { ViewBag.Results += unfollow.Username + ","; dbContext.Entry(unfollow).State = System.Data.EntityState.Deleted; } } } // Save at the end dbContext.SaveChanges(); } return View(); }
public ActionResult AddToken(string sUserName, string sToken) { try { // TODO: Add update logic here Unfollower.Models.TwitterUserContext dbContext = new Models.TwitterUserContext(); Unfollower.Models.TwitterUser myUser = null; try { if (dbContext.Tweeps.Count() > 0) { List<Unfollower.Models.TwitterUser> userlist = dbContext.Tweeps.ToList(); foreach (Unfollower.Models.TwitterUser us in userlist) { if (us.Username == sUserName) { myUser = us; break; } } } } catch { } // create user if (myUser != null) { myUser.DeviceToken = sToken; dbContext.Entry(myUser).State = System.Data.EntityState.Modified; dbContext.SaveChanges(); ViewBag.Result = "Good"; } return View(); } catch { ViewBag.Result = "Exception"; return View(); } }