public int?PersonUpdateTransaction(Person person) { int?personID = null; try { using (NetballEntities context = new NetballEntities()) { context.Entry(person).State = EntityState.Modified; context.SaveChanges(); personID = person.PersonID; } } catch (Exception ex) { throw ex; } return(personID); }
/// <summary> /// Insert a GamePlayer object in GamePlayer table returning GamePlayerID if successful. /// GamePlayerID = null if failed. /// </summary> /// <param name="GamePlayer"></param> /// <returns></returns> public int?GamePlayerAdd(GamePlayer gameplayer) { int?gameplayerID = null; try { using (NetballEntities context = new NetballEntities()) { context.Entry(gameplayer).State = EntityState.Added; context.SaveChanges(); gameplayerID = gameplayer.GamePlayerID; } } catch (Exception ex) { throw ex; } return(gameplayerID); }
public int?GameTeamUpdateTransaction(GameTeam gameteam) { int?gameteamID = null; try { using (NetballEntities context = new NetballEntities()) { context.Entry(gameteam).State = EntityState.Modified; context.SaveChanges(); gameteamID = gameteam.GameTeamID; } } catch (Exception ex) { throw ex; } return(gameteamID); }
/// <summary> /// Insert a Court object in Court table returning CourtID if successful. /// CourtID = null if failed. /// </summary> /// <param name="Court"></param> /// <returns></returns> public int?CourtAdd(Court court) { int?courtID = null; try { using (NetballEntities context = new NetballEntities()) { context.Entry(court).State = EntityState.Added; context.SaveChanges(); courtID = court.CourtID; } } catch (Exception ex) { throw ex; } return(courtID); }
/// <summary> /// Insert a Division object in Division table returning DivisionID if successful. /// DivisionID = null if failed. /// </summary> /// <param name="Division"></param> /// <returns></returns> public int?DivisionAdd(Division division) { int?divisionID = null; try { using (NetballEntities context = new NetballEntities()) { context.Entry(division).State = EntityState.Added; context.SaveChanges(); divisionID = division.DivisionID; } } catch (Exception ex) { throw ex; } return(divisionID); }
public int?CoachUpdateTransaction(Coach coach) { int?coachID = null; try { using (NetballEntities context = new NetballEntities()) { context.Entry(coach).State = EntityState.Modified; context.SaveChanges(); coachID = coach.CoachID; } } catch (Exception ex) { throw ex; } return(coachID); }