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); DataGridAccountTypes.ItemsSource = Commons.Db.AccountTypes.Where(x => x.Id == id && x.Year == Commons.CurrentYear).Take(Commons.TopRow).ToList(); } else { DataGridAccountTypes.ItemsSource = Commons.Db.AccountTypes.Where(x => x.Name.Contains(LastTextBoxSearch) && x.Year == Commons.CurrentYear).Take(Commons.TopRow).ToList(); } } if (DataGridAccountTypes.Items != null && DataGridAccountTypes.Items.Count != 0) { DataGridAccountTypes.SelectedItem = DataGridAccountTypes.Items[0]; DataGridAccountTypes.ScrollIntoView(DataGridAccountTypes.SelectedItem); DataGridAccountTypes.Focus(); } }
private void ButtonSave_Click(object sender, RoutedEventArgs e) { ControlsValidate?Vd = Commons.ValidateData(FirstControlNewAccountType, ControlsArray); MessageDialog Msg = null; if (Vd != null) { Msg = new MessageDialog(Messages.SaveMessageTitleAccountTypes, Vd.Value.Message, MessageDialogButtons.Ok, MessageDialogType.Warning, GridHeaderAccountTypes.Background); Msg.Owner = Window.GetWindow(this); Msg.ShowDialog(); Vd.Value.Control.Focus(); } else { DomainClasses.AccountTypesTb MyAccountType = null; if (AccountTypeId != -1) { MyAccountType = Commons.Db.AccountTypes.Find(AccountTypeId, Commons.CurrentYear); } if (MyAccountType == null) { Msg = new MessageDialog(Messages.SaveMessageTitleAccountTypes, Messages.SaveMessageAccountTypes, MessageDialogButtons.YesNo, MessageDialogType.Warning, GridHeaderAccountTypes.Background); Msg.Owner = Window.GetWindow(this); if (Msg.ShowDialog() == true) { try { int?MaxId = Commons.Db.AccountTypes.Where(x => x.Year == Commons.CurrentYear).Max(x => (int?)x.Id); if (MaxId == null) { MaxId = 0; } MaxId++; Commons.Db.AccountTypes.Add(new DomainClasses.AccountTypesTb { Id = Convert.ToInt32(MaxId), Name = TextBoxName.Text.Trim(), Year = Commons.CurrentYear, Formules = TextBoxFormules.Text.Trim(), Description = TextBoxComments.Text.Trim() }); Commons.Db.SaveChanges(); Commons.SetFromEdited("AccountTypes"); SearchAgain = true; DataGridAccountTypes.Items.Refresh(); DataGridAccountTypes.UpdateLayout(); Msg = new MessageDialog(Messages.SaveMessageTitleAccountTypes, Messages.SaveMessageSuccessAccountTypes, MessageDialogButtons.Ok, MessageDialogType.Information, GridHeaderAccountTypes.Background); Msg.Owner = Window.GetWindow(this); Msg.ShowDialog(); ButtonNew_Click(null, null); } catch { Msg = new MessageDialog(Messages.SaveMessageTitleAccountTypes, Messages.ErrorSendingDataToDatabase, MessageDialogButtons.Ok, MessageDialogType.Error, GridHeaderAccountTypes.Background); Msg.Owner = Window.GetWindow(this); Msg.ShowDialog(); } } } else { Msg = new MessageDialog(Messages.EditMessageTitleAccountTypes, Messages.EditMessageAccountTypes, MessageDialogButtons.YesNo, MessageDialogType.Warning, GridHeaderAccountTypes.Background); Msg.Owner = Window.GetWindow(this); if (Msg.ShowDialog() == true) { try { MyAccountType.Name = TextBoxName.Text.Trim(); MyAccountType.Formules = TextBoxFormules.Text.Trim(); MyAccountType.Description = TextBoxComments.Text.Trim(); Commons.Db.SaveChanges(); Commons.SetFromEdited("AccountTypes"); List <AccountTypesTb> Lc = (List <AccountTypesTb>)DataGridAccountTypes.ItemsSource; if (Lc != null) { AccountTypesTb Rc = Lc.Find(x => x.Id == MyAccountType.Id && x.Year == Commons.CurrentYear); if (Rc != null) { Rc.Description = MyAccountType.Description; Rc.Formules = MyAccountType.Formules; Rc.Name = MyAccountType.Name; Rc.RecordDate = MyAccountType.RecordDate; Rc.Year = MyAccountType.Year; } } DataGridAccountTypes.Items.Refresh(); DataGridAccountTypes.UpdateLayout(); SearchAgain = true; Msg = new MessageDialog(Messages.EditMessageTitleAccountTypes, Messages.EditMessageSuccessAccountTypes, MessageDialogButtons.Ok, MessageDialogType.Information, GridHeaderAccountTypes.Background); Msg.Owner = Window.GetWindow(this); Msg.ShowDialog(); ButtonNew_Click(null, null); } catch { Msg = new MessageDialog(Messages.EditMessageTitleAccountTypes, Messages.ErrorSendingDataToDatabase, MessageDialogButtons.Ok, MessageDialogType.Error, GridHeaderAccountTypes.Background); Msg.Owner = Window.GetWindow(this); Msg.ShowDialog(); } } } } }