// GET: /RequirementSkillSet/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(RedirectToAction("BadRequest", "Error"));
            }
            RequirementSkillSet requirementskillset = db.RequirementSkillSets.Find(id);

            if (requirementskillset == null)
            {
                return(RedirectToAction("NotFound", "Error"));
            }
            return(View(requirementskillset));
        }
 public ActionResult DeleteConfirmed(int id)
 {
     try
     {
         RequirementSkillSet requirementskillset = db.RequirementSkillSets.Find(id);
         db.RequirementSkillSets.Remove(requirementskillset);
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     catch (Exception exp)
     {
         Logger.LogException(exp);
         return(RedirectToAction("AppError", "Error"));
     }
 }
        // GET: /RequirementSkillSet/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(RedirectToAction("BadRequest", "Error"));
            }
            RequirementSkillSet requirementskillset = db.RequirementSkillSets.Find(id);

            if (requirementskillset == null)
            {
                return(RedirectToAction("NotFound", "Error"));
            }
            ViewBag.RequirementId = new SelectList(db.Requirements, "RequirementId", "JobNumber", requirementskillset.RequirementId);
            ViewBag.SkillSetId    = new SelectList(db.SkillSets, "SkillSetId", "Name", requirementskillset.SkillSetId);
            return(View(requirementskillset));
        }
 public ActionResult DeleteSkillSet(int id)
 {
     try
     {
         RequirementSkillSet skillset = db.RequirementSkillSets.Find(id);
         if (skillset != null)
         {
             db.RequirementSkillSets.Remove(skillset);
             db.SaveChanges();
             return(RedirectToAction("Edit", new { id = skillset.RequirementId }));
         }
         return(View(Response));
     }
     catch (Exception exp)
     {
         Logger.LogException(exp);
         return(RedirectToAction("AppError", "Error"));
     }
 }
 public ActionResult Edit([Bind(Include = "RequirementSkillSetId,RequirementId,SkillSetId,IsMandatory")] RequirementSkillSet requirementskillset)
 {
     try
     {
         if (ModelState.IsValid)
         {
             db.Entry(requirementskillset).State = EntityState.Modified;
             db.SaveChanges();
             return(RedirectToAction("Index"));
         }
         ViewBag.RequirementId = new SelectList(db.Requirements, "RequirementId", "JobNumber", requirementskillset.RequirementId);
         ViewBag.SkillSetId    = new SelectList(db.SkillSets, "SkillSetId", "Name", requirementskillset.SkillSetId);
         return(View(requirementskillset));
     }
     catch (Exception exp)
     {
         Logger.LogException(exp);
         return(RedirectToAction("AppError", "Error"));
     }
 }
 private void AddSkillSet(string SelectedSkillSetCSV, string MandatorySkillSetCSV, Requirement requirement)
 {
     if (SelectedSkillSetCSV.Length > 0)
     {
         if (requirement.RequirementId != 0)
         {
             db.Entry(requirement).Collection(r => r.RequirementSkillSets).Load();
             foreach (RequirementSkillSet skillset in requirement.RequirementSkillSets)
             {
                 skillset.IsMandatory      = MandatorySkillSetCSV.IndexOf("," + skillset.SkillSetId + ",") >= 0 ? true : false;
                 skillset.UpdatedBy        = User.Identity.GetUserId();
                 skillset.UpdatedTimestamp = DateTime.Now;
             }
         }
         if (requirement.RequirementSkillSets == null)
         {
             requirement.RequirementSkillSets = new List <RequirementSkillSet>();
         }
         RequirementSkillSet reqskillset = null;
         string[]            skillsets   = SelectedSkillSetCSV.Split(",".ToCharArray());
         foreach (string skillset in skillsets)
         {
             if (skillset.Length > 0)
             {
                 reqskillset = new RequirementSkillSet()
                 {
                     SkillSetId       = int.Parse(skillset),
                     IsMandatory      = MandatorySkillSetCSV.IndexOf("," + skillset + ",") >= 0 ? true : false,
                     CreatedBy        = User.Identity.GetUserId(),
                     CreatedTimestamp = DateTime.Now
                 };
                 requirement.RequirementSkillSets.Add(reqskillset);
             }
         }
     }
 }