public EunidadMedida unidadMedida_Update(EunidadMedida item, ref ETransactionResult _transResult)
{
EunidadMedida 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 = "D_PR_unidadMedida_Update";
sqlCmd.Parameters.AddWithValue("@idUnidad", item.idUnidad);
sqlCmd.Parameters.AddWithValue("@descripcion", item.descripcion);
using (var reader = sqlCmd.ExecuteReader())
{
while (reader.Read())
{
itemUpdated = new EunidadMedida();
itemUpdated.idUnidad = (int)reader["idUnidad"];
itemUpdated.descripcion = (string)reader["descripcion"];
}
}
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(itemUpdated);
}
public List <EunidadMedida> unidadMedida_GetAll(ref ETransactionResult _transResult)
{
var list = new List <EunidadMedida>();
_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 = "D_PR_unidadMedida_SelectAll";
using (var reader = sqlCmd.ExecuteReader())
while (reader.Read())
{
var item = new EunidadMedida();
item.idUnidad = (int)reader["idUnidad"];
item.descripcion = (string)reader["descripcion"];
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 unidadMedida_Delete(EunidadMedida 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 = "D_PR_unidadMedida_Delete";
sqlCmd.Parameters.AddWithValue("@idUnidad", item.idUnidad);
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;
}
}
}
