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