// Customer is added private void viewModel_Adding(object sender, ViewModelEventArgs e) { DataGridCustomers.ScrollIntoView(DataGridCustomers.SelectedItem, null); DataGridCustomers.IsEnabled = false; DataFormCustomer.BeginEdit(); }
private void DoSearch() { if ((LastTextBoxSearch != TextBoxSearch.Text.Trim() || SearchAgain == true) && TextBoxSearch.Text.Trim() != "") { SearchAgain = false; LastTextBoxSearch = TextBoxSearch.Text.Trim(); if (RadioSearchByCode.IsChecked == true) { long id = Convert.ToInt64(LastTextBoxSearch); DataGridCustomers.ItemsSource = Commons.Db.Customers.Where(x => (x.Id == id || x.PostalCode == LastTextBoxSearch || x.MeliCode == LastTextBoxSearch) && x.Year == Commons.CurrentYear).Take(Commons.TopRow).ToList(); } else { LastTextBoxSearch = LastTextBoxSearch.Replace(' ', '%'); string Query = "select Top " + Commons.TopRow.ToString() + " * from Customerstbs where (Search like N'%" + LastTextBoxSearch + "%') and Year =" + Commons.CurrentYear.ToString(); DataGridCustomers.ItemsSource = Commons.Db.Customers.SqlQuery(Query).Take(Commons.TopRow).ToList(); } } if (DataGridCustomers.Items != null && DataGridCustomers.Items.Count != 0) { DataGridCustomers.SelectedItem = DataGridCustomers.Items[0]; DataGridCustomers.ScrollIntoView(DataGridCustomers.SelectedItem); DataGridCustomers.Focus(); } }