public async Task <IHttpActionResult> GetKPICategory(int id)
        {
            KPICategory kPICategory = await db.KPICategories.FindAsync(id);

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

            return(Ok(kPICategory));
        }
        public async Task <IHttpActionResult> PostKPICategory(KPICategory kPICategory)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            if (KPICategoryExistsName(kPICategory.KPICategoryName))
            {
                return(BadRequest());
            }
            db.KPICategories.Add(kPICategory);
            await db.SaveChangesAsync();

            return(CreatedAtRoute("DefaultApi", new { id = kPICategory.ID }, kPICategory));
        }
        public async Task <IHttpActionResult> DeleteKPICategory(int id)
        {
            //get the kpi category in the DB.
            KPICategory kPICategoryInDB = await db.KPICategories.FindAsync(id);

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

            if (KPICategoryExistsID(id))
            {
                return(BadRequest());
            }

            kPICategoryInDB.IsDeleted = true;
            //db.KPICategories.Remove(kPICategory);
            await db.SaveChangesAsync();

            return(Ok());
        }
        public async Task <IHttpActionResult> PutKPICategory(int id, [FromBody] KPICategory kPICategory)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != kPICategory.ID)
            {
                return(BadRequest());
            }
            if (KPICategoryExistsName(kPICategory.KPICategoryName))
            {
                return(BadRequest());
            }

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

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

            return(StatusCode(HttpStatusCode.OK));
        }