/** * Validates user details against DB * returns true if user details exist. */ private bool IsExist(string username, string password) { string cmdStr = string.Format("SELECT * FROM UserDetails WHERE [UserName]=N'{0}' and Password=N'{1}'", username, password); DBAccesor dbAccessor = ServiceLocator.Instance.GetService <DBAccesor>(); return(dbAccessor.isExist(cmdStr)); }
protected void Page_Load(object sender, EventArgs e) { string user = (string)Session["UserName"]; if (Request.Form["menu"] != null) { DBAccesor dB = ServiceLocator.Instance.GetService <DBAccesor>(); if (user != null) { string cmdStr = string.Format("SELECT * FROM TetrisHighScore WHERE [UserName]=N'{0}'", user); int score = int.Parse(Request.Form["scoreDB"]); if (dB.isExist(cmdStr)) { var table = dB.runSelectCmd(cmdStr); int highScore = (int)table.Rows[0]["Score"]; if (score > highScore) { table.Rows[0]["Score"] = score; dB.updateTable(cmdStr, table); } } else { string cmdStr1 = string.Format($"INSERT INTO TetrisHighScore(UserName, Score) VALUES (N'{user}',{score})"); dB.runSqlCommand(cmdStr1); } } Response.Redirect("tetrisGameOver.aspx"); } }
private bool isExist(string user, int id) { string cmdString = string.Format($"SELECT * FROM Cart WHERE UserName = N'{user}' and OrderId = {id} "); DBAccesor dbAccessor = ServiceLocator.Instance.GetService <DBAccesor>(); return(dbAccessor.isExist(cmdString)); }
/** * Run query against DB * return true if result exist otherwise false. */ private bool checkDB(string query) { DBAccesor dbAccessor = ServiceLocator.Instance.GetService <DBAccesor>(); return(dbAccessor.isExist(query)); }