コード例 #1
0
        public object Get(string showCode, string entityId)
        {
            PreviewDTO    pDTO  = new PreviewDTO();
            SQLDataHelper SQLDA = new SQLDataHelper();

            eventBitEntities entities = new eventBitEntities();

            var entityState = entities.EntityStates.FirstOrDefault(x => x.ShowCode == showCode && x.EntityID == entityId);

            DataTable dt = new DataTable();

            if (entityState != null)
            {
                dt = SQLDA.GetEntityDataTable(entityId, (entityState.sysEventId ?? 0));

                pDTO.Columns = dt.Columns.Cast <DataColumn>().Where(x => !x.ColumnName.StartsWith("sys"))
                               .Select(x => Char.ToLowerInvariant(x.ColumnName[0]) + x.ColumnName.Substring(1))
                               .ToArray();

                pDTO.SysRowStampNumMax = entityState.sysRowStampNumMax.ToString();

                pDTO.RowCount = SQLDA.GetRowCountForEntity(entityId, (entityState.sysEventId ?? 0));
            }

            pDTO.Data = dt;

            return(pDTO);
        }
コード例 #2
0
        public async Task <HttpResponseMessage> Get(string eventName)
        {
            eventBitEntities entities = new eventBitEntities();

            //Grab my X-AUTH from header.
            string reqAuth = Request.Headers.GetValues("X-AUTH-CLAIMS").First();

            ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;

            HttpClient client = new HttpClient();

            client.BaseAddress = new Uri("https://dev.experienteventbit.com/webapi/API/Event/");

            client.DefaultRequestHeaders.Add("X-AUTH-CLAIMS", reqAuth);

            HttpResponseMessage response = client.GetAsync(eventName + "/TrackingData").Result;

            string newXAuthHeader = response.Headers.GetValues("X-AUTH-CLAIMS").First();

            var data = await response.Content.ReadAsStringAsync();

            //Check for error
            HttpResponseMessage r = new HttpResponseMessage();

            if (response.StatusCode == HttpStatusCode.OK)
            {
                var d = JsonConvert.DeserializeObject <TrackedData>(data);

                SnapshotState ssState;
                //Check my snapshot id.
                ssState = entities.SnapshotStates.FirstOrDefault(x => x.ShowCode == eventName);

                if (ssState != null)
                {
                    if (ssState.UniqueIdentifier == d.UniqueIdentifier)
                    {
                        return(RH.OK(newXAuthHeader, "Snapshot unique identifier matches currently loaded snapshot, no new snapshot available."));
                    }
                }
                else
                {
                    ssState          = new SnapshotState();
                    ssState.ShowCode = eventName;
                    entities.SnapshotStates.Add(ssState);
                }

                ProcessTrackedData(d, eventName);

                ssState.UniqueIdentifier = d.UniqueIdentifier;
                entities.SaveChanges();

                return(RH.OK(newXAuthHeader, "Snapshot sync complete."));
            }
            else
            {
                return(RH.BadRequest(newXAuthHeader, data));
            }
        }
コード例 #3
0
        public async Task <HttpResponseMessage> Get(string id, string eventName)
        {
            EntityState entityState;

            //Clear up data structures
            using (eventBitEntities entities = new eventBitEntities())
            {
                entityState = entities.EntityStates.FirstOrDefault(x => x.ShowCode == eventName && x.EntityID == id);
                if (entityState == null)
                {
                    entityState          = new EntityState();
                    entityState.EntityID = id;
                    entityState.ShowCode = eventName;
                }

                EntityCallResponse resp = await GetEntityResponse(id, eventName, entityState.sysRowStampNumMax);

                //Error Check This Out.
                if (resp == null || resp.StatusCode != HttpStatusCode.OK)
                {
                    return(RH.BadRequest(resp.X_AUTH_CLAIMS, resp.Content));
                }

                var d = JsonConvert.DeserializeObject(resp.Content);

                ResponseDTO rDTO = new ResponseDTO();
                rDTO.Count     = ((JArray)d).Count;
                rDTO.LastSince = resp.RequestString;

                //Sync Data Here
                //There has to be a way I can get this to be more generic.
                if (rDTO.Count > 0)
                {
                    try
                    {
                        //There has to be a way to make this SUPER generic.
                        //Currently a messy switch. At least it makes it easy to debug.
                        //ProcessDataToEntities(entities, entityState, d, id);
                        int sysEventId = 0;

                        GenericSwitchToAssignTypes(d, id, out sysEventId);

                        UpdateEntitySyncLog(id, eventName, sysEventId);
                    }
                    catch (Exception e)
                    {
                        return(RH.BadRequest(resp.X_AUTH_CLAIMS, e.Message.ToString()));
                    }
                }

                return(RH.OK(resp.X_AUTH_CLAIMS, JsonConvert.SerializeObject(rDTO)));
            }
        }
コード例 #4
0
        private void ProcessDataToEntitiesGeneric <T>(dynamic d, string id, out int sysEventID) where T : class
        {
            // var ent = entities.Set<t.GetType()>();
            //I want to make sure I dispose of this here
            using (eventBitEntities entities = new eventBitEntities())
            {
                var table = entities.Set <T>();

                //I pass in show code but everything is based on sysEventId??
                sysEventID = 0;
                foreach (JObject data in d)
                {
                    var jsonEnt = data.ToObject <T>();

                    int pKey = Convert.ToInt32(jsonEnt.GetType().GetProperty(id + "ID").GetValue(jsonEnt, null));

                    if (sysEventID == 0)
                    {
                        sysEventID = Convert.ToInt32(jsonEnt.GetType().GetProperty("sysEventID").GetValue(jsonEnt, null));
                    }

                    var ent = table.Find(pKey);

                    if (ent == null)
                    {
                        table.Add(jsonEnt);
                    }
                    else
                    {
                        CopyPropertyValues(jsonEnt, ent);
                    }
                }
                entities.SaveChanges();
            }
            //Expression Tree? Maybe?
        }