コード例 #1
0
ファイル: JobRepository.cs プロジェクト: hvtienfithou997/CUNL
        public string Index(Job data, out string auto_id)
        {
            auto_id = "";
            int retry = 0;

            if (string.IsNullOrEmpty(data.id_auto))
            {
                string _auto_id = Nanoid.Nanoid.Generate("0123456789", max_id_job);

                while (IsAutoIdExist(_auto_id, data.app_id) && retry++ < 10)
                {
                    Task.Delay(TimeSpan.FromSeconds(1));
                    _auto_id = Nanoid.Nanoid.Generate("0123456789", max_id_job);
                }
                if (retry >= 10)
                {
                    return("");
                }
                data.id_auto = _auto_id;
            }
            else
            {
                while (IsIdAutoExist(data.id_auto, data.app_id) && retry++ < 10)
                {
                    Task.Delay(TimeSpan.FromSeconds(1));
                    data.id_auto = Nanoid.Nanoid.Generate("0123456789", max_id_job);
                }
                if (retry >= 10)
                {
                    return("");
                }
            }
            auto_id = data.id_auto;
            return(Index(_default_index, data));
        }
コード例 #2
0
ファイル: JobRepository.cs プロジェクト: hvtienfithou997/CUNL
        public bool Update(Job data)
        {
            string id = $"{data.id_job}";

            data.id_job   = string.Empty;
            data.ngay_sua = XMedia.XUtil.TimeInEpoch(DateTime.Now);
            data.auto_id  = -Int32.MaxValue;
            data.ngay_tao = -Int32.MaxValue;
            data.id_auto  = null;
            return(Update(_default_index, data, id));
        }
コード例 #3
0
ファイル: JobRepository.cs プロジェクト: hvtienfithou997/CUNL
        public Job GetByAutoID(string app_id, string id_auto)
        {
            var re = client.Search <Job>(s => s.Query(q => q.Term(t => t.Field("app_id.keyword").Value(app_id)) && !q.Term(t => t.Field("trang_thai").Value(TrangThai.DELETED)) &&
                                                      q.Term(t => t.Field("id_auto.keyword").Value(id_auto))
                                                      ).Size(1));

            if (re.Total > 0)
            {
                Job job = re.Hits.First().Source;
                job.id_job = re.Hits.First().Id;
                return(re.Documents.First());
            }
            return(null);
        }
コード例 #4
0
ファイル: JobRepository.cs プロジェクト: hvtienfithou997/CUNL
        private Job ConvertDoc(IHit <Job> hit)
        {
            Job u = new Job();

            try
            {
                u        = hit.Source;
                u.id_job = hit.Id;
            }
            catch
            {
            }
            return(u);
        }
コード例 #5
0
        public IActionResult Get(string id)
        {
            var user_job = QLCUNL.BL.UserJobBL.GetById(id);
            var job_user = BL.JobBL.GetMany(app_id, new List <string>()
            {
                user_job.id_job
            }, new string[] { "chuc_danh", "so_luong", "cong_ty" }).ToDictionary(x => x.id_job, y => y);

            Models.UserJobMap data = new Models.UserJobMap();
            data.id_user_job   = user_job.id_user_job;
            data.id_job        = user_job.id_job;
            data.ngay_nhan_job = user_job.ngay_nhan_job;

            var lst_id_thuoc_tinh = user_job.thuoc_tinh != null ? user_job.thuoc_tinh : new List <int>();
            var data_thuoc_tinh   = QLCUNL.BL.ThuocTinhBL.GetManyByGiaTri(app_id, lst_id_thuoc_tinh, LoaiThuocTinh.USER_JOB, ThuocTinhType.SHARED).ToDictionary(x => x.gia_tri, y => y);

            data.thuoc_tinh = user_job.thuoc_tinh;
            data.thuoc_tinh = user_job.thuoc_tinh != null?user_job.thuoc_tinh.Select(x => new
            {
                gia_tri = x,
                ten     = data_thuoc_tinh.ContainsKey(x) ? data_thuoc_tinh[x].ten : x.ToString(),
                nhom    = data_thuoc_tinh.ContainsKey(x) ? data_thuoc_tinh[x].nhom : 0
            }).ToArray() : new dynamic[]
            {
            };
            var cong_ty = new CongTy();
            var jd      = new Job();

            if (job_user.TryGetValue(user_job.id_job, out jd))
            {
                data.so_luong  = jd.so_luong;
                data.chuc_danh = jd.chuc_danh;
                cong_ty        = jd.cong_ty != null?CongTyBL.GetById(jd.cong_ty.id_cong_ty) : new CongTy();

                jd.cong_ty   = cong_ty;
                data.cong_ty = cong_ty.ten_cong_ty;
            }
            return(Ok(new { data = jd, extra = new { user_job.id_user, data.ngay_nhan_job, data.thuoc_tinh, user_job.nguoi_tao }, success = user_job != null, msg = "" }));
        }
