public static string BindDatatable(string uniqueUserID, string fullName, string givenName, string familyName, string email, string googleToken)
{
string ConnectionIDUpdated = "false";
using (var db = new WebApplication2.MyEntityFramework.MySignalRUsersEntities())
{
var userDataRecord = (from c in db.UsersTemp
where (c.UniqueUserID == uniqueUserID)
select c).SingleOrDefault();
if (userDataRecord != null)
{
userDataRecord.FullName = fullName;
userDataRecord.GivenName = givenName;
userDataRecord.FamilyName = familyName;
userDataRecord.Email = email;
userDataRecord.GoogleToken = googleToken;
db.SaveChanges();
ConnectionIDUpdated = "true";
}
}
return(ConnectionIDUpdated);
}
protected void Page_Load(object sender, EventArgs e)
{
WebApplication2.Models.UsersData uData = new WebApplication2.Models.UsersData();
using (var db = new WebApplication2.MyEntityFramework.MySignalRUsersEntities())
{
var userIDsList = (from c in db.UsersTemp
select new Models.UsersData()
{
userID = c.UniqueUserID, FullName = c.FullName, GivenName = c.GivenName, FamilyName = c.FamilyName, Email = c.Email, GoogleToken = c.GoogleToken
}).ToList();
foreach (var id in userIDsList)
{
if (id.FullName != null)
{
uData.userIDS.Add(id.userID.ToString() + "|" + id.FullName.ToString());
}
else
{
uData.userIDS.Add(id.userID.ToString());
}
}
}
allLoggedInUsers.Items.Clear();
for (int i = 0; i < uData.userIDS.Count; i++)
{
allLoggedInUsers.Items.Add(new ListItem(uData.userIDS[i].ToString()));
}
}
