//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;
}
}
}
//delete report by report_id
public string Delete(int id)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
patient_report reportid = entities.patient_report.Find(id);
entities.patient_report.Remove(reportid);
entities.SaveChanges();
return("Report Deleted Successfully");
}
}
//update report
public void PUT(int id, patient_report report)
{
using (ThyroidDataEntities entities = new ThyroidDataEntities())
{
var report1 = entities.patient_report.Find(id);
report1.FT4 = report.FT4;
report1.TSH = report.TSH;
report1.timestamp = report.timestamp;
entities.Entry(report1).State = System.Data.Entity.EntityState.Modified;
entities.SaveChanges();
}
}