public bool RemoveUser(int usrId)
{
using (var ctx = new TCAppEntities())
{
var idParam = new SqlParameter("@UserID", usrId);
ctx.Database.SqlQuery <dynamic>("exec DeleteUser @UserID", idParam).ToList();
}
return(true);
}
public void DeleteTweet(int id)
{
using (var ctx = new TCAppEntities())
{
var idParam = new SqlParameter("@TweetID", id);
ctx.Database.SqlQuery <UserHomeModel>(
"exec DeleteTweet @TweetID", idParam).ToList();
}
}
public void UpdateTweet(int id, string tweetMsg)
{
using (var ctx = new TCAppEntities())
{
var idParam = new SqlParameter("@TweetID", id);
var messageParam = new SqlParameter("@Message", tweetMsg);
ctx.Database.SqlQuery <UserHomeModel>(
"exec EditTweet @TweetID,@Message", idParam, messageParam).ToList();
}
}
public bool FollowUser(int id, int followUserId)
{
using (var ctx = new TCAppEntities())
{
var idParam = new SqlParameter("@ID", id);
var followUserIdParam = new SqlParameter("@FollowingUserID", followUserId);
ctx.Database.SqlQuery <UserFollowings>(
"exec InsertUserFollowing @ID,@FollowingUserID", idParam, followUserIdParam).ToList <UserFollowings>();
}
return(true);
}
public IEnumerable <UserFollowings> GetFollowersList(int id)
{
IEnumerable <UserFollowings> usrFollowers;
using (var ctx = new TCAppEntities())
{
var idParam = new SqlParameter("@id", id);
var followersList = ctx.Database.SqlQuery <UserFollowings>(
"exec GetFollowersList @id", idParam).ToList();
usrFollowers = followersList;
}
return(usrFollowers);
}
public IEnumerable <UserFollowing> GetFollowingList(int ID)
{
IEnumerable <UserFollowing> usrFollowing = null;
using (var ctx = new TCAppEntities())
{
var idParam = new SqlParameter("@id", ID);
var FollowingList = ctx.Database.SqlQuery <UserFollowing>(
"exec GetFollowingList @id", idParam).ToList <UserFollowing>();
usrFollowing = FollowingList;
}
return(usrFollowing);
}
public IEnumerable <UserTweet> GetAllTweets(int id)
{
IEnumerable <UserTweet> usrTweets;
using (var ctx = new TCAppEntities())
{
var idParam = new SqlParameter("@id", id);
var tweetDetails = ctx.Database.SqlQuery <UserTweet>(
"exec GetAllTweets @id", idParam).ToList();
usrTweets = tweetDetails;
}
return(usrTweets);
}
public SearchUser GetUserDetails(string srchString)
{
SearchUser usrSrch = new SearchUser();
using (var ctx = new TCAppEntities())
{
var idParam = new SqlParameter("@displayName", srchString);
var usr = ctx.Database.SqlQuery <SearchUser>(
"exec SearchUser @displayName", idParam).FirstOrDefault();
if (usr != null)
{
usrSrch.UserDisplayName = usr.UserDisplayName;
usrSrch.UserEmail = usr.UserEmail;
usrSrch.UserFullName = usr.UserFullName;
usrSrch.Id = usr.Id;
}
}
return(usrSrch);
}
public UserSearch GetUserDetails(string srchString)
{
UserSearch usrSrch = new UserSearch();
using (var ctx = new TCAppEntities())
{
var idParam = new SqlParameter("@displayName", srchString);
var usr = ctx.Database.SqlQuery <UserSearch>(
"exec SearchUser @displayName", idParam).FirstOrDefault();
if (usr != null)
{
usrSrch.DisplayName = usr.DisplayName;
usrSrch.Email = usr.Email;
usrSrch.FullName = usr.FullName;
usrSrch.ID = usr.ID;
}
}
return(usrSrch);
}
