public static Schedule GetSchedule(int scheduleId) { try { var schedule = new Schedule(); using (var dbContext = new AutoLuminosityDataDataContext()) { var scheduleDb = dbContext.AutoLuminosity_Schedules.FirstOrDefault(i => i.ScheduleId == scheduleId); if (scheduleDb != null) { schedule = new Schedule { Action = scheduleDb.ScheduleAction, EntityId = scheduleDb.ScheduleEntityId, Id = scheduleDb.ScheduleId, Type = scheduleDb.ScheduleType, ExecuteTime = scheduleDb.ScheduleExecuteTime }; } } return(schedule); } catch (Exception ex) { // Log error message } return(null); }
public static void ToggleRoom(int roomId, int action) { try { using (var dbContext = new AutoLuminosityDataDataContext()) { string lightAction = string.Empty; if (action == 1) { lightAction = "on"; } else if (action == 2) { lightAction = "off"; } 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 Room GetRoom(int roomId) { try { var room = new Room(); using (var dbContext = new AutoLuminosityDataDataContext()) { var roomDb = dbContext.AutoLuminosity_Rooms.FirstOrDefault(i => i.RoomId == roomId); if (roomDb != null) { room = new Room { UserId = roomDb.UserId, Name = roomDb.RoomName, Id = roomDb.RoomId, CreateDate = roomDb.RoomCreateDate.ToString(), ExternalId = roomDb.RoomExternalId }; } } return(room); } catch (Exception ex) { // Log error message } return(null); }
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 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 GetLight(int lightId) { try { var light = new Light(); using (var dbContext = new AutoLuminosityDataDataContext()) { var lightDb = dbContext.AutoLuminosity_Lights.FirstOrDefault(i => i.LightId == lightId); if (lightDb != null) { light = new Light() { UserId = lightDb.UserId, Name = lightDb.LightName, Id = lightDb.LightId, CreateDate = lightDb.LightCreateDate.ToString(), IsOn = lightDb.LightIsOn, ExternalId = lightDb.LightExternalId }; } } return(light); } catch (Exception ex) { // Log error message } return(null); }
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 List <Room> GetRooms(int userId) { try { var rooms = new List <Room>(); using (var dbContext = new AutoLuminosityDataDataContext()) { dbContext.AutoLuminosity_Rooms.Where(i => i.UserId == userId).ToList().ForEach(roomDb => { if (roomDb != null) { rooms.Add(new Room() { UserId = roomDb.UserId, Name = roomDb.RoomName, Id = roomDb.RoomId, CreateDate = roomDb.RoomCreateDate.ToString(), ExternalId = roomDb.RoomExternalId }); } }); } return(rooms); } catch (Exception ex) { // Log error message } return(null); }
public static List <Light> GetLights(int userId) { try { var lights = new List <Light>(); using (var dbContext = new AutoLuminosityDataDataContext()) { dbContext.AutoLuminosity_Lights.Where(i => i.UserId == userId).ToList().ForEach(lightDb => { if (lightDb != null) { lights.Add(new Light() { UserId = lightDb.UserId, Name = lightDb.LightName, Id = lightDb.LightId, CreateDate = lightDb.LightCreateDate.ToString(), IsOn = lightDb.LightIsOn, ExternalId = lightDb.LightExternalId }); } }); } return(lights); } catch (Exception ex) { // Log error message } return(null); }
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 List <Schedule> GetSchedulesForLight(int lightId) { try { var schedules = new List <Schedule>(); using (var dbContext = new AutoLuminosityDataDataContext()) { dbContext.AutoLuminosity_Schedules.Where(i => i.ScheduleEntityId == lightId && i.ScheduleType == ScheduleType.Light).ToList().ForEach(schedule => { if (schedule != null) { schedules.Add(new Schedule { Id = schedule.ScheduleId, Action = schedule.ScheduleAction, EntityId = schedule.ScheduleEntityId, ExecuteTime = schedule.ScheduleExecuteTime, Type = schedule.ScheduleType }); } }); } return(schedules); } catch (Exception ex) { // Log error message } return(null); }
public static bool IsEmailRegistered(string email) { bool result = false; try { using (var dbContext = new AutoLuminosityDataDataContext()) { result = dbContext.AutoLuminosity_Users.ToList().FirstOrDefault(g => string.Equals(g.UserEmail.ToLower(), email.ToLower())) != null; } } catch (Exception ex) { // Log error message //Email.ErrorLogEmail($"IsEmailRegistered {ex.Message} - {ex.StackTrace}"); } return(result); }
public static User LoginUser(User user) { using (var dbContext = new AutoLuminosityDataDataContext()) { var hashedPassword = HashPasswordForStoringInConfigFile(user.Password, "MD5"); var userDb = dbContext.AutoLuminosity_Users.ToList() .FirstOrDefault( g => string.Equals(g.UserEmail.ToLower(), user.Email.ToLower()) && string.Equals(g.UserPassword, hashedPassword)); if (userDb != null) { user.Id = userDb.UserId; user.CreateDate = userDb.UserCreateDate.ToString(); } } return(user); }
public static void ExecuteSchedule(int scheduleId) { try { using (var dbContext = new AutoLuminosityDataDataContext()) { var schedule = dbContext.AutoLuminosity_Schedules.FirstOrDefault(i => i.ScheduleId == scheduleId); if (schedule != null) { string action = string.Empty; if (schedule.ScheduleAction == 1) { action = "on"; } else if (schedule.ScheduleAction == 2) { action = "off"; } string jsonRequest = "{ \"power\": \"" + action + "\" }"; if (schedule.ScheduleType == ScheduleType.Light) { var light = dbContext.AutoLuminosity_Lights.FirstOrDefault(i => i.LightId == schedule.ScheduleEntityId); if (light != null) { LifxConnector.ToggleLight(light.LightExternalId, jsonRequest); } } else if (schedule.ScheduleType == ScheduleType.Room) { var room = dbContext.AutoLuminosity_Rooms.FirstOrDefault(i => i.RoomId == schedule.ScheduleEntityId); if (room != null) { LifxConnector.ToggleRoom(room.RoomExternalId, jsonRequest); } } } } } catch (Exception ex) { } }
public static List <Schedule> GetSchedulesForUser(int userId) { try { var schedules = new List <Schedule>(); using (var dbContext = new AutoLuminosityDataDataContext()) { dbContext.AutoLuminosity_Schedules.Where(i => i.UserId == userId).ToList().ForEach(schedule => { if (schedule != null) { var entityName = string.Empty; if (schedule.ScheduleType == ScheduleType.Light) { var light = dbContext.AutoLuminosity_Lights.FirstOrDefault(l => l.LightId == schedule.ScheduleEntityId); entityName = light.LightName; } else { var room = dbContext.AutoLuminosity_Rooms.FirstOrDefault(l => l.RoomId == schedule.ScheduleEntityId); entityName = room.RoomName; } schedules.Add(new Schedule { Id = schedule.ScheduleId, Action = schedule.ScheduleAction, EntityId = schedule.ScheduleEntityId, ExecuteTime = schedule.ScheduleExecuteTime, Type = schedule.ScheduleType, EntityName = entityName }); } }); } return(schedules); } catch (Exception ex) { // Log error message } return(null); }
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 List <Light> GetLightsForRoom(int roomId) { try { var lights = new List <Light>(); using (var dbContext = new AutoLuminosityDataDataContext()) { dbContext.AutoLuminosity_RoomLightLinks.Where(i => i.RoomId == roomId).ToList().ForEach(roomLightLink => { if (roomLightLink == null) { return; } var lightDb = dbContext.AutoLuminosity_Lights.FirstOrDefault(light => light.LightId == roomLightLink.LightId); if (lightDb != null) { lights.Add(new Light() { UserId = lightDb.UserId, Name = lightDb.LightName, Id = lightDb.LightId, CreateDate = lightDb.LightCreateDate.ToString(), IsOn = lightDb.LightIsOn, ExternalId = lightDb.LightExternalId }); } }); } return(lights); } catch (Exception ex) { // Log error message } return(null); }
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); }