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