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