public async void UpdateEmployeeSkill_Put_Adjusted_Value_Of_EmployeeSkill_Already_Added()
        {
            var query = new EmployeeSkillsController(context);

            var newEmployeeSkill = new EmployeeSkills {
                Id = 9, SkillsId = 1, Experience = 2, UserId = "a1"
            };

            // https://stackoverflow.com/questions/36856073/the-instance-of-entity-type-cannot-be-tracked-because-another-instance-of-this-t/42475617
            var local = context.EmployeeSkills.Local.Where(t => t.Id == 9).FirstOrDefault();

            if (local != null)
            {
                context.Entry(local).State = EntityState.Detached;            // only needed for xUnit testing
            }
            var result = await query.PutEmployeeSkills(9, newEmployeeSkill);  // async

            var added = await query.GetEmployeeSkillById(9);                  // async

            Assert.NotEqual(newEmployeeSkill.SkillsId, added.Value.SkillsId); // skill already in db therefore cannot update
            Assert.Equal(7, added.Value.SkillsId);                            // what is was before trying to update
            var badRequestResult = Assert.IsType <BadRequestObjectResult>(result);

            Assert.Contains("already added to this employee", badRequestResult.Value.ToString());
            Assert.Equal(400, badRequestResult.StatusCode);
            Assert.IsType <BadRequestObjectResult>(result);
        }
Example #2
0
        public JsonResult Edit(EmployeeSkills skills)
        {
            MTSHRDataLayer.EmployeeSkills data_skills = new MTSHRDataLayer.EmployeeSkills();
            string SkillList = string.Join(",", skills.Skill);
            var    result    = data_skills.UpdateSkills(skills.Employee_Id, SkillList, skills.Certificationname);

            return(Json(new { success = result }, JsonRequestBehavior.AllowGet));
        }
Example #3
0
        public ActionResult DeleteConfirmed(int?EmployeeID, int?SkillID)
        {
            EmployeeSkills employeeSkills = _EmployeeSkillsRepository.GetEmployeeSkillByID(EmployeeID, SkillID);

            _EmployeeSkillsRepository.EmployeeSkillDelete(EmployeeID, SkillID);
            _EmployeeSkillsRepository.Save();
            return(RedirectToAction("Index"));
        }
