Beispiel #1
0
        string ResolveNameByNumber(string number)
        {
            IDbCommand  cmd;
            IDataReader reader;

            try
            {
                cmd             = DatabaseService.TryCreateCommand();
                cmd.CommandText = String.Format("SELECT name FROM persons WHERE number='{0}'", number);
                reader          = cmd.ExecuteReader();
            }
            catch (Exception ex)
            {
                Log.AddException("SMS", ex);
                return(number);
            }


            Log.Add(LogLevel.Verbose, "SMS", cmd.CommandText);
            string ret;

            if (reader.Read())
            {
                ret = (string)reader["name"];
            }
            else
            {
                Log.Add(LogLevel.Warning, "SMS", String.Format("Number {0} not found in db.", number));
                ret = number;
            }

            reader.Close();
            return(ret);
        }
Beispiel #2
0
 public override void Start()
 {
     try
     {
         Log.Add(LogLevel.Info, "SMS", "Opening device to port.");
         _gsm.Open();
         StartReceiving();
     }
     catch (Exception ex)
     {
         Log.AddException("SMS", ex);
     }
 }