public METER Save(METER meter)
{
if (meter.ID == 0)
{
context.METERs.Add(meter);
}
else
{
context.Entry(meter).State = EntityState.Modified;
}
context.SaveChanges();
return(meter);
}
private string CheckVerificationNoteForMeter(METER meter, MeterType meterType)
{
var age = Bill.Date.Year - meter.VARIFICATION_DATE.Year;
if (meter.VARIFICATION_DATE > Bill.Date.AddYears(-age))
{
age--;
}
return((age >= meterType.VarificationPeriod) ?
String.Format(Localization.MeterVerificationNote,
meterType.VarificationPeriod, meter.VARIFICATION_DATE.ToString("dd MM yyyy")) :
String.Empty);
}
private static void GetTemperatureHistory(TownUtilityBillSystemEntities context, BillModel model, METER m)
{
List <Temperature> temperaturesDB = new List <Temperature>();
DateTime temperatureStartDate = new DateTime();
DateTime temperatureFinishDate = new DateTime();
int temperatureYearsHistory = 2;
float valueSum = 0;
float averageValue;
string fullMonthName = "";
temperatureStartDate = Convert.ToDateTime(model.Bill.Period + "-01");
temperatureStartDate = temperatureStartDate.AddYears(-1);
temperatureFinishDate = temperatureStartDate.AddMonths(1);
var temperatureItemsDB = context.TEMPERATURE.Where(t => t.TOWN_ID == m.ADDRESS.TOWN_ID).ToList();
foreach (var d in temperatureItemsDB)
{
temperaturesDB.Add(new Temperature()
{
Id = d.ID, Date = d.DATE, MinValue = d.MINVALUE, MaxValue = d.MAXVALUE
});
}
for (int j = 0; j < temperatureYearsHistory; j++)
{
for (; temperatureStartDate < temperatureFinishDate; temperatureStartDate = temperatureStartDate.AddDays(1))
{
valueSum += (float)(temperaturesDB.Where(t => t.Date == temperatureStartDate).FirstOrDefault().MinValue + temperaturesDB.Where(t => t.Date == temperatureStartDate).FirstOrDefault().MaxValue) / 2;
}
temperatureStartDate = temperatureStartDate.AddMonths(-1);
fullMonthName = temperatureStartDate.ToString("MMMM yyyy");
averageValue = valueSum / System.DateTime.DaysInMonth(temperatureStartDate.Year, temperatureStartDate.Month);
model.Temperatures.Add(new TemperatureModel()
{
AverageValue = (float)Math.Round(averageValue, 1), MonthName = fullMonthName
});
temperatureStartDate = temperatureStartDate.AddYears(1);
temperatureFinishDate = temperatureStartDate.AddMonths(1);
valueSum = 0;
}
}
public void Delete(METER meter)
{
context.METERs.Remove(meter);
context.SaveChanges();
}
private static float GetConsumedMonthValue(DateTime startDate, DateTime finishDate, METER meter)
{
using (var context = new TownUtilityBillSystemV2Entities())
{
float consumedMonthValue;
var startMeterItem = (from item in context.METER_ITEMs
where item.METER_ID == meter.ID && item.DATE == startDate
select item).FirstOrDefault();
var finishMeterItem = (from item in context.METER_ITEMs
where item.METER_ID == meter.ID && item.DATE == finishDate
select item).FirstOrDefault();
consumedMonthValue = finishMeterItem.VALUE - startMeterItem.VALUE;
return(consumedMonthValue);
}
}
