//get all dosage info
public IEnumerable <drug_dosage> Get()
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.drug_dosage.ToList());
}
}
//get all users (can be used for admin accs)
public IEnumerable <user> Get()
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.user.ToList());
}
}
//get all comments (for postman testing)
public IEnumerable <forum_comment> Get()
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.forum_comment.ToList());
}
}
//Get report by patient id
public IEnumerable <patient_report> GetByPatient(int patientid)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.patient_report.Where(s => s.patient_id == patientid).ToList());
}
}
//add new patient report
public void POST(patient_report report)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
entities.patient_report.Add(report);
//entities.SaveChanges();
try
{
entities.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
//get one patient report (can be used for patient-only accs)
public patient_report Get(int id)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.patient_report.FirstOrDefault(e => e.report_id == id));
}
}
//get all patient reports (can be used for doctor-only accs)
public IEnumerable <patient_report> Get()
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.patient_report.ToList());
}
}
// Get notification by patient id
public IEnumerable <notification> GetByPatientId(int patientid)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.notification.Where(s => s.patient_id == patientid).ToList());
}
}
//get comments via comment forumid
public IEnumerable <forum_comment> Get(int id)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.forum_comment.Where(s => s.forum_id == id).ToList());
}
}
//get one user info from firebase unique ID (to be done on javascript)
public user Get(string id)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.user.FirstOrDefault(e => e.user_id == id));
}
}
//get one disease info
public disease_information Get(string id)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.disease_information.FirstOrDefault(e => e.disease == id));
}
}
//get all forum posts based on disease name
public IEnumerable <disease_forum> Get(string disease)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.disease_forum.Where(s => s.disease_name == disease).ToList());
}
}
//get one patient info via firebase UID (can be used for patient-only accs)
public diagnosis GetDiagnosis(int diagnosisid)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.diagnosis.FirstOrDefault(s => s.diagnosis_id == diagnosisid));
}
}
//get all disease infos
public IEnumerable <disease_information> Get()
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.disease_information.ToList());
}
}
//get one patient info via firebase UID (can be used for patient-only accs)
public patient_information Get(string id)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.patient_information.FirstOrDefault(e => e.user_id == id));
}
}
// GET all notification
public IEnumerable <notification> Get()
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.notification.ToList());
}
}
//get all patient's diagnosis (get specific done in js)
public IEnumerable <diagnosis> Get()
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.diagnosis.ToList());
}
}
//get patient informations via patient id(can be used for doctor-only accs)
public IEnumerable <patient_information> GetByDoctor(string doctorid)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.patient_information.Where(s => s.doctor_id == doctorid).ToList());
}
}
//get one forum post
public disease_forum Get(int id)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.disease_forum.FirstOrDefault(e => e.idForum == id));
}
}
//get patient diagnosis via patient id
public IEnumerable <diagnosis> Get(int id)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
return(entities.diagnosis.Where(s => s.patient_id == id).ToList());
}
}
//add patient diagnosis (done when patient signs up)
public void POST(diagnosis diagnose)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
entities.diagnosis.Add(diagnose);
entities.SaveChanges();
}
}
//add new disease info
public void POST(disease_information disease)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
entities.disease_information.Add(disease);
entities.SaveChanges();
}
}
//add new patient
public void POST(patient_information info)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
entities.patient_information.Add(info);
entities.SaveChanges();
}
}
//add new user
public void POST(user info)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
entities.user.Add(info);
entities.SaveChanges();
}
}
//add comment
public void POST(forum_comment foracomment)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
entities.forum_comment.Add(foracomment);
entities.SaveChanges();
}
}
//delete forum post via forum id
//NOTE: if user did not delete forum before removing account, name displayed on post
//will be [deleted], like reddit
public string Delete(int id)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
disease_forum postid = entities.disease_forum.Find(id);
entities.disease_forum.Remove(postid);
entities.SaveChanges();
return("Forum Deleted Successfully");
}
}
//delete diagnosis by diagnosis_id (can be deleted by both user and admins)
public string Delete(int id)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
diagnosis infoid = entities.diagnosis.Find(id);
entities.diagnosis.Remove(infoid);
entities.SaveChanges();
return("Patient info deleted");
}
}
//add forum post
public void POST(disease_forum forumdetails)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
entities.disease_forum.Add(forumdetails);
entities.SaveChanges();
}
}
//delete disease info
public string Delete(string id)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
disease_information disease = entities.disease_information.Find(id);
entities.disease_information.Remove(disease);
entities.SaveChanges();
return("Deleted Successfully");
}
}
//delete dosage via dosage id
public string Delete(int id)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
drug_dosage drugdose = entities.drug_dosage.Find(id);
entities.drug_dosage.Remove(drugdose);
entities.SaveChanges();
return("Deleted Successfully");
}
}
