public AssociateVM GetById(int Id) { try { AssociateVM result = new AssociateVM(); foreach (var item in db.Associates.Where(a => a.Id == Id).ToList()) { List <AssociateSkillVM> associateskills = new List <AssociateSkillVM>(); associateskills = (from t1 in db.Associate_Skills join t2 in db.Skills on t1.Skill_ID equals t2.SkillId where t1.Associate_ID == item.Id select new AssociateSkillVM { Associate_ID = t1.Associate_ID, Id = t1.Id, Rating = t1.Rating, SkillName = t2.SkillName, Skill_ID = t1.Skill_ID }).ToList(); string strongSkills = String.Join(",", associateskills.Where(a => a.Rating >= 15).Select(a => a.SkillName)); result = new AssociateVM() { Id = item.Id, Associate_ID = item.Associate_ID, Name = item.Name, Gender = item.Gender, Email = item.Email, Level_1 = item.Level_1, Level_2 = item.Level_2, Level_3 = item.Level_3, Mobile = item.Mobile, Pic = item.Pic, Remark = item.Remark, Status_Blue = item.Status_Blue, Status_Green = item.Status_Green, Status_Red = item.Status_Red, Strength = item.Strength, Weakness = item.Weakness, Skills = associateskills, StrongSkills = strongSkills }; } return(result); } catch (Exception ex) { return(new AssociateVM()); } }
public IHttpActionResult Post(HttpRequestMessage jsonData) { try { AssociateVM associate = JsonConvert.DeserializeObject <AssociateVM>(jsonData.Content.ReadAsStringAsync().Result); if (dao.Add(associate)) { return(Ok("Record Created Successfully")); } else { return(BadRequest("Record Created Successfully")); } } catch (Exception ex) { return(BadRequest("Error Occurred")); } }
public bool Add(AssociateVM model) { try { if (model.Id > 0) { Associate editAssociate = db.Associates.Find(model.Id); db.Entry(editAssociate).CurrentValues.SetValues(model); db.SaveChanges(); if (db.Associate_Skills.Any(a => a.Associate_ID == model.Id)) { db.Associate_Skills.RemoveRange(db.Associate_Skills.Where(a => a.Associate_ID == model.Id).ToList()); db.SaveChanges(); } foreach (AssociateSkillVM data in model.Skills) { db.Associate_Skills.Add(new Associate_Skill { Skill_ID = data.Skill_ID, Associate_ID = model.Id, Rating = data.Rating, Created = DateTime.Now }); db.SaveChanges(); } } else { Associate associate = new Associate() { Associate_ID = model.Associate_ID, Name = model.Name, Gender = model.Gender, Email = model.Email, Level_1 = model.Level_1, Level_2 = model.Level_2, Level_3 = model.Level_3, Mobile = model.Mobile, Pic = model.Pic, Remark = model.Remark, Status_Blue = model.Status_Blue, Status_Green = model.Status_Green, Status_Red = model.Status_Red, Strength = model.Strength, Weakness = model.Weakness, Created = DateTime.Now }; db.Associates.Add(associate); db.SaveChanges(); foreach (AssociateSkillVM data in model.Skills) { db.Associate_Skills.Add(new Associate_Skill { Skill_ID = data.Skill_ID, Associate_ID = associate.Id, Rating = data.Rating, Created = DateTime.Now }); db.SaveChanges(); } } return(true); } catch (Exception ex) { return(false); } }