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