예제 #1
0
 private DoorInfo Retrieve(string DoorID)
 {
     var ret = new DoorInfo();
     var cs = ConfigurationManager.ConnectionStrings["DoorSource"].ConnectionString;
     var conn = new SQLiteConnection(cs);
     conn.Open();
     var cmd = new SQLiteCommand(conn);
     cmd.CommandText = "SELECT DoorID, Location, Description, EventID FROM Doors WHERE DoorID = @DoorID LIMIT 1";
     cmd.Parameters.Add(new SQLiteParameter("@DoorID", DoorID));
     SQLiteDataReader res = null;
     try
     {
         res = cmd.ExecuteReader();
         if (res.HasRows && res.Read())
         {
             ret.DoorID = DoorID;
             ret.Location = res.GetString(1);
             ret.Description = res.GetString(2);
             ret.EventID = res.GetInt64(3);
         }
         return ret;
     }
     catch(Exception ex)
     {
         throw;
     }
     finally
     {
         if (null != res && !res.IsClosed)
             res.Close();
     }
 }
예제 #2
0
 private DoorInfo Retrieve(string DoorID)
 {
     if (null == _conn)
         InitConnection();
     var ret = new DoorInfo();
     var cs = ConfigurationManager.ConnectionStrings["DoorSource"].ConnectionString;
     using(var cmd = new SqlCommand("SELECT TOP 1 DoorID, Location, Description, EventID FROM Doors WHERE DoorID = @DoorID")) {
         if(_conn.State != System.Data.ConnectionState.Open)
             _conn.Open();
         cmd.Connection = _conn;
         cmd.Parameters.Add(new SqlParameter("@DoorID", DoorID));
         SqlDataReader res = null;
         try
         {
             res = cmd.ExecuteReader();
             if (res.HasRows && res.Read())
             {
                 ret.DoorID = DoorID;
                 ret.Location = res.GetString(1);
                 ret.Description = res.GetString(2);
                 ret.EventID = res.GetInt64(3);
             }
             return ret;
         }
         catch (Exception ex)
         {
             throw;
         }
         finally
         {
             if (null != res && !res.IsClosed)
                 res.Close();
         }
     }
 }