public string AddAssociateDetails(AssociateModel associateDetails) { AssociateDAO associateDAO = new AssociateDAO(); Associate associate = new Associate { Associate_ID = associateDetails.AssociateId, Name = associateDetails.Name, Email = associateDetails.Email, Mobile = associateDetails.Mobile, Pic = associateDetails.Pic, Status = associateDetails.Status, Level = associateDetails.Level, Remark = associateDetails.Remark, OtherSkills = associateDetails.OtherSkills, Weekness = associateDetails.Weekness, Strength = associateDetails.Strength, AssociateSkillsList = associateDetails.AssociateSkills .Select(x => new AssociateSkills { Associate_ID = associateDetails.AssociateId, Associate_Skills_ID = x.AssociateSkillsId, Associate_Details_ID = associateDetails.AssociateDetailsId, Skill_ID = x.SkillId, Skill_Rate = x.SkillRate, }).ToList() }; associateDAO.AddAssociate(associate); //if (associateDAO.AddAssociate(associate) && associateDetails.AssociateSkills != null && associateDetails.AssociateSkills.Count > 0) //{ // AssociateSkillsDAO associateSkillsDAO = new AssociateSkillsDAO(); // associateSkillsDAO.AddAssociateSkills(associateDetails.AssociateSkills.Select(x => new AssociateSkills { Associate_ID = associate.Associate_ID, Skill_ID = x.SkillId, Skill_Rate = x.SkillRate }).ToList()); //} return("Associate details added successfully"); }
public AssociateModel GetAssociateByID(string associateId) { AssociateDAO associateDAO = new AssociateDAO(); Associate associate = associateDAO.GetAssociateByID(associateId); AssociateSkillsDAO associateSkillsDAO = new AssociateSkillsDAO(); //List<AssociateSkillsModel> associateSkillsList = associateSkillsDAO.GetAssociateSkillsByID(associateId) // .Select(x=> new AssociateSkillsModel { AssociateSkillsId = x.Associate_Skills_ID, SkillId = x.Skill_ID, SkillRate = x.Skill_Rate}).ToList(); return(new AssociateModel { AssociateDetailsId = associate.Associate_Details_ID, AssociateId = associate.Associate_ID, Name = associate.Name, Email = associate.Email, Mobile = associate.Mobile, Pic = associate.Pic, Status = associate.Status, Level = associate.Level, Remark = associate.Remark, OtherSkills = associate.OtherSkills, Weekness = associate.Weekness, Strength = associate.Strength, AssociateSkills = associate.AssociateSkillsList .Select(x => new AssociateSkillsModel { AssociateSkillsId = x.Associate_Skills_ID, SkillRate = x.Skill_Rate, SkillId = x.Associate_Skills.Skill_ID, SkillName = x.Associate_Skills.Skill_Name }).ToList() }); }
public List <AssociateModel> GetAllAssociates() { List <AssociateModel> associateModelList = new List <AssociateModel>(); AssociateDAO associateDAO = new AssociateDAO(); //associateModelList = return(associateDAO.GetAllAssociates() .Select(x => new AssociateModel { AssociateDetailsId = x.Associate_Details_ID, AssociateId = x.Associate_ID, Name = x.Name, Email = x.Email, Mobile = x.Mobile, Pic = x.Pic, Status = x.Status, Level = x.Level, Remark = x.Remark, OtherSkills = x.OtherSkills, Weekness = x.Weekness, Strength = x.Strength, AssociateSkills = x.AssociateSkillsList .Select(y => new AssociateSkillsModel { AssociateSkillsId = y.Associate_Skills_ID, SkillRate = y.Skill_Rate, SkillId = y.Associate_Skills.Skill_ID, SkillName = y.Associate_Skills.Skill_Name }).ToList() }).ToList()); //List<AssociateSkillsModel> associateSkillsModelList = null; //AssociateSkillsDAO associateSkillsDAO = new AssociateSkillsDAO(); //foreach (AssociateModel associateModel in associateModelList) //{ // associateSkillsModelList = associateSkillsDAO.GetAssociateSkillsByID(associateModel.AssociateId) // .Select(x => new AssociateSkillsModel // { // AssociateSkillsId = x.Associate_Skills_ID, // SkillId = x.Skill_ID, // SkillRate = x.Skill_Rate // }).ToList(); // associateModel.AssociateSkills = associateSkillsModelList; //} //return associateModelList; }