public CropRequirementRemoval GetCropRequirementRemoval()
{
decimal n_removal = 0;
ConversionFactor _cf = _sd.GetConversionFactor();
CropRequirementRemoval crr = new CropRequirementRemoval();
Crop crop = _sd.GetCrop(cropid);
// For testing we're using Soil Test Kelowna of 65ppm, should actually by 100+ (say 101)
//
// Nutrient removal
// P2O5 = crop.cropremovalfactor_P2O5 * yield
// K2O = crop.cropremovalfactor_K2O * yield
// N = crop.cropremovalfactor_N * yield
// if crude_protien exists and is not default
// crop.cropremovalfactor_N = (crude protien / (0.625 * 0.5))
// N = crop.cropremovalfactor_N * yield
// else
// N = crop.cropremovalfactor_N * yield
//
// Note for Cover crops (only)
// if Cover Crop harvested
// don't change numbers
// if Cover crop not harvested
// set all removal amts to zero
if (!crudeProtien.HasValue || (crudeProtien.HasValue && crudeProtien.Value == 0))
{
decimal tmpDec;
if (decimal.TryParse(crop.cropremovalfactor_N.ToString(), out tmpDec))
{
n_removal = tmpDec * yield;
}
else
{
n_removal = 0;
}
}
else
{
n_removal = decimal.Divide(Convert.ToDecimal(crudeProtien), (_cf.n_protein_conversion * _cf.unit_conversion)) * yield;
}
crr.P2O5_Removal = Convert.ToInt32(crop.cropremovalfactor_P2O5 * yield);
crr.K2O_Removal = Convert.ToInt32(crop.cropremovalfactor_K2O * yield);
crr.N_Removal = Convert.ToInt32(n_removal);
if (coverCropHarvested.HasValue && coverCropHarvested.Value == false)
{
crr.P2O5_Removal = 0;
crr.K2O_Removal = 0;
crr.N_Removal = 0;
}
// Crop Requirement
// P205
// get region.soil_test_phospherous_region_cd
// get phosphorous_crop_group_region_cd = crop_stp_regioncd(cropid, region.soil_test_phospherous_region_cd)
// get stp_kelowna_range.id usign default ST Kelowna (65) between range_low and range_high
// get P2O5 recommedation = stp_recommend(stp_kelowna_range.id, region.soil_test_phospherous_region_cd, phosphorous_crop_group_region_cd)
//
// same as above for K2O
//
// For N
// Look up crop.n_recommcd
// if 0 or 1
// N = crop.n_recomm_lbperac
// if 2
// same as N removal
// if 3
// get default yield = cropyield(cropid, locationid)
// N = (yield / default yield) * crop.n_recomm_lbperac
int regionid = _ud.FarmDetails().farmRegion.Value;
Region region = _sd.GetRegion(regionid);
Field fld = _ud.GetFieldDetails(fieldName);
if (fld.soilTest == null)
{
fld.soilTest = new SoilTest();
DefaultSoilTest dt = _sd.GetDefaultSoilTest();
fld.soilTest.valNO3H = dt.nitrogen;
fld.soilTest.ValP = dt.phosphorous;
fld.soilTest.valK = dt.potassium;
fld.soilTest.valPH = dt.pH;
fld.soilTest.ConvertedKelownaK = dt.convertedKelownaK;
fld.soilTest.ConvertedKelownaP = dt.convertedKelownaP;
}
int _STP = fld.soilTest.ConvertedKelownaP;
if (_STP == 0)
{
_STP = _cf.defaultSoilTestKelownaP;
}
int _STK = fld.soilTest.ConvertedKelownaK;
if (fld.soilTest.ConvertedKelownaK == 0)
{
_STK = _cf.defaultSoilTestKelownaK;
}
// p2o5 recommend calculations
CropSTPRegionCd cropSTPRegionCd = _sd.GetCropSTPRegionCd(cropid, region.soil_test_phospherous_region_cd);
int? phosphorous_crop_group_region_cd = cropSTPRegionCd.phosphorous_crop_group_region_cd;
STPKelownaRange sTPKelownaRange = _sd.GetSTPKelownaRangeByPpm(_STP);
int stp_kelowna_range_id = sTPKelownaRange.id;
if (phosphorous_crop_group_region_cd == null)
{
crr.P2O5_Requirement = 0;
}
else
{
STPRecommend sTPRecommend = _sd.GetSTPRecommend(stp_kelowna_range_id, region.soil_test_phospherous_region_cd, Convert.ToInt16(phosphorous_crop_group_region_cd));
crr.P2O5_Requirement = Convert.ToInt32(Convert.ToDecimal(sTPRecommend.p2o5_recommend_kgperha) * _cf.kgperha_lbperac_conversion);
}
// k2o recommend calculations
CropSTKRegionCd cropSTKRegionCd = _sd.GetCropSTKRegionCd(cropid, region.soil_test_potassium_region_cd);
int? potassium_crop_group_region_cd = cropSTKRegionCd.potassium_crop_group_region_cd;
STKKelownaRange sTKKelownaRange = _sd.GetSTKKelownaRangeByPpm(_STK);
int stk_kelowna_range_id = sTKKelownaRange.id;
if (potassium_crop_group_region_cd == null)
{
crr.K2O_Requirement = 0;
}
else
{
STKRecommend sTKRecommend = _sd.GetSTKRecommend(stk_kelowna_range_id, region.soil_test_potassium_region_cd, Convert.ToInt16(potassium_crop_group_region_cd));
crr.K2O_Requirement = Convert.ToInt32(Convert.ToDecimal(sTKRecommend.k2o_recommend_kgperha) * _cf.kgperha_lbperac_conversion);
}
// n recommend calculations -note the excel n_recommd are zero based, the static data is 1 based
switch (crop.n_recommcd)
{
case 1:
crr.N_Requirement = Convert.ToInt16(crop.n_recomm_lbperac);
break;
case 2:
crr.N_Requirement = Convert.ToInt16(crop.n_recomm_lbperac);
break;
case 3:
crr.N_Requirement = crr.N_Removal;
break;
case 4:
CropYield cropYield = _sd.GetCropYield(cropid, region.locationid);
if (cropYield.amt != null)
{
crr.N_Requirement = Convert.ToInt16(decimal.Divide(yield, Convert.ToDecimal(cropYield.amt)) * crop.n_recomm_lbperac);
}
else
{
crr.N_Requirement = 0;
}
break;
}
// if a previous crop has been ploughed dowm account for the N in the field (passed in as a credit)
crr.N_Requirement = crr.N_Requirement - nCredit;
// only reduce to 0
crr.N_Requirement = (crr.N_Requirement < 0) ? 0 : crr.N_Requirement;
return(crr);
}
public async Task <string> RenderSummary()
{
string crpName = string.Empty;
Utility.SoilTestConversions stc = new SoilTestConversions(_ud, _sd);
ReportSummaryViewModel rvm = new ReportSummaryViewModel();
rvm.testMethod = string.IsNullOrEmpty(_ud.FarmDetails().testingMethod) ? "Not Specified" : _sd.GetSoilTestMethod(_ud.FarmDetails().testingMethod);
rvm.year = _ud.FarmDetails().year;
FarmDetails fd = _ud.FarmDetails();
rvm.tests = new List <ReportSummaryTest>();
List <Field> flds = _ud.GetFields();
foreach (var m in flds)
{
ReportSummaryTest dc = new ReportSummaryTest();
dc.fieldName = m.fieldName;
if (m.soilTest != null)
{
dc.sampleDate = m.soilTest.sampleDate.ToString("MMM-yyyy");
dc.nitrogen = m.soilTest.valNO3H.ToString();
dc.phosphorous = m.soilTest.ValP.ToString();
dc.potassium = m.soilTest.valK.ToString();
dc.pH = m.soilTest.valPH.ToString();
dc.phosphorousRange = _sd.SoilTestRating("phosphorous", stc.GetConvertedSTP(m.soilTest));
dc.potassiumRange = _sd.SoilTestRating("potassium", stc.GetConvertedSTK(m.soilTest));
}
else
{
DefaultSoilTest dt = _sd.GetDefaultSoilTest();
SoilTest st = new SoilTest();
st.valPH = dt.pH;
st.ValP = dt.phosphorous;
st.valK = dt.potassium;
st.valNO3H = dt.nitrogen;
st.ConvertedKelownaP = dt.convertedKelownaP;
st.ConvertedKelownaK = dt.convertedKelownaK;
dc.sampleDate = "Default Values";
dc.nitrogen = dt.nitrogen.ToString();
dc.phosphorous = dt.phosphorous.ToString();
dc.potassium = dt.potassium.ToString();
dc.pH = dt.pH.ToString();
dc.phosphorousRange = _sd.SoilTestRating("phosphorous", stc.GetConvertedSTP(st));
dc.potassiumRange = _sd.SoilTestRating("potassium", stc.GetConvertedSTK(st));
}
dc.fieldCrops = null;
List <FieldCrop> crps = _ud.GetFieldCrops(m.fieldName);
if (crps != null)
{
foreach (var c in crps)
{
crpName = string.IsNullOrEmpty(c.cropOther) ? _sd.GetCrop(Convert.ToInt32(c.cropId)).cropname : c.cropOther;
dc.fieldCrops = string.IsNullOrEmpty(dc.fieldCrops) ? crpName : dc.fieldCrops + "\n" + crpName;
}
}
rvm.tests.Add(dc);
}
var result = await _viewRenderService.RenderToStringAsync("~/Views/Report/ReportSummary.cshtml", rvm);
return(result);
}
