protected void grvThuaDat_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Select") { NhapThongTinThuaDat_Visible(true); string _maThuaDat = e.CommandArgument.ToString(); Session["ThaoTac"] = ThaoTac.DangSua; Session["MaThuaDat"] = _maThuaDat; using (DMCWebEntities db = new DMCWebEntities()) { long maThuaDat = long.Parse(_maThuaDat); var thuadatdangxet = (from td in db.tblThuaDatDuBis where td.MaThuaDat == maThuaDat select td).Single(); tblThuaDatDuBi thua = (tblThuaDatDuBi)thuadatdangxet; lblMaThuaDat.Text = thua.MaThuaDat.ToString(); lblMaHoSo.Text = thua.MaHoSoKeKhai.ToString(); txtToBanDo.Text = thua.ToBanDo; txtSoThua.Text = thua.SoThua; txtDiaChi.Text = thua.DiaChi; txtDienTich.Text = thua.DienTich; txtDTSDChung.Text = thua.SuDungChung; txtDTSDRieng.Text = thua.SuDungRieng; txtMucDich.Text = thua.MucDichSuDung; txtThoiHan.Text = thua.ThoiHanSuDung; txtNgayBatDau.Text = thua.NgayBatDauSuDung.ToString(); drHanChe.SelectedValue = thua.CoHanCheSuDung.ToString().ToLower(); txtHanChe.Text = thua.NoiDungHanCheSuDung; drLoaiNguonGoc.SelectedValue = thua.LoaiNguonGocSuDung; } } }
public bool XoaThuaDatDuBi(string MaThuaDat) { try { long _maThuaDat = long.Parse(MaThuaDat); tblThuaDatDuBi thuadatcanxoa = db.tblThuaDatDuBis.Single(td => td.MaThuaDat == _maThuaDat); db.tblThuaDatDuBis.Remove(thuadatcanxoa); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool SuaThuaDatDuBi(string MaThuaDat, string MaHoSo, string ToBanDo, string SoThua, string DiaChi, string DienTich, string SuDungChung, string SuDungRieng, string NguonGoc, string MucDich, string CoHanChe, string HanChe, string SuDungTuNgay, string ThoiHan) { try { bool _coHanChe = false; if (CoHanChe.Trim().ToLower() == "true") { _coHanChe = true; } else { _coHanChe = false; } long _maThuaDat = long.Parse(MaThuaDat); tblThuaDatDuBi thuadatcansua = db.tblThuaDatDuBis.Single(td => td.MaThuaDat == _maThuaDat); thuadatcansua.MaHoSoKeKhai = Convert.ToInt32(MaHoSo); thuadatcansua.ToBanDo = ToBanDo; thuadatcansua.SoThua = SoThua; thuadatcansua.DiaChi = DiaChi; thuadatcansua.DienTich = DienTich; thuadatcansua.SuDungChung = SuDungChung; thuadatcansua.SuDungRieng = SuDungRieng; thuadatcansua.LoaiNguonGocSuDung = NguonGoc; thuadatcansua.MucDichSuDung = MucDich; thuadatcansua.CoHanCheSuDung = _coHanChe; thuadatcansua.NoiDungHanCheSuDung = HanChe; thuadatcansua.NgayBatDauSuDung = Convert.ToDateTime(SuDungTuNgay); thuadatcansua.ThoiHanSuDung = ThoiHan; db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool ThemThuaDatDuBi(string MaHoSo, string ToBanDo, string SoThua, string DiaChi, string DienTich, string SuDungChung, string SuDungRieng, string NguonGoc, string MucDich, string CoHanChe, string HanChe, string SuDungTuNgay, string ThoiHan) { try { bool _coHanChe = false; if (CoHanChe.Trim().ToLower() == "true") { _coHanChe = true; } else { _coHanChe = false; } tblThuaDatDuBi thuadatmoi = new tblThuaDatDuBi(); thuadatmoi.MaHoSoKeKhai = Convert.ToInt32(MaHoSo); thuadatmoi.ToBanDo = ToBanDo; thuadatmoi.SoThua = SoThua; thuadatmoi.DiaChi = DiaChi; thuadatmoi.DienTich = DienTich; thuadatmoi.SuDungChung = SuDungChung; thuadatmoi.SuDungRieng = SuDungRieng; thuadatmoi.LoaiNguonGocSuDung = NguonGoc; thuadatmoi.MucDichSuDung = MucDich; thuadatmoi.CoHanCheSuDung = _coHanChe; thuadatmoi.NoiDungHanCheSuDung = HanChe; thuadatmoi.NgayBatDauSuDung = Convert.ToDateTime(SuDungTuNgay); thuadatmoi.ThoiHanSuDung = ThoiHan; db.tblThuaDatDuBis.Add(thuadatmoi); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }