public ChildrenClass DetailWithParent(int id)
        {
            MysqlConnect();
            string       query = "select * from child join parent on parent.parent_id = child.f_parent_id where child_id = " + id;
            MySqlCommand comm  = new MySqlCommand(query);

            comm.Connection = mysql;
            mysql.Open();

            MySqlDataReader dr = comm.ExecuteReader();

            dr.Read();

            parentClass   p = new parentClass();
            ChildrenClass x = new ChildrenClass
            {
                child_id    = (int)dr["child_id"],
                f_parent_id = (int)dr["f_parent_id"],
                child_name  = dr["child_name"].ToString(),
                parent_name = dr["parent_name"].ToString(),
                list_parent = new SelectList(p.Read(), "parent_id", "parent_name", (int)dr["f_parent_id"])
            };

            mysql.Close();
            return(x);
        }
        public void Add(ChildrenClass p)
        {
            MysqlConnect();
            string       query = "INSERT INTO `child` (`child_id`, `child_name`, `f_parent_id`) VALUES(NULL, '" + p.child_name + "', " + p.f_parent_id + ")";
            MySqlCommand comm  = new MySqlCommand(query);

            comm.Connection = mysql;
            mysql.Open();
            comm.ExecuteNonQuery();
            mysql.Close();
            return;
        }
        public void Edit(ChildrenClass p)
        {
            MysqlConnect();

            string       query = "UPDATE `child` SET `child_name` = '" + p.child_name + "' WHERE `child`.`child_id` = " + p.child_id;
            MySqlCommand comm  = new MySqlCommand(query);

            comm.Connection = mysql;
            mysql.Open();
            comm.ExecuteNonQuery();
            mysql.Close();
            return;
        }
        public bool isExist(ChildrenClass p)
        {
            MysqlConnect();
            string       query = "select * from child where child_name='" + p.child_name + "'";
            MySqlCommand comm  = new MySqlCommand(query);

            comm.Connection = mysql;
            mysql.Open();

            MySqlDataReader dr = comm.ExecuteReader();

            bool flg = dr.HasRows;

            mysql.Close();
            if (flg)
            {
                return(true);
            }
            return(false);
        }