public void HandleCommand(ReportCommand command, object[] args)
{
// open file dialogue
var dialog = new OpenFileDialog
{
Title = COpenDialogFileFormTitle,
DefaultExt = Cextension,
Filter = COpenDialogFileExtensionFilter,
InitialDirectory = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData), "AMEN CONSEIL\\Declaration\\Etats")
};
if (dialog.ShowDialog() != DialogResult.OK)
{
return;
}
if (string.IsNullOrEmpty(dialog.FileName))
{
return;
}
if (!File.Exists(dialog.FileName))
{
return;
}
// initialize the report file (XtraReport)
var xreport = XtraReport.FromFile(dialog.FileName, true);
xreport.SourceUrl = dialog.FileName;
var reportTypeName = xreport.Tag.ToString();
// load the report initializer (ITresorerieReport)
// set report data properties
var source = new DsVirement();
// set data adapter if the report is type of `ITresorerieReportView`
xreport.DataSource = source;
xreport.DataMember = "TEntete";
// open the report
_xrDesigner.OpenReport(xreport);
// set report designer properties [DataAdapter/Dataset]
foreach (var comp in xreport.Container.Components.OfType <SqlDataAdapter>())
{
xreport.Container.Remove(comp);
}
var pd = TypeDescriptor.GetProperties(xreport.DataSource)[NameProperty];
pd.SetValue(xreport.DataSource, ((DataSet)xreport.DataSource).DataSetName);
foreach (var comp in xreport.Container.Components.OfType <SqlDataAdapter>())
{
pd = TypeDescriptor.GetProperties(comp)[NameProperty];
pd.SetValue(comp, DataAdapterName);
}
}
public System.Data.DataSet GetDataSet(SocieteBanque banque, VirementEntete entete, List <VirementLigne> lignes)
{
if (entete == null)
{
throw new ArgumentNullException(nameof(entete));
}
var dataSet = new DsVirement();
// ajout de la ligne societe
var tableSociete = dataSet.TSociete;
tableSociete.AddTSocieteRow(
_societe.Id,
int.Parse(_societe.MatriculFiscal),
_societe.MatriculCle,
_societe.MatriculCategorie,
_societe.MatriculEtablissement,
_exercice.Annee,
_societe.RaisonSocial,
_societe.Activite,
_societe.Ville,
_societe.Adresse,
0,
int.Parse(_societe.CodePostal));
var tableEntete = dataSet.TEntete;
var row = tableEntete.AddTEnteteRow(entete.Id,
entete.DateEcheance,
entete.DateCreation,
entete.ReferenceEnvoi,
entete.MotifOperation,
entete.Total,
entete.NombreTotal,
entete.Rib,
banque.Agence.ToUpper(),
banque.Adresse
);
foreach (var ligne in lignes)
{
var tableLigne = dataSet.TLignes;
tableLigne.AddTLignesRow(ligne.Id,
row,
ligne.Nom,
ligne.Prenom,
ligne.Rib,
ligne.NomBanque,
ligne.NetAPaye
);
}
return(dataSet);
}
