public JsonResult searchData(FormCollection form)
{
HSCV_CONGVIECBusiness = Get <HSCV_CONGVIECBusiness>();
var searchModel = SessionManager.GetValue("ProcessedJobSearchModel") as HSCV_CONGVIEC_SEARCH;
if (searchModel == null)
{
searchModel = new HSCV_CONGVIEC_SEARCH();
searchModel.pageSize = MaxPerpage;
}
string TENCONGVIEC = form["TENCONGVIEC"];
string NGAYBATDAU_FROM = form["NGAYBATDAU_FROM"];
string NGAYBATDAU_TO = form["NGAYBATDAU_TO"];
string NGAYKETTHUC_FROM = form["NGAYKETTHUC_FROM"];
string NGAYKETTHUC_TO = form["NGAYKETTHUC_TO"];
string DOKHAN_ID = form["DOKHAN_ID"];
string DOMAT_ID = form["DOMAT_ID"];
#region Gán giá trị
if (!string.IsNullOrEmpty(TENCONGVIEC))
{
searchModel.TENCONGVIEC = TENCONGVIEC.Trim();
}
searchModel.NGAYBATDAU_FROM = NGAYBATDAU_FROM.ToDateTime();
searchModel.NGAYBATDAU_TO = NGAYBATDAU_TO.ToDateTime();
searchModel.NGAYKETTHUC_FROM = NGAYKETTHUC_FROM.ToDateTime();
searchModel.NGAYKETTHUC_TO = NGAYKETTHUC_TO.ToDateTime();
if (!string.IsNullOrEmpty(DOKHAN_ID))
{
searchModel.DOKHAN = DOKHAN_ID.ToLongOrNULL();
}
if (!string.IsNullOrEmpty(DOMAT_ID))
{
searchModel.DO_UUTIEN = DOMAT_ID.ToLongOrNULL();
}
#endregion
SessionManager.SetValue("ProcessedJobSearchModel", searchModel);
var data = HSCV_CONGVIECBusiness.GetListProcessedJob(searchModel, searchModel.pageSize, 1);
SessionManager.SetValue("ProcessedJobSearch", data.ListItem);
return(Json(data));
}
//private CCTC_THANHPHANBusiness CCTC_THANHPHANBusiness;
public ActionResult Index()
{
CongViecIndexViewModel model = new CongViecIndexViewModel();
HSCV_CONGVIECBusiness = Get <HSCV_CONGVIECBusiness>();
HSCV_CONGVIEC_SEARCH searchModel = new HSCV_CONGVIEC_SEARCH();
AssignUserInfo();
searchModel.USER_ID = currentUser.ID;
searchModel.pageSize = MaxPerpage;
SessionManager.SetValue("ProcessedJobSearchModel", searchModel);
var ListCongViec = HSCV_CONGVIECBusiness.GetListProcessedJob(searchModel, MaxPerpage);
model.ListResult = ListCongViec;
DM_DANHMUC_DATABusiness = Get <DM_DANHMUC_DATABusiness>();
model.ListDoKhan = DM_DANHMUC_DATABusiness.DsByMaNhom(DMLOAI_CONSTANT.DOQUANTRONG, 0);
model.ListDoUuTien = DM_DANHMUC_DATABusiness.DsByMaNhom(DMLOAI_CONSTANT.DOUUTIEN, 0);
model.UserInfo = currentUser;
SessionManager.SetValue("ProcessedJobSearch", ListCongViec.ListItem);
return(View(model));
}
public ActionResult Index()
{
CongViecIndexViewModel model = new CongViecIndexViewModel();
HSCV_CONGVIECBusiness = Get <HSCV_CONGVIECBusiness>();
HSCV_CONGVIEC_SEARCH searchModel = new HSCV_CONGVIEC_SEARCH();
AssignUserInfo();
searchModel.LOAI_CONGVIEC = LOAI_CONGVIEC.PHOIHOP_XULY;
searchModel.USER_ID = currentUser.ID;
searchModel.pageSize = MaxPerpage;
SessionManager.SetValue("CongViecXLSearchModel", searchModel);
var ListCongViec = HSCV_CONGVIECBusiness.GetDaTaByPage(searchModel, MaxPerpage);
model.ListResult = ListCongViec;
DM_DANHMUC_DATABusiness = Get <DM_DANHMUC_DATABusiness>();
model.ListDoKhan = DM_DANHMUC_DATABusiness.DsByMaNhom(DMLOAI_CONSTANT.DOKHAN, 0);
model.ListDoUuTien = DM_DANHMUC_DATABusiness.DsByMaNhom(DMLOAI_CONSTANT.DOUUTIEN, 0);
model.UserInfo = currentUser;
return(View(model));
}
public JsonResult getData(int indexPage, string sortQuery, int pageSize)
{
HSCV_CONGVIECBusiness = Get <HSCV_CONGVIECBusiness>();
var searchModel = SessionManager.GetValue("CongViecXLSearchModel") as HSCV_CONGVIEC_SEARCH;
if (!string.IsNullOrEmpty(sortQuery))
{
if (searchModel == null)
{
searchModel = new HSCV_CONGVIEC_SEARCH();
}
searchModel.sortQuery = sortQuery;
if (pageSize > 0)
{
searchModel.pageSize = pageSize;
}
SessionManager.SetValue("CongViecXLSearchModel", searchModel);
}
var data = HSCV_CONGVIECBusiness.GetDaTaByPage(searchModel, pageSize, indexPage);
return(Json(data));
}
public PageListResultBO <CongViecBO> GetDaTaByPage(HSCV_CONGVIEC_SEARCH searchModel, int pageSize = 20, int pageIndex = 1)
{
var query = from congviec in this.context.HSCV_CONGVIEC
join dokhan in this.context.DM_DANHMUC_DATA
on congviec.DOKHAN equals dokhan.ID
into group1
from g1 in group1.DefaultIfEmpty()
join douutien in this.context.DM_DANHMUC_DATA
on congviec.DOUU_TIEN equals douutien.ID
into group2
from g2 in group2.DefaultIfEmpty()
join xlchinh in this.context.DM_NGUOIDUNG
on congviec.NGUOIXULYCHINH_ID equals xlchinh.ID
into group3
from g3 in group3.DefaultIfEmpty()
join giaoviec in this.context.DM_NGUOIDUNG
on congviec.NGUOIGIAOVIEC_ID equals giaoviec.ID
into group4
from g4 in group4.DefaultIfEmpty()
join subtask in this.context.HSCV_CONGVIEC
on congviec.ID equals subtask.CONGVIECGOC_ID
into group5
from g5 in group5.DefaultIfEmpty()
select new CongViecBO
{
CONGVIECGOC_ID = congviec.CONGVIECGOC_ID,
DATUDANHGIA = congviec.DATUDANHGIA,
DayDiff = 0,
DOKHAN = congviec.DOKHAN,
DOUU_TIEN = congviec.DOUU_TIEN,
HAS_FILE = congviec.HAS_FILE,
HAS_NHACVIECDENHAN = congviec.HAS_NHACVIECDENHAN,
ID = congviec.ID,
IS_EMAIL = congviec.IS_EMAIL,
IS_HASPLAN = congviec.IS_HASPLAN,
IS_MESG = congviec.IS_MESG,
IS_MYJOB = congviec.IS_MYJOB,
IS_POPUP = congviec.IS_POPUP,
IS_SMS = congviec.IS_SMS,
IS_SUBTASK = congviec.IS_SUBTASK,
ITEMTYPE = congviec.ITEMTYPE,
ITEM_ID = congviec.ITEM_ID,
NGAY_NHANVIEC = congviec.NGAY_NHANVIEC,
NGAYHOANTHANH_THEOMONGMUON = congviec.NGAYHOANTHANH_THEOMONGMUON,
NGAYSUA = congviec.NGAYSUA,
NGAYTAO = congviec.NGAYTAO,
NGUOIGIAOVIECDANHGIA = congviec.NGUOIGIAOVIECDANHGIA,
NGUOIGIAOVIECDAPHANHOI = congviec.NGUOIGIAOVIECDAPHANHOI,
NGUOIGIAOVIEC_ID = congviec.NGUOIGIAOVIEC_ID,
NGUOITAO = congviec.NGUOITAO,
NGUOIXULYCHINH_ID = congviec.NGUOIXULYCHINH_ID,
NOIDUNGCONGVIEC = congviec.NOIDUNGCONGVIEC,
PHANTRAMHOANTHANH = congviec.PHANTRAMHOANTHANH,
PHANTRAMHOANTHANH_OLD = congviec.PHANTRAMHOANTHANH_OLD,
SONGAYNHACTRUOCHAN = congviec.SONGAYNHACTRUOCHAN,
SUBTASK_ID = congviec.SUBTASK_ID,
TENCONGVIEC = congviec.TENCONGVIEC,
TRANGTHAI_ID = congviec.TRANGTHAI_ID,
TEN_DOKHAN = g1.TEXT,
TEN_DOUUTIEN = g2.TEXT,
ICON_DOKHAN = g1.ICON,
ICON_DOUUTIEN = g2.ICON,
TEN_NGUOIGIAOVIEC = g4.HOTEN,
TEN_NGUOIXULYCHINH = g3.HOTEN,
IS_BATDAU = (true == congviec.IS_BATDAU),
HasChild = (g5 != null),
SONGAYCONLAI = (true == congviec.IS_HASPLAN && congviec.NGAYKETTHUC_KEHOACH.HasValue) ? EntityFunctions.DiffDays(DateTime.Now, congviec.NGAYKETTHUC_KEHOACH) : EntityFunctions.DiffDays(DateTime.Now, congviec.NGAYHOANTHANH_THEOMONGMUON)
};
if (searchModel != null)
{
#region Tim kiem
switch (searchModel.LOAI_CONGVIEC)
{
//Đối với công việc cá nhân
case LOAI_CONGVIEC.CANHAN:
//query = query.Where(x => searchModel.USER_ID == x.NGUOITAO || searchModel.USER_ID == x.NGUOIGIAOVIEC_ID);
query = query.Where(x => searchModel.USER_ID == x.NGUOIGIAOVIEC_ID);
break;
//Đối với công việc được giao
case LOAI_CONGVIEC.DUOCGIAO:
//query = query.Where(x => searchModel.USER_ID == x.NGUOIXULYCHINH_ID && true != x.IS_MYJOB);
query = query.Where(x => searchModel.USER_ID == x.NGUOIXULYCHINH_ID);
break;
//Đối với công việc được phối hợp xử lý
case LOAI_CONGVIEC.PHOIHOP_XULY:
var Ids = (from phoihop in this.context.HSCV_CONGVIEC_NGUOITHAMGIAXULY
where searchModel.USER_ID == phoihop.USER_ID
select phoihop.CONGVIEC_ID).ToList();
query = query.Where(x => Ids.Contains(x.ID));
break;
}
if (searchModel.DOKHAN.HasValue)
{
query = query.Where(x => searchModel.DOKHAN.Value == x.DOKHAN);
}
if (searchModel.DO_UUTIEN.HasValue)
{
query = query.Where(x => searchModel.DO_UUTIEN.Value == x.DOUU_TIEN);
}
if (searchModel.IS_HASPLAN.HasValue)
{
query = query.Where(x => searchModel.IS_HASPLAN.Value == x.IS_HASPLAN);
}
if (searchModel.NGAYBATDAU_FROM.HasValue)
{
query = query.Where(x => searchModel.NGAYBATDAU_FROM.Value <= x.NGAY_NHANVIEC);
}
if (searchModel.NGAYBATDAU_TO.HasValue)
{
query = query.Where(x => searchModel.NGAYBATDAU_TO.Value >= x.NGAY_NHANVIEC);
}
if (searchModel.NGAYKETTHUC_FROM.HasValue)
{
query = query.Where(x => searchModel.NGAYKETTHUC_FROM.Value <= x.NGAYHOANTHANH_THEOMONGMUON);
}
if (searchModel.NGAYKETTHUC_TO.HasValue)
{
query = query.Where(x => searchModel.NGAYKETTHUC_TO.Value >= x.NGAYHOANTHANH_THEOMONGMUON);
}
if (searchModel.NOTIF_TYPE.HasValue)
{
}
if (!string.IsNullOrEmpty(searchModel.TENCONGVIEC))
{
query = query.Where(x => x.TENCONGVIEC.ToLower().Contains(searchModel.TENCONGVIEC.ToLower()));
}
#endregion
query = query.GroupBy(x => x.ID).Select(y => y.FirstOrDefault());
if (!string.IsNullOrEmpty(searchModel.sortQuery))
{
query = query.OrderBy(searchModel.sortQuery);
}
else
{
query = query.OrderByDescending(x => x.NGAYTAO);
}
}
else
{
query = query.GroupBy(x => x.ID).Select(y => y.FirstOrDefault());
query = query.OrderByDescending(x => x.NGAYTAO);
}
var resultmodel = new PageListResultBO <CongViecBO>();
var dataPageList = query.ToPagedList(pageIndex, pageSize);
resultmodel.Count = dataPageList.TotalItemCount;
resultmodel.TotalPage = dataPageList.PageCount;
resultmodel.ListItem = dataPageList.ToList();
return(resultmodel);
}
public PageListResultBO <CongViecBO> GetListProcessedJob(HSCV_CONGVIEC_SEARCH searchModel, int pageSize = 20, int pageIndex = 1)
{
var query = from congviec in this.context.HSCV_CONGVIEC
join dokhan in this.context.DM_DANHMUC_DATA
on congviec.DOKHAN equals dokhan.ID
into group1
from g1 in group1.DefaultIfEmpty()
join douutien in this.context.DM_DANHMUC_DATA
on congviec.DOUU_TIEN equals douutien.ID
into group2
from g2 in group2.DefaultIfEmpty()
join xlchinh in this.context.DM_NGUOIDUNG
on congviec.NGUOIXULYCHINH_ID equals xlchinh.ID
into group3
from g3 in group3.DefaultIfEmpty()
join giaoviec in this.context.DM_NGUOIDUNG
on congviec.NGUOIGIAOVIEC_ID equals giaoviec.ID
into group4
from g4 in group4.DefaultIfEmpty()
select new CongViecBO
{
CONGVIECGOC_ID = congviec.CONGVIECGOC_ID,
DATUDANHGIA = congviec.DATUDANHGIA,
DayDiff = 0,
DOKHAN = congviec.DOKHAN,
DOUU_TIEN = congviec.DOUU_TIEN,
HAS_FILE = congviec.HAS_FILE,
HAS_NHACVIECDENHAN = congviec.HAS_NHACVIECDENHAN,
ID = congviec.ID,
IS_EMAIL = congviec.IS_EMAIL,
IS_HASPLAN = congviec.IS_HASPLAN,
IS_MESG = congviec.IS_MESG,
IS_MYJOB = congviec.IS_MYJOB,
IS_POPUP = congviec.IS_POPUP,
IS_SMS = congviec.IS_SMS,
IS_SUBTASK = congviec.IS_SUBTASK,
ITEMTYPE = congviec.ITEMTYPE,
ITEM_ID = congviec.ITEM_ID,
NGAY_NHANVIEC = congviec.NGAY_NHANVIEC,
NGAYHOANTHANH_THEOMONGMUON = congviec.NGAYHOANTHANH_THEOMONGMUON,
NGAYSUA = congviec.NGAYSUA,
NGAYTAO = congviec.NGAYTAO,
NGUOIGIAOVIECDANHGIA = congviec.NGUOIGIAOVIECDANHGIA,
NGUOIGIAOVIECDAPHANHOI = congviec.NGUOIGIAOVIECDAPHANHOI,
NGUOIGIAOVIEC_ID = congviec.NGUOIGIAOVIEC_ID,
NGUOITAO = congviec.NGUOITAO,
NGUOIXULYCHINH_ID = congviec.NGUOIXULYCHINH_ID,
NOIDUNGCONGVIEC = congviec.NOIDUNGCONGVIEC,
PHANTRAMHOANTHANH = congviec.PHANTRAMHOANTHANH,
PHANTRAMHOANTHANH_OLD = congviec.PHANTRAMHOANTHANH_OLD,
SONGAYNHACTRUOCHAN = congviec.SONGAYNHACTRUOCHAN,
SUBTASK_ID = congviec.SUBTASK_ID,
TENCONGVIEC = congviec.TENCONGVIEC,
TRANGTHAI_ID = congviec.TRANGTHAI_ID,
TEN_DOKHAN = g1.TEXT,
TEN_DOUUTIEN = g2.TEXT,
ICON_DOKHAN = g1.ICON,
ICON_DOUUTIEN = g2.ICON,
TEN_NGUOIGIAOVIEC = g4.HOTEN,
TEN_NGUOIXULYCHINH = g3.HOTEN
};
if (searchModel != null)
{
query = query.Where(x => searchModel.USER_ID == x.NGUOIGIAOVIEC_ID && x.TRANGTHAI_ID == 1);
if (searchModel.DOKHAN.HasValue)
{
query = query.Where(x => searchModel.DOKHAN.Value == x.DOKHAN);
}
if (searchModel.DO_UUTIEN.HasValue)
{
query = query.Where(x => searchModel.DO_UUTIEN.Value == x.DOUU_TIEN);
}
if (searchModel.IS_HASPLAN.HasValue)
{
query = query.Where(x => searchModel.IS_HASPLAN.Value == x.IS_HASPLAN);
}
if (searchModel.NGAYBATDAU_FROM.HasValue)
{
query = query.Where(x => searchModel.NGAYBATDAU_FROM.Value >= x.NGAY_NHANVIEC);
}
if (searchModel.NGAYBATDAU_TO.HasValue)
{
query = query.Where(x => searchModel.NGAYBATDAU_TO.Value <= x.NGAY_NHANVIEC);
}
if (searchModel.NGAYKETTHUC_FROM.HasValue)
{
query = query.Where(x => searchModel.NGAYKETTHUC_FROM.Value >= x.NGAYHOANTHANH_THEOMONGMUON);
}
if (searchModel.NGAYKETTHUC_TO.HasValue)
{
query = query.Where(x => searchModel.NGAYKETTHUC_TO.Value <= x.NGAYHOANTHANH_THEOMONGMUON);
}
if (searchModel.NOTIF_TYPE.HasValue)
{
}
if (!string.IsNullOrEmpty(searchModel.TENCONGVIEC))
{
query = query.Where(x => x.TENCONGVIEC.ToLower().Contains(searchModel.TENCONGVIEC.ToLower()));
}
if (!string.IsNullOrEmpty(searchModel.sortQuery))
{
query = query.OrderBy(searchModel.sortQuery);
}
else
{
query = query.OrderBy(x => x.TRANGTHAI_ID);
}
}
else
{
query = query.OrderBy(x => x.TRANGTHAI_ID);
}
var resultmodel = new PageListResultBO <CongViecBO>();
var dataPageList = query.ToPagedList(pageIndex, pageSize);
resultmodel.Count = dataPageList.TotalItemCount;
resultmodel.TotalPage = dataPageList.PageCount;
resultmodel.ListItem = dataPageList.ToList();
return(resultmodel);
}
