public JsonResult AddAppointments(AppointmentJsonObject json) { var status = "ok"; var actualdate = json.date.Replace(@"\", string.Empty); Appointment newAppointment = new Appointment(); if (json.appointmentId.HasValue) { newAppointment = context.Appointment.Find(json.appointmentId); } else { context.Appointment.Add(newAppointment); } using (var trans = new TransactionScope()) { newAppointment.AppointmentDate = Convert.ToDateTime(actualdate); newAppointment.Description = json.description; newAppointment.PetId = Convert.ToInt32(json.petId); newAppointment.VeterinaryId = json.veterinaryId; newAppointment.VetId = json.vetId; newAppointment.Prescription = json.prescription; newAppointment.Status = json.status; context.SaveChanges(); trans.Complete(); } return(Json(new { status = status, appointement = newAppointment }, JsonRequestBehavior.AllowGet)); }
public static List <AppointmentJsonObject> from(List <Appointment> appointments) { List <AppointmentJsonObject> apjs = new List <AppointmentJsonObject>(); foreach (var a in appointments) { apjs.Add(AppointmentJsonObject.from(a)); } return(apjs); }
public static AppointmentJsonObject from(Appointment appointment) { AppointmentJsonObject apj = new AppointmentJsonObject(); apj.appointmentId = appointment.AppointmentId; apj.vetId = appointment.VetId; apj.veterinaryId = appointment.VeterinaryId; apj.petId = appointment.PetId; apj.date = appointment.AppointmentDate.ToString(); apj.description = appointment.Description; apj.prescription = appointment.Prescription; apj.vet = appointment.Vet.Person.Name + " " + appointment.Vet.Person.LastName; apj.veterinary = appointment.Veterinary.Name; apj.pet = appointment.Pet.Name; return(apj); }
public JsonResult Appointments(Int32?petId) { if (petId.HasValue) { return(Json(new { status = "ok", content = AppointmentJsonObject.from(context.Appointment.Where(x => x.PetId == petId).ToList()) }, JsonRequestBehavior.AllowGet )); } else { return(Json(new { status = "ok", content = AppointmentJsonObject.from(context.Appointment.ToList()) }, JsonRequestBehavior.AllowGet )); } //return Json(appointmentId.HasValue ? AppointmentJsonObject.@from(context.Appointment.Where(x => x.AppointmentId == appointmentId).ToList()) : AppointmentJsonObject.@from(context.Appointment.ToList()), JsonRequestBehavior.AllowGet); }