public HomeController(ILogger <HomeController> logger, socialnetworkContext context, IHubContext <ChatHub> hubContext, ITrendsFee trends)
{
_logger = logger;
_context = context;
_trends = trends;
this.hubContext = hubContext;
}
public List <UsersWithCommon> GetUsersWithCommon(Guid Id, socialnetworkContext context, int skip, int rows, string pattern, string city, string country)
{
SqlParameter parameter = new SqlParameter("@ID", Id);
SqlParameter skipparam = new SqlParameter("@skip", skip);
SqlParameter rowsparam = new SqlParameter("@rows", rows);
SqlParameter patternparam = new SqlParameter("@pattern", pattern);
SqlParameter cityparam = new SqlParameter("@city", city);
SqlParameter countryparam = new SqlParameter("@country", country);
var Users = context.users.FromSqlRaw("GetCommonFriends @ID, @skip, @rows, @pattern, @city, @country", new SqlParameter[] { parameter, skipparam, rowsparam, patternparam, cityparam, countryparam }).ToList();
return(Users);
}
public FriendsController(socialnetworkContext context)
{
_context = context;
}
public UsersController(socialnetworkContext context, IFriendFee friendsFee)
{
_context = context;
_friendFee = friendsFee;
}
public ChatHub(socialnetworkContext context)
{
_context = context;
}
public List <TrendPosts> GetTrends(socialnetworkContext context)
{
var Users = context.trends.ToList();
return(Users);
}
public BlogsController(socialnetworkContext context)
{
_context = context;
}
public MessagesController(socialnetworkContext context)
{
_context = context;
}
public AuthController(socialnetworkContext context, IHubContext <ChatHub> hubContext)
{
_context = context;
_tokensalt = Convert.FromBase64String("h/QUm2iYZ8lIttbVGCTnYA==");
HubContext = hubContext;
}