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