private HttpResponseMessage ProcessNewFarmYieldRecord(HttpRequestMessage request, FarmYieldDTO uDto, string key, int FarmYieldId, int userId) { var ur = new FarmYieldRepository(); var user = new FarmYield(); var validationErrors = GetValidationErrors(ur, user, uDto, FarmYieldId, userId); if (validationErrors.Any()) { return(ProcessValidationErrors(request, validationErrors, key)); } user = ur.Save(user); uDto.Key = key; uDto.YieldID = user.YieldID.ToString(); UpdateProductionTotalYield(uDto); var response = request.CreateResponse(HttpStatusCode.Created, uDto); response.Headers.Location = new Uri(Url.Link("Default", new { id = user.YieldID })); return(response); }
private HttpResponseMessage ProcessExistingFarmYieldRecord(HttpRequestMessage request, FarmYieldDTO cqDto, int contactId, string key, int FarmYieldId, int userId) { var ur = new FarmYieldRepository(); var user = new FarmYield(); user = ur.GetById(contactId); var validationErrors = GetValidationErrors(ur, user, cqDto, FarmYieldId, userId); if (validationErrors.Any()) { return(ProcessValidationErrors(request, validationErrors, key)); } if (cqDto.Remove != null && int.Parse(cqDto.Remove) == 1) { ur.Delete(user); } else { ur.Save(user); } UpdateProductionTotalYield(cqDto); cqDto.Key = key; return(request.CreateResponse(HttpStatusCode.Accepted, cqDto)); }
private void UpdateProductionTotalYield(FarmYieldDTO uDto) { var pr = new ProductionTotalRepository(); var prod = new ProductionTotal(); var prodexists = pr.GetByDateAndPond(DateTime.Parse(uDto.YieldDate), int.Parse(uDto.PondID)); decimal ay = 0; var y1 = uDto.PercentYield == null ? 0 : decimal.Parse(uDto.PercentYield); var y2 = uDto.PercentYield2 == null ? 0 : decimal.Parse(uDto.PercentYield2); if (y1 > 0 || y2 > 0) { if (y2 > 0) { if (y1 > 0) { ay = (y1 + y2) / 2; } else { ay = y2; } } else { ay = y1; } } if (prodexists == null) { prod.PondId = int.Parse(uDto.PondID); prod.ProductionDate = DateTime.Parse(uDto.YieldDate); prod.AverageYield = ay; pr.Save(prod); } else { prod = prodexists; var fyr = new FarmYieldRepository(); List <FarmYield> fyl = fyr.GetByDateAndPond(DateTime.Parse(uDto.YieldDate), int.Parse(uDto.PondID)); int fycount = fyl.Where(x => x.PercentYield != null).Count(); int fycount2 = fyl.Where(x => x.PercentYield2 != null).Count(); decimal fysum1 = fyl.Where(x => x.PercentYield != null).Sum(x => x.PercentYield).Value; decimal fysum2 = fyl.Where(x => x.PercentYield2 != null).Sum(x => x.PercentYield2).Value; prod.AverageYield = (fysum1 + fysum2) / (fycount + fycount2); //if (prod.AverageYield == null) //{ // prod.AverageYield = ay; //} //else //{ // prod.AverageYield = (prod.AverageYield + ay) / 2; //} pr.Save(prod); } }
public HttpResponseMessage FarmYieldsFromSamplings([FromBody] FarmYieldDTO 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 FarmYieldRepository(); var u = new FarmYield(); if (cqDTO.YieldDate != null) { cqDTO.Start_YieldDate = DateTime.Parse(cqDTO.YieldDate).ToString(); cqDTO.End_YieldDate = DateTime.Parse(cqDTO.YieldDate).AddDays(1).ToString(); } else { int sm = int.Parse(cqDTO.StartDateMonth); if (sm == 1) { cqDTO.Start_YieldDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString(); cqDTO.End_YieldDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString(); } else if (sm == 12) { cqDTO.Start_YieldDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_YieldDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString(); } else { cqDTO.Start_YieldDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_YieldDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) + 1).ToString() + "/14/" + cqDTO.StartDateYear).ToString(); } cqDTO.StartDateMonth = null; cqDTO.StartDateYear = null; } SGApp.DTOs.GenericDTO dto = new GenericDTO(); dto.StartDate = DateTime.Parse(cqDTO.Start_YieldDate); dto.EndDate = DateTime.Parse(cqDTO.End_YieldDate); List<Sampling> samplingResults = new List<Sampling>(); PondRepository pr = new PondRepository(); var client = new HttpClient { //BaseAddress = new Uri("http://323-booth-svr2:3030/") BaseAddress = new Uri("http://64.139.95.243:7846/") //BaseAddress = new Uri(baseAddress) }; try { //var response = client.PostAsJsonAsync("api/Remote/GetKeithsData", dto).Result; //response.EnsureSuccessStatusCode(); JavaScriptSerializer json_serializer = new JavaScriptSerializer(); //Sampling[] samplingResultsArray = json_serializer.Deserialize<Sampling[]>(response.Content.ReadAsStringAsync().Result); // new List<Sampling>(); //Sampling[] samplingResultsArray = response.Content.ReadAsAsync<Sampling[]>().Result; //samplingResults = samplingResultsArray.ToList(); //JavaScriptSerializer json_serializer = new JavaScriptSerializer(); Sampling[] samplingResultsArray = json_serializer.Deserialize<Sampling[]>(Constants.testdata); samplingResults = samplingResultsArray.ToList(); samplingResults = samplingResults.GroupBy(x => x.farmPond).Select(group => group.First()).ToList(); //var result = response.Content.ReadAsStringAsync().Result; //return Request.CreateResponse(HttpStatusCode.OK, result); } catch (Exception e) { throw new HttpException("Error occurred: " + e.Message); } 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 (Sampling sam in samplingResults) { FarmYield fy = data.Where(x => x.Pond.InnovaName == sam.farmPond).FirstOrDefault(); Pond pd = pr.GetPondFromInnovaName(sam.farmPond); var dic = new Dictionary<string, string>(); if (fy != null) { dic.Add("YieldId", fy.YieldID.ToString()); dic.Add("PondID", fy.PondID.ToString()); dic.Add("PondName", sam.farmPond); dic.Add("FarmID", fy.Pond.FarmId.ToString()); dic.Add("YieldDate", fy.YieldDate.ToShortDateString()); dic.Add("PoundsYielded", fy.PoundsYielded.ToString()); dic.Add("PoundsPlant", fy.PoundsPlant.ToString()); dic.Add("PoundsHeaded", fy.PoundsHeaded.ToString()); dic.Add("PercentYield", fy.PercentYield.ToString()); dic.Add("PercentYield2", fy.PercentYield2.ToString()); } else { dic.Add("YieldId", "-1"); dic.Add("PondID", pd.PondId.ToString() != null ? pd.PondId.ToString() : ""); dic.Add("PondName", sam.farmPond != null ? sam.farmPond : ""); dic.Add("FarmID", pd.FarmId.ToString() != null ? pd.FarmId.ToString() : ""); dic.Add("YieldDate", cqDTO.Start_YieldDate); dic.Add("PoundsYielded", ""); dic.Add("PoundsPlant", ""); dic.Add("PoundsHeaded", ""); dic.Add("PercentYield", ""); dic.Add("PercentYield2", ""); } col.Add(dic); } foreach (FarmYield fy in data) { Sampling samp = samplingResults.Where(x => x.farmPond == fy.Pond.InnovaName).FirstOrDefault(); var dic = new Dictionary<string, string>(); if (samp == null) { dic.Add("YieldId", fy.YieldID.ToString()); dic.Add("PondID", fy.PondID.ToString()); dic.Add("PondName", fy.Pond.InnovaName != null ? fy.Pond.InnovaName : fy.Pond.PondName); dic.Add("FarmID", fy.Pond.FarmId.ToString()); dic.Add("YieldDate", fy.YieldDate.ToShortDateString()); dic.Add("PoundsYielded", fy.PoundsYielded.ToString()); dic.Add("PoundsPlant", fy.PoundsPlant.ToString()); dic.Add("PoundsHeaded", fy.PoundsHeaded.ToString()); dic.Add("PercentYield", fy.PercentYield.ToString()); dic.Add("PercentYield2", fy.PercentYield2.ToString()); col.Add(dic); } } var retVal = new GenericDTO { Key = key, ReturnData = col }; return Request.CreateResponse(HttpStatusCode.OK, retVal); } var message = "validation failed"; return Request.CreateResponse(HttpStatusCode.NotFound, message); }
private void UpdateProductionTotalYield(FarmYieldDTO uDto) { var pr = new ProductionTotalRepository(); var prod = new ProductionTotal(); var prodexists = pr.GetByDateAndPond(DateTime.Parse(uDto.YieldDate), int.Parse(uDto.PondID)); decimal ay = 0; var y1 = uDto.PercentYield == null ? 0 : decimal.Parse(uDto.PercentYield); var y2 = uDto.PercentYield2 == null ? 0 : decimal.Parse(uDto.PercentYield2); if (y1 > 0 || y2 > 0) { if (y2 > 0) { if (y1 > 0) { ay = (y1 + y2) / 2; } else { ay = y2; } } else { ay = y1; } } if (prodexists == null) { prod.PondId = int.Parse(uDto.PondID); prod.ProductionDate = DateTime.Parse(uDto.YieldDate); prod.AverageYield = ay; pr.Save(prod); } else { prod = prodexists; var fyr = new FarmYieldRepository(); List<FarmYield> fyl = fyr.GetByDateAndPond(DateTime.Parse(uDto.YieldDate), int.Parse(uDto.PondID)); int fycount = fyl.Where(x => x.PercentYield != null).Count(); int fycount2 = fyl.Where(x => x.PercentYield2 != null).Count(); decimal fysum1 = fyl.Where(x => x.PercentYield != null).Sum(x => x.PercentYield).Value; decimal fysum2 = fyl.Where(x => x.PercentYield2 != null).Sum(x => x.PercentYield2).Value; prod.AverageYield = (fysum1 + fysum2) / (fycount + fycount2); //if (prod.AverageYield == null) //{ // prod.AverageYield = ay; //} //else //{ // prod.AverageYield = (prod.AverageYield + ay) / 2; //} pr.Save(prod); } }
private HttpResponseMessage ProcessNewFarmYieldRecord(HttpRequestMessage request, FarmYieldDTO uDto, string key, int FarmYieldId, int userId) { var ur = new FarmYieldRepository(); var user = new FarmYield(); var validationErrors = GetValidationErrors(ur, user, uDto, FarmYieldId, userId); if (validationErrors.Any()) { return ProcessValidationErrors(request, validationErrors, key); } user = ur.Save(user); uDto.Key = key; uDto.YieldID = user.YieldID.ToString(); UpdateProductionTotalYield(uDto); var response = request.CreateResponse(HttpStatusCode.Created, uDto); response.Headers.Location = new Uri(Url.Link("Default", new { id = user.YieldID })); return response; }
private HttpResponseMessage ProcessExistingFarmYieldRecord(HttpRequestMessage request, FarmYieldDTO cqDto, int contactId, string key, int FarmYieldId, int userId) { var ur = new FarmYieldRepository(); var user = new FarmYield(); user = ur.GetById(contactId); var validationErrors = GetValidationErrors(ur, user, cqDto, FarmYieldId, userId); if (validationErrors.Any()) { return ProcessValidationErrors(request, validationErrors, key); } if (cqDto.Remove != null && int.Parse(cqDto.Remove) == 1) { ur.Delete(user); } else { ur.Save(user); } UpdateProductionTotalYield(cqDto); cqDto.Key = key; return request.CreateResponse(HttpStatusCode.Accepted, cqDto); }
private List<DbValidationError> GetValidationErrors(FarmYieldRepository pr, FarmYield contact, FarmYieldDTO cqDto, int YieldID, int userId) { contact.ProcessRecord(cqDto); return pr.Validate(contact); }
internal HttpResponseMessage FarmYields(HttpRequestMessage request, FarmYieldDTO 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 FarmYieldRepository(); var u = new FarmYield(); if (cqDTO.YieldDate != null) { cqDTO.Start_YieldDate = DateTime.Parse(cqDTO.YieldDate).ToString(); cqDTO.End_YieldDate = DateTime.Parse(cqDTO.YieldDate).AddDays(1).ToString(); } else { int sm = int.Parse(cqDTO.StartDateMonth); if (sm == 1) { cqDTO.Start_YieldDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString(); cqDTO.End_YieldDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString(); } else if (sm == 12) { cqDTO.Start_YieldDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_YieldDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString(); } else { cqDTO.Start_YieldDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_YieldDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) + 1).ToString() + "/14/" + cqDTO.StartDateYear).ToString(); } cqDTO.StartDateMonth = null; cqDTO.StartDateYear = null; } 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("YieldId", item.YieldID.ToString()); dic.Add("PondID", item.PondID.ToString()); dic.Add("PondName", item.Pond.PondName); dic.Add("FarmID", item.Pond.FarmId.ToString()); dic.Add("YieldDate", item.YieldDate.ToShortDateString()); dic.Add("PoundsYielded", item.PoundsYielded.ToString()); dic.Add("PoundsPlant", item.PoundsPlant.ToString()); dic.Add("PoundsHeaded", item.PoundsHeaded.ToString()); dic.Add("PercentYield", item.PercentYield.ToString()); dic.Add("PercentYield2", item.PercentYield2.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 DailyReport(HttpRequestMessage request, DailyReportDTO cqDTO) { string key; var aur = new AppUserRepository(); var companyId = 0; var userId = aur.ValidateUser(cqDTO.Key, out key, ref companyId); if (userId > 0) { var fyr = new FarmYieldRepository(); var ser = new ShiftEndRepository(); var fyhr = new FarmYieldHeaderRepository(); var fyh = new FarmYieldHeader(); //var lfsr = new LiveFishSamplingRepository(); //var lfs = new LiveFishSampling(); var reportDate = new DateTime(); var se = new ShiftEnd(); decimal? pondWeight = 0; if (cqDTO.ReportDate != null) { reportDate = DateTime.Parse(cqDTO.ReportDate).AddDays(-1); } fyh = fyhr.GetByDate(reportDate); pondWeight = fyr.GetPondWeightByDate(reportDate); se = ser.GetByDate(reportDate); string downtime = ""; //lfs = lfsr.GetByDate(reportDate); if (se != null && se.DowntimeMinutes != null) { downtime = String.Format((se.DowntimeMinutes / 60).ToString(), "{0, D2}") + ":" + String.Format((se.DowntimeMinutes % 60).ToString(), "{0, D2}"); } else { downtime = ""; } var col = new Collection<Dictionary<string, string>>(); var dic = new Dictionary<string, string>(); if (fyh != null) { dic.Add("PlantWeight", string.IsNullOrEmpty(fyh.PlantWeight.ToString()) ? "" : (fyh.PlantWeight.ToString())); dic.Add("WeighBacks", string.IsNullOrEmpty(fyh.WeighBacks.ToString()) ? "" : (fyh.WeighBacks.ToString())); dic.Add("TotalPounds", string.IsNullOrEmpty(fyh.WeighBacks.ToString()) || string.IsNullOrEmpty(fyh.PlantWeight.ToString()) ? "" : (fyh.PlantWeight - fyh.WeighBacks).ToString()); dic.Add("PondWeight", string.IsNullOrEmpty(pondWeight.ToString()) ? "" : pondWeight.ToString()); dic.Add("Variance", string.IsNullOrEmpty(pondWeight.ToString()) || string.IsNullOrEmpty(fyh.PlantWeight.ToString()) ? "" : (pondWeight - fyh.PlantWeight).ToString()); dic.Add("DownTime", downtime); } col.Add(dic); var data = fyr.GetByDate(reportDate); var col1 = new Collection<Dictionary<string, string>>(); data = data.OrderBy(x => x.YieldDate).ToList(); foreach (var item in data) { var dic1 = new Dictionary<string, string>(); dic1.Add("YieldId", string.IsNullOrEmpty(item.YieldID.ToString()) ? "" : (item.YieldID.ToString())); dic1.Add("PondID", string.IsNullOrEmpty(item.PondID.ToString()) ? "" : (item.PondID.ToString())); dic1.Add("PondName", string.IsNullOrEmpty(item.Pond.PondName) ? "" : (item.Pond.PondName)); dic1.Add("FarmID", string.IsNullOrEmpty(item.Pond.Farm.FarmName) ? "" : (item.Pond.Farm.FarmName)); dic1.Add("YieldDate", string.IsNullOrEmpty(item.YieldDate.ToString()) ? "" : (item.YieldDate.ToString())); dic1.Add("PoundsYielded", string.IsNullOrEmpty(item.PoundsYielded.ToString()) ? "" : (item.PoundsYielded.ToString())); dic1.Add("PoundsPlant", string.IsNullOrEmpty(item.PoundsPlant.ToString()) ? "" : (item.PoundsPlant.ToString())); dic1.Add("PoundsHeaded", string.IsNullOrEmpty(item.PoundsHeaded.ToString()) ? "" : (item.PoundsHeaded.ToString())); dic1.Add("PercentYield", string.IsNullOrEmpty(item.PercentYield.ToString()) ? "" : (item.PercentYield.ToString())); ; dic1.Add("PercentYield2", string.IsNullOrEmpty(item.PercentYield2.ToString()) ? "" : (item.PercentYield2.ToString())); col1.Add(dic1); } var col2 = new Collection<Dictionary<string, string>>(); var dic2 = new Dictionary<string, string>(); var col3 = new Collection<Dictionary<string, string>>(); var dic3 = new Dictionary<string, string>(); var col4 = new Collection<Dictionary<string, string>>(); var dic4 = new Dictionary<string, string>(); if (se != null) { dic4.Add("DayFinishedFreezing", string.IsNullOrEmpty(se.DayFinishedFreezing.ToString()) ? "" : DateTime.Parse(se.DayFinishedFreezing.ToString()).ToString("HH:mm")); dic2.Add("DayShiftFroze", string.IsNullOrEmpty(se.DayShiftFroze.ToString()) ? "" : (se.DayShiftFroze.ToString())); dic3.Add("EmployeesOnVacation", string.IsNullOrEmpty(se.EmployeesOnVacation.ToString()) ? "" : (se.EmployeesOnVacation.ToString())); dic2.Add("FilletScaleReading", string.IsNullOrEmpty(se.FilletScaleReading.ToString()) ? "" : (se.FilletScaleReading.ToString())); dic4.Add("FinishedFillet", string.IsNullOrEmpty(se.FinishedFillet.ToString()) ? "" : DateTime.Parse(se.FinishedFillet.ToString()).ToString("HH:mm")); dic4.Add("FinishedKill", string.IsNullOrEmpty(se.FinishedKill.ToString()) ? "" : DateTime.Parse(se.FinishedKill.ToString()).ToString("HH:mm")); dic4.Add("FinishedSkinning", string.IsNullOrEmpty(se.FinishedSkinning.ToString()) ? "" : DateTime.Parse(se.FinishedSkinning.ToString()).ToString("HH:mm")); dic3.Add("InmateLeftEarly", string.IsNullOrEmpty(se.InmateLeftEarly.ToString()) ? "" : (se.InmateLeftEarly.ToString())); dic3.Add("InLateOut", string.IsNullOrEmpty(se.InLateOut.ToString()) ? "" : (se.InLateOut.ToString())); dic4.Add("NightFinishedFreezing", string.IsNullOrEmpty(se.NightFinishedFreezing.ToString()) ? "" : DateTime.Parse(se.NightFinishedFreezing.ToString()).ToString("HH:mm")); dic2.Add("NightShiftFroze", string.IsNullOrEmpty(se.NightShiftFroze.ToString()) ? "" : (se.NightShiftFroze.ToString())); dic3.Add("RegEmpLate", string.IsNullOrEmpty(se.RegEmpLate.ToString()) ? "" : (se.RegEmpLate.ToString())); dic3.Add("RegEmpOut", string.IsNullOrEmpty(se.RegEmpOut.ToString()) ? "" : (se.RegEmpOut.ToString())); dic3.Add("RegEmplLeftEarly", string.IsNullOrEmpty(se.RegEmplLeftEarly.ToString()) ? "" : (se.RegEmplLeftEarly.ToString())); dic3.Add("TempEmpOut", string.IsNullOrEmpty(se.TempEmpOut.ToString()) ? "" : (se.TempEmpOut.ToString())); } col2.Add(dic2); col3.Add(dic3); col4.Add(dic4); //var col5 = new Collection<Dictionary<string, string>>(); //var dic5 = new Dictionary<string, string>(); //if (lfs != null) //{ // dic5.Add("Pct0_125", string.IsNullOrEmpty(lfs.Pct0_125.ToString()) ? "" : (lfs.Pct0_125.ToString())); // dic5.Add("Avg0_125", string.IsNullOrEmpty(lfs.Avg0_125.ToString()) ? "" : (lfs.Avg0_125.ToString())); // dic5.Add("Pct125_225", string.IsNullOrEmpty(lfs.Pct125_225.ToString()) ? "" : (lfs.Pct125_225.ToString())); // dic5.Add("Avg125_225", string.IsNullOrEmpty(lfs.Avg125_225.ToString()) ? "" : (lfs.Avg125_225.ToString())); // dic5.Add("Pct225_3", string.IsNullOrEmpty(lfs.Pct225_3.ToString()) ? "" : (lfs.Pct225_3.ToString())); // dic5.Add("Avg225_3", string.IsNullOrEmpty(lfs.Avg225_3.ToString()) ? "" : (lfs.Avg225_3.ToString())); // dic5.Add("Pct3_5", string.IsNullOrEmpty(lfs.Pct3_5.ToString()) ? "" : (lfs.Pct3_5.ToString())); // dic5.Add("Avg3_5", string.IsNullOrEmpty(lfs.Avg3_5.ToString()) ? "" : (lfs.Avg3_5.ToString())); // dic5.Add("Pct5_Up", string.IsNullOrEmpty(lfs.Pct5_Up.ToString()) ? "" : (lfs.Pct5_Up.ToString())); // dic5.Add("Avg5_Up", string.IsNullOrEmpty(lfs.Avg5_Up.ToString()) ? "" : (lfs.Avg5_Up.ToString())); //} //col5.Add(dic5); var retVal = new DailyReportDTO { Key = key, Header = col, Ponds = col1, Employees = col3, Finish = col4, Freezing = col2, //Samplings = col5 }; return Request.CreateResponse(HttpStatusCode.OK, retVal); } var message = "validation failed"; return request.CreateResponse(HttpStatusCode.NotFound, message); }
internal HttpResponseMessage FarmYieldDates(HttpRequestMessage request, FarmYieldDTO 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 FarmYieldRepository(); var u = new FarmYield(); if (cqDTO.YieldDate != null) { cqDTO.Start_YieldDate = DateTime.Parse(cqDTO.YieldDate).ToString(); cqDTO.End_YieldDate = DateTime.Parse(cqDTO.YieldDate).AddDays(1).ToString(); } else { int sm = int.Parse(cqDTO.StartDateMonth); if (sm == 1) { cqDTO.Start_YieldDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString(); cqDTO.End_YieldDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString(); } else if (sm == 12) { cqDTO.Start_YieldDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_YieldDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString(); } else { cqDTO.Start_YieldDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_YieldDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) + 1).ToString() + "/14/" + cqDTO.StartDateYear).ToString(); } cqDTO.StartDateMonth = null; cqDTO.StartDateYear = null; } var predicate = ur.GetPredicate(cqDTO, u, companyId); var data = ur.GetByPredicate(predicate); var col = new Collection <Dictionary <string, string> >(); data = data.GroupBy(x => x.YieldDate).Select(x => x.First()).OrderBy(x => x.YieldDate).ToList(); foreach (var item in data) { var dic = new Dictionary <string, string>(); dic.Add("YieldDate", item.YieldDate.ToShortDateString()); 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)); }
public HttpResponseMessage FarmYieldsFromSamplings([FromBody] FarmYieldDTO 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 FarmYieldRepository(); var u = new FarmYield(); if (cqDTO.YieldDate != null) { cqDTO.Start_YieldDate = DateTime.Parse(cqDTO.YieldDate).ToString(); cqDTO.End_YieldDate = DateTime.Parse(cqDTO.YieldDate).AddDays(1).ToString(); } else { int sm = int.Parse(cqDTO.StartDateMonth); if (sm == 1) { cqDTO.Start_YieldDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString(); cqDTO.End_YieldDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString(); } else if (sm == 12) { cqDTO.Start_YieldDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_YieldDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString(); } else { cqDTO.Start_YieldDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_YieldDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) + 1).ToString() + "/14/" + cqDTO.StartDateYear).ToString(); } cqDTO.StartDateMonth = null; cqDTO.StartDateYear = null; } SGApp.DTOs.GenericDTO dto = new GenericDTO(); dto.StartDate = DateTime.Parse(cqDTO.Start_YieldDate); dto.EndDate = DateTime.Parse(cqDTO.End_YieldDate); List <DTOs.Sampling> samplingResults = new List <DTOs.Sampling>(); PondRepository pr = new PondRepository(); var client = new HttpClient { //BaseAddress = new Uri("http://323-booth-svr2:3030/") BaseAddress = new Uri("http://64.139.95.243:7846/") //BaseAddress = new Uri(baseAddress) }; try { //var response = client.PostAsJsonAsync("api/Remote/GetKeithsData", dto).Result; //response.EnsureSuccessStatusCode(); JavaScriptSerializer json_serializer = new JavaScriptSerializer(); //Sampling[] samplingResultsArray = json_serializer.Deserialize<Sampling[]>(response.Content.ReadAsStringAsync().Result); // new List<Sampling>(); //Sampling[] samplingResultsArray = response.Content.ReadAsAsync<Sampling[]>().Result; //samplingResults = samplingResultsArray.ToList(); //JavaScriptSerializer json_serializer = new JavaScriptSerializer(); DTOs.Sampling[] samplingResultsArray = json_serializer.Deserialize <DTOs.Sampling[]>(Constants.testdata); samplingResults = samplingResultsArray.ToList(); samplingResults = samplingResults.GroupBy(x => x.farmPond).Select(group => group.First()).ToList(); //var result = response.Content.ReadAsStringAsync().Result; //return Request.CreateResponse(HttpStatusCode.OK, result); } catch (Exception e) { throw new HttpException("Error occurred: " + e.Message); } 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 (DTOs.Sampling sam in samplingResults) { FarmYield fy = data.Where(x => x.Pond.InnovaName == sam.farmPond).FirstOrDefault(); Pond pd = pr.GetPondFromInnovaName(sam.farmPond); var dic = new Dictionary <string, string>(); if (fy != null) { dic.Add("YieldId", fy.YieldID.ToString()); dic.Add("PondID", fy.PondID.ToString()); dic.Add("PondName", sam.farmPond); dic.Add("FarmID", fy.Pond.FarmId.ToString()); dic.Add("YieldDate", fy.YieldDate.ToShortDateString()); dic.Add("PoundsYielded", fy.PoundsYielded.ToString()); dic.Add("PoundsPlant", fy.PoundsPlant.ToString()); dic.Add("PoundsHeaded", fy.PoundsHeaded.ToString()); dic.Add("PercentYield", fy.PercentYield.ToString()); dic.Add("PercentYield2", fy.PercentYield2.ToString()); } else { dic.Add("YieldId", "-1"); dic.Add("PondID", pd.PondId.ToString() != null ? pd.PondId.ToString() : ""); dic.Add("PondName", sam.farmPond != null ? sam.farmPond : ""); dic.Add("FarmID", pd.FarmId.ToString() != null ? pd.FarmId.ToString() : ""); dic.Add("YieldDate", cqDTO.Start_YieldDate); dic.Add("PoundsYielded", ""); dic.Add("PoundsPlant", ""); dic.Add("PoundsHeaded", ""); dic.Add("PercentYield", ""); dic.Add("PercentYield2", ""); } col.Add(dic); } foreach (FarmYield fy in data) { DTOs.Sampling samp = samplingResults.Where(x => x.farmPond == fy.Pond.InnovaName).FirstOrDefault(); var dic = new Dictionary <string, string>(); if (samp == null) { dic.Add("YieldId", fy.YieldID.ToString()); dic.Add("PondID", fy.PondID.ToString()); dic.Add("PondName", fy.Pond.InnovaName != null ? fy.Pond.InnovaName : fy.Pond.PondName); dic.Add("FarmID", fy.Pond.FarmId.ToString()); dic.Add("YieldDate", fy.YieldDate.ToShortDateString()); dic.Add("PoundsYielded", fy.PoundsYielded.ToString()); dic.Add("PoundsPlant", fy.PoundsPlant.ToString()); dic.Add("PoundsHeaded", fy.PoundsHeaded.ToString()); dic.Add("PercentYield", fy.PercentYield.ToString()); dic.Add("PercentYield2", fy.PercentYield2.ToString()); col.Add(dic); } } var retVal = new GenericDTO { Key = key, ReturnData = col }; return(Request.CreateResponse(HttpStatusCode.OK, retVal)); } var message = "validation failed"; return(Request.CreateResponse(HttpStatusCode.NotFound, message)); }
private List <DbValidationError> GetValidationErrors(FarmYieldRepository pr, FarmYield contact, FarmYieldDTO cqDto, int YieldID, int userId) { contact.ProcessRecord(cqDto); return(pr.Validate(contact)); }