Example #1
0
        public static DateTime CaluculateTheNextADayOfEveryMonth(ListAutoGenerate entry)
        {
            DateTime CheckedDate;

            DateTime.TryParseExact(
                entry.Checked_date,
                "yyyy-MM-dd HH:mm:ss",
                System.Globalization.CultureInfo.InvariantCulture,
                System.Globalization.DateTimeStyles.None,
                out CheckedDate);
            Int32 theDay   = (int)entry.Number0;
            Int32 theMonth = CheckedDate.Month;
            Int32 theYear  = CheckedDate.Year;

            if (theDay <= CheckedDate.Day)
            {
                theMonth++;
                if (theMonth > 12)
                {
                    theYear++;
                    theMonth = 1;
                }
            }
            Int32 maxDay = DateTime.DaysInMonth(theYear, theMonth);

            if (theDay > maxDay)
            {
                theDay = maxDay;
            }
            return(new DateTime(theYear, theMonth, theDay));
        }
Example #2
0
        public static int AutoGenerateTask(string dbpath, ListAutoGenerate entry, DateTime theDate)
        {
            int      result  = 0;
            DateTime dueDate = new DateTime(theDate.Year, theDate.Month, theDate.Day, (int)entry.Due_hour, (int)entry.Due_minute, 0);

            if (TimeZoneInfo.Local.IsInvalidTime(dueDate))
            {
                dueDate = new DateTime(theDate.Year, theDate.Month, theDate.Day, 0, 0, 0);
            }
            ListViewFile lvFile = new ListViewFile()
            {
                Name        = entry.Name,
                Description = "",
                Memo        = "",
                Priority    = entry.Priority,
                DueDate     = TimeZoneInfo.ConvertTimeToUtc(dueDate).ToString("yyyy-MM-dd HH:mm:ss"),
                Status      = "Active",
                WorkHolder  = WorkHolder.CreateWorkHolder(entry.Name)
            };

            if (entry.Template > 0)
            {
                var tlv = new TemplateListViewModel();
                if (SQLiteClass.ExecuteSelectATableTemplate(dbpath, tlv, entry.Template))
                {
                    if (!string.IsNullOrEmpty(tlv.Entries[0].Template))
                    {
                        lvFile.Description = tlv.Entries[0].Template;
                        result            += 1;
                    }
                }
            }

            Int64 retId;

            retId = SQLiteClass.ExecuteInsertTable(dbpath, lvFile);
            if (retId > 0)
            {
                result += 2;
            }
            if (SQLiteClass.ExecuteInsertTableFTSString(dbpath, retId, "tasklist_name", Ngram.getNgramText(lvFile.Name, 2)))
            {
                result += 4;
            }
            if (SQLiteClass.ExecuteInsertTableFTSString(dbpath, retId, "tasklist_description", Ngram.getNgramText(lvFile.Description, 2)))
            {
                result += 8;
            }

            // copy template path
            if (entry.Template > 0)
            {
                string workHolder = WorkHolder.CreateWorkHolder(entry.Name);
                if (WorkHolder.CopyTemplatePathToWorkFolder(dbpath, entry.Template, workHolder) > 0)
                {
                    result += 16;
                }
            }
            return(result);
        }
Example #3
0
        public static Boolean ExecuteSelectTableAutoGenerate(string dbpath, AutoGenerateListViewModel aglv)
        {
            Boolean ret = false;

            string sql = "SELECT * from autogenerate ORDER BY torder ASC";

            SQLiteConnection con = new SQLiteConnection("Data Source=" + dbpath + ";");

            con.Open();

            SQLiteCommand com = new SQLiteCommand(sql, con);

            try
            {
                SQLiteDataReader sdr = com.ExecuteReader();

                while (sdr.Read() == true)
                {
                    ListAutoGenerate lt = new ListAutoGenerate();
                    lt.Id           = (Int64)sdr["id"];
                    lt.Order        = (Int64)sdr["torder"];
                    lt.Type         = (Int64)sdr["type"];
                    lt.Name         = (string)sdr["name"];
                    lt.Priority     = (string)sdr["priority"];
                    lt.Template     = (Int64)sdr["template"];
                    lt.Number0      = (Int64)sdr["number0"];
                    lt.Number1      = (Int64)sdr["number1"];
                    lt.Due_hour     = (Int64)sdr["due_hour"];
                    lt.Due_minute   = (Int64)sdr["due_minute"];
                    lt.Checked_date = (string)sdr["checked_date"];
                    aglv.Entries.Add(lt);
                }
                sdr.Close();
                ret = true;
            }
            catch (Exception ex)
            {
                MessageBox.Show("database table autogenerate select error!\n" + ex.Message);
            }
            finally
            {
                con.Close();
            }
            return(ret);
        }
