public Form1() { InitializeComponent(); Proxies.EmployeesQueryProxyStub q = new Proxies.EmployeesQueryProxyStub(); q.Select(q.EmployeeID, q.FirstName, q.LastName, q.HireDate, q.BirthDate, (q.LastName + ", " + q.FirstName).As("Fullname")); coll = svc.Employees_QueryForCollection(q); this.dataGrid.DataSource = coll.Collection; }
private void buttonDelete_Click(object sender, EventArgs e) { DataGridViewSelectedRowCollection selectedRows = dataGrid.SelectedRows; foreach (DataGridViewRow row in selectedRows) { EmployeesProxyStub emp = row.DataBoundItem as EmployeesProxyStub; emp.MarkAsDeleted(); } coll = svc.Employees_SaveCollection(coll); this.dataGrid.DataSource = coll.Collection; }
void Employees_QueryForCollectionCompleted(object sender, Employees_QueryForCollectionCompletedEventArgs e) { WorkingBar.Value = 100; Timer.Stop(); if (e.Result != null) { employees = e.Result; EmployeesDataGrid.ItemsSource = employees.Collection; } else { EmployeesDataGrid.ItemsSource = null; } }
void Employees_SaveCollectionCompleted(object sender, Employees_SaveCollectionCompletedEventArgs e) { try { WorkingBar.Value = 100; Timer.Stop(); RecordsAdded = 0; employees = e.Result; EmployeesDataGrid.ItemsSource = employees.Collection; } catch (Exception exc) { Console.WriteLine(exc.StackTrace); } }
private void AddButton_Click(object sender, RoutedEventArgs e) { if (employees == null) { employees = new EmployeesCollectionProxyStub(); EmployeesDataGrid.ItemsSource = employees.Collection; } if (RecordsAdded++ < 5) { EmployeesProxyStub newEmp = new EmployeesProxyStub(); newEmp.FirstName = "Scott"; newEmp.LastName = "Schecter"; employees.Collection.Add(newEmp); } }
private void buttonQuery_Click(object sender, EventArgs e) { Proxies.EmployeesQueryProxyStub q = new Proxies.EmployeesQueryProxyStub("emp"); q.Select(q.EmployeeID, q.FirstName, q.LastName, q.HireDate, q.BirthDate, (q.LastName + ", " + q.FirstName).As("Fullname")); q.Where(q.LastName.Like("%" + txtLastName.Text + "%")); q.OrderBy(q.LastName.Ascending); coll = svc.Employees_QueryForCollection(Proxies.EmployeesQueryProxyStub.SerializeHelper.ToXml(q)); if (coll == null) { coll = new EmployeesCollectionProxyStub(); } this.dataGrid.DataSource = coll.Collection; }
private void ClearButton_Click(object sender, RoutedEventArgs e) { SearchTextBox.Text = ""; employees = null; EmployeesDataGrid.ItemsSource = null; }
private void buttonSave_Click(object sender, EventArgs e) { coll = svc.Employees_SaveCollection(coll); this.dataGrid.DataSource = coll.Collection; }