public IEnumerable <Schedule> GetAll()
{
using (var context = new HomeAutomationContext())
{
return(context.Schedules.ToList());
}
}
public Schedule Add(bool mon, bool tue, bool wed, bool thu, bool fri, bool sat, bool sun, int deviceID, DateTime time, short temperture, short fan, Mode mode)
{
int id = 0;
using (var context = new HomeAutomationContext())
{
if (context.Schedules.Count() > 0)
{
id = context.Schedules.Max(o => o.ID) + 1;
}
var schedule = new Schedule()
{
ID = id,
Mon = mon,
Tue = tue,
Wed = wed,
Thu = thu,
Fri = fri,
Sun = sun,
Sat = sat,
DeviceID = deviceID,
Time = time,
Mode = mode,
Fan = fan,
Temperature = temperture
};
context.Schedules.Add(schedule);
context.SaveChanges();
return(schedule);
}
}
public IEnumerable <Device> GetAll()
{
using (var context = new HomeAutomationContext())
{
return(context.Devices.ToList());
}
}
public IEnumerable <User> GetAll()
{
using (var context = new HomeAutomationContext())
{
return(context.Users.ToList());
}
}
public Device Get(int ID)
{
using (var context = new HomeAutomationContext())
{
return(context.Devices.Where(o => o.ID == ID).FirstOrDefault());
}
}
public ChartData GetDailyTemperatures(DateTime fromDate, DateTime toDate)
{
using (var ctx = new HomeAutomationContext())
{
var temperatures = ctx.GetDailyTemperatures(fromDate, toDate);
return(GetData(temperatures, "MM-dd"));
}
}
public void Delete(int ID)
{
using (var context = new HomeAutomationContext())
{
context.Remove(context.Devices.Where(o => o.ID == ID).FirstOrDefault());
context.SaveChanges();
}
}
public void Delete(int iD)
{
using (var context = new HomeAutomationContext())
{
var r = context.Schedules.Where(o => o.ID == iD).FirstOrDefault();
context.Schedules.Remove(r);
context.SaveChanges();
}
}
public void UpdateTemperature(int ID, float?temperature)
{
using (var context = new HomeAutomationContext())
{
var item = context.Devices.Where(o => o.ID == ID).FirstOrDefault();
item.Temperature = temperature;
context.SaveChanges();
}
}
public IEnumerable <ViewSchedule> GetAllFormated()
{
using (var context = new HomeAutomationContext())
{
List <ViewSchedule> result = new List <ViewSchedule>();
foreach (var schedule in context.Schedules)
{
result.Add(this.scheduleFactory.Create(schedule));
}
return(result);
}
}
public void Update(Device device)
{
using (var context = new HomeAutomationContext())
{
var item = context.Devices.Where(o => o.ID == device.ID).FirstOrDefault();
item.Appliance = device.Appliance;
item.Name = device.Name;
item.NodeAddress = device.NodeAddress;
context.SaveChanges();
}
}
public Device Add(string nodeAddress, string name, Appliance appliance)
{
using (var context = new HomeAutomationContext())
{
int id = context.Devices.Max(o => o.ID) + 1;
var device = new Device()
{
ID = id, NodeAddress = nodeAddress, Name = name, Appliance = appliance
};
context.Devices.Add(device);
context.SaveChanges();
return(device);
}
}
private ChartData GetData(List <Temperature> temperatures, string format)
{
using (var ctx = new HomeAutomationContext())
{
var q = from r in ctx.Devices
select new Dataset()
{
Label = r.Name,
Data = (from t in temperatures where t.DeviceID == r.ID orderby t.Date select t.Value).ToList()
};
var result = new ChartData()
{
Labels = temperatures.OrderBy(d => d.Date).Select(d => d.Date.ToString(format)).Distinct().ToList(),
Datasets = q.ToList()
};
return(result);
}
}