//update employee object
public UpdateStatus Update(Employees updatedStudent)
{
UpdateStatus operationStatus = UpdateStatus.Failed;
try
{
HelpdeskContext _db = new HelpdeskContext();
Employees currentStudent = _db.Employees.FirstOrDefault(stu => stu.Id == updatedStudent.Id);
_db.Entry(currentStudent).OriginalValues["Timer"] = updatedStudent.Timer;
_db.Entry(currentStudent).CurrentValues.SetValues(updatedStudent);
if (_db.SaveChanges() == 1)
{
operationStatus = UpdateStatus.Ok;
}
}
catch (DbUpdateConcurrencyException)
{
operationStatus = UpdateStatus.Stale;
}
catch (Exception ex)
{
Console.WriteLine("Problem in " + GetType().Name + " " +
MethodBase.GetCurrentMethod().Name + " " + ex.Message);
throw ex;
}
return(operationStatus);
}
public Employees GetByEmail(string email)
{
Employees selectedEmployee = null;
try
{
HelpdeskContext _db = new HelpdeskContext();
selectedEmployee = _db.Employees.FirstOrDefault(emp => emp.Email == email);
}
catch (Exception ex)
{
Debug.WriteLine("Problem in " + " " + GetType().Name + " " +
MethodBase.GetCurrentMethod().Name + ex.Message);
}
return(selectedEmployee);
}
public int Add(Employees newempdent)
{
try
{
HelpdeskContext _db = new HelpdeskContext();
_db.Employees.Add(newempdent);
_db.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine("Problem in " + GetType().Name + " " +
MethodBase.GetCurrentMethod().Name + "" + ex.Message);
throw ex;
}
return(newempdent.Id);
}
public List <Employees> GetAll()
{
List <Employees> allEmployees = new List <Employees>();
try
{
HelpdeskContext _db = new HelpdeskContext();
allEmployees = _db.Employees.ToList();
}
catch (Exception ex)
{
Debug.WriteLine("Problem in " + GetType().Name + " " +
MethodBase.GetCurrentMethod().Name + "" + ex.Message);
throw ex;
}
return(allEmployees);
}
public Employees GetById(int id)
{
Employees selectedempdent = null;
try
{
HelpdeskContext _db = new HelpdeskContext();
selectedempdent = _db.Employees.FirstOrDefault(emp => emp.Id == id);
}
catch (Exception ex)
{
Debug.WriteLine("Problem in" + GetType().Name + " " +
MethodBase.GetCurrentMethod().Name + " " + ex.Message);
throw ex;
}
return(selectedempdent);
}
public int Update(Employee updatedEmployee)
{
int employeesUpdated = -1;
try
{
HelpdeskContext ctx = new HelpdeskContext();
Employee currentStudent = ctx.Employees.FirstOrDefault(Employee => Employee.Id == updatedEmployee.Id);
ctx.Entry(currentStudent).CurrentValues.SetValues(updatedEmployee);
employeesUpdated = ctx.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("Problem in " + GetType().Name + " " +
MethodBase.GetCurrentMethod().Name + " " + ex.Message);
throw ex;
}
return(employeesUpdated);
}
public int Update(Employees updatedempdent)
{
int EmployeesUpdated = -1;
try
{
HelpdeskContext _db = new HelpdeskContext();
Employees currentempdent = _db.Employees.FirstOrDefault(emp => emp.Id == updatedempdent.Id);
_db.Entry(currentempdent).CurrentValues.SetValues(updatedempdent);
EmployeesUpdated = _db.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine("Problem in " + GetType().Name + " " +
MethodBase.GetCurrentMethod().Name + " " + ex.Message);
}
return(EmployeesUpdated);
}
public int Delete(int id)
{
int empdentDeleted = -1;
try
{
HelpdeskContext _db = new HelpdeskContext();
Employees selectedempdent = _db.Employees.FirstOrDefault(emp => emp.Id == id);
_db.Employees.Remove(selectedempdent);
empdentDeleted = _db.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine("Problem in " + GetType().Name + " " +
MethodBase.GetCurrentMethod().Name + "" + ex.Message);
throw ex;
}
return(empdentDeleted);
}
// Returns the Id of added employee
public int Add(Employees newEmployee)
{
try
{
// Declare HelpdeskContext object for function call
HelpdeskContext _db = new HelpdeskContext();
_db.Employees.Add(newEmployee);
_db.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine("Problem in " + GetType().Name + " " +
MethodBase.GetCurrentMethod().Name + " " + ex.Message);
throw ex;
} // try/catch
// Returns Id
return(newEmployee.Id);
}
// Return lists of employees
public List <Employees> GetAll()
{
// declare lists of employees
List <Employees> allEmployees = new List <Employees>();
try
{
// Declare HelpdeskContext object for function call
HelpdeskContext _db = new HelpdeskContext();
allEmployees = _db.Employees.ToList();
}
catch (Exception ex)
{
Console.WriteLine("Problem in " + GetType().Name + " " +
MethodBase.GetCurrentMethod().Name + " " + ex.Message);
throw ex;
} // try/catch
// Return lists of employees
return(allEmployees);
}
// Return employee with matching id
public Employees GetById(int id)
{
// Decalre employee to store the result
Employees selectedEmployee = null;
try
{
// Declare HelpdeskContext object for query call
HelpdeskContext _db = new HelpdeskContext();
selectedEmployee = _db.Employees.FirstOrDefault(emp => emp.Id == id);
}
catch (Exception ex)
{
Console.WriteLine("Problem in " + GetType().Name + " " +
MethodBase.GetCurrentMethod().Name + " " + ex.Message);
throw ex;
} // try/catch
// return the employee
return(selectedEmployee);
}
public HelpdeskRepository(HelpdeskContext context = null)
{
_db = context != null ? context : new HelpdeskContext();
}
public HelpDeskRepository(HelpdeskContext context = null)
{
//Creates an instance of Helpdesk context to allow these methods to interact directly with the database
dbContext = context != null ? context : new HelpdeskContext();
}
public SomeWorkRepository(HelpdeskContext context = null)
{
_db = context ?? new HelpdeskContext();
}