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