/*public List<SavedFreelancersVM> AllSkills() * { * List<SavedFreelancersVM> allSkills = new List<SavedFreelancersVM>(); * * var list = (from s in pg.skill * select new * { * s.name * }).ToList(); * foreach (var item in list) * { * SavedFreelancersVM objcvm = new SavedFreelancersVM(); * objcvm.Skillname = item.name; * allSkills.Add(objcvm); * } * return allSkills; * } * * public List<SavedFreelancersVM> AllExpertises() * { * List<SavedFreelancersVM> allExpertises = new List<SavedFreelancersVM>(); * * var list = (from e in pg.expertise * select new * { * e.name * }).ToList(); * foreach (var item in list) * { * SavedFreelancersVM objcvm = new SavedFreelancersVM(); * objcvm.Expertisename = item.name; * allExpertises.Add(objcvm); * } * return allExpertises; * } * * public List<SavedFreelancersVM> AllRanks() * { * List<SavedFreelancersVM> allRanks = new List<SavedFreelancersVM>(); * * var list = (from r in pg.rank_expertise * select new * { * r.rank_expertise_Id * }).ToList(); * foreach (var item in list) * { * SavedFreelancersVM objcvm = new SavedFreelancersVM(); * objcvm.ExpertiseRank = item.rank_expertise_Id; * allRanks.Add(objcvm); * } * return allRanks; * }*/ public List <Freelancer> SavedFreeID(int cusID) { ProjektGruppFEntities1 pgfe = new ProjektGruppFEntities1(); List <Freelancer> CusSavedFreeID = new List <Freelancer>(); var IdList = (from c_f in pgfe.customer_freelancer where c_f.customer_id == cusID select new { c_f.freelancer_id }).ToList(); foreach (var item in IdList) { Freelancer f = new Freelancer(); f.Freelancer_id = item.freelancer_id; CusSavedFreeID.Add(f); } return(CusSavedFreeID); }
public List <Freelancer> FreelancercardVMList() { ProjektGruppFEntities1 pgfe = new ProjektGruppFEntities1(); List <Freelancer> FreelancerCardList = new List <Freelancer>(); var cardlist = (from fl_table in pgfe.freelancer join cv_table in pgfe.cv on fl_table.cv_id equals cv_table.cv_id select new { fl_table.freelancer_id, fl_table.firstname, fl_table.lastname, cv_table.birthday, cv_table.nationality, cv_table.cv_id }).ToList(); foreach (var item in cardlist) { DateTime birthdate = item.birthday; int age = AgeConverter(birthdate); Freelancer fcVM = new Freelancer(); fcVM.Freelancer_id = item.freelancer_id; fcVM.Firstname = item.firstname; fcVM.Lastname = item.lastname; fcVM.Age = age; fcVM.Nationality = item.nationality; fcVM.Cv_id = item.cv_id; fcVM.SkillList = GetSkills(item.cv_id); fcVM.ExpertiseList = GetExpertiseList(item.cv_id); FreelancerCardList.Add(fcVM); } return(FreelancerCardList); }