/// <summary> /// Checking if is user already registered with given e-mail address /// </summary> /// <param name="email"></param> /// <returns>True/False</returns> private static bool isAlreadyregistered(string email) { string comm = "SELECT * FROM Users WHERE email = '" + email + "'"; User u = new User(-1); String s = ""; SqlDataReader reader = u.ExecuteReader(comm, ref s); bool isRegistered = false; while (reader.Read()) { isRegistered = true; } reader.Close(); return isRegistered; }
/// <summary> /// Get user group id /// </summary> /// <param name="p"></param> /// <returns></returns> private static string getUsertype(string p) { string comm = "SELECT UTypeID FROM UserTypes WHERE Usertypename = '" + p + "'"; User u = new User(-1); String s = ""; SqlDataReader reader = u.ExecuteReader(comm, ref s); while (reader.Read()) { s = reader["UTypeID"].ToString(); } reader.Close(); return s; }