public int getId(string getEmail) { using (postgresContext db = new postgresContext()) { return(db.user_data.ToList().Where(el => el.email == getEmail).ToList()[0].user_id); } }
public string getSave(string getEmail) { using (postgresContext db = new postgresContext()) { return(db.user_data.ToList().Where(el => el.email == getEmail).ToList()[0].savestring); } }
public void PatchName(string getEmail, string patchName) { using (postgresContext db = new postgresContext()) { var _user = db.user_data.ToList().Where(el => el.email == getEmail).ToList(); _user[0].nickname = patchName; db.user_data.Update(_user[0]); db.SaveChanges(); } }
public void setSave(Save newSave) { using (postgresContext db = new postgresContext()) { var userList = db.user_data.ToList(); var user = userList.Where(el => el.email == newSave.email).ToList()[0]; user.savestring = newSave.savestring; db.user_data.Update(user); db.SaveChanges(); } }
public void ResetProgress([FromBody] string getEmail) { using (postgresContext db = new postgresContext()) { var user = db.user_data.ToList().Where(el => el.email == getEmail).ToList()[0]; user.savestring = "0"; var userStats = db.user_stats.ToList().Where(el => el.user_id == user.user_id).ToList()[0]; userStats.maxenergylvl = 0; userStats.maxmatterlvl = 0; userStats.maxnaturelvl = 0; db.user_stats.Update(userStats); db.user_data.Update(user); db.SaveChanges(); } }
public string OnLogin(string getEmail, string getName) { using (postgresContext db = new postgresContext()) { var userList = db.user_data.ToList(); if (userList.Where(el => el.email == getEmail).ToList().Count == 0) { int maxId = 0; foreach (user_data user in userList) { maxId = Math.Max(maxId, user.user_id); } user_data newUser = new user_data(maxId + 1, getName, getEmail, "0"); user_stats newStats = new user_stats(maxId + 1, 1, 1, 1); db.user_data.Add(newUser); db.user_stats.Add(newStats); db.SaveChanges(); return(getName); } return(userList.Where(el => el.email == getEmail).ToList()[0].nickname); } }