public HttpResponseMessage Post([FromBody] JObject barber_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." }); using (SalonDbEntities entities = new SalonDbEntities()) { int barber_id = int.Parse(barber_service_details["barber_id"].ToString()); int service_id = int.Parse(barber_service_details["service_id"].ToString()); // Validate barber - check if the barber service already exists if (entities.tblbarber_service.Any(e => e.barber_id == barber_id && e.service_id == service_id)) { return(Messages.GetInstance().HandleRequest("Barber Service", ActionType.INSERT, true)); } else { using (var transaction = entities.Database.BeginTransaction()) { tblbarber_service obj = new tblbarber_service { barber_id = barber_id, service_id = service_id }; entities.tblbarber_service.Add(obj); entities.SaveChanges(); Utilities.getInstance().UpdateChanges(entities, transaction, obj.barber_service_id.ToString(), typeof(tblbarber).Name, ActionType.INSERT); return(Messages.GetInstance().HandleRequest("Barber Service", ActionType.INSERT)); } } } } catch (Exception) { return(Messages.GetInstance().HandleException("An error occured! Failed to create barber service.")); } }
public HttpResponseMessage GetSelectedBarberService(int barber_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()) { tblbarber_service selectedBarber = entities.tblbarber_service.FirstOrDefault(e => e.barber_service_id == barber_service_id); if (selectedBarber != null) { return(Request.CreateResponse(HttpStatusCode.OK, new { Success = true, Message = "Barber service details retrieved successfully!", Barber_service_details = new { selectedBarber.barber_service_id, selectedBarber.barber_id, barber_name = entities.tblbarbers.Where(x => x.barber_id == selectedBarber.barber_id).Select(x => x.barber_name).First(), selectedBarber.service_id, service_name = entities.tblservices.Where(x => x.service_id == selectedBarber.service_id).Select(x => x.service_name).First() } })); } else { return(Messages.GetInstance().HandleException("Retrieve failed! Barber service with id = ", barber_service_id.ToString())); } } } catch (Exception) { return(Messages.GetInstance().HandleException("An error occured! Failed to retrieve barber service details.")); } }