public async Task <IHttpActionResult> PostStateProvince(StateProvinceDTO value)
        {
            try
            {
                if (!ModelState.IsValid)
                {
                    return(BadRequest(ModelState));
                }
                DbContext.StateProvinces.Add(StateProvinceTX.ReadFromDTO(new StateProvince(), value));
                await DbContext.SaveChangesAsync();

                return(CreatedAtRoute("DefaultApi", new { StateProvinceId = value.StateProvinceId }, value));
            }
            catch (Exception ex)
            {
                Log.Error("StateProvince.Post: " + ex);
                throw;
            }
        }
        public async Task <IHttpActionResult> GetStateProvince(int stateProvinceId)
        {
            try
            {
                StateProvinceDTO found = await Task.Run(() =>
                {
                    return(StateProvinceTX.WriteToDTO(DbContext.StateProvinces
                                                      .AsEnumerable().FirstOrDefault(e => e.StateProvinceId == stateProvinceId)));
                });

                if (found == null)
                {
                    return(NotFound());
                }
                return(Ok(found));
            }
            catch (Exception ex)
            {
                Log.Error("StateProvince.Get: " + ex);
                throw;
            }
        }