public IHttpActionResult Patch([FromODataUri] string key, Delta <CODE_PATIENTSOURCEEntity> patch)
        {
            CODE_PATIENTSOURCEService service = new CODE_PATIENTSOURCEService();
            object id;

            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            else if (patch.GetChangedPropertyNames().Contains("PATIENTSOURCEID") && patch.TryGetPropertyValue("PATIENTSOURCEID", out id) && (string)id != key)
            {
                return(BadRequest("The key from the url must match the key of the entity in the body"));
            }

            try
            {
                var query = service.GetEntity(key);
                patch.Patch(query);
                service.UpdateEntity(query);
                return(Updated(query));
            }
            catch (Exception)
            {
                return(NotFound());
            }
        }
        public IHttpActionResult RecordQuery(string key)
        {
            CODE_PATIENTSOURCEService service = new CODE_PATIENTSOURCEService();

            try
            {
                var query         = service.GetEntity(key.ToString());
                var packageEntity = query.PackageResult();
                return(Json(packageEntity));
            }
            catch (Exception)
            {
                PackageResultEntity <object> packageResultEntity = new PackageResultEntity <object>()
                {
                    list = null,
                    msg  = "failed"
                };
                return(Json(packageResultEntity));
            }
        }