internal void SkillEdit() { // Populate the excel data GlobalDefinitions.ExcelLib.PopulateInCollection(Base.ExcelPath, "ProfilePage"); GlobalDefinitions.WaitForElement(GlobalDefinitions.driver, By.XPath("//a[@data-tab='second']")); //Click Skill tab ClickSkilltab.Click(); GlobalDefinitions.WaitForElement(GlobalDefinitions.driver, By.XPath("(//*[@data-tab='second']//table//tbody//tr//td[3]//i[@class='outline write icon'])")); //Edit Skill EditSkill.Click(); //Edit Skill AddnewSkill.Clear(); AddnewSkill.SendKeys(GlobalDefinitions.ExcelLib.ReadData(3, "Skill")); //Edit Level SelectElement Edit = new SelectElement(SelectSkillLevel); Edit.SelectByText(GlobalDefinitions.ExcelLib.ReadData(3, "Skill Level")); //Click update UpdateSkill.Click(); }
public bool UpdateSkill(int userID, UpdateSkill newValue) { using (IDbConnection dbConnection = Connection) { string imageQuery = "UPDATE tblskill SET level = @level WHERE userid = @id AND skillid = @skillid"; int rowsAffected = dbConnection.Execute(imageQuery, new { level = newValue.NewValue, id = userID, skillid = newValue.SkillID }); return(rowsAffected > 0); } }
public int updateskill(int skillid, string skillname, string skilldesc, int lmodifiedby) { UpdateSkill us = new UpdateSkill() { SkillId = skillid, SkillName = skillname, SkillDescription = skilldesc, LastModifiedBy = lmodifiedby }; return(new ProjectManagerCSD().updateskill(us)); }
/// <summary> ///Updates Skill Name and description in Skill Table. /// </summary> /// <param name="us"></param> /// <returns></returns> public int updateskill(UpdateSkill us) { SqlParameter[] param1 = new SqlParameter[4]; param1[0] = new SqlParameter("@skillId", SqlDbType.Int); param1[0].Value = us.SkillId; param1[1] = new SqlParameter("@skillName", SqlDbType.VarChar); param1[1].Value = us.SkillName; param1[2] = new SqlParameter("@skillDesc", SqlDbType.VarChar); param1[2].Value = us.SkillDescription; param1[3] = new SqlParameter("@modifiedBy", SqlDbType.Int); param1[3].Value = us.LastModifiedBy; int j = SqlHelper.ExecuteNonQuery("Data Source=.;Initial Catalog=HRS;Integrated Security=True", CommandType.StoredProcedure, "[dbo].[spUpdateSkill]", param1); return(j); }
public void EditSkills() { Global.ExcelLib.PopulateInCollection(Base.ExcelPath, "AddSkills"); GlobalDefinitions.Wait(); SkillLink.Click(); //This list gets the number of rows from the table //IList<IWebElement> rows = GlobalDefinitions.driver.FindElements(By.XPath(".//tr")); //This loop finds the first row which' title matches sRowValue IList <IWebElement> rows = GlobalDefinitions.driver.FindElements(By.XPath(".//tr")); //This loop finds the first row which' title matches sRowValue for (int i = 1; i < rows.Count; i++) { String sValue = GlobalDefinitions.driver.FindElement(By.XPath("//td[contains(text(),'C#')]")).Text; if (sValue == ExcelLib.ReadData(2, "Skill")) { IWebElement Edit = GlobalDefinitions.driver.FindElement(By.XPath("//div[@class='ui bottom attached tab segment tooltip-target active']//tbody[1]//tr[1]//td[3]//span[1]//i[1]")); Edit.Click(); AddSkillText.Clear(); AddSkillText.SendKeys(ExcelLib.ReadData(7, "Skill")); UpdateSkill.Click(); break; } } GlobalDefinitions.Wait(); IWebElement AddAlertPopup = GlobalDefinitions.driver.FindElement(By.ClassName("ns-box-inner")); String AlertText = AddAlertPopup.Text; GlobalDefinitions.Wait(); Assert.IsTrue(AlertText.Contains("updated")); Console.WriteLine(AlertText); //saving screenshot var ScreenshotPath = Global.SaveScreenshot.SaveScreenshotClass(GlobalDefinitions.driver, "Edit is successful"); }
public int updateskill(UpdateSkill us) { return(new CreateSkilldao().updateskill(us)); }
public int updateskill(UpdateSkill us) { return(new CreateSkillBusinessComponent().updateskill(us)); }
public void Put(int id, [FromBody]UpdateSkill newValue) { ur.UpdateSkill(id, newValue); }
public RedirectToActionResult UpdateSkillAction(UpdateSkill skill) { InitialSystemInfo(); if (!ModelState.IsValid) { ProcessModelState(); return(RedirectToAction("AddSkill")); } //Check if id is correct var checkInDatabase = _context.Skills.Where(a => a.Id == skill.Id); if (!checkInDatabase.Any()) { if ((string)TempData["Error"] != "") { TempData["Error"] += "\n"; } TempData["Error"] += "Please enter correct skill id!"; return(RedirectToAction("AddSkill")); } //Check if duplicate field name with other field name var checkDuplication = _context.Skills .Where(a => a.NormalizedName == skill.Name.ToUpper()); if (checkDuplication.Any() && checkDuplication.First().Id != skill.Id) { if ((string)TempData["Error"] != "") { TempData["Error"] += "\n"; } TempData["Error"] += "Entered duplicate skill name " + "\"" + skill.Name + "\" " + "!"; return(RedirectToAction("AddSkill")); } var oldSkill = checkInDatabase.First(); //Prepare to change status if (oldSkill.Status != skill.Status) { string oldStatus; string newStatus; switch (oldSkill.Status) { case FieldStatus.InUse: oldStatus = "\"In Use\""; break; case FieldStatus.InRequest: oldStatus = "\"In Request\""; break; default: oldStatus = "\"No Longer Used\""; break; } switch (skill.Status) { case FieldStatus.InUse: newStatus = "\"In Use\""; break; case FieldStatus.InRequest: newStatus = "\"In Request\""; break; default: newStatus = "\"No Longer Used\""; break; } oldSkill.Status = skill.Status; _context.Skills.Update(oldSkill); _context.SaveChanges(); if ((string)TempData["Inform"] != "") { TempData["Inform"] += "\n"; } TempData["Inform"] += "Skill " + "\"" + oldSkill.Name + "\" " + "'s status changed from " + oldStatus + " to " + newStatus; } //Prepare to log if (oldSkill.Name != skill.Name) { var newName = skill.Name; var oldName = oldSkill.Name; oldSkill.Name = skill.Name; oldSkill.NormalizedName = skill.Name.ToUpper(); _context.Skills.Update(oldSkill); _context.SaveChanges(); if ((string)TempData["Inform"] != "") { TempData["Inform"] += "\n"; } TempData["Inform"] += "Skill" + "\"" + skill.Name + "\" " + "'s name changed from " + oldName + " to " + newName; } TempData["Success"] = "Skill \"" + skill.Name + "\" updated!"; return(RedirectToAction("AddSkill")); }
public void UpdateSkill(Skill skill) { UpdateSkill UpdateSkill = new UpdateSkill(skill); UpdateSkill.Excute(); }