public static DataTable OfficielsMeritantsList(int year) { try { var context = AthleteJuryEntities.GetDBContext(); DataSet ds = new DataSet(); using (MySqlConnection connection = new MySqlConnection(context.Database.Connection.ConnectionString)) { using (MySqlCommand cmd = new MySqlCommand("usp_OfficielsMeritantsList", connection)) { MySqlDataAdapter adapter = new MySqlDataAdapter(cmd); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; adapter.SelectCommand.Parameters.Add(new MySqlParameter("@year", year)); adapter.Fill(ds); } } return(ds.Tables[0]); //var result = new List<usp_OfficielsMeritantsList_Result>(); //using (var context = AthleteJuryEntities.GetDBContext()) // result = context.usp_OfficielsMeritantsList(year).ToList(); //return result; } catch (Exception ex) { Logger.Error(ex); throw; } }
public virtual T GetSingle(Func <T, bool> where, params Expression <Func <T, object> >[] navigationProperties) { try { T item = null; using (var dbContext = AthleteJuryEntities.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 = AthleteJuryEntities.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 = AthleteJuryEntities.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 virtual void Add(AthleteJuryEntities dbContext, params T[] items) { try { foreach (T item in items) { dbContext.Entry(item).State = EntityState.Added; } } 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_Upcomingcompetitions_Result> Upcomingcompetitions() { try { var result = new List <usp_Upcomingcompetitions_Result>(); using (var context = AthleteJuryEntities.GetDBContext()) { return(context.usp_Upcomingcompetitions().ToList()); } } catch (Exception ex) { Logger.Error(ex); throw; } }
static public DataTable ExecuteSP(string spName) { var context = AthleteJuryEntities.GetDBContext(); DataSet ds = new DataSet(); using (MySqlConnection connection = new MySqlConnection(context.Database.Connection.ConnectionString)) { using (MySqlCommand cmd = new MySqlCommand(spName, connection)) { MySqlDataAdapter adapter = new MySqlDataAdapter(cmd); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; //adapter.SelectCommand.Parameters.Add(new MySqlParameter("@ID", RecordID)); adapter.Fill(ds); } } return(ds.Tables[0]); }
public virtual void SaveChanges(AthleteJuryEntities dbContext) { try { dbContext.SaveChanges(); } 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; } }