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