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); }