/// <summary>
/// Adds an available task to a type
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddTask_Click(object sender, EventArgs e)
{
DataRowView selectedTask = (DataRowView)this.AvailableTasksListBox.SelectedItem;
if (selectedTask != null)
{
string task_id = selectedTask["task_id"].ToString();
DataRowView selectedType = (DataRowView)this.TypesListBox.SelectedItem;
string type_id = selectedType["type_id"].ToString();
if (!string.IsNullOrEmpty(task_id) && !string.IsNullOrEmpty(type_id))
{
string error = Data.Ins_Task(type_id, task_id, "");
if (string.IsNullOrEmpty(error))
{
//MessageBox.Show("Task was added for type");
this.info = info = new TimeTrackInfo();
this.TypesListBox_Bind();
this.TypesListBox.ClearSelected();
this.TypesListBox.SelectedValue = selectedType.Row[0];
this.RefereshMain();
}
else
{
MessageBox.Show(error);
}
}
}
}
/// <summary>
/// Adds a new sub task
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddSubTask_Click(object sender, EventArgs e)
{
DataRowView selectedTask = (DataRowView)this.CurrentTasksListBox.SelectedItem;
if (selectedTask != null)
{
string task_id = selectedTask["task_id"].ToString();
DataRowView selectedType = (DataRowView)this.TypesListBox.SelectedItem;
string type_id = selectedType["type_id"].ToString();
string link_id = selectedTask["link_id"].ToString();
DataRowView selectedSubTask = (DataRowView)this.AvailableSubTasksListBox.SelectedItem;
string sub_task_id = selectedSubTask["sub_task_id"].ToString();
if (!string.IsNullOrEmpty(sub_task_id))
{
string error = Data.Ins_New_Sub_Task(link_id, sub_task_id, "");
if (string.IsNullOrEmpty(error))
{
//MessageBox.Show("Sub Task was added for task");
this.info = info = new TimeTrackInfo();
this.TypesListBox_Bind();
this.TypesListBox.ClearSelected();
this.TypesListBox.SelectedValue = type_id;
this.CurrentTasksListBox.SelectedValue = task_id;
this.RefereshMain();
}
else
{
MessageBox.Show(error);
}
}
}
}
/// <summary>
/// Deletes a task
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDeleteTask_Click(object sender, EventArgs e)
{
DataRowView selectedTask = (DataRowView)this.CurrentTasksListBox.SelectedItem;
if (selectedTask != null)
{
// Get the values from the selected row
string task_id = selectedTask["task_id"].ToString();
string type_id = selectedTask["type_id"].ToString();
string link_id = selectedTask["link_id"].ToString();
// Check to make sure that they are not null
if (!string.IsNullOrEmpty(task_id) && !string.IsNullOrEmpty(type_id) && !string.IsNullOrEmpty(link_id))
{
string error = Data.Del_Task(task_id, link_id, type_id);
if (string.IsNullOrEmpty(error))
{
MessageBox.Show("Tasks is Deleted");
this.info = info = new TimeTrackInfo();
this.TypesListBox_Bind();
this.TypesListBox.ClearSelected();
this.TypesListBox.SelectedValue = type_id;
//this.CurrentTasksListBox.SelectedValue = task_id;
this.RefereshMain();
}
else
{
MessageBox.Show(error);
}
}
}
}
/// <summary>
/// Creates a new type
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnNewType_Click(object sender, EventArgs e)
{
string newType = this.txtNewType.Text;
if (!string.IsNullOrEmpty(newType))
{
string error = Data.Ins_Type(newType);
if (string.IsNullOrEmpty(error))
{
//MessageBox.Show("Type was added");
this.info = null;
this.txtNewType.Clear();
this.TypesListBox_Bind();
this.RefereshMain();
}
else
{
MessageBox.Show(error);
}
}
else
{
MessageBox.Show("Please enter a type");
}
}
/// <summary>
/// Deletes a type
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click(object sender, EventArgs e)
{
DataRowView selectedType = (DataRowView)this.TypesListBox.SelectedItem;
string error = string.Empty;
string type_id = selectedType["type_id"].ToString();
if (!string.IsNullOrEmpty(type_id))
{
DialogResult results = MessageBox.Show("Are you sure you want to delete the type?", "Delete Type", MessageBoxButtons.YesNo);
if (results == System.Windows.Forms.DialogResult.Yes)
{
// First delete the tasks, which will also delete the sub tasks
for (int x = 0; x < this.CurrentTasksListBox.Items.Count; x++)
{
DataRowView task = (DataRowView)this.CurrentTasksListBox.Items[x];
string task_id = task["task_id"].ToString();
string link_id = task["link_id"].ToString();
error = Data.Del_Task(task_id, link_id, type_id);
if (!string.IsNullOrEmpty(error))
{
MessageBox.Show(error);
return;
}
}
error = Data.Del_Type(type_id);
if (string.IsNullOrEmpty(error))
{
MessageBox.Show("Type was deleted");
this.info = null;
this.TypesListBox_Bind();
this.RefereshMain();
}
else
{
MessageBox.Show(error);
}
}
}
}