public async Task <IHttpActionResult> PutPetSitterService(int id, PetSitterService petSitterService)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != petSitterService.PetSitterServiceNo)
            {
                return(BadRequest());
            }

            db.Entry(petSitterService).State = EntityState.Modified;

            try
            {
                await db.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!PetSitterServiceExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
        public async Task <IHttpActionResult> GetPetSitterService(int id)
        {
            PetSitterService petSitterService = await db.PetSitterServices.FindAsync(id);

            if (petSitterService == null)
            {
                return(NotFound());
            }

            return(Ok(petSitterService));
        }
        public async Task <IHttpActionResult> PostPetSitterService(PetSitterService petSitterService)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.PetSitterServices.Add(petSitterService);
            await db.SaveChangesAsync();

            return(CreatedAtRoute("DefaultApi", new { id = petSitterService.PetSitterServiceNo }, petSitterService));
        }
        public async Task <IHttpActionResult> DeletePetSitterService(int id)
        {
            PetSitterService petSitterService = await db.PetSitterServices.FindAsync(id);

            if (petSitterService == null)
            {
                return(NotFound());
            }

            db.PetSitterServices.Remove(petSitterService);
            await db.SaveChangesAsync();

            return(Ok(petSitterService));
        }
        private async Task <List <PetSitterService> > AddPetSitterService(PetSitter petSitter, string service)
        {
            List <PetSitterService> petSitterServices = new List <PetSitterService>();
            var arr = HttpUtility.UrlDecode(service.ToString()).Split(',');

            for (int i = 0; i < arr.Length; i++)
            {
                PetSitterService petSitterService = new PetSitterService();
                petSitterService.PetSitterNo          = petSitter.PetSitterNo;
                petSitterService.PetSitterServiceCode = int.Parse(arr[i].ToString());
                petSitterServices.Add(petSitterService);
            }

            db.PetSitterServices.AddRange(petSitterServices);
            await db.SaveChangesAsync();

            return(petSitterServices);
        }