public HttpResponseMessage Post([FromBody] JObject appointment_service_details)
{
try
{
// Check if a session already exists or if it's expired
//if (HttpContext.Current.Session["Token"] == null)
// return Request.CreateResponse(HttpStatusCode.Unauthorized, new { Success = false, Message = "Session expired! Unable to authenticate user." });
int appointment_id = int.Parse(appointment_service_details["appointment_id"].ToString());
int service_id = int.Parse(appointment_service_details["service_id"].ToString());
using (SalonDbEntities entities = new SalonDbEntities())
{
// Validate appointment - check if the appointment service already exists
if (entities.tblservice_booked.Any(e => e.appointment_id == appointment_id && e.service_id == service_id))
{
return(Messages.GetInstance().HandleRequest("Appointment Service", ActionType.INSERT, true));
}
else
{
using (var transaction = entities.Database.BeginTransaction())
{
tblservice_booked obj = new tblservice_booked
{
appointment_id = appointment_id,
service_id = service_id
};
entities.tblservice_booked.Add(obj);
entities.SaveChanges();
Utilities.getInstance().UpdateChanges(entities, transaction, obj.id.ToString(), typeof(tblservice_booked).Name, ActionType.INSERT);
return(Messages.GetInstance().HandleRequest("Appointment Service", ActionType.INSERT));
}
}
}
}
catch (Exception)
{
return(Messages.GetInstance().HandleException("An error occured! Failed to create appointment service."));
}
}
public HttpResponseMessage GetSelectedAppointmentService(int appointment_service_id)
{
try
{
// Check if a session already exists or if it's expired
//if (HttpContext.Current.Session["Token"] == null)
// return Request.CreateResponse(HttpStatusCode.Unauthorized, new { Success = false, Message = "Session expired! Unable to authenticate user." });
using (SalonDbEntities entities = new SalonDbEntities())
{
tblservice_booked selectedAppointment = entities.tblservice_booked.FirstOrDefault(e => e.id == appointment_service_id);
if (selectedAppointment != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, new
{
Success = true,
Message = "Appointment service details retrieved successfully!",
Appointment_service_details = new
{
selectedAppointment.id,
selectedAppointment.appointment_id,
selectedAppointment.service_id,
service_name = entities.tblservices.Where(x => x.service_id == selectedAppointment.service_id).Select(x => x.service_name).First()
}
}));
}
else
{
return(Messages.GetInstance().HandleException("Retrieve failed! Appointment service with id = ", appointment_service_id.ToString()));
}
}
}
catch (Exception)
{
return(Messages.GetInstance().HandleException("An error occured! Failed to retrieve appointment service details."));
}
}
