public bool create(GiayKhaiSinh entity) { try { string sqlString = "INSERT INTO GiayKhaiSinhs VALUES ('" + entity.So + "','" + entity.MaQuyen + "','" + entity.MaCD + "',N'" + entity.NoiSinh + "','" + entity.MaCD_Cha + "','" + entity.MaCD_Me + "','" + entity.MaCD_NguoiKhai + "',N'" + entity.QuanHe + "','" + entity.NgayDK_KhaiSinh.ToShortDateString() + "')"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi create KhaiSinh + " + e.Message); return(false); } }
public bool create(HoKhau entity) { try { string sqlString = "INSERT INTO HoKhaus VALUES ('" + entity.SoHK + "',N'" + entity.DiaChi + "')"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi create HoKhau + " + e.Message); return(false); } }
public bool create(CMND entity) { try { string sqlString = "INSERT INTO CMNDs VALUES ('" + entity.MaSo + "','" + entity.NgayCap.ToShortDateString() + "',N'" + entity.NoiCap + "')"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi create CMND + " + e.Message); return(false); } }
public bool create(ThuongTru TT) { try { string sqlString = "INSERT INTO ThuongTrus VALUES ('" + TT.SoQuyen + "','" + TT.SoDK + "','" + TT.MaCD + "',N'" + TT.NgayDK + "','" + TT.MaHoKhau + "','" + TT.NoiDKThuongTru + "','" + TT.NgayDen.ToShortDateString() + "','" + TT.NgayHuy.Value.ToShortDateString() + "')"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi create Thuong Tru + " + e.Message); return(false); } }
public bool create(CongDan entity) { try { string sqlString = "INSERT INTO CongDans VALUES ('" + entity.MaCD + "',N'" + entity.HoLot + "',N'" + entity.Ten + "','" + entity.GioiTinh.ToString() + "','" + entity.NgaySinh.ToShortDateString() + "',N'" + entity.QuocTich + "',N'" + entity.DanToc + "',NULL,N'" + entity.QueQuan + "',NULL,NULL,NULL,N'" + entity.DiaChiThuongTru + "',NULL,NULL,NULL,'True',NULL)"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi create CongDan + " + e.Message); return(false); } }
public bool create(GiayNhanConNuoi entity) { try { string sqlString = "INSERT INTO GiayNhanConNuois VALUES ('" + entity.MaGiayNhanConNuoi + "','" + entity.MaQuyen + "','" + entity.MaCD_Cha + "','" + entity.MaCD_Me + "','" + entity.MaCD_Con + "',N'" + entity.NoiDangKi + "','" + entity.NgayDangKi.ToShortDateString() + "',N'" + entity.GhiChu + "')"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi create GiayNhanConNuoi + " + e.Message); return(false); } }
public bool create(GiayDangKiKetHon entity) { try { string sqlString = "INSERT INTO GiayDangKiKetHons VALUES ('" + entity.MaGDKKetHon + "','" + entity.MaQuyen + "','" + entity.MaCD_Chong + "','" + entity.MaCD_Vo + "','" + entity.NgayDangKi.ToShortDateString() + "')"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi create KetHon + " + e.Message); return(false); } }
public bool create(HoKhau_QuanHe entity) { try { string sqlString = "INSERT INTO HoKhau_QuanHe VALUES ('" + entity.maHK + "','" + entity.maCD + "','" + entity.idQuanHe + "')"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi create HoKhau_QuanHe + " + e.Message); return(false); } }
public bool create(CapGiayTo entity) { try { string sqlString = "Insert Into CapGiayToes Values('" + entity.MaCD + "','" + entity.LoaiGiayTo + "','" + entity.NgayCap + "')"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi create CapGiayTo + " + e.Message); return(false); } }
public bool create(GiayChungTu entity) { try { string sqlString = "INSERT INTO GiayChungTus VALUES ('" + entity.MaGiayChungTu + "','" + entity.MaQuyen + "','" + entity.MaCD + "',N'" + entity.CoQuanBaoTu + "',N'" + entity.NoiChet + "',N'" + entity.NguyenNhan + "','" + entity.MaCD_NguoiKhai + "','" + entity.NgayTu.ToShortDateString() + "')"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); } catch (Exception e) { MessageBox.Show("Lỗi create ChungTu + " + e.Message); return(false); } }
public bool ThietLap(string xa, string quan, string thanhpho) { QuanLyDanCuModelADO db = Form1.db; string sqlString = "delete * from DonViQuanLis"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); }
public bool updateNgayHuy(string MaCD, DateTime NgayHuy) { string sqlString = "Update TamVangs Set NgayHuy=N'" + NgayHuy.ToShortDateString() + "' Where MaCD='" + MaCD + "'"; return(db.MyExecuteNonQuery(sqlString, CommandType.Text)); }