private void btXacNhan_Click(object sender, EventArgs e)
{
MaQL M = new MaQL();
M.ShowDialog();
if (M.DialogResult == DialogResult.OK)
{
dt = XuLyDuLieu.docDuLieu("Select MaCN From CHI_NHANH Where TenCN like N'" + txtChiNhanh.Text + "'");
foreach (DataRow dr in dt.Rows)
{
Ma = dr[0].ToString();
}
// Store
SqlConnection con = new SqlConnection(XuLyDuLieu.connectionString);
con.Open();
SqlCommand cmd = new SqlCommand("DangKy", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MaCN", SqlDbType.Char));
cmd.Parameters.Add(new SqlParameter("@HoTen", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlParameter("@GioiTinh", SqlDbType.Char));
cmd.Parameters.Add(new SqlParameter("@DienThoai", SqlDbType.Int));
cmd.Parameters.Add(new SqlParameter("@DiaChi", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlParameter("@NgaySinh", SqlDbType.DateTime));
cmd.Parameters.Add(new SqlParameter("@TaiKhoan", SqlDbType.Char));
cmd.Parameters.Add(new SqlParameter("@MatKhau", SqlDbType.Char));
cmd.Parameters["@MaCN"].Value = Ma;
cmd.Parameters["@HoTen"].Value = txtHoTen.Text;
if (cbNam.CheckState == CheckState.Checked)
{
cmd.Parameters["@GioiTinh"].Value = cbNam.Text;
}
else
{
cmd.Parameters["@GioiTinh"].Value = cbNu.Text;
}
cmd.Parameters["@DienThoai"].Value = txtSDT.Text;
cmd.Parameters["@DiaChi"].Value = txtDiaChi.Text;
cmd.Parameters["@NgaySinh"].Value = txtNgaySinh.Text;
cmd.Parameters["@TaiKhoan"].Value = txtTaiKhoan.Text;
cmd.Parameters["@MatKhau"].Value = txtMatKhau.Text;
cmd.Parameters.Add("RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
con.Close();
int ReturnValueInt = Convert.ToInt32(cmd.Parameters["RETURN_VALUE"].Value);
if (ReturnValueInt == 1)
{
MessageBox.Show("Đăng ký thành công");
this.Hide();
}
else
{
MessageBox.Show("Tài khoản đã tồn tại");
}
}
}
private void btXoaCN_Click_1(object sender, EventArgs e)
{
MaQL A = new MaQL();
A.ShowDialog();
if (A.DialogResult == DialogResult.OK)
{
if (dgvChiNhanh.SelectedRows.Count > 0)
{
DataRow dr = ((DataRowView)dgvChiNhanh.SelectedRows[0].DataBoundItem).Row;
SqlConnection conn = new SqlConnection(XuLyDuLieu.connectionString);
conn.Open();
SqlCommand cmd = new SqlCommand("proc_XoaCN", conn);
cmd.Parameters.Add(new SqlParameter("@maCN", SqlDbType.Char));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters["@maCN"].Value = dr[0];
cmd.ExecuteNonQuery();
conn.Close();
}
}
Form_Load();
}