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(parentClass p) { MysqlConnect(); string query = "INSERT INTO `parent` (`parent_id`, `parent_name`) VALUES(NULL, '" + p.parent_name + "');"; MySqlCommand comm = new MySqlCommand(query); comm.Connection = mysql; mysql.Open(); comm.ExecuteNonQuery(); mysql.Close(); return; }
public void Edit(parentClass p) { MysqlConnect(); string query = "UPDATE `parent` SET `parent_name` = '" + p.parent_name + "' WHERE `parent`.`parent_id` = " + p.parent_id; MySqlCommand comm = new MySqlCommand(query); comm.Connection = mysql; mysql.Open(); comm.ExecuteNonQuery(); mysql.Close(); return; }
public bool isExist(parentClass p) { MysqlConnect(); string query = "select * from parent where parent_name='" + p.parent_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); }
public parentClass Detail(int id) { MysqlConnect(); string query = "select * from parent where parent_id=" + id; MySqlCommand comm = new MySqlCommand(query); comm.Connection = mysql; mysql.Open(); MySqlDataReader dr = comm.ExecuteReader(); dr.Read(); parentClass x = new parentClass { parent_id = (int)dr["parent_id"], parent_name = dr["parent_name"].ToString() }; mysql.Close(); return(x); }