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