/*Save Patient Meditation, supplement, hospitalization etc.. info*/
public static string SavePatientInfo(string key, string title, Guid _pkey)
{
GuruETCEntities _etc = new GuruETCEntities();
long? ParentId = _etc.PatientProfiles.Where(d => d.UserGuid == _pkey).Select(d => d.Id).FirstOrDefault();
long? ExamId = _etc.PatientExams.Where(d => d.PatientId == ParentId).OrderByDescending(d => d.ExamId).Select(d => d.ExamId).FirstOrDefault();
long? PhealthId = _etc.PatientResultQuestions.Where(d => d.ExamId == ExamId).Select(d => d.PHealthId).FirstOrDefault();
string Result = string.Empty;
switch (key)
{
case "1":
PatientMedication _pmedi = new PatientMedication();
_pmedi.Title = title;
_pmedi.PHealthId = PhealthId; //By default 1 change it dynamically
_pmedi.DateAdded = DateTime.Now;
_etc.AddToPatientMedications(_pmedi);
_etc.SaveChanges();
Result = _pmedi.MedicationId.ToString();
break;
case "2":
PatientSupplement _psup = new PatientSupplement();
_psup.Title = title;
_psup.PHealthId = PhealthId; //By default 1 change it dynamically
_psup.DateAdded = DateTime.Now;
_etc.AddToPatientSupplements(_psup);
_etc.SaveChanges();
Result = _psup.SupplementId.ToString();
break;
case "3":
PatientHospitalized _phos = new PatientHospitalized();
_phos.Title = title;
_phos.PHealthId = PhealthId; //By default 1 change it dynamically
_phos.DateAdded = DateTime.Now;
_etc.AddToPatientHospitalizeds(_phos);
_etc.SaveChanges();
Result = _phos.HospitalizationId.ToString();
break;
}
return(Result);
}
public static string DeletePatientInfo(string key, string delId)
{
GuruETCEntities _etc = new GuruETCEntities();
long GetId = int.Parse(delId);
string Result = string.Empty;
switch (key)
{
case "1":
PatientMedication _pmedi = _etc.PatientMedications.Where(d => d.MedicationId == GetId).FirstOrDefault();
if (_pmedi != null)
{
_etc.DeleteObject(_pmedi);
_etc.SaveChanges();
}
Result = "Success";
break;
case "2":
PatientSupplement _psup = _etc.PatientSupplements.Where(d => d.SupplementId == GetId).FirstOrDefault();
if (_psup != null)
{
_etc.DeleteObject(_psup);
_etc.SaveChanges();
}
Result = "Success";
break;
case "3":
PatientHospitalized _phos = _etc.PatientHospitalizeds.Where(d => d.HospitalizationId == GetId).FirstOrDefault();
if (_phos != null)
{
_etc.DeleteObject(_phos);
_etc.SaveChanges();
}
Result = "Success";
break;
}
return(Result);
}
