private void btImport_Click(object sender, EventArgs e)
{
var model = new Model.F6303(new F6303());
var z = new ImportForms.F6303ImportForm(model);
if (z.ShowDialog(this) == DialogResult.OK)
{
var f6303 = this.f6303BindingSource.Current as Model.F6303;
if (f6303 == null)
{
return;
}
foreach (var currentF6303Ligne in model.Lignes)
{
if (currentF6303Ligne != null && !currentF6303Ligne.Calculable)
{
var l = f6303.Lignes.Single(x => x.CodeN == currentF6303Ligne.CodeN);
l.ValeurN = currentF6303Ligne.ValeurN;
l = f6303.Lignes.Single(x => x.CodeN1 == currentF6303Ligne.CodeN1);
l.ValeurN1 = currentF6303Ligne.ValeurN1;
}
}
this.f6303BindingSource.ResetCurrentItem();
}
}
public XtraFrmF6303(LiasseController controller)
{
_controller = controller;
InitializeComponent();
gridView1.CustomRowCellEdit += GridView1OnCustomRowCellEdit;
_CurrentF6303 = controller.CurrentF6303();
DBf6303BindingSource.DataSource = _CurrentF6303;
var Model = new Model.F6303(_CurrentF6303);
this.f6303BindingSource.DataSource = new Model.F6303(_CurrentF6303);
btEnregistrer.Click += BtEnregistrer_Click;
btExporter.Click += BtExporter_Click;
//this.gridView1.OptionsView.RowAutoHeight = true;
//colLibelle.AppearanceCell.TextOptions.WordWrap=WordWrap.Wrap;
saveFileDialog1.FileName = controller.GetXmlFileName(this.DBf6303BindingSource.Current);
}
public F6303ImportForm(Model.F6303 currentF6303)
{
InitializeComponent();
CurrentF6303 = currentF6303;
_fileName = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), Application.ProductName, $"ModelImport_{CurrentF6303.GetType().Name}.xml");
this.f6303BindingSource.DataSource = CurrentF6303;
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;
}