//3 hard, 1 easy, -1 gresit public IActionResult GetCheckAnswerByQuestionIDAnswerIdUser(string questionID, string answer,string id_user) { string response=""; int score = 0; try { database db = new database(database.maindb); db.AddParam("?id", questionID); MySqlDataReader rd = db.ExecuteReader("select answer from questions where random_id=?id"); while(rd.Read()) { if (rd.GetString("answer") == answer) { response = "1"; score = 3; } else { response = "0"; score = -1; } } db.AddParam("?score", score); db.AddParam("?id_user", id_user); db.ExecuteReader("update questions set answered=1 where random_id=?id"); db.ExecuteReader("update users set score=score+?score where id=?id_user"); } catch { } return new ObjectResult(response); }
public IActionResult country(string countryName) { ViewBag.country = countryName; try { ViewBag.countryExists = "true"; database db = new database(database.maindb); db.AddParam("?country", countryName); MySqlDataReader rd = db.ExecuteReader("select * from countries where lower(country)=lower(?country)"); if (!rd.HasRows) { ViewBag.climate = "N.A."; ViewBag.death_rate = "N.A."; ViewBag.obesity = "N.A."; } while (rd.Read()) { ViewBag.climate = rd.GetString("climate"); double death_rate = rd.GetDouble("death_rate"); if (death_rate == 0) ViewBag.death_rate = "N.A."; else ViewBag.death_rate = death_rate; double obesity = rd.GetDouble("obesity"); if (obesity == 0) ViewBag.obesity = "N.A."; else ViewBag.obesity = obesity; } Dictionary<string, Country> cslist = new Countries().getDictionar(); ViewBag.code = ""; try { ViewBag.code = cslist[countryName].Code; } catch { } } catch { } ViewBag.nr = 0; try { ObjectResult obj = (ObjectResult)new MeAd.Raml.SearchController().Get(countryName); Dictionary<string, Countries.CountryDiseases> countryDiseases = (Dictionary<string, Countries.CountryDiseases>)obj.Value; ViewBag.countryDiseases = countryDiseases; } catch { } return View(); }
public string Login(string username, string password) { //-1 username or email doesnt exist try { //if (!IsValidEmail(email)) return "-1"; database db = new database(database.maindb); db.AddParam("?username", username); db.AddParam("?password", password); MySqlDataReader rd = db.ExecuteReader("select * from users where lower(username)=lower(?username) and password=?password"); if (!rd.HasRows) { Context.Session.SetInt32("on", 0); // invalid user / pass db.Close(); return "-1"; } while (rd.Read()) { Context.Session.SetInt32("on", 1); Context.Session.SetInt32("id", rd.GetInt32("id")); Context.Session.SetString("email", rd.GetString("email")); Context.Session.SetString("username", rd.GetString("username")); Context.Session.SetInt32("score", rd.GetInt32("score")); Context.Session.SetString("country", rd.GetString("country")); Context.Session.SetInt32("gender", rd.GetInt32("gender")); Context.Session.SetString("birthday", rd.GetString("birthday")); break; } db.Close(); } catch (Exception e) { // HttpContext.Current.Session["on"] = 0; return e.ToString(); } return "1"; }
public string RegisterUser(string email, string password, string username, string birthday, string gender, string country) { //-1 username or email already exists, -2 invalid birthday try { database db = new database(database.maindb); if (String.IsNullOrEmpty(birthday)) birthday = ""; if (String.IsNullOrEmpty(country)) country = ""; db.AddParam("?username", username); db.AddParam("?email", email); MySqlDataReader rd = db.ExecuteReader("select * from users where lower(email)=lower(?email) or lower(username)=lower(?username)"); if (rd.HasRows) return "-1"; DateTime dateValue; if (!DateTime.TryParse(birthday, out dateValue) && birthday != "") return "-2"; int sex = 0; switch (gender) { case "Gender": sex = 0; break; case "Male": sex = 1; break; case "Female": sex = 2; break; } db.AddParam("?password", password); db.AddParam("?birthday", birthday); db.AddParam("?country", country); db.AddParam("?gender", sex); db.ExecuteNonQuery("insert into users(email,username,password,gender,country,birthday) values (?email,?username,?password,?gender,?country,?birthday)"); return "1"; } catch (Exception e) { return e.ToString(); } }
public string FBLogin(string token) { try { WebClient wc = new WebClient(); wc.Proxy = null; string res = wc.DownloadString("https://graph.facebook.com/me?fields=email,name,first_name,last_name,gender&access_token=" + token); Dictionary<string, string> response = JsonConvert.DeserializeObject<Dictionary<string, string>>(res); if (response.ContainsKey("name")) { string id = response["id"]; string email = response["email"]; database db = new database(database.maindb); db.AddParam("?fbid", id); db.AddParam("?email", email); db.AddParam("?username", response["first_name"]+response["last_name"]); switch (response["gender"]) { case "male": db.AddParam("?gender", 1); break; case "female": db.AddParam("?gender", 2); break; default: db.AddParam("?gender", 0); break; } MySqlDataReader rd; rd = db.ExecuteReader("select * from users where facebookid = ?fbid or email = ?email"); if (rd.HasRows) while (rd.Read()) { Context.Session.SetInt32("on", 1); Context.Session.SetString("email", rd.GetString("email")); Context.Session.SetString("username", rd.GetString("username")); Context.Session.SetInt32("id", rd.GetInt32("id")); Context.Session.SetString("myname", rd.GetString("lastname") + " " + rd.GetString("firstname")); break; // return "2"; } else { db.ExecuteNonQuery("insert into users (email,username,gender,facebookid) values (?email,?username,?gender,?fbid)"); rd = db.ExecuteReader("select * from users where facebookid = ?fbid or email = ?email"); while (rd.Read()) { Context.Session.SetInt32("on", 1); Context.Session.SetString("email", rd.GetString("email")); Context.Session.SetInt32("id", rd.GetInt32("id")); Context.Session.SetString("username", rd.GetString("username")); Context.Session.SetInt32("gender", rd.GetInt32("gender")); } //return "3"; } db.Close(); return "1"; } else return "0"; } catch (Exception ex) { return ex.ToString(); } }