public bool DeleteChiTietHoaDon(ChiTietHoaDon_ET chiTietHoaDon) { try { conn.Open(); SqlCommand cmd = new SqlCommand("SP_ChiTietHoaDon_Delete", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", chiTietHoaDon.ID); if (cmd.ExecuteNonQuery() > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } finally { conn.Close(); } }
public bool UpdateChiTietHoaDon(ChiTietHoaDon_ET chiTietHoaDon) { try { conn.Open(); SqlCommand cmd = new SqlCommand("SP_ChiTietHoaDon_Update", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", chiTietHoaDon.ID); cmd.Parameters.AddWithValue("@id_hoadon", chiTietHoaDon.ID_HoaDon); cmd.Parameters.AddWithValue("@id_sanpham", chiTietHoaDon.ID_SanPham); cmd.Parameters.AddWithValue("@soluong", chiTietHoaDon.SoLuong); if (cmd.ExecuteNonQuery() > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } finally { conn.Close(); } }
public bool DeleteChiTietHoaDon(ChiTietHoaDon_ET chiTietHoaDon) { return(dal_ChiTietHoaDon.DeleteChiTietHoaDon(chiTietHoaDon)); }
public bool UpdateChiTietHoaDon(ChiTietHoaDon_ET chiTietHoaDon) { return(dal_ChiTietHoaDon.UpdateChiTietHoaDon(chiTietHoaDon)); }
public bool AddChiTietHoaDon(ChiTietHoaDon_ET chiTietHoaDon) { return(dal_ChiTietHoaDon.AddChiTietHoaDon(chiTietHoaDon)); }