public static List <int> GetAllIdInLayer(int _layer, JournalTask.EntryType _mode) { List <int> idInLayer = new List <int>(); DBTools db = new DBTools(Properties.Settings.Default.ConnectionString); string command = ""; if (_mode == JournalTask.EntryType.daily) { command = "select id from currenttasks where layerid = @layerid"; } if (_mode == JournalTask.EntryType.monthly) { command = "select id from monthlytasks where layerid = @layerid"; } if (_mode == JournalTask.EntryType.future) { command = "select id from futuretasks where layerid = @layerid"; } SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("layerid", SqlDbType.Int) { Value = _layer } }; foreach (DataRow row in db.GenericQueryAction(command, parameter).AsEnumerable().ToList()) { idInLayer.Add(row.Field <int>("id")); } return(idInLayer); }
private void dataGrid_collection_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e) { // Right Click if (e.Button == MouseButtons.Right) { title = dataGrid_notes.SelectedRows[0].Cells[1].Value.ToString(); // Store id taskId = JournalTask.ContextMenuHandler(dataGrid_notes, contextMenuStrip1, e); contextMenuStrip1.Items["migrate"].Visible = false; entryType = JournalTask.EntryType.notes; } }
public CurrentTaskDescription(JournalTask.EntryMode _entryMode, int _id, int _layer, JournalTask.EntryType _entryType = JournalTask.EntryType.none) { InitializeComponent(); // initialize db db = new DBTools(Properties.Settings.Default.ConnectionString); // store ids id = _id; layer = _layer; // store mode mode = _entryMode; entryType = _entryType; cmb_taskType.SelectedIndex = 0; // Edit Mode if (mode == JournalTask.EntryMode.edit) { this.Text = "Edit Daily Task"; // Query the category name string command = "select description, " + "taskisimportant," + "tasktype " + "from currenttasks " + "where id = @id"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int) { Value = id } }; DataTable dataTable = db.GenericQueryAction(command, parameters); DataRow dataRow = dataTable.AsEnumerable().ToList()[0]; // Set the textbox to the category name txt_currentTaskDescription.Text = dataRow.Field <string>("description"); cmb_taskType.SelectedIndex = dataRow.Field <int>("tasktype"); chk_taskIsImportant.Checked = dataRow.Field <bool>("taskisimportant"); } }
public static List <int> GetAllPreviousLayerId(int _id, JournalTask.EntryType _entryType) { List <int> returnList = new List <int>(); int id = _id; returnList.Add(id); while (GetPreviousLayerId(id, _entryType) != -1) { id = GetPreviousLayerId(id, _entryType); returnList.Add(id); } return(returnList); }
private void GridController(JournalTask.EntryType entryType) { switch (entryType) { case JournalTask.EntryType.daily: Populate_DailyTasks(); break; case JournalTask.EntryType.monthly: Populate_MonthlyTasks(); break; case JournalTask.EntryType.future: Populate_FutureTasks(); break; default: break; } }
public History(JournalTask.EntryType _entryType, string _title, int _layer = 0, int _currentId = 0) { InitializeComponent(); db = new DBTools(Properties.Settings.Default.ConnectionString); entryType = _entryType; layer = _layer; currentId = _currentId; lbl_title.Text = _title; DataGridViewButtonColumn button = new DataGridViewButtonColumn(); button.Name = "btn_undo"; button.HeaderText = "Action"; button.Text = "Undo"; button.UseColumnTextForButtonValue = true; dataGrid_content.Columns.Add(button); GridController(entryType); }
public static int GetPreviousLayerId(int _id, JournalTask.EntryType _entryType) { DBTools db = new DBTools(Properties.Settings.Default.ConnectionString); string command = ""; if (_entryType == JournalTask.EntryType.daily) { command = "select previouslayerid from currenttasks " + "where id = @id"; } if (_entryType == JournalTask.EntryType.monthly) { command = "select previouslayerid from monthlytasks " + "where id = @id"; } if (_entryType == JournalTask.EntryType.future) { command = "select previouslayerid from futuretaks " + "where id = @id"; } SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("id", SqlDbType.Int) { Value = _id } }; DataTable dataTable = db.GenericQueryAction(command, parameter); DataRow row = dataTable.AsEnumerable().ToList()[0]; return(row.Field <int>("previouslayerid")); }
public Migration ( JournalTask.EntryType _entryTypeFr, JournalTask.EntryType _entryTypeTo, int _sourceId, string _title, int _layer, int _currentId = 0 ) { InitializeComponent(); db = new DBTools(Properties.Settings.Default.ConnectionString); entryTypeFr = _entryTypeFr; entryTypeTo = _entryTypeTo; sourceId = _sourceId; layer = _layer; currentId = _currentId; lbl_title.Text = _title; GridController(entryTypeTo); }
private void dataGrid_futureLog_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e) { if (e.Button == MouseButtons.Left) { taskId = JournalTask.ContextMenuHandler(dataGrid_futureLog, contextMenuStrip1, e); if (taskId != 0) { title = dataGrid_futureLog.SelectedRows[0].Cells[4].Value.ToString(); } entryType = JournalTask.EntryType.future; contextMenuStrip1.Hide(); } // right clock if (e.Button == MouseButtons.Right) { title = dataGrid_futureLog.SelectedRows[0].Cells[4].Value.ToString(); taskId = JournalTask.ContextMenuHandler(dataGrid_futureLog, contextMenuStrip1, e); entryType = JournalTask.EntryType.future; } }