public List <Measure> Get(MeasureSearchCriteria criteria)
{
var endDate = criteria.EndDate.AddDays(1);
using (var context = new PowerUnitContext())
{
// składnia za pomocą wyrażeń lambda
var measures = context.Measures
.Where(x => x.MeasureDate >= criteria.StartDate)
.Where(measure => measure.MeasureDate < endDate)
.OrderBy(measure => measure.MeasureDate)
.ToList();
// składnia podobna do SQL
//var measures = (
// from measure in context.Measures
// where measure.MeasureDate >= criteria.StartDate
// && measure.MeasureDate < endDate
// orderby measure.MeasureDate
// select measure
// )
// .ToList();
return(measures);
}
}
public PowerSupplierViewModel()
{
MeasureSearchCriteria = new MeasureSearchCriteria();
VoltageService = new N30HVoltageService();
CurrentService = new N30UCurrentService();
VoltageOutputService = new SupplierService();
CurrentOutputService = new SupplierService();
OutputService = new SupplierService();
SupplierVoltageInputService = new SupplierService();
SupplierCurrentInputService = new SupplierService();
ThreePhaseInputService = new N10Service();
// MeasuresService = new FileMeasuresService("measures.csv");
MeasuresService = new DbMeasuresService();
ThreePhaseMeasuresService = new DbThreePhaseMeasuresService();
Voltages = new ObservableCollection <float>();
timer = new Timer(1000);
timer.Elapsed += Timer_Elapsed;
timer.Enabled = true;
}
public List <Measure> Get(MeasureSearchCriteria criteria)
{
throw new NotSupportedException();
}
