/// <summary>
/// Return Grid Datail from dailyrecord days
/// </summary>
/// <returns></returns>
public List <GridReportPivotState> GetGridDailyRecordIrrigationResumeTitles()
{
#region Local Variables
List <GridReportPivotState> lGridDailyRecordIrrigationResumeList = new List <GridReportPivotState>();
GridReportPivotState lGridDailyRecordIrrigationResume;
#endregion
#region Configuration Variables
UserConfiguration uc;
#endregion
try
{
#region Configuration - Instance
uc = new UserConfiguration();
#endregion
lGridDailyRecordIrrigationResume = new GridReportPivotState("Nombre", "Día", "Fecha", "Riego", "Lluvia");
lGridDailyRecordIrrigationResumeList.Add(lGridDailyRecordIrrigationResume);
}
catch (Exception ex)
{
Utils.LogError(ex, "Exception in ReportPivotState.GetGridDailyRecordIrrigationResumeTitles");
return(null);
}
return(lGridDailyRecordIrrigationResumeList);
}
/// <summary>
/// Return Grid Datail from dailyrecord days
/// </summary>
/// <returns></returns>
public List <GridReportPivotState> GetGridDailyRecordIrrigationResumeTitles()
{
#region Local Variables
List <GridReportPivotState> lGridDailyRecordIrrigationResumeList = new List <GridReportPivotState>();
GridReportPivotState lGridDailyRecordIrrigationResume;
#endregion
try
{
lGridDailyRecordIrrigationResume = new GridReportPivotState("Día", "Fecha", "Riego", "Lluvia");
lGridDailyRecordIrrigationResumeList.Add(lGridDailyRecordIrrigationResume);
}
catch (Exception ex)
{
Utils.LogError(ex, "Exception in CropIrrigationWeathersActiveViewModel.GetGridDailyRecordIrrigationResumeTitles");
return(null);
}
return(lGridDailyRecordIrrigationResumeList);
}
/// <summary>
/// Return Grid Datail from dailyrecord days
/// </summary>
/// <returns></returns>
public List <GridReportPivotState> GetGridDailyRecordIrrigationResume()
{
#region Local Variables
string lEffectiveRain;
string lEffectiveInputWater;
double lEffectiveRainDouble;
double lEffectiveInputWaterDouble;
List <GridReportPivotState> lGridIrrigationUnitList = new List <GridReportPivotState>();
List <GridReportPivotState> lGridDailyRecordIrrigationResumeList = new List <GridReportPivotState>();
GridReportPivotState lGridDailyRecordIrrigationResume = null;
DateTime lDateOfReference;
List <DailyRecord> lDailyRecordList;
DailyRecordConfiguration lDailyRecordConfiguration;
List <IrrigationUnit> lIrrigationUnitList;
List <CropIrrigationWeather> lCropIrrigationWeatherList;
List <Farm> lFarmList;
FarmConfiguration lFarmConfiguration;
UserConfiguration lUserConfiguration;
IrrigationUnitConfiguration lIrrigationUnitConfiguration;
User lLoggedUser;
#endregion
#region Configuration - Instance
lUserConfiguration = new UserConfiguration();
lFarmConfiguration = new FarmConfiguration();
#endregion
try
{
lDateOfReference = Utils.GetDateOfReference().Value;
lIrrigationUnitConfiguration = new IrrigationUnitConfiguration();
lDailyRecordConfiguration = new DailyRecordConfiguration();
lLoggedUser = lUserConfiguration.GetUserByName(ManageSession.GetUserName());
lFarmList = lFarmConfiguration.GetFarmWithActiveCropIrrigationWeathersListBy(lLoggedUser);
//Create IrrigationQuantity Units List
lIrrigationUnitList = new List <IrrigationUnit>();
foreach (Farm lCurrentFarm in lFarmList)
{
lIrrigationUnitList = lIrrigationUnitConfiguration.GetIrrigationUnitListBy(lCurrentFarm);
foreach (var lIrrigationUnit in lIrrigationUnitList)
{
lCropIrrigationWeatherList = lIrrigationUnitConfiguration.GetCropIrrigationWeatherListIncludeCropMainWeatherStationRainListIrrigationListBy(lIrrigationUnit, lDateOfReference);
foreach (CropIrrigationWeather lCropIrrigationWeather in lCropIrrigationWeatherList)
{
lDailyRecordList = lDailyRecordConfiguration.GetDailyRecordsListDataUntilDateBy(lCropIrrigationWeather.CropIrrigationWeatherId, lDateOfReference);
foreach (var lDailyRecordUnit in lDailyRecordList)
{
lEffectiveRain = "";
lEffectiveInputWater = "";
lEffectiveRainDouble = 0;
lEffectiveInputWaterDouble = 0;
if (lDailyRecordUnit.Rain != null)
{
lEffectiveRainDouble = lDailyRecordUnit.Rain.ExtraInput + lDailyRecordUnit.Rain.Input;
}
if (lDailyRecordUnit.Irrigation != null)
{
lEffectiveInputWaterDouble = lDailyRecordUnit.Irrigation.ExtraInput + lDailyRecordUnit.Irrigation.Input;
}
if (lEffectiveRainDouble + lEffectiveInputWaterDouble > 0) // not input
{
if (lEffectiveRainDouble != 0)
{
lEffectiveRain = lEffectiveRainDouble.ToString();
}
if (lEffectiveInputWaterDouble != 0)
{
lEffectiveInputWater = lEffectiveInputWaterDouble.ToString();
}
lGridDailyRecordIrrigationResume = new GridReportPivotState(lCurrentFarm.Name + " | " + lCropIrrigationWeather.IrrigationUnit.ShortName, lDailyRecordUnit.DaysAfterSowing.ToString(), lDailyRecordUnit.DailyRecordDateTime.ToShortDateString(), lEffectiveRain, lEffectiveInputWater);
lGridDailyRecordIrrigationResumeList.Add(lGridDailyRecordIrrigationResume);
}
}
}
}
}
}
catch (Exception ex)
{
Utils.LogError(ex, "Exception in ReportPivotState.GetGridDailyRecordIrrigationResume \n {0} ");
return(null);
}
return(lGridDailyRecordIrrigationResumeList);
}
/// <summary>
/// Return Grid Datail from dailyrecord days
/// </summary>
/// <returns></returns>
public List <GridReportPivotState> GetGridDailyRecordIrrigationResume()
{
#region Local Variables
List <GridReportPivotState> lGridIrrigationUnitList = new List <GridReportPivotState>();
List <GridReportPivotState> lGridDailyRecordIrrigationResumeList = new List <GridReportPivotState>();
GridReportPivotState lGridDailyRecordIrrigationResume = null;
string lEffectiveRain;
string lEffectiveInputWater;
double lEffectiveRainDouble;
double lEffectiveInputWaterDouble;
List <DailyRecord> lDailyRecordList;
DailyRecordConfiguration drc;
#endregion
try
{
drc = new DailyRecordConfiguration();
lDailyRecordList = drc.GetDailyRecordsListDataUntilDateBy(ciwId, Utils.GetDateOfReference().Value);
foreach (var lDailyRecordUnit in lDailyRecordList)
{
lEffectiveRain = "";
lEffectiveInputWater = "";
lEffectiveRainDouble = 0;
lEffectiveInputWaterDouble = 0;
if (lDailyRecordUnit.Rain != null)
{
lEffectiveRainDouble = lDailyRecordUnit.Rain.ExtraInput + lDailyRecordUnit.Rain.Input;
}
if (lDailyRecordUnit.Irrigation != null)
{
lEffectiveInputWaterDouble = lDailyRecordUnit.Irrigation.ExtraInput + lDailyRecordUnit.Irrigation.Input;
}
if (lEffectiveRainDouble + lEffectiveInputWaterDouble > 0) // not input
{
if (lEffectiveRainDouble != 0)
{
lEffectiveRain = lEffectiveRainDouble.ToString();
}
if (lEffectiveInputWaterDouble != 0)
{
lEffectiveInputWater = lEffectiveInputWaterDouble.ToString();
}
lGridDailyRecordIrrigationResume = new GridReportPivotState(lDailyRecordUnit.DaysAfterSowing.ToString(), lDailyRecordUnit.DailyRecordDateTime.ToShortDateString(), lEffectiveRain, lEffectiveInputWater);
lGridDailyRecordIrrigationResumeList.Add(lGridDailyRecordIrrigationResume);
}
}
}
catch (Exception ex)
{
Utils.LogError(ex, "Exception in ReportPivotState.GetGridDailyRecordIrrigationResume \n {0} ");
return(null);
}
return(lGridDailyRecordIrrigationResumeList);
}
/// <summary>
/// Return Grid Datail from dailyrecord days
/// </summary>
/// <returns></returns>
public List <GridReportPivotState> GetGridDailyRecordIrrigationResume(IrrigationUnit pIrrigationUnit)
{
#region Local Variables
string lEffectiveRain;
string lEffectiveInputWater;
double lEffectiveRainDouble;
double lEffectiveInputWaterDouble;
List <GridReportPivotState> lGridIrrigationUnitList = new List <GridReportPivotState>();
List <GridReportPivotState> lGridDailyRecordIrrigationResumeList = new List <GridReportPivotState>();
GridReportPivotState lGridDailyRecordIrrigationResume = null;
DateTime lDateOfReference;
List <DailyRecord> lDailyRecordList;
DailyRecordConfiguration lDailyRecordConfiguration;
List <CropIrrigationWeather> lCropIrrigationWeatherList;
IrrigationUnitConfiguration lIrrigationUnitConfiguration;
#endregion
try
{
lDateOfReference = Utils.GetDateOfReference().Value;
lIrrigationUnitConfiguration = new IrrigationUnitConfiguration();
lDailyRecordConfiguration = new DailyRecordConfiguration();
lCropIrrigationWeatherList = lIrrigationUnitConfiguration.GetCropIrrigationWeatherListIncludeCropMainWeatherStationRainListIrrigationListBy(pIrrigationUnit, lDateOfReference);
foreach (CropIrrigationWeather lCropIrrigationWeather in lCropIrrigationWeatherList)
{
lDailyRecordList = lDailyRecordConfiguration.GetDailyRecordsListDataUntilDateBy(lCropIrrigationWeather.CropIrrigationWeatherId, lDateOfReference);
foreach (var lDailyRecordUnit in lDailyRecordList)
{
lEffectiveRain = "";
lEffectiveInputWater = "";
lEffectiveRainDouble = 0;
lEffectiveInputWaterDouble = 0;
if (lDailyRecordUnit.Rain != null)
{
lEffectiveRainDouble = lDailyRecordUnit.Rain.ExtraInput + lDailyRecordUnit.Rain.Input;
}
if (lDailyRecordUnit.Irrigation != null)
{
lEffectiveInputWaterDouble = lDailyRecordUnit.Irrigation.ExtraInput + lDailyRecordUnit.Irrigation.Input;
}
if (lEffectiveRainDouble + lEffectiveInputWaterDouble > 0) // not input
{
if (lEffectiveRainDouble != 0)
{
lEffectiveRain = lEffectiveRainDouble.ToString();
}
if (lEffectiveInputWaterDouble != 0)
{
lEffectiveInputWater = lEffectiveInputWaterDouble.ToString();
}
lGridDailyRecordIrrigationResume = new GridReportPivotState(lDailyRecordUnit.DaysAfterSowing.ToString(), lDailyRecordUnit.DailyRecordDateTime.ToShortDateString(), lEffectiveRain, lEffectiveInputWater);
lGridDailyRecordIrrigationResumeList.Add(lGridDailyRecordIrrigationResume);
}
}
}
}
catch (Exception ex)
{
Utils.LogError(ex, "Exception in ReportPivotState.GetGridDailyRecordIrrigationResume \n {0} ");
return(null);
}
return(lGridDailyRecordIrrigationResumeList);
}
