public HttpResponseMessage ProductionTotals([FromBody] ProductionTotalDTO 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 ProductionTotalRepository(); var u = new ProductionTotal(); if (cqDTO.ProductionDate != null) { cqDTO.Start_ProductionDate = DateTime.Parse(cqDTO.ProductionDate).ToString(); cqDTO.End_ProductionDate = DateTime.Parse(cqDTO.ProductionDate).AddDays(1).ToString(); } else { int sm = int.Parse(cqDTO.StartDateMonth); if (sm == 1) { cqDTO.Start_ProductionDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString(); cqDTO.End_ProductionDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString(); } else if (sm == 12) { cqDTO.Start_ProductionDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_ProductionDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString(); } else { cqDTO.Start_ProductionDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_ProductionDate = 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_ProductionDate); dto.EndDate = DateTime.Parse(cqDTO.End_ProductionDate); 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); Sampling[] samplingResultsArray = json_serializer.Deserialize<Sampling[]>(response.Content.ReadAsStringAsync().Result); 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.ProductionDate).ToList(); foreach (Sampling sam in samplingResults) { ProductionTotal 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) { var wb = fy.WeighBacks != null ? fy.WeighBacks : 0; dic.Add("ProductionTotalId", fy.ProductionTotalID.ToString()); dic.Add("PondID", fy.PondId.ToString()); dic.Add("PondName", sam.farmPond); dic.Add("FarmID", fy.Pond.FarmId.ToString()); dic.Add("ProductionDate", fy.ProductionDate.ToShortDateString()); dic.Add("PlantWeight", fy.PlantWeight != null ? fy.PlantWeight.ToString() : "---"); dic.Add("PondWeight", fy.PondWeight != null ? fy.PondWeight.ToString() : "---"); dic.Add("WeighBacks", fy.WeighBacks != null ? fy.WeighBacks.ToString() : "---"); dic.Add("AverageYield", fy.AverageYield != null ? fy.AverageYield.ToString() : "---"); dic.Add("HeadedWeight", fy.AverageYield != null && fy.PlantWeight != null ? String.Format("{0:0.00}", ((fy.AverageYield / 100) * (fy.PlantWeight - wb))) : "---"); } else { dic.Add("ProductionTotalId", "-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("ProductionDate", cqDTO.ProductionDate); dic.Add("PlantWeight", "---"); dic.Add("PondWeight", "---"); dic.Add("WeighBacks", "---"); dic.Add("AverageYield", "---"); dic.Add("HeadedWeight", "---"); } 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); }
internal HttpResponseMessage ProductionDates(HttpRequestMessage request, ProductionTotalDTO 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 ProductionTotalRepository(); var u = new ProductionTotal(); if (cqDTO.ProductionDate != null) { cqDTO.Start_ProductionDate = DateTime.Parse(cqDTO.ProductionDate).ToString(); cqDTO.End_ProductionDate = DateTime.Parse(cqDTO.ProductionDate).AddDays(1).ToString(); } else { int sm = int.Parse(cqDTO.StartDateMonth); if (sm == 1) { cqDTO.Start_ProductionDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString(); cqDTO.End_ProductionDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString(); } else if (sm == 12) { cqDTO.Start_ProductionDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_ProductionDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString(); } else { cqDTO.Start_ProductionDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString(); cqDTO.End_ProductionDate = 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>>(); foreach (var item in data) { var dic = new Dictionary<string, string>(); dic.Add("ProductionDate", item.ProductionDate.ToShortDateString()); 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 void UpdateProductionTotalPlantPondWeight(PlantPondWeightDTO uDto) { var pr = new ProductionTotalRepository(); var prod = new ProductionTotal(); var prodexists = pr.GetByDateAndPond(DateTime.Parse(uDto.PPWDateTime), int.Parse(uDto.PondID)); if (prodexists == null) { prod.PondId = int.Parse(uDto.PondID); prod.ProductionDate = DateTime.Parse(uDto.PPWDateTime); if (uDto.PlantWeight != null) { prod.PlantWeight = decimal.Parse(uDto.PlantWeight); } if (uDto.PondWeight != null) { prod.PondWeight = decimal.Parse(uDto.PondWeight); } pr.Save(prod); } else { prod = prodexists; var ppwr = new PlantPondWeightRepository(); List<PlantPondWeight> ppwl = ppwr.GetByDateAndPond(DateTime.Parse(uDto.PPWDateTime), int.Parse(uDto.PondID)); decimal plw = ppwl.Where(x => x.PlantWeight != null).Sum(x => x.PlantWeight).Value; decimal pw = ppwl.Where(x => x.PondWeight != null).Sum(x => x.PondWeight).Value; if (pw != 0) { prod.PondWeight = pw; } if (plw != 0) { prod.PlantWeight = plw; } //if (prod.PlantWeight == null && uDto.PlantWeight != null) //{ // prod.PlantWeight = decimal.Parse(uDto.PlantWeight); //} //else if (prod.PlantWeight != null && uDto.PlantWeight != null) //{ // prod.PlantWeight = prod.PlantWeight + decimal.Parse(uDto.PlantWeight); //} //if (prod.PondWeight == null && uDto.PondWeight != null) //{ // prod.PondWeight = decimal.Parse(uDto.PondWeight); //} //else if (prod.PondWeight != null && uDto.PondWeight != null) //{ // prod.PondWeight = prod.PondWeight + decimal.Parse(uDto.PondWeight); //} pr.Save(prod); } }
private void UpdateProductionTotalWeighBack(WeighBackDTO uDto) { var pr = new ProductionTotalRepository(); var prod = new ProductionTotal(); var prodexists = pr.GetByDateAndPond(DateTime.Parse(uDto.WBDateTime), int.Parse(uDto.PondID)); decimal wb = 0; wb = uDto.Backs == null ? 0 : decimal.Parse(uDto.Backs); wb += uDto.BigFish == null ? 0 : decimal.Parse(uDto.BigFish); wb += uDto.Bream == null ? 0 : decimal.Parse(uDto.Bream); wb += uDto.Carp == null ? 0 : decimal.Parse(uDto.Carp); wb += uDto.DOAs == null ? 0 : decimal.Parse(uDto.DOAs); wb += uDto.DressedDisease == null ? 0 : decimal.Parse(uDto.DressedDisease) / decimal.Parse("0.6"); wb += uDto.LiveDisease == null ? 0 : decimal.Parse(uDto.LiveDisease); wb += uDto.RedFillet == null ? 0 : decimal.Parse(uDto.RedFillet) / decimal.Parse("0.36"); wb += uDto.Shad == null ? 0 : decimal.Parse(uDto.Shad); wb += uDto.Trash == null ? 0 : decimal.Parse(uDto.Trash); wb += uDto.Turtle == null ? 0 : decimal.Parse(uDto.Turtle); if (prodexists == null) { prod.PondId = int.Parse(uDto.PondID); prod.ProductionDate = DateTime.Parse(uDto.WBDateTime); prod.WeighBacks = wb; pr.Save(prod); } else { prod = prodexists; var wbr = new WeighBackRepository(); List<WeighBack> wbl = wbr.GetByDateAndPond(DateTime.Parse(uDto.WBDateTime), int.Parse(uDto.PondID)); wb = wbl.Where(x => x.Backs != null).Sum(x => x.Backs).Value; wb += wbl.Where(x => x.BigFish != null).Sum(x => x.BigFish).Value; wb += wbl.Where(x => x.Bream != null).Sum(x => x.Bream).Value; wb += wbl.Where(x => x.Carp != null).Sum(x => x.Carp).Value; wb += wbl.Where(x => x.DOAs != null).Sum(x => x.DOAs).Value; wb += wbl.Where(x => x.DressedDisease != null).Sum(x => x.DressedDisease).Value / decimal.Parse("0.6"); wb += wbl.Where(x => x.LiveDisease != null).Sum(x => x.LiveDisease).Value; wb += wbl.Where(x => x.RedFillet != null).Sum(x => x.RedFillet).Value / decimal.Parse("0.36"); wb += wbl.Where(x => x.Shad != null).Sum(x => x.Shad).Value; wb += wbl.Where(x => x.Trash != null).Sum(x => x.Trash).Value; wb += wbl.Where(x => x.Turtle != null).Sum(x => x.Turtle).Value; //wb += uDto.Bream == null ? 0 : decimal.Parse(uDto.Bream); //wb += uDto.Carp == null ? 0 : decimal.Parse(uDto.Carp); //wb += uDto.DOAs == null ? 0 : decimal.Parse(uDto.DOAs); //wb += uDto.DressedDisease == null ? 0 : decimal.Parse(uDto.DressedDisease); //wb += uDto.LiveDisease == null ? 0 : decimal.Parse(uDto.LiveDisease); //wb += uDto.RedFillet == null ? 0 : decimal.Parse(uDto.RedFillet); //wb += uDto.Shad == null ? 0 : decimal.Parse(uDto.Shad); //wb += uDto.Trash == null ? 0 : decimal.Parse(uDto.Trash); //wb += uDto.Turtle == null ? 0 : decimal.Parse(uDto.Turtle); //if (prod.WeighBacks == null) //{ // prod.WeighBacks = wb; //} //else //{ // prod.WeighBacks = prod.WeighBacks + wb; //} if (wb != 0) { prod.WeighBacks = wb; } pr.Save(prod); } }