public IActionResult register(string name, string email, string password)
{
string zpravaProUzivatele = String.Empty;
var pripojeni = ConnectToDatabase.Connector();
var data = ConnectToDatabase.LoginRegisterNameCheck(name, pripojeni);
//Console.WriteLine(modelError.GetType());
if (!data.Read())
{
pripojeni.Close();
pripojeni.Open();
try
{
ConnectToDatabase.RegisterNewUser(name, email, password, pripojeni);
var modelError = modelCreate.infoMessageModel("Uspesna registrace");
return(View("register", modelError));
}
catch
{
var modelError = modelCreate.infoMessageModel("Registrace se nezdarila");
return(View("register", modelError));
}
}
else
{
//Console.WriteLine(data["jmeno"]);
var modelError = modelCreate.infoMessageModel("Jmeno nebo email uz existuje");
return(View("register", modelError));
}
// return View("~/Views/loginRegister/register.cshtml");
}
public IActionResult Scoreboard()
{
var pripojeni = ConnectToDatabase.Connector();
string sql = $"SELECT score, jmeno FROM databazeUzivatelu ORDER BY score DESC LIMIT 50;";
var prikaz = new MySqlCommand(sql, pripojeni);
var data = prikaz.ExecuteReader();
// Dictionary<List<string>, string> values = new Dictionary<string, string>();
List <string> jmenaList = new List <string>();
List <string> scoreList = new List <string>();
var modelScoreBoard = new ScoreBoard {
jmena = jmenaList,
score = scoreList
};
while (data.Read())
{
/*
* var score = data[0].ToString();
* var jmeno = data[1].ToString();
* Console.WriteLine(jmeno);
*/
modelScoreBoard.jmena.Add(data[1].ToString());
modelScoreBoard.score.Add(data[0].ToString());
//Dictionary<int, string> dataList = new Dictionary<int, string>();
//var jsonString = JsonConvert.SerializeObject(data);
}
//scoreList.ForEach(Console.WriteLine);
//jmenaList.ForEach(Console.WriteLine);
return(View(modelScoreBoard));
}
public IActionResult Trivia(string jmeno, string score) // trivia score funkce
{
var pripojeni = ConnectToDatabase.Connector();
string sql = $"UPDATE databazeUzivatelu SET score = score + {score} WHERE jmeno = '{jmeno}';";
try
{
var prikaz = new MySqlCommand(sql, pripojeni);
prikaz.ExecuteNonQuery();
}
catch (MySqlException ex) { Console.WriteLine(ex); }
pripojeni.Close();
return(View());
}
public IActionResult user(string username)
{
var pripojeni = ConnectToDatabase.Connector();
var data = ConnectToDatabase.getInfoAboutUser(username, pripojeni);
if (data.Read())
{
var modelUser = modelCreate.userInfoProfileModelCreator(data["jmeno"].ToString(), data["email"].ToString(), data["datumPripojeni"].ToString(), data["score"].ToString());
return(View(modelUser));
}
else
{
Console.WriteLine("userNotFound");
return(View());
}
}
public IActionResult login(string name, string password)
{
var pripojeni = ConnectToDatabase.Connector();
string hesloDatabaze = String.Empty;
string scoreDatabaze = String.Empty;
bool verified = false;
var data = ConnectToDatabase.LoginRegisterNameCheck(name, pripojeni);
if (data.Read())
{
hesloDatabaze = data["heslo"].ToString();
verified = BCrypt.Net.BCrypt.Verify(password, hesloDatabaze);
Console.WriteLine(verified);
}
if (verified)
{
HttpContext.Session.SetString("username", name);
var model = modelCreate.infoMessageModel(name);
//Response.Cookies.Append("jmeno", name);
//string cookie = Request.Cookies["jmeno"];
//Console.WriteLine(cookie);
return(View("login", model));
}
else
{
var modelError = new LoginRegisterModel {
errorMessage = "Spatne jmeno nebo heslo"
};
return(View("login", modelError));
}
}