コード例 #6
0
 public static bool Update(Job data)
 {
     return(JobRepository.Instance.Update(data));
 }
コード例 #7
0
 public static string Index(Job data, out string auto_id)
 {
     return(JobRepository.Instance.Index(data, out auto_id));
 }
コード例 #8
0
        public IActionResult MyJob(string id_job, string id_ung_vien, long ngay_nhan_job_from, long ngay_nhan_job_to, string thuoc_tinh, string thuoc_tinh_rieng,
                                   int page, int page_size)
        {
            List <int>               lst_thuoc_tinh       = new List <int>();
            List <int>               lst_thuoc_tinh_rieng = new List <int>();
            List <string>            lst_id = new List <string>();
            bool                     is_find_thuoc_tinh_rieng = false;
            List <UserJob>           data       = new List <UserJob>();
            List <Models.UserJobMap> lst        = new List <Models.UserJobMap>();
            long                     total_recs = 0;
            string                   msg        = "";

            if (!string.IsNullOrEmpty(thuoc_tinh))
            {
                foreach (var tt in thuoc_tinh.Split(','))
                {
                    int t = -1;
                    if (Int32.TryParse(tt, out t))
                    {
                        lst_thuoc_tinh.Add(t);
                    }
                }
            }
            if (!string.IsNullOrEmpty(thuoc_tinh_rieng))
            {
                foreach (var tt in thuoc_tinh_rieng.Split(','))
                {
                    int t = -1;
                    if (Int32.TryParse(tt, out t))
                    {
                        lst_thuoc_tinh_rieng.Add(t);
                    }
                }
                if (lst_thuoc_tinh_rieng.Count > 0)
                {
                    is_find_thuoc_tinh_rieng = true;
                    var lst_id_obj = BL.ThuocTinhDuLieuBL.Search(app_id, user, LoaiThuocTinh.CONG_TY, lst_thuoc_tinh_rieng, page, out long total_recs_thuoc_tinh, out _, 9999);
                    lst_id = lst_id_obj.Select(x => x.id_obj).ToList();
                }
            }
            if (is_find_thuoc_tinh_rieng && lst_id.Count == 0)
            {
            }
            else
            {
                data = QLCUNL.BL.UserJobBL.Search(app_id, user, group, new List <string>()
                {
                    id_job
                }, id_ung_vien, ngay_nhan_job_from, ngay_nhan_job_to, lst_thuoc_tinh, lst_id, page, out total_recs, out msg, page_size);
            }
            if (data.Count > 0)
            {
                var job_user = BL.JobBL.GetMany(app_id, data.Select(x => x.id_job), new string[] { "chuc_danh", "so_luong", "cong_ty" }).ToDictionary(x => x.id_job, y => y);

                foreach (var item in data)
                {
                    Models.UserJobMap m = new Models.UserJobMap();
                    m.id_user_job   = item.id_user_job;
                    m.id_job        = item.id_job;
                    m.ngay_nhan_job = item.ngay_nhan_job;
                    m.thuoc_tinh    = item.thuoc_tinh;
                    var jd = new Job();
                    if (job_user.TryGetValue(item.id_job, out jd))
                    {
                        m.so_luong  = jd.so_luong;
                        m.chuc_danh = jd.chuc_danh;
                        m.cong_ty   = jd.cong_ty.ten_cong_ty;
                        m.auto_id   = jd.auto_id;
                    }
                    lst.Add(m);
                }
            }
            return(Ok(new DataResponsePaging()
            {
                data = lst, total = total_recs, success = data != null, msg = msg
            }));
        }
