// Creates a Note and inserts it into the collection in MongoDB. public void CreateNote(Note note) { MongoCollection<Note> collection = GetNotesCollectionForEdit(); try { collection.Insert(note); } catch (MongoCommandException ex) { // ReSharper disable once UnusedVariable string msg = ex.Message; } }
public List<Note> GetNotes() { //var stopwatch = new Stopwatch(); //stopwatch.Start(); List<Note> lista = new List<Note>(); using (SqlConnection conn = new SqlConnection(DatosConexion)) { string sql = @"SELECT * FROM Note"; SqlCommand command = new SqlCommand(sql, conn); conn.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { Note nota; foreach (var valor in reader) { nota = new Note { Id = Guid.Parse(reader["Id"].ToString()), Text = Convert.ToString(reader["Note"]), Date = Convert.ToDateTime(reader["Date"]) }; lista.Add(nota); } } //stopwatch.Stop(); //Console.WriteLine("Tiempo Transcurrido" + stopwatch.ElapsedMilliseconds); return lista; } }
public void CreateSQlNote(Note note) { //var stopwatch = new Stopwatch(); //stopwatch.Start(); using (SqlConnection con = new SqlConnection(DatosConexion)) { //Paso 2 - Abrir la conexión con.Open(); // Paso 3 - Crear un nuevo comando const string textoCmd = "Insert into Note (Note, Date) values(@note, @datetime);"; try { SqlCommand cmd = new SqlCommand(textoCmd, con); //cmd.Parameters.AddWithValue("@id", note.Id); cmd.Parameters.AddWithValue("@note", note.Text); cmd.Parameters.AddWithValue("datetime", note.Date); //Paso 4 - Ejecutar el comando cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { throw new Exception(e.Message); } } //stopwatch.Stop(); //Console.WriteLine("Tiempo Transcurrido" + stopwatch.ElapsedMilliseconds); }