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;
}
}
