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();
}
}