/// <summary> /// Attachs teams /// </summary> /// <param name="pContext"></param> /// <param name="pTeamHistory">The object which were attachs</param> private static void tryAttach(synupEntities pContext, pojo.TeamHistory pTeamHistory) { var entry = pContext.Entry(pTeamHistory); if (entry.State == System.Data.Entity.EntityState.Detached) { pContext.TeamHistories.Attach(pTeamHistory); } }
/// <summary> /// Updates a given teamHistory with the new parameters of it. /// </summary> /// <param name="pTeamHistory">Receives the teamHistory that will be updated.</param> /// <returns>Returns a boolean whether the teamHistory has been updated succesfully or not.</returns> public static bool updateTeamHistory(String pNif, String pCodeTeam /*, DateTime pEntranceDate,*/, DateTime pExitDate) { using (var context = new synupEntities()) { pojo.TeamHistory modifiedTeamHistory = null; modifiedTeamHistory = readTeamHistory(pNif, pCodeTeam, context); if (modifiedTeamHistory != null) { tryAttach(context, modifiedTeamHistory); //modifiedTeamHistory.id_employee = pNif; //modifiedTeamHistory.id_team = pCodeTeam; //modifiedTeamHistory.entranceDay = pEntranceDate; modifiedTeamHistory.exitDate = pExitDate; } return(commitChanges(context)); } }
/// <summary> /// Deletes a given teamHistory. /// </summary> /// <param name="t">Receives the teamHistory that is meant to be deleted.</param> /// <returns>Returns the teamHistory that has been deleted.</returns> public static pojo.TeamHistory deleteTeamHistory(String pNif, String pCode) { using (var context = new synupEntities()) { pojo.TeamHistory foundTeamHistory = readTeamHistory(pNif, pCode, context); //Finds the received teamHistory in the database. if (foundTeamHistory != null) //If the teamHistory has been found - meaning that it exists: { tryAttach(context, foundTeamHistory); //foundTeamHistory //foundTeamHistory.Team = null; context.TeamHistories.Remove(foundTeamHistory); //Will be deleted. if (commitChanges(context)) { return(foundTeamHistory); //If the changes are commited succesfully it will return the deleted TeamHistory. } else { return(null); } } } return(null); }