private void sync_VatList()
{
DataTable dt = exeDT("SELECT * FROM IVA");
foreach (DataRow row in dt.Rows)
{
app_vat_group_details app_vat_group_details = new app_vat_group_details();
app_vat vat = new app_vat();
vat.name = (string)row["DESIVA"];
vat.id_company = id_company;
vat.coefficient = (decimal)row["COHEFICIENTE"] - 1;
dbContext.app_vat.Add(vat);
dbContext.SaveChanges();
app_vat_group vat_group = new app_vat_group();
vat_group.name = (string)row["DESIVA"];
vat_group.id_company = id_company;
dbContext.app_vat_group.Add(vat_group);
dbContext.SaveChanges();
app_vat_group_details.app_vat = dbContext.app_vat.Where(x => x.name == vat.name && x.id_company == id_company).FirstOrDefault();
app_vat_group_details.app_vat_group = dbContext.app_vat_group.Where(x => x.name == vat_group.name && x.id_company == id_company).FirstOrDefault();
dbContext.app_vat_group_details.Add(app_vat_group_details);
}
dt.Clear();
dbContext.SaveChanges();
}
private void btnNew_Click(object sender, RoutedEventArgs e)
{
crud_modal.Visibility = System.Windows.Visibility.Visible;
cntrl.vat objVat = new cntrl.vat();
app_vat app_vat = new app_vat();
entity.db.app_vat.Add(app_vat);
app_vatViewSource.View.MoveCurrentToLast();
objVat.app_vatViewSource = app_vatViewSource;
objVat.entity = entity;
crud_modal.Children.Add(objVat);
}
public accounting_chart find_Chart(AccountingJournalDB context, app_vat vat)
{
if (vat != null)
{
if (context.accounting_chart.Where(i => i.id_vat == vat.id_vat && i.chart_type == accounting_chart.ChartType.Assets).FirstOrDefault() != null)
{
return(context.accounting_chart.Where(i => i.id_vat == vat.id_vat).FirstOrDefault());
}
else if (context.accounting_chart.Where(i => i.chartsub_type == accounting_chart.ChartSubType.VAT && i.chart_type == accounting_chart.ChartType.Assets && i.is_generic == true).FirstOrDefault() != null)
{
return(context.accounting_chart.Where(i => i.chartsub_type == accounting_chart.ChartSubType.VAT && i.chart_type == accounting_chart.ChartType.Assets && i.is_generic == true).FirstOrDefault());
}
}
return(null);
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
try
{
MessageBoxResult res = MessageBox.Show("Are you sure want to Delete?", "Cognitivo", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (res == MessageBoxResult.Yes)
{
app_vat app_vat = app_vatViewSource.View.CurrentItem as app_vat;
app_vat.is_active = false;
btnSave_Click(sender, e);
}
}
catch (Exception)
{
//throw ex;
}
}
