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); }
partial void DeleteAutoLuminosity_RoomLightLink(AutoLuminosity_RoomLightLink instance);
partial void InsertAutoLuminosity_RoomLightLink(AutoLuminosity_RoomLightLink instance);