public IEnumerable<PowerViewModel> Get_Power_Log_Month(int? targetMonth, int? targetYear)
{
if (targetMonth == null)
targetMonth = DateTime.Today.Month;
if (targetYear == null)
targetYear = DateTime.Today.Year;
int nDay = DateTime.DaysInMonth(targetYear ?? DateTime.Today.Year, targetMonth ?? DateTime.Today.Month);
int nDayLastMonth = 0;
if(targetMonth != null && targetYear != null)
{
if (targetMonth == 1)
nDayLastMonth = DateTime.DaysInMonth((int)targetYear - 1, 12);
else
nDayLastMonth = DateTime.DaysInMonth((int)targetYear, (int)targetMonth - 1);
}
else
{
if(DateTime.Today.Month == 1)
nDayLastMonth = DateTime.DaysInMonth(DateTime.Today.Year-1, 12);
else
nDayLastMonth = DateTime.DaysInMonth(DateTime.Today.Year, DateTime.Today.Month - 1);
}
var queryDoingam = from x in db.doingam_log1hr
where (SqlFunctions.DatePart("month", x.LocalCol.Value) == targetMonth
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetYear
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8)
|| (
SqlFunctions.DatePart("day", x.LocalCol.Value) == nDayLastMonth
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == ((targetMonth==1)? 12 : targetMonth - 1)
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == ((targetMonth==1)? targetYear-1 : targetYear)
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8
)
select new dayViewModel
{
day = x.LocalCol.Value.Day,
energy = (x.Doingam_MBInDataEnergy??0)/10
};
var queryHigh1 = from x in db.high1_log1hr
where (SqlFunctions.DatePart("month", x.LocalCol.Value) == targetMonth
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetYear
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8)
|| (
SqlFunctions.DatePart("day", x.LocalCol.Value) == nDayLastMonth
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == ((targetMonth == 1) ? 12 : targetMonth - 1)
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == ((targetMonth == 1) ? targetYear - 1 : targetYear)
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8
)
select new dayViewModel
{
day = x.LocalCol.Value.Day,
energy = x.High1_DataEnergy??0
};
var queryHigh2 = from x in db.high2_log1hr
where (SqlFunctions.DatePart("month", x.LocalCol.Value) == targetMonth
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetYear
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8)
|| (
SqlFunctions.DatePart("day", x.LocalCol.Value) == nDayLastMonth
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == ((targetMonth == 1) ? 12 : targetMonth - 1)
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == ((targetMonth == 1) ? targetYear - 1 : targetYear)
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8
)
select new dayViewModel
{
day = x.LocalCol.Value.Day,
energy = x.High2_DataEnergy??0
};
var queryHuainamrin = from x in db.huainamrin_log1hr
where (SqlFunctions.DatePart("month", x.LocalCol.Value) == targetMonth
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetYear
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8)
|| (
SqlFunctions.DatePart("day", x.LocalCol.Value) == nDayLastMonth
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == ((targetMonth == 1) ? 12 : targetMonth - 1)
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == ((targetMonth == 1) ? targetYear - 1 : targetYear)
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8
)
select new dayViewModel
{
day = x.LocalCol.Value.Day,
energy = (x.Huaynamrin_DataEnergy ?? 0) / 10
};
var queryRawwater = from x in db.low_log1hr
where (SqlFunctions.DatePart("month", x.LocalCol.Value) == targetMonth
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetYear
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8)
|| (
SqlFunctions.DatePart("day", x.LocalCol.Value) == nDayLastMonth
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == ((targetMonth == 1) ? 12 : targetMonth - 1)
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == ((targetMonth == 1) ? targetYear - 1 : targetYear)
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8
)
select new dayViewModel
{
day = x.LocalCol.Value.Day,
energy = (x.RawWater_DataEnergy ?? 0) / 10
};
var queryPhajome = from x in db.pharjome_log1hr
where (SqlFunctions.DatePart("month", x.LocalCol.Value) == targetMonth
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetYear
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8)
|| (
SqlFunctions.DatePart("day", x.LocalCol.Value) == nDayLastMonth
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == ((targetMonth == 1) ? 12 : targetMonth - 1)
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == ((targetMonth == 1) ? targetYear - 1 : targetYear)
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8
)
select new dayViewModel
{
day = x.LocalCol.Value.Day,
energy = (x.Phajome_DataEnergy ?? 0) / 10
};
var queryPhom = from x in db.phom_log1hr
where (SqlFunctions.DatePart("month", x.LocalCol.Value) == targetMonth
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetYear
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8)
|| (
SqlFunctions.DatePart("day", x.LocalCol.Value) == nDayLastMonth
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == ((targetMonth == 1) ? 12 : targetMonth - 1)
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == ((targetMonth == 1) ? targetYear - 1 : targetYear)
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8
)
select new dayViewModel
{
day = x.LocalCol.Value.Day,
energy = (x.Phomvihane_DataEnergy ?? 0) / 10
};
var querySoonchar = from x in db.soonchar_log1hr
where (SqlFunctions.DatePart("month", x.LocalCol.Value) == targetMonth
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetYear
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8)
|| (
SqlFunctions.DatePart("day", x.LocalCol.Value) == nDayLastMonth
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == ((targetMonth == 1) ? 12 : targetMonth - 1)
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == ((targetMonth == 1) ? targetYear - 1 : targetYear)
&& SqlFunctions.DatePart("hour", x.LocalCol.Value) == 8
)
select new dayViewModel
{
day = x.LocalCol.Value.Day,
energy = (x.Sooncha_DataEnergy ?? 0) / 10
};
List<dayViewModel> dayList = new List<dayViewModel>();
for (int i = 1; i <= nDay; i++)
{
dayList.Add(new dayViewModel { day = i, energy = 0 });
}
PowerViewModel sumEnergy = new PowerViewModel();
try
{
// Substract
var doingamList = queryDoingam.ToList();
if(doingamList.Count > 1)
{
for (int i = doingamList.Count - 1; i > 0; i--)
{
if (doingamList[i].energy >= doingamList[i - 1].energy)
doingamList[i].diffEnergy = doingamList[i].energy - doingamList[i - 1].energy;
else
doingamList[i].diffEnergy = 0;
}
if (doingamList[1].day < doingamList[0].day)
doingamList.RemoveAt(0);
}
var high1List = queryHigh1.ToList();
if(high1List.Count > 1)
{
for (int i = high1List.Count - 1; i > 0; i--)
{
if (high1List[i].energy >= high1List[i - 1].energy)
high1List[i].diffEnergy = high1List[i].energy - high1List[i - 1].energy;
else
high1List[i].diffEnergy = 0;
}
if (high1List[1].day < high1List[0].day)
high1List.RemoveAt(0);
}
var high2List = queryHigh2.ToList();
if(high2List.Count > 1)
{
for (int i = high2List.Count - 1; i > 0; i--)
{
if (high2List[i].energy >= high2List[i - 1].energy)
high2List[i].diffEnergy = high2List[i].energy - high2List[i - 1].energy;
else
high2List[i].diffEnergy = 0;
}
if (high2List[1].day < high2List[0].day)
high2List.RemoveAt(0);
}
var huainamrinList = queryHuainamrin.ToList();
if(huainamrinList.Count > 1)
{
for (int i = huainamrinList.Count - 1; i > 0; i--)
{
if (huainamrinList[i].energy >= huainamrinList[i - 1].energy)
huainamrinList[i].diffEnergy = huainamrinList[i].energy - huainamrinList[i - 1].energy;
else
huainamrinList[i].diffEnergy = 0;
}
if (huainamrinList[1].day < huainamrinList[0].day)
huainamrinList.RemoveAt(0);
}
var rawwaterList = queryRawwater.ToList();
if(rawwaterList.Count > 1)
{
for (int i = rawwaterList.Count - 1; i > 0; i--)
{
if (rawwaterList[i].energy >= rawwaterList[i - 1].energy)
rawwaterList[i].diffEnergy = rawwaterList[i].energy - rawwaterList[i - 1].energy;
else
rawwaterList[i].diffEnergy = 0;
}
if (rawwaterList[1].day < rawwaterList[0].day)
rawwaterList.RemoveAt(0);
}
var phajomeList = queryPhajome.ToList();
if(phajomeList.Count > 1)
{
for (int i = phajomeList.Count - 1; i > 0; i--)
{
if (phajomeList[i].energy >= phajomeList[i - 1].energy)
phajomeList[i].diffEnergy = phajomeList[i].energy - phajomeList[i - 1].energy;
else
phajomeList[i].diffEnergy = 0;
}
if (phajomeList[1].day < phajomeList[0].day)
phajomeList.RemoveAt(0);
}
var phomList = queryPhom.ToList();
if(phomList.Count > 1 )
{
for (int i = phomList.Count - 1; i > 0; i--)
{
if (phomList[i].energy >= phomList[i - 1].energy)
phomList[i].diffEnergy = phomList[i].energy - phomList[i - 1].energy;
else
phomList[i].diffEnergy = 0;
}
if (phomList[1].day < phomList[0].day)
phomList.RemoveAt(0);
}
var sooncharList = querySoonchar.ToList();
if(sooncharList.Count > 1)
{
for (int i = sooncharList.Count - 1; i > 0; i--)
{
if (sooncharList[i].energy >= sooncharList[i - 1].energy)
sooncharList[i].diffEnergy = sooncharList[i].energy - sooncharList[i - 1].energy;
else
sooncharList[i].diffEnergy = 0;
}
if (sooncharList[1].day < sooncharList[0].day)
sooncharList.RemoveAt(0);
}
var list = from x in dayList
join y1 in rawwaterList on x.day equals y1.day into g1
from t1 in g1.Where(k => k.day == x.day).DefaultIfEmpty()
join y2 in doingamList on x.day equals y2.day into g2
from t2 in g2.Where(k => k.day == x.day).DefaultIfEmpty()
join y3 in high1List on x.day equals y3.day into g3
from t3 in g3.Where(k => k.day == x.day).DefaultIfEmpty()
join y4 in high2List on x.day equals y4.day into g4
from t4 in g4.Where(k => k.day == x.day).DefaultIfEmpty()
join y5 in huainamrinList on x.day equals y5.day into g5
from t5 in g5.Where(k => k.day == x.day).DefaultIfEmpty()
join y6 in phajomeList on x.day equals y6.day into g6
from t6 in g6.Where(k => k.day == x.day).DefaultIfEmpty()
join y7 in phomList on x.day equals y7.day into g7
from t7 in g7.Where(k => k.day == x.day).DefaultIfEmpty()
join y8 in sooncharList on x.day equals y8.day into g8
from t8 in g8.Where(k => k.day == x.day).DefaultIfEmpty()
select new PowerViewModel
{
timeStamp = x.day.ToString(),
rawWater = t1 == null ? 0.00 : Math.Round((double)t1.energy, 2),
rawWaterDiff = t1 == null ? 0.00 : Math.Round((double)t1.diffEnergy, 2),
doiNgam = t2 == null ? 0.00 : Math.Round((double)t2.energy, 2),
doiNgamDiff = t2 == null ? 0.00 : Math.Round((double)t2.diffEnergy, 2),
high1 = t3 == null ? 0.00 : Math.Round((double)t3.energy, 2),
high1Diff = t3 == null ? 0.00 : Math.Round((double)t3.diffEnergy, 2),
high2 = t4 == null ? 0.00 : Math.Round((double)t4.energy, 2),
high2Diff = t4 == null ? 0.00 : Math.Round((double)t4.diffEnergy, 2),
huaiNamrin = t5 == null ? 0.00 : Math.Round((double)t5.energy, 2),
huaiNamrinDiff = t5 == null ? 0.00 : Math.Round((double)t5.diffEnergy, 2),
phaJome = t6 == null ? 0.00 : Math.Round((double)t6.energy, 2),
phaJomeDiff = t6 == null ? 0.00 : Math.Round((double)t6.diffEnergy, 2),
phom = t7 == null ? 0.00 : Math.Round((double)t7.energy, 2),
phomDiff = t7 == null ? 0.00 : Math.Round((double)t7.diffEnergy, 2),
soonChar = t8 == null ? 0.00 : Math.Round((double)t8.energy, 2),
soonCharDiff = t8 == null ? 0.00 : Math.Round((double)t8.diffEnergy, 2),
};
List<PowerViewModel> newList = new List<PowerViewModel>();
newList = list.ToList();
for (int i = 0; i<newList.Count; i++)
{
sumEnergy.timeStamp = "Total";
sumEnergy.doiNgamDiff = Math.Round(sumEnergy.doiNgamDiff + newList[i].doiNgamDiff, 2);
sumEnergy.rawWaterDiff = Math.Round(sumEnergy.rawWaterDiff + newList[i].rawWaterDiff, 2);
sumEnergy.high1Diff = Math.Round(sumEnergy.high1Diff + newList[i].high1Diff, 2);
sumEnergy.high2Diff = Math.Round(sumEnergy.high2Diff + newList[i].high2Diff, 2);
sumEnergy.huaiNamrinDiff = Math.Round(sumEnergy.huaiNamrinDiff + newList[i].huaiNamrinDiff, 2);
sumEnergy.phaJomeDiff = Math.Round(sumEnergy.phaJomeDiff + newList[i].phaJomeDiff, 2);
sumEnergy.phomDiff = Math.Round(sumEnergy.phomDiff + newList[i].phomDiff, 2);
sumEnergy.soonCharDiff = Math.Round(sumEnergy.soonCharDiff + newList[i].soonCharDiff, 2);
}
sumEnergy.doiNgam = (doingamList.Count > 1) ? Math.Round(doingamList[doingamList.Count - 1].energy,2) : 0;
sumEnergy.rawWater = (rawwaterList.Count > 1) ? Math.Round(rawwaterList[rawwaterList.Count - 1].energy,2) : 0;
sumEnergy.high1 = (high1List.Count > 1) ? Math.Round(high1List[high1List.Count - 1].energy,2) : 0;
sumEnergy.high2 = (high2List.Count > 1) ? Math.Round(high2List[high2List.Count - 1].energy,2) : 0;
sumEnergy.huaiNamrin = (huainamrinList.Count > 1) ? Math.Round(huainamrinList[huainamrinList.Count - 1].energy,2) : 0;
sumEnergy.phaJome = (phajomeList.Count > 1) ? Math.Round(phajomeList[phajomeList.Count - 1].energy,2) : 0;
sumEnergy.phom = (phomList.Count > 1) ? Math.Round(phomList[phomList.Count - 1].energy,2) : 0;
sumEnergy.soonChar = (sooncharList.Count > 1) ? Math.Round(sooncharList[sooncharList.Count - 1].energy,2) : 0;
newList.Add(sumEnergy);
return newList;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
return null;
}
}
public IEnumerable<PowerViewModel> Get_Power_Log(DateTime targetDate)
{
if (targetDate == null)
targetDate = DateTime.Today;
var queryDoingam = from x in db.doingam_log1hr
where SqlFunctions.DatePart("day", x.LocalCol.Value) == SqlFunctions.DatePart("day", targetDate.Date)
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == targetDate.Month
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetDate.Year
orderby x.LocalCol ascending
select new
{
hr = x.LocalCol.Value.Hour,
energy = x.Doingam_MBInDataEnergy / 10
};
var queryHigh1 = from x in db.high1_log1hr
where SqlFunctions.DatePart("day", x.LocalCol.Value) == SqlFunctions.DatePart("day", targetDate.Date)
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == targetDate.Month
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetDate.Year
orderby x.LocalCol ascending
select new
{
hr = x.LocalCol.Value.Hour,
energy = x.High1_DataEnergy
};
var queryHigh2 = from x in db.high2_log1hr
where SqlFunctions.DatePart("day", x.LocalCol.Value) == SqlFunctions.DatePart("day", targetDate.Date)
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == targetDate.Month
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetDate.Year
orderby x.LocalCol ascending
select new
{
hr = x.LocalCol.Value.Hour,
energy = x.High2_DataEnergy
};
var queryHuainamrin = from x in db.huainamrin_log1hr
where SqlFunctions.DatePart("day", x.LocalCol.Value) == SqlFunctions.DatePart("day", targetDate.Date)
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == targetDate.Month
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetDate.Year
orderby x.LocalCol ascending
select new
{
hr = x.LocalCol.Value.Hour,
energy = x.Huaynamrin_DataEnergy / 10
};
var queryRawwater = from x in db.low_log1hr
where SqlFunctions.DatePart("day", x.LocalCol.Value) == SqlFunctions.DatePart("day", targetDate.Date)
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == targetDate.Month
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetDate.Year
orderby x.LocalCol ascending
select new
{
hr = x.LocalCol.Value.Hour,
energy = x.RawWater_DataEnergy
};
var queryPhajome = from x in db.pharjome_log1hr
where SqlFunctions.DatePart("day", x.LocalCol.Value) == SqlFunctions.DatePart("day", targetDate.Date)
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == targetDate.Month
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetDate.Year
orderby x.LocalCol ascending
select new
{
hr = x.LocalCol.Value.Hour,
energy = x.Phajome_DataEnergy / 10
};
var queryPhom = from x in db.phom_log1hr
where SqlFunctions.DatePart("day", x.LocalCol.Value) == SqlFunctions.DatePart("day", targetDate.Date)
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == targetDate.Month
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetDate.Year
orderby x.LocalCol ascending
select new
{
hr = x.LocalCol.Value.Hour,
energy = x.Phomvihane_DataEnergy / 10
};
var querySoonchar = from x in db.soonchar_log1hr
where SqlFunctions.DatePart("day", x.LocalCol.Value) == SqlFunctions.DatePart("day", targetDate.Date)
&& SqlFunctions.DatePart("month", x.LocalCol.Value) == targetDate.Month
&& SqlFunctions.DatePart("year", x.LocalCol.Value) == targetDate.Year
orderby x.LocalCol ascending
select new
{
hr = x.LocalCol.Value.Hour,
energy = x.Sooncha_DataEnergy / 10
};
List<HrViewModel> hrList = new List<HrViewModel>();
for(int i=0; i<=23; i++)
{
hrList.Add(new HrViewModel { hr = i, energy = 0 });
}
try
{
var doingamList = queryDoingam.ToList();
var high1List = queryHigh1.ToList();
var high2List = queryHigh2.ToList();
var huainamrinList = queryHuainamrin.ToList();
var rawwaterList = queryRawwater.ToList();
var phajomeList = queryPhajome.ToList();
var phomList = queryPhom.ToList();
var sooncharList = querySoonchar.ToList();
var list = from x in hrList
join y1 in rawwaterList on x.hr equals y1.hr into g1
from t1 in g1.Where(k => k.hr == x.hr).DefaultIfEmpty()
join y2 in doingamList on x.hr equals y2.hr into g2
from t2 in g2.Where(k => k.hr == x.hr).DefaultIfEmpty()
join y3 in high1List on x.hr equals y3.hr into g3
from t3 in g3.Where(k => k.hr == x.hr).DefaultIfEmpty()
join y4 in high2List on x.hr equals y4.hr into g4
from t4 in g4.Where(k => k.hr == x.hr).DefaultIfEmpty()
join y5 in huainamrinList on x.hr equals y5.hr into g5
from t5 in g5.Where(k => k.hr == x.hr).DefaultIfEmpty()
join y6 in phajomeList on x.hr equals y6.hr into g6
from t6 in g6.Where(k => k.hr == x.hr).DefaultIfEmpty()
join y7 in phomList on x.hr equals y7.hr into g7
from t7 in g7.Where(k => k.hr == x.hr).DefaultIfEmpty()
join y8 in sooncharList on x.hr equals y8.hr into g8
from t8 in g8.Where(k => k.hr == x.hr).DefaultIfEmpty()
select new PowerViewModel
{
timeStamp = x.hr.ToString() + ":00",
rawWater = t1 == null ? 0.00 : (double)t1.energy,
doiNgam = t2 == null ? 0.00 : (double)t2.energy,
high1 = t3 == null ? 0.00 : (double)t3.energy,
high2 = t4 == null ? 0.00 : (double)t4.energy,
huaiNamrin = t5 == null ? 0.00 : (double)t5.energy,
phaJome = t6 == null ? 0.00 : (double)t6.energy,
phom = t7 == null ? 0.00 : (double)t7.energy,
soonChar = t8 == null ? 0.00 : (double)t8.energy,
};
List<PowerViewModel> newList = new List<PowerViewModel>();
PowerViewModel sumEnergy = new PowerViewModel();
newList = list.ToList();
for (int i=23; i>=0; i--)
{
if (i == 0)
{
newList[i].doiNgam = 0.00;
newList[i].rawWater = 0.00;
newList[i].high1 = 0.00;
newList[i].high2 = 0.00;
newList[i].huaiNamrin = 0.00;
newList[i].phaJome = 0.00;
newList[i].phom = 0.00;
newList[i].soonChar = 0.00;
}
else
{
newList[i].doiNgam = (newList[i - 1].doiNgam == 0.00) ? 0.00 : (newList[i].doiNgam > newList[i - 1].doiNgam) ? Math.Round(newList[i].doiNgam - newList[i - 1].doiNgam, 2) : 0.00;
newList[i].rawWater = (newList[i - 1].rawWater == 0.00) ? 0.00 : (newList[i].rawWater > newList[i - 1].rawWater) ? Math.Round(newList[i].rawWater - newList[i - 1].rawWater, 2) : 0.00;
newList[i].high1 = (newList[i - 1].high1 == 0.00) ? 0.00 : (newList[i].high1 > newList[i - 1].high1) ? Math.Round(newList[i].high1 - newList[i - 1].high1, 2) : 0.00;
newList[i].high2 = (newList[i - 1].high2 == 0.00) ? 0.00 : (newList[i].high2 > newList[i - 1].high2) ? Math.Round(newList[i].high2 - newList[i - 1].high2, 2) : 0.00;
newList[i].huaiNamrin = (newList[i - 1].huaiNamrin == 0.00) ? 0.00 : (newList[i].huaiNamrin > newList[i - 1].huaiNamrin) ? Math.Round(newList[i].huaiNamrin - newList[i - 1].huaiNamrin, 2) : 0.00;
newList[i].phaJome = (newList[i - 1].phaJome == 0.00) ? 0.00 : (newList[i].phaJome > newList[i - 1].phaJome) ? Math.Round(newList[i].phaJome - newList[i - 1].phaJome, 2) : 0.00;
newList[i].phom = (newList[i - 1].phom == 0.00) ? 0.00 : (newList[i].phom > newList[i - 1].phom) ? Math.Round(newList[i].phom - newList[i - 1].phom, 2) : 0.00;
newList[i].soonChar = (newList[i - 1].soonChar == 0.00) ? 0.00 : (newList[i].soonChar > newList[i - 1].soonChar) ? Math.Round(newList[i].soonChar - newList[i - 1].soonChar, 2) : 0.00;
}
sumEnergy.timeStamp = "Total";
sumEnergy.doiNgam = Math.Round(sumEnergy.doiNgam + newList[i].doiNgam, 2);
sumEnergy.rawWater = Math.Round(sumEnergy.rawWater + newList[i].rawWater, 2);
sumEnergy.high1 = Math.Round(sumEnergy.high1 + newList[i].high1, 2);
sumEnergy.high2 = Math.Round(sumEnergy.high2 + newList[i].high2, 2);
sumEnergy.huaiNamrin = Math.Round(sumEnergy.huaiNamrin + newList[i].huaiNamrin, 2);
sumEnergy.phaJome = Math.Round(sumEnergy.phaJome + newList[i].phaJome, 2);
sumEnergy.phom = Math.Round(sumEnergy.phom + newList[i].phom, 2);
sumEnergy.soonChar = Math.Round(sumEnergy.soonChar + newList[i].soonChar, 2);
}
newList.Add(sumEnergy);
return newList;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
return null;
}
}