public IActionResult UpdateUniteLegale([FromBody] List <String> sirets)
{
string siren = sirets.First().Substring(0, 9);
UniteLegale uniteLegale = _apiClient.GetUniteLegale(siren);
List <Etablissement> etablissementBySiret = new List <Etablissement>();
foreach (string siret in sirets)
{
Etablissement selectedEtablissement = uniteLegale.etablissements.FirstOrDefault(etablissement => etablissement.siret == siret);
Etablissement existingEtablissement = _context.Etablissements.FirstOrDefault(e => e.siret == selectedEtablissement.siret);
if (selectedEtablissement != null)
{
if (existingEtablissement != null)
{
etablissementBySiret.Remove(existingEtablissement);
etablissementBySiret.Add(selectedEtablissement);
}
else
{
return(BadRequest(StatusCode(404)));
}
}
}
uniteLegale.etablissements = etablissementBySiret;
UniteLegale existingUniteLegale = _context.UniteLegale.Include(u => u.etablissements).FirstOrDefault(u => u.siren == uniteLegale.siren);
if (existingUniteLegale != null)
{
_context.Remove(existingUniteLegale);
_context.Add(uniteLegale);
}
else
{
return(BadRequest(StatusCode(404)));
}
_context.SaveChanges();
return(Ok());
}
public async Task <bool> EditPointReleveTemperature(PointReleveTemperature pointReleveTemperature)
{
bool IsEdited = false;
try
{
Etablissement etablissement = await GetEtablissementByUser();
if (pointReleveTemperature.EtablissementId == etablissement.Id)
{
_context.Update(pointReleveTemperature);
await _context.SaveChangesAsync();
IsEdited = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(IsEdited);
}
public async Task <IActionResult> Edit(string IdEtablissement, Etablissement etablissement)
{
if (IdEtablissement != etablissement.IdEtablissement)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
await _etablissementLayer.EtablissementUpdateProcedureAsync(etablissement);
return(RedirectToAction(nameof(Index)));
}
catch (DbUpdateConcurrencyException)
{
return(RedirectToAction(nameof(Index)));
}
}
ListeEtablissement();
return(View(etablissement));
}
public List <Etablissement> RetrouverListeEmployeur(int idContact)
{
List <Etablissement> RetrouverListeEmployeur = new List <Etablissement>();
SqlCommand command = Connexion.GetInstance().CreateCommand();
command.CommandText = "SELECT * FROM travailpour WHERE idContact = @idContact";
command.Parameters.AddWithValue("@idContact", idContact);
// Lecture des résultats
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
int idEtablissement = dataReader.GetInt32(0);
EtablissementDAO etablissementDAO = new EtablissementDAO();
Etablissement etablissement = etablissementDAO.Read(idEtablissement);
RetrouverListeEmployeur.Add(etablissement);
}
dataReader.Close();
return(RetrouverListeEmployeur);
}
public async Task <bool> VerifyProductionInstallation()
{
bool isVerified = false;
Production production;
try
{
Etablissement etablissement = await GetEtablissementByUser();
production = etablissement?.Installation?.Production;
if (production != null)
{
isVerified = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(isVerified);
}
public async Task <Diagnostique> GetDiagnostiqueById(int diagnostiqueId)
{
Diagnostique diagnostique = null;
try
{
Etablissement etablissement = await GetEtablissementByUser();
Diagnostique diagnostiqueVerif = await _context.Diagnostiques.FindAsync(diagnostiqueId);
if (diagnostiqueVerif.InstallationId == etablissement.Installation.Id)
{
diagnostique = diagnostiqueVerif;
}
}
catch (Exception ex)
{
throw ex;
}
return(diagnostique);
}
public List <Etablissement> RetrouverListeClient(int idVisiteurMedical)
{
List <Etablissement> listeClient = new List <Etablissement>();
SqlCommand command = Connexion.GetInstance().CreateCommand();
command.CommandText = "SELECT * FROM relationcommerciale WHERE idVisiteurMedical = @idVisiteurMedical";
command.Parameters.AddWithValue("@idVisiteurMedical", idVisiteurMedical);
// Lecture des résultats
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
int idEtablissement = dataReader.GetInt32(0);
EtablissementDAO etablissementDAO = new EtablissementDAO();
Etablissement etablissement = etablissementDAO.Read(idEtablissement);
listeClient.Add(etablissement);
}
dataReader.Close();
return(listeClient);
}
public async Task <IActionResult> Validate(Guid etabId, string button)
{
try
{
Etablissement etab = await etablissementService.GetEtablissementAsync(etabId);
etab.estValide = bool.Parse(button);
var idToken = await HttpContext.GetTokenAsync("access_token");
var result = await etablissementService.UpdateEtablissementAsync(etab, idToken);
}
catch (Exception ex)
{
ErrorViewModel vme = new ErrorViewModel()
{
RequestId = ex.Message
};
return(View("Error", vme));
}
return(RedirectToAction("ListeEtablissementOwned"));
}
public IActionResult DeleteEtablissement(String siret)
{
string siren = siret.Substring(0, 9);
Etablissement existingEtablissement = _context.Etablissements.FirstOrDefault(e => e.siret == siret);
UniteLegale existingUniteLegale = _context.UniteLegale.Include(u => u.etablissements)
.FirstOrDefault(u => u.siren == siren);
if (existingEtablissement == null)
{
return(BadRequest());
}
else
{
_context.Remove(existingEtablissement);
_context.SaveChanges();
if (!existingUniteLegale.etablissements.Any())
{
_context.Remove(existingUniteLegale);
_context.SaveChanges();
}
return(Ok());
}
}
public IActionResult Create(Etablissement etablissement)
{
if (etablissement == null)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_etablissementLayer.EtablissementAddProcedure(etablissement);
//return View(etablissement); pour les tests
return(RedirectToAction(nameof(Index)));
}
catch (DbException)
{
return(RedirectToAction(nameof(Index)));
}
}
ListeEtablissement();
return(View(etablissement));
}
public override CompteRendu Read(int id)
{
CompteRendu compteRendu = null;
SqlCommand commande = Connexion.GetInstance().CreateCommand();
commande.CommandText = "SELECT * FROM compterendu WHERE id = @id";
commande.Parameters.AddWithValue("@id", id);
SqlDataReader dataReader = commande.ExecuteReader();
if (dataReader.Read())
{
int idVisiteurMedical = dataReader.GetInt32(1);;
int idContact = dataReader.GetInt32(2);
int idEtablissement = dataReader.GetInt32(3);
string titre = dataReader.GetString(4);
string contenu = dataReader.GetString(5);
DateTime date = dataReader.GetDateTime(6);
dataReader.Close();
EchantillonDAO echantillonDao = new EchantillonDAO();
List <Echantillon> listeEchantillon = echantillonDao.RetrouverListeEchantillon(id);
VisiteurMedicalDAO visiteurMedicalDao = new VisiteurMedicalDAO();
VisiteurMedical visiteurMedical = visiteurMedicalDao.Read(idVisiteurMedical);
ContactDAO contactDao = new ContactDAO();
Contact contact = contactDao.Read(idContact);
EtablissementDAO etablissementDao = new EtablissementDAO();
Etablissement etablissement = etablissementDao.Read(idEtablissement);
compteRendu = new CompteRendu(id, visiteurMedical, contact, etablissement, titre, contenu, date, listeEchantillon);
}
return(compteRendu);
}
public bool Update(Etablissement e)
{
string sql = "UPDATE etablissement SET NomE = @NomE, " +
" VilleE = @VilleE, TelE = @TelE, idU = @idU WHERE Id = @Id";
ok = false;
try
{
db = new DB();
db.InitPrepare(sql);
db.GetCmd().Parameters.Add("@Id", SqlDbType.Int);
db.GetCmd().Parameters.Add("@NomE", SqlDbType.VarChar, 255);
db.GetCmd().Parameters.Add("@VilleE", SqlDbType.VarChar, 150);
db.GetCmd().Parameters.Add("@TelE", SqlDbType.VarChar, 15);
db.GetCmd().Parameters.Add("@idU", SqlDbType.Int);
db.GetCmd().Parameters["@Id"].Value = e.Id;
db.GetCmd().Parameters["@NomE"].Value = e.NomE;
db.GetCmd().Parameters["@VilleE"].Value = e.VilleE;
db.GetCmd().Parameters["@TelE"].Value = e.TelE;
db.GetCmd().Parameters["@idU"].Value = e.IdU.Id;
if (db.ExecuteMAJ() != 0)
{
ok = true;
}
}
catch (Exception ex)
{
ok = false;
MessageBox.Show(ex.Message.ToString());
}
return(ok);
}
public async void EtablissementAddAsync(Etablissement etablissement)
{
_context.Add(etablissement);
await _context.SaveChangesAsync();
}
public void EtablissementUpdate(Etablissement etablissement)
{
_context.Update(etablissement);
_context.SaveChanges();
}
public void EtablissementAdd(Etablissement etablissement)
{
_context.Add(etablissement);
_context.SaveChanges();
}
public void EditEtablissement(Etablissement oldEtablissement, Etablissement newEtablissement)
{
EtablissementRepo.Set(oldEtablissement, newEtablissement);
}
public void DeleteEtablissement(Etablissement Etablissement)
{
EtablissementRepo.Remove(Etablissement);
}
public void CreateEtablissement(Etablissement Etablissement)
{
EtablissementRepo.Add(Etablissement);
}
public async Task <IActionResult> Index()
{
Etablissement etablissement = await _dataEtablissement.GetEtablissementByUser();
return(View(etablissement));
}
public ActionResult FormCompteRendu(String id)
{
ActionResult retour = View();
if (Session["UserID"] == null)
{
retour = RedirectToAction("Login");
}
else
{
CompteRenduDAO crDao = new CompteRenduDAO();
VisiteurMedicalDAO visiteurMedicalDao = new VisiteurMedicalDAO();
ContactDAO contactDao = new ContactDAO();
EtablissementDAO etabDao = new EtablissementDAO();
ProduitDAO produitDao = new ProduitDAO();
CompteRendu cr = new CompteRendu();
ViewBag.cr = cr;
List <VisiteurMedical> listeVisiteursMedicaux = visiteurMedicalDao.RetournerTousLesVisiteursMedicaux();
ViewBag.listeVisiteursMedicaux = listeVisiteursMedicaux;
List <Contact> listeContacts = contactDao.RetournerTousLesContacts();
ViewBag.listeContacts = listeContacts;
List <Etablissement> listeEtablissements = etabDao.RetournerTousLesEtablissements();
ViewBag.listeEtablissements = listeEtablissements;
List <Produit> listeProduits = produitDao.RetournerTousLesProduits();
ViewBag.listeProduits = listeProduits;
if (Request.HttpMethod == "POST")
{
int idCompteRendu = Int32.Parse(Request.Form["idCompteRendu"]);
VisiteurMedical visiteurMedical = listeVisiteursMedicaux.Find(vm => vm.Id == Int32.Parse(Request.Form["visiteurMedical"]));
Contact contact = listeContacts.Find(cont => cont.Id == Int32.Parse(Request.Form["contact"]));
Etablissement etablissement = listeEtablissements.Find(etab => etab.Id == Int32.Parse(Request.Form["etablissement"]));
string titre = Request.Form["titre"];
string contenu = Request.Form["contenu"];
DateTime date = Convert.ToDateTime(Request.Form["date"]);
List <Echantillon> listeEchantillon = new List <Echantillon>();
cr = new CompteRendu(idCompteRendu, visiteurMedical, contact, etablissement, titre, contenu, date, listeEchantillon);
if (idCompteRendu == 0)
{
crDao.Create(cr);
}
else
{
crDao.Update(cr);
}
ViewBag.cr = cr;
retour = View("FicheCompteRendu");
}
else
{
if (!String.IsNullOrWhiteSpace(id))
{
if (Int32.TryParse(id, out int idCompteRendu))
{
if (etabDao.Read(idCompteRendu) != null)
{
cr = crDao.Read(idCompteRendu);
if ((Request.HttpMethod == "GET") && (Request.Params["action"] != null))
{
if (Request.Params["action"] == "del")
{
crDao.Delete(cr);
retour = RedirectToAction("FicheCompteRendu");
}
}
else
{
ViewBag.cr = cr;
}
}
}
}
}
}
return(retour);
}
private void dataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Etablissement et = dataGrid.SelectedItem as Etablissement;
MessageBox.Show(et.NomE);
}
public async Task <IActionResult> EditImages(EditImagesViewModel model)
{
if (ModelState.IsValid)
{
try
{
var idToken = await HttpContext.GetTokenAsync("access_token");
//met à jour l'établissement avec le nouveau logo le cas échéant
if (model.PathLogo == null && model.Logo != null)
{
Etablissement etab = await etablissementService.GetEtablissementAsync(model.EtablissementId);
if (etab.Logo != null)
{
string PathLogo = Path.Combine(hostingEnvironment.WebRootPath, "img", "Etablissement", etab.Id.ToString(), "Logo", etab.Logo);
deleteImage(PathLogo);
}
etab.Logo = createLogo(etab.Id, model.Logo);
var result = await etablissementService.UpdateEtablissementAsync(etab, idToken);
}
//supprime les photos le cas échéant
if (model.lPathImages != null)
{
List <PhotoGeneriqueViewModel> lPhotosASupprimer = new List <PhotoGeneriqueViewModel>();
lPhotosASupprimer = model.lPathImages.Where(x => x.IsToBeDeleted).ToList();
if (lPhotosASupprimer != null)
{
foreach (PhotoGeneriqueViewModel photo in lPhotosASupprimer)
{
string PathLogo = Path.Join(hostingEnvironment.WebRootPath, photo.Path);
deleteImage(PathLogo);
var result = photoService.DeletePhotoAsync(photo.id, idToken);
}
}
}
//rajoute les photos le cas échéant
List <PhotoGeneriqueViewModel> lPhotosARajouter = new List <PhotoGeneriqueViewModel>();
lPhotosARajouter = model.Photos.Where(x => x.Photo != null).ToList();
if (lPhotosARajouter != null)
{
foreach (PhotoGeneriqueViewModel photo in lPhotosARajouter)
{
createPhoto(model.EtablissementId, photo);
}
}
}
catch (Exception ex)
{
ErrorViewModel vme = new ErrorViewModel()
{
RequestId = ex.Message
};
return(View("Error", vme));
}
}
return(RedirectToAction("ListeEtablissementOwned"));
}
public async Task <IActionResult> Create(CreateEtablissementViewModel model)
{
try
{
if (ModelState.IsValid)
{
var userId = User.Claims.FirstOrDefault(x => x.Type.ToString() == "sub").Value;
if (User != null)
{
Etablissement newEtabl = new Etablissement();
newEtabl = model.Etab;
Guid userGuid;
if (Guid.TryParse(userId, out userGuid))
{
newEtabl.PublieParUserId = userGuid;
}
else
{
RedirectToAction("Index", "Home");
}
newEtabl.DatePublication = DateTime.Now;
newEtabl.NomUrl = await getNomUrl(newEtabl.Nom);
if (model.Logo != null)
{
//stocke le logo sur le serveur et renvoie son nom
newEtabl.Logo = createLogo(newEtabl.Id, model.Logo);
}
//crée l'établissement
var idToken = await HttpContext.GetTokenAsync("access_token");
try
{
var result = await etablissementService.CreateEtablissementAsync(newEtabl, idToken);
}
catch (Exception)
{
return(View("Error"));
}
//crée les photos
if (model.Photos != null)
{
foreach (PhotoGeneriqueViewModel photo in model.Photos)
{
createPhoto(newEtabl.Id, photo);
}
}
//crée les horaires
createHoraires(newEtabl, model.lHoraire);
return(RedirectToAction("ListeEtablissementOwned"));
}
else
{
RedirectToAction("Index", "Home");
}
}
}
catch (Exception ex)
{
ErrorViewModel vme = new ErrorViewModel()
{
RequestId = ex.Message
};
return(View("Error", vme));
}
return(View(model));
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
Etablissement newEtablissement = new Etablissement(
txtName.Text,
textBox1.Text,
txtEmail.Text,
!string.IsNullOrEmpty(pictureBox1.ImageLocation) ? File.ReadAllBytes(pictureBox1.ImageLocation) : this.oldEtablissement.Logo,
int.Parse(txtTel.Text),
textBP.Text
);
EtablissementBLO universityBLO = new EtablissementBLO(ConfigurationManager.AppSettings["DbFolder"]);
if (this.oldEtablissement == null)
{
universityBLO.CreateEtablissement(newEtablissement);
}
else
{
universityBLO.EditEtablissement(oldEtablissement, newEtablissement);
}
MessageBox.Show(
"Save done!",
"Confirmation",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
txtEmail.Clear();
txtName.Clear();
txtTel.Clear();
pictureBox1.ImageLocation = null;
loadData();
}
catch (TypingException ex)
{
MessageBox.Show(
ex.Message,
"Typing error",
MessageBoxButtons.OK,
MessageBoxIcon.Warning
);
}
catch (DuplicateNameException ex)
{
MessageBox.Show(
ex.Message,
"Duplicate error",
MessageBoxButtons.OK,
MessageBoxIcon.Warning
);
}
catch (KeyNotFoundException ex)
{
MessageBox.Show(
ex.Message,
"key not found error",
MessageBoxButtons.OK,
MessageBoxIcon.Warning
);
}
catch (Exception ex)
{
ex.WriteToFile();
MessageBox.Show(
"An error occured please try again",
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
}
}
public async void EtablissementUpdateAsync(Etablissement etablissement)
{
_context.Update(etablissement);
await _context.SaveChangesAsync();
}
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 FicheViewModel()
{
lPathPhotos = new List <PhotoGeneriqueViewModel>();
Etab = new Etablissement();
Etab.lHoraire = new List <Horaire>();
}
public void Remove(Etablissement etablissement)
{
etablissements.Remove(etablissement);
Save();
}
