public virtual T GetSingle(Func <T, bool> where, params Expression <Func <T, object> >[] navigationProperties) { try { T item = null; using (var dbContext = JuryAtheleteEntities.GetDBContext()) { IQueryable <T> dbQuery = dbContext.Set <T>(); //Apply eager loading i.e. include navigation properties foreach (Expression <Func <T, object> > navigationProperty in navigationProperties) { dbQuery = dbQuery.Include <T, object>(navigationProperty); } item = dbQuery .AsNoTracking() //Don't track any changes for the selected item .FirstOrDefault(where); //Apply where clause } return(item); } catch (Exception ex) { Logger.Error(ex); throw; } }
public virtual IList <T> GetList(Func <T, bool> where, params Expression <Func <T, object> >[] navigationProperties) { try { List <T> list = new List <T>(); using (var context = JuryAtheleteEntities.GetDBContext()) { IQueryable <T> dbQuery = context.Set <T>(); //Apply eager loading i.e. include navigation properties foreach (Expression <Func <T, object> > navigationProperty in navigationProperties) { dbQuery = dbQuery.Include <T, object>(navigationProperty); } list = dbQuery .AsNoTracking() //Don't track any changes for the selected item .Where(where) //Apply where clause .ToList <T>(); } return(list); } catch (Exception ex) { Logger.Error(ex); throw; } }
public virtual bool Remove(params T[] items) { try { bool result = false; using (var dbContext = JuryAtheleteEntities.GetDBContext()) { foreach (T item in items) { dbContext.Entry(item).State = EntityState.Deleted; } result = dbContext.SaveChanges() > 0; } return(result); } catch (Exception ex) { DbEntityValidationException validationException = ex as System.Data.Entity.Validation.DbEntityValidationException; if (validationException != null) { foreach (var entityValidationErrors in validationException.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Logger.Error(validationError.PropertyName + "-" + validationError.ErrorMessage); } } } Logger.Error(ex); throw; } }
public static List <usp_Summary_Result> Summary(int f_officiel_id, int saison) { try { var result = new List <usp_Summary_Result>(); using (var context = JuryAtheleteEntities.GetDBContext()) result = context.usp_Summary(f_officiel_id, saison).ToList(); return(result); } catch (Exception ex) { Logger.Error(ex); throw; } }
public static List <usp_PlannedBenefits_Result> PlannedBenefits(int year, int month) { try { var result = new List <usp_PlannedBenefits_Result>(); using (var context = JuryAtheleteEntities.GetDBContext()) result = context.usp_PlannedBenefits(year, month).ToList(); return(result); } catch (Exception ex) { Logger.Error(ex); throw; } }
public static List <usp_GetOfficielsByCompetition_Result> OfficielsByCompetition(int competitionId) { try { var result = new List <usp_GetOfficielsByCompetition_Result>(); using (var context = JuryAtheleteEntities.GetDBContext()) result = context.usp_GetOfficielsByCompetition(competitionId).ToList(); return(result); } catch (Exception ex) { Logger.Error(ex); throw; } }
public static List <usp_OfficielsMeritantsList_Result> OfficielsMeritantsList() { try { var result = new List <usp_OfficielsMeritantsList_Result>(); using (var context = JuryAtheleteEntities.GetDBContext()) result = context.usp_OfficielsMeritantsList().ToList(); return(result); } catch (Exception ex) { Logger.Error(ex); throw; } }
public static List <usp_Upcomingcompetitions_Result> Upcomingcompetitions() { try { var result = new List <usp_Upcomingcompetitions_Result>(); using (var context = JuryAtheleteEntities.GetDBContext()) result = context.usp_Upcomingcompetitions().ToList(); return(result); } catch (Exception ex) { Logger.Error(ex); throw; } }