public async Task<IHttpActionResult> PutstoreHoliday(int id, StoreHoliday storeHoliday)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            if (id != storeHoliday.StoreHolidayNo)
            {
                return BadRequest();
            }

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

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

            return StatusCode(HttpStatusCode.NoContent);
        }
        public async Task<IHttpActionResult> PoststoreHoliday(StoreHoliday storeHoliday)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            db.StoreHolidays.Add(storeHoliday);
            await db.SaveChangesAsync();

            return CreatedAtRoute("DefaultApi", new { id = storeHoliday.StoreHolidayNo }, storeHoliday);
        }
        private async Task<List<StoreHoliday>> AddstoreHoliday(Store store, string holiday)
        {
            List<StoreHoliday> storeHolidays = new List<StoreHoliday>();
            var arr = HttpUtility.UrlDecode(holiday.ToString()).Split(',');

            for (int i = 0; i < arr.Length; i++)
            {
                StoreHoliday storeHoliday = new StoreHoliday();

                storeHoliday.StoreNo = store.StoreNo;
                storeHoliday.CodeID = arr[i].ToString().Trim();

                storeHolidays.Add(storeHoliday);
            }

            db.StoreHolidays.AddRange(storeHolidays);
            await db.SaveChangesAsync();

            return storeHolidays;
        }