Exemplo n.º 1
0
        /// <summary>
        /// Inserts an e-mail into the database. In case sending the e-mail didn't work, it is still registered in the db
        /// </summary>
        /// <param name="uniqueString">The user's unique string</param>
        /// <param name="emailMessage">The e-mail message</param>
        /// <param name="emailSubject">The e-mail subject</param>
        /// <param name="eMailAddress">The users e-mail address. This is optional</param>
        public static void InsertEmailAttempt(string uniqueString, string emailMessage, string emailSubject, string eMailAddress = "")
        {
            using (remindmesqldbEntities db = new remindmesqldbEntities())
            {
                int attemptCount = 0;
                while (!terminateDatabaseAccess && !CanConnect(db))
                {
                    Thread.Sleep(500);
                    if (attemptCount > MAX_ATTEMPTS)
                    {
                        break;
                    }
                }

                EmailAttempts ea = new EmailAttempts();
                ea.Username = Environment.UserName;
                ea.UserId   = uniqueString;
                ea.Message  = emailMessage;
                ea.Subject  = emailSubject;

                if (!string.IsNullOrWhiteSpace(eMailAddress))
                {
                    ea.E_mail = eMailAddress;
                }

                db.EmailAttempts.Add(ea);
                db.SaveChanges();
            }
        }
Exemplo n.º 2
0
        public static void TransformUniqueString(string uniqueStringOld, string uniqueStringNew, string remindMeVersion)
        {
            using (remindmesqldbEntities db = new remindmesqldbEntities())
            {
                int attemptCount = 0;
                while (!terminateDatabaseAccess && !CanConnect(db))
                {
                    Thread.Sleep(500);
                    if (attemptCount > MAX_ATTEMPTS)
                    {
                        break;
                    }
                }

                Users usr;
                //If the user doesn't exist in the db yet...
                if (db.Users.Where(u => u.UniqueString == uniqueStringOld).Count() > 0)
                {
                    //Update the LastOnline attribute
                    usr = db.Users.Where(u => u.UniqueString == uniqueStringOld).SingleOrDefault();
                    usr.UniqueString = uniqueStringNew;
                    usr.LastOnline   = DateTime.UtcNow;
                    usr.SignIns++;
                    usr.RemindMeVersion = remindMeVersion;
                    db.SaveChanges();
                }
            }
        }
Exemplo n.º 3
0
        /// <summary>
        /// Inserts a user into the database to keep track of how many users RemindMe has (after version 2.6.02)
        /// </summary>
        /// <param name="uniqueString"></param>
        public static void InsertOrUpdateUser(string uniqueString, string remindMeVersion)
        {
            using (remindmesqldbEntities db = new remindmesqldbEntities())
            {
                int attemptCount = 0;
                while (!terminateDatabaseAccess && !CanConnect(db))
                {
                    Thread.Sleep(500);
                    if (attemptCount > MAX_ATTEMPTS)
                    {
                        break;
                    }
                }

                Users usr;
                //If the user doesn't exist in the db yet...
                if (db.Users.Where(u => u.UniqueString == uniqueString).Count() == 0)
                {
                    usr                   = new Users();
                    usr.Username          = Environment.UserName;
                    usr.UniqueString      = uniqueString;
                    usr.LastOnline        = DateTime.UtcNow;
                    usr.RemindMeVersion   = remindMeVersion;
                    usr.Material          = 1;
                    usr.AutoUpdate        = 1;
                    usr.ActiveReminders   = 0;
                    usr.DisabledReminders = 0;
                    usr.DeletedReminders  = 0;
                    usr.ArchivedReminders = 0;
                    usr.TotalReminders    = 0;

                    db.Users.Add(usr);
                }
                else
                {
                    //Update the LastOnline attribute
                    usr = db.Users.Where(u => u.UniqueString == uniqueString).SingleOrDefault();
                    usr.UniqueString = uniqueString;
                    usr.LastOnline   = DateTime.UtcNow;
                    usr.SignIns++;
                    usr.RemindMeVersion = remindMeVersion;
                    usr.Material        = (int)DLLocalDatabase.Setting.Settings.MaterialDesign.Value;
                    usr.AutoUpdate      = (int)DLLocalDatabase.Setting.Settings.AutoUpdate;
                }

                usr.ActiveReminders   = DLReminders.GetReminders().Where(r => r.Enabled == 1).Count();
                usr.DisabledReminders = DLReminders.GetReminders().Where(r => r.Enabled == 0).Count();
                usr.DeletedReminders  = DLReminders.GetDeletedReminders().Count;
                usr.ArchivedReminders = DLReminders.GetArchivedReminders().Count;
                usr.TotalReminders    = DLReminders.GetAllReminders().Count;

                db.SaveChanges();
            }
        }
