public DanpheTelemedicineController(DanpheTeleMedDbContext context,
IHostingEnvironment hostingEnvironment)
{
//connString = _config.Value.ConnectionString;
dbContext = context;
_hostingEnvironment = hostingEnvironment;
}
List <string> GetSessionIdList(DanpheTeleMedDbContext dbContext, string useridlist)
{
var arr = useridlist.Split(',');
var user1id = Convert.ToInt32(arr[0]);
var user2id = Convert.ToInt32(arr[1]);
var sessionlist = (from sl in dbContext.SessionUserTxns.AsEnumerable()
where (sl.SessionOwnerId == user1id && sl.UserId == user2id) ||
(sl.UserId == user1id && sl.SessionOwnerId == user2id)
select sl.SessionId).Distinct().ToList();
return(sessionlist);
}
int GetUserId(DanpheTeleMedDbContext dbContext, string userName)
{
return((from u in dbContext.User
where u.UserName == userName
select u.UserId).FirstOrDefault());
}
string GetUserName(DanpheTeleMedDbContext dbContext, int userId)
{
return((from u in dbContext.User
where u.UserId == userId
select u.UserName).FirstOrDefault());
}
