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