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