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);
}
}
