public async Task <IHttpActionResult> PuttSNPAvailability(int id, tSNPAvailability SNPAvailability)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != SNPAvailability.ID)
            {
                return(BadRequest());
            }

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

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

            return(StatusCode(HttpStatusCode.NoContent));
        }
        public async Task <IHttpActionResult> GettSNPAvailability(int id)
        {
            tSNPAvailability tSNPAvailability = await db.tSNPAvailabilities.FindAsync(id);

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

            return(Ok(tSNPAvailability));
        }
        public async Task <IHttpActionResult> PosttSNPAvailability(tSNPAvailability SNPAvailability)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.tSNPAvailabilities.Add(SNPAvailability);
            await db.SaveChangesAsync();

            return(CreatedAtRoute("DefaultApi", new { id = SNPAvailability.ID }, SNPAvailability));
        }
        public async Task <IHttpActionResult> DeletetSNPAvailability(int id)
        {
            tSNPAvailability tSNPAvailability = await db.tSNPAvailabilities.FindAsync(id);

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

            db.tSNPAvailabilities.Remove(tSNPAvailability);
            await db.SaveChangesAsync();

            return(Ok(tSNPAvailability));
        }