public EColonias Colonias_Update(EColonias item, ref ETransactionResult _transResult) { EColonias 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_Colonias_Update"; sqlCmd.Parameters.AddWithValue("@Id", item.Id); sqlCmd.Parameters.AddWithValue("@IdEstado", item.IdEstado); sqlCmd.Parameters.AddWithValue("@IdMunicipio", item.IdMunicipio); sqlCmd.Parameters.AddWithValue("@cp", item.cp); sqlCmd.Parameters.AddWithValue("@Descripcion", item.Descripcion); using (var reader = sqlCmd.ExecuteReader()) { while (reader.Read()) { itemUpdated = new EColonias(); itemUpdated.Id = (int)reader["Id"]; itemUpdated.IdEstado = (int)reader["IdEstado"]; itemUpdated.IdMunicipio = (int)reader["IdMunicipio"]; itemUpdated.cp = (long)reader["cp"]; itemUpdated.Descripcion = reader["Descripcion"] == DBNull.Value ? null : (string)reader["Descripcion"]; } } 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 <EColonias> Colonias_GetAll(ref ETransactionResult _transResult) { var list = new List <EColonias>(); _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_Colonias_SelectAll"; using (var reader = sqlCmd.ExecuteReader()) while (reader.Read()) { var item = new EColonias(); item.Id = (int)reader["Id"]; item.IdEstado = (int)reader["IdEstado"]; item.IdMunicipio = (int)reader["IdMunicipio"]; item.cp = (long)reader["cp"]; item.Descripcion = reader["Descripcion"] == DBNull.Value ? null : (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 Colonias_Delete(EColonias 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_Colonias_Delete"; sqlCmd.Parameters.AddWithValue("@Id", item.Id); sqlCmd.Parameters.AddWithValue("@IdEstado", item.IdEstado); sqlCmd.Parameters.AddWithValue("@IdMunicipio", item.IdMunicipio); 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; } } }