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)); }