public async Task <List <RecordObject> > getRecordsAfterAsync(long time) { List <RecordObject> records = new List <RecordObject>(); //try //{ // using (SqlConnection conn = new SqlConnection(sqlCon)) // { // if (conn.State == ConnectionState.Closed) // { // conn.Open(); // using (SqlCommand command = new SqlCommand("SELECT time,operation,keyStroke,window FROM Records WHERE time > @t Order By time", conn)) // { // // // // Add new SqlParameter to the command. // // // command.Parameters.Add(new SqlParameter("t", time)); // SqlDataReader reader; // // SqlCommand command = // // new SqlCommand("SELECT time,operation,keyStroke,window " + // // "FROM Records WHERE time>'" + // // time + // // "' Order By time;", conn); // reader = command.ExecuteReader(); // if (reader.HasRows) // { // while (reader.Read()) // { // records.Add(new RecordObject(reader.GetInt64(0), // reader.GetString(1), reader.GetString(2), reader.GetString(3))); // } // } // else // { // Console.WriteLine("No rows found."); // } // } // } // } //} //catch(Exception e) //{ // Console.WriteLine(e.ToString()); //} records = await MongoDBUtils.RetriveRecordsAfter(time); return(records); }
public static void injectRecord(RecordObject rec) { try { BsonDocument doc = new BsonDocument { { "Time", rec.Time }, { "Operation", rec.Operation }, { "Key", rec.KeyWord }, { "Window", rec.Window } }; MongoDBUtils.RecordsCollection.InsertOne(doc); } catch { MongoDBUtils.Connect(); } }
public void insertRecord(RecordObject record) { //using (SqlConnection conn = new SqlConnection(sqlCon)) //{ // if (conn.State == ConnectionState.Closed) // { // conn.Open(); // SqlCommand command = // new SqlCommand("INSERT INTO Records " + // "VALUES(" + // record.Time + ", " + // record.Operation + ", " + // record.KeyWord + ", " + // record.Window + ");", // conn); // command.ExecuteReader(); // } //} MongoDBUtils.injectRecord(record); }
public DBManager() { MongoDBUtils.Connect(); // AppDomain.CurrentDomain.SetData("DataDirectory", Directory.GetCurrentDirectory()); // sqlCon = // "Data Source=(LocalDB)\\MSSQLLocalDB;Integrated Security=True"; // @"Data Source=.\SQLEXPRESS;" + // @"AttachDbFilename=|DataDirectory|\EyeDenticaDB.mdf; // Integrated Security=True; // Connect Timeout=30; // User Instance=True"; // conn = new SqlConnection(sqlCon); // conn.ConnectionString = // "Server =.\\SQLExpress; AttachDbFilename =|DataDirectory|EyeDenticaDB.mdf; Database = EyeDenticaDB; Trusted_Connection = Yes;"; // @"Data Source = (localdb)\v12.0;" + // "User Instance=true;" + // "Integrated Security=true;" + // @"AttachDbFilename = C:\mf\projectTfs\EyeDentica\EyeDenticaService\EyeDenticaService\DB\EyeDenticaDB.mdf;"; }
static MongoDBUtils() { BsonDefaults.GuidRepresentation = GuidRepresentation.Standard; MongoDBUtils.Connect(); }