public T Add(T entity) { //Add the parameter object to the database dbContext.Set <T>().Add(entity); //Save changes to finalize the add dbContext.SaveChanges(); //Return the newly added entity return(entity); }
//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 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 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); }
public T Add(T entity) { _db.Set <T>().Add(entity); _db.SaveChanges(); return(entity); }
public T Add(T entity) { ctx.Set <T>().Add(entity); ctx.SaveChanges(); return(entity); }