public async Task <T> Get(int id) { using (CliniqueDbContext context = _contextFactory.CreateDbContext()) { T entity = await context.Set <T>().FirstOrDefaultAsync((e) => e.Id == id); return(entity); } }
public async Task <T> Create(T entity) { using (CliniqueDbContext context = _contextFactory.CreateDbContext()) { EntityEntry <T> createdResult = await context.Set <T>().AddAsync(entity); await context.SaveChangesAsync(); return(createdResult.Entity); } }
public async Task <bool> Delete(DateTime datec, int iddocteur, int iddossierpatient) { using (CliniqueDbContext context = _contextFactory.CreateDbContext()) { Consultation entity = await context.Set <Consultation>().FirstOrDefaultAsync((e) => e.IdDocteur == iddocteur && e.IdDossierpatient == iddossierpatient && e.DateC == datec); await context.SaveChangesAsync(); return(true); } }
// GET: Dossierpatients public async Task <IActionResult> Index( string sortOrder, string currentFilter, string searchString, int?pageNumber) { ViewData["CurrentSort"] = sortOrder; ViewData["NumAsSortParm"] = String.IsNullOrEmpty(sortOrder) ? "id_desc" : ""; ViewData["DateSortParm"] = sortOrder == "Date" ? "date_desc" : "Date"; if (searchString != null) { pageNumber = 1; } else { searchString = currentFilter; } ViewData["CurrentFilter"] = searchString; var patients = from s in _contextFactory.CreateDbContext().Dossierpatients.Include(d => d.Docteur) select s; if (!String.IsNullOrEmpty(searchString)) { patients = patients.Where(s => s.NomP.Contains(searchString) || s.PrenomP.Contains(searchString)); } patients = sortOrder switch { "id_desc" => patients.OrderByDescending(s => s.NumAS), "Date" => patients.OrderBy(s => s.DateNaiss), "date_desc" => patients.OrderByDescending(s => s.DateNaiss), _ => patients.OrderBy(s => s.NumAS), }; int pageSize = 8; return(View(await PaginatedList <Dossierpatient> .CreateAsync(patients.AsNoTracking(), pageNumber ?? 1, pageSize))); }
// GET: Docteurs public async Task <IActionResult> Index( string sortOrder, string currentFilter, string searchString, int?pageNumber) { ViewData["CurrentSort"] = sortOrder; ViewData["IdSortParm"] = String.IsNullOrEmpty(sortOrder) ? "id_desc" : ""; ViewData["SpecSortParm"] = sortOrder == "Specialite" ? "spec_desc" : "Specialite"; if (searchString != null) { pageNumber = 1; } else { searchString = currentFilter; } ViewData["CurrentFilter"] = searchString; var docteurs = from s in _contextFactory.CreateDbContext().Docteurs.Include(d => d.Specialite) select s; switch (sortOrder) { case "id_desc": docteurs = docteurs.OrderByDescending(s => s.Id); break; case "Specialite": docteurs = docteurs.OrderBy(s => s.Specialite.Titre); break; case "spec_desc": docteurs = docteurs.OrderByDescending(s => s.Specialite.Titre); break; default: docteurs = docteurs.OrderBy(s => s.Id); break; } int pageSize = 8; return(View(await PaginatedList <Docteur> .CreateAsync(docteurs.AsNoTracking(), pageNumber ?? 1, pageSize))); }
// GET: RendezVous public async Task <IActionResult> Index() { var cliniqueDbContext = _contextFactory.CreateDbContext().RendezVous.Include(r => r.Docteur).Include(r => r.Dossierpatient); return(View(await cliniqueDbContext.ToListAsync())); }
// GET: Ordonnances public async Task <IActionResult> Index() { return(View(await _contextFactory.CreateDbContext().Ordonnances.ToListAsync())); }
// GET: Medicaments public async Task <IActionResult> Index( string sortOrder, string currentFilter, string searchString, int?pageNumber) { ViewData["CurrentSort"] = sortOrder; ViewData["NomSortParm"] = String.IsNullOrEmpty(sortOrder) ? "nom_desc" : ""; ViewData["PrixSortParm"] = sortOrder == "Prix" ? "prix_desc" : "Prix"; ViewData["CatSortParm"] = sortOrder == "Categorie" ? "cat_desc" : "Categorie"; if (searchString != null) { pageNumber = 1; } else { searchString = currentFilter; } ViewData["CurrentFilter"] = searchString; var medicaments = from s in _contextFactory.CreateDbContext().Medicaments.Include(d => d.Categorie) select s; switch (sortOrder) { case "nom_desc": medicaments = medicaments.OrderByDescending(s => s.NomMed); break; case "Prix": medicaments = medicaments.OrderBy(s => s.Prix); break; case "prix_desc": medicaments = medicaments.OrderByDescending(s => s.Prix); break; case "Categorie": medicaments = medicaments.OrderBy(s => s.Categorie); break; case "cat_desc": medicaments = medicaments.OrderByDescending(s => s.Categorie); break; default: medicaments = medicaments.OrderBy(s => s.NomMed); break; } int pageSize = 8; return(View(await PaginatedList <Medicament> .CreateAsync(medicaments.AsNoTracking(), pageNumber ?? 1, pageSize))); }
public IActionResult Index() { ViewData["Couleurs"] = Couleur.CreerSelectList(); ViewData["IdDossier"] = new SelectList(_contextFactory.CreateDbContext().Dossierpatients, "Id", "NomComplet"); ViewData["IdDocteur"] = new SelectList(_contextFactory.CreateDbContext().Docteurs, "Id", "NomComplet"); return(View()); }
// GET: Ordonnancechirurgies public async Task <IActionResult> Index() { var cliniqueDbContext = _contextFactory.CreateDbContext().Ordonnancechirurgies.Include(o => o.Ordonnance); return(View(await cliniqueDbContext.ToListAsync())); }
// GET: Ordonnancemedicaments public async Task <IActionResult> Index() { CliniqueDbContext context = _contextFactory.CreateDbContext(); var cliniqueDbContext = context .Ordonnancemedicaments.Include(o => o.Medicament).Include(o => o.Ordonnance); return(View(await cliniqueDbContext.ToListAsync())); }