public async Task <ActionResult <TypeEtablissement> > PostTypeEtablissement(TypeEtablissement typeEtablissement)
{
_context.TypeEtablissements.Add(typeEtablissement);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTypeEtablissement", new { id = typeEtablissement.Id }, typeEtablissement));
}
public override Etablissement Read(int id)
{
Etablissement etablissement = null;
SqlCommand command = Connexion.GetInstance().CreateCommand();
command.CommandText = "SELECT * FROM etablissement WHERE id = @id";
command.Parameters.AddWithValue("@id", id);
// Lecture des résultats
SqlDataReader dataReader = command.ExecuteReader();
if (dataReader.Read())
{
int idEtablissement = id;
string nom = dataReader.GetString(1);
string adresse = dataReader.GetString(2);
string numeroTelephone = dataReader.GetString(3);
string mel = dataReader.GetString(4);
int idType = dataReader.GetInt32(5);
dataReader.Close();
TypeEtablissementDAO typeEtabDAO = new TypeEtablissementDAO();
TypeEtablissement typeEtab = typeEtabDAO.Read(idType);
etablissement = new Etablissement(idEtablissement, nom, adresse, numeroTelephone, mel, typeEtab);
}
return(etablissement);
}
public CreateEtablissementViewModel()
{
lTypeEtablissement = new TypeEtablissement().types;
lPays = new Pays().lPays;
lJoursSemaines = new JoursSemaine().lJours;
this.Etab = new Etablissement();
this.lHoraire = new List <Horaire>();
this.Photos = new PhotoGeneriqueViewModel[NombrePhotos];
for (int i = 0; i < NombrePhotos; i++)
{
Photos[i] = new PhotoGeneriqueViewModel();
}
}
public ActionResult FormEtablissement(string id)
{
ActionResult retour = View();
if (Session["UserID"] == null)
{
retour = RedirectToAction("Login");
}
else
{
EtablissementDAO etabDao = new EtablissementDAO();
TypeEtablissementDAO typesEtabDao = new TypeEtablissementDAO();
Etablissement etab = new Etablissement();
ViewBag.etablissement = etab;
List <TypeEtablissement> listeTypesEtablissement = typesEtabDao.RetournerTousLesTypesEtablissement();
ViewBag.listeTypesEtablissement = listeTypesEtablissement;
if (Request.HttpMethod == "POST")
{
int idEtab = Int32.Parse(Request.Form["idEtab"]);
string nom = Request.Form["nom"];
string adresse = Request.Form["adresse"];
string mel = Request.Form["adresseMel"];
string numeroTelephone = Request.Form["numeroTelephone"];
int idType = Int32.Parse(Request.Form["idType"]);
TypeEtablissement typeEtab = listeTypesEtablissement.Find(tp => tp.Id == idType);
etab = new Etablissement(idEtab, nom, adresse, numeroTelephone, mel, typeEtab);
if (idEtab == 0)
{
etabDao.Create(etab);
}
else
{
etabDao.Update(etab);
}
ViewBag.etablissement = etab;
retour = View("FicheEtablissement");
}
else
{
if (!String.IsNullOrWhiteSpace(id))
{
if (Int32.TryParse(id, out int idEtab))
{
if (etabDao.Read(idEtab) != null)
{
etab = etabDao.Read(idEtab);
if ((Request.HttpMethod == "GET") && (Request.Params["action"] != null))
{
if (Request.Params["action"] == "del")
{
etabDao.Delete(etab);
retour = RedirectToAction("FicheEtablissement");
}
}
else
{
ViewBag.etablissement = etab;
}
}
}
}
}
}
return(retour);
}
public EditEtablissementViewModel()
{
lTypeEtablissement = new TypeEtablissement().types;
lPays = new Pays().lPays;
lJoursSemaines = new JoursSemaine().lJours;
}
public async Task <ActionResult <TypeEtablissement> > PutTypeEtablissement(long id, TypeEtablissement typeEtablissement)
{
if (id != typeEtablissement.Id)
{
return(BadRequest());
}
_context.Entry(typeEtablissement).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TypeEtablissementExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
//return NoContent();
return(typeEtablissement);
}