protected void loadData(string DangKyBienDong)
{
try
{
tblYKienCoQuanDangKyDatDaiVeBienDong ykien = n.result(Session["DangKyBienDong"].ToString());
if (ykien != null)
{
txtNoiDungYKien.Text = ykien.NoiDungYKien;
txtNguoiKiemTra.Text = ykien.NguoiKiemTra;
if (ykien.NgayKiemTra != null)
{
txtNguoiKiemTra_NgayKy.Text = ykien.NgayKiemTra.ToString();
}
txtGiamDoc.Text = ykien.GiamDoc;
if (ykien.NgayKy != null)
{
txtGiamDoc_NgayKy.Text = ykien.NgayKy.ToString();
}
txtGhiChu.Text = ykien.GhiChu;
}
}
catch (Exception)
{
return;
}
}
public bool SuaXacNhanCoQuanDangKy(string MaDangKyBienDong, string NgayKiemtra, string NguoiKiemTra, string ChucVuNguoiKiemTra, string NoiDungYKien, string GhiChu, string NgayKy, string GiamDoc)
{
try
{
long _MaDangKyBienDong = long.Parse(MaDangKyBienDong);
tblYKienCoQuanDangKyDatDaiVeBienDong kq = db.tblYKienCoQuanDangKyDatDaiVeBienDongs.SingleOrDefault(n => n.MaDangKyBienDong == _MaDangKyBienDong);
kq.NgayKiemTra = Convert.ToDateTime(NgayKiemtra);
kq.NguoiKiemTra = NguoiKiemTra;
kq.ChucVuNguoiKiemTra = ChucVuNguoiKiemTra;
kq.NoiDungYKien = NoiDungYKien;
kq.GhiChu = GhiChu;
if (NgayKy.Trim() != "")
{
kq.NgayKy = Convert.ToDateTime(NgayKy);
}
kq.GiamDoc = GiamDoc;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool XoaXacNhanCoQuanDangKy(string MaDangKyBienDong)
{
try
{
long _MaDangKyBienDong = long.Parse(MaDangKyBienDong);
tblYKienCoQuanDangKyDatDaiVeBienDong kq = db.tblYKienCoQuanDangKyDatDaiVeBienDongs.SingleOrDefault(n => n.MaDangKyBienDong == _MaDangKyBienDong);
db.tblYKienCoQuanDangKyDatDaiVeBienDongs.Remove(kq);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool KiemTraTonTai(string MaDangKyBienDong)
{
try
{
long _MaDangKyBienDong = long.Parse(MaDangKyBienDong);
tblYKienCoQuanDangKyDatDaiVeBienDong kq = (from n in db.tblYKienCoQuanDangKyDatDaiVeBienDongs
where n.MaDangKyBienDong == _MaDangKyBienDong
select n).SingleOrDefault();
if (kq != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
