public FrmChiTietCccd(Cccd cd)
{
InitializeComponent();
cccd = cd;
if (cccd.Ma == -1)
{
SetThemState();
cccd.NgayCap = DateTime.Now;
cccd.NgaySinh = DateTime.Now;
cccd.ThoiHan = DateTime.Now;
}
else
{
SetSuaState();
disableSua();
rbKhong.Select();
}
setData(cccd);
btnLuuSua.Click += BtnLuuSua_Click;
btnLuuThem.Click += BtnLuuThem_Click;
rbCo.Click += RbCo_Click;
rbKhong.Click += RbKhong_Click;
}
public bool Delete(Cccd cd)
{
string query = string.Empty;
query += "DELETE FROM [CCCD] WHERE [Ma] = @Ma";
using (SqlConnection _cnn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = _cnn;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Ma", cd.Ma);
try
{
_cnn.Open();
cmd.ExecuteNonQuery();
_cnn.Close();
_cnn.Dispose();
}
catch (Exception ex)
{
_cnn.Close();
return(false);
}
}
}
return(true);
}
private void setData(Cccd result)
{
tbHoTen.Text = result.HoTen;
tbSoCccd.Text = result.SoCccd;
tbGioiTinh.Text = result.GioiTinh;
tbQueQuan.Text = result.QueQuan;
tbQuocTich.Text = result.QuocTich;
tbDiaChi.Text = result.DiaChiHoKhau;
tbDacDiem.Text = result.DacDiemNhanDang;
tbNoiCap.Text = result.NoiCap;
tbNguoiCap.Text = result.NguoiCap;
if (result.NgayCap != null)
{
dtpNgayCap.Value = result.NgayCap;
}
if (result.NgaySinh != null)
{
dtpNgaySinh.Value = result.NgaySinh;
}
if (result.ThoiHan != null)
{
dtpThoiHan.Value = result.ThoiHan;
}
}
public bool Update(Cccd cd)
{
string query = string.Empty;
query += "UPDATE [CCCD] SET ";
query += "[SoCccd] = @SoCccd, ";
query += "[HoTen] = @HoTen, ";
query += "[GioiTinh] = @GioiTinh, ";
query += "[NgaySinh] = @NgaySinh, ";
query += "[QueQuan] = @QueQuan, ";
query += "[QuocTich] = @QuocTich, ";
query += "[DiaChiHoKhau] = @DiaChiHoKhau, ";
query += "[ThoiHan] = @ThoiHan, ";
query += "[DacDiemNhanDang] = @DacDiemNhanDang, ";
query += "[NgayCap] = @NgayCap, ";
query += "[NoiCap] = @NoiCap, ";
query += "[NguoiCap] = @NguoiCap ";
query += "WHERE [Ma] = @Ma";
using (SqlConnection _cnn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = _cnn;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Ma", cd.Ma);
cmd.Parameters.AddWithValue("@HoTen", cd.HoTen);
cmd.Parameters.AddWithValue("@SoCccd", cd.SoCccd);
cmd.Parameters.AddWithValue("@GioiTinh", cd.GioiTinh);
cmd.Parameters.AddWithValue("@NgaySinh", cd.NgaySinh);
cmd.Parameters.AddWithValue("@QueQuan", cd.QueQuan);
cmd.Parameters.AddWithValue("@QuocTich", cd.QuocTich);
cmd.Parameters.AddWithValue("@DiaChiHoKhau", cd.DiaChiHoKhau);
cmd.Parameters.AddWithValue("@ThoiHan", cd.ThoiHan);
cmd.Parameters.AddWithValue("@DacDiemNhanDang", cd.DacDiemNhanDang);
cmd.Parameters.AddWithValue("@NgayCap", cd.NgayCap);
cmd.Parameters.AddWithValue("@NoiCap", cd.NoiCap);
cmd.Parameters.AddWithValue("@NguoiCap", cd.NguoiCap);
try
{
_cnn.Open();
cmd.ExecuteNonQuery();
_cnn.Close();
_cnn.Dispose();
}
catch (Exception ex)
{
_cnn.Close();
return(false);
}
}
}
return(true);
}
private void BtnTaoCccd_Click(object sender, EventArgs e)
{
Cccd cccd = new Cccd();
congDan.Update(cccd);
FrmChiTietCccd frm = new FrmChiTietCccd(cccd);
frm.AddCccdEvent += Frm_AddCccdEvent;
frm.UpdateCccdEvent += Frm_UpdateCccdEvent;
frm.Show(this);
}
public bool Add(Cccd cd)
{
string query = string.Empty;
query += @"
INSERT INTO [CCCD] (
[SoCccd], [HoTen], [GioiTinh], [NgaySinh], [QueQuan], [QuocTich],
[DiaChiHoKhau], [ThoiHan], [DacDiemNhanDang], [NgayCap], [NoiCap], [NguoiCap])
VALUES
(@SoCccd, @HoTen, @GioiTinh, @NgaySinh, @QueQuan, @QuocTich, @DiaChiHoKhau,
@ThoiHan, @DacDiemNhanDang, @NgayCap, @NoiCap, @NguoiCap)";
using (SqlConnection _cnn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = _cnn;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@SoCccd", cd.SoCccd);
cmd.Parameters.AddWithValue("@HoTen", cd.HoTen);
cmd.Parameters.AddWithValue("@GioiTinh", cd.GioiTinh);
cmd.Parameters.AddWithValue("@NgaySinh", cd.NgaySinh);
cmd.Parameters.AddWithValue("@QueQuan", cd.QueQuan);
cmd.Parameters.AddWithValue("@QuocTich", cd.QuocTich);
cmd.Parameters.AddWithValue("@DiaChiHoKhau", cd.DiaChiHoKhau);
cmd.Parameters.AddWithValue("@ThoiHan", cd.ThoiHan);
cmd.Parameters.AddWithValue("@DacDiemNhanDang", cd.DacDiemNhanDang);
cmd.Parameters.AddWithValue("@NgayCap", cd.NgayCap);
cmd.Parameters.AddWithValue("@NoiCap", cd.NoiCap);
cmd.Parameters.AddWithValue("@NguoiCap", cd.NguoiCap);
try
{
_cnn.Open();
cmd.ExecuteNonQuery();
_cnn.Close();
_cnn.Dispose();
}
catch (Exception ex)
{
_cnn.Close();
return(false);
}
}
}
return(true);
}
private void setCmndCccd()
{
if (congDan.CoCccd())
{
cccd = cccdBUS.Read(congDan.SoCccd);
}
else
{
btnXemCccd.Enabled = false;
}
if (congDan.CoCmnd())
{
cmnd = cmndBUS.Read(congDan.SoCmnd);
}
else
{
btnXemCmnd.Enabled = false;
}
}
private Cccd GetFromReader(SqlDataReader reader)
{
Cccd cd = new Cccd();
cd.Ma = int.Parse(reader["Ma"].ToString());
cd.SoCccd = reader["SoCccd"].ToString();
cd.HoTen = reader["HoTen"].ToString();
cd.GioiTinh = reader["GioiTinh"].ToString();
cd.QueQuan = reader["QueQuan"].ToString();
cd.QuocTich = reader["QuocTich"].ToString();
cd.DiaChiHoKhau = reader["DiaChiHoKhau"].ToString();
cd.ThoiHan = DateTime.Parse(reader["ThoiHan"].ToString());
cd.DacDiemNhanDang = reader["DacDiemNhanDang"].ToString();
cd.NgayCap = DateTime.Parse(reader["NgayCap"].ToString());
cd.NgaySinh = DateTime.Parse(reader["NgaySinh"].ToString());
cd.NoiCap = reader["NoiCap"].ToString();
cd.NguoiCap = reader["NguoiCap"].ToString();
return(cd);
}
public Cccd Read(string ma)
{
string query = string.Empty;
query += "SELECT TOP 1 * ";
query += "FROM [CCCD] WHERE [SoCccd]=@SoCccd";
Cccd cd = new Cccd();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@SoCccd", ma);
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
reader.Read();
cd = GetFromReader(reader);
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(null);
}
}
}
return(cd);
}
private void Frm_AddCccdEvent(object sender, Cccd cd)
{
cccd = cd;
tbSoCccd.Text = cd.SoCccd;
}
private void Frm_UpdateCccdEvent(object sender, Cccd cd)
{
}
public bool Delete(Cccd cd)
{
return(CccdDAL.GetInstance().Delete(cd));
}
public bool Update(Cccd cd)
{
return(CccdDAL.GetInstance().Update(cd));
}
public bool Add(Cccd cd)
{
return(CccdDAL.GetInstance().Add(cd));
}
