public EmployeesCollectionProxyStub Employees_SaveCollection(EmployeesCollectionProxyStub collection)
{
if (collection != null)
{
EmployeesCollection c = collection.GetCollection();
c.Save();
return(c);
}
return(null);
}
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;
}
public Form1()
{
InitializeComponent();
this.dataGrid.AutoGenerateColumns = true;
EmployeesQuery q = new EmployeesQuery();
q.Select(q.EmployeeID, q.FirstName, q.LastName, q.HireDate, q.BirthDate, (q.LastName + ", " + q.FirstName).As("Fullname"));
EmployeesCollectionProxyStub proxyColl = svc.Employees_QueryForCollection(EmployeesQuery.SerializeHelper.ToXml(q));
_bindingSource.DataSource = coll = proxyColl.GetCollection();
}
private void buttonSave_Click(object sender, EventArgs e)
{
try
{
if (coll.IsDirty)
{
EmployeesCollectionProxyStub proxyColl = new EmployeesCollectionProxyStub(coll);
proxyColl = svc.Employees_SaveCollection(proxyColl);
_bindingSource.DataSource = coll = proxyColl.GetCollection();
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
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 buttonQuery_Click(object sender, EventArgs e)
{
EmployeesQuery q = new EmployeesQuery("emp");
q.Where(q.LastName.Like("%" + txtLastName.Text + "%"));
q.OrderBy(q.LastName.Ascending);
EmployeesCollectionProxyStub proxyColl = svc.Employees_QueryForCollection(EmployeesQuery.SerializeHelper.ToXml(q));
if (proxyColl != null)
{
_bindingSource.DataSource = coll = proxyColl.GetCollection();
}
else
{
_bindingSource.DataSource = coll = new BusinessObjects.EmployeesCollection();
}
}
public EmployeesCollectionProxyStub Employees_SaveCollection(EmployeesCollectionProxyStub collection)
{
if (collection != null)
{
EmployeesCollection c = collection.GetCollection();
c.Save();
return c;
}
return null;
}
private void buttonSave_Click(object sender, EventArgs e)
{
coll = svc.Employees_SaveCollection(coll);
this.dataGrid.DataSource = coll.Collection;
}
private void buttonSave_Click(object sender, EventArgs e)
{
try
{
if (coll.IsDirty)
{
EmployeesCollectionProxyStub proxyColl = new EmployeesCollectionProxyStub(coll);
proxyColl = svc.Employees_SaveCollection(proxyColl);
_bindingSource.DataSource = coll = proxyColl.GetCollection();
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
