public static bool Them_KH(KhachHang k) { bool ban = false; if (isConnect()) { SqlCommand com = new SqlCommand(); com.CommandText = "Them_KH"; com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@ten", k.HoTen); com.Parameters.AddWithValue("@cmnd", k.CMND); com.Parameters.AddWithValue("@diachi", k.DiaChi); com.Parameters.AddWithValue("@nlv", k.NoiLamViec); com.Parameters.AddWithValue("@ns", k.NS); com.Parameters.AddWithValue("@sdt", k.SDT); com.Connection = con; int i = com.ExecuteNonQuery(); ban = i > 0 ? true : false; } return ban; }
private void QLKH_but_OK_Click(object sender, EventArgs e) { if (txtCmnd.Text != "" && txtdc.Text != "" && txtdt.Text != "" && txtnct.Text != "" && txtten.Text != "") { KhachHang k = new KhachHang(); k.CMND = txtCmnd.Text; k.HoTen = txtten.Text; k.SDT = txtdt.Text; k.DiaChi = txtdc.Text; k.NoiLamViec = txtnct.Text; k.NS = QLKH_dateNS.Value; bool kt = connect.Them_KH(k); if (kt) MessageBox.Show("Them khach hang thanh cong"); else MessageBox.Show("Them khach hang that bai"); } else MessageBox.Show("Nhap du thong tin"); }