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