public bool hoadon_delete(hoadon data) { try { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("HoaDon_Delete", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MAHD", data.mahd)); cmd.ExecuteNonQuery(); } return(true); } catch { return(false); } }
public List <hoadon> hoadon_getAll() { List <hoadon> lst = new List <hoadon>(); using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("HoaDon_Select", conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { hoadon obj = new hoadon(); obj.hoadon_datareader(dr); lst.Add(obj); } } } return(lst); }
public bool hoadon_update(hoadon data) { try { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("HoaDon_Update", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MAHD", data.mahd)); cmd.Parameters.Add(new SqlParameter("@MAKH", data.makh)); cmd.Parameters.Add(new SqlParameter("@MANV", data.manv)); cmd.Parameters.Add(new SqlParameter("@NGAYLAP", data.ngaylap)); cmd.Parameters.Add(new SqlParameter("@TONGTIEN", data.tongtien)); cmd.ExecuteNonQuery(); } return(true); } catch { return(false); } }