public bool cancelAuthority() { try { var emp = from employee in ctx.Employees join rol in ctx.Roles on employee.RoleID equals rol.RoleID where rol.RoleID == 3 select employee; ADTeam4EF.Employee e = emp.First(); var delegateInfo = from del in ctx.DelicatedInfoes where del.EmployeeID == e.EmployeeID select del; ADTeam4EF.DelicatedInfo d = delegateInfo.First(); using (TransactionScope ts = new TransactionScope()) { e.RoleID = 4; //ctx.SaveChanges(); ctx.DelicatedInfoes.Remove(d); ctx.SaveChanges(); ts.Complete(); return(true); } } catch { return(false); } }
public bool delegateAuthorityMobile(int employeeID, DateTime fromDate, DateTime toDate) { try { var employee = from emp in ctx.Employees join r in ctx.Roles on emp.RoleID equals r.RoleID where emp.EmployeeID == employeeID select emp; ADTeam4EF.Employee e = employee.First(); using (TransactionScope ts = new TransactionScope()) { e.RoleID = 3; ctx.SaveChanges(); ADTeam4EF.DelicatedInfo delicateInfo = new ADTeam4EF.DelicatedInfo(); delicateInfo.EmployeeID = employeeID; delicateInfo.fromDate = fromDate; delicateInfo.toDate = toDate; ctx.DelicatedInfoes.Add(delicateInfo); ctx.SaveChanges(); ts.Complete(); return(true); } } catch { return(false); } }
public void updateExpiredDelegatedEmployee() { try { var emp = from e in ctx.Employees join r in ctx.Roles on e.RoleID equals r.RoleID where e.RoleID == 3 select e; ADTeam4EF.Employee employee = emp.FirstOrDefault(); if (employee != null) { var de = from del in ctx.DelicatedInfoes join e in ctx.Employees on del.EmployeeID equals e.EmployeeID where e.EmployeeID == employee.EmployeeID select del; ADTeam4EF.DelicatedInfo d = de.FirstOrDefault(); if (d != null) { if (System.DateTime.Today > d.toDate) { using (TransactionScope ts = new TransactionScope()){ employee.RoleID = 4; ctx.DelicatedInfoes.Remove(d); ctx.SaveChanges(); ts.Complete(); } } } } } catch (Exception ex) { throw ex; } }
public DelicatedInfo checkDelegate(int employeeid, DateTime today) { try { var dele = from del in ctx.DelicatedInfoes join emp in ctx.Employees on del.EmployeeID equals emp.EmployeeID where del.EmployeeID == employeeid where del.fromDate <= today && del.toDate >= today select del; ADTeam4EF.DelicatedInfo delicatedInfo = dele.FirstOrDefault(); if (delicatedInfo != null) { return(delicatedInfo); } else { return(null); } } catch (Exception ex) { throw ex; } }