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