private void ShowTree()
{
var ds = new CompanyDataSet();
var cda = new linqToDataSet.CompanyDataSetTableAdapters.CompanyTableAdapter();
cda.Fill(ds.Company);
var tvCompanyItem = new TreeViewItem
{
Header = ds.Company.FirstOrDefault().Name
};
this.treeCompany.Items.Add(tvCompanyItem);
var dda = new linqToDataSet.CompanyDataSetTableAdapters.DepartmentTableAdapter();
dda.Fill(ds.Department);
var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter();
eda.Fill(ds.Employee);
var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter();
pda.Fill(ds.Person);
foreach (var dept in ds.Department.Where(d=>d.Isparent_idNull()))
{
var tv = new TreeViewItem
{
Header = dept.Name,
Tag = new DepartmentDetailsPage(dept.department_id)
};
tvCompanyItem.Items.Add(tv);
GetSubTree(ref tv, dept);
}
}
private void GetSubTree(ref TreeViewItem iSubTree, CompanyDataSet.DepartmentRow department)
{
var employees = department.GetEmployeeRows();
foreach (var employee in employees)
{
var ep = new EmployeeDetailsPage(employee.employee_id);
ep.OnEmployeeChanged += (s, e) => ((TreeViewItem) treeCompany.SelectedItem).Header = e.Name;
var subItem = new TreeViewItem
{
Header = employee.PersonRow.Name,
Tag = ep
};
iSubTree.Items.Add(subItem);
}
foreach (var subDept in department.GetDepartmentRows())
{
var subItem = new TreeViewItem
{
Header = subDept.Name,
Tag = new DepartmentDetailsPage(subDept.department_id)
};
iSubTree.Items.Add(subItem);
GetSubTree(ref subItem, subDept);
}
}
private void PageLoaded(object sender, RoutedEventArgs e)
{
var ds = new CompanyDataSet();
var cda = new linqToDataSet.CompanyDataSetTableAdapters.CompanyTableAdapter();
cda.Fill(ds.Company);
CompanyName = ds.Company.First().Name;
Total = Features.Total();
WindowsTitle = CompanyName;
}
private void PageLoaded(object sender, RoutedEventArgs e)
{
var ds = new CompanyDataSet();
var cda = new linqToDataSet.CompanyDataSetTableAdapters.CompanyTableAdapter();
cda.Fill(ds.Company);
CompanyName = ds.Company.First().Name;
Total = Features.Total();
WindowsTitle = CompanyName;
}
private static void CutSubDept(CompanyDataSet.DepartmentRow parent)
{
var subDepts = Ds.Department.Where(d => (d.Isparent_idNull() == false) && (d.parent_id == parent.department_id));
foreach (var subDept in subDepts)
{
foreach (var employeeRow in subDept.GetEmployeeRows())
{
employeeRow.Salary /= 2;
}
CutSubDept(subDept);
}
}
private void PageLoaded(object sender, RoutedEventArgs e)
{
var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter();
var ds = new CompanyDataSet();
eda.FillBy(ds.Employee, _employeeId);
var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter();
pda.FillBy(ds.Person, ds.Employee.Single().person_id);
var emp = ds.Employee.Single();
var person = emp.PersonRow;
WindowsTitle = person.Name;
DataContext = new { Person = person, Employee = emp };
}
private void PageLoaded(object sender, RoutedEventArgs e)
{
var dda = new linqToDataSet.CompanyDataSetTableAdapters.DepartmentTableAdapter();
var ds = new CompanyDataSet();
dda.FillBy(ds.Department, _departmentId);
var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter();
eda.Fill(ds.Employee);
var manager = ds.Employee.Where(emp => (emp.department_id == _departmentId) && emp.IsManager).Single();
var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter();
pda.FillBy(ds.Person, manager.person_id);
var dept = ds.Department.Where(d => d.department_id == _departmentId).Single();
WindowsTitle = dept.Name;
Total = Features.SubTotalForDept(_departmentId);
DataContext = new { Name = manager.PersonRow.Name };
}
public CompanyDataSet GetCompanies()
{
//Returns a list of companies
CompanyDataSet companies = new CompanyDataSet();
CRMServiceClient client = null;
try {
client = new CRMServiceClient();
DataSet ds = client.GetCompanies();
client.Close();
if (ds.Tables["CompanyTable"] != null && ds.Tables["CompanyTable"].Rows.Count > 0)
{
companies.Merge(ds.Tables["CompanyTable"].Select("", "CompanyName ASC"));
}
}
catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); }
catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); }
catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); }
return(companies);
}
private void ShowTree()
{
var ds = new CompanyDataSet();
var cda = new linqToDataSet.CompanyDataSetTableAdapters.CompanyTableAdapter();
cda.Fill(ds.Company);
var tvCompanyItem = new TreeViewItem
{
Header = ds.Company.FirstOrDefault().Name
};
this.treeCompany.Items.Add(tvCompanyItem);
var dda = new linqToDataSet.CompanyDataSetTableAdapters.DepartmentTableAdapter();
dda.Fill(ds.Department);
var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter();
eda.Fill(ds.Employee);
var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter();
pda.Fill(ds.Person);
foreach (var dept in ds.Department.Where(d => d.Isparent_idNull()))
{
var tv = new TreeViewItem
{
Header = dept.Name,
Tag = new DepartmentDetailsPage(dept.department_id)
};
tvCompanyItem.Items.Add(tv);
GetSubTree(ref tv, dept);
}
}
private void PageLoaded(object sender, RoutedEventArgs e)
{
var dda = new linqToDataSet.CompanyDataSetTableAdapters.DepartmentTableAdapter();
var ds = new CompanyDataSet();
dda.FillBy(ds.Department, _departmentId);
var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter();
eda.Fill(ds.Employee);
var manager = ds.Employee.Where(emp => (emp.department_id == _departmentId) && emp.IsManager).Single();
var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter();
pda.FillBy(ds.Person, manager.person_id);
var dept = ds.Department.Where(d => d.department_id == _departmentId).Single();
WindowsTitle = dept.Name;
Total = Features.SubTotalForDept(_departmentId);
DataContext = new { Name = manager.PersonRow.Name };
}
public CompanyDataSet GetCompanies2()
{
//Returns a list of companies without the clientnumber hyphen (i.e. companyname - 001)
CompanyDataSet companies = new CompanyDataSet();
CRMServiceClient client = null;
try {
client = new CRMServiceClient();
DataSet ds = client.GetCompanies();
client.Close();
if (ds.Tables["CompanyTable"] != null && ds.Tables["CompanyTable"].Rows.Count > 0)
{
companies.Merge(ds.Tables["CompanyTable"].Select("", "CompanyName ASC"));
for (int i = 0; i < companies.CompanyTable.Count; i++)
{
companies.CompanyTable[i].CompanyName = companies.CompanyTable[i].CompanyName.Split(new string[] { "-" }, StringSplitOptions.RemoveEmptyEntries)[0].Trim();
}
}
}
catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); }
catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); }
catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); }
return(companies);
}
private void PageLoaded(object sender, RoutedEventArgs e)
{
var eda = new linqToDataSet.CompanyDataSetTableAdapters.EmployeeTableAdapter();
var ds = new CompanyDataSet();
eda.FillBy(ds.Employee, _employeeId);
var pda = new linqToDataSet.CompanyDataSetTableAdapters.PersonTableAdapter();
pda.FillBy(ds.Person, ds.Employee.Single().person_id);
var emp = ds.Employee.Single();
var person = emp.PersonRow;
WindowsTitle = person.Name;
DataContext = new {Person = person, Employee = emp};
}
private static decimal GetSubDeptsTotal(CompanyDataSet.DepartmentRow parent, decimal total)
{
var subDepts = Ds.Department.Where(d => (d.Isparent_idNull() == false) && (d.parent_id == parent.department_id));
foreach (var dept in subDepts)
{
total += dept.GetEmployeeRows().Sum(er => er.Salary);
total += GetSubDeptsTotal(dept, total);
}
return total;
}
