public List <CsAdmRoles> GetAssocitedToMenuByMenuID(int menuId)
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spx_AdmRoles_GetAssocitedToMenuByMenuID";
cmd.Parameters.Clear();
cmd.Parameters.Add("@MenuID", SqlDbType.VarChar).Value = menuId;
DBBase.SetDBNullParametre(cmd.Parameters);
SqlDataReader reader = null;
List <CsAdmRoles> rows = new List <CsAdmRoles>();
try
{
reader = cmd.ExecuteReader();
Fill(reader, rows, 0, int.MaxValue);
reader.Close();
return(rows);
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Dispose();
}
}
//public bool Update(CsUtilisateur admUsers)
//{
// cn = new SqlConnection(ConnectionString);
// cmd = new SqlCommand();
// cmd.Connection = cn;
// //SqlCommand cmd = new SqlCommand("spx_AdmUsers_Update", this.ConnectionString);
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.CommandText = "spx_Adm_Uers_Update";
// //cmd.CommandText = "spx_AdmUsers_Update";
// cmd.Parameters.Clear();
// //cmd.Parameters.AddWithValue("@IdUser", admUsers.IdUser);
// cmd.Parameters.Add("@LoginName", SqlDbType.VarChar).Value = admUsers.LoginName;
// cmd.Parameters.Add("@DateCreation", SqlDbType.DateTime).Value = admUsers.DateCreation;
// cmd.Parameters.Add("@DateDerniereModification", SqlDbType.DateTime).Value = admUsers.DateDerniereModification;
// cmd.Parameters.Add("@DateDebutValidite", SqlDbType.DateTime).Value = admUsers.DateDebutValidite;
// cmd.Parameters.Add("@DateFinValidite", SqlDbType.DateTime).Value = admUsers.DateFinValidite;
// cmd.Parameters.Add("@IdStatusCompte", SqlDbType.VarChar).Value = admUsers.IdStatusCompte;
// cmd.Parameters.Add("@RoleID", SqlDbType.VarChar).Value = admUsers.RoleID;
// cmd.Parameters.Add("@DateDerniereModificationPassword", SqlDbType.DateTime).Value = admUsers.DateDerniereModificationPassword;
// cmd.Parameters.Add("@InitUserPassword", SqlDbType.VarChar).Value = admUsers.InitUserPassword;
// cmd.Parameters.Add("@NombreEchecsOuvertureSession", SqlDbType.Int).Value = admUsers.NombreEchecsOuvertureSession;
// cmd.Parameters.Add("@DateDerniereConnexion", SqlDbType.DateTime).Value = admUsers.DateDerniereConnexion;
// cmd.Parameters.Add("@DerniereConnexionReussie", SqlDbType.DateTime).Value = admUsers.DerniereConnexionReussie;
// cmd.Parameters.Add("@DateDernierVerrouillage", SqlDbType.DateTime).Value = admUsers.DateDernierVerrouillage;
// cmd.Parameters.Add("@Centre", SqlDbType.VarChar).Value = admUsers.Centre;
// cmd.Parameters.Add("@Matricule", SqlDbType.VarChar).Value = admUsers.Matricule;
// cmd.Parameters.Add("@DisplayName", SqlDbType.VarChar).Value = admUsers.DisplayName;
// cmd.Parameters.Add("@fonction", SqlDbType.VarChar).Value = admUsers.Fonction;
// cmd.Parameters.Add("@NumCaisse", SqlDbType.VarChar).Value = admUsers.NumCaisse;
// cmd.Parameters.Add("@branche", SqlDbType.VarChar).Value = admUsers.Branche;
// //cmd.Parameters.AddWithValue("@DisplayName", admUsers.DisplayName);
// // cmd.Parameters.AddWithValue("@Nom", admUsers.Nom);
// // cmd.Parameters.AddWithValue("@Prenoms", admUsers.Prenoms);
// // cmd.Parameters.AddWithValue("@Agent_ID", admUsers.Agent_ID);
// // cmd.Parameters.AddWithValue("@EstMutiSociete", admUsers.EstMutiSociete);
// /*Adaptation Galatee - Par OLA*/
// //cmd.Parameters.AddWithValue("@Centre", admUsers.Centre);
// //cmd.Parameters.AddWithValue("@Matricule", admUsers.Matricule);
// //cmd.Parameters.AddWithValue("@NomPrenoms", admUsers.DisplayName);
// //cmd.Parameters.AddWithValue("@fonction", admUsers.Fonction);
// //cmd.Parameters.AddWithValue("@NumCaisse", admUsers.NumCaisse);
// //cmd.Parameters.AddWithValue("@branche", admUsers.Branche);
// /*Fin - le 14/10/2009*/
// DBBase.SetDBNullParametre(cmd.Parameters);
// try
// {
// if (cn.State == ConnectionState.Closed)
// cn.Open();
// cmd.ExecuteNonQuery();
// return true;
// }
// catch(Exception ex)
// {
// string error= ex.Message;
// return false;
// }
// finally
// {
// if (cn.State == ConnectionState.Open)
// cn.Close(); // Fermeture de la connection
// cmd.Dispose();
// }
//}
//public void Insert(CsUtilisateur admUsers)
//{
// cn = new SqlConnection(ConnectionString);
// cmd = new SqlCommand();
// cmd.Connection = cn;
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.CommandText = "spx_AdmUsers_Insert";
// cmd.Parameters.Clear();
// //cmd.Parameters.AddWithValue("@IdUser", admUsers.IdUser);
// //cmd.Parameters.AddWithValue("@LoginName", admUsers.LoginName);
// //cmd.Parameters.AddWithValue("@DisplayName", admUsers.DisplayName);
// //cmd.Parameters.AddWithValue("@Nom", admUsers.Nom);
// //cmd.Parameters.AddWithValue("@Prenoms", admUsers.Prenoms);
// //cmd.Parameters.AddWithValue("@Agent_ID", admUsers.Agent_ID);
// cmd.Parameters.Add("@LoginName", SqlDbType.VarChar).Value = admUsers.LoginName;
// cmd.Parameters.Add("@DateCreation", SqlDbType.DateTime).Value = admUsers.DateCreation;
// cmd.Parameters.Add("@DateDerniereModification", SqlDbType.DateTime).Value = admUsers.DateDerniereModification;
// cmd.Parameters.Add("@DateDebutValidite", SqlDbType.DateTime).Value = admUsers.DateDebutValidite;
// cmd.Parameters.Add("@DateFinValidite", SqlDbType.DateTime).Value = admUsers.DateFinValidite;
// cmd.Parameters.Add("@IdStatusCompte", SqlDbType.TinyInt).Value =Convert.ToInt16(admUsers.IdStatusCompte);
// cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = admUsers.Password;
// //cmd.Parameters.Add("@RoleID", SqlDbType.VarChar).Value = admUsers.RoleID;
// cmd.Parameters.Add("@DateDerniereModificationPassword", SqlDbType.DateTime).Value = admUsers.DateDerniereModificationPassword;
// cmd.Parameters.Add("@InitUserPassword", SqlDbType.Bit).Value = admUsers.InitUserPassword==true ? 0:1;
// cmd.Parameters.Add("@NombreEchecsOuvertureSession", SqlDbType.TinyInt).Value = admUsers.NombreEchecsOuvertureSession;
// cmd.Parameters.Add("@DateDerniereConnexion", SqlDbType.DateTime).Value = admUsers.DateDerniereConnexion;
// cmd.Parameters.Add("@DerniereConnexionReussie", SqlDbType.Bit).Value = admUsers.DerniereConnexionReussie == true? 0:1;
// cmd.Parameters.Add("@DateDernierVerrouillage", SqlDbType.DateTime).Value = admUsers.DateDernierVerrouillage;
// cmd.Parameters.Add("@Centre", SqlDbType.VarChar).Value = admUsers.Centre;
// cmd.Parameters.Add("@Matricule", SqlDbType.VarChar).Value = admUsers.Matricule;
// cmd.Parameters.Add("@NomPrenoms", SqlDbType.VarChar).Value = admUsers.DisplayName;
// cmd.Parameters.Add("@fonction", SqlDbType.VarChar).Value = admUsers.Fonction;
// cmd.Parameters.Add("@NumCaisse", SqlDbType.VarChar).Value = admUsers.NumCaisse;
// cmd.Parameters.Add("@branche", SqlDbType.VarChar).Value = admUsers.Branche;
// cmd.Parameters.Add("@PerimetreAction", SqlDbType.SmallInt).Value =Convert.ToInt16(admUsers.PerimetreAction);
// /*Adaptation Galatee - Par OLA*/
// //cmd.Parameters.AddWithValue("@Centre", admUsers.Centre);
// //cmd.Parameters.AddWithValue("@Matricule", admUsers.Matricule);
// //cmd.Parameters.AddWithValue("@NomPrenoms", admUsers.DisplayName);
// //cmd.Parameters.AddWithValue("@fonction", admUsers.Fonction);
// //cmd.Parameters.AddWithValue("@NumCaisse", admUsers.NumCaisse);
// //cmd.Parameters.AddWithValue("@branche", admUsers.Branche);
// /*Fin - le 14/10/2009*/
// DBBase.SetDBNullParametre(cmd.Parameters);
// try
// {
// if (cn.State == ConnectionState.Closed)
// cn.Open();
// cmd.ExecuteNonQuery();
// }
// catch (Exception ex)
// {
// throw new Exception(ex.Message);
// }
// finally
// {
// if (cn.State == ConnectionState.Open)
// cn.Close(); // Fermeture de la connection
// cmd.Dispose();
// }
//}
//public bool Delete(Guid IdUser)
//{
// cn = new SqlConnection(ConnectionString);
// cmd = new SqlCommand();
// cmd.Connection = cn;
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.CommandText = "spx_AdmUsers_Delete";
// cmd.Parameters.Clear();
// cmd.Parameters.Add("@IdUser", SqlDbType.VarChar).Value = IdUser;
// DBBase.SetDBNullParametre(cmd.Parameters);
// try
// {
// if (cn.State == ConnectionState.Closed)
// cn.Open();
// cmd.ExecuteNonQuery();
// return true;
// }
// catch (Exception ex)
// {
// string error = ex.Message;
// return false;
// }
// finally
// {
// if (cn.State == ConnectionState.Open)
// cn.Close(); // Fermeture de la connection
// cmd.Dispose();
// }
//}
/*Adaptation Galatee - Par HGB*/
public bool Delete(string Matricule)
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spx_AdmUsers_DeleteByMatricule";
cmd.Parameters.Clear();
cmd.Parameters.Add("@Matricule", SqlDbType.VarChar).Value = Matricule;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
public List <CsRegCli> RetourneRegroupementGestionnaires(int IdGestionnaire)
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 18000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_RECOUV_REGROUPEMENTGESTIONNAIRE";
cmd.Parameters.Add("@IDGESTIONNAIRE", SqlDbType.Int).Value = IdGestionnaire;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
return(Entities.GetEntityListFromQuery <CsRegCli>(dt));
}
catch (Exception ex)
{
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
public List <CsComptable> RetourneComptaDuMoisComptable(string pMoisCompta, string pTypeEnc)
{
CsComptable _ta;
List <CsComptable> ListeTA = new List <CsComptable>();
ConnectionString = Session.GetSqlConnexionStringAbo07();
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = EnumProcedureStockee.RetourneComptaParMoisCompta;
cmd.Parameters.Clear();
cmd.Parameters.Add("@MOISCOMPTA", SqlDbType.VarChar).Value = pMoisCompta;
cmd.Parameters.Add("@TYPEENC", SqlDbType.VarChar).Value = pTypeEnc;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (this.cn.State == ConnectionState.Closed)
{
this.cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
reader.Close();
// throw new Exception("Erreur survenue.");
}
while (reader.Read())
{
_ta = new CsComptable();
_ta.MOISCOMPTA = string.IsNullOrEmpty(reader.GetValue(0).ToString()) ? string.Empty : reader.GetValue(0).ToString().Trim();
_ta.CENTRE = string.IsNullOrEmpty(reader.GetValue(1).ToString()) ? string.Empty : reader.GetValue(1).ToString().Trim();
_ta.NATURE = string.IsNullOrEmpty(reader.GetValue(2).ToString()) ? string.Empty : reader.GetValue(2).ToString().Trim();
_ta.COMMUNE = string.IsNullOrEmpty(reader.GetValue(3).ToString()) ? string.Empty : reader.GetValue(3).ToString().Trim();
_ta.PRODUIT = string.IsNullOrEmpty(reader.GetValue(4).ToString()) ? string.Empty : reader.GetValue(4).ToString().Trim();
_ta.REDEVANCE = string.IsNullOrEmpty(reader.GetValue(5).ToString()) ? string.Empty : reader.GetValue(5).ToString().Trim();
_ta.REDHT = string.IsNullOrEmpty(reader.GetValue(6).ToString()) ? 0 : Convert.ToDecimal(reader.GetValue(6).ToString().Trim());
_ta.REDTAXE = string.IsNullOrEmpty(reader.GetValue(7).ToString()) ? 0 : Convert.ToDecimal(reader.GetValue(7).ToString().Trim());
ListeTA.Add(_ta);
}
//Fermeture reader
reader.Close();
return(ListeTA);
}
catch (Exception ex)
{
throw new Exception(EnumProcedureStockee.SelectARRETE + ":" + ex.Message);
}
finally
{
if (this.cn.State == ConnectionState.Open)
{
this.cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
public List <CsHabilitationProgram> ProgramSelectById(int id)
{
CsHabilitationProgram line;
List <CsHabilitationProgram> programmes = new List <CsHabilitationProgram>();
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "spx_Program_SelectById";
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = id;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
List <CsHabilitationProgram> rows = new List <CsHabilitationProgram>();
if (this.cn.State == ConnectionState.Closed)
{
this.cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
reader.Close();
return(null);
}
while (reader.Read())
{
//line = new CsHabilitationProgram();
//if (reader.GetValue(0).ToString().Trim() != string.Empty)
// line.Id = reader.GetValue(0).ToString().Trim();
////if (reader.GetValue(1).ToString().Trim() != string.Empty)
// //line.IdGroupProgram =reader.GetValue(1).ToString().Trim();
//line.Code = reader.GetValue(2).ToString().Trim();
//line.Libelle = reader.GetValue(3).ToString().Trim();
//rows.Add(line);
}
//Fermeture reader
reader.Close();
return(rows);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (this.cn.State == ConnectionState.Open)
{
this.cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
public List <CsReclamationRcl> ListDesReclamationSpx(DateTime dateDebut, DateTime dateFin, List <int> lstidcentre, List <int> EtatReclamant)
{
try
{
string listeTypeReclamation = DBBase.RetourneStringListeObject(EtatReclamant);;
//foreach (var item in EtatReclamant)
// {
// listeTypeReclamation=item+","+ listeTypeReclamation;
// }
cn = new SqlConnection(ConnectionString);
string lesCentres = DBBase.RetourneStringListeObject(lstidcentre);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 3000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_RECLAMATION_LISTERECLAMATION";
cmd.Parameters.Add("@dateDebut", SqlDbType.DateTime).Value = dateDebut;
//cmd.Parameters.Add("@TypeReclamantion", SqlDbType.Int).Value = EtatReclamant;
cmd.Parameters.Add("@TypeReclamantion", SqlDbType.VarChar).Value = listeTypeReclamation;
cmd.Parameters.Add("@dateFin", SqlDbType.DateTime).Value = dateFin;
cmd.Parameters.Add("@IDCENTRELIST", SqlDbType.VarChar, int.MaxValue).Value = lesCentres;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
return(Entities.GetEntityListFromQuery <CsReclamationRcl>(dt));
}
catch (Exception ex)
{
return(null);
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Delete_REGROU(string Centre, string CodeRegroupement, string CodeProduit)
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = EnumProcedureStockee.DeleteREGROU;
cmd.Parameters.Clear();
SqlParameter paramCentre = cmd.Parameters.Add("@Centre", SqlDbType.VarChar);
paramCentre.Direction = ParameterDirection.Input;
SqlParameter paramRegrou = cmd.Parameters.Add("@Regrou", SqlDbType.VarChar);
paramRegrou.Direction = ParameterDirection.Input;
SqlParameter paramProduit = cmd.Parameters.Add("@Produit", SqlDbType.VarChar);
paramProduit.Direction = ParameterDirection.Input;
// recuperer les informations de la ligne selectionnée
paramCentre.Value = Centre;
paramRegrou.Value = CodeRegroupement;
paramProduit.Value = CodeProduit;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
StartTransaction(cn);
cmd.ExecuteNonQuery();
CommitTransaction(cmd.Transaction);
}
catch (Exception ex)
{
RollBackTransaction(cmd.Transaction);
throw new Exception(EnumProcedureStockee.DeleteREGROU + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
cmd.Dispose();
}
}
public void Update(List <CsInit> row)
{
foreach (CsInit ta in row)
{
int rowsAffected = -1;
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = EnumProcedureStockee.UpdateINIT;
cmd.Parameters.Clear();
try
{
cmd.Parameters.Add("@CENTRE", SqlDbType.VarChar).Value = ta.CENTRE;
cmd.Parameters.Add("@PRODUIT", SqlDbType.VarChar).Value = ta.PRODUIT;
cmd.Parameters.Add("@NTABLE", SqlDbType.SmallInt).Value = int.Parse(ta.NTABLE);
cmd.Parameters.Add("@ZONE", SqlDbType.SmallInt).Value = int.Parse(ta.ZONE);
cmd.Parameters.Add("@CONTENU", SqlDbType.SmallInt).Value = ta.CONTENU;
cmd.Parameters.Add("@OBLIG", SqlDbType.VarChar).Value = ta.OBLIG;
cmd.Parameters.Add("@DMAJ", SqlDbType.DateTime).Value = ta.DMAJ;
cmd.Parameters.Add("@TRANS", SqlDbType.VarChar).Value = ta.TRANS;
cmd.Parameters.Add("@ROWID", SqlDbType.Timestamp).Value = ta.ROWID;
DBBase.SetDBNullParametre(cmd.Parameters);
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
StartTransaction(cn);
rowsAffected = cmd.ExecuteNonQuery();
//cmd.ExecuteNonQuery(); // Exécution de la procédure stockée
CommitTransaction(cmd.Transaction);
}
catch (Exception ex)
{
RollBackTransaction(cmd.Transaction);
throw ex;
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
}
public void MiseAJour_REGROU(List <CsRegrou> rows)
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = EnumProcedureStockee.UpdateREGROU.Trim();
try
{
foreach (CsRegrou row in rows)
{
cmd.Parameters.Clear();
cmd.Parameters.Add("@CENTRE", SqlDbType.VarChar).Value = row.CENTRE;
cmd.Parameters.Add("@REGROU", SqlDbType.VarChar).Value = row.REGROU;
cmd.Parameters.Add("@PRODUIT", SqlDbType.VarChar).Value = row.PRODUIT;
cmd.Parameters.Add("@NOM", SqlDbType.VarChar).Value = row.NOM;
cmd.Parameters.Add("@CUBGEN", SqlDbType.Int).Value = row.CUBGEN;
cmd.Parameters.Add("@CUBDIV", SqlDbType.Int).Value = row.CUBDIV;
cmd.Parameters.Add("@DMAJ", SqlDbType.DateTime).Value = row.DMAJ;
cmd.Parameters.Add("@TRANS", SqlDbType.VarChar).Value = row.TRANS;
cmd.Parameters.Add("@ROWID", SqlDbType.Timestamp).Value = row.ROWID;
DBBase.SetDBNullParametre(cmd.Parameters);
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
StartTransaction(cn);
cmd.ExecuteNonQuery(); // Exécution de la procédure stockée
}
CommitTransaction(cmd.Transaction);
}
catch (Exception ex)
{
RollBackTransaction(cmd.Transaction);
throw new Exception(EnumProcedureStockee.UpdateREGROU + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
public void Insert(List <aTa> row)
{
foreach (aTa ta in row)
{
int rowsAffected = -1;
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = EnumProcedureStockee.InsertTa.Trim();
cmd.Parameters.Clear();
try
{
cmd.Parameters.Add("@CENTRE", SqlDbType.VarChar).Value = ta.CENTRE;
cmd.Parameters.Add("@NUM", SqlDbType.SmallInt).Value = ta.NUM;
cmd.Parameters.Add("@CODE", SqlDbType.SmallInt).Value = ta.CODE;
cmd.Parameters.Add("@TRANS", SqlDbType.VarChar).Value = ta.TRANS;
cmd.Parameters.Add("@LIBELLE", SqlDbType.VarChar).Value = ta.LIBELLE;
cmd.Parameters.Add("@DMAJ", SqlDbType.DateTime).Value = ta.DMAJ;
DBBase.SetDBNullParametre(cmd.Parameters);
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
StartTransaction(cn);
rowsAffected = cmd.ExecuteNonQuery();
//cmd.ExecuteNonQuery(); // Exécution de la procédure stockée
CommitTransaction(cmd.Transaction);
}
catch (Exception ex)
{
RollBackTransaction(cmd.Transaction);
throw ex;
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
}
//public int SaveTarifFacturation(List<CsTarifFacturation> ListeVariableDeTarificationToUpdate_, List<CsTarifFacturation> ListeVariableDeTarificationToInserte_, List<CsTarifFacturation> ListeVariableDeTarificationToDelete_)
//{
// try
// {
// return TarificationProcedure.SaveTarifFacturation(ListeVariableDeTarificationToUpdate_, ListeVariableDeTarificationToInserte_, ListeVariableDeTarificationToDelete_);
// }
// catch (Exception ex)
// {
// throw ex;
// }
// //return true;
//}
//public bool DuplicationTarifVersCentre(int AncienIdCentre, int NouveauIdCentre, int? produit)
//{
// try
// {
// return TarificationProcedure.DuplicationTarifVersCentre(AncienIdCentre, NouveauIdCentre, produit);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public bool DuplicationTarifVersCentre(int AncienIdCentre, int NouveauIdCentre, int?produit)
{
try
{
try
{
cn = new SqlConnection(ConnectionString);
int resultat = -1;
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 3000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_TARIF_DUPLICATION";
cmd.Parameters.Add("@AncienIdCentre", SqlDbType.Int).Value = AncienIdCentre;
cmd.Parameters.Add("@NouveauIdCentre", SqlDbType.Int).Value = NouveauIdCentre;
cmd.Parameters.Add("@produitId", SqlDbType.Int).Value = produit;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
resultat = cmd.ExecuteNonQuery();
return(resultat < 0 ? false : true);
}
catch (Exception ex)
{
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <cStatistiqueReclamation> RetourStatistiqueReclamationSpx(DateTime dateDebut, DateTime dateFin, List <int> lstidcentre)
{
try
{
cn = new SqlConnection(ConnectionString);
string lesCentres = DBBase.RetourneStringListeObject(lstidcentre);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 3000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_RECLAMATION_STATISTIQUERECLAMATION";
cmd.Parameters.Add("@dateDebut", SqlDbType.DateTime).Value = dateDebut;
cmd.Parameters.Add("@dateFin", SqlDbType.DateTime).Value = dateFin;
cmd.Parameters.Add("@centre", SqlDbType.VarChar).Value = lesCentres;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
return(Entities.GetEntityListFromQuery <cStatistiqueReclamation>(dt));
}
catch (Exception ex)
{
return(null);
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsLclient> ReturneListeDesImpayesSpx(int IdCentre, int?IdCategorie, int?IdTournee)
{
try
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 3000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_RPT_IMPAYES_CENTRE_CATEGORIE_CENTRE";
cmd.Parameters.Add("@IdCentre", SqlDbType.Int).Value = IdCentre;
cmd.Parameters.Add("@IdCategorie", SqlDbType.Int).Value = IdCategorie;
cmd.Parameters.Add("@IdTournee", SqlDbType.Int).Value = IdTournee;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
return(Entities.GetEntityListFromQuery <CsLclient>(dt));
}
catch (Exception ex)
{
return(null);
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Testunicite_DEMCOUT
/// </summary>
/// <param name="Centre"></param>
/// <param name="Produit"></param>
/// <param name="Tdem"></param>
/// <returns></returns>
public bool Testunicite_DEMCOUT(string Centre, string Produit, string Tdem)
{
bool Result = false;
try
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = EnumProcedureStockee.SelectDEMCOUTByKey.Trim();
cmd.Parameters.Clear();
cmd.Parameters.Add("@CENTRE", SqlDbType.VarChar).Value = Centre;
cmd.Parameters.Add("@PRODUIT", SqlDbType.VarChar).Value = Produit;
cmd.Parameters.Add("@TDEM", SqlDbType.VarChar).Value = Tdem;
DBBase.SetDBNullParametre(cmd.Parameters);
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
StartTransaction(cn);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
Result = true;
}
reader.Close();
CommitTransaction(cmd.Transaction);
}
catch (Exception ex)
{
RollBackTransaction(cmd.Transaction);
throw ex;
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
return(Result);
}
public List <CsCentreProfil> GetCentreProfilActif(int IdUtilidateur, int IdProfil)
{
try
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 3000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_ADMIN_RETOURECENTREPROFIL";
cmd.Parameters.Add("@IDPROFIL", SqlDbType.Int).Value = IdProfil;
cmd.Parameters.Add("@IDUTILISATEUR", SqlDbType.Int).Value = IdUtilidateur;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
return(Entities.GetEntityListFromQuery <CsCentreProfil>(dt));
}
catch (Exception ex)
{
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool InsertOrUpdate(CsPosteTransformation st)
{
SqlConnection cn = new SqlConnection(Session.GetSqlConnexionString());
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 1800;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_ACC_INSERTORUPDATE_POSTETRANSFORMATION";
if (cmd.Parameters != null && cmd.Parameters.Count != 0)
{
cmd.Parameters.Clear();
}
cmd.Parameters.Add("@PK_ID", SqlDbType.Int).Value = st.PK_ID;
cmd.Parameters.Add("@CODE", SqlDbType.VarChar, 6).Value = st.CODE;
cmd.Parameters.Add("@LIBELLE", SqlDbType.VarChar, 50).Value = st.LIBELLE;
cmd.Parameters.Add("@USERCREATION", SqlDbType.VarChar, 20).Value = st.USERCREATION;
cmd.Parameters.Add("@USERMODIFICATION", SqlDbType.VarChar, 20).Value = st.USERMODIFICATION;
cmd.Parameters.Add("@FK_IDDEPARTHTA", SqlDbType.Int).Value = st.FK_IDDEPARTHTA;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
return(cmd.ExecuteNonQuery() > 0);
}
catch (Exception ex)
{
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
public CsUtilisateur VerifieUserExist(string matricule)
{
try
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 3000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_ADMIN_VERIFIEUTILISATEUR";
cmd.Parameters.Add("@MATRICULE", SqlDbType.VarChar, 9).Value = matricule;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
return(Entities.GetEntityFromQuery <CsUtilisateur>(dt));
}
catch (Exception ex)
{
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
}
public CsUtilisateur GetUserByLoginName(string LoginName)
{
try
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 180;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_ADMIN_GETUSERBYLOGIN";
cmd.Parameters.Add("@LOGINNAME", SqlDbType.VarChar, 20).Value = LoginName;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
return(Entities.GetEntityFromQuery <CsUtilisateur>(dt));
}
catch (Exception ex)
{
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
}
public CsStrategieSecurite GetActif()
{
try
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 180;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_ADMIN_STRATEGIESECURITE_ACTIVE";
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
return(Entities.GetEntityFromQuery <CsStrategieSecurite>(dt));
}
catch (Exception ex)
{
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
}
//public List<CsHabilitationProgram> SelectHabilitationByUser(int Iduser)
//{
// try
// {
// DataTable obj = Galatee.Entity.Model.AuthentProcedures.SelectHabilitationByUser(Iduser);
// List<CsHabilitationProgram> l = Tools.Utility.GetEntityFromQuery<CsHabilitationProgram>(obj).ToList();
// return l;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
#endregion
public List <CsHabilitationProgram> SelectHabilitationByUser(int Iduser)
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 180;
cmd.CommandType = CommandType.StoredProcedure;
if (cmd.Parameters != null && cmd.Parameters.Count != 0)
{
cmd.Parameters.Clear();
}
cmd.CommandText = "SPX_ADMIN_SELECTPROFILUSER";
cmd.Parameters.Add("@IDUSER", SqlDbType.Int).Value = Iduser;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
return(Entities.GetEntityListFromQuery <CsHabilitationProgram>(dt));
}
catch (Exception ex)
{
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
public bool Delete(CsPosteTransformation del)
{
SqlConnection cn = new SqlConnection(Session.GetSqlConnexionString());
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 1800;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_ACC_DELETE_POSTETRANSFORMATION";
if (cmd.Parameters != null && cmd.Parameters.Count != 0)
{
cmd.Parameters.Clear();
}
cmd.Parameters.Add("@PK_ID", SqlDbType.Int).Value = del.PK_ID;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
return(!reader.HasRows);
}
catch (Exception ex)
{
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
public List <CsPosteTransformation> SelectAllPosteTransformation()
{
SqlConnection cn = new SqlConnection(Session.GetSqlConnexionString());
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandTimeout = 1800;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPX_ACC_GET_POSTETRANSFORMATION";
if (cmd.Parameters != null && cmd.Parameters.Count != 0)
{
cmd.Parameters.Clear();
}
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
return(Entities.GetEntityListFromQuery <CsPosteTransformation>(dt));
}
catch (Exception ex)
{
throw new Exception(cmd.CommandText + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
public bool Insert(CsAdmRoles admRoles)
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spx_AdmRoles_Insert";
cmd.Parameters.Clear();
cmd.Parameters.Add("@Centre", SqlDbType.VarChar).Value = admRoles.Centre;
cmd.Parameters.Add("@RoleID", SqlDbType.VarChar).Value = admRoles.RoleID;
cmd.Parameters.Add("@CodeFonc", SqlDbType.VarChar).Value = admRoles.CodeFonc;
cmd.Parameters.Add("@RoleName", SqlDbType.VarChar).Value = admRoles.RoleName;
cmd.Parameters.Add("@RoleDisplayName", SqlDbType.VarChar).Value = admRoles.RoleDisplayName;
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
public List <CsSchema> RetourneDonneesTableSchema()
{
CsSchema _ta;
List <CsSchema> ListeTA = new List <CsSchema>();
ConnectionString = Session.GetSqlConnexionStringAbo07();
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = EnumProcedureStockee.SelectSCHEMAS;
cmd.Parameters.Clear();
DBBase.SetDBNullParametre(cmd.Parameters);
try
{
if (this.cn.State == ConnectionState.Closed)
{
this.cn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
reader.Close();
throw new Exception(EnumProcedureStockee.SelectSCHEMAS + ":" + "n'a retourné aucun jeu de caractère");
}
while (reader.Read())
{
_ta = new CsSchema();
_ta.CENTRE = string.IsNullOrEmpty(reader.GetValue(0).ToString()) ? string.Empty : reader.GetValue(0).ToString().Trim();
_ta.NUM = string.IsNullOrEmpty(reader.GetValue(1).ToString()) ? string.Empty : reader.GetValue(1).ToString().Trim();
_ta.GENE0 = string.IsNullOrEmpty(reader.GetValue(2).ToString()) ? string.Empty : reader.GetValue(2).ToString().Trim();
_ta.ANAL0 = string.IsNullOrEmpty(reader.GetValue(3).ToString()) ? string.Empty : reader.GetValue(3).ToString().Trim();
_ta.GENE1 = string.IsNullOrEmpty(reader.GetValue(4).ToString()) ? string.Empty : reader.GetValue(4).ToString().Trim();
_ta.ANAL1 = string.IsNullOrEmpty(reader.GetValue(5).ToString()) ? string.Empty : reader.GetValue(5).ToString().Trim();
_ta.SENS1 = string.IsNullOrEmpty(reader.GetValue(6).ToString()) ? string.Empty : reader.GetValue(6).ToString().Trim();
_ta.SIGN1 = string.IsNullOrEmpty(reader.GetValue(7).ToString()) ? string.Empty : reader.GetValue(7).ToString().Trim();
_ta.GENE2 = string.IsNullOrEmpty(reader.GetValue(8).ToString()) ? string.Empty : reader.GetValue(8).ToString().Trim();
_ta.ANAL2 = string.IsNullOrEmpty(reader.GetValue(9).ToString()) ? string.Empty : reader.GetValue(9).ToString().Trim();
_ta.SENS2 = string.IsNullOrEmpty(reader.GetValue(10).ToString()) ? string.Empty : reader.GetValue(10).ToString().Trim();
_ta.SIGN2 = string.IsNullOrEmpty(reader.GetValue(11).ToString()) ? string.Empty : reader.GetValue(11).ToString().Trim();
_ta.GENE3 = string.IsNullOrEmpty(reader.GetValue(12).ToString()) ? string.Empty : reader.GetValue(12).ToString().Trim();
_ta.ANAL3 = string.IsNullOrEmpty(reader.GetValue(13).ToString()) ? string.Empty : reader.GetValue(13).ToString().Trim();
_ta.SENS3 = string.IsNullOrEmpty(reader.GetValue(14).ToString()) ? string.Empty : reader.GetValue(14).ToString().Trim();
_ta.SIGN3 = string.IsNullOrEmpty(reader.GetValue(15).ToString()) ? string.Empty : reader.GetValue(15).ToString().Trim();
_ta.GENE4 = string.IsNullOrEmpty(reader.GetValue(16).ToString()) ? string.Empty : reader.GetValue(16).ToString().Trim();
_ta.ANAL4 = string.IsNullOrEmpty(reader.GetValue(17).ToString()) ? string.Empty : reader.GetValue(17).ToString().Trim();
_ta.SENS4 = string.IsNullOrEmpty(reader.GetValue(18).ToString()) ? string.Empty : reader.GetValue(18).ToString().Trim();
_ta.SIGN4 = string.IsNullOrEmpty(reader.GetValue(19).ToString()) ? string.Empty : reader.GetValue(19).ToString().Trim();
_ta.GENE5 = string.IsNullOrEmpty(reader.GetValue(20).ToString()) ? string.Empty : reader.GetValue(20).ToString().Trim();
_ta.ANAL5 = string.IsNullOrEmpty(reader.GetValue(21).ToString()) ? string.Empty : reader.GetValue(21).ToString().Trim();
_ta.SENS5 = string.IsNullOrEmpty(reader.GetValue(22).ToString()) ? string.Empty : reader.GetValue(22).ToString().Trim();
_ta.SIGN5 = string.IsNullOrEmpty(reader.GetValue(23).ToString()) ? string.Empty : reader.GetValue(23).ToString().Trim();
_ta.GENE6 = string.IsNullOrEmpty(reader.GetValue(24).ToString()) ? string.Empty : reader.GetValue(24).ToString().Trim();
_ta.ANAL6 = string.IsNullOrEmpty(reader.GetValue(25).ToString()) ? string.Empty : reader.GetValue(25).ToString().Trim();
_ta.SENS6 = string.IsNullOrEmpty(reader.GetValue(26).ToString()) ? string.Empty : reader.GetValue(26).ToString().Trim();
_ta.SIGN6 = string.IsNullOrEmpty(reader.GetValue(27).ToString()) ? string.Empty : reader.GetValue(27).ToString().Trim();
ListeTA.Add(_ta);
}
//Fermeture reader
reader.Close();
return(ListeTA);
}
catch (Exception ex)
{
throw new Exception(EnumProcedureStockee.SelectSCHEMAS + ":" + ex.Message);
}
finally
{
if (this.cn.State == ConnectionState.Open)
{
this.cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}
/// <summary>
/// Insertion_DEMCOUT
/// </summary>
/// <param name="row"></param>
public void Insertion_DEMCOUT(List <CsTdemCout> rows)
{
cn = new SqlConnection(ConnectionString);
cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = EnumProcedureStockee.InsertDEMCOUT.Trim();
cmd.Parameters.Clear();
try
{
foreach (CsTdemCout row in rows)
{
cmd.Parameters.Add("@CENTRE", SqlDbType.VarChar).Value = row.CENTRE;
cmd.Parameters.Add("@PRODUIT", SqlDbType.VarChar).Value = row.PRODUIT;
cmd.Parameters.Add("@TDEM", SqlDbType.VarChar).Value = row.TDEM;
cmd.Parameters.Add("@COPER1", SqlDbType.VarChar).Value = row.COPER1;
cmd.Parameters.Add("@OBLI1", SqlDbType.VarChar).Value = row.OBLI1;
cmd.Parameters.Add("@AUTO1", SqlDbType.VarChar).Value = row.AUTO1;
cmd.Parameters.Add("@MONTANT1", SqlDbType.Decimal).Value = row.MONTANT1;
cmd.Parameters.Add("@TAXE1", SqlDbType.VarChar).Value = row.TAXE1;
cmd.Parameters.Add("@COPER2", SqlDbType.VarChar).Value = row.COPER2;
cmd.Parameters.Add("@OBLI2", SqlDbType.VarChar).Value = row.OBLI2;
cmd.Parameters.Add("@AUTO2", SqlDbType.VarChar).Value = row.AUTO2;
cmd.Parameters.Add("@MONTANT2", SqlDbType.Decimal).Value = row.MONTANT2;
cmd.Parameters.Add("@TAXE2", SqlDbType.VarChar).Value = row.TAXE2;
cmd.Parameters.Add("@COPER3", SqlDbType.VarChar).Value = row.COPER3;
cmd.Parameters.Add("@OBLI3", SqlDbType.VarChar).Value = row.OBLI3;
cmd.Parameters.Add("@AUTO3", SqlDbType.VarChar).Value = row.AUTO3;
cmd.Parameters.Add("@MONTANT3", SqlDbType.Decimal).Value = row.MONTANT3;
cmd.Parameters.Add("@TAXE3", SqlDbType.VarChar).Value = row.TAXE3;
cmd.Parameters.Add("@COPER4", SqlDbType.VarChar).Value = row.COPER4;
cmd.Parameters.Add("@OBLI4", SqlDbType.VarChar).Value = row.OBLI4;
cmd.Parameters.Add("@AUTO4", SqlDbType.VarChar).Value = row.AUTO4;
cmd.Parameters.Add("@MONTANT4", SqlDbType.Decimal).Value = row.MONTANT4;
cmd.Parameters.Add("@TAXE4", SqlDbType.VarChar).Value = row.TAXE4;
cmd.Parameters.Add("@COPER5", SqlDbType.VarChar).Value = row.COPER5;
cmd.Parameters.Add("@OBLI5", SqlDbType.VarChar).Value = row.OBLI5;
cmd.Parameters.Add("@AUTO5", SqlDbType.VarChar).Value = row.AUTO5;
cmd.Parameters.Add("@MONTANT5", SqlDbType.Decimal).Value = row.MONTANT5;
cmd.Parameters.Add("@TAXE5", SqlDbType.VarChar).Value = row.TAXE5;
cmd.Parameters.Add("@DMAJ", SqlDbType.DateTime).Value = row.DMAJ;
cmd.Parameters.Add("@TRANS", SqlDbType.VarChar).Value = row.TRANS;
DBBase.SetDBNullParametre(cmd.Parameters);
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
StartTransaction(cn);
cmd.ExecuteNonQuery();
}
CommitTransaction(cmd.Transaction);
}
catch (Exception ex)
{
RollBackTransaction(cmd.Transaction);
throw new Exception(EnumProcedureStockee.InsertDEMCOUT + ":" + ex.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close(); // Fermeture de la connection
}
cmd.Dispose();
}
}