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