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); } } }