/// <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)); }