public IActionResult Contact()
{
ViewData["Message"] = "Your contact page.";
var ttt = new EFDataManager(new ApplicationContext());
//var tt = ttt.Statements.GetAll()
// .IncludeMultiple( s => s.Certification )
// .IncludeMultiple( s => s.EducationProgram )
// .IncludeMultiple( s => s.Subject );
//var vm = ttt.EducationPrograms.GetAll().Where(p => p.ProgramType.Contains("Курс"))
// .Where(pr => pr.Active)
// .Where(c => c.CategoryId == 1)
// .IncludeMultiple( p => p.EducationalPlanList )
// .Select( i => new PageContactViewModel { Program = i.Title, Subjects = i.EducationalPlanList.Select( l => l.SubjectId.ToString()) } ).ToList();
var ititi = ttt.EducationalPlans.GetAll()
.IncludeMultiple(pl => pl.EducationProgram)
.IncludeMultiple(pl => pl.Subject)
.Select(item => new PageContactViewModel {
Program = new ProgramViewModel {
Title = item.EducationProgram.Title, Guid = item.EducationProgram.Guid
},
Subjects = new SubjectViewModel {
Title = item.Subject.Title, Guid = item.Subject.Guid
}
});
return(View(ititi));
}
public IActionResult Index()
{
var ttt = new EFDataManager(new ApplicationContext());
var tr = ttt.Statements.GetAll().Select(s => s.Date.ToString());
return(View(tr));
}
public IActionResult About()
{
ViewData["Message"] = "Your application description page.";
var ttt = new EFDataManager(new ApplicationContext());
var tr = ttt.EducationPrograms.GetAll()
.Where(p => p.ProgramType.Contains("Курс"))
.Where(pr => pr.Active)
.Where(c => c.CategoryId == 1)
.IncludeMultiple(s => s.EducationalPlanList, s => s.EducationType);
var r = ttt.EducationPrograms.GetAllIncludeRef(s => s.Category, s => s.EducationType);
var tt = ttt.Statements.GetAllIncludeRef(fdf => fdf.Certification);
var uu = ttt.EducationPrograms.GetAll()
.Where(p => p.ProgramType.Contains("Курс"))
.IncludeMultiple(e => e.EducationalPlanList)
.Where(p => p.EducationalPlanList.Count > 0);
return(View(r));
}
public static void Main(string[] args)
{
using (ApplicationContext db = new ApplicationContext())
{
IDataManager dm = new EFDataManager(db);
foreach (var i in new AddCatogories().Create())
{
dm.Categories.Add(i);
}
foreach (var i in new AddCertifications().Create())
{
dm.Certifications.Add(i);
}
foreach (var i in new AddEducationTypes().Create())
{
dm.EducationTypes.Add(i);
}
foreach (var i in new AddPrograms(dm).Create())
{
dm.EducationPrograms.Add(i);
}
dm.Save();
//foreach (var item in dm.Certifications.GetAll())
//{
// Console.WriteLine($"{item.Title}.{item.Guid}");
//}
//Console.WriteLine($"{u.Id}.{u.FirstName} - {u.Email}");
Console.ReadKey();
}
}
