public static void OnAfterUpdateStep(IAddress address)
{
using (var session = new SessionScopeWrapper(false))
{
//обновить контакты
CommonProcedures.UpdateAccountContacts(address.EntityId, session);
}
}
public static void OnBeforeDeleteStep(IAccContactInfo contact, ISession session)
{
if (contact == null)
{
return;
}
// обновить контакты
CommonProcedures.UpdateAccountContacts(contact.AccountId, session);
}
/*
* /// <summary>
* /// DB_BANQUES2
* /// </summary>
* public DB_BANQUES()
* {
* ConnectionString = Session.GetSqlConnexionString();
* }
* /// <summary>
* /// DB_BANQUES2
* /// </summary>
* /// <param name="ConnStr"></param>
* public DB_BANQUES(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;
*
#region Méthodes de mise à jour de la table BANQUE dans GALADB2
*
* public List<aBanque> SelectAllBanque()
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.SelectBANQUE
* };
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<aBanque>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw new Exception(EnumProcedureStockee.SelectBANQUE + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public bool Delete(aBanque pBanque)
* {
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.DeleteBANQUE
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@BANQUE", pBanque.BANQUE);
* cmd.Parameters.AddWithValue("@GUICHET", pBanque.GUICHET);
* 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.DeleteBANQUE + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(List<aBanque> pBanqueCollection)
* {
* int number = 0;
* foreach (aBanque entity in pBanqueCollection)
* {
* if (Delete(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private bool Update(aBanque pBanque)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.UpdateBANQUE
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@BANQUE", pBanque.BANQUE);
* cmd.Parameters.AddWithValue("@OriginalBANQUE", pBanque.OriginalBANQUE);
* cmd.Parameters.AddWithValue("@GUICHET", pBanque.GUICHET);
* cmd.Parameters.AddWithValue("@OriginalGUICHET", pBanque.OriginalGUICHET);
* cmd.Parameters.AddWithValue("@LIBELLE", pBanque.LIBELLE);
* cmd.Parameters.AddWithValue("@TRANS", pBanque.TRANS);
* cmd.Parameters.AddWithValue("@BANQUEMERE", pBanque.BANQUEMERE);
* cmd.Parameters.AddWithValue("@COMPTE", pBanque.COMPTE);
* cmd.Parameters.AddWithValue("@DATECREATION", pBanque.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pBanque.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pBanque.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pBanque.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<aBanque> pBanqueCollection)
* {
* int number = 0;
* foreach (aBanque entity in pBanqueCollection)
* {
* if (Update(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* private bool Insert(aBanque pBanque)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.InsertBANQUE
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@BANQUE", pBanque.BANQUE);
* cmd.Parameters.AddWithValue("@GUICHET", pBanque.GUICHET);
* cmd.Parameters.AddWithValue("@LIBELLE", pBanque.LIBELLE);
* cmd.Parameters.AddWithValue("@TRANS", pBanque.TRANS);
* cmd.Parameters.AddWithValue("@BANQUEMERE", pBanque.BANQUEMERE);
* cmd.Parameters.AddWithValue("@COMPTE", pBanque.COMPTE);
* cmd.Parameters.AddWithValue("@DATECREATION", pBanque.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pBanque.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pBanque.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pBanque.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<aBanque> pBanqueCollection)
* {
* int number = 0;
* foreach (aBanque entity in pBanqueCollection)
* {
* if (Insert(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public static List<aBanque> Fill(IDataReader reader, List<aBanque> 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
*
* aBanque c = new aBanque();
* c.BANQUE = (Convert.IsDBNull(reader["BANQUE"])) ? string.Empty : (System.String)reader["BANQUE"];
* c.OriginalBANQUE = (Convert.IsDBNull(reader["BANQUE"])) ? string.Empty : (System.String)reader["BANQUE"];
* c.GUICHET = (Convert.IsDBNull(reader["GUICHET"])) ? string.Empty : (System.String)reader["GUICHET"];
* c.OriginalGUICHET = (Convert.IsDBNull(reader["GUICHET"])) ? string.Empty : (System.String)reader["GUICHET"];
* c.LIBELLE = (Convert.IsDBNull(reader["LIBELLE"])) ? string.Empty : (System.String)reader["LIBELLE"];
* c.TRANS = (Convert.IsDBNull(reader["TRANS"])) ? null : (System.String)reader["TRANS"];
* c.BANQUEMERE = (Convert.IsDBNull(reader["BANQUEMERE"])) ? null : (System.String)reader["BANQUEMERE"];
* c.COMPTE = (Convert.IsDBNull(reader["COMPTE"])) ? null : (System.String)reader["COMPTE"];
* c.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;
* }
*
* /// <summary>
* /// SelectAll_BANQUE
* /// </summary>
* /// <returns></returns>
* public DataSet SelectAll_BANQUE()
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand();
* cmd.Connection = cn;
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.CommandText = EnumProcedureStockee.SelectBANQUE2;
*
* try
* {
* StartTransaction(cn);
*
* if (cn.State == ConnectionState.Closed)
* cn.Open();
*
* SqlDataAdapter adapter = new SqlDataAdapter();
* adapter.SelectCommand = cmd;
* DataSet ds = new DataSet();
* adapter.Fill(ds);
*
* CommitTransaction(cmd.Transaction);
*
* return ds;
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw new Exception(EnumProcedureStockee.SelectBANQUE2 + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
*
* }
* }
* /// <summary>
* /// Delete_BANQUE
* /// </summary>
* /// <param name="Centre"></param>
* /// <param name="Banque"></param>
* /// <param name="Guichet"></param>
* public void Delete_BANQUE(string Centre, string Banque, string Guichet)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand();
* cmd.Connection = cn;
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.CommandText =EnumProcedureStockee.DeleteBANQUE2;
* cmd.Parameters.Clear();
*
* cmd.Parameters.Add("@CENTRE", SqlDbType.VarChar).Value = Centre;
* cmd.Parameters.Add("@BANQUE", SqlDbType.VarChar).Value = Banque;
* cmd.Parameters.Add("@GUICHET", SqlDbType.VarChar).Value = Guichet;
*
*
* 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.DeleteBANQUE2 + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
* /// <summary>
* /// MiseAJour_BANQUE
* /// </summary>
* /// <param name="row"></param>
* public void MiseAJour_BANQUE(List<aBanque> rows)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand();
* cmd.Connection = cn;
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.CommandText = EnumProcedureStockee.UpdateBANQUE2.Trim();
*
*
* cmd.Parameters.Clear();
*
* try
* {
* foreach (aBanque row in rows)
* {
* cmd.Parameters.Clear();
*
* cmd.Parameters.Add("@CENTRE", SqlDbType.VarChar).Value = row.CENTRE;
* cmd.Parameters.Add("@BANQUE", SqlDbType.VarChar).Value = row.BANQUE;
* cmd.Parameters.Add("@GUICHET", SqlDbType.VarChar).Value = row.GUICHET;
* cmd.Parameters.Add("@LIBELLE", SqlDbType.VarChar).Value = row.LIBELLE;
* cmd.Parameters.Add("@DMAJ", SqlDbType.DateTime).Value = row.DMAJB;
* cmd.Parameters.Add("@TRANS", SqlDbType.VarChar).Value = row.TRANS;
* cmd.Parameters.Add("@BANQUEMERE", SqlDbType.VarChar).Value = row.BANQUEMERE;
* cmd.Parameters.Add("@COMPTE", SqlDbType.VarChar).Value = row.COMPTE;
* 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.UpdateBANQUE2 + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
* /// <summary>
* /// Insertion_BANQUE
* /// </summary>
* /// <param name="row"></param>
* public void Insertion_BANQUE(List<aBanque> rows)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand();
* cmd.Connection = cn;
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.CommandText = EnumProcedureStockee.InsertBANQUE2.Trim();
*
*
* try
* {
* foreach (aBanque row in rows)
* {
* cmd.Parameters.Clear();
*
* cmd.Parameters.Add("@CENTRE", SqlDbType.VarChar).Value = row.CENTRE;
* cmd.Parameters.Add("@BANQUE", SqlDbType.VarChar).Value = row.BANQUE;
* cmd.Parameters.Add("@GUICHET", SqlDbType.VarChar).Value = row.GUICHET;
* cmd.Parameters.Add("@LIBELLE", SqlDbType.VarChar).Value = row.LIBELLE;
* cmd.Parameters.Add("@DMAJ", SqlDbType.DateTime).Value = row.DMAJB;
* cmd.Parameters.Add("@TRANS", SqlDbType.VarChar).Value = row.TRANS;
* cmd.Parameters.Add("@BANQUEMERE", SqlDbType.VarChar).Value = row.BANQUEMERE;
* cmd.Parameters.Add("@COMPTE", SqlDbType.VarChar).Value = row.COMPTE;
*
* 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.InsertBANQUE2 + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
* /// <summary>
* /// Testunicite_BANQUE
* /// </summary>
* /// <param name="Centre"></param>
* /// <param name="Banque"></param>
* /// <param name="Guichet"></param>
* /// <returns></returns>
* public bool Testunicite_BANQUE(string Centre, string Banque, string Guichet)
* {
* bool Result = false;
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand();
* cmd.Connection = cn;
* cmd.CommandType = CommandType.StoredProcedure;
* cmd.CommandText = EnumProcedureStockee.SelectBANQUE2ByKey.Trim();
* cmd.Parameters.Clear();
*
* cmd.Parameters.Add("@CENTRE", SqlDbType.VarChar).Value = Centre;
* cmd.Parameters.Add("@BANQUE", SqlDbType.VarChar).Value = Banque;
* cmd.Parameters.Add("@GUICHET", SqlDbType.VarChar).Value = Guichet;
*
*
*
* 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;
* }
*
*
*
* /// <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);
* }
*
* }
*
#endregion
*
*/
public List <aBanque> SelectAllBanque()
{
try
{
return(Entities.GetEntityListFromQuery <aBanque>(CommonProcedures.RetourneTousBanques()));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsAppareils> SelectAllAppareils()
{
try
{
return(Entities.GetEntityListFromQuery <CsAppareils>(CommonProcedures.RetourneTousAppareils()));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsCaisse> SelectAllCaisse()
{
try
{
return(Entities.GetEntityListFromQuery <CsCaisse>(CommonProcedures.RetourneTousCaisse()));
}
catch (Exception ex)
{
throw ex;
}
}
/*
* private string ConnectionString;
*
* public DB_CategorieClient()
* {
* try
* {
* ConnectionString = Session.GetSqlConnexionString();
* }
* catch (Exception ex)
* {
*
* throw ex;
* }
* }
*
* public DB_CategorieClient(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<CsCategorieClient> SelectAllCategorieClient()
* {
* cn = new SqlConnection(ConnectionString);
* try
* {
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.SelectCATEGORIECLIENT
* };
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsCategorieClient>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* return rows;
* }
* catch (Exception ex)
* {
* throw new Exception(EnumProcedureStockee.SelectCATEGORIECLIENT + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close(); // Fermeture de la connection
* cmd.Dispose();
* }
* }
*
* public CsCategorieClient SelectCategorieClientByCode(string pCategorieClient)
* {
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.SelectCATEGORIECLIENTByKey
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@CODE", pCategorieClient);
* if (cn.State == ConnectionState.Closed)
* cn.Open();
* IDataReader reader = cmd.ExecuteReader();
* var rows = new List<CsCategorieClient>();
* Fill(reader, rows, int.MinValue, int.MaxValue);
* reader.Close();
* if (rows.Count == 0)
* return null;
* else
* return rows[0];
* }
* catch (Exception ex)
* {
* RollBackTransaction(cmd.Transaction);
* throw new Exception(EnumProcedureStockee.SelectCATEGORIECLIENTByKey + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(CsCategorieClient pCategorieClient)
* {
* try
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.DeleteCATEGORIECLIENT
* };
* cmd.Parameters.Clear();
* cmd.Parameters.AddWithValue("@CODE", pCategorieClient.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.DeleteCATEGORIECLIENT + ":" + ex.Message);
* }
* finally
* {
* if (cn.State == ConnectionState.Open)
* cn.Close();
* cmd.Dispose();
* }
* }
*
* public bool Delete(List<CsCategorieClient> pCategorieClientCollection)
* {
* int number = 0;
* foreach (CsCategorieClient entity in pCategorieClientCollection)
* {
* if (Delete(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public static List<CsCategorieClient> Fill(IDataReader reader, List<CsCategorieClient> 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 CsCategorieClient();
* 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(CsCategorieClient pCategorieClient)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.UpdateCATEGORIECLIENT
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CODE", pCategorieClient.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pCategorieClient.LIBELLE);
* cmd.Parameters.AddWithValue("@OriginalCODE", pCategorieClient.OriginalCODE);
* cmd.Parameters.AddWithValue("@DATECREATION", pCategorieClient.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pCategorieClient.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pCategorieClient.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pCategorieClient.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<CsCategorieClient> pCategorieClientCollection)
* {
* int number = 0;
* foreach (CsCategorieClient entity in pCategorieClientCollection)
* {
* if (Update(entity))
* {
* number++;
* }
* }
* return number != 0;
* }
*
* public bool Insert(CsCategorieClient pCategorieClient)
* {
* cn = new SqlConnection(ConnectionString);
* cmd = new SqlCommand
* {
* Connection = cn,
* CommandType = CommandType.StoredProcedure,
* CommandText = EnumProcedureStockee.InsertCATEGORIECLIENT
* };
* cmd.Parameters.Clear();
*
* try
* {
* cmd.Parameters.AddWithValue("@CODE", pCategorieClient.CODE);
* cmd.Parameters.AddWithValue("@LIBELLE", pCategorieClient.LIBELLE);
* cmd.Parameters.AddWithValue("@DATECREATION", pCategorieClient.DATECREATION);
* cmd.Parameters.AddWithValue("@DATEMODIFICATION", pCategorieClient.DATEMODIFICATION);
* cmd.Parameters.AddWithValue("@USERCREATION", pCategorieClient.USERCREATION);
* cmd.Parameters.AddWithValue("@USERMODIFICATION", pCategorieClient.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<CsCategorieClient> pCategorieClientCollection)
* {
* int number = 0;
* foreach (CsCategorieClient entity in pCategorieClientCollection)
* {
* 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 <CsCategorieClient> SelectAllCategorieClient()
{
try
{
return(Entities.GetEntityListFromQuery <CsCategorieClient>(CommonProcedures.RetourneCategorieClient()));
}
catch (Exception ex)
{
throw ex;
}
}
public List <CsTdem> SelectAllTdem()
{
try
{
return(Entities.GetEntityListFromQuery <CsTdem>(CommonProcedures.RetourneTousTDEM()));
}
catch (Exception ex)
{
throw ex;
}
}
public static void OnAfterDelete(IAccNewsletter accnewsletter)
{
using (var session = new SessionScopeWrapper())
{
// обновить контакты
if (accnewsletter.AccContactInfo != null)
{
CommonProcedures.UpdateAccountContacts(accnewsletter.AccContactInfo.AccountId, session);
}
}
}
public CsEntreprise GetAll()
{
try
{
return(Entities.GetEntityFromQuery <CsEntreprise>(CommonProcedures.RetourneInformationsEntreprise()));
}
catch (Exception ex)
{
throw ex;
}
}
public static void OnBeforeInsertStep(IAccContactInfo contact, ISession session)
{
if (contact == null && contact.IsMain == false && contact.Account == null && contact.ContactType == null)
{
return;
}
EnsureContactPrimary(contact, session);
// обновить контакты
CommonProcedures.UpdateAccountContacts(contact.AccountId, session);
}
public static void OnAfterInsertStep(IAccNewsletter accnewsletter)
{
accnewsletter.UnsetAllMain();
//accnewsletter.CheckAccContactInfo();
using (var session = new SessionScopeWrapper())
{
// обновить контакты
if (accnewsletter.AccContactInfo != null)
{
CommonProcedures.UpdateAccountContacts(accnewsletter.AccContactInfo.AccountId, session);
}
}
}
public List <CParametre> ChargerTypeFacturation()
{
try
{
List <CParametre> typeFacturation = new List <CParametre>();
DataTable dtType = CommonProcedures.RetourneTousTypefacturation();
typeFacturation.AddRange(Entities.GetEntityListFromQuery <CParametre>(dtType));
return(typeFacturation);
}
catch (Exception ex)
{
throw ex;
}
}
private static void UpdateRelatedEntity(IAddress address, ISession session)
{
if (address != null && !string.IsNullOrEmpty(address.EntityId))
{
if (address.EntityId.StartsWith("A", StringComparison.Ordinal))
{
// обновить контакты
CommonProcedures.UpdateAccountContacts(address.EntityId, session);
return;
}
if (address.EntityId.StartsWith("C", StringComparison.Ordinal))
{
// обновить контакты
CommonProcedures.UpdateAccountContacts(address.EntityId, session);
}
}
}
