public void DeleteLeague(Guid ID) { //get existing record to delete Models.DBObjects.League leagueToDelete = dbContext.Leagues.FirstOrDefault(x => x.IDLeague == ID); if (leagueToDelete != null) { dbContext.Leagues.DeleteOnSubmit(leagueToDelete); //mark for deletion dbContext.SubmitChanges(); } }
public LeagueModel GetLeagueByID(Guid ID) { Models.DBObjects.League existingLeague = dbContext.Leagues.FirstOrDefault(x => x.IDLeague == ID); if (existingLeague != null) { return(existingLeague.MapObject <LeagueModel>()); } else { return(null); } }
//map Model object to ORM model – mapper method private Models.DBObjects.League MapModelToDbObject(LeagueModel leagueModel) { Models.DBObjects.League dbLeagueModel = new Models.DBObjects.League(); if (leagueModel != null) { dbLeagueModel.IDLeague = leagueModel.IDLeague; dbLeagueModel.NameLeague = leagueModel.NameLeague; dbLeagueModel.Country = leagueModel.Country; dbLeagueModel.NumberOfTeams = leagueModel.NumberOfTeams; dbLeagueModel.Sponsor = leagueModel.Sponsor; return(dbLeagueModel); } return(null); }
//map ORM model to Model object – mapper method private LeagueModel MapDbObjectToModel(Models.DBObjects.League dbLeague) { LeagueModel leagueModel = new LeagueModel(); if (dbLeague != null) { leagueModel.IDLeague = dbLeague.IDLeague; leagueModel.NameLeague = dbLeague.NameLeague; leagueModel.Country = dbLeague.Country; leagueModel.NumberOfTeams = dbLeague.NumberOfTeams; leagueModel.Sponsor = dbLeague.Sponsor; return(leagueModel); } return(null); }
public void UpdateLeague(LeagueModel leagueModel) { //get existing record to update Models.DBObjects.League existingLeague = dbContext.Leagues.FirstOrDefault(x => x.IDLeague == leagueModel.IDLeague); if (existingLeague != null) { //map updated values with keeping the ORM objecte reference existingLeague.IDLeague = leagueModel.IDLeague; existingLeague.NameLeague = leagueModel.NameLeague; existingLeague.Country = leagueModel.Country; existingLeague.NumberOfTeams = leagueModel.NumberOfTeams; existingLeague.Sponsor = leagueModel.Sponsor; existingLeague.UpdateObject(leagueModel); dbContext.SubmitChanges(); //commit to db } }