public static bool UpdateSchedule(Schedule schedule)
{
try
{
using (var dbContext = new AutoLuminosityDataDataContext())
{
// Create a new db Item object to store into the queue
var scheduleDb = dbContext.AutoLuminosity_Schedules.FirstOrDefault(i => i.ScheduleId == schedule.Id);
if (scheduleDb != null)
{
scheduleDb.ScheduleAction = schedule.Action;
scheduleDb.ScheduleEntityId = schedule.EntityId;
scheduleDb.ScheduleExecuteTime = schedule.ExecuteTime;
scheduleDb.ScheduleType = schedule.Type;
}
dbContext.SubmitChanges();
return(true);
}
}
catch (Exception ex)
{
// Log error message
}
return(false);
}
public static Light AddLight(Light light)
{
try
{
using (var dbContext = new AutoLuminosityDataDataContext())
{
var lightDb = dbContext.AutoLuminosity_Lights.FirstOrDefault(i => string.Equals(i.LightExternalId, light.ExternalId));
if (lightDb == null)
{
// Create a new db Item object to store into the queue
lightDb = new AutoLuminosity_Light()
{
LightIsOn = light.IsOn,
UserId = light.UserId,
LightName = light.Name,
LightCreateDate = DateTime.UtcNow,
LightExternalId = light.ExternalId
};
// Insert our newly created Item and Submit the change to the db
dbContext.AutoLuminosity_Lights.InsertOnSubmit(lightDb);
dbContext.SubmitChanges();
}
light.Id = lightDb.LightId;
}
}
catch (Exception ex)
{
// Log error message
}
return(light);
}
public static bool UpdateRoom(Room room)
{
try
{
using (var dbContext = new AutoLuminosityDataDataContext())
{
// Create a new db Item object to store into the queue
var roomDb = dbContext.AutoLuminosity_Rooms.FirstOrDefault(i => i.RoomId == room.Id);
if (roomDb != null)
{
roomDb.RoomName = room.Name;
roomDb.RoomExternalId = room.ExternalId;
}
dbContext.SubmitChanges();
return(true);
}
}
catch (Exception ex)
{
// Log error message
}
return(false);
}
public static bool UpdateLight(Light light)
{
try
{
using (var dbContext = new AutoLuminosityDataDataContext())
{
// Create a new db Item object to store into the queue
var lightDb = dbContext.AutoLuminosity_Lights.FirstOrDefault(i => i.LightId == light.Id);
if (lightDb != null)
{
lightDb.LightName = light.Name;
lightDb.LightIsOn = light.IsOn;
lightDb.LightExternalId = light.ExternalId;
}
dbContext.SubmitChanges();
return(true);
}
}
catch (Exception ex)
{
// Log error message
}
return(false);
}
public static Schedule AddSchedule(Schedule schedule)
{
try
{
using (var dbContext = new AutoLuminosityDataDataContext())
{
// Create a new db Item object to store into the queue
var itemDb = new AutoLuminosity_Schedule
{
ScheduleEntityId = schedule.EntityId,
ScheduleAction = schedule.Action,
ScheduleExecuteTime = schedule.ExecuteTime,
ScheduleType = schedule.Type
};
// Insert our newly created Item and Submit the change to the db
dbContext.AutoLuminosity_Schedules.InsertOnSubmit(itemDb);
dbContext.SubmitChanges();
schedule.Id = itemDb.ScheduleId;
}
}
catch (Exception ex)
{
// Log error message
}
return(schedule);
}
public static Room AddRoom(Room room)
{
try
{
using (var dbContext = new AutoLuminosityDataDataContext())
{
var roomDb = dbContext.AutoLuminosity_Rooms.FirstOrDefault(i => string.Equals(i.RoomExternalId, room.ExternalId));
if (roomDb == null)
{
// Create a new db Item object to store into the queue
roomDb = new AutoLuminosity_Room()
{
RoomName = room.Name,
UserId = room.UserId,
RoomCreateDate = DateTime.UtcNow,
RoomExternalId = room.ExternalId
};
// Insert our newly created Item and Submit the change to the db
dbContext.AutoLuminosity_Rooms.InsertOnSubmit(roomDb);
dbContext.SubmitChanges();
}
room.Id = roomDb.RoomId;
}
}
catch (Exception ex)
{
// Log error message
}
return(room);
}
public static bool RemoveSchedule(int scheduleId)
{
try
{
using (var dbContext = new AutoLuminosityDataDataContext())
{
var schedule = dbContext.AutoLuminosity_Schedules.Where(i => i.ScheduleId == scheduleId);
if (schedule.Any())
{
dbContext.AutoLuminosity_Schedules.DeleteAllOnSubmit(schedule);
dbContext.SubmitChanges();
}
}
return(true);
}
catch (Exception ex)
{
}
return(false);
}
public static bool RemoveRoom(int roomId)
{
try
{
using (var dbContext = new AutoLuminosityDataDataContext())
{
var rooms = dbContext.AutoLuminosity_Rooms.Where(i => i.RoomId == roomId);
if (rooms.Any())
{
dbContext.AutoLuminosity_Rooms.DeleteAllOnSubmit(rooms);
dbContext.SubmitChanges();
}
}
return(true);
}
catch (Exception ex)
{
}
return(false);
}
public static bool RemoveLight(int lightId)
{
try
{
using (var dbContext = new AutoLuminosityDataDataContext())
{
var lights = dbContext.AutoLuminosity_Lights.Where(i => i.LightId == lightId);
if (lights.Any())
{
dbContext.AutoLuminosity_Lights.DeleteAllOnSubmit(lights);
dbContext.SubmitChanges();
}
}
return(true);
}
catch (Exception ex)
{
}
return(false);
}
public static void ToggleRoom(int roomId)
{
try
{
using (var dbContext = new AutoLuminosityDataDataContext())
{
string lightAction = "on";
bool turnLightsOn = true;
var roomLightLinks = dbContext.AutoLuminosity_RoomLightLinks.Where(i => i.RoomId == roomId);
roomLightLinks.ToList().ForEach(l =>
{
var light = dbContext.AutoLuminosity_Lights.FirstOrDefault(i => l.LightId == i.LightId);
if (light.LightIsOn)
{
turnLightsOn = false;
lightAction = "off";
}
});
roomLightLinks.ToList().ForEach(l =>
{
var light = dbContext.AutoLuminosity_Lights.FirstOrDefault(i => l.LightId == i.LightId);
light.LightIsOn = turnLightsOn;
});
dbContext.SubmitChanges();
string jsonRequest = "{ \"power\": \"" + lightAction + "\" }";
var room = dbContext.AutoLuminosity_Rooms.FirstOrDefault(i => i.RoomId == roomId);
if (room != null)
{
LifxConnector.ToggleRoom(room.RoomExternalId, jsonRequest);
}
}
}
catch (Exception ex)
{
}
}
public static bool AddLightToRoom(int roomId, int lightId)
{
try
{
using (var dbContext = new AutoLuminosityDataDataContext())
{
var roomDb = dbContext.AutoLuminosity_Rooms.FirstOrDefault(i => i.RoomId == roomId);
var lightDb = dbContext.AutoLuminosity_Lights.FirstOrDefault(i => i.LightId == lightId);
if (roomDb == null || lightDb == null)
{
return(false);
}
var rommLightLinkDb = dbContext.AutoLuminosity_RoomLightLinks.FirstOrDefault(i => i.RoomId == roomId && i.LightId == lightId);
if (rommLightLinkDb == null)
{
// Create a new db Item object to store into the queue
rommLightLinkDb = new AutoLuminosity_RoomLightLink()
{
RoomId = roomId,
LightId = lightId
};
// Insert our newly created Item and Submit the change to the db
dbContext.AutoLuminosity_RoomLightLinks.InsertOnSubmit(rommLightLinkDb);
dbContext.SubmitChanges();
}
return(rommLightLinkDb.RoomLightLinkId > 0);
}
}
catch (Exception ex)
{
// Log error message
}
return(false);
}
public static bool RegisterUser(User user)
{
try
{
using (var dbContext = new AutoLuminosityDataDataContext())
{
var userDb = new AutoLuminosity_User()
{
UserEmail = user.Email,
UserPassword = HashPasswordForStoringInConfigFile(user.Password, "MD5"),
UserCreateDate = DateTime.UtcNow
};
dbContext.AutoLuminosity_Users.InsertOnSubmit(userDb);
dbContext.SubmitChanges();
return(true);
}
}
catch (Exception ex)
{
// Log error message
}
return(false);
}
