public ActionResult LayYKien(string madoan)
{
if (madoan == null)
{
return(RedirectToAction("Index"));
}
if (madoan.Trim().Length == 0)
{
return(RedirectToAction("Index"));
}
THONGTINDOAN doan = this.gISRepository.getThongTinDoAn().Where(da => da.MaDoAn == madoan).FirstOrDefault();
if (doan == null)
{
return(RedirectToAction("Index"));
}
ViewBag.DoAn = doan;
ViewBag.HoSoDuAn = this.gISRepository.getHoSoDoAn().Where(hs => hs.MaDoAn == madoan).OrderBy(hs => hs.LoaiHoSo).ToList();
YKienQuyHoach ykien;
ykien = new YKienQuyHoach();
ykien.MaDoAn = doan.MaDoAn;
return(View(ykien));
}
public List <DoAn> getDoAn(string trangthaidoan)
{
List <THONGTINDOAN> listThongtindoan;
List <Domain> listQuanHuyen;
List <ListDoAn> ListThongTinDoAn;
ListDoAn doanMenu;
List <DoAn> listDoAnQuyHoach = new List <DoAn>();
DoAn doAnQuyHoach;
listQuanHuyen = this.gISRepository.getDomain("DMHuyenTPThiXa").ToList();
listQuanHuyen = listQuanHuyen.OrderBy(qh => qh.value).ToList();
for (int q = 0; q < listQuanHuyen.Count; q++)
{
Domain QuanHuyen = listQuanHuyen[q];
listThongtindoan = this.gISRepository.getThongTinDoAn().Where(da => da.MaQuanHuyen.Trim() == QuanHuyen.code.Trim() &&
da.TrangThaiDoAn == trangthaidoan).ToList();
ListThongTinDoAn = new List <dataHelper.ListDoAn>();
for (int i = 0; i < listThongtindoan.Count; i++)
{
THONGTINDOAN doan = listThongtindoan[i];
doanMenu = new ListDoAn();
doanMenu.MaDoAn = doan.MaDoAn;
doanMenu.TenDoAn = doan.TenDoAn;
ListThongTinDoAn.Add(doanMenu);
}
doAnQuyHoach = new DoAn();
doAnQuyHoach.MaQuanHuyen = QuanHuyen.code;
doAnQuyHoach.TenQuanHuyen = QuanHuyen.value;
doAnQuyHoach.ListDoAnQuyHoach = ListThongTinDoAn;
listDoAnQuyHoach.Add(doAnQuyHoach);
}
return(listDoAnQuyHoach);
}
public List <LoaiQuyHoach> getLoaiQuyHoachByHanhChinh(string maquanHuyen, string trangthaidoan)
{
List <LoaiQuyHoach> list = new List <LoaiQuyHoach>();
List <THONGTINDOAN> listThongtindoan = this.gISRepository.getThongTinDoAn().Where(da => da.MaQuanHuyen == maquanHuyen &&
da.TrangThaiDoAn == trangthaidoan).ToList();
List <Domain> listDoMain = this.gISRepository.getDomain("DMLoaiQuyHoach").ToList();
LoaiQuyHoach loaiQuyHoach;
List <ListDoAn> ListThongTinDoAn;
ListDoAn doanMenu;
for (int d = 0; d < listDoMain.Count; d++)
{
Domain doman = listDoMain[d];
ListThongTinDoAn = new List <dataHelper.ListDoAn>();
for (int i = 0; i < listThongtindoan.Count; i++)
{
THONGTINDOAN doan = listThongtindoan[i];
if (doan.LoaiQuyHoach == doman.code)
{
doanMenu = new ListDoAn();
doanMenu.MaDoAn = doan.MaDoAn;
doanMenu.TenDoAn = doan.TenDoAn;
ListThongTinDoAn.Add(doanMenu);
}
}
loaiQuyHoach = new LoaiQuyHoach();
loaiQuyHoach.MaLoaiQuyHoach = doman.code;
loaiQuyHoach.TenLoaiQuyHoach = doman.value;
loaiQuyHoach.ListThongTinDoAn = ListThongTinDoAn;
list.Add(loaiQuyHoach);
}
return(list);
}
public List <DoAnQuyHoach> getLoaiQuyHoachByHanhChinh(string trangthaidoan)
{
List <THONGTINDOAN> listThongtindoan;
List <Domain> listDoMain;
List <Domain> listQuanHuyen;
LoaiQuyHoach loaiQuyHoach;
List <ListDoAn> ListThongTinDoAn;
ListDoAn doanMenu;
List <LoaiQuyHoach> list;
List <DoAnQuyHoach> listDoAnQuyHoach = new List <DoAnQuyHoach>();
DoAnQuyHoach doAnQuyHoach;
listDoMain = this.gISRepository.getDomain("DMLoaiQuyHoach").ToList();
listQuanHuyen = this.gISRepository.getDomain("DMHuyenTPThiXa").ToList();
listQuanHuyen = listQuanHuyen.OrderBy(qh => qh.code).ToList();
for (int q = 0; q < listQuanHuyen.Count; q++)
{
Domain QuanHuyen = listQuanHuyen[q];
listThongtindoan = this.gISRepository.getThongTinDoAn().Where(da =>
da.MaQuanHuyen.Trim() == QuanHuyen.code.Trim() &&
da.TrangThaiDoAn == trangthaidoan).ToList();
list = new List <LoaiQuyHoach>();
for (int d = 0; d < listDoMain.Count; d++)
{
Domain doman = listDoMain[d];
ListThongTinDoAn = new List <dataHelper.ListDoAn>();
for (int i = 0; i < listThongtindoan.Count; i++)
{
THONGTINDOAN doan = listThongtindoan[i];
if (doan.LoaiQuyHoach == doman.code)
{
doanMenu = new ListDoAn();
doanMenu.MaDoAn = doan.MaDoAn;
doanMenu.TenDoAn = doan.TenDoAn;
ListThongTinDoAn.Add(doanMenu);
}
}
//if (ListThongTinDoAn.Count > 0)
//{
loaiQuyHoach = new LoaiQuyHoach();
loaiQuyHoach.MaLoaiQuyHoach = doman.code;
loaiQuyHoach.TenLoaiQuyHoach = doman.value;
loaiQuyHoach.ListThongTinDoAn = ListThongTinDoAn;
list.Add(loaiQuyHoach);
//}
}
//if (list.Count > 0)
//{
doAnQuyHoach = new DoAnQuyHoach();
doAnQuyHoach.MaQuanHuyen = QuanHuyen.code;
doAnQuyHoach.TenQuanHuyen = QuanHuyen.value;
doAnQuyHoach.ListLoaiQuyHoach = list;
listDoAnQuyHoach.Add(doAnQuyHoach);
//}
}
return(listDoAnQuyHoach);
}
public ActionResult XuatPhieu(ThongTinQHXD thongTinQHXD, QHCT_SUDUNGDAT quyHoachChiTietSDD, THONGTINDOAN thongTinDoAn, ImageQHXD imageQHXD)
{
thongTinQHXD.ThongTinDoAn = thongTinDoAn;
thongTinQHXD.QuyHoachChiTietSDD = quyHoachChiTietSDD;
thongTinQHXD.ImageQHXD = imageQHXD;
var io = new ExlThongTinQHXD();
var path = HostingEnvironment.ApplicationPhysicalPath + @"/Resources/MauPhieu/MauPhieuThongTin_GIS.xlsx";
HttpContext.Response.Headers.Add("Access-Control-Expose-Headers", "Content-Disposition");
return(File(io.Build(path, thongTinQHXD), System.Net.Mime.MediaTypeNames.Application.Octet, "report.xlsx"));
}
public ActionResult reviewYKienNguoiDan(string madoan, string loaiDoAn)
{
khaoSatNguoiDung khaoSatNguoiDung = GetCart();
if (madoan == null)
{
return(RedirectToAction("Index"));
}
if (madoan.Trim().Length == 0)
{
return(RedirectToAction("Index"));
}
string table = "";
if (loaiDoAn == "QHCT")
{
table = "QHCT_ThongTinDoAn";
}
if (loaiDoAn == "QHPK")
{
table = "QHPK_ThongTinDoAn";
}
if (loaiDoAn == "QHC")
{
table = "QHC_ThongTinDoAn";
}
if (loaiDoAn == "QHNT")
{
table = "QHNT_ThongTinDoAn";
}
if (loaiDoAn == "KHAC")
{
table = "KHAC_ThongTinDoAn";
}
if (loaiDoAn == "QHV")
{
table = "QHV_ThongTinDoAn";
}
THONGTINDOAN doan = this.gISRepository.getThongTinDoAn(loaiDoAn).Where(da => da.MaDoAn == madoan).FirstOrDefault();
if (doan == null)
{
return(RedirectToAction("Index"));
}
ViewBag.DoAn = doan;
//khaoSatNguoiDung khaoSatNguoiDung = GetCart();
string noiDung = "";
if (khaoSatNguoiDung != null)
{
foreach (var line in khaoSatNguoiDung.Lines)
{
if (line.HoSo.MaDoAn == madoan)
{
noiDung += "\n" + line.yKien;
}
}
}
YKienQuyHoach ykien;
ykien = new YKienQuyHoach();
ykien.MaDoAn = doan.MaDoAn;
ykien.NoiDungGopY = noiDung;
ykien.TenDoAn = doan.TenDoAn;
ykien.BangDuLieu = table;
return(View(ykien));
}
