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