private void SetNodesToDefault() { ActivitiesAdapter = new activitiesTableAdapter(); activitiesDataTable ActivitiesTable = ActivitiesAdapter.GetActivityIDByCustomerIDAndPrice(deafalultPrice, CustomerID); foreach (TreeNode node in treeViewHourlyRate.Nodes) { if (ActivitiesTable.Any(x => x.ID.Equals(node.Tag))) { node.Checked = true; } foreach (TreeNode children in node.Nodes) { if (ActivitiesTable.Any(x => x.ID.Equals(children.Tag))) { children.Checked = true; } } } ActivitiesAdapter.Dispose(); }
private void SavePriceChanges() { CustomerAdapter = new customersTableAdapter(); customersDataTable customerDT = CustomerAdapter.GetCustomerDataByID(CustomerID); customersRow cRow = (customersRow)customerDT.Rows[0]; if (!string.IsNullOrWhiteSpace(txtNewPrice.Text)) { float.TryParse(txtNewPrice.Text, out _price); cRow.stdHourlyPrice = _price; } if (!string.IsNullOrWhiteSpace(txtNewPrice.Text)) { float.TryParse(txtNewOvertime1.Text, out _overtime1); cRow.stdOvertime1 = _overtime1; } if (!string.IsNullOrWhiteSpace(txtNewPrice.Text)) { float.TryParse(txtNewOvertime2.Text, out _overtime2); cRow.stdOvertime2 = _overtime2; } CustomerAdapter.Update(customerDT); CustomerAdapter.Dispose(); ActivitiesAdapter = new activitiesTableAdapter(); activitiesDataTable ActivitiesTable; activitiesRow row; foreach (TreeNode Parent in treeViewHourlyRate.Nodes) { if (Parent.Checked == true) { ActivitiesTable = ActivitiesAdapter.GetActivityPriceDataByID((int)Parent.Tag); row = (activitiesRow)ActivitiesTable.Rows[0]; if (!string.IsNullOrWhiteSpace(txtNewPrice.Text)) { float.TryParse(txtNewPrice.Text, out _price); row.price = _price; } if (!string.IsNullOrWhiteSpace(txtNewOvertime1.Text)) { float.TryParse(txtNewOvertime1.Text, out _overtime1); row.overtime1 = _overtime1; } if (!string.IsNullOrWhiteSpace(txtNewOvertime2.Text)) { float.TryParse(txtNewOvertime2.Text, out _overtime2); row.overtime2 = _overtime2; } ActivitiesAdapter.Update(ActivitiesTable); ActivitiesAdapter.Dispose(); } foreach (TreeNode child in Parent.Nodes) { if (child.Checked == true) { ActivitiesTable = ActivitiesAdapter.GetActivityPriceDataByID((int)child.Tag); row = (activitiesRow)ActivitiesTable.Rows[0]; if (!string.IsNullOrWhiteSpace(txtNewPrice.Text)) { float.TryParse(txtNewPrice.Text, out _price); row.price = _price; } if (!string.IsNullOrWhiteSpace(txtNewOvertime1.Text)) { float.TryParse(txtNewOvertime1.Text, out _overtime1); row.overtime1 = _overtime1; } if (!string.IsNullOrWhiteSpace(txtNewOvertime2.Text)) { float.TryParse(txtNewOvertime2.Text, out _overtime2); row.overtime2 = _overtime2; } ActivitiesAdapter.Update(ActivitiesTable); ActivitiesAdapter.Dispose(); } } } }
private void GetCustomerProjectData() { try { ActivitiesAdapter = new activitiesTableAdapter(); activitiesDataTable ActivitiesTable; if (chkProjectActive.Checked) { ActivitiesTable = ActivitiesAdapter.GetAllProjectsOnCustomerID(CustomerID); } else { ActivitiesTable = ActivitiesAdapter.GetAllActiveProjectsOnCustomerID(CustomerID); } ActivitiesAdapter.Dispose(); foreach (activitiesRow Proj in ActivitiesTable.Rows) { if (Proj.parentID == 0) { Activities = new TreeNode(); Activities.Text = "(" + Proj.price + ") " + Proj.description; Activities.Tag = Proj.ID; treeViewHourlyRate.Nodes.Add(Activities); if ((Proj.status % 2) == 0) { Activities.ImageIndex = 3; Activities.SelectedImageIndex = 3; } else if (Proj.type.Equals(project)) { Activities.ImageIndex = 0; Activities.SelectedImageIndex = 0; } else if (Proj.type.Equals(uppdrag)) { Activities.ImageIndex = 1; Activities.SelectedImageIndex = 1; } } } int index = 0; foreach (TreeNode tn in treeViewHourlyRate.Nodes) { foreach (activitiesRow act in ActivitiesTable.Rows) { if (act.parentID == (int)tn.Tag) { TreeNode activity = new TreeNode(); activity.Text = "(" + act.price + ") " + act.description; activity.Tag = act.ID; treeViewHourlyRate.Nodes[index].Nodes.Add(activity); if ((act.status % 2) == 0) { activity.ImageIndex = 4; activity.SelectedImageIndex = 4; } else { activity.ImageIndex = 2; activity.SelectedImageIndex = 2; } } } index++; } } catch { } ActivitiesAdapter.Dispose(); }