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); }