private void btImport_Click(object sender, EventArgs e)
{
var model = new Model.F6004(new F6004());
var z = new ImportForms.F6004ImportForm(model);
if (z.ShowDialog(this) == DialogResult.OK)
{
var f6004 = this.F6004BindingSource.Current as Model.F6004;
if (f6004 == null)
{
return;
}
foreach (var currentF6004Ligne in model.Lignes)
{
if (currentF6004Ligne != null && !currentF6004Ligne.Calculable)
{
var l = f6004.Lignes.Single(x => x.CodeN == currentF6004Ligne.CodeN);
l.ValeurN = currentF6004Ligne.ValeurN;
l = f6004.Lignes.Single(x => x.CodeN1 == currentF6004Ligne.CodeN1);
l.ValeurN1 = currentF6004Ligne.ValeurN1;
}
}
this.F6004BindingSource.ResetCurrentItem();
}
}
public F6004ImportForm(Model.F6004 currentF6004)
{
InitializeComponent();
CurrentF6004 = currentF6004;
_fileName = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), Application.ProductName, $"ModelImport_{CurrentF6004.GetType().Name}.xml");
this.f6004BindingSource.DataSource = CurrentF6004;
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 => Core.Helpers.Helper.IsNumericType(x.Type) && x.Selected).Select(x => x.Name)
.ToList());
this.ValNetcomboBoxEdit.EditValue = excelDataSource1.Schema
.Where(x => Core.Helpers.Helper.IsNumericType(x.Type) && 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 => Core.Helpers.Helper.IsNumericType(x.Type) && x.Selected).Select(x => x.Name)
.ToList());
this.ValN_1comboBoxEdit.EditValue = excelDataSource1.Schema
.Where(x => Core.Helpers.Helper.IsNumericType(x.Type) && x.Selected).Select(x => x.Name)
.FirstOrDefault(x => x.Trim() == col4);
}
catch
{
// ignored
}
}
this.buttonEdit1.EditValue = excelDataSource1.FileName;
layoutControlGroup3.Visibility = LayoutVisibility.Never;
}