Exemplo n.º 4
0
        public static void InsertTheme(Database.Entity.Themes theme)
        {
            try
            {
                using (remindmesqldbEntities db = new remindmesqldbEntities())
                {
                    int attemptCount = 0;
                    while (!terminateDatabaseAccess && !CanConnect(db))
                    {
                        Thread.Sleep(500);
                        if (attemptCount > MAX_ATTEMPTS)
                        {
                            break;
                        }
                    }


                    UserThemes usrTheme = new UserThemes();
                    usrTheme.NormalPrimary = theme.Primary;
                    usrTheme.DarkPrimary   = theme.DarkPrimary;
                    usrTheme.LightPrimary  = theme.LightPrimary;
                    usrTheme.Accent        = theme.Accent;
                    usrTheme.TextShade     = theme.TextShade;
                    usrTheme.Mode          = theme.Mode.Value;
                    usrTheme.ThemeName     = theme.ThemeName;

                    db.UserThemes.Add(usrTheme);
                    db.SaveChanges();
                }
            }
            catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
            {
                Exception raise = dbEx;
                foreach (var validationErrors in dbEx.EntityValidationErrors)
                {
                    foreach (var validationError in validationErrors.ValidationErrors)
                    {
                        string message = string.Format("{0}:{1}",
                                                       validationErrors.Entry.Entity.ToString(),
                                                       validationError.ErrorMessage);
                        // raise a new exception nesting
                        // the current instance as InnerException
                        raise = new InvalidOperationException(message, raise);
                    }
                }
                throw raise;
            }
        }
Exemplo n.º 5
0
 /// <summary>
 /// Adds another count to the amount of times a message is read
 /// </summary>
 /// <param name="id"></param>
 public static void UpdateRemindMeMessageCount(int id)
 {
     using (remindmesqldbEntities db = new remindmesqldbEntities())
     {
         int attemptCount = 0;
         while (!terminateDatabaseAccess && !CanConnect(db))
         {
             Thread.Sleep(500);
             if (attemptCount > MAX_ATTEMPTS)
             {
                 break;
             }
         }
         RemindMeMessages mess = db.RemindMeMessages.Where(m => m.Id == id).FirstOrDefault();
         mess.ReadByAmountOfUsers++;
         db.SaveChanges();
     }
 }
Exemplo n.º 6
0
        public static bool IsUniqueString(string uniqueString)
        {
            using (remindmesqldbEntities db = new remindmesqldbEntities())
            {
                int attemptCount = 0;
                while (!terminateDatabaseAccess && !CanConnect(db))
                {
                    Thread.Sleep(500);
                    if (attemptCount > MAX_ATTEMPTS)
                    {
                        break;
                    }
                }


                return(db.Users.Where(u => u.UniqueString == uniqueString).SingleOrDefault() == null);
            }
        }
Exemplo n.º 7
0
        /// <summary>
        /// Logs an exception to the online database
        /// </summary>
        /// <param name="ex">The exception that is going to be logged</param>
        /// <param name="exceptionDate">The date the exception is logged at</param>
        public static void AddException(Exception ex, DateTime exceptionDate, string pathToSystemLog, string customMessage)
        {
            if (exceptionInserts >= MAX_EXCEPTION_INSERTS)
            {
                return;
            }

            int attemptCount = 0;

            using (remindmesqldbEntities db = new remindmesqldbEntities())
            {
                while (!terminateDatabaseAccess && !terminateDatabaseAccess && !CanConnect(db))
                {
                    Thread.Sleep(500);
                    if (attemptCount > MAX_ATTEMPTS)
                    {
                        break;
                    }
                }


                ExceptionLog log = new ExceptionLog();
                log.ExceptionDate = exceptionDate;

                log.ExceptionMessage = ex.Message;
                log.CustomMessage    = customMessage;


                if (pathToSystemLog != null && File.Exists(pathToSystemLog))
                {
                    log.SystemLog = File.ReadAllText(pathToSystemLog).Replace(Environment.NewLine, "¤");//so we can do a find and replace ¤ to \r\n in notepad++ to make it more readable
                }
                log.ExceptionStackTrace = ex.ToString();
                log.ExceptionType       = ex.GetType().ToString();
                log.Username            = Environment.UserName;


                db.ExceptionLog.Add(log);
                db.SaveChanges();
                exceptionInserts++;
            }
        }
Exemplo n.º 8
0
        /// <summary>
        /// Checks wether RemindMe can make a connection to the online SQL Database.
        /// </summary>
        /// <param name="db">The entities object representing the database</param>
        /// <returns>True if a connection can be made, false if not</returns>
        private static bool CanConnect(remindmesqldbEntities db)
        {
            if (terminateDatabaseAccess)
            {
                return(false);
            }

            try
            {
                terminateDatabaseAccess = !db.Database.Exists();

                if (terminateDatabaseAccess)
                {
                    return(false);
                }
            }
            catch (Exception ex) { return(false); } //TODO: this might increase cpu usage a bit if connecting to the database fails

            return(true);
        }
Exemplo n.º 9
0
        /// <summary>
        /// Gets the RemindMe messages from the database, sent by the creator of RemindMe
        /// </summary>
        public static RemindMeMessages GetRemindMeMessageById(int id)
        {
            try
            {
                using (remindmesqldbEntities db = new remindmesqldbEntities())
                {
                    int attemptCount = 0;
                    while (!terminateDatabaseAccess && !CanConnect(db))
                    {
                        Thread.Sleep(500);
                        if (attemptCount > MAX_ATTEMPTS)
                        {
                            break;
                        }
                    }

                    return(db.RemindMeMessages.Where(m => m.Id == id).FirstOrDefault());
                }
            }
            catch (DbUpdateException) { return(null); }
            catch { return(null); }
        }
Exemplo n.º 10
0
        private static bool CanConnect(remindmesqldbEntities db)
        {
            if (terminateDatabaseAccess)
            {
                return(false);
            }

            try
            {
                terminateDatabaseAccess = !db.Database.Exists();

                if (terminateDatabaseAccess)
                {
                    return(false);
                }

                db.Database.Connection.Open();
                db.Database.Connection.Close();
            }
            catch { return(false); }

            return(true);
        }