public void Delete(VirementEntete societeBanque)
{
using (var con = new SqlConnection(ConnectionString))
{
con.Execute(QueryDelete, new { No = societeBanque.Id });
}
}
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);
}
private DeclarationView ToView(VirementEntete declaration)
{
return new DeclarationView
{
ExerciceId = declaration.ExerciceId,
Id = declaration.Id,
Banque = declaration.Banque,
Rib = declaration.Rib,
Exercice = declaration.Exercice,
Cloturer = declaration.Cloturer,
Archiver = declaration.Archiver,
MotifOperation = declaration.MotifOperation,
ReferenceEnvoi = declaration.ReferenceEnvoi,
Total = declaration.Total,
SocieteId = declaration.SocieteId,
DateCreation = declaration.DateCreation,
NombreTotal = declaration.NombreTotal,
DateEcheance = declaration.DateEcheance,
BanqueId = declaration.BanqueId,
RaisonSocial = _service.Societe.RaisonSocial
};
}
public int Create(VirementEntete entete)
{
using (var con = new SqlConnection(ConnectionString))
{
return(con.Query <int>(QueryInsert, new
{
entete.Rib,
entete.Archiver,
entete.Banque,
entete.BanqueId,
entete.Cloturer,
entete.DateCreation,
entete.DateEcheance,
entete.Exercice,
entete.ExerciceId,
MotifOperation = entete.MotifOperation ?? string.Empty,
entete.NombreTotal,
entete.Total,
ReferenceEnvoi = entete.ReferenceEnvoi ?? string.Empty,
entete.SocieteId,
}).SingleOrDefault());
}
}
public void Update(VirementEntete entete)
{
using (var con = new SqlConnection(ConnectionString))
{
con.Execute(QueryUpdate, new
{
entete.Id,
entete.Rib,
entete.Archiver,
entete.Banque,
entete.BanqueId,
entete.Cloturer,
entete.DateCreation,
entete.DateEcheance,
entete.Exercice,
entete.ExerciceId,
MotifOperation = entete.MotifOperation ?? string.Empty,
entete.NombreTotal,
entete.Total,
ReferenceEnvoi = entete.ReferenceEnvoi ?? string.Empty,
entete.SocieteId,
});
}
}