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();
}