Example #4
0
        public static DateTime CaluculateTheNextAWeekDayOfEveryWeek(ListAutoGenerate entry)
        {
            DateTime CheckedDate;

            DateTime.TryParseExact(
                entry.Checked_date,
                "yyyy-MM-dd HH:mm:ss",
                System.Globalization.CultureInfo.InvariantCulture,
                System.Globalization.DateTimeStyles.None,
                out CheckedDate);
            Int32 theWeekday = (int)entry.Number1;
            Int32 theDay     = CheckedDate.Day;
            Int32 theMonth   = CheckedDate.Month;
            Int32 theYear    = CheckedDate.Year;
            Int32 plusDays   = theWeekday - (int)CheckedDate.DayOfWeek;

            if (plusDays <= 0)
            {
                plusDays += 7;
            }
            return(new DateTime(theYear, theMonth, theDay) + new TimeSpan(plusDays, 0, 0, 0));
        }
Example #5
0
        public static Boolean ExecuteInsertTableAutoGenerate(string dbpath, ListAutoGenerate lt)
        {
            Boolean ret = false;
            object  obj;

            SQLiteConnection con = new SQLiteConnection("Data Source=" + dbpath + ";");

            con.Open();

            SQLiteCommand com = new SQLiteCommand("INSERT INTO autogenerate (torder, type, name, priority, template, number0, number1, due_hour, due_minute, checked_date) VALUES (@torder, @type, @name, @priority, @template, @number0, @number1, @due_hour, @due_minute, @checked_date)", con);

            com.Parameters.Add(sqliteParamInt64(com, "@torder", lt.Order));
            com.Parameters.Add(sqliteParamInt64(com, "@type", lt.Type));
            com.Parameters.Add(sqliteParam(com, "@name", lt.Name));
            com.Parameters.Add(sqliteParam(com, "@priority", lt.Priority));
            com.Parameters.Add(sqliteParamInt64(com, "@template", lt.Template));
            com.Parameters.Add(sqliteParamInt64(com, "@number0", lt.Number0));
            com.Parameters.Add(sqliteParamInt64(com, "@number1", lt.Number1));
            com.Parameters.Add(sqliteParamInt64(com, "@due_hour", lt.Due_hour));
            com.Parameters.Add(sqliteParamInt64(com, "@due_minute", lt.Due_minute));
            com.Parameters.Add(sqliteParam(com, "@checked_date", lt.Checked_date));

            try
            {
                obj = com.ExecuteNonQuery();
                ret = true;
            }
            catch (Exception ex)
            {
                MessageBox.Show("database table autogenerate insert error!\n" + ex.Message);
            }
            finally
            {
                con.Close();
            }
            return(ret);
        }
Example #6
0
        public static Boolean ExecuteUpdateTableAutoGenerate(string dbpath, ListAutoGenerate lt)
        {
            Boolean ret = false;

            SQLiteConnection con = new SQLiteConnection("Data Source=" + dbpath + ";");

            con.Open();

            SQLiteCommand com = new SQLiteCommand("UPDATE autogenerate set torder=@torder, type=@type, name=@name, priority=@priority, template=@template, number0=@number0, number1=@number1, due_hour=@due_hour, due_minute=@due_minute, checked_date=@checked_date where id=@id", con);

            com.Parameters.Add(sqliteParamInt64(com, "@id", lt.Id));
            com.Parameters.Add(sqliteParamInt64(com, "@torder", lt.Order));
            com.Parameters.Add(sqliteParamInt64(com, "@type", lt.Type));
            com.Parameters.Add(sqliteParam(com, "@name", lt.Name));
            com.Parameters.Add(sqliteParam(com, "@priority", lt.Priority));
            com.Parameters.Add(sqliteParamInt64(com, "@template", lt.Template));
            com.Parameters.Add(sqliteParamInt64(com, "@number0", lt.Number0));
            com.Parameters.Add(sqliteParamInt64(com, "@number1", lt.Number1));
            com.Parameters.Add(sqliteParamInt64(com, "@due_hour", lt.Due_hour));
            com.Parameters.Add(sqliteParamInt64(com, "@due_minute", lt.Due_minute));
            com.Parameters.Add(sqliteParam(com, "@checked_date", lt.Checked_date));

            try
            {
                com.ExecuteNonQuery();
                ret = true;
            }
            catch (Exception ex)
            {
                MessageBox.Show("database table autogenerate update error!\n" + ex.Message);
            }
            finally
            {
                con.Close();
            }
            return(ret);
        }