public ActionResult Reteta(IList <RetetaModel> retete)
{
foreach (RetetaModel reteta in retete)
{
RetetaModel retetaDB = db.Reteta.Find(reteta.Id);
retetaDB.MedicamentRetras1 = retetaDB.MedicamentRetras1 == false ? reteta.MedicamentRetras1 : true;
retetaDB.MedicamentRetras2 = retetaDB.MedicamentRetras2 == false ? reteta.MedicamentRetras2 : true;
retetaDB.MedicamentRetras3 = retetaDB.MedicamentRetras3 == false ? reteta.MedicamentRetras3 : true;
retetaDB.MedicamentRetras4 = retetaDB.MedicamentRetras4 == false ? reteta.MedicamentRetras4 : true;
retetaDB.MedicamentRetras5 = retetaDB.MedicamentRetras5 == false ? reteta.MedicamentRetras5 : true;
if (((retetaDB.Medicament1 != null && retetaDB.MedicamentRetras1) || retetaDB.Medicament1 == null) &&
((retetaDB.Medicament2 != null && retetaDB.MedicamentRetras2) || retetaDB.Medicament2 == null) &&
((retetaDB.Medicament3 != null && retetaDB.MedicamentRetras3) || retetaDB.Medicament3 == null) &&
((retetaDB.Medicament4 != null && retetaDB.MedicamentRetras4) || retetaDB.Medicament4 == null) &&
((retetaDB.Medicament5 != null && retetaDB.MedicamentRetras5) || retetaDB.Medicament5 == null)
)
{
retetaDB.Retras = true;
}
retetaDB.DataRetragere = DateTime.Now;
db.Entry(retetaDB).State = EntityState.Modified;
db.SaveChanges();
}
Istoric istoric = db.Istoric.Find(retete.FirstOrDefault(_ => _.IstoricId > 0).IstoricId);
return(RedirectToAction("Home", "Farmacist"));//Reteta("1940218020097");//retete.FirstOrDefault(_ => _.IstoricId > 0).IstoricId;
}
private string createEmail(Istoric istoric, RetetaModel reteta, Pacient pacient, Medic medic)
{
string mesaj = $"Bună ziua {pacient.Prenume} {pacient.Nume},\n\n" +
$"V-a fost eliberată o rețetă de către Doctor {medic.Prenume} {medic.Nume} pentru următorul diagnostic: \n" +
$" -Data: {istoric.Data}.\n" +
$" -Diagnostic: {istoric.Diagnostic}.\n" +
$" -Tratament: {istoric.Tratament}\n" +
$" -Zile de spitalizare: {istoric.ZileSpitalizare}\n\n" +
$"Aceasta conține:\n";
if (reteta.Medicament1 != null)
{
mesaj = mesaj + $" -{reteta.Medicament1} cu administrarea: {reteta.Administrare1}\n";
}
if (reteta.Medicament2 != null)
{
mesaj = mesaj + $" -{reteta.Medicament2} cu administrarea: {reteta.Administrare2}\n";
}
if (reteta.Medicament3 != null)
{
mesaj = mesaj + $" -{reteta.Medicament3} cu administrarea: {reteta.Administrare3}\n";
}
if (reteta.Medicament4 != null)
{
mesaj = mesaj + $" -{reteta.Medicament4} cu administrarea: {reteta.Administrare4}\n";
}
if (reteta.Medicament5 != null)
{
mesaj = mesaj + $" -{reteta.Medicament5} cu administrarea: {reteta.Administrare5}\n";
}
mesaj = mesaj + $"\nAceasta poate fii eliberată la orice farmacie pe baza buletinului.\n" +
$"Vă rugăm să contactați medicul de familie în caz de orice nelămurire la numărul de telefon: {medic.Numartelefon}\n\n" +
$"Vă mulțumim!";
return(mesaj);
}
public ActionResult EditIstoric(Istoric istoric)
{
if (ModelState.IsValid)
{
//dateAdministratorModel = CalculeazaTaxe(ref dateAdministratorModel);
db.Entry(istoric).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", "Pacient", new { id = istoric.PacientCNP }));
}
return(View(istoric));
}
public ActionResult Diagnostic(Istoric istoric)
{
if (ModelState.IsValid)
{
//dateAdministratorModel = CalculeazaTaxe(ref dateAdministratorModel);
db.Entry(istoric).State = EntityState.Added;
db.SaveChanges();
return(RedirectToAction("Index", new { message = "Editat cu succes!" }));
}
return(View(istoric));
}
public ActionResult DetailsReteta(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Istoric istoric = db.Istoric
.Include(_ => _.Retete)
.Where(_ => _.IstoricId == id)
.FirstOrDefault();
//List<RetetaModel> retete = new List<RetetaModel>();
//foreach (RetetaModel reteta in istoric.Retete)
//{
// rete
//}
return(View(istoric.Retete));
}
// GET: Salariat/Edit/5
public ActionResult Diagnostic(string id)
{
//if (id == null)
//{
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
//}
//Istoric istoric = db.Istoric.Where(p => p.PacientCNP == id).FirstOrDefault();
//if (istoric == null)
//{
// return HttpNotFound();
//}
Istoric newIstoric = new Istoric()
{
//IstoricId = istoric.IstoricId,
PacientCNP = id,
Data = DateTime.Now
};
return(View(newIstoric));
}
public ActionResult EditIstoric(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Istoric istoric = db.Istoric.Find(id);
if (istoric == null)
{
return(HttpNotFound());
}
//Istoric newIstoric = new Istoric()
//{
// //IstoricId = istoric.IstoricId,
// PacientCNP = id,
// Data = DateTime.Now
//};
return(View(istoric));
}
public ActionResult Reteta(RetetaModel reteta)
{
if (ModelState.IsValid)
{
//dateAdministratorModel = CalculeazaTaxe(ref dateAdministratorModel);
reteta.DataEmitere = DateTime.Now;
reteta.DataRetragere = DateTime.Now;
db.Entry(reteta).State = EntityState.Added;
db.SaveChanges();
Istoric istoric = db.Istoric.Find(reteta.IstoricId);
Pacient pacient = db.Pacient.Find(istoric.PacientCNP);
string guid = User.Identity.GetUserId();
Medic medic = db.Medic.Where(_ => _.accountGuid.ToString() == guid).FirstOrDefault();
string email = createEmail(istoric, reteta, pacient, medic);
sendRetetaInEmail(pacient.Email, email);
return(RedirectToAction("Details", "Pacient", new { id = istoric.PacientCNP }));
}
return(View(reteta));
}
private void Clear_Click(object sender, EventArgs e)
{
result.Clear();
Istoric.Clear();
value = 0;
}
// every day at 00:00:00
public static void Run([TimerTrigger("0 0 0 * * *")] TimerInfo myTimer, TraceWriter log)
{
double tempmin, tempmax, tempavg, umidmin, umidmax, umidavg;
int count;
using (IrigationDBEntities1 context = new IrigationDBEntities1())
{
// .Include(val => val.Values).Include(val => val.Istorics)
List <Senzori> senzoriList = context.Senzoris.ToList();
foreach (Senzori s in senzoriList)
{
tempmin = 100;
tempmax = -100;
tempavg = 0;
umidmin = 100;
umidmax = 0;
umidavg = 0;
List <Value> valuesList = context.Values.Where(v => v.Id_senzor == s.Id).ToList();
//list.ForEach(x => x.Senzori = null);
count = valuesList.Count;
foreach (Value v in valuesList)
{
tempavg += (double)v.Temperatura;
umidavg += (double)v.Umiditate;
if (v.Umiditate > umidmax)
{
umidmax = (double)v.Umiditate;
}
if (v.Temperatura > tempmax)
{
tempmax = (double)v.Temperatura;
}
if (v.Umiditate < umidmin)
{
umidmin = (double)v.Umiditate;
}
if (v.Temperatura < tempmin)
{
tempmin = (double)v.Temperatura;
}
//delete value
context.Values.Remove(v);
context.SaveChanges();
}
umidavg /= count;
tempavg /= count;
Istoric istoric = new Istoric();
istoric.Id_senzor = s.Id;
istoric.MaxTemperatura = tempmax;
istoric.MinTemperatura = tempmin;
istoric.MedieTemperatura = tempavg;
istoric.MaxUmiditate = umidmax;
istoric.MaxUmiditate = umidmax;
istoric.MedieUmiditate = umidavg;
istoric.Data = DateTime.Now;
context.Istorics.Add(istoric);
context.SaveChanges();
}
}
//log.Info($"C# Timer trigger function executed at: {DateTime.Now}");
}
