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));
}
private async void StartCountdownTimer(int startingVal)
{
while (startingVal >= 0)
{
RunOnUiThread(() => countDownView.Text = startingVal.ToString());
startingVal = startingVal - 1;
await Task.Delay(1000);
}
if (startingVal < 0)
{
ReadyGoStop.Text = "STOP!";
topLayerCount.Visibility = Android.Views.ViewStates.Visible;
countdownView.Text = "Time is up! Final Score: " + totalScore + " points";
replayGame.Enabled = true;
//Show the layer to say it is done
ConnectToDatabase insertValues = new ConnectToDatabase();
var storedCorrectly = false;
RunOnUiThread(() => storedCorrectly = insertValues.insertToMadMinute(username, totalScore, totalQuestions - totalScore));
return;
}
}
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());
}
}
protected void btnRegister_ServerClick(object sender, EventArgs e)
{
var r = new Regex(@"^([0-9a-zA-Z]([-\.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})$");
if (!r.IsMatch(email.Value))
{
errorMsg.InnerHtml = "Email not valid";
}
else
{
Session["Email"] = email.Value;
ConnectToDatabase db = new ConnectToDatabase();
image = db.getDefaultImage();
Random rnd = new Random();
do
{
code = rnd.Next(1000, 99999).ToString();
} while (db.isCodeTaken(code));
Boolean userAlreadyExists = db.writeUserAsInactive(firstName.Value, lastName.Value, email.Value, password.Value, telephone.Value, txtDateOfBirth.Text, street.Value, int.Parse(streetNumber.Value), city.Value, postalCode.Value, country.Value, image, code);
if (userAlreadyExists)
{
errorMsg.InnerHtml = "You are already a member. Try resetting your password on Login page";
}
else
{
if (Request.QueryString["rurl"] != "appointee.aspx" && Request.QueryString["rurl"] == null)
{
//Session["FirstName"] = firstName.Value;
//Session["LastName"] = lastName.Value;
//Session["email"] = email.Value;
//Session["LoggedIn"] = "";
Response.Redirect("login.aspx");
}
else
{
Response.Redirect(Request.QueryString["rurl"] + "?cid=" + Session["CalId"] + "&sd=" + Session["StartDate"] + "&ed=" + Session["EndDate"] + "&name=" + Session["CalendarName"]);
}
}
}
}
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));
}
}
public IActionResult Trivia()
{
string name;
string score;
if (HttpContext.Session.GetString("username") != null)
{
name = HttpContext.Session.GetString("username");
score = ConnectToDatabase.getScore(name);
}
else
{
name = "Guest";
score = "No score for guest";
}
var model = new UserModel {
jmeno = name,
score = score
};
return(View("~/Views/trivia/trivia.cshtml", model));
}
