private void Load_vaccine(object sender, Kidshistory e) { //throw new NotImplementedException(); string id = (string)e.vaccine; MySqlConnectionString connStr = GetMySqlConnString(); var conn = new MySqlConnection(connStr); conn.UseConnectionPool = true; conn.Open(); string result = ""; try { var cmd = new MySqlCommand("SELECT injected_vaccine FROM vaccine WHERE username_id=@id", conn); cmd.Parameters.AddWithValue("@id", id); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { result = reader.GetString("injected_vaccine"); e.vaccine = result; Console.WriteLine("List: {0} by id:{1}", result, id); } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex); } if (result == "") { e.vaccine = "Fail"; } conn.Close(); }
private void Health_Load_age_gender(object sender, Kidshistory e) //age gender { string query = (string)e.health; MySqlConnectionString connStr = GetMySqlConnString(); var conn = new MySqlConnection(connStr); conn.UseConnectionPool = true; conn.Open(); string result = ""; try { var cmd = new MySqlCommand(query, conn); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { result = reader.GetString("gender"); result = result + "|" + reader.GetString("age"); e.health = result; } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex); } conn.Close(); }
private void Load_Appoinement(object sender, Kidshistory e) { string id = (string)e.notification; MySqlConnectionString connStr = GetMySqlConnString(); var conn = new MySqlConnection(connStr); conn.UseConnectionPool = true; conn.Open(); string result = ""; try { var cmd = new MySqlCommand("SELECT detail, appointment FROM notification " + "WHERE username_id=@id", conn); cmd.Parameters.AddWithValue("@id", id); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { result += reader.GetString("appointment"); result += "|" + reader.GetString("detail"); e.notification = result; } if (result == "") { e.notification = "No data"; } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex); } conn.Close(); }
private void Login(object sender, Kidshistory e) { bool status = false; string myname = ""; string mypassword; string user_id = ""; string word = (string)e.users; string[] words = word.Split('|'); string username = words[0].ToString(); string password = words[1].ToString(); MySqlConnectionString connStr = GetMySqlConnString(); var conn = new MySqlConnection(connStr); conn.UseConnectionPool = true; conn.Open(); try { var cmd = new MySqlCommand("SELECT username,password,username_id FROM users WHERE " + "username='******' AND password='******'", conn); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { myname = reader.GetString("username"); mypassword = reader.GetString("password"); if (myname == username && mypassword == password) { myname = reader.GetString("username"); mypassword = reader.GetString("password"); user_id = reader.GetString("username_id"); Console.WriteLine("Username: "******"\n" + "Password: "******"Success" + "|" + user_id; //response data var cmd2 = new MySqlCommand("UPDATE users SET State=@S WHERE username=@user", conn); cmd2.Parameters.AddWithValue("@S", 1); cmd2.Parameters.AddWithValue("@user", myname); cmd2.ExecuteNonQuery(); } else { e.users = "Fail" + "|" + 0; Console.WriteLine("Login failed"); } } catch (Exception ex) { Console.WriteLine(ex); } conn.Close(); }
private void About_Comment_Arrived(object sender, Kidshistory e) { MySqlConnectionString connStr = GetMySqlConnString(); var conn = new MySqlConnection(connStr); conn.UseConnectionPool = true; conn.Open(); try { var cmd = new MySqlCommand("INSERT INTO about(comment)VALUES(@comment)", conn); cmd.Parameters.AddWithValue("@comment", (string)e.about); cmd.ExecuteNonQuery(); } catch (Exception) { } conn.Close(); }