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