Beispiel #1
0
        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."));
            }
        }
Beispiel #2
0
        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."));
            }
        }