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