public List <TweetMessage> GetAllTweets(string userName)
{
List <TweetMessage> lstTweetMessage = new List <TweetMessage>();
try
{
using (_dbContext = new TwitterCloneEntities())
{
var tweets = _dbContext.Tweets.ToList();// .Where(x => x.User_Id.Trim().ToUpper() == userName.ToUpper().Trim());
lstTweetMessage = tweets.Select(t =>
new TweetMessage
{
Tweet_Id = t.Tweet_Id,
Message = t.Message,
User_Id = t.User_Id,
Created = t.Created ?? DateTime.Now,
IsUserTweet = t.User_Id.Trim().ToUpper() == userName.ToUpper().Trim() ? true : false
}).ToList();
}
}
catch (Exception ex)
{
}
return(lstTweetMessage);
}
/// <summary>
/// Retrieves a lit of tweets based on user id
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
private List <Tweet> GetTweets(int userId)
{
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
return(db.Tweets.Where(x => x.UserId == userId).OrderBy(x => x.TweetTime).ToList());
}
}
public bool SaveTweet(TweetMessage tweetMsg)
{
bool IsSuccess = false;
try
{
using (_dbContext = new TwitterCloneEntities())
{
var tweets = _dbContext.People.Where(x => x.User_Id.Trim().ToUpper() == tweetMsg.User_Id.Trim().ToUpper()).FirstOrDefault();
var tweet = _dbContext.Tweets.Where(x => x.Tweet_Id == tweetMsg.Tweet_Id).FirstOrDefault();
if (tweet == null && tweetMsg.Tweet_Id == 0)
{
tweet = new Tweet();
tweet.User_Id = tweetMsg.User_Id;
tweet.Message = tweetMsg.Message;
tweet.Created = DateTime.Now;
_dbContext.Entry(tweet).State = System.Data.Entity.EntityState.Added;
}
else
{
tweet.Message = tweetMsg.Message;
}
IsSuccess = true;
_dbContext.SaveChanges();
}
}
catch (Exception ex)
{
}
return(IsSuccess);
}
public TweetModel GetTweetMessageDetails(string userName)
{
TweetModel tweetModel = new TweetModel();
try
{
using (_dbContext = new TwitterCloneEntities())
{
var tweets = _dbContext.Tweets.Where(x => x.User_Id.Trim().ToUpper() == userName.ToUpper().Trim());
var following = _dbContext.Followings.Where(x => x.User_Id.Trim().ToUpper() == userName.ToUpper().Trim());
var followers = _dbContext.Followings.Where(x => x.Following_id.Trim().ToUpper() == userName.ToUpper().Trim());
if (tweets != null)
{
tweetModel.TotalTweets = tweets.Count();
}
if (followers != null)
{
tweetModel.TotalFollowers = followers.Count();
}
if (following != null)
{
tweetModel.TotalFollowing = following.Count();
}
}
}
catch (Exception ex)
{
}
return(tweetModel);
}
public List <Tweet> GetTweets(string userId)
{
List <Tweet> tweets = new List <Tweet>();
List <Tweet> FollowingTweets = new List <Tweet>();
List <Following> followings = new List <Following>();
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
tweets = (from t in db.Tweets
where t.UserId == userId
select t
).OrderBy(x => x.CreatedDate).ToList();
followings = (from f in db.Followings
where f.UserId == userId
select f
).ToList();
foreach (var item in followings)
{
FollowingTweets = (from t in db.Tweets
where t.UserId == item.FollowingId
select t
).OrderBy(x => x.CreatedDate).ToList();
foreach (var tweet in FollowingTweets)
{
tweets.Add(tweet);
}
}
}
return(tweets);
}
public void AddUser(Person item)
{
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
db.People.Add(item);
db.SaveChanges();
}
}
public Person ValidateUser(string name, string pw)
{
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
Person people = db.People.FirstOrDefault(i => i.UserId == name && i.Password == pw && i.Active == true);
return(people);
}
}
public Person Validate(string uname, string pwd)
{
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
Person obj = db.People.FirstOrDefault(i => i.UserId == uname && i.Password == pwd && i.Active == true);
return(obj);
}
}
public Person SearchUser(string uname)
{
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
Person obj = db.People.FirstOrDefault(i => i.UserId.Contains(uname));
return(obj);
}
}
public void DeleteTweet(int tweetId)
{
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
Tweet twt;
twt = GetTweetById(tweetId);
db.Entry(twt).State = EntityState.Deleted;
db.SaveChanges();
}
}
public Tweet GetTweetById(int Id)
{
Tweet twt = new Tweet();
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
twt = (from a in db.Tweets where a.TweetId == Id select a).SingleOrDefault();
}
return(twt);
}
public List <string> GetUserList()
{
List <string> lstUser = new List <string>();
using (_dbContext = new TwitterCloneEntities())
{
lstUser = _dbContext.People.Select(x => x.User_Id).ToList();
}
return(lstUser != null ? lstUser : new List <string>());
}
public bool UserAlreadyExists(string userId)
{
bool isUserExist = false;
using (_dbContext = new TwitterCloneEntities())
{
var items = _dbContext.People.Where(x => x.User_Id.ToLower().Trim() == userId.ToLower().Trim()).FirstOrDefault();
isUserExist = (items == null) ? false : true;
}
return(isUserExist);
}
public ActionResult AddTweet(string tweetText)
{
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
var tweet = new Tweet();
tweet.TweetText = tweetText;
tweet.TweetTime = DateTime.Now;
tweet.UserId = (int)Session["Id"];
db.Tweets.Add(tweet);
db.SaveChanges();
}
return(RedirectToAction("Index", "Dashboard"));
}
public List <Tweet> GetTweets(string userId)
{
List <Tweet> tweets = new List <Tweet>();
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
tweets = (from t in db.Tweets
where t.UserId == userId
select t
).OrderBy(x => x.CreatedDate).ToList();
}
return(tweets);
}
public int GetUserTweetCount(string id)
{
int count = 0;
List <Tweet> twt = new List <Tweet>();
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
twt = (from a in db.Tweets where a.UserId == id select a).OrderBy(x => x.CreatedDate).ToList();
if (twt != null && twt.Count > 0)
{
count = twt.Count;
}
}
return(count);
}
public int GetUserFollowingCount(string userId)
{
int count = 0;
List <Following> userFollowing = new List <Following>();
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
userFollowing = (from a in db.Followings where a.UserId == userId select a).ToList();
if (userFollowing != null && userFollowing.Count > 0)
{
count = userFollowing.Count;
}
}
return(count);
}
public void SaveTweet(Tweet tweet)
{
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
if (tweet.TweetId == 0)
{
db.Tweets.Add(tweet);
}
else
{
Tweet t;
t = GetTweetById(tweet.TweetId);
}
db.SaveChanges();
}
}
public void UpdateUser(Person person)
{
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
if (!string.IsNullOrWhiteSpace(person.UserId))
{
Person p;
p = SearchUser(person.UserId);
p.Active = person.Active;
p.Email = person.Email;
p.FullName = person.FullName;
p.Password = person.Password;
db.People.Attach(p);
db.Entry(p).State = EntityState.Modified;
}
db.SaveChanges();
}
}
public bool RegisterOrUpdateUser(PersonModel personModel)
{
bool isRegistered = false;
try
{
using (_dbContext = new TwitterCloneEntities())
{
Person person = _dbContext.People.Where(x => x.User_Id.ToUpper().Trim() == personModel.User_Id.ToUpper().Trim()).FirstOrDefault();
if (person == null)
{
Person user = new Person();
user.User_Id = personModel.User_Id;
user.Passowrd = personModel.Password;
user.FullName = personModel.FullName;
user.Email = personModel.Email;
user.Joined = DateTime.Now;
user.Active = true;
_dbContext.People.Add(user);
}
else
{
if (string.IsNullOrEmpty(personModel.Password.Trim()))
{
person.Passowrd = personModel.Password;
}
person.FullName = personModel.FullName;
person.Email = personModel.Email;
_dbContext.Entry <Person>(person).State = System.Data.Entity.EntityState.Modified;
}
_dbContext.SaveChanges();
isRegistered = true;
}
}
catch (Exception ex)
{
isRegistered = false;
}
return(isRegistered);
}
public int GetUserFollowersCount(string userId)
{
int result = 0;
List <Following> followings = new List <Following>();
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
followings = (from f in db.Followings
where f.FollowingId == userId
select f
).ToList();
if (followings != null && followings.Count > 0)
{
result = followings.Count;
}
}
return(result);
}
public void SaveTweet(Tweet tweet)
{
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
if (tweet.TweetId == 0)
{
db.Tweets.Add(tweet);
}
else
{
Tweet twt;
twt = GetTweetById(tweet.TweetId);
twt.Message = tweet.Message;
db.Tweets.Attach(twt);
db.Entry(twt).State = EntityState.Modified;
}
db.SaveChanges();
}
}
public int GetUserTweetCount(string userId)
{
int result = 0;
List <Tweet> tweets = new List <Tweet>();
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
tweets = (from t in db.Tweets
where t.UserId == userId
select t
).OrderBy(x => x.CreatedDate).ToList();
if (tweets != null && tweets.Count > 0)
{
result = tweets.Count;
}
}
return(result);
}
public PersonModel GetProfile(string userId)
{
PersonModel prModel = new PersonModel();
using (_dbContext = new TwitterCloneEntities())
{
var items = _dbContext.People.Where(x => x.User_Id.Trim() == userId.Trim()).FirstOrDefault();
if (items != null)
{
prModel.User_Id = items.User_Id;
prModel.Password = items.Passowrd;
prModel.FullName = items.FullName;
prModel.Email = items.Email;
prModel.Joined = items.Joined;
prModel.Active = items.Active;
}
}
return(prModel);
}
public ActionResult Authorize(User userModel)
{
if (string.IsNullOrWhiteSpace(userModel.UserName) || string.IsNullOrWhiteSpace(userModel.Password))
{
return(View("Index", userModel));
}
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
var userDetails = db.Users.Where(x => x.UserName == userModel.UserName && x.Password == userModel.Password).FirstOrDefault();
if (userDetails == null)
{
return(View("Index", userModel));
}
Session["Id"] = userDetails.UserId;
Session["UserName"] = userDetails.UserName;
Session["FullName"] = string.Format($"{userDetails.FirstName} {userDetails.LastName}");
return(RedirectToAction("Index", "Dashboard"));
}
}
public string DeleteTweet(int tweetId)
{
string strUserName = string.Empty;
try
{
using (_dbContext = new TwitterCloneEntities())
{
var tweet = _dbContext.Tweets.Where(x => x.Tweet_Id == tweetId).FirstOrDefault();//_context.TWEETs.Where(x => x.tweet_id == tweetMsg.TweetId).FirstOrDefault();
if (tweet != null && tweetId != 0)
{
strUserName = tweet.User_Id;
_dbContext.Tweets.Remove(tweet);
}
_dbContext.SaveChanges();
}
}
catch (Exception ex)
{
}
return(strUserName);
}
public List <Tweet> GetTweets(string userId)
{
List <Tweet> userTweet = new List <Tweet>();
List <Following> userFollower = new List <Following>();
List <Tweet> userFollowedTweet = new List <Tweet>();
using (TwitterCloneEntities db = new TwitterCloneEntities())
{
userTweet = (from a in db.Tweets where a.UserId == userId select a).OrderBy(b => b.CreatedDate).ToList();
userFollower = (from a in db.Followings where a.UserId == userId select a).ToList();
foreach (var item in userFollower)
{
userFollowedTweet = (from a in db.Tweets where a.UserId == item.FollowingId select a).OrderBy(b => b.CreatedDate).ToList();
foreach (var tweet in userFollowedTweet)
{
userTweet.Add(tweet);
}
}
}
return(userTweet);
}
public TweetMessage EditTweet(int tweetId)
{
TweetMessage _editTweet = new TweetMessage();
try
{
using (_dbContext = new TwitterCloneEntities())
{
var tweet = _dbContext.Tweets.Where(x => x.Tweet_Id == tweetId).FirstOrDefault();//_context.TWEETs.Where(x => x.tweet_id == tweetMsg.TweetId).FirstOrDefault();
_editTweet.User_Id = tweet.User_Id;
_editTweet.Message = tweet.Message;
_editTweet.Tweet_Id = tweet.Tweet_Id;
_editTweet.Created = DateTime.Now;
_dbContext.Entry(_editTweet).State = System.Data.Entity.EntityState.Modified;
_dbContext.SaveChanges();
}
}
catch (Exception ex)
{
}
return(_editTweet);
}
public AppRepository()
{
_dbContext = new TwitterCloneEntities();
}
