protected void loadData(string DangKyBienDong)
{
try
{
tblYKienCoQuanTaiNguyenVaMoiTruongVeBienDong ykien = n.resultTNMT(Session["DangKyBienDong"].ToString());
if (ykien != null)
{
txtNoiDungYKien.Text = ykien.NoiDungYKien;
txtNguoiKiemTra.Text = ykien.NguoiKiemTra;
if (ykien.NgayKiemTra != null)
{
txtNguoiKiemTra_NgayKy.Text = ykien.NgayKiemTra.ToString();
}
txtThuTruong.Text = ykien.ThuTruongCoQuanKy;
if (ykien.NgayKy != null)
{
txtThuTruong_NgayKy.Text = ykien.NgayKy.ToString();
}
}
}
catch (Exception)
{
return;
}
}
public bool SuaXacNhanCoQuanTNMT(string MaDangKyBienDong, string NgayKiemtra, string NguoiKiemTra, /* string ChucVuNguoiKiemTra, */ string NoiDungYKien, string GhiChu, string NgayKy, string ThuTruong)
{
try
{
long _MaDangKyBienDong = long.Parse(MaDangKyBienDong);
tblYKienCoQuanTaiNguyenVaMoiTruongVeBienDong kq = db.tblYKienCoQuanTaiNguyenVaMoiTruongVeBienDongs.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.ThuTruongCoQuanKy = ThuTruong;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool XoaXacNhanCoQuanTNMT(string MaDangKyBienDong)
{
try
{
long _MaDangKyBienDong = long.Parse(MaDangKyBienDong);
tblYKienCoQuanTaiNguyenVaMoiTruongVeBienDong kq = db.tblYKienCoQuanTaiNguyenVaMoiTruongVeBienDongs.SingleOrDefault(n => n.MaDangKyBienDong == _MaDangKyBienDong);
db.tblYKienCoQuanTaiNguyenVaMoiTruongVeBienDongs.Remove(kq);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool KiemTraTonTaiTNMT(string MaDangKyBienDong)
{
try
{
long _MaDangKyBienDong = long.Parse(MaDangKyBienDong);
tblYKienCoQuanTaiNguyenVaMoiTruongVeBienDong kq = (from n in db.tblYKienCoQuanTaiNguyenVaMoiTruongVeBienDongs
where n.MaDangKyBienDong == _MaDangKyBienDong
select n).SingleOrDefault();
if (kq != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
