public int ExecuteCommandTransaction(string command, System.Data.IsolationLevel IsolationLevel, params object[] parameters) { if (this.Database.Connection.State != System.Data.ConnectionState.Open) { this.Database.Connection.Open(); } using (System.Data.Common.DbTransaction dbTrans = this.Database.Connection.BeginTransaction(IsolationLevel)) { this.Database.UseTransaction(dbTrans); try { int rt = this.Database.ExecuteSqlCommand(command, parameters); if (rt > 0) { dbTrans.Commit(); } else { dbTrans.Rollback(); } return(rt); } catch (Exception ex) { dbTrans.Rollback(); throw ex; } } }
public static void DeleteWorkZone(int WorkZoneID) { using (DBContext db = new DBContext()) { using (System.Data.Common.DbTransaction tran = db.UseTransaction()) { try { WorkZone wz = new WorkZone(); wz.WorkZoneId = WorkZoneID; wz.Delete(); List <WorkZoneDetail> listWZD = WorkZoneDetail.GetWorkZoneDetailByWorkZoneID(WorkZoneID); foreach (WorkZoneDetail wzd in listWZD) { wzd.Delete(); } List <DetailProblem> listProblem = DetailProblem.GetAllDetailProblem(WorkZoneID); foreach (DetailProblem p in listProblem) { p.Delete(); } } catch (Exception e) { tran.Rollback(); logger.Error("Error DeleteWorkZone", e); throw e; } } } }
public void CreateUploadMessages(BO.ORCID.Person person, string loggedInInternalUsername) { // Before opening the transaction get the 'read limited' token if it exists. // if it does not exist or is expired we will create a message to update it. BO.ORCID.PersonToken personToken = new BLL.ORCID.PersonToken().GetByPersonIDAndPermissionID(person.PersonID, (int)BO.ORCID.REFPermission.REFPermissions.orcid_profile_read_limited); using (System.Data.Common.DbTransaction trans = base.GetEditTransaction()) { try { new ProfilesRNSDLL.BLL.ORCID.Person().Edit(person, trans); if (!personToken.Exists || personToken.IsExpired) { CreateMessageToReadLimited(person, trans); } if (person.PushBiographyToORCID || (person.HasURLsToPush)) { CreateBioUpdateMessage(person, trans, loggedInInternalUsername); } WorksUpdate(person, trans); AffiliationsUpdate(person, trans); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw ErrorLog.LogError(ex, loggedInInternalUsername, "An error occurred while generating the messages to send to ORCID."); } } }
/// <summary> /// Rollback a started transaction. /// </summary> public void Rollback() { if (!IsStarted) { throw new TransactionException("The transaction is not started. Call the Begin method to start the transaction."); } IDisposable tx = TransactionManager.Instance.GetTransaction(this) as IDisposable; if (tx is System.Data.Common.DbTransaction) { System.Data.Common.DbTransaction dbTx = tx as System.Data.Common.DbTransaction; // Close the connection associated with the transaction after the rollback using (System.Data.Common.DbConnection connection = dbTx.Connection) { dbTx.Rollback(); } } else { if (tx is CommittableTransaction) { CommittableTransaction commitableTx = tx as CommittableTransaction; commitableTx.Rollback(); } } TransactionState = TransactionState.Aborted; TransactionManager.Instance.StopTransaction(this); }
public bool UpdateGeneric <T>(List <T> entity) where T : class { _cntxt = new DataContext(_connStr); System.Data.Common.DbTransaction tran = null; try { if (_cntxt.Connection.State == System.Data.ConnectionState.Closed) { _cntxt.Connection.Open(); } tran = _cntxt.Connection.BeginTransaction(); _cntxt.Transaction = tran; _cntxt.GetTable <T>().AttachAll <T>(entity); _cntxt.Refresh(RefreshMode.KeepCurrentValues, entity); _cntxt.SubmitChanges(); tran.Commit(); _cntxt.Connection.Close(); return(true); } catch (Exception e) { tran.Rollback(); _cntxt.Connection.Close(); DBEvents.LogException(e, "UpdateGeneric<T>(List<T> entity)", 0); return(false); } }
/// <summary> /// 事务处理多条多条操作 /// </summary> /// <param name="sqls"></param> /// <returns></returns> public override int TransactionExecute(string[] sqls) { int affectedRows = 0; System.Data.Common.DbTransaction transation = Connection.BeginTransaction(); try { using (SQLiteCommand command = new SQLiteCommand()) { command.Connection = Connection; for (int i = 0; i < sqls.Length; i++) { command.CommandText = sqls[i]; affectedRows = command.ExecuteNonQuery(); } transation.Commit(); } } catch (Exception) { transation.Rollback(); throw; } finally { Connection.Close(); } return(affectedRows); }
public static int TransactionUpLoad(WorkZone WZ, List <WorkZoneDetail> listWZD) { int idz = 0; using (DBContext db = new DBContext()) { using (System.Data.Common.DbTransaction tran = db.UseTransaction()) { try { idz = InsertWorkZoneWithID(WZ); int nextDetailId = 1; foreach (WorkZoneDetail wzd in listWZD) { wzd.WorkZoneId = idz; wzd.WorkZoneDetailId = nextDetailId++; wzd.Insert(); } return(idz); } catch (Exception e) { tran.Rollback(); if (idz != 0) { WZ.Delete(); } logger.Error("Error Transaction", e); throw e; } } } }
/// <summary> /// 桌面栏目设置保存 /// </summary> /// <param name="portalcolumnnumbers"></param> /// <param name="customerID"></param> public void SavePortalColumnsNumber(List <PortalColumnNumber> portalcolumnnumbers, int customerID) { System.Data.Common.DbTransaction tran = null; try { this._context.Connection.Open(); tran = this._context.Connection.BeginTransaction(); string sql = "DELETE Sys_PortalColumnNumber WHERE customerID='" + customerID.ToString() + "'"; this._context.ExecuteStoreCommand(sql); foreach (var item in portalcolumnnumbers) { _context.PortalColumnNumbers.AddObject(item); } _context.SaveChanges(); tran.Commit(); } catch (Exception err) { if (tran != null) { tran.Rollback(); } throw err; } finally { if (this._context != null && this._context.Connection.State != System.Data.ConnectionState.Closed) { this._context.Connection.Close(); } } }
public static bool SendClaimCodesList(CouponItemInfo couponItemInfo, int count) { bool result = false; Database database = DatabaseFactory.CreateDatabase(); using (System.Data.Common.DbConnection dbConnection = database.CreateConnection()) { dbConnection.Open(); System.Data.Common.DbTransaction dbTransaction = dbConnection.BeginTransaction(); try { for (int i = 0; i < count; i++) { new CouponDao().SendClaimCodes(couponItemInfo, dbTransaction); } } catch { dbTransaction.Rollback(); result = false; } finally { dbConnection.Close(); } result = true; } return(result); }
public static bool SendClaimCodes(IList <CouponItemInfo> listCouponItem) { bool Flag = false; Database database = DatabaseFactory.CreateDatabase(); using (System.Data.Common.DbConnection dbCon = database.CreateConnection()) { dbCon.Open(); System.Data.Common.DbTransaction dbTran = dbCon.BeginTransaction(); try { new CouponDao().SendClaimCodesByTran(listCouponItem, dbTran); } catch { dbTran.Rollback(); Flag = false; } finally { dbCon.Close(); } Flag = true; } return(Flag); }
public ReturnType AddStockUnitGroup(StockUnitGroup stockunitgroup, StockUnit unit) { System.Data.Common.DbTransaction tran = null; using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { try { alading.Connection.Open(); tran = alading.Connection.BeginTransaction(); alading.AddToStockUnitGroup(stockunitgroup); alading.AddToStockUnit(unit); alading.SaveChanges(); tran.Commit(); return(ReturnType.Success); } catch (System.Exception ex) { if (tran != null) { tran.Rollback(); } return(ReturnType.SaveFailed); } finally { if (alading != null && alading.Connection.State != System.Data.ConnectionState.Closed) { alading.Connection.Close(); } } } }
public static void ExecuteNonQuery(System.Data.IDbCommand cmd) { using (System.Data.Common.DbConnection conn = GetConnection()) { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } cmd.Connection = conn; using (System.Data.Common.DbTransaction transact = conn.BeginTransaction()) { cmd.Transaction = transact; try { cmd.ExecuteNonQuery(); transact.Commit(); } // End Try catch (System.Exception) { transact.Rollback(); throw; } // End Catch finally { if (conn.State != System.Data.ConnectionState.Closed) { conn.Close(); } } // End Finally } // End Using transact } // End Using conn } // End Sub
/// <summary> /// Dispose the transaction and close the connection associated with a DbTransaction. /// </summary> internal void End() { IDisposable tx = TransactionManager.Instance.GetTransaction(this); IsStarted = false; if (tx != null) { using (tx) { System.Data.Common.DbTransaction dbTx = tx as System.Data.Common.DbTransaction; if (dbTx != null && dbTx.Connection != null) { // Rollback and close the associated connection. using (System.Data.Common.DbConnection connection = dbTx.Connection) { dbTx.Rollback(); TransactionState = TransactionState.Aborted; } } } } // The transaction was ended and a Commit or Rollback was not called if (TransactionState == TransactionState.Active) { TransactionState = TransactionState.Unknown; } }
public ReturnType AddInOutAndDetails(StockInOut stockInOut, PayCharge payChage, List <StockDetail> sdList, List <StockHouseProduct> shpList, List <View_StockItemProduct> vsipList) { System.Data.Common.DbTransaction tran = null; using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { try { alading.Connection.Open(); tran = alading.Connection.BeginTransaction(); alading.AddToPayCharge(payChage); alading.AddToStockInOut(stockInOut); foreach (StockDetail sd in sdList) { alading.AddToStockDetail(sd); } foreach (StockHouseProduct shp in shpList) { StockHouseProduct tmpshp = alading.StockHouseProduct.FirstOrDefault(c => c.HouseProductCode == shp.HouseProductCode); if (tmpshp != null) { tmpshp.Num = shp.Num; } else { alading.AddToStockHouseProduct(shp); } } foreach (View_StockItemProduct vsip in vsipList) { StockItem stockItem = alading.StockItem.FirstOrDefault(s => s.OuterID == vsip.OuterID); StockProduct stockProduct = alading.StockProduct.FirstOrDefault(s => s.SkuOuterID == vsip.SkuOuterID); stockItem.TotalQuantity = Math.Round(vsip.TotalQuantity, 3); stockProduct.SkuQuantity = vsip.SkuQuantity; stockProduct.LastStockPrice = vsip.LastStockPrice; stockProduct.AvgStockPrice = vsip.AvgStockPrice; } alading.SaveChanges(); tran.Commit(); return(ReturnType.Success); } catch (System.Exception ex) { if (tran != null) { tran.Rollback(); } return(ReturnType.SaveFailed); } finally { if (alading != null && alading.Connection.State != System.Data.ConnectionState.Closed) { alading.Connection.Close(); } } } }
private void BtnStart_Click(object sender, EventArgs e) { try { if (!checke1 || !checke2) { MessageBox.Show("请先检查出差方案,请重试"); return; } var dr = MessageBox.Show("确认开始吗?请提前备份好数据再开始", "确认", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { if (dal.Connection.State == System.Data.ConnectionState.Closed) { dal.Connection.Open(); } tran = dal.Connection.BeginTransaction(); string strSourceSolutionId = labelFromSolutionId.Text; string strToSolutionId = labelToSolutionID.Text; var areaAll = (from ent in dal.T_OA_AREADIFFERENCE.Include("T_OA_TRAVELSOLUTIONS") where ent.T_OA_TRAVELSOLUTIONS.TRAVELSOLUTIONSID == strSourceSolutionId //神州通集团出差方案 select ent).ToList(); var solutionitem = (from ent in dal.T_OA_TRAVELSOLUTIONS where ent.TRAVELSOLUTIONSID == strToSolutionId select ent).FirstOrDefault(); //复制城市分类 foreach (var area in areaAll) { StarCopy(solutionitem, area, strSourceSolutionId); } dal.SaveChanges(); tran.Commit(); } } catch (Exception ex) { tran.Rollback(); MessageBox.Show(ex.ToString()); } }
public void Rollback() { foreach (IDbTransactionObserver observer in _observers) { observer.BeforeRollback(); } _innerTransaction.Rollback(); foreach (IDbTransactionObserver observer in _observers) { observer.AfterRollback(); } }
public bool DeleteGeneric <T>(List <T> entity) where T : class { bool sonuc = false; _cntxt = new DataContext(_connStr); System.Data.Common.DbTransaction tran = null; try { if (_cntxt.Connection.State == System.Data.ConnectionState.Closed) { _cntxt.Connection.Open(); } tran = _cntxt.Connection.BeginTransaction(); _cntxt.Transaction = tran; var Table = _cntxt.GetTable <T>(); foreach (T kayit in entity) { Table.Attach(kayit); Table.DeleteOnSubmit(kayit); _cntxt.SubmitChanges(); } sonuc = true; tran.Commit(); _cntxt.Connection.Close(); } catch (Exception exp) { tran.Rollback(); _cntxt.Connection.Close(); try { StackTrace stackTrace = new StackTrace(); MethodBase methodBase = stackTrace.GetFrame(1).GetMethod(); LogException(exp, "DeleteGeneric<T>(List<T> entity) in " + methodBase.ReflectedType.Name + "." + methodBase.Name, 0); } catch { } sonuc = false; } finally { if (_cntxt.Connection.State == System.Data.ConnectionState.Open) { _cntxt.Connection.Close(); } } return(sonuc); }
protected void registerButton_Click(object sender, EventArgs e) { if (usernameTextBox.Text.Trim().Length == 0) { registerErrorLabel.Text = "Username empty"; } else { var user = from u in entities.Users where u.Username == usernameTextBox.Text select u; if (user.Count() != 0) { registerErrorLabel.Text = "Username taken"; } else { if (passwordTextBox.Text.Trim().Length == 0) { registerErrorLabel.Text = "Password empty"; } else { PicChatDBEntities1 transac_entities = new PicChatDBEntities1(); transac_entities.Connection.Open(); System.Data.Common.DbTransaction transaction = transac_entities.Connection.BeginTransaction(); try { User newuser = new User() { Username = usernameTextBox.Text, Password = passwordTextBox.Text }; transac_entities.Users.AddObject(newuser); transac_entities.SaveChanges(); } catch (Exception ex) { transaction.Rollback(); registerErrorLabel.Text = "Error creating user"; return; } transaction.Commit(); registerErrorLabel.Text = "Successful registration"; } } } }
public void RollBack(System.Data.Common.DbTransaction tran, bool p = false) { try { tran.Rollback(); } catch { if (p) { throw; } } }
public ReturnType RemoveInOutAndDetails(string inOutCode) { System.Data.Common.DbTransaction tran = null; using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { try { alading.Connection.Open(); tran = alading.Connection.BeginTransaction(); List <StockInOut> list = alading.StockInOut.Where(p => p.InOutCode == inOutCode).ToList(); if (list.Count == 0) { return(ReturnType.NotExisted); } else { StockInOut sy = list.First(); foreach (StockDetail sd in alading.StockDetail.Where(c => c.InOutCode == inOutCode)) { alading.DeleteObject(sd); } alading.DeleteObject(sy); alading.SaveChanges(); } alading.SaveChanges(); tran.Commit(); return(ReturnType.Success); } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { if (tran != null) { tran.Rollback(); } return(ReturnType.SaveFailed); } finally { if (alading != null && alading.Connection.State != System.Data.ConnectionState.Closed) { alading.Connection.Close(); } } } }
public ActionResult SaveSrvCycle(int SrvTypeID, int SrvNo, string SrvCycleDt) { ERPDataContext oTran = new ERPDataContext(); oTran.Connection.Open(); System.Data.Common.DbTransaction transaction = oTran.Connection.BeginTransaction(); string Message = "Successfully Saved ..."; try { string[] Row = SrvCycleDt.Split('^'); tblSrvCycleMst oSrvM; tblSrvCycleItd oSrvI; commFunction oCom = new commFunction(); oSrvM = new tblSrvCycleMst(); oSrvM.SrvNo = SrvNo; oSrvM.SrvTypeID = SrvTypeID; db.tblSrvCycleMsts.InsertOnSubmit(oSrvM); db.SubmitChanges(); foreach (string itm in Row) { if (itm.ToString() != "") { oSrvI = new tblSrvCycleItd(); oSrvI.SrvNo = SrvNo; oSrvI.ItdCode = oSrvM.MstCode; oSrvI.SrvDate = Convert.ToDateTime(itm); db.tblSrvCycleItds.InsertOnSubmit(oSrvI); db.SubmitChanges(); } } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); // transaction.Connection.Close(); Message = ex.Message; } //finally //{ // // transaction.Connection.Close(); //} return(Json(Message, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 用户向导部分插入四个表 /// </summary> /// <param name="user"></param> /// <param name="list"></param> /// <returns></returns> public bool InsertUserWizard(UserInfo user, Policy policy, List <string> right, List <Dictionary <string, object> > list) { MeaningsBLL bll = new MeaningsBLL(); using (System.Data.SQLite.SQLiteConnection conn = SQLiteHelper.SQLiteHelper.CreateConn()) { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } System.Data.Common.DbTransaction tran = conn.BeginTransaction(); try { /*插入userinfo*/ this.InsertUser(user, tran); /*修改策略*/ processor.Update <Policy>(policy, tran); /*修改权限*/ if (right != null) { Dictionary <string, List <string> > r = new Dictionary <string, List <string> >(); r.Add(user.UserName, right); new UserRightBLL().SummitUserRight(r, tran); } /*修改meaning*/ if (list != null && list.Count > 0) { bll.InsertMeanRel(user.UserName, list, tran); } tran.Commit(); } catch { tran.Rollback(); conn.Close(); return(false); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } return(true); }
public static void InsertList <T>(System.Data.IDbCommand cmd , System.Collections.Generic.IEnumerable <T> listToInsert , callbackAddData_t <T> addDataCallback) { using (System.Data.Common.DbConnection conn = GetConnection()) { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } cmd.Connection = conn; using (System.Data.Common.DbTransaction transact = conn.BeginTransaction()) { cmd.Transaction = transact; try { foreach (T thisItem in listToInsert) { addDataCallback(cmd, thisItem); if (cmd.ExecuteNonQuery() != 1) { //'handled as needed, //' but this snippet will throw an exception to force a rollback throw new System.InvalidProgramException(); } } // Next thisObject transact.Commit(); } // End Try catch (System.Exception) { transact.Rollback(); throw; } // End Catch finally { if (conn.State != System.Data.ConnectionState.Closed) { conn.Close(); } } // End Finally } // End Using transact } // End Using conn } // End Sub
public bool DeleteGeneric <T>(List <T> entity) where T : class { bool sonuc = false; _cntxt = new DataContext(_connStr); System.Data.Common.DbTransaction tran = null; try { if (_cntxt.Connection.State == System.Data.ConnectionState.Closed) { _cntxt.Connection.Open(); } tran = _cntxt.Connection.BeginTransaction(); _cntxt.Transaction = tran; var Table = _cntxt.GetTable <T>(); foreach (T kayit in entity) { Table.Attach(kayit); Table.DeleteOnSubmit(kayit); _cntxt.SubmitChanges(); } sonuc = true; tran.Commit(); _cntxt.Connection.Close(); } catch (Exception exp) { tran.Rollback(); _cntxt.Connection.Close(); LogException(exp, "DeleteGeneric", -1); sonuc = false; } finally { if (_cntxt.Connection.State == System.Data.ConnectionState.Open) { _cntxt.Connection.Close(); } } return(sonuc); }
public bool RegistrarUsuario(Usuarios model) { System.Data.Common.DbTransaction transaccion = null; AdministraAccesoDatos acceso = null; List <IDataParameter> listaParametros = null; try { acceso = new AdministraAccesoDatos(Configuracion.BASEDATOSLOCAL, TipoProveedor.SqlServer); acceso.ObtenerConexion().Open(); transaccion = acceso.ObtenerConexion().BeginTransaction(); listaParametros = new List <IDataParameter>(); listaParametros.Add(new SqlParameter("@NOMBRE", model.Nombre)); listaParametros.Add(new SqlParameter("@APELLIDO", model.Apellidos)); listaParametros.Add(new SqlParameter("@USUARIO", model.Usuario)); listaParametros.Add(new SqlParameter("@CONTRASENA", model.Contrasena)); acceso.EjecutarStoredProcedureTransaccional("[dbo].[REGISTRA_USUARIO]", listaParametros.ToArray <IDataParameter>(), transaccion); transaccion.Commit(); return(true); } catch (Exception ex) { if (transaccion != null) { transaccion.Rollback(); transaccion.Dispose(); } throw ex; } finally { if (acceso != null) { acceso.CerrarConexion(); } if (transaccion != null) { transaccion.Dispose(); } } }
protected override int ExecuteInsert(IDictionary values) { Gateway gateway = owner.Gateway; Type type = Util.GetType(this.owner.TypeName); object entity = Activator.CreateInstance(type); foreach (string key in values.Keys) { PropertyInfo property = Util.DeepGetProperty(type, key); if (property.CanWrite) { property.SetValue(entity, ChangeType(values[key], property.PropertyType), null); } } NBearDataSourceEventArgs savingArgs = new NBearDataSourceEventArgs(entity); owner.OnSaving(savingArgs); entity = savingArgs.Entity; if (entity == null) { return(0); } System.Data.Common.DbTransaction tran = null; try { tran = gateway.BeginTransaction(); MethodInfo miSave = GetGatewayMethodInfo("Int32 Save[EntityType](EntityType, System.Data.Common.DbTransaction)"); miSave.MakeGenericMethod(type).Invoke(gateway, new object[] { entity, tran }); tran.Commit(); } catch { tran.Rollback(); throw; } finally { gateway.CloseTransaction(tran); } owner.OnSaved(new NBearDataSourceEventArgs(entity)); this.OnDataSourceViewChanged(EventArgs.Empty); return(1); }
public override void Excluir(object obj, out string mensagem, string strConexao) { using (var conn = ObterConexao(strConexao)) { System.Data.Common.DbTransaction transaction = null; try { conn.Open(); transaction = conn.BeginTransaction(); if (conn.RecordCount <Telefone>(new { IdFornecedor = obj }) > 0) { conn.DeleteList <Telefone>(new { IdFornecedor = obj }); } if (conn.RecordCount <FornecedorPessoaFisica>(new { IdFornecedor = obj }) > 0) { conn.Delete <FornecedorPessoaFisica>(obj); } if (conn.RecordCount <FornecedorPessoaFisica>(new { IdFornecedor = obj }) > 0) { conn.Delete <FornecedorPessoaJuridica>(obj); } int id = conn.Delete <Fornecedor>(obj); if (id == 0) { throw new Exception("Erro ao excluir os dados. Entre em contato com o administrador."); } mensagem = null; transaction.Commit(); } catch (Exception ex) { if (transaction != null) { transaction.Rollback(); } mensagem = ex.Message; } finally { conn.Close(); } } }
/// <summary> /// 用户向导部分插入四个表 /// </summary> /// <param name="user"></param> /// <param name="list"></param> /// <returns></returns> public bool InsertUserWizard(UserInfo user, List <Dictionary <string, object> > list) { MeaningsBLL bll = new MeaningsBLL(); using (System.Data.SQLite.SQLiteConnection conn = SQLiteHelper.SQLiteHelper.CreateConn()) { if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } System.Data.Common.DbTransaction tran = conn.BeginTransaction(); try { /*插入userinfo*/ this.InsertUser(user, tran); //先获取当前meaning及relation的最大id int mId = bll.GetMeaningPKValue(); int rId = bll.GetRelationPKValue(); Dictionary <string, object> rDic, mDic; foreach (Dictionary <string, object> dic in list) { rDic = new Dictionary <string, object>(dic); mDic = new Dictionary <string, object>(dic); mDic.Add("ID", ++mId); rDic.Add("ID", ++rId); bll.InsertOrUpdateMeaning(mDic, tran); bll.InsertMeanRel(user.UserName, rDic, tran); } tran.Commit(); } catch { tran.Rollback(); conn.Close(); return(false); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } return(true); }
public bool EliminarUsuario(int IdUsuario) { System.Data.Common.DbTransaction transaccion = null; AdministraAccesoDatos acceso = null; List <IDataParameter> listaParametros = null; try { acceso = new AdministraAccesoDatos(Configuracion.BASEDATOSLOCAL, TipoProveedor.SqlServer); acceso.ObtenerConexion().Open(); transaccion = acceso.ObtenerConexion().BeginTransaction(); listaParametros = new List <IDataParameter>(); listaParametros.Add(new SqlParameter("@IDUSUARIO", IdUsuario)); acceso.EjecutarStoredProcedureTransaccional("[dbo].[ELIMINA_USUARIO]", listaParametros.ToArray <IDataParameter>(), transaccion); transaccion.Commit(); return(true); } catch (Exception ex) { if (transaccion != null) { transaccion.Rollback(); transaccion.Dispose(); } throw ex; } finally { if (acceso != null) { acceso.CerrarConexion(); } if (transaccion != null) { transaccion.Dispose(); } } }
public void CommitPalavras() { this.RemoveAllData <PALAVRAS>(); System.Data.Common.DbTransaction transaction = this.DbBase.BeginTransaction(); try { foreach (var item in Palavras) { this.Save(item, transaction); } transaction.Commit(); } catch { transaction.Rollback(); } finally { DbBase.Close(); } }