private void Delete()
{
try
{
if (dgvItems.SelectedRows.Count > 0)
{
List<string> selections = new List<string>();
foreach (DataGridViewRow row in dgvItems.SelectedRows)
selections.Add(Convert.ToString(row.Cells[0].Value));
using (MyDayData db = new MyDayData())
{
var query = from ts in db.TaskStatuses
where selections.Contains(ts.TaskStatusCode)
select ts;
if (query.FirstOrDefault() != null)
{
foreach (var row in query)
db.TaskStatuses.DeleteObject(row);
db.SaveChanges();
this.SetStatus("Selected items were deleted successfully");
this.PopulateList();
}
}
}
}
catch (Exception ex)
{
this.SetStatus(ex);
this.PopulateList();
}
finally
{
txtItem.Focus();
}
}
private void Add()
{
try
{
string item = txtItem.Text.Trim();
if (!String.IsNullOrEmpty(item))
{
using (MyDayData db = new MyDayData())
{
var query = from ts in db.TaskStatuses
where ts.TaskStatusCode == item
select new { TaskStatus = ts.TaskStatusCode };
if (query.FirstOrDefault() == null)
{
TaskStatus newItem = new TaskStatus { TaskStatusCode = item };
db.AddToTaskStatuses(newItem);
db.SaveChanges();
this.SetStatus("Item was added successfully");
this.PopulateList();
txtItem.Text = "";
}
}
}
}
catch (Exception ex)
{
this.SetStatus(ex);
this.PopulateList();
}
finally
{
txtItem.Focus();
}
}
private void txtFields_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (sender is TextBox)
{
TextBox ctrl = (TextBox)sender;
string val = ctrl.Text.Trim();
PictureBox newPic = null;
if (ctrl == txtProject)
{
if (String.IsNullOrEmpty(val))
return;
using (MyDayData db = new MyDayData())
{
var query = from t in db.Projects
where t.ProjectCode.Equals(val, StringComparison.InvariantCultureIgnoreCase)
select t;
var row = query.FirstOrDefault();
if (row == null)
{
newPic = pbNewProject;
txtTask.AutoCompleteList = null;
}
else
{
ctrl.Text = row.ProjectCode;
var tasksQuery = from t in db.Tasks
where t.ProjectCode.Equals(val, StringComparison.InvariantCultureIgnoreCase)
orderby t.TaskCode
select t.TaskCode;
txtTask.AutoCompleteList = tasksQuery.ToList();
}
}
}
else if (ctrl == txtTask)
{
if (String.IsNullOrEmpty(val))
return;
using (MyDayData db = new MyDayData())
{
var query = from t in db.Tasks
where t.ProjectCode.Equals(txtProject.Text.Trim(), StringComparison.InvariantCultureIgnoreCase)
&& t.TaskCode.Equals(val, StringComparison.InvariantCultureIgnoreCase)
select t;
var row = query.FirstOrDefault();
if (row == null)
{
newPic = pbNewTask;
txtTaskType.Text = String.Empty;
txtTaskStatus.Text = String.Empty;
txtEstEffort.Text = String.Empty;
}
else
{
ctrl.Text = row.TaskCode;
txtTaskType.Text = row.TaskTypeCode;
txtTaskStatus.Text = row.TaskStatusCode;
txtEstEffort.Text = row.EstimatedEffortHours.HasValue ? Convert.ToDouble(row.EstimatedEffortHours).ToString("F2") : "";
}
}
}
else if (ctrl == txtTaskType)
{
if (String.IsNullOrEmpty(val))
return;
using (MyDayData db = new MyDayData())
{
var query = from t in db.TaskTypes
where t.TaskTypeCode.Equals(val, StringComparison.InvariantCultureIgnoreCase)
select t;
var row = query.FirstOrDefault();
if (row == null)
newPic = pbNewTaskType;
else
ctrl.Text = row.TaskTypeCode;
}
}
else if (ctrl == txtTaskType)
{
if (String.IsNullOrEmpty(val))
return;
using (MyDayData db = new MyDayData())
{
var query = from t in db.TaskTypes
where t.TaskTypeCode.Equals(val, StringComparison.InvariantCultureIgnoreCase)
select t;
var row = query.FirstOrDefault();
if (row == null)
newPic = pbNewTaskType;
else
ctrl.Text = row.TaskTypeCode;
}
}
else if (ctrl == txtTaskStatus)
{
if (String.IsNullOrEmpty(val))
return;
using (MyDayData db = new MyDayData())
{
var query = from t in db.TaskStatuses
where t.TaskStatusCode.Equals(val, StringComparison.InvariantCultureIgnoreCase)
select t;
var row = query.FirstOrDefault();
if (row == null)
newPic = pbNewTaskStatus;
else
ctrl.Text = row.TaskStatusCode;
}
}
else if (ctrl == txtEstEffort)
{
if (!String.IsNullOrEmpty(val))
{
decimal decVal;
if (!Decimal.TryParse(val, out decVal) || decVal <= 0)
{
this.SetStatus("Please enter a valid decimal value");
return;
}
else
ctrl.Text = decVal.ToString("F2");
}
}
else if (ctrl == txtAction)
{
if (String.IsNullOrEmpty(val))
return;
if (lblActionCode.Text.Equals("(New)"))
newPic = pbNewAction;
}
else if (ctrl == txtActionType)
{
if (String.IsNullOrEmpty(val))
return;
using (MyDayData db = new MyDayData())
{
var query = from t in db.ActionTypes
where t.ActionTypeCode.Equals(val, StringComparison.InvariantCultureIgnoreCase)
select t;
var row = query.FirstOrDefault();
if (row == null)
newPic = pbNewActionType;
else
ctrl.Text = row.ActionTypeCode;
}
}
else if (ctrl == txtActionTags)
{
if (!String.IsNullOrEmpty(val))
{
if (!tpTags.ContainsTag(val))
{
string tagCaption = String.Empty;
using (MyDayData db = new MyDayData())
{
var query = from t in db.Tags
where t.TagCode.Equals(val, StringComparison.InvariantCultureIgnoreCase)
select t;
var row = query.FirstOrDefault();
if (row == null)
tagCaption = val + " (New)";
else
{
val = row.TagCode;
tagCaption = val;
}
}
tpTags.AddTag(val, tagCaption);
}
txtActionTags.Text = String.Empty;
return;
}
}
this.MoveToNextControl(ctrl, newPic);
}
else if (sender is DateTimePicker)
{
DateTimePicker ctrl = (DateTimePicker)sender;
if (ctrl == dtpActionTimeTo)
{
if (dtpActionTimeTo.Value <= dtpActionTimeFrom.Value)
{
this.SetStatus("The Action End Time must be greater than the Action Start Time");
return;
}
}
this.MoveToNextControl(ctrl);
}
}
else if (e.KeyCode == Keys.Up)
{
if (sender == txtAction)
{
AutoCompleteBox ctrl = (AutoCompleteBox)sender;
SearchList list = new SearchList();
}
}
}
private void Save()
{
try
{
using (MyDayData db = new MyDayData())
{
string projectCode = txtProject.Text.Trim();
string taskCode = txtTask.Text.Trim();
string taskTypeCode = txtTaskType.Text.Trim();
string taskStatusCode = txtTaskStatus.Text.Trim();
decimal? estEff = null;
string estEffStr = txtEstEffort.Text.Trim();
if (!String.IsNullOrEmpty(estEffStr))
estEff = Convert.ToDecimal(estEffStr);
string action = txtAction.Text.Trim();
DateTime actionStartTime = dtpActionDate.Value.Date.Add(dtpActionTimeFrom.Value.Subtract(dtpActionTimeFrom.Value.Date));
DateTime actionEndTime = dtpActionDate.Value.Date.Add(dtpActionTimeTo.Value.Subtract(dtpActionTimeTo.Value.Date));
string actionTypeCode = txtActionType.Text.Trim();
Dictionary<string, string> actionTags = tpTags.GetTags();
if (pbNewProject.Visible)
{
Project newProject = new Project();
newProject.ProjectCode = projectCode;
db.AddToProjects(newProject);
}
if (pbNewTaskType.Visible)
{
TaskType newTaskType = new TaskType();
newTaskType.TaskTypeCode = taskTypeCode;
db.AddToTaskTypes(newTaskType);
}
if (pbNewTaskStatus.Visible)
{
TaskStatus newTaskStatus = new TaskStatus();
newTaskStatus.TaskStatusCode = taskStatusCode;
db.AddToTaskStatuses(newTaskStatus);
}
if (pbNewActionType.Visible)
{
ActionType newActionType = new ActionType();
newActionType.ActionTypeCode = actionTypeCode;
db.AddToActionTypes(newActionType);
}
if (pbNewTask.Visible)
{
Task newTask = new Task();
newTask.ProjectCode = projectCode;
newTask.TaskCode = taskCode;
newTask.TaskTypeCode = taskTypeCode;
newTask.TaskStatusCode = taskStatusCode;
newTask.EstimatedEffortHours = estEff;
db.AddToTasks(newTask);
}
else
{
var query = from t in db.Tasks
where t.ProjectCode.Equals(projectCode, StringComparison.InvariantCultureIgnoreCase)
&& t.TaskCode.Equals(taskCode, StringComparison.InvariantCultureIgnoreCase)
select t;
Task currentTask = query.First();
currentTask.TaskTypeCode = taskTypeCode;
currentTask.TaskStatusCode = taskStatusCode;
currentTask.EstimatedEffortHours = estEff;
}
MyDay.Data.Action actionEnt = null;
if (lblActionCode.Text == "(New)")
{
actionEnt = new MyDay.Data.Action();
actionEnt.ProjectCode = projectCode;
actionEnt.TaskCode = taskCode;
actionEnt.ActionTypeCode = actionTypeCode;
actionEnt.FromTime = actionStartTime;
actionEnt.ToTime = actionEndTime;
actionEnt.ActionComments = action;
db.AddToActions(actionEnt);
}
else
{
long actionCode = Convert.ToInt64(lblActionCode.Text);
var query = from t in db.Actions
where t.ActionCode == actionCode
select t;
actionEnt = query.First();
actionEnt.ActionTypeCode = actionTypeCode;
actionEnt.FromTime = actionStartTime;
actionEnt.ToTime = actionEndTime;
actionEnt.ActionComments = action;
}
using (var txn = db.BeginTransaction())
{
db.SaveChanges();
var query = from t in db.ActionTags
where t.ActionCode == actionEnt.ActionCode
select t;
foreach (var row in query)
db.DeleteObject(row);
foreach (KeyValuePair<string, string> tag in actionTags)
{
if (tag.Value.EndsWith("(New)") && !tag.Key.Equals(tag.Value))
{
MyDay.Data.Tag newTag = new Tag();
newTag.TagCode = tag.Key;
db.AddToTags(newTag);
}
MyDay.Data.ActionTag actionTagEnt = new ActionTag();
actionTagEnt.ActionCode = actionEnt.ActionCode;
actionTagEnt.TagCode = tag.Key;
db.AddToActionTags(actionTagEnt);
}
db.SaveChanges();
txn.Commit();
}
}
this.ResetControls(true);
this.SetStatus("The specified Action was saved successfully");
}
catch (Exception ex)
{
this.SetStatus(ex);
}
}
private void ResetControls(bool sameProject = false)
{
using (var db = new MyDayData())
{
var projectQuery = from t in db.Projects
orderby t.ProjectCode
select t.ProjectCode;
txtProject.AutoCompleteList = projectQuery.ToList();
var taskTypeQuery = from t in db.TaskTypes
orderby t.TaskTypeCode
select t.TaskTypeCode;
txtTaskType.AutoCompleteList = taskTypeQuery.ToList();
var taskStatusQuery = from t in db.TaskStatuses
orderby t.TaskStatusCode
select t.TaskStatusCode;
txtTaskStatus.AutoCompleteList = taskStatusQuery.ToList();
var actionTypeQuery = from t in db.ActionTypes
orderby t.ActionTypeCode
select t.ActionTypeCode;
txtActionType.AutoCompleteList = actionTypeQuery.ToList();
var tagsQuery = from t in db.Tags
orderby t.TagCode
select t.TagCode;
txtActionTags.AutoCompleteList = tagsQuery.ToList();
}
foreach (Control ctrl in this.pnlFields.Controls)
{
if (!(ctrl is Label))
{
ctrl.Enabled = false;
if (ctrl is TextBox && !(sameProject && ctrl == txtProject))
ctrl.Text = String.Empty;
if (ctrl is TagPanel)
((TagPanel)ctrl).ClearTags();
else if (ctrl is PictureBox)
ctrl.Visible = false;
}
}
dtpActionTimeFrom.Value = dtpActionTimeTo.Value;
btnCancel.Enabled = true;
btnTimerToggle.Enabled = true;
lblActionCode.Text = "(New)";
this.SetStatus("Tip: Hit Up Arrow Key to select/search existing values.");
txtProject.Enabled = true;
txtProject.Focus();
this.txtFields_KeyUp(txtProject, new KeyEventArgs(Keys.Enter));
}
private void PopulateList()
{
try{
using (MyDayData db = new MyDayData())
{
var query = from ts in db.TaskStatuses
select new { TaskStatus = ts.TaskStatusCode };
dgvItems.DataSource = query;
}
}
catch (Exception ex)
{
this.SetStatus(ex);
}
finally
{
txtItem.Focus();
}
}