C# (CSharp) C969_Software_2 SqlUpdater.SetCurrentUserID Examples

Example #1

File: Login.cs Project: talltony-m/C969-WGU-Software-II-Appointment-Calendar

        static public int FindUser(string userName, string password)
        {
            MySqlConnection C = new MySqlConnection(SqlUpdater.conString);

            C.Open();
            MySqlCommand    cmd = new MySqlCommand($"SELECT userId FROM user WHERE userName = '******' AND password = '******'", C);
            MySqlDataReader rdr = cmd.ExecuteReader();

            if (rdr.HasRows)
            {
                rdr.Read();
                SqlUpdater.SetCurrentUserID(Convert.ToInt32(rdr[0]));
                SqlUpdater.SetCurrentUserName(userName);
                rdr.Close();
                return(SqlUpdater.GetCurrentUserID());
            }
            return(0);
        }