public bool cthoadon_delete(cthoadon data) { try { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("CTHoaDon_Delete", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MAHD", data.mahd)); cmd.Parameters.Add(new SqlParameter("@MAHH", data.mahh)); cmd.ExecuteNonQuery(); } return(true); } catch { return(false); } }
public List <cthoadon> cthoadon_getAll() { List <cthoadon> lst = new List <cthoadon>(); using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("CTHoaDon_Select", conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { cthoadon obj = new cthoadon(); obj.cthoadon_datareader(dr); lst.Add(obj); } } } return(lst); }
public bool cthoadon_insert(cthoadon data) { try { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("CTHoaDon_Insert", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MAHD", data.mahd)); cmd.Parameters.Add(new SqlParameter("@MAHH", data.mahh)); cmd.Parameters.Add(new SqlParameter("@DONGIA", data.dongia)); cmd.Parameters.Add(new SqlParameter("@SOLUONG", data.soluong)); cmd.Parameters.Add(new SqlParameter("@THANHTIEN", data.thanhtien)); cmd.ExecuteNonQuery(); } return(true); } catch { return(false); } }