public static bool HasTest() // javĂtva { MySqlDB mySql = new MySqlDB(); string command = "SELECT count(id) FROM kompetencia_jelolt_kapcs WHERE interju_id = " + Session.InterViewID + " AND hr_id = " + Session.UserData.id + ""; bool response = mySql.Bind(command); mySql.Close(); return(response); }
public static bool Authentication(string username) { MySqlDB mySql = new MySqlDB(); if (mySql.Bind("SELECT count(id) FROM users WHERE username='******' AND validitas = 1")) { Session.UserData = UserData.GetOwnDatas(); DateTime dateTime = DateTime.Now; mySql.Execute("UPDATE users SET belepve = '" + dateTime.ToString("yyyy.MM.dd") + "' WHERE username = '******';"); mySql.Close(); return(true); } else { mySql.Close(); } return(false); }