private void btImport_Click(object sender, EventArgs e)
{
var model = new Model.F6005(new Core.Models.Liass.F6005());
var z = new ImportForms.F6005ImportForm(model);
if (z.ShowDialog(this) == DialogResult.OK)
{
var f6005 = this.F6005BindingSource.Current as Model.F6005;
if (f6005 == null)
{
return;
}
foreach (var currentF6005 in model.Lignes)
{
if (currentF6005 != null && !currentF6005.Calculable)
{
var l = f6005.Lignes.Single(x => x.CodeN == currentF6005.CodeN);
l.ValeurN = currentF6005.ValeurN;
l = f6005.Lignes.Single(x => x.CodeN1 == currentF6005.CodeN1);
l.ValeurN1 = currentF6005.ValeurN1;
}
}
this.F6005BindingSource.ResetCurrentItem();
}
}
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;
}