private void MigrateFutureToFuture(int _id) { foreach (DataGridViewRow row in dataGrid_content.SelectedRows) { MigrationHelper.MigrateFutureToFuture(_id, (int)row.Cells[0].Value); } }
private void MigrateMonthlyToDaily(int _id) { foreach (DataGridViewRow row in dataGrid_content.SelectedRows) { MigrationHelper.MigrateMonthlyToDaily(_id, (int)row.Cells[0].Value); } }
private void saveToolStripMenuItem_Click(object sender, EventArgs e) { // validation if (!(JournalTask.IsInputInvalid(txt_currentTaskDescription))) { return; } // add if (mode == JournalTask.EntryMode.add) { string command = "insert into futuretasks " + "(description, layerid, previouslayerid, dateadded, datechanged, taskisimportant, tasktype) " + "values " + "(@desc, @layerid, @prevlayer, @dateadded, @datechanged, @taskisimportant, @tasktype) "; SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@desc", SqlDbType.NVarChar) { Value = txt_currentTaskDescription.Text }, new SqlParameter("@layerid", SqlDbType.Int) { Value = layer }, new SqlParameter("@prevlayer", SqlDbType.Int) { Value = id }, new SqlParameter("@dateadded", SqlDbType.DateTime) { Value = DateTime.Now }, new SqlParameter("@datechanged", SqlDbType.DateTime) { Value = DateTime.Now }, new SqlParameter("@taskisimportant", SqlDbType.Bit) { Value = chk_taskIsImportant.Checked }, new SqlParameter("@tasktype", SqlDbType.Int) { Value = JournalTask.GetTask(cmb_taskType.Text) } }; db.GenericNonQueryAction(command, parameter); } // edit if (mode == JournalTask.EntryMode.edit) { string command = "update futuretasks " + "set " + "description = @desc, " + "datechanged = @datechanged," + "tasktype = @tasktype, " + "taskisimportant = @taskisimportant " + "where id = @id"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@desc", SqlDbType.NVarChar) { Value = txt_currentTaskDescription.Text }, new SqlParameter("@id", SqlDbType.Int) { Value = id }, new SqlParameter("@datechanged", SqlDbType.DateTime) { Value = DateTime.Now }, new SqlParameter("@tasktype", SqlDbType.Int) { Value = JournalTask.GetTask(cmb_taskType.Text) }, new SqlParameter("@taskisimportant", SqlDbType.Bit) { Value = chk_taskIsImportant.Checked } }; db.GenericNonQueryAction(command, parameters); } // migrate if (mode == JournalTask.EntryMode.migrate) { string command = "insert into futuretasks " + "(description, layerid, previouslayerid, dateadded, datechanged, taskisimportant, tasktype) " + "output inserted.id " + "values " + "(@desc, @layerid, @prevlayer, @dateadded, @datechanged, @taskisimportant, @tasktype) "; SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@desc", SqlDbType.NVarChar) { Value = txt_currentTaskDescription.Text }, new SqlParameter("@layerid", SqlDbType.Int) { Value = 0 }, new SqlParameter("@prevlayer", SqlDbType.Int) { Value = -1 }, new SqlParameter("@dateadded", SqlDbType.DateTime) { Value = DateTime.Now }, new SqlParameter("@datechanged", SqlDbType.DateTime) { Value = DateTime.Now }, new SqlParameter("@taskisimportant", SqlDbType.Bit) { Value = chk_taskIsImportant.Checked }, new SqlParameter("@tasktype", SqlDbType.Int) { Value = JournalTask.GetTask(cmb_taskType.Text) } }; int insertedId = db.GenericScalarAction(command, parameter); switch (entryType) { case JournalTask.EntryType.daily: MigrationHelper.MigrateDailyToFuture(id, insertedId); break; case JournalTask.EntryType.monthly: MigrationHelper.MigrateMonthlyToFuture(id, insertedId); break; case JournalTask.EntryType.future: MigrationHelper.MigrateFutureToFuture(id, insertedId); break; default: break; } } // Cleanup txt_currentTaskDescription.Text = ""; // Broadcast the event OnFutureTaskSave(); // Close when on edit mode if (mode != JournalTask.EntryMode.add) { this.Close(); } }