public bool nhacungcap_delete(nhacungcap data) { try { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("NhaCungCap_Delete", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MANCC", data.mancc)); cmd.ExecuteNonQuery(); } return(true); } catch { return(false); } }
public List <nhacungcap> nhacungcap_getAll() { List <nhacungcap> lst = new List <nhacungcap>(); using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("NhaCungCap_Select", conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { nhacungcap obj = new nhacungcap(); obj.nhacungcap_datareader(dr); lst.Add(obj); } } } return(lst); }
public bool nhacungcap_update(nhacungcap data) { try { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("NhaCungCap_Update", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MANCC", data.mancc)); cmd.Parameters.Add(new SqlParameter("@TENNCC", data.tenncc)); cmd.Parameters.Add(new SqlParameter("@DIACHI", data.diachi)); cmd.Parameters.Add(new SqlParameter("@DIENTHOAI", data.dienthoai)); cmd.ExecuteNonQuery(); } return(true); } catch { return(false); } }