public static void MigrateDailyToDaily(int _sourceId, int _targetId)
{
DBTools db = new DBTools(Properties.Settings.Default.ConnectionString);
int layer = GetDailyLayer(_targetId);
string insertCommand = "insert into currenttasks " +
"(description, layerid, previouslayerid, dateadded, datechanged, taskisimportant, tasktype) " +
"(select description, @layerid, @previouslayerid, dateadded, datechanged, taskisimportant, tasktype " +
"from currenttasks " +
"where id = @id) ";
SqlParameter[] insertParameter = new SqlParameter[]
{
new SqlParameter("@id", SqlDbType.Int)
{
Value = _sourceId
},
new SqlParameter("@layerid", SqlDbType.Int)
{
Value = layer + 1
},
new SqlParameter("@previouslayerid", SqlDbType.Int)
{
Value = _targetId
},
};
db.GenericNonQueryAction(insertCommand, insertParameter);
}
private void dataGrid_content_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
selectedId = JournalTask.ContentClickHandler(dataGrid_content, e);
string command = "";
if (entryType == JournalTask.EntryType.daily)
{
command = "update currenttasks " +
"set " +
"iscompleted = @iscompleted, " +
"datecompleted = @completeddate " +
"where id = @id";
}
if (entryType == JournalTask.EntryType.monthly)
{
command = "update monthlytasks " +
"set " +
"iscompleted = @iscompleted, " +
"datecompleted = @completeddate " +
"where id = @id";
}
if (entryType == JournalTask.EntryType.future)
{
command = "update futuretasks " +
"set " +
"iscompleted = @iscompleted, " +
"datecompleted = @completeddate " +
"where id = @id";
}
if (e.ColumnIndex == 0)
{
foreach (int pickedId in JournalTask.GetAllPreviousLayerId(selectedId, entryType))
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@id", SqlDbType.Int)
{
Value = pickedId
},
new SqlParameter("@iscompleted", SqlDbType.Bit)
{
Value = false
},
new SqlParameter("@completeddate", SqlDbType.DateTime)
{
Value = DBNull.Value
}
};
db.GenericNonQueryAction(command, parameter);
}
OnRefreshGrid();
}
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
string command = "delete from monthlytasks " +
"where id = @ids";
List <int> ids = JournalTask.GetAllMonthlyTasksId(selectedId);
for (int i = 0; i < ids.Count; i++)
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@ids", SqlDbType.Int)
{
Value = ids[i]
}
};
db.GenericNonQueryAction(command, parameter);
}
OnMonthlyTaskSave();
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
string command = "delete from habit " +
"where id = @ids";
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@ids", SqlDbType.Int)
{
Value = selectedId
}
};
db.GenericNonQueryAction(command, parameter);
RefreshGrid();
}
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();
}
}
private void saveToolStripMenuItem_Click(object sender, EventArgs e)
{
// validation
if (!(JournalTask.IsInputInvalid(txt_notes)))
{
return;
}
// add
if (mode == JournalTask.EntryMode.add)
{
string command = "insert into notes " +
"(notedescription, layerid, previouslayerid, dateadded, datechanged) " +
"values " +
"(@desc, @layerid, @prevlayer, @dateadded, @datechanged) ";
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@desc", SqlDbType.NVarChar)
{
Value = txt_notes.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
}
};
db.GenericNonQueryAction(command, parameter);
}
// edit
if (mode == JournalTask.EntryMode.edit)
{
string command = "update notes " +
"set " +
"notedescription = @desc, " +
"datechanged = @datechanged " +
"where id = @id";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@desc", SqlDbType.NVarChar)
{
Value = txt_notes.Text
},
new SqlParameter("@id", SqlDbType.Int)
{
Value = id
},
new SqlParameter("@datechanged", SqlDbType.DateTime)
{
Value = DateTime.Now
}
};
db.GenericNonQueryAction(command, parameters);
}
// Cleanup
txt_notes.Text = "";
// Broadcast the event
OnNotesSave();
// Close when on edit mode
if (mode == JournalTask.EntryMode.edit)
{
this.Close();
}
}
private void saveToolStripMenuItem_Click(object sender, EventArgs e)
{
// validation
if (!(JournalTask.IsInputInvalid(txt_currentTaskDescription)))
{
return;
}
if (entryMode == JournalTask.EntryMode.add)
{
string command = "insert into habit " +
"(description, isvisible) " +
"values " +
"(@description, @isvisible)";
SqlParameter[] paramter = new SqlParameter[]
{
new SqlParameter("@description", SqlDbType.NVarChar)
{
Value = txt_currentTaskDescription.Text
},
new SqlParameter("isvisible", SqlDbType.Bit)
{
Value = chk_taskIsVisible.Checked
}
};
db.GenericNonQueryAction(command, paramter);
}
if (entryMode == JournalTask.EntryMode.edit)
{
string command = "update habit " +
"set " +
"description = @desc, " +
"isvisible = @isvisible " +
"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("@isvisible", SqlDbType.Bit)
{
Value = chk_taskIsVisible.Checked
}
};
db.GenericNonQueryAction(command, parameters);
}
txt_currentTaskDescription.Text = "";
if (entryMode == JournalTask.EntryMode.edit)
{
this.Close();
}
OnSave();
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
if (entryType == JournalTask.EntryType.daily)
{
string command = "delete from currenttasks " +
"where id = @ids";
List <int> ids = JournalTask.GetAllCurrentTasksId(taskId);
for (int i = 0; i < ids.Count; i++)
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@ids", SqlDbType.Int)
{
Value = ids[i]
}
};
db.GenericNonQueryAction(command, parameter);
}
RefreshGrid();
}
if (entryType == JournalTask.EntryType.monthly)
{
string command = "delete from monthlytasks " +
"where id = @ids";
List <int> ids = JournalTask.GetAllMonthlyTasksId(taskId);
for (int i = 0; i < ids.Count; i++)
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@ids", SqlDbType.Int)
{
Value = ids[i]
}
};
db.GenericNonQueryAction(command, parameter);
}
RefreshGrid();
}
if (entryType == JournalTask.EntryType.future)
{
string command = "delete from futuretasks " +
"where id = @ids";
List <int> ids = JournalTask.GetAllFutureTasksId(taskId);
for (int i = 0; i < ids.Count; i++)
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@ids", SqlDbType.Int)
{
Value = ids[i]
}
};
db.GenericNonQueryAction(command, parameter);
}
RefreshGrid();
}
if (entryType == JournalTask.EntryType.notes)
{
string command = "delete from notes " +
"where id = @ids";
List <int> ids = JournalTask.GetAllNoteId(taskId);
for (int i = 0; i < ids.Count; i++)
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@ids", SqlDbType.Int)
{
Value = ids[i]
}
};
db.GenericNonQueryAction(command, parameter);
}
RefreshGrid();
}
}