IQueryable <T> QueryList <T>(Expression <Func <T, bool> > expression, Type type = null) where T : class
{
IQueryable <T> list;
if (typeof(BaseDTO).IsAssignableFrom(type ?? typeof(T)))
{
list = new DTORepository <T>(_context).GetDTO("");
}
else
{
list = _context.Set <T>();
}
if (expression != null)
{
list = list.Where(expression);
}
return(list);
}
//private readonly IQueryConditionsHelper _conditionsHelper;
public DTOService(DTORepository <TDTO> dtoRepository /*, IQueryConditionsHelper conditionsHelper*/)
{
DTORepository = dtoRepository;
//_conditionsHelper = conditionsHelper;
}
static void Main(string[] args)
{
WorkOutContext context = new WorkOutContext("WorkOutDbConnection");
WorkOutContext context1 = new WorkOutContext("WorkOutDbConnection");
Repository <Set> repSet = new Repository <Set>(context);
Repository <Exercise> repExercise = new Repository <Exercise>(context);
Repository <Approach> repApproach = new Repository <Approach>(context);
Repository <Training> repTraining = new Repository <Training>(context);
//var set = context.Sets.FirstOrDefault();
TrainingType tt2 = context.TrainingTypes.FirstOrDefault();
var trainingType1 = context.TrainingTypes.FirstOrDefault <TrainingType>();
trainingType1.TypeTraining = "База 1";
var ttEntry = context.Entry <TrainingType>(trainingType1);
var trainingCol = ttEntry.Collection <Training>("Trainings");
ttEntry.Reload();
var training = context.Trainings.Where(tr => tr.Id == 2).FirstOrDefault();
context.Trainings.Remove(training);
//set.Training = training;
//context.SaveChanges();
ExerciseDTO firstEx = new ExerciseDTO
{
Name = "Test",
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
SetDTO set1 = new SetDTO
{
TimeForRest = 10,
PlannedTime = 0,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
DTOSetRepository dtoSetRepository = null;
DTORepository <Approach, ApproachDTO> dtoApproachRepository = new DTORepository <Approach, ApproachDTO>(null);
DTORepository <Exercise, ExerciseDTO> dtoExcerciseRepository = new DTORepository <Exercise, ExerciseDTO>(null);
firstEx.Id = dtoExcerciseRepository.Create(firstEx);
firstEx.CreatedDate = DateTime.Now;
firstEx.ModifiedDate = DateTime.Now;
set1.Exercises.Add(firstEx);
dtoSetRepository.Create(set1);
string settttt = "Set";
var exer = context.Exercises.Include(settttt).Where(item => item.Id == 1).FirstOrDefault();
ApproachDTO approachDTO = new ApproachDTO
{
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now,
PlannedTimeForRest = 10,
SpentTimeForRest = 12
};
var approaches = dtoApproachRepository.GetAll();
//context1.Exercises.Attach(ex);
//var contextChanges = context1.ChangeTracker.Entries().ToList();
//repSet.Create(set1);
//Exercise firstEx = new Exercise
//{
// Name = "Test",
// CreatedDate = DateTime.Now,
// ModifiedDate = DateTime.Now
//};
//Approach firstApproach = new Approach
//{
// PlannedTimeForRest = 0,
// SpentTimeForRest = 0,
// CreatedDate = DateTime.Now,
// ModifiedDate = DateTime.Now
//};
//repApproach.Create(firstApproach);
//Set set = new Set
//{
// TimeForRest = 10,
// PlannedTime = 0,
// CreatedDate = DateTime.Now,
// ModifiedDate = DateTime.Now
//};
//set.Approaches.Add(firstApproach);
//set.Exercises.Add(firstEx);
//repSet.Create(set);
Repository <TrainingType> rep = new Repository <TrainingType>(context);
//var test = rep.Get(1);
TrainingType test1 = new TrainingType
{
Id = 1,
TypeTraining = "Op",
Description = "aaa",
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
foreach (var changeTrack in context.ChangeTracker.Entries())
{
Console.WriteLine(changeTrack.Entity);
}
context.Set <TrainingType>().Attach(test1);
foreach (var changeTrack in context.ChangeTracker.Entries())
{
Console.WriteLine(changeTrack.Entity);
}
rep.Update(test1);
var tt = new TrainingType
{
Description = "test 4",
TypeTraining = "TT 4",
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
rep.Create(tt);
Repository <TrainingType> rep1 = new Repository <TrainingType>(context);
var trainingType = rep1.Get(tt.Id);
trainingType.TypeTraining = "fwefwef";
trainingType.Trainings = new List <Training>();
rep1.Update(tt);
}
public SomethingDTO get(Guid id)
{
DTORepository repo = new DTORepository();
return(repo.getSomething(id));
}