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); }
partial void UpdateAutoLuminosity_Light(AutoLuminosity_Light instance);
partial void DeleteAutoLuminosity_Light(AutoLuminosity_Light instance);
partial void InsertAutoLuminosity_Light(AutoLuminosity_Light instance);