internal HttpResponseMessage FarmYieldHeaders(HttpRequestMessage request, FarmYieldHeaderDTO cqDTO) { string key; var aur = new AppUserRepository(); var companyId = 0; var userId = aur.ValidateUser(cqDTO.Key, out key, ref companyId); if (userId > 0) { var ur = new FarmYieldHeaderRepository(); var u = new FarmYieldHeader(); if (cqDTO.YieldDate != null) { cqDTO.Start_YieldDate = DateTime.Parse(cqDTO.YieldDate).AddHours(-1).ToString(); cqDTO.End_YieldDate = DateTime.Parse(cqDTO.YieldDate).AddHours(1).ToString(); } var predicate = ur.GetPredicate(cqDTO, u, companyId); var data = ur.GetByPredicate(predicate); var col = new Collection <Dictionary <string, string> >(); data = data.OrderBy(x => x.YieldDate).ToList(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("FarmYieldHeaderID", item.FarmYieldHeaderID.ToString()); dic.Add("YieldDate", item.YieldDate.ToShortDateString()); dic.Add("PlantWeight", item.PlantWeight.ToString()); dic.Add("WeighBacks", item.WeighBacks.ToString()); col.Add(dic); var ufdic = new Dictionary <string, string>(); } var retVal = new GenericDTO { Key = key, ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(request.CreateResponse(HttpStatusCode.NotFound, message)); }
internal HttpResponseMessage FarmYieldHeaders(HttpRequestMessage request, FarmYieldHeaderDTO cqDTO) { string key; var aur = new AppUserRepository(); var companyId = 0; var userId = aur.ValidateUser(cqDTO.Key, out key, ref companyId); if (userId > 0) { var ur = new FarmYieldHeaderRepository(); var u = new FarmYieldHeader(); if (cqDTO.YieldDate != null) { cqDTO.Start_YieldDate = DateTime.Parse(cqDTO.YieldDate).AddHours(-1).ToString(); cqDTO.End_YieldDate = DateTime.Parse(cqDTO.YieldDate).AddHours(1).ToString(); } var predicate = ur.GetPredicate(cqDTO, u, companyId); var data = ur.GetByPredicate(predicate); var col = new Collection<Dictionary<string, string>>(); data = data.OrderBy(x => x.YieldDate).ToList(); foreach (var item in data) { var dic = new Dictionary<string, string>(); dic.Add("FarmYieldHeaderID", item.FarmYieldHeaderID.ToString()); dic.Add("YieldDate", item.YieldDate.ToShortDateString()); dic.Add("PlantWeight", item.PlantWeight.ToString()); dic.Add("WeighBacks", item.WeighBacks.ToString()); col.Add(dic); var ufdic = new Dictionary<string, string>(); } var retVal = new GenericDTO { Key = key, ReturnData = col }; return Request.CreateResponse(HttpStatusCode.OK, retVal); } var message = "validation failed"; return request.CreateResponse(HttpStatusCode.NotFound, message); }