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
}
}