Example #4
0
        public ActionResult DeleteConfirmed(int id)
        {
            EmployeeSkills employeeskills = db.EmployeeSkill.Find(id);

            db.EmployeeSkill.Remove(employeeskills);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Example #5
0
 public void UpdateEmployeeSkill(EmployeeSkills EmployeeSkills)
 {
     if (EmployeeSkills != null)
     {
         _context.Entry(EmployeeSkills).State = EntityState.Modified;
         _context.SaveChanges();
     }
 }
Example #6
0
        //
        // GET: /EmployeeSkills/Delete/5

        public ActionResult Delete(int id = 0)
        {
            EmployeeSkills employeeskills = db.EmployeeSkill.Find(id);

            if (employeeskills == null)
            {
                return(HttpNotFound());
            }
            return(View(employeeskills));
        }
        public void UpdateEmployeeSkill(EmployeeSkills EmployeeSkil)
        {
            if (!ModelState.IsValid)
            {
                throw new HttpResponseException(HttpStatusCode.BadRequest);
            }

            _EmployeeSkillsRepository.UpdateEmployeeSkill(EmployeeSkil);
            _EmployeeSkillsRepository.Save();
        }
        public EmployeeSkills CreateEmployeeSkill(EmployeeSkills EmployeeSkill)
        {
            if (!ModelState.IsValid)
            {
                throw new HttpResponseException(HttpStatusCode.BadRequest);
            }

            _EmployeeSkillsRepository.InsertEmployeeSkill(EmployeeSkill);
            _EmployeeSkillsRepository.Save();
            return(EmployeeSkill);
        }
Example #9
0
 public ActionResult Edit(EmployeeSkills employeeskills)
 {
     if (ModelState.IsValid)
     {
         db.Entry(employeeskills).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.EmpId   = new SelectList(db.Employees, "EmpId", "Name", employeeskills.EmpId);
     ViewBag.SkillId = new SelectList(db.Skill, "SkillId", "Name", employeeskills.SkillId);
     return(View(employeeskills));
 }
Example #10
0
 public void EmployeeSkillDelete(int?EmployeeId, int?SkillID)
 {
     try
     {
         EmployeeSkills employeeSkills = _context.EmployeeSkills.SingleOrDefault(c => c.EmployeeID == EmployeeId && c.SkillID == SkillID);
         _context.EmployeeSkills.Remove(employeeSkills);
     }
     catch (Exception)
     {
         throw;
     }
 }
Example #11
0
 public ActionResult Edit([Bind(Include = "EmployeeID,SkillID,SkillLevel,ModofiedDate")] EmployeeSkills employeeSkills)
 {
     if (ModelState.IsValid)
     {
         _EmployeeSkillsRepository.UpdateEmployeeSkill(employeeSkills);
         _EmployeeSkillsRepository.Save();
         return(RedirectToAction("Index"));
     }
     ViewBag.EmployeeID = new SelectList(_EmployeeRepository.GetListofEmployees(), "EmployeeID", "Name", employeeSkills.EmployeeID);
     ViewBag.SkillID    = new SelectList(_SkillRepository.GetListOfSkills(), "SkillID", "Description", employeeSkills.SkillID);
     return(View(employeeSkills));
 }
Example #12
0
        //
        // GET: /EmployeeSkills/Edit/5

        public ActionResult Edit(int id = 0)
        {
            EmployeeSkills employeeskills = db.EmployeeSkill.Find(id);

            if (employeeskills == null)
            {
                return(HttpNotFound());
            }
            ViewBag.EmpId   = new SelectList(db.Employees, "EmpId", "Name", employeeskills.EmpId);
            ViewBag.SkillId = new SelectList(db.Skill, "SkillId", "Name", employeeskills.SkillId);
            return(View(employeeskills));
        }
        public async void PostEmployeeSkill_Returns_OK()
        {
            var query = new EmployeeSkillsController(context);

            var newEmployeeSkill = new EmployeeSkills {
                Id = 10, SkillsId = 2, Experience = 3, UserId = "a3"
            };

            var result = await query.PostEmployeeSkills(newEmployeeSkill);  // async

            Assert.IsType <ActionResult <EmployeeSkills> >(result);
            Assert.IsType <CreatedAtActionResult>(result.Result);
        }
Example #14
0
        public ActionResult Create(EmployeeSkills employeeskills)
        {
            if (ModelState.IsValid)
            {
                db.EmployeeSkill.Add(employeeskills);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.EmpId   = new SelectList(db.Employees, "EmpId", "Name", employeeskills.EmpId);
            ViewBag.SkillId = new SelectList(db.Skill, "SkillId", "Name", employeeskills.SkillId);
            return(View(employeeskills));
        }
        private async Task RemoveSkillFromEmployee(Skill skill)
        {
            try
            {
                await _employeesService.RemoveSkillFromEmployeeAsync(_currentEmployeeID, skill.ID);

                EmployeeSkills.Remove(skill);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
                await _userDialogs.AlertAsync(ex.Message, "Error");
            }
        }
Example #16
0
        public ActionResult Delete(int?EmployeeID, int?SkillID)
        {
            if (EmployeeID == null || SkillID == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            EmployeeSkills employeeSkills = _EmployeeSkillsRepository.GetEmployeeSkillByID(EmployeeID, SkillID);

            if (employeeSkills == null)
            {
                return(HttpNotFound());
            }
            return(View(employeeSkills));
        }
Example #17
0
 public void InsertEmployeeSkill(EmployeeSkills EmployeeSkills)
 {
     try
     {
         if (EmployeeSkills != null)
         {
             _context.EmployeeSkills.Add(EmployeeSkills);
             _context.SaveChanges();
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
Example #18
0
        public async void GetData()
        {
            if (string.IsNullOrEmpty(Settings.AccessToken) || string.IsNullOrWhiteSpace(Settings.AccessToken))
            {
                return;
            }
            try
            {
                Basicinfos = EmployeeProfileHelper.EmployeeCurrentProfile;
                var yearstemp = Basicinfos.YearsOfExperience.ToString();
                if (yearstemp != null)
                {
                    Enteryearsofexperience = Basicinfos.YearsOfExperience.ToString();
                }


                //TODO : Overide the null values


                if (Basicinfos == null)
                {
                    return;
                }
                ObservableCollection <SkillsModel> CastList = new ObservableCollection <SkillsModel>(Basicinfos.EmployeeSkills);
                SelectedJobTypeId = EmployeeProfileHelper.EmployeeCurrentProfile.JobTypeId;
                SkillsListView    = CastList;

                if (!EmployeeSkills.Any())
                {
                    if (check == null)
                    {
                        EmployeeSkills = CastList;
                        check          = false;
                    }
                    else
                    {
                        return;
                    }
                }
                Enteryearsofexperience = Basicinfos.YearsOfExperience.ToString();
                ShowName = Basicinfos.CoverLetter;
            }
            catch (Exception ex)
            {
                var logged = new LoggedException.LoggedException("Error in registerviewmodel", ex);
                await logged.LoggAPI();
            }
        }
Example #19
0
        public async Task <ActionResult <EmployeeSkills> > PostEmployeeSkills(EmployeeSkills employeeSkills)
        {
            var e = await _context.EmployeeSkills
                    .Include(s => s.Skills)
                    .FirstOrDefaultAsync(x => x.SkillsId == employeeSkills.SkillsId && x.UserId == employeeSkills.UserId);

            if (e != null)
            {
                return(BadRequest("Skill of " + e.Skills.Name + " already added to this employee."));
            }

            _context.EmployeeSkills.Add(employeeSkills);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetEmployeeSkills", new { id = employeeSkills.Id }, employeeSkills));
        }
Example #20
0
        public ActionResult Edit(int?EmployeeID, int?SkillID)
        {
            if (EmployeeID == null || SkillID == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            EmployeeSkills employeeSkills = _EmployeeSkillsRepository.GetEmployeeSkillByID(EmployeeID, SkillID);

            if (employeeSkills == null)
            {
                return(HttpNotFound());
            }
            ViewBag.EmployeeID = new SelectList(_EmployeeRepository.GetListofEmployees(), "EmployeeID", "Name", employeeSkills.EmployeeID);
            ViewBag.SkillID    = new SelectList(_SkillRepository.GetListOfSkills(), "SkillID", "Description", employeeSkills.SkillID);
            return(View(employeeSkills));
        }
        private async Task AddSkillToEmployee(Guid skillID)
        {
            var selectedSkill = _skillCache.FirstOrDefault(s => s.ID == skillID) ??
                                throw new InvalidOperationException($"Skill {skillID} Does not exist");

            try
            {
                await _employeesService.AddSkillToEmployeeAsync(_currentEmployeeID, selectedSkill);

                EmployeeSkills.Add(selectedSkill);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
                await _userDialogs.AlertAsync(ex.Message, "Error");
            }
        }
        public async void UpdateEmployeeSkill_Put()
        {
            var query = new EmployeeSkillsController(context);

            var newEmployeeSkill = new EmployeeSkills {
                Id = 9, SkillsId = 7, Experience = 1, UserId = "a1"
            };

            var newEmployeeSkillToReturn = new EmployeeSkillsToReturn
            {
                Id         = 9,
                SkillsId   = 7,
                Experience = 1,
                UserId     = "a1",
                Skills     = new Skills {
                    Id = 7, Name = "ASP.NET Core", Type = 2
                },
                UserInfo = new UserInfo {
                    Id = "a1", UserName = "******", FirstName = "Sarah", LastName = "West", Email = "*****@*****.**"
                }
            };

            // https://stackoverflow.com/questions/36856073/the-instance-of-entity-type-cannot-be-tracked-because-another-instance-of-this-t/42475617
            var local = context.EmployeeSkills.Local.Where(t => t.Id == 9).FirstOrDefault();

            if (local != null)
            {
                context.Entry(local).State = EntityState.Detached;           // only needed for xUnit testing
            }
            var result = await query.PutEmployeeSkills(9, newEmployeeSkill); // async

            var added = await query.GetEmployeeSkillById(9);                 // async

            var addedGoodRequest = Assert.IsType <EmployeeSkillsToReturn>(added.Value);

            Assert.Equal(newEmployeeSkill.Id, added.Value.Id);
            Assert.Equal(newEmployeeSkill.SkillsId, added.Value.SkillsId);
            Assert.Equal(newEmployeeSkill.Experience, added.Value.Experience);
            Assert.Equal(newEmployeeSkill.UserId, added.Value.UserId);
            Assert.Equal(Newtonsoft.Json.JsonConvert.SerializeObject(newEmployeeSkillToReturn), Newtonsoft.Json.JsonConvert.SerializeObject(addedGoodRequest));
            //Assert.Equal(newEmployeeSkillToReturn, addedGoodRequest);
            // not sure why the objects aren't considered to be the same
            //Assert.Equal(newEmployeeSkill, result); // No Content returned so can't check it without changing return value
        }
        public async void PostExployeeSkills_Add_EmployeeSkill_Already_Added()
        {
            var query = new EmployeeSkillsController(context);

            var newEmployeeSkill = new EmployeeSkills {
                Id = 10, SkillsId = 1, Experience = 3, UserId = "a3"
            };

            var result = await query.PostEmployeeSkills(newEmployeeSkill); // async

            var added = await query.GetEmployeeSkillById(10);              // async

            Assert.Null(added.Value);
            var badRequestResult = Assert.IsType <BadRequestObjectResult>(result.Result);

            Assert.Contains("already added to this employee", badRequestResult.Value.ToString());
            Assert.Equal(400, badRequestResult.StatusCode);
            Assert.IsType <BadRequestObjectResult>(result.Result);
        }
        public async void UpdateEmployeeSkills_Returns_OK()
        {
            var query = new EmployeeSkillsController(context);

            var newEmployeeSkill = new EmployeeSkills {
                Id = 9, SkillsId = 7, Experience = 1, UserId = "a1"
            };

            // https://stackoverflow.com/questions/36856073/the-instance-of-entity-type-cannot-be-tracked-because-another-instance-of-this-t/42475617
            var local = context.EmployeeSkills.Local.Where(t => t.Id == 9).FirstOrDefault();

            if (local != null)
            {
                context.Entry(local).State = EntityState.Detached;            // only needed for xUnit testing
            }
            var result = await query.PutEmployeeSkills(9, newEmployeeSkill);  // async

            Assert.IsType <NoContentResult>(result);
        }
        public async void PostExployeeSkills_Add()
        {
            var query = new EmployeeSkillsController(context);

            var newEmployeeSkill = new EmployeeSkills {
                Id = 10, SkillsId = 2, Experience = 3, UserId = "a3"
            };

            var newEmployeeSkillToReturn = new EmployeeSkillsToReturn
            {
                Id         = 10,
                SkillsId   = 2,
                Experience = 3,
                UserId     = "a3",
                Skills     = new Skills {
                    Id = 2, Name = "Javascript", Type = 1
                },
                UserInfo = new UserInfo {
                    Id = "a3", UserName = "******", FirstName = "Tim", LastName = "Wills", Email = "*****@*****.**", IsManager = null
                }
            };

            var result = await query.PostEmployeeSkills(newEmployeeSkill); // async

            var added = await query.GetEmployeeSkillById(10);              // async

            var resultGoodRequest = Assert.IsType <CreatedAtActionResult>(result.Result);
            var addedGoodRequest  = Assert.IsType <EmployeeSkillsToReturn>(added.Value);

            Assert.Equal(newEmployeeSkill.Id, added.Value.Id);
            Assert.Equal(newEmployeeSkill.SkillsId, added.Value.SkillsId);
            Assert.Equal(newEmployeeSkill.Experience, added.Value.Experience);
            Assert.Equal(newEmployeeSkill.UserId, added.Value.UserId);
            Assert.Equal(newEmployeeSkill, resultGoodRequest.Value);
            Assert.Equal(Newtonsoft.Json.JsonConvert.SerializeObject(newEmployeeSkillToReturn), Newtonsoft.Json.JsonConvert.SerializeObject(addedGoodRequest));
            //Assert.Equal(newEmployeeSkillToReturn, addedGoodRequest);
            // not sure why the objects aren't considered to be the same
        }
Example #26
0
        public async Task <IActionResult> PutEmployeeSkills(int id, EmployeeSkills employeeSkills)
        {
            if (id != employeeSkills.Id)
            {
                return(BadRequest());
            }

            var e = await _context.EmployeeSkills
                    .AsNoTracking()
                    .Include(s => s.Skills)
                    .FirstOrDefaultAsync(x => x.SkillsId == employeeSkills.SkillsId && x.UserId == employeeSkills.UserId);

            if (e != null && e.Id != id)
            {
                return(BadRequest("Skill of " + e.Skills.Name + " already added to this employee."));
            }

            _context.Entry(employeeSkills).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!EmployeeSkillsExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
        public async Task <IActionResult> Create([Bind("EmployeeId,FirstName,LastName,Address,BirthDate,Joindate,Gender,RoleId,About")] Employee employee, IFormCollection fc)
        {
            if (ModelState.IsValid)
            {
                var emp = await _context.Employees.AddAsync(employee);

                await _context.SaveChangesAsync();

                List <EmployeeHobbies> Hobbies = new List <EmployeeHobbies>();
                foreach (var i in fc["hobbies"])
                {
                    var hobbies = new EmployeeHobbies()
                    {
                        HobbyId    = Convert.ToInt32(i),
                        EmployeeId = emp.Entity.EmployeeId
                    };
                    Hobbies.Add(hobbies);
                }
                List <EmployeeSkills> skills = new List <EmployeeSkills>();

                foreach (var i in fc["skills"])
                {
                    var skill = new EmployeeSkills()
                    {
                        SkillId    = Convert.ToInt32(i),
                        EmployeeId = emp.Entity.EmployeeId
                    };
                    skills.Add(skill);
                }
                _context.EmployeeSkills.AddRange(skills);
                _context.EmployeeHobbies.AddRange(Hobbies);

                _context.SaveChanges();
            }
            ViewData["Roles"] = _context.Roles.ToList();
            return(View(employee));
        }
 public JsonResult UpdateEmployeeSkill(EmployeeSkills EmployeeSkil)
 {
     _EmployeeSkillsRepository.UpdateEmployeeSkill(EmployeeSkil);
     _EmployeeSkillsRepository.Save();
     return(Json("Updated record successfully", JsonRequestBehavior.AllowGet));
 }
    /// <summary>
    /// To populate the skills which already user having 
    /// </summary>
    /// <param name="currentUserId"></param>
    protected void populateData(string currentUserId)
    {
        SqlConnection con = new SqlConnection();
        con.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["skillsetConnectionString"].ConnectionString;
        con.Open();
        SqlCommand skillcmd = new SqlCommand(@"select u.*,s.skillname from  emploskills u join
           skillstab s on s.skillid = u.skillid where eid='" + currentUserId + "'", con);
        SqlDataReader reader = skillcmd.ExecuteReader();
        List<EmployeeSkills> empSkills = new List<EmployeeSkills>();
        while (reader.Read())
        {
            EmployeeSkills empSkill = new EmployeeSkills();

            empSkill.Certified = reader["certified"].ToString();
            empSkill.EmpId = reader["eid"].ToString();
            empSkill.Trained = reader["trained"].ToString();
            empSkill.Experienced = reader["skill_experience"].ToString();
            empSkill.Description = reader["description"].ToString();
            empSkill.ExpLevel = reader["experiancelevel"].ToString();
            empSkill.ExpYears = reader["expyear"].ToString();
            empSkill.ExpMonths = reader["expmonth"].ToString();
            empSkill.SkillId = reader["skillid"].ToString();
            empSkills.Add(empSkill);
        }
        reader.Close();
        con.Close();
        hdnValue.Value = empSkills.ToJSON();
    }
    protected void populateData(string currentUserId)
    {
        ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('" + currentUserId + "')</script>");
                SqlConnection con = new SqlConnection();
                con.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["skillsetConnectionString"].ConnectionString;
                con.Open();
                SqlCommand skillcmd = new SqlCommand(@"select u.*,s.skillname from  emploskills u join
               skillstab s on s.skillid = u.skillid where eid='" + currentUserId + "'", con);
                SqlDataReader reader = skillcmd.ExecuteReader();
                List<EmployeeSkills> empSkills = new List<EmployeeSkills>();
                while (reader.Read())
                {
                    EmployeeSkills empSkill = new EmployeeSkills();

                    empSkill.Certified = reader["certified"].ToString();
                    empSkill.EmpId = reader["eid"].ToString();
                    empSkill.Trained = reader["trained"].ToString();
                    empSkill.Experienced = reader["skill_experience"].ToString();
                    empSkill.Description = reader["description"].ToString();
                    empSkill.ExpLevel = reader["experiancelevel"].ToString();
                    empSkill.ExpYears = reader["expyear"].ToString();
                    empSkill.ExpMonths = reader["expmonth"].ToString();
                    empSkill.SkillId = reader["skillid"].ToString();
                    empSkill.SkillName = reader["basicskill"].ToString();
                    empSkills.Add(empSkill);
                }
    }
Example #31
0
 public EmployeeDetail()
 {
     employeeSkills = new EmployeeSkills();
 }
Example #32
0
        /*
         * This method will add the given Employee Details to DB along with other related details
         * It takes EmployeeDto object and returns the string message
         */
        public int AddEmployee(EmployeeDto toAddEmployee)
        {
            ContactDetails    contactEntity   = new ContactDetails();
            EmployeeBiography biographyEntity = new EmployeeBiography();
            Employee          employeeEntity  = new Employee();

            try {
                //Adding Employee Contact Details to DB Entity

                contactEntity.MobNumberOff      = toAddEmployee.ContactDetail.MobileOffice;
                contactEntity.MobNumberPersonal = toAddEmployee.ContactDetail.MobilePersonal;
                contactEntity.SkypeID           = toAddEmployee.ContactDetail.SkypeId;
                contactEntity.SlackID           = toAddEmployee.ContactDetail.SlackId;
                contactEntity.Address           = toAddEmployee.ContactDetail.Address;
                contactEntity.FBLink            = toAddEmployee.ContactDetail.FBLink;
                contactEntity.TwitterLink       = toAddEmployee.ContactDetail.TwitterLink;
                contactEntity.GitHubLink        = toAddEmployee.ContactDetail.GitHubLink;
                contactEntity.linkdinLink       = toAddEmployee.ContactDetail.LinkdinLink;

                Context.ContactDetails.Add(contactEntity);

                //Adding Employee Biography to DB Entity

                biographyEntity.About     = toAddEmployee.Bio.About;
                biographyEntity.Hobbies   = toAddEmployee.Bio.Hobbies;
                biographyEntity.Interests = toAddEmployee.Bio.Interests;

                Context.ContactDetails.Add(contactEntity);
                Context.EmployeeBiographies.Add(biographyEntity);
                Context.SaveChanges();

                var departDetails = Context.DepartmentDetails
                                    .FirstOrDefault(depart => depart.DepartmentId == toAddEmployee.Departmnent.DepartmentId);
                var roledetails = Context.EmployeeRoles
                                  .FirstOrDefault(role => role.RoleId == toAddEmployee.Role.RoleId);
                var teamDetails = Context.TeamDetails
                                  .FirstOrDefault(team => team.TeamID == toAddEmployee.Team.TeamId);

                // Adding Employee Details to Employee Entity

                employeeEntity.FirstName         = toAddEmployee.FirstName;
                employeeEntity.LastName          = toAddEmployee.LastName;
                employeeEntity.Dob               = toAddEmployee.Dob;
                employeeEntity.EmployeePhotoURL  = "https://picsum.photos/300/200/?image="; //toAddEmployee.PhotoUrl;
                employeeEntity.JoiningDate       = toAddEmployee.JoiningDate;
                employeeEntity.EmailID           = toAddEmployee.EmailId;
                employeeEntity.SPOC              = toAddEmployee.SPOC;
                employeeEntity.RoleId            = toAddEmployee.Role.RoleId;
                employeeEntity.employeeRoles     = roledetails;
                employeeEntity.DepartmentDetails = departDetails;
                employeeEntity.TeamDetails       = teamDetails;
                employeeEntity.ContactId         = contactEntity.ContactId;
                employeeEntity.BioId             = biographyEntity.BioId;

                Context.Employees.Add(employeeEntity);
                Context.SaveChanges();

                // Mapping and Adding Employee Skills to DB Entity

                List <EmployeeSkills> skillList = new List <EmployeeSkills>();
                foreach (EmployeeSkillsDto empSkill in toAddEmployee.EmployeeSkills)
                {
                    EmployeeSkills skillEntity = new EmployeeSkills();

                    skillEntity.employee   = employeeEntity;
                    skillEntity.SkillId    = empSkill.SkillId;
                    skillEntity.EmployeeId = employeeEntity.EmployeeId;
                    skillEntity.SkillLevel = empSkill.SkillLevel;


                    skillList.Add(skillEntity);
                }

                // Adding Employee Skills
                Context.EmployeeSkills.AddRange(skillList);
                Context.SaveChanges();
            }
            catch (SqlException sqlExp)
            {
                throw sqlExp;
            }
            catch (NullReferenceException expNull)
            {
                throw expNull;
            }
            return(employeeEntity.EmployeeId);
        }
 public static EmployeeSkills CreateEmployeeSkills(int ID, string skill, int skillYears, int employeeSkills_Employee, byte[] rowVersion)
 {
     EmployeeSkills employeeSkills = new EmployeeSkills();
     employeeSkills.Id = ID;
     employeeSkills.Skill = skill;
     employeeSkills.SkillYears = skillYears;
     employeeSkills.EmployeeSkills_Employee = employeeSkills_Employee;
     employeeSkills.RowVersion = rowVersion;
     return employeeSkills;
 }
 public void AddToEmployeeSkills(EmployeeSkills employeeSkills)
 {
     base.AddObject("EmployeeSkills", employeeSkills);
 }