public static void SaveUser(int userId, int numKnowledge, int totalKnowledge, int?numBook,
int?numTutor, int?numProf, int?numSchool, int?numUni, int?numLab, int?Level)
{
knowledgeclickerdbEntities db = new knowledgeclickerdbEntities();
User item = null;
item = db.Users.Find(userId);
item.numKnowledge = numKnowledge;
item.totalKnowledge = totalKnowledge;
item.Level = Level;
item.numBook = numBook;
item.numTutor = numTutor;
item.numProf = numProf;
item.numSchool = numSchool;
item.numUni = numUni;
item.numLab = numLab;
db.SaveChanges();
}
public static List <User> GetUsers()
{
knowledgeclickerdbEntities db = new knowledgeclickerdbEntities();
int id = int.Parse(HttpContext.Current.Session["UserID"].ToString());
var res = db.Users.Where(u => u.UserID == id).ToList()
.Select(
u => new User
{
UserID = id,
numKnowledge = u.numKnowledge,
totalKnowledge = u.totalKnowledge,
numBook = u.numBook,
numProf = u.numProf,
numTutor = u.numTutor,
numSchool = u.numSchool,
numUni = u.numUni,
numLab = u.numLab,
Level = u.Level
}).ToList();
return(res);
}
