public bool DeleteHoaDon(HoaDon_ET hoaDon) { try { conn.Open(); SqlCommand cmd = new SqlCommand("SP_HoaDon_Delete", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", hoaDon.ID); if (cmd.ExecuteNonQuery() > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } finally { conn.Close(); } }
public bool UpdateHoaDon(HoaDon_ET hoaDon) { try { conn.Open(); SqlCommand cmd = new SqlCommand("SP_HoaDon_Update", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", hoaDon.ID); cmd.Parameters.AddWithValue("@id_kh", hoaDon.ID_KhachHang); cmd.Parameters.AddWithValue("@id_nv", hoaDon.ID_NhanVien); cmd.Parameters.AddWithValue("@ngaylap", hoaDon.NgayLap); if (cmd.ExecuteNonQuery() > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } finally { conn.Close(); } }
public bool UpdateHoaDon(HoaDon_ET hoaDon) { return(dal_HoaDon.UpdateHoaDon(hoaDon)); }
public bool DeleteHoaDon(HoaDon_ET hoaDon) { return(dal_HoaDon.DeleteHoaDon(hoaDon)); }
public bool AddHoaDon(HoaDon_ET hoaDon) { return(dal_HoaDon.AddHoaDon(hoaDon)); }