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);
        }
Esempio n. 2
0
 partial void UpdateAutoLuminosity_Light(AutoLuminosity_Light instance);
Esempio n. 3
0
 partial void DeleteAutoLuminosity_Light(AutoLuminosity_Light instance);
Esempio n. 4
0
 partial void InsertAutoLuminosity_Light(AutoLuminosity_Light instance);