コード例 #9
0
        public IActionResult Search(string term, string id_job, string id_ung_vien, long ngay_nhan_job_from, long ngay_nhan_job_to, string thuoc_tinh, string thuoc_tinh_rieng,
                                    int page, int page_size)
        {
            List <int>               lst_thuoc_tinh       = new List <int>();
            List <int>               lst_thuoc_tinh_rieng = new List <int>();
            List <string>            lst_id     = new List <string>();
            List <string>            lst_id_job = new List <string>();
            bool                     is_find_thuoc_tinh_rieng = false;
            List <UserJob>           data = new List <UserJob>();
            List <string>            lst_id_job_filter = new List <string>();
            List <Models.UserJobMap> lst        = new List <Models.UserJobMap>();
            long                     total_recs = 0;
            string                   msg        = "";

            if (!string.IsNullOrEmpty(thuoc_tinh))
            {
                foreach (var tt in thuoc_tinh.Split(','))
                {
                    int t = -1;
                    if (Int32.TryParse(tt, out t))
                    {
                        lst_thuoc_tinh.Add(t);
                    }
                }
            }
            if (!string.IsNullOrEmpty(thuoc_tinh_rieng))
            {
                foreach (var tt in thuoc_tinh_rieng.Split(','))
                {
                    int t = -1;
                    if (Int32.TryParse(tt, out t))
                    {
                        lst_thuoc_tinh_rieng.Add(t);
                    }
                }
                if (lst_thuoc_tinh_rieng.Count > 0)
                {
                    is_find_thuoc_tinh_rieng = true;
                    var lst_id_obj = BL.ThuocTinhDuLieuBL.Search(app_id, user, LoaiThuocTinh.CONG_TY, lst_thuoc_tinh_rieng, page, out long total_recs_thuoc_tinh, out _, 9999);
                    lst_id = lst_id_obj.Select(x => x.id_obj).ToList();
                }
            }
            if (!string.IsNullOrEmpty(term))
            {
                var data_job_by_term = QLCUNL.BL.JobBL.Search(app_id, user, group, term, string.Empty, string.Empty, 0, 0, 0, 0, new List <int>(), new List <string>(), new List <string>(), 0, 0, 1, out _, out _, 200, (is_sys_admin || is_app_admin), new string[] { "id_job" });
                lst_id_job = data_job_by_term.Select(x => x.id_job).ToList();
            }
            if (!string.IsNullOrEmpty(id_job))
            {
                lst_id_job.Add(id_job);
            }
            if (is_find_thuoc_tinh_rieng && lst_id.Count == 0)
            {
            }
            else
            {
                data = QLCUNL.BL.UserJobBL.Search(app_id, user, group, lst_id_job, id_ung_vien, ngay_nhan_job_from, ngay_nhan_job_to, lst_thuoc_tinh, lst_id, page, out total_recs, out msg, page_size, (is_sys_admin || is_app_admin));
            }

            if (data.Count > 0)
            {
                var lst_id_thuoc_tinh = data.Where(x => x.thuoc_tinh != null).SelectMany(x => x.thuoc_tinh);
                var data_thuoc_tinh   = QLCUNL.BL.ThuocTinhBL.GetManyByGiaTri(app_id, lst_id_thuoc_tinh, LoaiThuocTinh.USER_JOB, ThuocTinhType.SHARED).ToDictionary(x => x.gia_tri, y => y);

                var job_user = BL.JobBL.GetMany(app_id, data.Select(x => x.id_job), new string[] { "chuc_danh", "so_luong", "cong_ty" }).ToDictionary(x => x.id_job, y => y);

                var cong_ty = BL.CongTyBL.GetMany(job_user.Where(x => x.Value.cong_ty != null).Select(x => x.Value.cong_ty.id_cong_ty).Distinct()).ToDictionary(x => x.id_cong_ty, y => y.ten_cong_ty);

                foreach (var item in data)
                {
                    Models.UserJobMap m = new Models.UserJobMap();

                    m.id_user_job   = item.id_user_job;
                    m.id_job        = item.id_job;
                    m.ngay_nhan_job = item.ngay_nhan_job;
                    m.thuoc_tinh    = item.thuoc_tinh != null?item.thuoc_tinh.Select(x => new
                    {
                        gia_tri = x,
                        ten     = data_thuoc_tinh.ContainsKey(x) ? data_thuoc_tinh[x].ten : x.ToString(),
                        nhom    = data_thuoc_tinh.ContainsKey(x) ? data_thuoc_tinh[x].nhom : 0
                    }).ToArray() : new dynamic[]
                    {
                    };
                    var jd = new Job();
                    if (job_user.TryGetValue(item.id_job, out jd))
                    {
                        m.so_luong  = jd.so_luong;
                        m.chuc_danh = jd.chuc_danh;
                        if (jd.cong_ty != null)
                        {
                            if (cong_ty.TryGetValue(jd.cong_ty.id_cong_ty, out string ten_cong_ty))
                            {
                                m.cong_ty = ten_cong_ty;
                            }
                        }
                        m.auto_id = jd.auto_id;
                    }
                    lst.Add(m);
                }
            }
            return(Ok(new DataResponsePaging()
            {
                data = lst, total = total_recs, success = data != null, msg = msg
            }));
        }