public async Task <IActionResult> Create([Bind("idVaccin,marque,num_lot")] Vaccin vaccin)
{
if (ModelState.IsValid)
{
_context.Add(vaccin);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(vaccin));
}
public async Task <IActionResult> Create([Bind("Id,Brand,VaccineTypeId")] Vaccin vaccine)
{
if (ModelState.IsValid)
{
_context.Add(vaccine);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["VaccineTypeId"] = new SelectList(_context.VaccineTypes, "Id", "Label", vaccine.VaccineTypeId);
return(View(vaccine));
}
private static void runCreationVaccin()
{
Console.WriteLine("New Vaccin");
Vaccin vaccin = VaccinController.Instance.AjouterVaccin("VIH Vaccin", 50, 2, false);
Console.ReadKey();
Console.WriteLine("Update Vaccin");
VaccinController.Instance.ModifierVaccin(vaccin, "VIH Vaccin altere", 50, 2, true);
Console.ReadKey();
Console.WriteLine("Delete Vaccin");
VaccinController.Instance.SupprimerVaccin(vaccin);
}
private static void runCreationBareme()
{
Vaccin vaccin = VaccinController.Instance.AjouterVaccin("VIH Vaccin", 50, 2, false);
Bareme bareme = BaremeStore.Instance.Ajouter("103", "30/07/07", "VACC", "Vaccination DT", 11, 10, 14, vaccin, false);
Console.WriteLine("INSERT");
Console.ReadKey();
Console.WriteLine("UPDATE");
BaremeStore.Instance.Modifier(bareme, "VACC", "Vaccination DT americanos", 110, 100, 140, vaccin);
Console.ReadKey();
Console.WriteLine("DELETE");
BaremeStore.Instance.Supprimer(bareme);
}
private static void runCreationLignesFacture()
{
Client client = ClientController.Instance.AjouterClient("Bugeavel-Track", "Amede", "3 rue du petit paris", "", "44950", "Flurne sur Loire", "0666785713", "Non", "*****@*****.**", "Pas de remarque", false);
Facture facture = FactureStore.Instance.Ajouter(client, DateTime.Now.ToUniversalTime(), Facture.eFactureEtats.a_imprimer, 135, DateTime.Now.ToUniversalTime(), false);
Vaccin vaccin = VaccinController.Instance.AjouterVaccin("VIH Vaccin", 50, 2, false);
Bareme bareme = BaremeStore.Instance.Ajouter("103", "30/07/07", "VACC", "Vaccination DT", 11, 10, 14, vaccin, false);
LigneFacture ligneFacture = LigneFactureStore.Instance.Ajouter(facture, bareme, 135, false);
Console.WriteLine("INSERT");
Console.ReadKey();
Console.WriteLine("UPDATE");
LigneFactureStore.Instance.Modifier(ligneFacture, facture, bareme, 1350, true);
Console.ReadKey();
Console.WriteLine("DELETE");
LigneFactureStore.Instance.Supprimer(ligneFacture);
}
public ActionResult Create([Bind(Include = "ID_Consultation,dateCreation,motif,note,poids,taille,temperature,systol,diastol,diagnostique,maladie,ID_Patient,ID_Staff")] Consultation consultation)
{
Vaccin vaccin = new Vaccin();
Ordonnance ordonnance = new Ordonnance();
Antecedent antecedentConsultation = new Antecedent();
if (ModelState.IsValid)
{
db.Consultations.Add(consultation);
string prescription = Request["prescription"].ToString();
string medicament = Request["medicament"].ToString();
string vac = Request["vac"].ToString();
string antecedent = Request["ant"];
if (!string.IsNullOrEmpty(antecedent))
{
antecedentConsultation.ID_Consultation = consultation.ID_Consultation;
antecedentConsultation.ID_Patient = consultation.ID_Patient;
antecedentConsultation.description = antecedent;
db.Antecedents.Add(antecedentConsultation);
}
if (!string.IsNullOrEmpty(vac))
{
vaccin.ID_Consultation = consultation.ID_Consultation;
vaccin.ID_PATIENT = consultation.ID_Patient;
vaccin.description = vac;
vaccin.date = DateTime.Now;
db.Vaccins.Add(vaccin);
}
if (!string.IsNullOrEmpty(medicament))
{
ordonnance.ID_Consultation = consultation.ID_Consultation;
ordonnance.medicament = medicament;
ordonnance.prescription = !string.IsNullOrEmpty(prescription) ? prescription : "";
db.Ordonnances.Add(ordonnance);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_Patient = new SelectList(db.Patients, "ID_Patient", "nom", consultation.ID_Patient);
ViewBag.ID_Staff = new SelectList(db.Staffs, "ID_Staff", "nom", consultation.ID_Staff);
return(View(consultation));
}
public void EnregistrerVaccinTest()
{
List <Vaccin> vaccins = new List <Vaccin> {
new Vaccin
{
NAMPatient = "AAAA10101010",
Type = "Pfizer",
Date = new DateTime(2021, 11, 21)
},
new Vaccin
{
NAMPatient = "BBBB10101010",
Type = "Pfizer",
Date = new DateTime(2021, 11, 30)
},
new Vaccin
{
NAMPatient = "CCCC10101010",
Type = "Moderna",
Date = new DateTime(2021, 11, 2)
},
};
Mock <IDaoVaccin> mockContexte = new Mock <IDaoVaccin>();
mockContexte.Setup(m => m.AjouterVaccin(It.IsAny <Vaccin>()));
mockContexte.Setup(m => m.ObtenirVaccins()).Returns(vaccins);
mockContexte.Setup(m => m.Sauvegarder());
Program p = new Program
{
DaoVaccin = mockContexte.Object
};
Vaccin v = new Vaccin
{
NAMPatient = "DDDD10101010",
Type = "Pfizer",
Date = new DateTime(2021, 03, 27)
};
p.EnregistrerVaccin(v);
mockContexte.Verify(m => m.AjouterVaccin(v), Times.Once);
mockContexte.Verify(m => m.AjouterVaccin(It.IsAny <Vaccin>()), Times.Once);
mockContexte.Verify(m => m.Sauvegarder());
}
public Vaccin GetVaccin(int idConsultation)
{
Vaccin vac = new Vaccin();
using (var cp = new Clinic2Entities())
{
var obj = cp.Vaccins
.Where(vaccin => vaccin.ID_Consultation == idConsultation)
.Select(st => new {
Description = st.description,
Date = st.date
});
vac.description = obj.Select(x => x.Description).DefaultIfEmpty("").First();
vac.date = obj.Select(x => x.Date).DefaultIfEmpty().First();
}
return(vac);
}
public void EnregistrerVaccin(Vaccin n)
{
var memePatient = DaoVaccin.ObtenirVaccins().Where(v => v.NAMPatient == n.NAMPatient);
Vaccin vaccin = CreerNouveauVaccin("", "");
if (memePatient.Count() > 1)
{
throw new ArgumentException("Patient déjà vacciné deux fois");
}
if (memePatient.Count() == 1 && memePatient.First().Type != vaccin.Type)
{
throw new ArgumentException("Un patient ne peut pas recevoir deux" +
"types de vaccins");
}
DaoVaccin.AjouterVaccin(vaccin);
DaoVaccin.Sauvegarder();
}
public ActionResult Create([Bind(Include = "ID_Consultation,creatieDate,createBy,changeDate,changeBy,motif,note,poids,taille,temperature,systol,diastol,diagnostique,maladie,antecedent,statut,ID_Patient,ID_Staff")] Consultation consultation)
{
if (ModelState.IsValid)
{
//---------------------------------------------------------- https://stackoverflow.com/questions/22246538/access-claim-values-in-controller-in-mvc-5
//Get the current claims principal
var identity = (ClaimsPrincipal)Thread.CurrentPrincipal;
// Get the claims values
var name = identity.Claims.Where(c => c.Type == ClaimTypes.Name)
.Select(c => c.Value).SingleOrDefault();
var uid = identity.Claims.Where(c => c.Type == ClaimTypes.Sid)
.Select(c => c.Value).SingleOrDefault();
var role = identity.Claims.Where(c => c.Type == ClaimTypes.Role)
.Select(c => c.Value).SingleOrDefault();
//-----------------------------------------------------------------
Ordonnance ordonnance = new Ordonnance();
Vaccin vaccin = new Vaccin();
consultation.createBy = name + " - ID: " + uid + " - Role:" + role;
consultation.creatieDate = DateTime.Now;
consultation.ID_Staff = Int32.Parse(uid);
consultation.ID_Patient = Int32.Parse(Request["ID_Patient"].ToString());
if (!string.IsNullOrEmpty(Request["medicament"].ToString()) || !string.IsNullOrEmpty(Request["prescription"].ToString()))
{
ordonnance.medicament = Request["medicament"].ToString();
ordonnance.prescription = Request["prescription"].ToString();
ordonnance.ID_Consultation = consultation.ID_Consultation;
db.Ordonnances.Add(ordonnance);
}
if (string.IsNullOrEmpty(Request["vac"].ToString()))
{
vaccin.date = DateTime.Now;
vaccin.description = Request["vac"].ToString();
vaccin.ID_Consultation = consultation.ID_Consultation;
db.Vaccins.Add(vaccin);
}
db.Consultations.Add(consultation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(consultation));
}
/// <summary>
/// Affichage du formulaire de mise à jour, avec chargement des fournisseurs dans le fichier local
/// </summary>
private void BTN_MiseAJour_Click(object sender, EventArgs e)
{
if (BTN_MiseAJour.Text == "Mettre à Jour")
{
Label_Fournisseur.Visible = true;
CBox_Fournisseurs.Visible = true;
Label_Nombre.Visible = true;
TBox_Nombre.Visible = true;
BTN_MiseAJour.Text = "Valider";
// Lecture des fournisseurs inscrits dans le fichier local et insertion dans la ComboBox
string[] CBBoxContent = File.ReadAllLines("C:\\Users\\Administrateur\\Desktop\\CliniqueVeto\\fournisseurs.csv");
foreach (var line in CBBoxContent)
{
string[] tokens = line.Split(';');
CBox_Fournisseurs.Items.Add(tokens[0]);
}
}
else if (BTN_MiseAJour.Text == "Valider")
{
if (String.IsNullOrEmpty(CBox_Fournisseurs.Text.Trim()))
{
errorSaisie.SetError(CBox_Fournisseurs, "Veuillez sélectionner un Fournisseur.");
}
else
{
if (String.IsNullOrEmpty(TBox_Nombre.Text.Trim()))
{
errorSaisie.SetError(TBox_Nombre, "Veuillez saisir une Quantité valide.");
}
else
{
Vaccin vaccin = new Vaccin(VaccinCourant.codeVaccin, VaccinCourant.nomVaccin, VaccinCourant.quantiteStock + int.Parse(TBox_Nombre.Text), VaccinCourant.periodeValidite, false);
MgtVaccin.UpdateVaccin(vaccin);
Datagrid_Load();
Label_Fournisseur.Visible = false;
CBox_Fournisseurs.Visible = false;
Label_Nombre.Visible = false;
TBox_Nombre.Visible = false;
BTN_MiseAJour.Text = "Mettre à Jour";
}
}
}
}
/// <summary>
/// Constructeur de Pharmacie
/// On créer des stocks initiaux pour faciler les tests
/// </summary>
/// <param name="nom"></param>
/// <param name="chiffreAffaireMois"></param>
/// <param name="siret"></param>
/// <param name="responsable"></param>
protected Pharmacie(string nom, double chiffreAffaireMois, string siret, Responsable responsable)
{
Nom = nom;
ChiffreAffaireMois = chiffreAffaireMois;
Siret = siret;
Responsable = responsable;
employes.Add(Responsable);
//On définis les stocks des pharmacies de base
Medicament m1 = new Medicament(1, "", "Doliprane", 12, 16, DateTime.Now, 15, "Medicament", "#Doli");
Vaccin v1 = new Vaccin("", "notice", "Covid-19 vaccin", 95, 500, 1000, DateTime.Now, 50, "Vaccin", "#VacccinCovid");
ProduitBeaute p1 = new ProduitBeaute(5, "Effaclar", 10, 20, DateTime.Now, 100, "ProduitBeaute", "#Effaclar");
p1.Avis.Add("Simplement génial.");
stock.Add(m1);
stock.Add(v1);
stock.Add(p1);
}
public async Task <IActionResult> Create([Bind("Id,TypeVaccin,Marque,NumLot,Date,DateRappel")] Vaccin vaccin, int Personne)
{
var personne = await _context.Personne.FindAsync(Personne);
vaccin.Personne = personne;
ModelState.Clear();
TryValidateModel(vaccin);
if (ModelState.IsValid)
{
_context.Add(vaccin);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["listeDesPersonnes"] = new SelectList(_context.Personne, "Id", "Nom");
return(View(vaccin));
}
private static List <Vaccin> builderObject(SqlDataReader dt)
{
List <Vaccin> list = new List <Vaccin>();
int colCode = dt.GetOrdinal("CodeVaccin");
int colNom = dt.GetOrdinal("NomVaccin");
int colQuantite = dt.GetOrdinal("QuantiteStock");
int colValidite = dt.GetOrdinal("PeriodeValidite");
while (dt.Read())
{
Vaccin vaccin = new Vaccin();
vaccin.codeVaccin = dt.GetGuid(colCode);
vaccin.nomVaccin = dt.GetString(colNom);
vaccin.quantiteStock = dt.GetInt32(colQuantite);
vaccin.periodeValidite = dt.GetInt32(colValidite);
list.Add(vaccin);
}
return(list);
}
public void CreerNouveauVaccinTest()
{
DateTime d = new DateTime(2021, 03, 27, 2, 34, 55, 392);
Mock <IFournisseurDeDate> mockFournisseurDate = new Mock <IFournisseurDeDate>();
mockFournisseurDate.Setup(m => m.Now).Returns(d);
Program p = new Program
{
FournisseurDeDate = mockFournisseurDate.Object
};
Vaccin v = new Vaccin
{
NAMPatient = "AAAA99999999",
Type = "ABC",
Date = d
};
Vaccin cree = p.CreerNouveauVaccin("AAAA99999999", "ABC");
Assert.AreEqual(v, cree);
}
public static Guid AddVaccin(Vaccin leVaccin)
{
try
{
using (SqlConnection cnx = DALAccess.GetConnection())
{
SqlCommand command = cnx.CreateCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "EXEC ajout_vaccin @nomvaccin, @periodevalidite, @quantite";
command.Parameters.AddWithValue("@nomvaccin", leVaccin.nomVaccin);
command.Parameters.AddWithValue("@periodevalidite", leVaccin.periodeValidite);
command.Parameters.AddWithValue("@quantite", leVaccin.quantiteStock);
Guid dResult = (Guid)command.ExecuteScalar();
return(dResult);
}
}
catch (Exception ex)
{
throw new ApplicationException("Erreur : " + ex.Message);
}
}
// GET api/<controller>
public IEnumerable<Vaccin> Get()
{
// return new string[] { "value1", "value2" };
string query = "select * from vaccineinfo";
DataSet aSet = aGateway.Select(query);
List<Vaccin> vaList = new List<Vaccin>();
foreach (DataRow dataRow in aSet.Tables[0].Rows)
{
Vaccin aVaccin = new Vaccin();
aVaccin.ID = Convert.ToInt32(dataRow["ID"].ToString());
aVaccin.Name = dataRow["VaccineName"].ToString();
aVaccin.StartDay = Convert.ToInt32(dataRow["StartDay"].ToString());
aVaccin.EndDay = Convert.ToInt32(dataRow["EndDay"].ToString());
aVaccin.Description = dataRow["Description"].ToString();
vaList.Add(aVaccin);
}
return vaList;
}
// GET api/<controller>/5
public Vaccin Get(int id)
{
string query = "select * from vaccineinfo where ID=@id";
Hashtable aHashtable = new Hashtable();
aHashtable.Add("id", id);
DataSet aSet = aGateway.Select(query,aHashtable);
// List<Vaccin> vaList = new List<Vaccin>();
Vaccin aVaccin = new Vaccin();
foreach (DataRow dataRow in aSet.Tables[0].Rows)
{
aVaccin.ID = Convert.ToInt32(dataRow["ID"].ToString());
aVaccin.Name = dataRow["VaccineName"].ToString();
aVaccin.StartDay = Convert.ToInt32(dataRow["StartDay"].ToString());
aVaccin.EndDay = Convert.ToInt32(dataRow["EndDay"].ToString());
aVaccin.Description = dataRow["Description"].ToString();
}
return aVaccin;
}
public void EnregistrerVaccin(string nam, string type)
{
var memePatient = Contexte.Vaccins.Where(v => v.NAMPatient == nam);
if (memePatient.Count() > 1)
{
throw new ArgumentException("Patient déjà vacciné deux fois");
}
if (memePatient.Count() == 1 && memePatient.First().Type != type)
{
throw new ArgumentException("Un patient ne peut pas recevoir deux types de vaccins");
}
Vaccin v = new Vaccin
{
NAMPatient = nam,
Type = type,
Date = DateTime.Now
};
Contexte.Vaccins.Add(v);
Contexte.SaveChanges();
}
public void Peupler()
{
if (Contexte.Vaccins.Count() == 0)
{
Vaccin dose1Mylene = new Vaccin
{
Date = new DateTime(2021, 01, 24),
NAMPatient = "LAPM12345678",
Type = "Moderna"
};
Vaccin dose1Gaston = new Vaccin
{
Date = new DateTime(2021, 01, 15),
NAMPatient = "BHEG12345678",
Type = "Pfizer"
};
Contexte.Vaccins.Add(dose1Mylene);
Contexte.Vaccins.Add(dose1Gaston);
Contexte.SaveChanges();
}
}
public void Peupler()
{
if (DaoVaccin.ObtenirVaccins().Count() == 0)
{
Vaccin dose1Mylene = new Vaccin
{
Date = new DateTime(2021, 01, 24),
NAMPatient = "LAPM12345678",
Type = "Moderna"
};
Vaccin dose1Gaston = new Vaccin
{
Date = new DateTime(2021, 01, 15),
NAMPatient = "BHEG12345678",
Type = "Pfizer"
};
DaoVaccin.AjouterVaccin(dose1Mylene);
DaoVaccin.AjouterVaccin(dose1Gaston);
DaoVaccin.Sauvegarder();
}
}
public Bareme Ajouter(string codeGroupement, string dateVigueur, string typeActe, string libelle,
decimal tarifFixe, decimal tarifMini, decimal tarifMaxi, Vaccin vaccin, bool archive)
{
Bareme bareme = new Bareme(codeGroupement, dateVigueur, typeActe, libelle,
tarifFixe, tarifMini, tarifMaxi, vaccin, archive);
Database.Instance.insert(bareme);
return(bareme);
}
public bool SupprimerVaccin(Vaccin vaccin)
{
return(VaccinStore.Instance.Supprimer(vaccin));
}
public void ModifierVaccin(Vaccin vaccin, string nomVaccin, int quantiteStock, byte periodeValidite, bool archive)
{
VaccinStore.Instance.Modifier(vaccin, nomVaccin, quantiteStock, periodeValidite, archive);
}
public void AjouterVaccin(Vaccin v)
{
contexte.Vaccins.Add(v);
}
public bool Supprimer(Vaccin vaccin)
{
return(Database.Instance.delete(vaccin));
}
// PUT api/Vaccination/5
//public void Put(int id, [FromBody]string value)
//{
//}
public HttpResponseMessage Put(Vaccin aVaccin)
{
if (ModelState.IsValid)
{
//db.Entry(model).State = System.Data.Entity.EntityState.Modified;
//db.SaveChanges();
//UPDATE `tikaappdb`.`vaccination` SET `start_day`=30 WHERE `id`=2;
string query1 = "UPDATE vaccineinfo SET VaccineName=@name, StartDay=@start_day, EndDay=@end_time,Description=@description WHERE ID=@id;";
Hashtable aHashtable = new Hashtable();
aHashtable.Add("name",aVaccin.Name);
aHashtable.Add("start_day", aVaccin.StartDay);
aHashtable.Add("end_time", aVaccin.EndDay);
aHashtable.Add("id", aVaccin.ID);
aHashtable.Add("description", aVaccin.Description);
aGateway.Update(query1,aHashtable);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, aVaccin);
return response;
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
}
//// POST api/<controller>
//public void Post([FromBody]string value)
//{
//}
// POST api/employee
public HttpResponseMessage Post(Vaccin aVaccin)
{
if (ModelState.IsValid)
{
//db.Employees.Add(model);
//db.SaveChanges();
string query = "INSERT INTO vaccineinfo (VaccineName, StartDay, EndDay,Description) VALUES (@name, @start_day, @end_day,@description);";
Hashtable aHashtable = new Hashtable();
aHashtable.Add("name", aVaccin.Name);
aHashtable.Add("start_day", aVaccin.StartDay);
aHashtable.Add("end_day", aVaccin.EndDay);
aHashtable.Add("description", aVaccin.Description);
aGateway.Insert(query, aHashtable);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, aVaccin);
return response;
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
}
public JsonResult SaveRisk(
int Id,
Vaccin? Vaccin,
bool? HDisease,
bool? Diabetes,
bool? Neuro,
bool? Asthma,
bool? Pulmonary,
bool? Liver,
bool? Renal,
bool? Immunsupp,
bool? ParaCerebral,
bool? Indigena,
bool? TrabSalud,
bool? Desnutricion,
bool? Prematuridad,
bool? BajoPesoNacer,
bool? AusLacMat,
Pregnant? Pregnant,
bool? Pperium,
Trimester? Trimester,
int? PregnantWeek,
bool? Smoking,
bool? Alcohol,
bool? DownSyn,
Obesity? Obesity,
string OtherRisk,
int? VacInfluenza,
DateTime? VacInfluenzaDateFirst,
DateTime? VacInfluenzaDateSecond,
int? VacBcg,
DateTime? VacBcgDate,
int? VacBcgDosis,
int? VacNeumococo,
DateTime? VacNeumococoDate,
int? VacNeumococoDosis,
int? VacTosFerina,
DateTime? VacTosFerinaDate,
int? VacTosFerinaDosis,
int? VacHaemophilus,
DateTime? VacHaemophilusDate,
int? VaccinFuente,
int? AntiViral,
DateTime? AntiViralDate,
DateTime? AntiViralDateEnd,
int? AntiViralType,
int? OseltaDose,
string AntiViralDose,
int? RiskFactors
)
{
FluCase flucase;
flucase = db.FluCases.Find(Id);
if (flucase == null)
{
flucase = new FluCase();
db.Entry(flucase).State = EntityState.Added;
}
else
{
db.Entry(flucase).State = EntityState.Modified;
}
flucase.Vaccin = Vaccin;
flucase.HDisease = HDisease;
flucase.Diabetes = Diabetes;
flucase.Neuro = Neuro;
flucase.Asthma = Asthma;
flucase.Pulmonary = Pulmonary;
flucase.Liver = Liver;
flucase.Renal = Renal;
flucase.Immunsupp = Immunsupp;
flucase.ParaCerebral = ParaCerebral;
flucase.Indigena = Indigena;
flucase.TrabSalud = TrabSalud;
flucase.Desnutricion = Desnutricion;
flucase.Prematuridad = Prematuridad;
flucase.BajoPesoNacer = BajoPesoNacer;
flucase.AusLacMat = AusLacMat;
flucase.Pregnant = Pregnant;
flucase.Pperium = Pperium;
flucase.Trimester = Trimester;
flucase.PregnantWeek = PregnantWeek;
flucase.Smoking = Smoking;
flucase.Alcohol = Alcohol;
flucase.DownSyn = DownSyn;
flucase.Obesity = Obesity;
flucase.OtherRisk = OtherRisk;
flucase.InsertDate = DateTime.Now;
//flucase.UserID = User.Identity.Name;
//flucase.VacInfluenza = (VacInfluenza.ToString() == null) ? VacInfluenza : (VaccineOptions)Enum.Parse(typeof(VaccineOptions), VacInfluenza.ToString());
flucase.VacInfluenza = VacInfluenza;
flucase.VacInfluenzaDateFirst = VacInfluenzaDateFirst;
flucase.VacInfluenzaDateSecond = VacInfluenzaDateSecond;
if (VacBcg != null) flucase.VacBcg = (VaccineOptions)Enum.Parse(typeof(VaccineOptions), VacBcg.ToString());
flucase.VacBcgDate = VacBcgDate;
flucase.VacBcgDosis = VacBcgDosis;
if (VacNeumococo != null) flucase.VacNeumococo = (VaccineOptions)Enum.Parse(typeof(VaccineOptions), VacNeumococo.ToString());
flucase.VacNeumococoDate = VacNeumococoDate;
flucase.VacNeumococoDosis = VacNeumococoDosis;
if (VacTosFerina != null) flucase.VacTosFerina = (VaccineOptions)Enum.Parse(typeof(VaccineOptions), VacTosFerina.ToString());
flucase.VacTosFerinaDate = VacTosFerinaDate;
flucase.VacTosFerinaDosis = VacTosFerinaDosis;
if (VacHaemophilus != null) flucase.VacHaemophilus = (VaccineOptions)Enum.Parse(typeof(VaccineOptions), VacHaemophilus.ToString());
flucase.VacHaemophilusDate = VacHaemophilusDate;
flucase.VaccinFuente = VaccinFuente;
if (AntiViral != null) flucase.AntiViral = (VaccineOptions)Enum.Parse(typeof(VaccineOptions), AntiViral.ToString());
flucase.AntiViralDate = AntiViralDate;
flucase.AntiViralDateEnd = AntiViralDateEnd;
flucase.AntiViralType = AntiViralType;
flucase.OseltaDose = OseltaDose;
flucase.AntiViralDose = AntiViralDose;
if (AntiViral != null) flucase.RiskFactors = (RiskFactor)Enum.Parse(typeof(RiskFactor), RiskFactors.ToString());
db.SaveChanges();
return Json("Success");
}
public ActionResult Edit([Bind(Include = "ID_Consultation,dateCreation,motif,note,poids,taille,temperature,systol,diastol,diagnostique,maladie,ID_Patient,ID_Staff")] Consultation consultation
/*[Bind(Include = "id_audit,ID_Consultation,ID_Staff,change_date,change_by")] Audit_Consultation ac*/)
{
//string medicament = (from o in db.Ordonnances where o.ID_Consultation == consultation.ID_Consultation select new { o.medicament }).Single().medicament;
//string prescription = (from o in db.Ordonnances where o.ID_Consultation == consultation.ID_Consultation select new { o.prescription }).Single().prescription;
//string vaccin = (from v in db.Vaccins where v.ID_Consultation == consultation.ID_Consultation select new { v.description }).Single().description;
//consultation.vaccin.description = getVaccin(consultation.ID_Consultation);
//consultation.ordonnance.prescription = getPrecription(consultation.ID_Consultation);
//consultation.ordonnance.medicament = getMedicament(consultation.ID_Consultation);
if (ModelState.IsValid)
{
db.Entry(consultation).State = EntityState.Modified;
//ac.ID_Consultation = consultation.ID_Consultation;
//ac.ID_Staff = consultation.ID_Staff;
//ac.change_date = DateTime.Now;
Vaccin v = new Vaccin();
Ordonnance o = new Ordonnance();
Antecedent ant = new Antecedent();
var changeBy = (from s in db.Staffs where s.ID_Staff == consultation.ID_Staff select new { s.nom, s.prenom }).Single();
consultation.changeBy = changeBy.nom + " " + changeBy.prenom;
consultation.changeDate = DateTime.Now;
//db.Audit_Consultation.Add(ac);
string viewAntecedent = Request["antecedent.description"].ToString();
string viewVaccin = Request["vaccin.description"].ToString();
string viewPrescription = Request["ordonnance.prescription"].ToString();
string viewMedicament = Request["ordonnance.medicament"].ToString();
int idVac = db.Vaccins.Where(id => id.ID_Consultation == consultation.ID_Consultation).Select(x => x.ID_Vaccin).DefaultIfEmpty(0).First();
int idOrd = db.Ordonnances.Where(id => id.ID_Consultation == consultation.ID_Consultation).Select(x => x.ID_Ordonnance).DefaultIfEmpty(0).First();
int idAnt = db.Antecedents.Where(id => id.ID_Consultation == consultation.ID_Consultation).Select(x => x.ID_Antecedent).DefaultIfEmpty(0).First();
if (idAnt > 0)
{
if (!string.IsNullOrEmpty(viewAntecedent))
{
db.Database.ExecuteSqlCommand("Update Antecedents set description='" + viewAntecedent + "' where ID_Antecedent =" + idAnt);
}
}
if (idAnt == 0)
{
if (!string.IsNullOrEmpty(viewAntecedent))
{
ant.description = viewAntecedent.ToString();
ant.ID_Consultation = consultation.ID_Consultation;
ant.ID_Patient = consultation.ID_Patient;
db.Antecedents.Add(ant);
}
}
if (idVac > 0)
{
if (!string.IsNullOrEmpty(viewVaccin))
{
db.Database.ExecuteSqlCommand("Update Vaccins set description='" + viewVaccin.ToString() + "' where ID_Vaccin =" + idVac);
}
}
if (idVac == 0)
{
if (!string.IsNullOrEmpty(viewVaccin))
{
v.description = viewVaccin.ToString();
v.ID_Consultation = consultation.ID_Consultation;
v.ID_PATIENT = consultation.ID_Patient;
v.date = DateTime.Now;
db.Vaccins.Add(v);
}
}
if (idOrd > 0)
{
if (!string.IsNullOrEmpty(viewPrescription))
{
db.Database.ExecuteSqlCommand("Update Ordonnances set prescription='" + viewPrescription.ToString() + "' where ID_Ordonnance =" + idOrd);
}
//else
//{
// db.Database.ExecuteSqlCommand("Update Ordonnances set prescription='' where ID_Ordonnance =" + idOrd);
//}
if (!string.IsNullOrEmpty(viewMedicament))
{
db.Database.ExecuteSqlCommand("Update Ordonnances set medicament='" + viewMedicament.ToString() + "' where ID_Ordonnance =" + idOrd);
}
}
if (idOrd == 0)
{
if (!string.IsNullOrEmpty(viewPrescription))
{
o.prescription = viewPrescription.ToString();
o.ID_Consultation = consultation.ID_Consultation;
db.Ordonnances.Add(o);
}
if (!string.IsNullOrEmpty(viewMedicament))
{
o.medicament = viewMedicament.ToString();
o.ID_Consultation = consultation.ID_Consultation;
db.Ordonnances.Add(o);
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_Patient = new SelectList(db.Patients, "ID_Patient", "nom", consultation.ID_Patient);
ViewBag.ID_Staff = new SelectList(db.Staffs, "ID_Staff", "nom", consultation.ID_Staff);
return(View(consultation));
}
public ActionResult Edit([Bind(Include = "ID_Consultation,creatieDate,createBy,changeDate,changeBy,motif,note,poids,taille,temperature,systol,diastol,diagnostique,maladie,antecedent,statut,ID_Patient,ID_Staff")] Consultation consultation)
{
if (ModelState.IsValid)
{
db.Entry(consultation).State = EntityState.Modified;
Ordonnance ordonnance = new Ordonnance();
Vaccin vaccin = new Vaccin();
string currentOrdPrescription = db.Ordonnances.Where(x => x.ID_Consultation == consultation.ID_Consultation).Select(x => x.prescription).DefaultIfEmpty("").First();
string currentOrdMedicament = db.Ordonnances.Where(x => x.ID_Consultation == consultation.ID_Consultation).Select(x => x.medicament).DefaultIfEmpty("").First();
string currentVacDescription = db.Vaccins.Where(x => x.ID_Consultation == consultation.ID_Consultation).Select(x => x.description).DefaultIfEmpty("").First();
string ordPrescription = Request["ordonnance.prescription"];
string ordMedicament = Request["ordonnance.medicament"];
string vacDescription = Request["vaccin.description"];
int idOrdonnance = db.Ordonnances.Where(x => x.ID_Consultation == consultation.ID_Consultation).Select(x => x.ID_Ordonnance).DefaultIfEmpty(0).First();
int idVaccin = db.Vaccins.Where(x => x.ID_Consultation == consultation.ID_Consultation).Select(x => x.ID_Vaccin).DefaultIfEmpty(0).First();
if (idOrdonnance > 0)
{
if (!string.IsNullOrEmpty(ordPrescription) || !string.IsNullOrEmpty(ordMedicament))
{
db.Database.ExecuteSqlCommand("Update Ordonnance set prescription='" + ordPrescription +
"',medicament='" + ordMedicament +
"' where ID_Consultation =" + consultation.ID_Consultation);
}
}
else
{
ordonnance.prescription = ordPrescription;
ordonnance.medicament = ordMedicament;
ordonnance.ID_Consultation = consultation.ID_Consultation;
db.Ordonnances.Add(ordonnance);
}
if (idVaccin > 0)
{
if (!string.IsNullOrEmpty(vacDescription))
{
db.Database.ExecuteSqlCommand("Update Vaccin set description='" + vacDescription +
"' where ID_Consultation =" + consultation.ID_Consultation);
}
}
else
{
vaccin.description = vacDescription;
vaccin.ID_Consultation = consultation.ID_Consultation;
db.Vaccins.Add(vaccin);
}
//---------------------------------------------------------- https://stackoverflow.com/questions/22246538/access-claim-values-in-controller-in-mvc-5
//Get the current claims principal
var identity = (ClaimsPrincipal)Thread.CurrentPrincipal;
// Get the claims values
var name = identity.Claims.Where(c => c.Type == ClaimTypes.Name)
.Select(c => c.Value).SingleOrDefault();
var uid = identity.Claims.Where(c => c.Type == ClaimTypes.Sid)
.Select(c => c.Value).SingleOrDefault();
var role = identity.Claims.Where(c => c.Type == ClaimTypes.Role)
.Select(c => c.Value).SingleOrDefault();
//-----------------------------------------------------------------
consultation.changeBy = name + " - ID: " + uid + " - Role:" + role;
consultation.changeDate = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(consultation));
}
/// <summary>
/// Vérifie les champs saisis puis créé le nouveau vaccin et le barème correspondant
/// </summary>
private void BTN_Valider_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(TBox_Nom.Text.Trim()))
{
errorSaisie.SetError(TBox_Nom, "Veuillez saisir un Nom.");
}
else
{
if (String.IsNullOrEmpty(DUP_Période.Text.Trim()))
{
errorSaisie.SetError(DUP_Période, "Veuillez saisir une Période de Validité.");
}
else
{
if (String.IsNullOrEmpty(DUP_Quantité.Text.Trim()))
{
errorSaisie.SetError(DUP_Quantité, "Veuillez saisir une Quantité.");
}
else
{
// Validation et création du nouveau vaccin et du barème correspondant
if (CBox_TypeTarif.SelectedIndex == 0)
{
// Vérification de la validité de la valeur saisie, pas de lettre et pas de 0
Decimal parsedValue;
if (String.IsNullOrEmpty(TBox_TarifFixe.Text.Trim()))
{
errorSaisie.SetError(TBox_TarifFixe, "Veuillez saisir un Tarif.");
}
else
{
if (!Decimal.TryParse(TBox_TarifFixe.Text, out parsedValue) || (Decimal.Parse(TBox_TarifFixe.Text) == 0))
{
errorSaisie.SetError(TBox_TarifFixe, "Veuillez saisir un Prix valide !");
TBox_TarifFixe.Text = "0,00";
}
else
{
errorSaisie.Clear();
Nom = TBox_Nom.Text;
Validite = int.Parse(DUP_Période.Text);
Quantite = int.Parse(DUP_Quantité.Text);
Fixe = Decimal.Parse(TBox_TarifFixe.Text);
Mini = Decimal.Parse(TBox_TarifMini.Text);
Maxi = Decimal.Parse(TBox_TarifMaxi.Text);
Vaccin newVaccin = new Vaccin(new Guid(), Nom, Quantite, Validite);
Guid vaccinCree = MgtVaccin.CreateVaccin(newVaccin);
int prochainCodeGroupement = MgtBareme.GetDernierCodeVaccin();
Bareme newBareme = new Bareme(prochainCodeGroupement.ToString(), DateTime.Now.ToString("dd/mm/yy"), "VACC", String.Format("Vaccination {0}", Nom), Fixe, 0, 0, vaccinCree.ToString());
MgtBareme.AddBareme(newBareme);
this.Close();
}
}
}
else if (CBox_TypeTarif.SelectedIndex == 1)
{
Decimal parsedValue;
if (String.IsNullOrEmpty(TBox_TarifMaxi.Text.Trim()))
{
errorSaisie.SetError(TBox_TarifMaxi, "Veuillez saisir un Tarif maximum.");
}
else
{
// Vérification de la validité de la valeur saisie, pas de lettre et pas de 0
if (!Decimal.TryParse(TBox_TarifMaxi.Text, out parsedValue) || (Decimal.Parse(TBox_TarifMaxi.Text) == 0))
{
errorSaisie.SetError(TBox_TarifMaxi, "Veuillez saisir un Prix valide !");
TBox_TarifMaxi.Text = "0,00";
}
else
{
if (String.IsNullOrEmpty(TBox_TarifMini.Text.Trim()))
{
errorSaisie.SetError(TBox_TarifMini, "Veuillez saisir un Tarif minimum.");
}
else
{
// Vérification de la validité de la valeur saisie, pas de lettre et pas de 0
if (!Decimal.TryParse(TBox_TarifMini.Text, out parsedValue) || (Decimal.Parse(TBox_TarifMini.Text) == 0))
{
errorSaisie.SetError(TBox_TarifMini, "Veuillez saisir un Prix valide !");
TBox_TarifMini.Text = "0,00";
}
else
{
errorSaisie.Clear();
Nom = TBox_Nom.Text;
Validite = int.Parse(DUP_Période.Text);
Quantite = int.Parse(DUP_Quantité.Text);
Fixe = Decimal.Parse(TBox_TarifFixe.Text);
Mini = Decimal.Parse(TBox_TarifMini.Text);
Maxi = Decimal.Parse(TBox_TarifMaxi.Text);
Vaccin newVaccin = new Vaccin(new Guid(), Nom, Quantite, Validite);
Guid vaccinCree = MgtVaccin.CreateVaccin(newVaccin);
int prochainCodeGroupement = MgtBareme.GetDernierCodeVaccin();
Bareme newBareme = new Bareme(prochainCodeGroupement.ToString(), DateTime.Now.ToString("dd/mm/yy"), "VACC", String.Format("Vaccination {0}", Nom), 0, Mini, Maxi, vaccinCree.ToString());
MgtBareme.AddBareme(newBareme);
this.Close();
}
}
}
}
}
}
}
}
}
public void Modifier(Bareme bareme, string typeActe, string libelle,
decimal tarifFixe, decimal tarifMini, decimal tarifMaxi, Vaccin vaccin)
{
bareme.TypeActe = typeActe;
bareme.Libelle = libelle;
bareme.TarifFixe = tarifFixe;
bareme.TarifMini = tarifMini;
bareme.TarifMaxi = tarifMaxi;
Database.Instance.update(bareme);
}
