public IHttpActionResult CreatePatients(Patient patient)
{
using (var db = new WebApiDemoDb1Entities())
{
if (db.Dentists.Any(p => p.Email == patient.Email || p.Phone == patient.Phone))
{
return(BadRequest("Patient record already exists"));
}
if (!ModelState.IsValid)
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
var dbPatient = patient.ToDatabase();
db.Patients.Add(dbPatient);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
throw;
}
}
return(Ok("Successfully Created Patient Record!"));
}
public IHttpActionResult UpdateDentist(int id, Dentist dentist)
{
using (var db = new WebApiDemoDb1Entities())
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var dbDentist = db.Dentists.SingleOrDefault(x => x.Id == id);
if (dbDentist == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
dbDentist.FirstName = dentist.FirstName;
dbDentist.LastName = dentist.LastName;
dbDentist.Email = dentist.Email;
dbDentist.Phone = dentist.Phone;
db.SaveChanges();
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
throw;
}
}
return(Ok("Dentist Record Updated Successfully!"));
}
public IHttpActionResult CreateDentist(Dentist dentist)
{
using (var db = new WebApiDemoDb1Entities())
{
if (!ModelState.IsValid)
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
if (db.Dentists.Any(d => d.Phone == dentist.Phone || d.Email == dentist.Email))
{
return(BadRequest("Record already exists!"));
}
var dbDentist = dentist.ToDatabase();
db.Dentists.Add(dbDentist);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
throw;
}
}
return(Ok("Dentist Reord Created Successfully!"));
}
public IHttpActionResult GetDentist(int id)
{
using (WebApiDemoDb1Entities db = new WebApiDemoDb1Entities())
{
var dbDentist = db.Dentists.SingleOrDefault(d => d.Id == id);
if (dbDentist == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
return(Ok(dbDentist.ToContract()));
}
}
public IEnumerable <Patient> GetPatientsByDentistId(int id)
{
List <Patient> patients = new List <Patient>();
using (WebApiDemoDb1Entities db = new WebApiDemoDb1Entities())
{
var dbPatient = db.Patients.Where(p => p.DentistId == id).ToList();
if (dbPatient.Count == 0)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
foreach (var row in dbPatient)
{
patients.Add(row.ToContract());
row.ToContract();
}
}
return(patients);
}
public IEnumerable <Dentist> GetDentists()
{
List <Dentist> dentists = new List <Dentist>();
using (WebApiDemoDb1Entities db = new WebApiDemoDb1Entities())
{
var dbDentist = db.Dentists.ToList();
if (dbDentist.Count == 0)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
foreach (var row in dbDentist)
{
dentists.Add(row.ToContract());
row.ToContract();
}
return(dentists);
}
}
public IHttpActionResult DeleteDentist(int id)
{
using (var db = new WebApiDemoDb1Entities())
{
var dbDentist = db.Dentists.SingleOrDefault(d => d.Id == id);
if (dbDentist == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
var dbPatient = db.Patients.SingleOrDefault(p => p.DentistId == id);
if (dbPatient != null)
{
return(BadRequest("Patient Record exists for the Dentist. Update or delete the patient record"));
}
db.Dentists.Remove(dbDentist);
db.SaveChanges();
}
return(Ok("Dentist record Deleted Successfully!"));
}
