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