public EUsuariosRoles UsuariosRoles_Update(EUsuariosRoles item, ref ETransactionResult _transResult) { EUsuariosRoles itemUpdated = null; _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("UpdateTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "SP_UsuariosRoles_Update"; sqlCmd.Parameters.AddWithValue("@IdUsuario", item.IdUsuario); sqlCmd.Parameters.AddWithValue("@IdRol", item.IdRol); using (var reader = sqlCmd.ExecuteReader()) { while (reader.Read()) { itemUpdated = new EUsuariosRoles(); itemUpdated.IdUsuario = (int)reader["IdUsuario"]; itemUpdated.IdRol = (string)reader["IdRol"]; } } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 1; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(itemUpdated); }
public List <EUsuariosRoles> UsuariosRoles_GetAll(ref ETransactionResult _transResult) { var list = new List <EUsuariosRoles>(); _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("SelectAllTranstaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "SP_UsuariosRoles_SelectAll"; using (var reader = sqlCmd.ExecuteReader()) while (reader.Read()) { var item = new EUsuariosRoles(); item.IdUsuario = (int)reader["IdUsuario"]; item.IdRol = (string)reader["IdRol"]; list.Add(item); } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(list); }
public void UsuariosRoles_Delete(EUsuariosRoles item, ref ETransactionResult _transResult) { _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("DeleteTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "SP_UsuariosRoles_Delete"; sqlCmd.Parameters.AddWithValue("@IdUsuario", item.IdUsuario); sqlCmd.Parameters.AddWithValue("@IdRol", item.IdRol); sqlCmd.ExecuteNonQuery(); transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } }