/// <summary>
        /// Get all data in the look up table
        /// </summary>
        /// <returns></returns>
        public List<Models.LookUp> GetAllLookUpData()
        {
            //return object
            List<Models.LookUp> cLookUp = new List<Models.LookUp>();
            List<DataAccess.Models.LookUp> rLookUp = _repository.GetAll().OrderBy(l => l.DisplayOrder).ToList();

            for (int ctr = 0; ctr <= rLookUp.Count - 1; ctr++) {

                Models.LookUp lookUp = new Models.LookUp();

                lookUp.Counter = ctr;
                lookUp.GroupID = rLookUp[ctr].GroupID;
                lookUp.TableName = rLookUp[ctr].TableName;
                lookUp.FieldName = rLookUp[ctr].FieldName;
                lookUp.ValueCode = rLookUp[ctr].ValueCode;
                lookUp.DisplayOrder = rLookUp[ctr].DisplayOrder;
                lookUp.ValueDescription = rLookUp[ctr].ValueDescription;
                lookUp.OwnerFieldName = rLookUp[ctr].OwnerFieldName;
                lookUp.OwnerValue = rLookUp[ctr].OwnerValue;
                lookUp.DefaultValue = rLookUp[ctr].DefaultValue;
                lookUp.SystemRequired = rLookUp[ctr].SystemRequired;
                lookUp.Aliased = rLookUp[ctr].Aliased;
                lookUp.ValueForAction = rLookUp[ctr].ValueForAction;
                lookUp.RecordLastUpdated = rLookUp[ctr].RecordLastUpdated;

                cLookUp.Add(lookUp);

            }

            return cLookUp;
        }
        public HttpResponseMessage Delete(HttpRequestMessage req)
        {
            var jsonData = req.Content.ReadAsStringAsync().Result;
            dynamic json = JValue.Parse(jsonData);
            Models.LookUp lookUpData = new Models.LookUp();
            lookUpData.GroupID = json.GroupID;
            lookUpData.TableName = json.TableName;
            lookUpData.FieldName = json.FieldName;
            lookUpData.ValueCode = json.ValueCode;
            lookUpData.ValueDescription = json.ValueDescription;
            lookUpData.DisplayOrder = json.DisplayOrder;
            lookUpData.OwnerFieldName = json.OwnerFieldName;
            lookUpData.OwnerValue = json.OwnerValue;
            lookUpData.DefaultValue = json.DefaultValue;
            lookUpData.SystemRequired = json.SystemRequired;
            lookUpData.Aliased = json.Aliased;
            lookUpData.ValueForAction = json.ValueForAction;

            /* Temp */
            byte[] dateTime = BitConverter.GetBytes(DateTime.Now.Ticks);
            lookUpData.RecordLastUpdated = dateTime;

            return Request.CreateResponse(HttpStatusCode.OK, _service.Delete(lookUpData));
        }