public CsCentre SelectCentreByCodeSiteCodeCentre(int pCodeSite, int pCodeCentre)
{
try
{
return(Entities.GetEntityFromQuery <CsCentre>(ParamProcedure.PARAM_CENTRE_RETOURNEByIdSiteIdCentre(pCodeSite, pCodeCentre)));
}
catch (Exception ex)
{
throw ex;
}
}
/*
* /// <summary>
* /// DB_BANQUES2
* /// </summary>
* public DB_REGEXO()
* {
* ConnectionString = Session.GetSqlConnexionString();
* }
* /// <summary>
* /// DB_BANQUES2
* /// </summary>
* /// <param name="ConnStr"></param>
* public DB_REGEXO(string ConnStr)
* {
* ConnectionString = ConnStr;
* }
* /// <summary>
* /// ConnectionString
* /// </summary>
* private string ConnectionString;
* private SqlConnection cn = null;
*
* private bool _Transaction;
* /// <summary>
* /// Transaction
* /// </summary>
* public bool Transaction
* {
* get { return _Transaction; }
* set { _Transaction = value; }
*
* }
*
* private SqlCommand cmd = null;
*
*
* public List<CsRegExo> SelectAllRegExo()
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.SelectREGEXO
* };
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsRegExo>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw new Exception(EnumProcedureStockee.SelectREGEXO + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Delete(CsRegExo pRegExo)
* {
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.DeleteREGEXO
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@CENTRE", pRegExo.CENTRE);
* cmd.Parameters.AddWithValue("@PRODUIT", pRegExo.PRODUIT);
* cmd.Parameters.AddWithValue("@REGCLI", pRegExo.REGCLI);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw new Exception(EnumProcedureStockee.DeleteREGEXO + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(List<CsRegExo> pRegExoCollection)
* {
* int number = 0;
* foreach (CsRegExo entity in pRegExoCollection)
* {
* if (Delete(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private bool Update(CsRegExo pRegExo)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.UpdateREGEXO
* };
* cmd.Parameters.Clear();
*
* try
* {
*
* cmd.Parameters.AddWithValue("@CENTRE", pRegExo.CENTRE);
* cmd.Parameters.AddWithValue("@OriginalCENTRE", pRegExo.OriginalCENTRE);
* cmd.Parameters.AddWithValue("@PRODUIT", pRegExo.PRODUIT);
* cmd.Parameters.AddWithValue("@OriginalPRODUIT", pRegExo.OriginalPRODUIT);
* cmd.Parameters.AddWithValue("@REGCLI", pRegExo.REGCLI);
* cmd.Parameters.AddWithValue("@OriginalREGCLI", pRegExo.OriginalREGCLI);
* cmd.Parameters.AddWithValue("@EXFAV", pRegExo.EXFAV);
* cmd.Parameters.AddWithValue("@EXFDOS", pRegExo.EXFDOS);
* cmd.Parameters.AddWithValue("@EXFPOL", pRegExo.EXFPOL);
* cmd.Parameters.AddWithValue("@TRAITFAC", pRegExo.TRAITFAC);
* cmd.Parameters.AddWithValue("@TRANS", pRegExo.TRANS);
* cmd.Parameters.AddWithValue("@REFERENCEPUPITRE", pRegExo.REFERENCEPUPITRE);
* cmd.Parameters.AddWithValue("@DATECREATION", pRegExo.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pRegExo.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pRegExo.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pRegExo.USERMODIFICATION);
*
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Update(List<CsRegExo> pRegExoCollection)
* {
* int number = 0;
* foreach (CsRegExo entity in pRegExoCollection)
* {
* if (Update(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private bool Insert(CsRegExo pRegExo)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.InsertREGEXO
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CENTRE", pRegExo.CENTRE);
* cmd.Parameters.AddWithValue("@PRODUIT", pRegExo.PRODUIT);
* cmd.Parameters.AddWithValue("@REGCLI", pRegExo.REGCLI);
* cmd.Parameters.AddWithValue("@EXFAV", pRegExo.EXFAV);
* cmd.Parameters.AddWithValue("@EXFDOS", pRegExo.EXFDOS);
* cmd.Parameters.AddWithValue("@EXFPOL", pRegExo.EXFPOL);
* cmd.Parameters.AddWithValue("@TRAITFAC", pRegExo.TRAITFAC);
* cmd.Parameters.AddWithValue("@TRANS", pRegExo.TRANS);
* cmd.Parameters.AddWithValue("@REFERENCEPUPITRE", pRegExo.REFERENCEPUPITRE);
* cmd.Parameters.AddWithValue("@DATECREATION", pRegExo.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pRegExo.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pRegExo.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pRegExo.USERMODIFICATION);
*
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
*
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Insert(List<CsRegExo> pRegExoCollection)
* {
* int number = 0;
* foreach (CsRegExo entity in pRegExoCollection)
* {
* if (Insert(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public static List<CsRegExo> Fill(IDataReader reader, List<CsRegExo> rows, int start, int pageLength)
* {
* // advance to the starting row
* for (int i = 0; i < start; i++)
* {
* if (!reader.Read())
* return rows; // not enough rows, just return
* }
*
* for (int i = 0; i < pageLength; i++)
* {
* if (!reader.Read())
* break; // we are done
*
* var c = new CsRegExo();
* c.REGCLI = (Convert.IsDBNull(reader["REGCLI"])) ? string.Empty : (System.String)reader["REGCLI"];
* c.OriginalREGCLI = (Convert.IsDBNull(reader["REGCLI"])) ? string.Empty : (System.String)reader["REGCLI"];
* c.PRODUIT = (Convert.IsDBNull(reader["PRODUIT"])) ? string.Empty : (System.String)reader["PRODUIT"];
* c.OriginalPRODUIT = (Convert.IsDBNull(reader["PRODUIT"])) ? string.Empty : (System.String)reader["PRODUIT"];
* c.CENTRE = (Convert.IsDBNull(reader["CENTRE"])) ? string.Empty : (System.String)reader["CENTRE"];
* c.OriginalCENTRE = (Convert.IsDBNull(reader["CENTRE"])) ? string.Empty : (System.String)reader["CENTRE"];
* c.EXFAV = (Convert.IsDBNull(reader["EXFAV"])) ? string.Empty : (System.String)reader["EXFAV"];
* c.EXFDOS = (Convert.IsDBNull(reader["EXFDOS"])) ? string.Empty : (System.String)reader["EXFDOS"];
* c.EXFPOL = (Convert.IsDBNull(reader["EXFPOL"])) ? string.Empty : (System.String)reader["EXFPOL"];
* c.TRAITFAC = (Convert.IsDBNull(reader["TRAITFAC"])) ? string.Empty : (System.String)reader["TRAITFAC"];
* c.TRANS = (Convert.IsDBNull(reader["TRANS"])) ? string.Empty : (System.String)reader["TRANS"];
* c.REFERENCEPUPITRE = (Convert.IsDBNull(reader["REFERENCEPUPITRE"])) ? null : (short?)reader["REFERENCEPUPITRE"];
* c.DATECREATION = (Convert.IsDBNull(reader["DATECREATION"])) ? DateTime.MinValue : (System.DateTime)reader["DATECREATION"];
* if (Convert.IsDBNull(reader["DATEMODIFICATION"]))
* c.DATECREATION = null;
* else
* c.DATEMODIFICATION = (System.DateTime)reader["DATEMODIFICATION"];
* c.USERCREATION = (Convert.IsDBNull(reader["USERCREATION"])) ? string.Empty : (System.String)reader["USERCREATION"];
* c.USERMODIFICATION = (Convert.IsDBNull(reader["USERMODIFICATION"])) ? null : (System.String)reader["USERMODIFICATION"];
* c.LIBELLECENTRE = (Convert.IsDBNull(reader["LIBELLECENTRE"])) ? null : (System.String)reader["LIBELLECENTRE"];
* c.LIBELLEPRODUIT = (Convert.IsDBNull(reader["LIBELLEPRODUIT"])) ? null : (System.String)reader["LIBELLEPRODUIT"];
* c.LIBELLEREGCLI = (Convert.IsDBNull(reader["LIBELLEREGCLI"])) ? null : (System.String)reader["LIBELLEREGCLI"];
* rows.Add(c);
* }
* return rows;
* }
*
* /// <summary>
* /// StartTransaction
* /// </summary>
* /// <param name="_conn"></param>
* private void StartTransaction(SqlConnection _conn)
* {
* if ((_Transaction) && (_conn != null))
* {
* cmd.Transaction = this.BeginTransaction(_conn);
* }
* }
* /// <summary>
* /// CommitTransaction
* /// </summary>
* /// <param name="_pSqlTransaction"></param>
* private void CommitTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.Commit(_pSqlTransaction);
* }
* }
* /// <summary>
* /// RollBackTransaction
* /// </summary>
* /// <param name="_pSqlTransaction"></param>
* private void RollBackTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.RollBack(_pSqlTransaction);
* }
*
* }
*/
public List <CsRegExo> SelectAllRegExo()
{
try
{
return(Entities.GetEntityListFromQuery <CsRegExo>(ParamProcedure.PARAM_REGEXO_RETOURNE()));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsQuartier> SelectAllQuartierByCommune(int pCommune)
{
try
{
return(Entities.GetEntityListFromQuery <CsQuartier>(ParamProcedure.PARAM_QUARTIER_RETOURNEByCommune(pCommune)));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsSecteur> SelectAllSecteurById(int pId)
{
try
{
return(Entities.GetEntityListFromQuery <CsSecteur>(ParamProcedure.PARAM_SECTEUR_RETOURNEById(pId)));
}
catch (Exception ex)
{
throw ex;
}
}
/*
* private string ConnectionString;
*
* public DB_ParametreEvenement()
* {
* try
* {
* ConnectionString = Session.GetSqlConnexionString();
* }
* catch (Exception ex)
* {
*
* throw ex;
* }
* }
*
* public DB_ParametreEvenement(string ConnStr)
* {
* ConnectionString = ConnStr;
* }
*
* private SqlConnection cn = null;
*
* private bool _Transaction;
*
* public bool Transaction
* {
* get { return _Transaction; }
* set { _Transaction = value; }
*
* }
*
* private SqlCommand cmd = null;
*
* public List<CsParametreEvenement> SelectAllParametresEvenement()
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.SelectPARAMETREEVENEMENT
* };
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsParametreEvenement>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw new Exception(EnumProcedureStockee.SelectPARAMETRESGENRAUX + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Delete(CsParametreEvenement pParametreEvenement)
* {
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.DeletePARAMETREEVENEMENT
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@CODE", pParametreEvenement.CODE);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw new Exception(EnumProcedureStockee.DeletePARAMETREEVENEMENT + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(List<CsParametreEvenement> pParametreEvenementCollection)
* {
* int number = 0;
* foreach (CsParametreEvenement entity in pParametreEvenementCollection)
* {
* if (Delete(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public static List<CsParametreEvenement> Fill(IDataReader reader, List<CsParametreEvenement> rows, int start, int pageLength)
* {
* // advance to the starting row
* for (int i = 0; i < start; i++)
* {
* if (! reader.Read() )
* return rows; // not enough rows, just return
* }
*
* for (int i = 0; i < pageLength; i++)
* {
* if (!reader.Read())
* break; // we are done
*
* var c = new CsParametreEvenement();
* c.CODE = (Convert.IsDBNull(reader["CODE"]))?string.Empty:(System.String)reader["CODE"];
* c.OriginalCODE = (Convert.IsDBNull(reader["CODE"]))?string.Empty:(System.String)reader["CODE"];
* c.LIBELLE = (Convert.IsDBNull(reader["LIBELLE"])) ? string.Empty : (System.String)reader["LIBELLE"];
* c.USERCREATION = (Convert.IsDBNull(reader["USERCREATION"])) ? string.Empty : (System.String)reader["USERCREATION"];
* c.USERMODIFICATION = (Convert.IsDBNull(reader["USERMODIFICATION"])) ? string.Empty : (System.String)reader["USERMODIFICATION"];
* c.DATECREATION = (Convert.IsDBNull(reader["DATECREATION"])) ? (DateTime?)null : (System.DateTime)reader["DATECREATION"];
* c.DATEMODIFICATION = (Convert.IsDBNull(reader["DATEMODIFICATION"])) ? (DateTime?)null : (System.DateTime)reader["DATEMODIFICATION"];
* rows.Add(c);
* }
* return rows;
* }
*
* public bool Update(CsParametreEvenement pParametreEvenement)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.UpdatePARAMETREEVENEMENT
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CODE", pParametreEvenement.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pParametreEvenement.LIBELLE);
* cmd.Parameters.AddWithValue("@OriginalCODE", pParametreEvenement.OriginalCODE);
* cmd.Parameters.AddWithValue("@DATECREATION", pParametreEvenement.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pParametreEvenement.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pParametreEvenement.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pParametreEvenement.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Update(List<CsParametreEvenement> pParametreEvenementCollection)
* {
* int number = 0;
* foreach (CsParametreEvenement entity in pParametreEvenementCollection)
* {
* if (Update(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public bool Insert(CsParametreEvenement pParametreEvenement)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.InsertPARAMETREEVENEMENT
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CODE", pParametreEvenement.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pParametreEvenement.LIBELLE);
* cmd.Parameters.AddWithValue("@DATECREATION", pParametreEvenement.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pParametreEvenement.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pParametreEvenement.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pParametreEvenement.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
*
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Insert(List<CsParametreEvenement> pParametreEvenementCollection)
* {
* int number = 0;
* foreach (CsParametreEvenement entity in pParametreEvenementCollection)
* {
* if (Insert(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private void StartTransaction(SqlConnection _conn)
* {
* if ((_Transaction) && (_conn != null))
* {
* cmd.Transaction = this.BeginTransaction(_conn);
* }
* }
*
* private void CommitTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.Commit(_pSqlTransaction);
* }
* }
*
* private void RollBackTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.RollBack(_pSqlTransaction);
* }
* }
*
*/
public List <CsParametreEvenement> SelectAllParametresEvenement()
{
try
{
return(Entities.GetEntityListFromQuery <CsParametreEvenement>(ParamProcedure.PARAM_PARAMETREEVENEMENT_RETOURNE()));
}
catch (Exception ex)
{
throw ex;
}
}
/*
* public bool Transaction { get; set; }
*
* private SqlCommand cmd = null;
* private SqlConnection cn = null;
*
* public static List<ObjTACHEDEVIS> Fill(IDataReader reader, List<ObjTACHEDEVIS> rows, int start, int pageLength)
* {
* // advance to the starting row
* for (int i = 0; i < start; i++)
* {
* if (!reader.Read())
* return rows; // not enough rows, just return
* }
*
* for (int i = 0; i < pageLength; i++)
* {
* if (!reader.Read())
* break; // we are done
*
* ObjTACHEDEVIS c = new ObjTACHEDEVIS();
* c.PK_ID = (Convert.IsDBNull(reader["Id"])) ? (int)0 : (System.Int32)reader["Id"];
* c.OriginalPK_ID = (Convert.IsDBNull(reader["Id"])) ? (int)0 : (System.Int32)reader["Id"];
* c.LIBELLE = (Convert.IsDBNull(reader["Libelle"])) ? string.Empty : (System.String)reader["Libelle"];
* c.USERCREATION = (Convert.IsDBNull(reader["USERCREATION"])) ? string.Empty : (System.String)reader["USERCREATION"];
* c.USERMODIFICATION = (Convert.IsDBNull(reader["USERMODIFICATION"])) ? string.Empty : (System.String)reader["USERMODIFICATION"];
* c.DATECREATION = (Convert.IsDBNull(reader["DATECREATION"])) ? (DateTime?)null : (System.DateTime)reader["DATECREATION"];
* c.DATEMODIFICATION = (Convert.IsDBNull(reader["DATEMODIFICATION"])) ? (DateTime?)null : (System.DateTime)reader["DATEMODIFICATION"];
* rows.Add(c);
* }
* return rows;
* }
*
* public static ObjTACHEDEVIS GetById(int? id)
* {
* ObjTACHEDEVIS row = new ObjTACHEDEVIS();
*
* string connectString = Session.GetSqlConnexionString();
*
* SqlConnection connection = new SqlConnection(connectString);
* SqlCommand command = new SqlCommand("SPX_PARAM_TACHEDEVIS_RETOURNEById", connection);
* command.CommandType = CommandType.StoredProcedure;
*
* SqlParameter param = command.Parameters.Add(new SqlParameter("@Id", id));
* param.Direction = ParameterDirection.Input;
*
* try
* {
* //Ouverture
* connection.Open();
*
* //Object datareader
* SqlDataReader reader = command.ExecuteReader();
*
* List<ObjTACHEDEVIS> tmp = new List<ObjTACHEDEVIS>();
* Fill(reader, tmp, 0, int.MaxValue);
* reader.Close();
*
* if (tmp.Count == 1)
* {
* row = tmp[0];
* }
* else if (tmp.Count == 0)
* {
* row = null;
* }
* return row;
* }
* catch (Exception ex)
* {
* throw new Exception(ex.Message);
* }
* finally
* {
* if (connection.State == ConnectionState.Open)
* connection.Close();
* command.Dispose();
* }
* }
*
* public static List<ObjTACHEDEVIS> GetAll()
* {
* string connectString = Session.GetSqlConnexionString();
* SqlConnection connection = new SqlConnection(connectString);
* SqlCommand command = new SqlCommand("SPX_PARAM_TACHEDEVIS_RETOURNE", connection);
* command.CommandType = CommandType.StoredProcedure;
*
* try
* {
*
*
* if (connection.State == ConnectionState.Closed)
* connection.Open();
*
* SqlDataReader reader = command.ExecuteReader();
*
* List<ObjTACHEDEVIS> rows = new List<ObjTACHEDEVIS>();
* Fill(reader, rows, 0, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw new Exception(ex.Message);
* }
* finally
* {
* //Fermeture base
* if (connection.State == ConnectionState.Open)
* connection.Close();
* connection.Dispose();
* command.Dispose();
* }
*
* }
*
* public bool Delete(ObjTACHEDEVIS pTacheDevis)
* {
* try
* {
* cn = new SqlConnection(Session.GetSqlConnexionString());
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_TACHEDEVIS_SUPPRIMER"
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@Id", pTacheDevis.PK_ID);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(List<ObjTACHEDEVIS> pTacheDevisCollection)
* {
* int number = 0;
* foreach (ObjTACHEDEVIS entity in pTacheDevisCollection)
* {
* if (Delete(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public bool Update(ObjTACHEDEVIS pTacheDevis)
* {
* cn = new SqlConnection(Session.GetSqlConnexionString());
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_TACHEDEVIS_UPDATE"
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@Id", pTacheDevis.PK_ID);
* cmd.Parameters.AddWithValue("@LIBELLE", pTacheDevis.LIBELLE);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Update(List<ObjTACHEDEVIS> pTacheDevisCollection)
* {
* int number = 0;
* foreach (ObjTACHEDEVIS entity in pTacheDevisCollection)
* {
* if (Update(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public bool Insert(ObjTACHEDEVIS pTacheDevis)
* {
* cn = new SqlConnection(Session.GetSqlConnexionString());
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_TACHEDEVIS_INSERER"
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@LIBELLE", pTacheDevis.LIBELLE);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
*
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Insert(List<ObjTACHEDEVIS> pTypeDevisCollection)
* {
* int number = 0;
* foreach (ObjTACHEDEVIS entity in pTypeDevisCollection)
* {
* if (Insert(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private void StartTransaction(SqlConnection _conn)
* {
* if ((Transaction) && (_conn != null))
* {
* cmd.Transaction = this.BeginTransaction(_conn);
* }
* }
*
* private void CommitTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((Transaction) && (_pSqlTransaction != null))
* {
* this.Commit(_pSqlTransaction);
* }
* }
*
* private void RollBackTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((Transaction) && (_pSqlTransaction != null))
* {
* this.RollBack(_pSqlTransaction);
* }
* }
*
*/
public static ObjTACHEDEVIS GetById(int id)
{
try
{
return(Entities.GetEntityFromQuery <ObjTACHEDEVIS>(ParamProcedure.PARAM_TACHEDEVIS_RETOURNEById(id)));
}
catch (Exception ex)
{
throw ex;
}
}
public static CsUsage GetById(string id)
{
try
{
return(Entities.GetEntityFromQuery <CsUsage>(ParamProcedure.RetourneUsage(id)));
}
catch (Exception ex)
{
throw ex;
}
}
public static CsMaterielDemande GetById(CsMaterielDemande entity)
{
try
{
return(Entities.GetEntityFromQuery <CsMaterielDemande>(ParamProcedure.PARAM_MATERIEL_RETOURNEById(entity.PK_ID)));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsModeCalcul> SelectAllModeCalcul()
{
try
{
return(Entities.GetEntityListFromQuery <CsModeCalcul>(ParamProcedure.PARAM_MODECALCUL_RETOURNE()));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsNotificaton> SelectAllNotification()
{
try
{
return(Entities.GetEntityListFromQuery <CsNotificaton>(ParamProcedure.RetourneNotification()));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsNiveauTarif> SelectAllNiveauTarif()
{
try
{
return(Entities.GetEntityListFromQuery <CsNiveauTarif>(ParamProcedure.PARAM_NIVEAUTARIF_RETOURNE()));
}
catch (Exception ex)
{
throw ex;
}
}
/*
* private string ConnectionString;
*
* public DBMarqueCompteur()
* {
* try
* {
* ConnectionString = Session.GetSqlConnexionString();
* }
* catch (Exception ex)
* {
*
* throw ex;
* }
* }
*
* public DBMarqueCompteur(string ConnStr)
* {
* ConnectionString = ConnStr;
* }
*
* private SqlConnection cn = null;
*
* private bool _Transaction;
*
* public bool Transaction
* {
* get { return _Transaction; }
* set { _Transaction = value; }
*
* }
*
* private SqlCommand cmd = null;
*
* public List<CsMarqueCompteur> SelectAllMarqueCompteur()
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_MARQUECOMPTEUR_RETOURNE"
* };
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsMarqueCompteur>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw new Exception("SPX_PARAM_MARQUECOMPTEUR_RETOURNE" + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Delete(CsMarqueCompteur pMarqueCompteur)
* {
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_MARQUECOMPTEUR_SUPPRIMER"
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@CODE", pMarqueCompteur.CODE);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw new Exception("SPX_PARAM_MARQUECOMPTEUR_SUPPRIMER" + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(List<CsMarqueCompteur> pCategorieBranchemenCollection)
* {
* int number = 0;
* foreach (CsMarqueCompteur entity in pCategorieBranchemenCollection)
* {
* if (Delete(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public static List<CsMarqueCompteur> Fill(IDataReader reader, List<CsMarqueCompteur> rows, int start, int pageLength)
* {
* // advance to the starting row
* for (int i = 0; i < start; i++)
* {
* if (! reader.Read() )
* return rows; // not enough rows, just return
* }
*
* for (int i = 0; i < pageLength; i++)
* {
* if (!reader.Read())
* break; // we are done
*
* var c = new CsMarqueCompteur();
* c.CODE = (Convert.IsDBNull(reader["CODE"]))?string.Empty:(System.String)reader["CODE"];
* c.OriginalCODE = (Convert.IsDBNull(reader["CODE"]))?string.Empty:(System.String)reader["CODE"];
* c.LIBELLE = (Convert.IsDBNull(reader["LIBELLE"])) ? string.Empty : (System.String)reader["LIBELLE"];
* c.USERCREATION = (Convert.IsDBNull(reader["USERCREATION"])) ? string.Empty : (System.String)reader["USERCREATION"];
* c.USERMODIFICATION = (Convert.IsDBNull(reader["USERMODIFICATION"])) ? string.Empty : (System.String)reader["USERMODIFICATION"];
* c.DATECREATION = (Convert.IsDBNull(reader["DATECREATION"])) ? (DateTime?)null : (System.DateTime)reader["DATECREATION"];
* c.DATEMODIFICATION = (Convert.IsDBNull(reader["DATEMODIFICATION"])) ? (DateTime?)null : (System.DateTime)reader["DATEMODIFICATION"];
* rows.Add(c);
* }
* return rows;
* }
*
* public bool Update(CsMarqueCompteur pMarqueCompteur)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_MARQUECOMPTEUR_UPDATE"
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CODE", pMarqueCompteur.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pMarqueCompteur.LIBELLE);
* cmd.Parameters.AddWithValue("@OriginalCODE", pMarqueCompteur.OriginalCODE);
* cmd.Parameters.AddWithValue("@DATECREATION", pMarqueCompteur.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pMarqueCompteur.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pMarqueCompteur.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pMarqueCompteur.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Update(List<CsMarqueCompteur> pMarqueCompteurCollection)
* {
* int number = 0;
* foreach (CsMarqueCompteur entity in pMarqueCompteurCollection)
* {
* if (Update(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public bool Insert(CsMarqueCompteur pMarqueCompteur)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_MARQUECOMPTEUR_INSERER"
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CODE", pMarqueCompteur.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pMarqueCompteur.LIBELLE);
* cmd.Parameters.AddWithValue("@DATECREATION", pMarqueCompteur.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pMarqueCompteur.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pMarqueCompteur.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pMarqueCompteur.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
*
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Insert(List<CsMarqueCompteur> pMarqueCompteurCollection)
* {
* int number = 0;
* foreach (CsMarqueCompteur entity in pMarqueCompteurCollection)
* {
* if (Insert(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private void StartTransaction(SqlConnection _conn)
* {
* if ((_Transaction) && (_conn != null))
* {
* cmd.Transaction = this.BeginTransaction(_conn);
* }
* }
*
* private void CommitTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.Commit(_pSqlTransaction);
* }
* }
*
* private void RollBackTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.RollBack(_pSqlTransaction);
* }
* }
*
*/
public List <CsMarqueCompteur> SelectAllMarqueCompteur()
{
try
{
return(Entities.GetEntityListFromQuery <CsMarqueCompteur>(ParamProcedure.PARAM_MARQUECOMPTEUR_RETOURNE()));
}
catch (Exception ex)
{
throw ex;
}
}
/*
* private string ConnectionString;
*
* public DB_Proprietaire()
* {
* try
* {
* ConnectionString = Session.GetSqlConnexionString();
* }
* catch (Exception ex)
* {
*
* throw ex;
* }
* }
*
* public DB_Proprietaire(string ConnStr)
* {
* ConnectionString = ConnStr;
* }
*
* private SqlConnection cn = null;
*
* private bool _Transaction;
*
* public bool Transaction
* {
* get { return _Transaction; }
* set { _Transaction = value; }
*
* }
*
* private SqlCommand cmd = null;
*
* public List<CsProprietaire> SelectAllProprietaire()
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.SelectPROPRIETAIRE
* };
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsProprietaire>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw new Exception(EnumProcedureStockee.SelectPROPRIETAIRE + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Delete(CsProprietaire pProprietaire)
* {
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.DeletePROPRIETAIRE
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@CODE", pProprietaire.CODE);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw new Exception(EnumProcedureStockee.DeletePROPRIETAIRE + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(List<CsProprietaire> pProprietairesCollection)
* {
* int number = 0;
* foreach (CsProprietaire entity in pProprietairesCollection)
* {
* if (Delete(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public static List<CsProprietaire> Fill(IDataReader reader, List<CsProprietaire> rows, int start, int pageLength)
* {
* // advance to the starting row
* for (int i = 0; i < start; i++)
* {
* if (! reader.Read() )
* return rows; // not enough rows, just return
* }
*
* for (int i = 0; i < pageLength; i++)
* {
* if (!reader.Read())
* break; // we are done
*
* var c = new CsProprietaire();
* c.CODE = (Convert.IsDBNull(reader["CODE"]))?string.Empty:(System.String)reader["CODE"];
* c.OriginalCODE = (Convert.IsDBNull(reader["CODE"]))?string.Empty:(System.String)reader["CODE"];
* c.LIBELLE = (Convert.IsDBNull(reader["LIBELLE"])) ? string.Empty : (System.String)reader["LIBELLE"];
* c.USERCREATION = (Convert.IsDBNull(reader["USERCREATION"])) ? string.Empty : (System.String)reader["USERCREATION"];
* c.USERMODIFICATION = (Convert.IsDBNull(reader["USERMODIFICATION"])) ? string.Empty : (System.String)reader["USERMODIFICATION"];
* c.DATECREATION = (Convert.IsDBNull(reader["DATECREATION"])) ? (DateTime?)null : (System.DateTime)reader["DATECREATION"];
* c.DATEMODIFICATION = (Convert.IsDBNull(reader["DATEMODIFICATION"])) ? (DateTime?)null : (System.DateTime)reader["DATEMODIFICATION"];
* rows.Add(c);
* }
* return rows;
* }
*
* public bool Update(CsProprietaire pProprietaire)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.UpdatePROPRIETAIRE
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CODE", pProprietaire.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pProprietaire.LIBELLE);
* cmd.Parameters.AddWithValue("@OriginalCODE", pProprietaire.OriginalCODE);
* cmd.Parameters.AddWithValue("@DATECREATION", pProprietaire.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pProprietaire.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pProprietaire.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pProprietaire.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Update(List<CsProprietaire> pProprietaireCollection)
* {
* int number = 0;
* foreach (CsProprietaire entity in pProprietaireCollection)
* {
* if (Update(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public bool Insert(CsProprietaire pProprietaire)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.InsertPROPRIETAIRE
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CODE", pProprietaire.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pProprietaire.LIBELLE);
* cmd.Parameters.AddWithValue("@DATECREATION", pProprietaire.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pProprietaire.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pProprietaire.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pProprietaire.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
*
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Insert(List<CsProprietaire> pProprietaireCollection)
* {
* int number = 0;
* foreach (CsProprietaire entity in pProprietaireCollection)
* {
* if (Insert(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private void StartTransaction(SqlConnection _conn)
* {
* if ((_Transaction) && (_conn != null))
* {
* cmd.Transaction = this.BeginTransaction(_conn);
* }
* }
*
* private void CommitTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.Commit(_pSqlTransaction);
* }
* }
*
* private void RollBackTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.RollBack(_pSqlTransaction);
* }
* }
*/
public List <CsProprietaire> SelectAllProprietaire()
{
try
{
return(Entities.GetEntityListFromQuery <CsProprietaire>(ParamProcedure.PARAM_PROPRIETAIRE_RETOURNE()));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsTarif> SelectTarifByTarifCentreProduit(CsTarif pTarif)
{
try
{
return(Entities.GetEntityListFromQuery <CsTarif>(ParamProcedure.PARAM_TARIFRETOURNEById(pTarif.PK_ID)));
}
catch (Exception ex)
{
throw ex;
}
}
/*
* private string ConnectionString;
*
* public DB_Commune()
* {
* try
* {
* ConnectionString = Session.GetSqlConnexionString();
* }
* catch (Exception ex)
* {
*
* throw ex;
* }
* }
*
* public DB_Commune(string ConnStr)
* {
* ConnectionString = ConnStr;
* }
*
* private SqlConnection cn = null;
*
* private bool _Transaction;
*
* public bool Transaction
* {
* get { return _Transaction; }
* set { _Transaction = value; }
*
* }
*
* private SqlCommand cmd = null;
*
* public List<CsCommune> SelectAllCommune()
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_COMMUNE_RETOURNE"
* };
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsCommune>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw new Exception("SPX_PARAM_COMMUNE_RETOURNE" + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Delete(CsCommune pCommune)
* {
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_COMMUNE_SUPPRIMER"
* };
* cmd.Parameters.Clear();
* //cmd.Parameters.AddWithValue("@CODE", pCommune.PK_COMMUNE);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw new Exception("SPX_PARAM_COMMUNE_SUPPRIMER" + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(List<CsCommune> pCommuneCollection)
* {
* int number = 0;
* foreach (CsCommune entity in pCommuneCollection)
* {
* if (Delete(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public static List<CsCommune> Fill(IDataReader reader, List<CsCommune> rows, int start, int pageLength)
* {
* // advance to the starting row
* for (int i = 0; i < start; i++)
* {
* if (! reader.Read() )
* return rows; // not enough rows, just return
* }
*
* for (int i = 0; i < pageLength; i++)
* {
* if (!reader.Read())
* break; // we are done
*
* var c = new CsCommune();
* //c.PK_COMMUNE = (Convert.IsDBNull(reader["CODE"])) ? string.Empty : (System.String)reader["CODE"];
* c.OriginalCODE = (Convert.IsDBNull(reader["CODE"]))?string.Empty:(System.String)reader["CODE"];
* c.LIBELLE = (Convert.IsDBNull(reader["LIBELLE"])) ? string.Empty : (System.String)reader["LIBELLE"];
* c.USERCREATION = (Convert.IsDBNull(reader["USERCREATION"])) ? string.Empty : (System.String)reader["USERCREATION"];
* c.USERMODIFICATION = (Convert.IsDBNull(reader["USERMODIFICATION"])) ? string.Empty : (System.String)reader["USERMODIFICATION"];
* c.DATECREATION = (Convert.IsDBNull(reader["DATECREATION"])) ? (DateTime?)null : (System.DateTime)reader["DATECREATION"];
* c.DATEMODIFICATION = (Convert.IsDBNull(reader["DATEMODIFICATION"])) ? (DateTime?)null : (System.DateTime)reader["DATEMODIFICATION"];
* rows.Add(c);
* }
* return rows;
* }
*
* public bool Update(CsCommune pCommune)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_COMMUNE_UPDATE"
* };
* cmd.Parameters.Clear();
*
* try
* {
* //cmd.Parameters.AddWithValue("@CODE", pCommune.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pCommune.LIBELLE);
* cmd.Parameters.AddWithValue("@OriginalCODE", pCommune.OriginalCODE);
* cmd.Parameters.AddWithValue("@DATECREATION", pCommune.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pCommune.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pCommune.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pCommune.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Update(List<CsCommune> pCommuneCollection)
* {
* int number = 0;
* foreach (CsCommune entity in pCommuneCollection)
* {
* if (Update(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public bool Insert(CsCommune pCommune)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_COMMUNE_INSERER"
* };
* cmd.Parameters.Clear();
*
* try
* {
* //cmd.Parameters.AddWithValue("@CODE", pCommune.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pCommune.LIBELLE);
* cmd.Parameters.AddWithValue("@DATECREATION", pCommune.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pCommune.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pCommune.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pCommune.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
*
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Insert(List<CsCommune> pCommuneCollection)
* {
* int number = 0;
* foreach (CsCommune entity in pCommuneCollection)
* {
* if (Insert(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private void StartTransaction(SqlConnection _conn)
* {
* if ((_Transaction) && (_conn != null))
* {
* cmd.Transaction = this.BeginTransaction(_conn);
* }
* }
*
* private void CommitTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.Commit(_pSqlTransaction);
* }
* }
*
* private void RollBackTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.RollBack(_pSqlTransaction);
* }
* }
*
*/
public List <CsCommune> SelectAllCommune()
{
try
{
return(Entities.GetEntityListFromQuery <CsCommune>(ParamProcedure.PARAM_COMMUNE_RETOURNE()));
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ObjTACHEDEVIS> GetAll()
{
try
{
return(Entities.GetEntityListFromQuery <ObjTACHEDEVIS>(ParamProcedure.PARAM_TACHEDEVIS_RETOURNE()));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsCtax> GetAll()
{
try
{
return(Entities.GetEntityListFromQuery <CsCtax>(ParamProcedure.PARAM_CTAX_RETOURNE()));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsNotificaton> SelectNotificationByTypeMail(string Code)
{
try
{
return(Entities.GetEntityListFromQuery <CsNotificaton>(ParamProcedure.SelectNotificationByTypeMail(Code)));
}
catch (Exception ex)
{
throw ex;
}
}
public CsCtax GetByCENTRECTAXDEBUTAPPLICATION(CsCtax entity)
{
try
{
return(Entities.GetEntityFromQuery <CsCtax>(ParamProcedure.PARAM_CTAX_RETOURNEById(entity)));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsParametreSMTP> SelectAllSMTP()
{
try
{
return(Entities.GetEntityListFromQuery <CsParametreSMTP>(ParamProcedure.RetourneParametreSMTP()));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsUniteComptage> SelectAllUniteComptage()
{
try
{
return(Entities.GetEntityListFromQuery <CsUniteComptage>(ParamProcedure.PARAM_UNITECOMPTAGE_RETOURNE()));
}
catch (Exception ex)
{
throw ex;
}
}
public CsEntreprise GetById(CsEntreprise entity)
{
try
{
return(Entities.GetEntityFromQuery <CsEntreprise>(ParamProcedure.PARAM_ENTREPRISE_RETOURNEById(entity.PK_ID)));
}
catch (Exception ex)
{
throw ex;
}
}
/*
* private string ConnectionString;
*
* public DB_CategorieBranchement()
* {
* try
* {
* ConnectionString = Session.GetSqlConnexionString();
* }
* catch (Exception ex)
* {
*
* throw ex;
* }
* }
*
* public DB_CategorieBranchement(string ConnStr)
* {
* ConnectionString = ConnStr;
* }
*
* private SqlConnection cn = null;
*
* private bool _Transaction;
*
* public bool Transaction
* {
* get { return _Transaction; }
* set { _Transaction = value; }
*
* }
*
* private SqlCommand cmd = null;
*
* public List<CsCategorieBranchement> SelectAllCategorieBranchement()
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.SelectCATEGORIEBRANCHEMENT
* };
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsCategorieBranchement>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw new Exception(EnumProcedureStockee.SelectCATEGORIEBRANCHEMENT + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Delete(CsCategorieBranchement pCategorieBranchement)
* {
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.DeleteCATEGORIEBRANCHEMENT
* };
* cmd.Parameters.Clear();
* //cmd.Parameters.AddWithValue("@CODE", pCategorieBranchement.CODE);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw new Exception(EnumProcedureStockee.DeleteCATEGORIEBRANCHEMENT+ ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(List<CsCategorieBranchement> pCategorieBranchemenCollection)
* {
* int number = 0;
* foreach (CsCategorieBranchement entity in pCategorieBranchemenCollection)
* {
* if (Delete(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public static List<CsCategorieBranchement> Fill(IDataReader reader, List<CsCategorieBranchement> rows, int start, int pageLength)
* {
* // advance to the starting row
* for (int i = 0; i < start; i++)
* {
* if (! reader.Read() )
* return rows; // not enough rows, just return
* }
*
* for (int i = 0; i < pageLength; i++)
* {
* if (!reader.Read())
* break; // we are done
*
* var c = new CsCategorieBranchement();
* //c.CODE = (Convert.IsDBNull(reader["CODE"]))?string.Empty:(System.String)reader["CODE"];
* //c.OriginalCODE = (Convert.IsDBNull(reader["CODE"]))?string.Empty:(System.String)reader["CODE"];
* c.LIBELLE = (Convert.IsDBNull(reader["LIBELLE"])) ? string.Empty : (System.String)reader["LIBELLE"];
* c.USERCREATION = (Convert.IsDBNull(reader["USERCREATION"])) ? string.Empty : (System.String)reader["USERCREATION"];
* c.USERMODIFICATION = (Convert.IsDBNull(reader["USERMODIFICATION"])) ? string.Empty : (System.String)reader["USERMODIFICATION"];
* c.DATECREATION = (Convert.IsDBNull(reader["DATECREATION"])) ? (DateTime?)null : (System.DateTime)reader["DATECREATION"];
* c.DATEMODIFICATION = (Convert.IsDBNull(reader["DATEMODIFICATION"])) ? (DateTime?)null : (System.DateTime)reader["DATEMODIFICATION"];
* rows.Add(c);
* }
* return rows;
* }
*
* public bool Update(CsCategorieBranchement pCategorieBranchement)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.UpdateCATEGORIEBRANCHEMENT
* };
* cmd.Parameters.Clear();
*
* try
* {
* //cmd.Parameters.AddWithValue("@CODE", pCategorieBranchement.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pCategorieBranchement.LIBELLE);
* //cmd.Parameters.AddWithValue("@OriginalCODE", pCategorieBranchement.OriginalCODE);
* cmd.Parameters.AddWithValue("@DATECREATION", pCategorieBranchement.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pCategorieBranchement.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pCategorieBranchement.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pCategorieBranchement.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Update(List<CsCategorieBranchement> pCategorieBranchementCollection)
* {
* int number = 0;
* foreach (CsCategorieBranchement entity in pCategorieBranchementCollection)
* {
* if (Update(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public bool Insert(CsCategorieBranchement pCategorieBranchement)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.InsertCATEGORIEBRANCHEMENT
* };
* cmd.Parameters.Clear();
*
* try
* {
* //cmd.Parameters.AddWithValue("@CODE", pCategorieBranchement.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pCategorieBranchement.LIBELLE);
* cmd.Parameters.AddWithValue("@DATECREATION", pCategorieBranchement.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pCategorieBranchement.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pCategorieBranchement.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pCategorieBranchement.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
*
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Insert(List<CsCategorieBranchement> pCategorieBranchementCollection)
* {
* int number = 0;
* foreach (CsCategorieBranchement entity in pCategorieBranchementCollection)
* {
* if (Insert(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private void StartTransaction(SqlConnection _conn)
* {
* if ((_Transaction) && (_conn != null))
* {
* cmd.Transaction = this.BeginTransaction(_conn);
* }
* }
*
* private void CommitTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.Commit(_pSqlTransaction);
* }
* }
*
* private void RollBackTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.RollBack(_pSqlTransaction);
* }
* }
*
*/
public List <CsTypeBranchement> SelectAllTypeBranchement()
{
try
{
return(Entities.GetEntityListFromQuery <CsTypeBranchement>(ParamProcedure.PARAM_TYPEBRANCHEMENT_RETOURNE()));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsCentre> SelectCentreBySiteId(int pId)
{
try
{
return(Entities.GetEntityListFromQuery <CsCentre>(ParamProcedure.PARAM_CENTRE_RETOURNEBySiteId(pId)));
}
catch (Exception ex)
{
throw ex;
}
}
/*
* private string ConnectionString;
*
* public DB_Usage()
* {
* try
* {
* ConnectionString = Session.GetSqlConnexionString();
* }
* catch (Exception ex)
* {
*
* throw ex;
* }
* }
*
* public DB_Usage(string ConnStr)
* {
* ConnectionString = ConnStr;
* }
*
* private SqlConnection cn = null;
*
* private bool _Transaction;
*
* public bool Transaction
* {
* get { return _Transaction; }
* set { _Transaction = value; }
*
* }
*
* private SqlCommand cmd = null;
*
* public List<CsUsage> SelectAllUsage()
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.SelectUsage
* };
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsUsage>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw new Exception(EnumProcedureStockee.SelectUsage + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Delete(CsUsage pUsage)
* {
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.DeleteUsage
* };
* cmd.Parameters.Clear();
* //cmd.Parameters.AddWithValue("@ID", pUsage.ID);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw new Exception(EnumProcedureStockee.DeleteUsage + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(List<CsUsage> pUsageCollection)
* {
* int number = 0;
* foreach (CsUsage entity in pUsageCollection)
* {
* if (Delete(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private static List<CsUsage> Fill(IDataReader reader, List<CsUsage> rows, int start, int pageLength)
* {
* // advance to the starting row
* for (int i = 0; i < start; i++)
* {
* if (!reader.Read())
* return rows; // not enough rows, just return
* }
*
* for (int i = 0; i < pageLength; i++)
* {
* if (!reader.Read())
* break; // we are done
*
* var c = new CsUsage
* {
* //ID = (Convert.IsDBNull(reader["ID"])) ? (byte) 0 : (System.Byte) reader["ID"],
* //CODE =
* // (Convert.IsDBNull(reader["CODE"]))
* // ? string.Empty
* // : (System.String) reader["CODE"],
* LIBELLE =
* (Convert.IsDBNull(reader["LIBELLE"]))
* ? null
* : (System.String) reader["LIBELLE"],
* DATECREATION =
* (Convert.IsDBNull(reader["DATECREATION"]))
* ? DateTime.MinValue
* : (System.DateTime) reader["DATECREATION"]
* };
* if (Convert.IsDBNull(reader["DATEMODIFICATION"]))
* c.DATEMODIFICATION = null;
* else
* c.DATEMODIFICATION = (System.DateTime)reader["DATEMODIFICATION"];
* c.USERCREATION = (Convert.IsDBNull(reader["USERCREATION"])) ? string.Empty : (System.String)reader["USERCREATION"];
* c.USERMODIFICATION = (Convert.IsDBNull(reader["USERMODIFICATION"])) ? null : (System.String)reader["USERMODIFICATION"];
* rows.Add(c);
* }
* return rows;
* }
*
* private bool Update(CsUsage pUsage)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.UpdateUsage
* };
* cmd.Parameters.Clear();
*
* try
* {
* //cmd.Parameters.AddWithValue("@ID", pUsage.ID);
* //cmd.Parameters.AddWithValue("@CODE", pUsage.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pUsage.LIBELLE);
* cmd.Parameters.AddWithValue("@DATECREATION", pUsage.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pUsage.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pUsage.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pUsage.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Update(List<CsUsage> pUsageCollection)
* {
* int number = 0;
* foreach (CsUsage entity in pUsageCollection)
* {
* if (Update(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private bool Insert(CsUsage pUsage)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.InsertUsage
* };
* cmd.Parameters.Clear();
*
* try
* {
* //cmd.Parameters.AddWithValue("@CODE", pUsage.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pUsage.LIBELLE);
* cmd.Parameters.AddWithValue("@DATECREATION", pUsage.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pUsage.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pUsage.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pUsage.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
*
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Insert(List<CsUsage> pUsageCollection)
* {
* int number = 0;
* foreach (CsUsage entity in pUsageCollection)
* {
* if (Insert(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private void StartTransaction(SqlConnection _conn)
* {
* if ((_Transaction) && (_conn != null))
* {
* cmd.Transaction = this.BeginTransaction(_conn);
* }
* }
*
* private void CommitTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.Commit(_pSqlTransaction);
* }
* }
*
* private void RollBackTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.RollBack(_pSqlTransaction);
* }
* }
*
*/
public List <CsUsage> SelectAllUsage()
{
try
{
return(Entities.GetEntityListFromQuery <CsUsage>(ParamProcedure.RetourneUsage(null)));
}
catch (Exception ex)
{
throw ex;
}
}
public string SelectLibelleProduit(int IdProduit)
{
try
{
var produit = Entities.GetEntityFromQuery <aBanque>(ParamProcedure.PARAM_PRODUIT_RETOURNEById(IdProduit));
return(produit != null ? produit.LIBELLE : null);
}
catch (Exception ex)
{
throw ex;
}
}
/*
* private string ConnectionString;
*
* public DB_ParametresGeneraux()
* {
* try
* {
* ConnectionString = Session.GetSqlConnexionString();
* }
* catch (Exception ex)
* {
*
* throw ex;
* }
* }
*
* public DB_ParametresGeneraux(string ConnStr)
* {
* ConnectionString = ConnStr;
* }
*
* private SqlConnection cn = null;
*
* private bool _Transaction;
*
* public bool Transaction
* {
* get { return _Transaction; }
* set { _Transaction = value; }
*
* }
*
* private SqlCommand cmd = null;
*
* public List<CsParametresGeneraux> SelectAllParametresGeneraux()
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.SelectPARAMETRESGENRAUX
* };
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsParametresGeneraux>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw new Exception(EnumProcedureStockee.SelectPARAMETRESGENRAUX + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public CsParametresGeneraux SelectParametresGenerauxByCode(string pCode)
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.SelectPARAMETRESGENRAUXByKey
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@CODE", pCode);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsParametresGeneraux>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* if (rows.Count == 1)
* {
* return rows[0];
* }
* else if (rows.Count == 0)
* {
* return null;
* }
* return null;
* }
* catch (Exception ex)
* {
* throw new Exception(EnumProcedureStockee.SelectPARAMETRESGENRAUXByKey + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Delete(CsParametresGeneraux pParametresGeneraux)
* {
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.DeletePARAMETRESGENRAUX
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@CODE", pParametresGeneraux.CODE);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw new Exception(EnumProcedureStockee.DeletePARAMETRESGENRAUX + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(List<CsParametresGeneraux> pParametreGenerauxCollection)
* {
* int number = 0;
* foreach (CsParametresGeneraux entity in pParametreGenerauxCollection)
* {
* if (Delete(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public static List<CsParametresGeneraux> Fill(IDataReader reader, List<CsParametresGeneraux> rows, int start, int pageLength)
* {
* // advance to the starting row
* for (int i = 0; i < start; i++)
* {
* if (! reader.Read() )
* return rows; // not enough rows, just return
* }
*
* for (int i = 0; i < pageLength; i++)
* {
* if (!reader.Read())
* break; // we are done
*
* var c = new CsParametresGeneraux();
* c.CODE = (Convert.IsDBNull(reader["CODE"]))?string.Empty:(System.String)reader["CODE"];
* c.OriginalCODE = (Convert.IsDBNull(reader["CODE"]))?string.Empty:(System.String)reader["CODE"];
* c.LIBELLE = (Convert.IsDBNull(reader["LIBELLE"])) ? string.Empty : (System.String)reader["LIBELLE"];
* c.DESCRIPTION = (Convert.IsDBNull(reader["DESCRIPTION"])) ? null : (System.String)reader["DESCRIPTION"];
* c.USERCREATION = (Convert.IsDBNull(reader["USERCREATION"])) ? string.Empty : (System.String)reader["USERCREATION"];
* c.USERMODIFICATION = (Convert.IsDBNull(reader["USERMODIFICATION"])) ? string.Empty : (System.String)reader["USERMODIFICATION"];
* c.DATECREATION = (Convert.IsDBNull(reader["DATECREATION"])) ? (DateTime?)null : (System.DateTime)reader["DATECREATION"];
* c.DATEMODIFICATION = (Convert.IsDBNull(reader["DATEMODIFICATION"])) ? (DateTime?)null : (System.DateTime)reader["DATEMODIFICATION"];
* rows.Add(c);
* }
* return rows;
* }
*
* public bool Update(CsParametresGeneraux pParametresGeneraux)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.UpdatePARAMETRESGENRAUX
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CODE", pParametresGeneraux.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pParametresGeneraux.LIBELLE);
* cmd.Parameters.AddWithValue("@DESCRIPTION", pParametresGeneraux.DESCRIPTION);
* cmd.Parameters.AddWithValue("@OriginalCODE", pParametresGeneraux.OriginalCODE);
* cmd.Parameters.AddWithValue("@DATECREATION", pParametresGeneraux.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pParametresGeneraux.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pParametresGeneraux.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pParametresGeneraux.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Update(List<CsParametresGeneraux> pParametreGenerauxCollection)
* {
* int number = 0;
* foreach (CsParametresGeneraux entity in pParametreGenerauxCollection)
* {
* if (Update(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public bool Insert(CsParametresGeneraux pParametresGeneraux)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.InsertPARAMETRESGENRAUX
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CODE", pParametresGeneraux.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pParametresGeneraux.LIBELLE);
* cmd.Parameters.AddWithValue("@DESCRIPTION", pParametresGeneraux.DESCRIPTION);
* cmd.Parameters.AddWithValue("@DATECREATION", pParametresGeneraux.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pParametresGeneraux.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pParametresGeneraux.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pParametresGeneraux.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
*
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Insert(List<CsParametresGeneraux> pParametreGenerauxCollection)
* {
* int number = 0;
* foreach (CsParametresGeneraux entity in pParametreGenerauxCollection)
* {
* if (Insert(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private void StartTransaction(SqlConnection _conn)
* {
* if ((_Transaction) && (_conn != null))
* {
* cmd.Transaction = this.BeginTransaction(_conn);
* }
* }
*
* private void CommitTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.Commit(_pSqlTransaction);
* }
* }
*
* private void RollBackTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.RollBack(_pSqlTransaction);
* }
* }
*
*/
public List <CsParametresGeneraux> SelectAllParametresGeneraux()
{
try
{
//return Entities.GetEntityListFromQuery<CsParametresGeneraux>(ParamProcedure.PARAM_PARAMETRESGENERAUX_RETOURNE());
DataTable obj = ParamProcedure.PARAM_PARAMETRESGENERAUX_RETOURNE();
return(Entities.GetEntityListFromQuery <CsParametresGeneraux>(obj));
}
catch (Exception ex)
{
throw ex;
}
}
/*
* private string ConnectionString;
*
* public DB_Centre()
* {
* try
* {
* ConnectionString = Session.GetSqlConnexionString();
* }
* catch (Exception ex)
* {
*
* throw ex;
* }
* }
*
* public DB_Centre(string ConnStr)
* {
* ConnectionString = ConnStr;
* }
*
* private SqlConnection cn = null;
*
* private bool _Transaction;
*
* public bool Transaction
* {
* get { return _Transaction; }
* set { _Transaction = value; }
*
* }
*
* private SqlCommand cmd = null;
*
* public List<CsCentre> SelectAllCentre()
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.SelectCENTRE
* };
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsCentre>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw new Exception(EnumProcedureStockee.SelectCENTRE + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public List<CsCentre> SelectCentreByCodeSite(string pCodeSite)
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_CENTRE_RETOURNEByCODESITE"
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@CODESITE", pCodeSite);
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsCentre>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public CsCentre SelectCentreByCodeSiteCodeCentre(string pCodeSite, string pCodeCentre)
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = "SPX_PARAM_CENTRE_RETOURNEByCodeCentreCODESITE"
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@CodeCentre", pCodeCentre);
* cmd.Parameters.AddWithValue("@CODESITE", pCodeSite);
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsCentre>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows.Count > 0 ? rows[0] : null;
* }
* catch (Exception ex)
* {
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Delete(CsCentre pCentre)
* {
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.DeleteCENTRE
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@CodeCentre", pCentre.PK_CodeCentre);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw new Exception(EnumProcedureStockee.DeleteCENTRE + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(List<CsCentre> pCentreCollection)
* {
* int number = 0;
* foreach (CsCentre entity in pCentreCollection)
* {
* if (Delete(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public static List<CsCentre> Fill(IDataReader reader, List<CsCentre> rows, int start, int pageLength)
* {
* // advance to the starting row
* for (int i = 0; i < start; i++)
* {
* if (! reader.Read() )
* return rows; // not enough rows, just return
* }
*
* for (int i = 0; i < pageLength; i++)
* {
* if (!reader.Read())
* break; // we are done
*
* var c = new CsCentre();
* c.PK_CodeCentre = (Convert.IsDBNull(reader["CodeCentre"])) ? string.Empty : (System.String)reader["CodeCentre"];
* c.OriginalCodeCentre = (Convert.IsDBNull(reader["CodeCentre"])) ? string.Empty : (System.String)reader["CodeCentre"];
* c.Libelle = (Convert.IsDBNull(reader["LIBELLE"])) ? string.Empty : (System.String)reader["LIBELLE"];
* c.CodeType = (Convert.IsDBNull(reader["CodeType"])) ? string.Empty : (System.String)reader["CodeType"];
* c.CodeSite = (Convert.IsDBNull(reader["CodeSite"])) ? string.Empty : (System.String)reader["CodeSite"];
* c.LIBELLESITE = (Convert.IsDBNull(reader["LIBELLESITE"])) ? string.Empty : (System.String)reader["LIBELLESITE"];
* c.LIBELLETYPECENTRE = (Convert.IsDBNull(reader["LIBELLETYPECENTRE"])) ? string.Empty : (System.String)reader["LIBELLETYPECENTRE"];
* c.USERCREATION = (Convert.IsDBNull(reader["USERCREATION"])) ? string.Empty : (System.String)reader["USERCREATION"];
* c.USERMODIFICATION = (Convert.IsDBNull(reader["USERMODIFICATION"])) ? string.Empty : (System.String)reader["USERMODIFICATION"];
* c.DATECREATION = (Convert.IsDBNull(reader["DATECREATION"])) ? (DateTime?)null : (System.DateTime)reader["DATECREATION"];
* c.DATEMODIFICATION = (Convert.IsDBNull(reader["DATEMODIFICATION"])) ? (DateTime?)null : (System.DateTime)reader["DATEMODIFICATION"];
* rows.Add(c);
* }
* return rows;
* }
*
* public bool Update(CsCentre pCentre)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.UpdateCENTRE
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CodeCentre", pCentre.PK_CodeCentre);
* cmd.Parameters.AddWithValue("@OriginalCodeCentre", pCentre.OriginalCodeCentre);
* cmd.Parameters.AddWithValue("@LIBELLE", pCentre.Libelle);
* cmd.Parameters.AddWithValue("@CodeType", pCentre.CodeType);
* cmd.Parameters.AddWithValue("@CodeSite", pCentre.CodeSite);
* cmd.Parameters.AddWithValue("@DATECREATION", pCentre.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pCentre.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pCentre.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pCentre.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Update(List<CsCentre> pCsCentreCollection)
* {
* int number = 0;
* foreach (CsCentre entity in pCsCentreCollection)
* {
* if (Update(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public bool Insert(CsCentre pCentre)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.InsertCENTRE
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CodeCentre", pCentre.PK_CodeCentre);
* cmd.Parameters.AddWithValue("@CodeSite", pCentre.CodeSite);
* cmd.Parameters.AddWithValue("@CODETYPE", pCentre.CodeType);
* cmd.Parameters.AddWithValue("@LIBELLE", pCentre.Libelle);
* cmd.Parameters.AddWithValue("@DATECREATION", pCentre.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pCentre.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pCentre.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pCentre.USERMODIFICATION);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* StartTransaction(cn);
*
* SetDBNullParametre(cmd.Parameters);
* int rowsAffected = cmd.ExecuteNonQuery();
* CommitTransaction(cmd.Transaction);
* return Convert.ToBoolean(rowsAffected);
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw ex;
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Insert(List<CsCentre> pCentreCollection)
* {
* int number = 0;
* foreach (CsCentre entity in pCentreCollection)
* {
* if (Insert(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private void StartTransaction(SqlConnection _conn)
* {
* if ((_Transaction) && (_conn != null))
* {
* cmd.Transaction = this.BeginTransaction(_conn);
* }
* }
*
* private void CommitTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.Commit(_pSqlTransaction);
* }
* }
*
* private void RollBackTransaction(SqlTransaction _pSqlTransaction)
* {
* if ((_Transaction) && (_pSqlTransaction != null))
* {
* this.RollBack(_pSqlTransaction);
* }
* }
*
*/
public List <CsCentre> SelectAllCentre()
{
try
{
List <CsCentre> lstCentre = Entities.GetEntityListFromQuery <CsCentre>(ParamProcedure.PARAM_CENTRE_RETOURNE());
List <CsProduit> lstProduitCentre = Entities.GetEntityListFromQuery <CsProduit>(ParamProcedure.PARAM_PRODUIT_CENTRE());
foreach (CsCentre item in lstCentre)
{
item.LESPRODUITSDUSITE = lstProduitCentre.Where(t => t.FK_IDCENTRE == item.PK_ID).ToList();
}
return(lstCentre);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Update(List <CsCentre> pCsCentreCollection)
{
try
{
galadbEntities ctx = new galadbEntities();
int result = -1;
foreach (CsCentre item in pCsCentreCollection)
{
List <int> lstIdCentreInit = new List <int>();
List <int> lstIdProduitAnc = new List <int>();
List <int> lstIdProduitNouv = new List <int>();
List <int> lstIdProduitAJouter = new List <int>();
List <int> lstIdProduitSupprimer = new List <int>();
List <int> lstIdProduitNonModifier = new List <int>();
List <PRODUITCENTRE> lstProduitAsupp = new List <PRODUITCENTRE>();
List <PRODUITCENTRE> lstProduitAjout = new List <PRODUITCENTRE>();
List <CsProduit> lstProduitCentre = Entities.GetEntityListFromQuery <CsProduit>(ParamProcedure.PARAM_PRODUIT_CENTRE(item.PK_ID));
foreach (CsProduit items in lstProduitCentre)
{
lstIdProduitAnc.Add(items.FK_IDPRODUIT);
}
foreach (CsProduit items in item.LESPRODUITSDUSITE)
{
lstIdProduitNouv.Add(items.FK_IDPRODUIT);
}
lstIdProduitAJouter = lstIdProduitNouv.Where(t => !lstIdProduitAnc.Contains(t)).ToList();
lstProduitAjout = Entities.ConvertObject <Galatee.Entity.Model.PRODUITCENTRE, CsProduit>(item.LESPRODUITSDUSITE.Where(t => lstIdProduitAJouter.Contains(t.FK_IDPRODUIT)).ToList());
// Supprimer
lstIdProduitSupprimer = lstIdProduitAnc.Where(t => !lstIdProduitNouv.Contains(t)).ToList();
lstProduitAsupp = Entities.ConvertObject <Galatee.Entity.Model.PRODUITCENTRE, CsProduit>(lstProduitCentre.Where(t => lstIdProduitSupprimer.Contains(t.FK_IDPRODUIT)).ToList());
lstProduitAsupp.ForEach(t => t.DATEFIN = System.DateTime.Today);
//
CENTRE leCentre = new CENTRE();
leCentre = Entities.ConvertObject <Galatee.Entity.Model.CENTRE, CsCentre>(item);
Entities.UpdateEntity <Galatee.Entity.Model.CENTRE>(leCentre, ctx);
if (lstProduitAsupp != null && lstProduitAsupp.Count != 0)
{
Entities.UpdateEntity <Galatee.Entity.Model.PRODUITCENTRE>(lstProduitAsupp, ctx);
}
if (lstProduitAjout != null && lstProduitAjout.Count != 0)
{
Entities.InsertEntity <Galatee.Entity.Model.PRODUITCENTRE>(lstProduitAjout, ctx);
}
}
result = ctx.SaveChanges();
return(result == -1 ? false : true);
}
catch (Exception ex)
{
throw ex;
}
}
