public Loai_DonHang getLoai_DonHang(int id)
{
Loai_DonHang lLoai_DonHang = new Loai_DonHang();
using (MySqlConnection connMySQL = new MySqlConnection(Conn.connString))
{
using (MySqlCommand cmd = connMySQL.CreateCommand())
{
cmd.CommandText = "SELECT LOAIDH_ID, TEN_LDH FROM LOAI_DH where LOAIDH_ID=@LOAIDH_ID";
cmd.Parameters.Add(new MySqlParameter("LOAIDH_ID", id));
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = connMySQL;
connMySQL.Open();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
lLoai_DonHang = (new Loai_DonHang
{
LOAIDH_ID = reader.GetInt32(reader.GetOrdinal("LOAIDH_ID")),
TEN_LDH = reader.GetString(reader.GetOrdinal("TEN_LDH"))
});
}
}
}
connMySQL.Close();
}
return(lLoai_DonHang);
}
public int addLoaiDonHang(Loai_DonHang loai_DH)
{
int kq;
using (MySqlConnection connMySQL = new MySqlConnection(Conn.connString))
{
using (MySqlCommand cmd = connMySQL.CreateCommand())
{
cmd.CommandText = "INSERT INTO LOAI_DH(TEN_LDH) VALUES (@TEN_LDH)";
cmd.Parameters.Add(new MySqlParameter("TEN_LDH", loai_DH.TEN_LDH));
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = connMySQL;
connMySQL.Open();
kq = cmd.ExecuteNonQuery();
}
connMySQL.Close();
}
return(kq);
}
public int editLoaiDonHang(Loai_DonHang loai_DH)
{
int kq;
using (MySqlConnection connMySQL = new MySqlConnection(Conn.connString))
{
using (MySqlCommand cmd = connMySQL.CreateCommand())
{
cmd.CommandText = "UPDATE LOAI_DH SET TEN_LDH=@TEN_LDH WHERE LOAIDH_ID=@LOAIDH_ID";
cmd.Parameters.Add(new MySqlParameter("TEN_LDH", loai_DH.TEN_LDH));
cmd.Parameters.Add(new MySqlParameter("LOAIDH_ID", loai_DH.LOAIDH_ID));
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = connMySQL;
connMySQL.Open();
kq = cmd.ExecuteNonQuery();
}
connMySQL.Close();
}
return(kq);
}
