public JsonResult GetChienDichInfo(string AutoID)
{
JsonResult jResult = new JsonResult();
try
{
ChienDichTruyenThongRequestEM request = new ChienDichTruyenThongRequestEM();
request.AutoID = AutoID;
List <ChienDichTruyenThongEM> lstCDTT = new List <ChienDichTruyenThongEM>();
lstCDTT = EFNotificationHistory.LoadAllChienDichTruyenThong(request);
if (lstCDTT.Count > 0)
{
jResult = Json(new { code = "0", data = lstCDTT[0], message = CoreVar.sMessageSuccess }, JsonRequestBehavior.AllowGet);
}
else
{
jResult = Json(new { code = "1", message = CoreVar.sMessageError }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception)
{
jResult = Json(new { code = "1", message = CoreVar.sMessageError }, JsonRequestBehavior.AllowGet);
}
return(jResult);
}
public JsonResult LoadAllChienDichTruyenThong(ChienDichTruyenThongRequestEM request)
{
JsonResult jResult = new JsonResult();
try
{
var data = EFNotificationHistory.LoadAllChienDichTruyenThong(request);
jResult = Json(new { code = "0", data = data }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
jResult = Json(new { code = "1", message = CoreVar.sMessageError }, JsonRequestBehavior.AllowGet);
}
return(jResult);
}
public List <ChienDichTruyenThongEM> LoadAllChienDichTruyenThong(ChienDichTruyenThongRequestEM objRequest)
{
List <ChienDichTruyenThongEM> lstCDTT = new List <ChienDichTruyenThongEM>();
try
{
if (objRequest.TU_NGAY != null)
{
objRequest.TU_NGAY = objRequest.TU_NGAY.Value.Date;
}
if (objRequest.DEN_NGAY != null)
{
objRequest.DEN_NGAY = objRequest.DEN_NGAY.Value.Date.AddDays(1);
}
lstCDTT = (from x in _context.ChienDichTruyenThongs
where (string.IsNullOrEmpty(objRequest.AutoID) || x.AutoID.ToString() == objRequest.AutoID) &&
(string.IsNullOrEmpty(objRequest.HINH_THUC_TRUYEN_THONG) || x.HINH_THUC_TRUYEN_THONG.Value.ToString() == objRequest.HINH_THUC_TRUYEN_THONG) &&
(string.IsNullOrEmpty(objRequest.DOI_TUONG) || x.DOI_TUONG.Value.ToString() == objRequest.DOI_TUONG) &&
(string.IsNullOrEmpty(objRequest.TINH_ID) || x.TINH_ID.Value.ToString() == objRequest.TINH_ID) &&
(string.IsNullOrEmpty(objRequest.HUYEN_ID) || x.HUYEN_ID.Value.ToString() == objRequest.HUYEN_ID) &&
(string.IsNullOrEmpty(objRequest.XA_ID) || x.HUYEN_ID.Value.ToString() == objRequest.XA_ID) &&
(objRequest.TU_NGAY == null || objRequest.TU_NGAY <= x.NGAY_THUC_HIEN) &&
(objRequest.DEN_NGAY == null || x.NGAY_THUC_HIEN <= objRequest.DEN_NGAY)
select new ChienDichTruyenThongEM
{
AutoID = x.AutoID,
TEN_CHIEN_DICH = x.TEN_CHIEN_DICH,
HINH_THUC_TRUYEN_THONG = x.HINH_THUC_TRUYEN_THONG,
KHU_VUC_ID = x.KHU_VUC_ID,
PHAM_VI = x.PHAM_VI,
NGAY_THUC_HIEN = x.NGAY_THUC_HIEN,
SO_LUONG = x.SO_LUONG,
DOI_TUONG = x.DOI_TUONG,
NOI_DUNG = x.NOI_DUNG,
TRANG_THAI = x.TRANG_THAI,
SO_LUONG_THANH_CONG = x.SO_LUONG_THANH_CONG,
TINH_ID = x.TINH_ID,
HUYEN_ID = x.HUYEN_ID,
XA_ID = x.XA_ID,
}).ToList();
foreach (var item in lstCDTT)
{
item.NGAY_THUC_HIEN_SHOW = item.NGAY_THUC_HIEN.Value.ToString(CoreVar.sFormatDate + " HH:mm");
item.GIO_THUC_HIEN = item.NGAY_THUC_HIEN.Value;
if (item.PHAM_VI == 2)
{
item.KHU_VUC = _context.Tinhs.FirstOrDefault(x => x.TINH_ID == item.KHU_VUC_ID).TENTINH;
}
else if (item.PHAM_VI == 3)
{
item.KHU_VUC = _context.Huyens.FirstOrDefault(x => x.HUYEN_ID == item.KHU_VUC_ID).TENHUYEN;
}
else if (item.PHAM_VI == 4)
{
var xaOBJ = _context.Xas.FirstOrDefault(x => x.XA_ID == item.KHU_VUC_ID);
if (xaOBJ != null)
{
item.KHU_VUC = xaOBJ.TENXA;
}
}
else
{
item.KHU_VUC = "Không Xác Định";
}
if (item.TRANG_THAI == 1)
{
item.TEN_TRANG_THAI = "Đã Được Gửi";
}
else
{
item.TEN_TRANG_THAI = "Chưa Được Gửi";
}
}
}
catch (Exception)
{
}
return(lstCDTT);
}
