private void ButtonDelete_Click(object sender, RoutedEventArgs e)
{
MessageDialog Msg;
try
{
long id = Convert.ToInt64(((TextBlock)DataGridAccountTypes.Columns[0].GetCellContent(DataGridAccountTypes.SelectedItem)).Text);
AccountTypesTb RowDeleted = Commons.Db.AccountTypes.Find(id, Commons.CurrentYear);
if (RowDeleted != null)
{
var Sub = Commons.Db.Subscriptions.Local.Where(x => x.AccountTypeId == id);
if (Sub.Count <SubscriptionsTb>() == 0)
{
Msg = new MessageDialog(Messages.DeleteMessageTitleAccountTypes, Messages.DeleteMessageAccountTypes, MessageDialogButtons.YesNo, MessageDialogType.Warning, GridHeaderAccountTypes.Background);
Msg.Owner = Window.GetWindow(this);
if (Msg.ShowDialog() == true)
{
Commons.Db.AccountTypes.Remove(RowDeleted);
Commons.Db.SaveChanges();
Commons.SetFromEdited("AccountTypes");
List <AccountTypesTb> L = (List <AccountTypesTb>)DataGridAccountTypes.ItemsSource;
if (L != null)
{
L.Remove(RowDeleted);
}
SearchAgain = true;
DataGridAccountTypes.Items.Refresh();
Msg = new MessageDialog(Messages.DeleteMessageTitleAccountTypes, Messages.DeleteMessageSuccessAccountTypes, MessageDialogButtons.Ok, MessageDialogType.Information, GridHeaderAccountTypes.Background);
Msg.Owner = Window.GetWindow(this);
Msg.ShowDialog();
}
}
else
{
Msg = new MessageDialog(Messages.DeleteMessageTitleAccountTypes, Messages.DeleteAccountTypeImpossible, MessageDialogButtons.Ok, MessageDialogType.Warning, GridHeaderAccountTypes.Background);
Msg.Owner = Window.GetWindow(this);
Msg.ShowDialog();
}
}
}
catch
{
Msg = new MessageDialog(Messages.DeleteMessageTitleAccountTypes, Messages.ErrorSendingDataToDatabase, MessageDialogButtons.Ok, MessageDialogType.Error, GridHeaderAccountTypes.Background);
Msg.Owner = Window.GetWindow(this);
Msg.ShowDialog();
}
}
private void ButtonShowEdit_Click(object sender, RoutedEventArgs e)
{
MessageDialog Msg;
try
{
long id = Convert.ToInt64(((TextBlock)DataGridAccountTypes.Columns[0].GetCellContent(DataGridAccountTypes.SelectedItem)).Text);
AccountTypesTb RowEdited = Commons.Db.AccountTypes.Find(id, Commons.CurrentYear);
if (RowEdited != null)
{
AccountTypeId = id;
TextBoxName.Text = RowEdited.Name.Trim();
TextBoxFormules.Text = RowEdited.Formules.Trim();
TextBoxComments.Text = RowEdited.Description.Trim();
ButtonAccountType_Click(ButtonAccountType, null);
}
}
catch
{
Msg = new MessageDialog(Messages.EditMessageTitleAccountTypes, Messages.ErrorSendingDataToDatabase, MessageDialogButtons.Ok, MessageDialogType.Error, GridHeaderAccountTypes.Background);
Msg.Owner = Window.GetWindow(this);
Msg.ShowDialog();
}
}
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();
}
}
}
}
}
