public bool capNhapNSX(ET_NSX sp) { try { _cn.Open(); SqlCommand cmd = new SqlCommand("sp_capnhapNSX", _cn); cmd.CommandText = "sp_capnhapNSX"; cmd.CommandType = CommandType.StoredProcedure; SqlParameter p_ma = new SqlParameter("@MaNSX", sp.Ma); cmd.Parameters.Add(p_ma); SqlParameter p_ten = new SqlParameter("@TenNSX", sp.Ten); cmd.Parameters.Add(p_ten); SqlParameter p_diachi = new SqlParameter("@DiaChi", sp.Diachi); cmd.Parameters.Add(p_diachi); SqlParameter p_sdt = new SqlParameter("@SDT", sp.Sdt); cmd.Parameters.Add(p_sdt); if (cmd.ExecuteNonQuery() > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } finally { _cn.Close(); } }
private void btnsua_Click(object sender, EventArgs e) { if (txtMa.Text != "" && txtDiaChi.Text != "" && txtMa.Text != "" && mtbSDT.Text != "") { ET_NSX lsp = new ET_NSX(txtMa.Text, txtTen.Text, txtDiaChi.Text, mtbSDT.Text); if (bLSP.SuaNSX(lsp) == true) { MessageBox.Show("Cập Nhập Thành Công"); } else { MessageBox.Show("khong thanh cong "); } } else { MessageBox.Show("Xem lại thông tin nhập"); } load(); }
private void btnThem_Click(object sender, EventArgs e) { if (txtMa.Text != "" && txtDiaChi.Text != "" && txtMa.Text != "" && mtbSDT.Text != "") { ET_NSX lsp = new ET_NSX(txtMa.Text, txtTen.Text, txtDiaChi.Text, mtbSDT.Text); if (bLSP.ThemNSX(lsp) == true) { MessageBox.Show("Them thanh cong "); txtMa.Text = ""; txtTen.Text = ""; txtDiaChi.Text = ""; mtbSDT.Text = ""; } else { MessageBox.Show("Them khong thanh cong "); } } else { MessageBox.Show("Xem lại thông tin nhập"); } load(); }
public bool SuaNSX(ET_NSX b) { return(kh.capNhapNSX(b)); }
public bool ThemNSX(ET_NSX b) { return(kh.themNSX(b)); }