private static int SaveToDatabase <T>(T tObject)
{
using (MedicineContext db = new MedicineContext())
{
if (tObject is Diagnoses)
{
db.Diagnoses.Add(tObject as Diagnoses);
}
else if (tObject is Doctors)
{
db.Doctors.Add(tObject as Doctors);
}
else if (tObject is Patients)
{
db.Patients.Add(tObject as Patients);
}
else if (tObject is Diseases)
{
db.Diseases.Add(tObject as Diseases);
}
else
{
throw new TypeLoadException("Тип не распознан!");
}
return(db.SaveChanges());
}
}
public PatientViewModel()
{
this.SavePatientDataCommand = new RelayCommand(this.SavePatientData);
Months = GetMonths();
using (MedicineContext db = new MedicineContext())
{
db.SocialStatuses.Load();
db.Policies.Load();
db.Disabilities.Load();
SocialStatuses = db.SocialStatuses.Local.ToBindingList();
Policies = db.Policies.Local.ToBindingList();
Disabilities = db.Disabilities.Local.ToBindingList();
}
if (SingletonVMP.VMP.Patient == null)
{
Patient = new Patient();
SingletonVMP.VMP.Patient = Patient;
}
else
{
Patient = SingletonVMP.VMP.Patient;
GetBirthday();
GetDisability();
SelectedSocialStatus = SocialStatuses.FirstOrDefault(x => x.Id == Patient.SocialStatusId);
SelectedPolicy = Policies.FirstOrDefault(x => x.Id == Patient.PoliceId);
}
}
public JsonResult GetMedicine()
{
using (MedicineContext db = new MedicineContext())
{
List <Medicine> medList = db.Medicines.ToList();
return(Json(medList, JsonRequestBehavior.AllowGet));
}
}
private static int UpdateDatabase(string p_doctor, string p_patient, string p_disease, string p_number)
{
int sent = 0;
Diagnoses diagnose;
Doctors doctor;
Patients patient;
Diseases disease;
int number = int.Parse(p_number);
using (MedicineContext db = new MedicineContext())
{
diagnose = db.Diagnoses.Where(d => d.Doctors.fullname == p_doctor && d.Diseases.name == p_disease &&
d.Patients.fullname == p_patient && d.number == number).FirstOrDefault();
if (diagnose == null)
{
doctor = db.Doctors.Where(d => d.fullname == p_doctor).FirstOrDefault();
if (doctor == null)
{
doctor = new Doctors()
{
id = Guid.NewGuid(),
fullname = p_doctor
};
sent += SaveToDatabase(doctor);
}
patient = db.Patients.Where(d => d.fullname == p_patient).FirstOrDefault();
if (patient == null)
{
patient = new Patients()
{
id = Guid.NewGuid(),
fullname = p_patient
};
sent += SaveToDatabase(patient);
}
disease = db.Diseases.Where(d => d.name == p_disease).FirstOrDefault();
if (disease == null)
{
disease = new Diseases()
{
id = Guid.NewGuid(),
name = p_disease
};
sent += SaveToDatabase(disease);
}
diagnose = new Diagnoses()
{
id = Guid.NewGuid(),
number = number,
patient = patient.id,
disease = disease.id,
doctor = doctor.id
};
sent += SaveToDatabase(diagnose);
}
}
return(sent);
}
public MedecineViewModel()
{
db = new MedicineContext();
DeleteCommand = new DelegateCommand(DeleteCommandFun);
FindCommand = new DelegateCommand(FindCommandFun);
IsNoBusy = true;
ReloadData();
}
public JsonResult Delete(int id)
{
using (MedicineContext db = new MedicineContext())
{
Medicine medicine = db.Medicines.Find(id);
if (medicine == null)
{
return(Json(new { success = false }));
}
db.Medicines.Remove(medicine);
db.SaveChanges();
return(Json(new { success = true }));
}
}
private void AddPolice_button_Click(object sender, RoutedEventArgs e)
{
if (!string.IsNullOrWhiteSpace(police_textBox.Text))
{
using (MedicineContext db = new MedicineContext())
{
db.Policies.Add(new Policy()
{
Name = police_textBox.Text
});
db.SaveChanges();
}
this.Close();
}
}
private void btnClear_Click(object sender, EventArgs e)
{
string text = "";
using (MedicineContext db = new MedicineContext())
{
int deleted = 0;
deleted += db.Database.ExecuteSqlCommand("DELETE FROM dbo.[Diagnoses]");
deleted += db.Database.ExecuteSqlCommand("DELETE FROM dbo.[Patients]");
deleted += db.Database.ExecuteSqlCommand("DELETE FROM dbo.[Doctors]");
deleted += db.Database.ExecuteSqlCommand("DELETE FROM dbo.[Diseases]");
deleted = deleted / 3;
text += "Удалено: " + deleted.ToString() + " записи.";
}
tbInput.AppendText("\r\n" + text);
}
public JsonResult Insert(Medicine medicine)
{
if (medicine != null)
{
using (MedicineContext db = new MedicineContext())
{
db.Medicines.Add(medicine);
db.SaveChanges();
return(Json(new { success = true }));
}
}
else
{
return(Json(new { success = false }));
}
}
public ObjectivelyViewModel()
{
SelectedDescription = new EyeDescriptionMethod("Оба сразу", true, "0");
EyeDescriptionMethods = new List <EyeDescriptionMethod>()
{
SelectedDescription,
new EyeDescriptionMethod("По отдельности", false, "2*")
};
using (MedicineContext db = new MedicineContext())
{
db.EyeSides.Load();
EyeSides = db.EyeSides.Local.ToBindingList();
}
EyeSide ODSide = EyeSides.FirstOrDefault(x => x.Side == "OD");
EyeSide OSSide = EyeSides.FirstOrDefault(x => x.Side == "OS");
if (SingletonVMP.VMP.Eyes == null)
{
ODEye = new Eye(ODSide);
OSEye = new Eye(OSSide);
Eyes = new List <Eye>();
Eyes.Add(ODEye);
Eyes.Add(OSEye);
SingletonVMP.VMP.Eyes = Eyes;
}
else
{
Eyes = SingletonVMP.VMP.Eyes;
ODEye = Eyes.FirstOrDefault(s => s.EyeSideId == ODSide.Id);
OSEye = Eyes.FirstOrDefault(s => s.EyeSideId == OSSide.Id);
if (ODEye.CompareTo(OSEye) == -1)
{
EyeDescriptionMethods.Clear();
SelectedDescription = new EyeDescriptionMethod("По отдельности", false, "2*");
EyeDescriptionMethods = new List <EyeDescriptionMethod>()
{
new EyeDescriptionMethod("Оба сразу", true, "0"),
SelectedDescription
};
}
}
}
public JsonResult Update(Medicine updatedMedicine)
{
using (MedicineContext db = new MedicineContext())
{
Medicine existingMedicine = db.Medicines.Find(updatedMedicine.ID);
if (existingMedicine == null)
{
return(Json(new { success = false }));
}
else
{
existingMedicine.Name = updatedMedicine.Name;
existingMedicine.Price = updatedMedicine.Price;
existingMedicine.Quantity = updatedMedicine.Quantity;
db.SaveChanges();
return(Json(new { success = true }));
}
}
}
private async void LoadData()
{
await Task.Run(() =>
{
using (MedicineContext db = new MedicineContext())
{
var data = db.VMPs.Include(x => x.Patient);
VMPAll = new List <VMP>();
foreach (var d in data)
{
VMPAll.Add(d);
}
}
});
InfoText = string.Empty;
foreach (var item in VMPAll)
{
VMPList.Add(item);
}
}
public static void Initialize(IServiceProvider serviceProvider)
{
var contextOptionsFromDi = serviceProvider.GetRequiredService <DbContextOptions <MedicineContext> >();
using (var context = new MedicineContext(contextOptionsFromDi))
{
// check if data already present
if (context.Medicines.Any())
{
return;
}
// Seed Data if absent
context.Medicines.AddRange(
new Medicine()
{
Id = 91,
Name = "Med1",
Brand = "brand1",
Price = (decimal)29.12,
Quantity = 10,
ExpiryDate = new DateTime(2020, 01, 01).Date,
Notes = "medicine number 1"
},
new Medicine()
{
Id = 92,
Name = "Med2",
Brand = "brand2",
Price = (decimal)29.13,
Quantity = 20,
ExpiryDate = new DateTime(2020, 01, 02).Date,
Notes = "medicine number 2"
});
context.SaveChangesAsync();
}
}
public ActionResult Create([Bind(Include = "id,M_Name,Image,M_Company,M_Type,M_Potency,M_Details,M_Price")] Medicine medicine, HttpPostedFileBase Image)
{
if (ModelState.IsValid)
{
Medicine m = new Medicine();
MedicineContext db = new MedicineContext();
m.Image = Image.FileName.ToString();
m.M_Name = medicine.M_Name;
m.M_Company = medicine.M_Company;
m.M_Type = medicine.M_Type;
m.M_Potency = medicine.M_Potency;
m.M_Details = medicine.M_Details;
m.M_Price = medicine.M_Price;
var path = Server.MapPath("~/Content/img");
Image.SaveAs(Path.Combine(path, Image.FileName.ToString()));
db.Medicines.Add(m);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(medicine));
}
public TreatmentController(MedicineContext context)
{
_db = context;
}
public SymptomsController([FromServices] MedicineContext context)
{
_context = context;
}
public DiagnosisController(MedicineContext context)
{
_db = context;
}
public PrescriptionController(MedicineContext context)
{
_db = context;
}
public EventInfoController(MedicineContext context)
{
_context = context;
}
public SqlMedicinesData(MedicineContext medicineContext)
{
_medicineContext = medicineContext;
}
public MedicinesController(MedicineContext context, ILoggerFactory loggerFactory)
{
_context = context;
_logger = loggerFactory.CreateLogger <MedicinesController>();
}
public ParameterController(MedicineContext context)
{
_db = context;
}
public PostAdminController([FromServices] MedicineContext context)
{
_context = context;
}
public MedicineInfo(MedicineContext _context)
{
_medicineContext = _context;
}
public PatientController(MedicineContext context)
{
_db = context;
}
public VisitationController([FromServices] MedicineContext context)
{
_context = context;
}
public MedicineInfoController(MedicineContext context)
{
_context = context;
}
public ImportExportController([FromServices] MedicineContext context) : this()
{
_context = context;
}
public ExaminationController(MedicineContext context)
{
_db = context;
}
