public F6005ImportForm(Model.F6005 currentF6005)
{
InitializeComponent();
CurrentF6005 = currentF6005;
_fileName = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), Application.ProductName, $"ModelImport_{CurrentF6005.GetType().Name}.xml");
this.f6005BindingSource.DataSource = CurrentF6005;
if (File.Exists(_fileName))
{
try
{
this.excelDataSource1.LoadFromXml(XElement.Load(_fileName));
excelDataSource1.Fill();
var col1 = "Code Rubrique (Net)";
var col2 = "Code Rubrique (N-1)";
//var col1 = "Code Rubrique (Net)";
var col3 = "Net";
//var col1 = "Libelle";
// var col4 = "Brut";
// var col5 = "Prov / Amort";
var col4 = "Net N-1";
//
this.CodeRubNetcomboBoxEdit.Properties.Items.Clear();
this.CodeRubNetcomboBoxEdit.Properties.Items.AddRange(excelDataSource1.Schema
.Where(x => x.Type == typeof(string) && x.Selected).Select(x => x.Name).ToList());
this.CodeRubNetcomboBoxEdit.EditValue = excelDataSource1.Schema
.Where(x => x.Type == typeof(string) && x.Selected).Select(x => x.Name)
.FirstOrDefault(x => x.Trim() == col1);
//
this.CodeRubN_1comboBoxEdit.Properties.Items.Clear();
this.CodeRubN_1comboBoxEdit.Properties.Items.AddRange(excelDataSource1.Schema
.Where(x => x.Type == typeof(string) && x.Selected).Select(x => x.Name).ToList());
this.CodeRubN_1comboBoxEdit.EditValue = excelDataSource1.Schema
.Where(x => x.Type == typeof(string) && x.Selected).Select(x => x.Name)
.FirstOrDefault(x => x.Trim() == col2);
//
this.ValNetcomboBoxEdit.Properties.Items.Clear();
this.ValNetcomboBoxEdit.Properties.Items.AddRange(excelDataSource1.Schema
.Where(x => x.Selected).Select(x => x.Name)
.ToList());
this.ValNetcomboBoxEdit.EditValue = excelDataSource1.Schema
.Where(x => x.Selected).Select(x => x.Name)
.FirstOrDefault(x => x.Trim() == col3);
//
this.ValN_1comboBoxEdit.Properties.Items.Clear();
this.ValN_1comboBoxEdit.Properties.Items.AddRange(excelDataSource1.Schema
.Where(x => x.Selected).Select(x => x.Name)
.ToList());
this.ValN_1comboBoxEdit.EditValue = excelDataSource1.Schema
.Where(x => x.Selected).Select(x => x.Name)
.FirstOrDefault(x => x.Trim() == col4);
}
catch
{
// ignored
}
}
this.buttonEdit1.EditValue = excelDataSource1.FileName;
layoutControlGroup3.Visibility = LayoutVisibility.Never;
}
