int AddTempRecord(JObject input) { TempRecord tempRecord = new TempRecord(); var tempHexBytes = input.SelectToken("payload_hex").ToString().Substring(12); tempRecord.temperature = Convert.ToInt32(tempHexBytes, 16) / 10; tempRecord.location = "Källbergsgatan 3"; DateTime date = DateTime.UtcNow; date = date.AddHours(2); tempRecord.time = date.ToString("dd/MM/yyyy HH:mm:ss"); SqlConnection sqlConnection = new SqlConnection("Data Source=smartlakes.cnhjmr9oh4re.us-east-2.rds.amazonaws.com;Initial Catalog=SmartLakes;Integrated Security=False;User ID=SmartLakesNFK;Password=NFKsmartlakes;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); string query = "INSERT INTO TempRecords VALUES(@temperature, @location, @time)"; using (SqlCommand command = new SqlCommand(query, sqlConnection)) { command.Parameters.Add("@temperature", SqlDbType.Float).Value = tempRecord.temperature; command.Parameters.Add("@location", SqlDbType.VarChar).Value = tempRecord.location; command.Parameters.Add("@time", SqlDbType.VarChar).Value = tempRecord.time; command.Connection.Open(); int rowsAffected = command.ExecuteNonQuery(); command.Connection.Close(); return(rowsAffected); } }
static void Main() { var tempRecord = new TempRecord(); tempRecord[3] = 58.3F; for (int i = 0; i < tempRecord.Length; i++) { Console.WriteLine($"Element #{i} = {tempRecord[i]}"); } }
static void Main(string[] args) { TempRecord tempRecord = new TempRecord(); float temp1 = tempRecord[5]; //Simplified syntax + purpose more intuitive. float temp2 = tempRecord.temps[1]; //Weird to read, as we already know tempRecord has temperatures. Console.WriteLine(temp1); Console.WriteLine(temp2); Console.ReadLine(); }
public void ShouldDumpObjectWithIndexer_IntegerArray_IgnoredByDefaultDumpOptions() { // Arrange var tempRecord = new TempRecord { [0] = 58.3f, [1] = 60.1f, }; // Act var dump = ObjectDumperCSharp.Dump(tempRecord); // Assert this.testOutputHelper.WriteLine(dump); dump.Should().NotBeNull(); dump.Should().Be("var tempRecord = new TempRecord\r\n{\r\n AProp = 0,\r\n ZProp = null\r\n};"); }
static void Main() { TempRecord tempRecord = new TempRecord(); // Use the indexer's set accessor tempRecord[3] = 58.3F; tempRecord[5] = 60.1F; // Use the indexer's get accessor for (int i = 0; i < 10; i++) { System.Console.WriteLine("Element #{0} = {1}", i, tempRecord[i]); } // Keep the console window open in debug mode. System.Console.WriteLine("Press any key to exit."); System.Console.ReadKey(); }
static void Main() { var tempRecord = new TempRecord(); // Use the indexer's set accessor tempRecord[3] = 58.3F; tempRecord[5] = 60.1F; // Use the indexer's get accessor for (int i = 0; i < 10; i++) { Console.WriteLine($"Element #{i} = {tempRecord[i]}"); } // Keep the console window open in debug mode. Console.WriteLine("Press any key to exit."); Console.ReadKey(); }
public void ShouldDumpObjectWithIndexer_IntegerArray() { // Arrange var tempRecord = new TempRecord { AProp = 99, [0] = 58.3f, [1] = 60.1f, ZProp = "ZZ" }; var dumpOptions = new DumpOptions { IgnoreIndexers = false }; // Act var dump = ObjectDumperCSharp.Dump(tempRecord, dumpOptions); // Assert this.testOutputHelper.WriteLine(dump); dump.Should().NotBeNull(); dump.Should().Be("var tempRecord = new TempRecord\r\n{\r\n AProp = 99,\r\n [0] = 58.3f,\r\n [1] = 60.1f,\r\n ZProp = \"ZZ\"\r\n};"); }
static void Main(string[] args) { //Коллекция нетипизированная ОЧЕРЕДЬ Queue q1 = new Queue(); q1.Enqueue("1"); q1.Enqueue('2'); q1.Enqueue("Three"); q1.Enqueue(5); Console.WriteLine("First element: " + q1.Peek()); Console.WriteLine("All elements: " + q1.Count); while (q1.Count > 0) { Console.WriteLine(q1.Dequeue()); } /* * foreach (var item in q1) * Console.WriteLine(item); */ //Коллекция СТЕК Stack s1 = new Stack(); s1.Push(6); s1.Push("2"); s1.Push('1'); s1.Push(3); Console.WriteLine("Upper element: " + s1.Peek()); Console.WriteLine("All elements: " + s1.Count); //Извлечение элементов while (s1.Count > 0) { Console.WriteLine(" " + s1.Pop()); } /* * //С первого элемента! * foreach (var item in s1) * Console.WriteLine(s1.Pop()); */ Num n = new Num(2, 5, 9); foreach (var item in n) { Console.WriteLine(item); } Demo d = new Demo(); foreach (int item in d) { Console.WriteLine(item); } TempRecord tr = new TempRecord(); //Установка значений через индексатор //через set устанавливаются значения tr[3] = 15; tr[4] = 17; //Получение значений через индексатор for (int i = 0; i < tr.Length; i++) { Console.WriteLine("Element #{0} equals {1}", i, tr[i]); } //пример индексатора где индексатор принимает строку DemoStringIndex dm = new DemoStringIndex(5, 6); Console.WriteLine("{0} {1}", dm["first"], dm["second"]); DemoArray a = new DemoArray(3, 3); for (int i = 0; i < a.LengthN; i++, Console.WriteLine()) { for (int j = 0; j < a.LengthM; j++) { a[i, j] = i * j; //использование индексаторов Console.WriteLine("{0,5}", a[i, j]); } } Console.WriteLine(); try { //Раскомментировать по очереди чтобы посмотреть на разные ошибки //Console.WriteLine(a[3, 3]); //a[0, 0] = 200; } catch (Exception e) { Console.WriteLine(e.Message); } Cat fluffy = new Cat(); Elephant slon = new Elephant(); Dog goldy = new Dog(); Patients SickPets = new Patients(); SickPets.AdmitPatient(fluffy); SickPets.AdmitPatient(slon); SickPets.AdmitPatient(goldy); foreach (object pet in SickPets) { Console.WriteLine(pet); } Console.ReadKey(); }