public Boolean UpdateEmployee(Employee emp) { try { _context.Entry(emp).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); return(true); } catch { return(false); } }
public Boolean UpdatePage(PageDetail page) { try { _context.Entry(page).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); return(true); } catch { return(false); } }
public Boolean UpadateType(PageType type) { try { var test = _context.PageTypes.Where(c => c.TypeId == type.TypeId).Select(c => new { c.IsActive }).FirstOrDefault(); type.IsActive = test.IsActive; _context.Entry(type).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); return(true); } catch { return(false); } }
/// <summary> /// return boolean value after update employee /// </summary> /// <param name="employee"></param> /// <returns>boolean</returns> public int UpdateEmployee(Employee employee) { try { //get employees' positionid and profile pic name var employeedetail = _context.Employees.Where(c => c.EmpEmail == employee.EmpEmail).Select(c => new { c.EmpProfilePicture, c.PositionPId, c.RegisterCode, c.Id, c.EmpPassword }).FirstOrDefault(); if (employee.EmpPassword != employeedetail.EmpPassword) { return(2); } if (employee.PositionPId == null || employee.PositionPId == "") { employee.PositionPId = employeedetail.PositionPId; } employee.RegisterCode = employeedetail.RegisterCode; //if there is not new employee picture leave the previous profile pic name if (employee.EmpProfilePicture == null || employee.EmpProfilePicture == "") { employee.EmpProfilePicture = employeedetail.EmpProfilePicture; } employee.Id = employeedetail.Id; _context.Entry(employee).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); return(1); } catch { return(0); } }
/// <summary> /// update project details /// </summary> /// <param name="project"></param> /// <returns></returns> public Boolean UpdateProject(Project project) { try { project.IsActive = true; _context.Entry(project).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); return(true); } catch { return(false); } }
/// <summary> /// For Insert or Update the Employee based on Employee Id(incliding the EmployeeLanguages Maps and Files) /// </summary> /// <param name="employee">Employee</param> /// <param name="employeeLanguagesList">employeeLanguages Maps List</param> /// <param name="files">Files Uploaded</param> /// <returns>True is for successfully transaction done , flase is not</returns> public bool InsertUpdateEmployee(Employee employee) { var flag = false; using (context) { //Begin the Transaction for Mutiple Table Data Isertion using (var dbContextTransaction = context.Database.BeginTransaction()) { try { if (employee.EmpId == 0) { employee = context.Employee.Add(employee); context.SaveChanges(); } else { //Insert Employee Landuage Mappings InsertEmployeeLanguages(employee.EmpId, employee.EmployeeLanguages, context); //Insert New Files FileDataManager.InsertFiles(employee.Files, employee.EmpId, context); //Update Employee context.Entry(employee).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } dbContextTransaction.Commit(); flag = true; } catch { dbContextTransaction.Rollback(); flag = false; //Here we trace the Exception in DB } } } return(flag); }
public Boolean ToAdmin(string email) { try { User user = new User(); user = _context.Users .Where(c => c.Email == email) .Where(c => c.Active == true) .FirstOrDefault(); user.Role = "admin"; _context.Entry(user).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); return(true); } catch { return(false); } }
public Boolean UpdateCricketTeam(CricketTeam team) { try { _context.Entry(team).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); return(true); } catch { return(false); } }
/// <summary> /// Task Update /// </summary> /// <param name="task"></param> /// <returns></returns> public Boolean UpdateTask(Task task) { try { _context.Entry(task).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); return(true); } catch { return(false); } }
/// <summary> /// update department /// </summary> /// <param name="dprt"></param> /// <returns></returns> public Boolean UpdateDepartment(Department dprt) { try { _context.Entry(dprt).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); return(true); } catch { return(false); } }
/// <summary> /// update position in table /// </summary> /// <param name="role"></param> /// <returns> boolean</returns> public Boolean UpdatePosition(Position role) { try { _context.Entry(role).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); return(true); } catch { return(false); } }