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