/*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); }