コード例 #1
0
        /// <summary>
        /// Get worker catalog list.
        /// </summary>
        /// <param name="userId">User Id.</param>
        /// <returns>List WorkerEntity</returns>
        public static List <PartnerCatalogEntity> GetWorkerList(AloaiDataContext db, decimal userId)
        {
            List <PartnerCatalogEntity> workerEntityList = new List <PartnerCatalogEntity>();

            var user = from d in db.M_USERS
                       where d.USER_ID == userId
                       select d;

            if (!user.Any())
            {
                return(workerEntityList);
            }

            var query3 = from d in db.V_PARTNERS
                         where d.USER_ID == userId
                         select d;

            if (query3.Any())
            {
                foreach (V_PARTNER worker in query3.ToList())
                {
                    PartnerCatalogEntity wkEntity = new PartnerCatalogEntity();
                    wkEntity.userId = worker.USER_ID;

                    Catalog catalog = new Catalog();
                    catalog.catalogCd = worker.CATALOG_CD;
                    wkEntity.cost     = worker.COST;

                    Unit unit = new Unit();
                    unit.unitCd = worker.UNIT_CD;

                    string languageType = user.Single().LANGUAGE_TYPE;

                    if (string.IsNullOrEmpty(languageType) || languageType.Equals(Constant.LANGUAGE_VN))
                    {
                        catalog.catalogName = worker.CATALOG_NAME;
                        unit.unitName       = worker.UNIT_NAME;
                    }
                    else
                    {
                        catalog.catalogName = worker.CATALOG_NAME_EN;
                        unit.unitName       = worker.UNIT_NAME_EN;
                    }

                    wkEntity.catalog = catalog;
                    wkEntity.unit    = unit;
                    workerEntityList.Add(wkEntity);
                }
            }

            return(workerEntityList);
        }
コード例 #2
0
        public ActionResult GetFavouriteList([FromRoute] decimal id, [FromRoute] int detailNum)
        {
            var query = (from d in _context.V_FAVOURITES
                         where d.USER_ID == id &&
                         d.MODE_USER == (int)Mode.Hirer
                         orderby d.REG_DATETIME descending
                         select d).Take(detailNum);

            if (!query.Any())
            {
                return(Ok(new Result
                {
                    Status = 404,
                    Message = "Not found",
                    Data = false
                }));
            }

            List <V_FAVOURITE>     favouriteList = query.ToList();
            List <FavouriteEntity> entityList    = new List <FavouriteEntity>();
            decimal favouriteUserId = 0;

            foreach (V_FAVOURITE favourite in favouriteList)
            {
                if (favouriteUserId == favourite.FAVOURITE_USER_ID)
                {
                    continue;
                }

                favouriteUserId = favourite.FAVOURITE_USER_ID;

                FavouriteEntity entity = new FavouriteEntity();
                entity.favouriteId     = favourite.FAVOURITE_ID;
                entity.userId          = favourite.USER_ID;
                entity.favouriteUserId = favourite.FAVOURITE_USER_ID;
                entity.name            = favourite.NAME;
                //entity.Sex = favourite.SEX;
                entity.avatar      = favourite.AVATAR;
                entity.introduce   = favourite.INTRODUCE;
                entity.modeDefault = favourite.MODE_DEFAULT;
                //entity.AccountType = favourite.ACCOUNT_TYPE;
                //entity.MemberType = favourite.MEMBER_TYPE;
                entity.modeUser = favourite.MODE_USER;
                Catalog catalog = new Catalog();
                catalog.catalogCd   = favourite.CATALOG_CD;
                catalog.catalogName = favourite.CATALOG_NAME;
                entity.catalog      = catalog;

                entity.cost = favourite.COST;

                Unit unit = new Unit();
                unit.unitCd          = favourite.UNIT_CD;
                unit.unitName        = favourite.UNIT_NAME;
                entity.unit          = unit;
                entity.score         = favourite.SCORE.Value;
                entity.likeNumber    = favourite.LIKE_NUM.GetValueOrDefault(0);
                entity.favouriteFlag = 1;

                var query3 = from d in _context.V_PARTNERS
                             where d.USER_ID == favourite.FAVOURITE_USER_ID
                             select d;

                PartnerCatalogEntity workerEntity = new PartnerCatalogEntity();

                var user = from d in _context.M_USERS
                           where d.USER_ID == favourite.FAVOURITE_USER_ID
                           select d;

                if (query3.Any())
                {
                    foreach (V_PARTNER worker in query3.ToList())
                    {
                        workerEntity.userId = worker.USER_ID;

                        Catalog catalog2 = new Catalog();
                        catalog2.catalogCd = worker.CATALOG_CD;
                        workerEntity.cost  = worker.COST;

                        Unit unit2 = new Unit();
                        unit2.unitCd = worker.UNIT_CD;

                        string languageType = user.Single().LANGUAGE_TYPE;

                        if (string.IsNullOrEmpty(languageType) || languageType.Equals(Constant.LANGUAGE_VN))
                        {
                            catalog2.catalogName = worker.CATALOG_NAME;
                            unit2.unitName       = worker.UNIT_NAME;
                        }
                        else
                        {
                            catalog2.catalogName = worker.CATALOG_NAME_EN;
                            unit2.unitName       = worker.UNIT_NAME_EN;
                        }

                        workerEntity.catalog = catalog2;
                        workerEntity.unit    = unit2;
                        break;
                    }
                }

                entity.partnerCatalog = workerEntity;
                entityList.Add(entity);
            }

            return(Ok(new Result
            {
                Status = 200,
                Message = string.Empty,
                Data = entityList
            }));
        }