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); }
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)); }
public ActionResult DeleteConfirmed(int?EmployeeID, int?SkillID) { EmployeeSkills employeeSkills = _EmployeeSkillsRepository.GetEmployeeSkillByID(EmployeeID, SkillID); _EmployeeSkillsRepository.EmployeeSkillDelete(EmployeeID, SkillID); _EmployeeSkillsRepository.Save(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { EmployeeSkills employeeskills = db.EmployeeSkill.Find(id); db.EmployeeSkill.Remove(employeeskills); db.SaveChanges(); return(RedirectToAction("Index")); }
public void UpdateEmployeeSkill(EmployeeSkills EmployeeSkills) { if (EmployeeSkills != null) { _context.Entry(EmployeeSkills).State = EntityState.Modified; _context.SaveChanges(); } }
// // 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); }
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)); }
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; } }
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)); }
// // 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); }
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"); } }
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)); }
public void InsertEmployeeSkill(EmployeeSkills EmployeeSkills) { try { if (EmployeeSkills != null) { _context.EmployeeSkills.Add(EmployeeSkills); _context.SaveChanges(); } } catch (Exception) { throw; } }
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(); } }
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)); }
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 }
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); } }
public EmployeeDetail() { employeeSkills = new EmployeeSkills(); }
/* * 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); }