public int update(Region_ENT datosRegion) { try { using (SqlConnection sqlConn = new SqlConnection(this.ConexionPH)) { sqlConn.Open(); SqlCommand cmd = new SqlCommand(this.ConexionPH, sqlConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "SP_UPDATE_REGION_IDREGION"; cmd.Parameters.AddWithValue("@id_region", datosRegion.IdRegion); cmd.Parameters.AddWithValue("@nombre", datosRegion.Nombre); cmd.Parameters.AddWithValue("@estado", datosRegion.Estado); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { this.error = reader["error"].Equals(1) ? 1 : 0; } return(this.error); } } catch (Exception ex) { throw new Exception("Error al ejecutar SP_UPDATE_REGION_IDREGION", ex); } }
public Region_ENT getForIdRegion(Region_ENT datosRegion) { try { using (SqlConnection sqlConn = new SqlConnection(this.ConexionPH)) { sqlConn.Open(); SqlCommand cmd = new SqlCommand(this.ConexionPH, sqlConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "SP_GET_REGION_IDREGION"; cmd.Parameters.AddWithValue("@id_region", datosRegion.IdRegion); SqlDataReader reader = cmd.ExecuteReader(); Region_ENT oRegion = new Region_ENT(); if (reader.Read()) { oRegion.IdRegion = Convert.ToInt32(reader["id_region"]); oRegion.Nombre = reader["nombre"].Equals(DBNull.Value) ? "" : Convert.ToString(reader["nombre"]); oRegion.Estado = reader["estado"].Equals(DBNull.Value) ? false : Convert.ToBoolean(reader["estado"]); return(oRegion); } else { return(null); } } } catch (Exception ex) { throw new Exception("Error al ejecutar SP_GET_REGION_IDREGION", ex); } }
public List <Region_ENT> listRegion() { try { using (SqlConnection sqlConn = new SqlConnection(this.ConexionPH)) { sqlConn.Open(); SqlCommand cmd = new SqlCommand(this.ConexionPH, sqlConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "SP_LIST_ALL_REGION"; List <Region_ENT> listRegion = new List <Region_ENT>(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { Region_ENT oRegion = new Region_ENT(); oRegion.IdRegion = Convert.ToInt32(reader["id_region"]); oRegion.Nombre = reader["nombre"].Equals(DBNull.Value) ? "" : Convert.ToString(reader["nombre"]); oRegion.Estado = reader["estado"].Equals(DBNull.Value) ? false : Convert.ToBoolean(reader["estado"]); listRegion.Add(oRegion); } return(listRegion); } } catch (Exception ex) { throw new Exception("Error al ejecutar SP_LIST_ALL_REGION", ex); } }
public Region_ENT getById(Region_ENT region) { return(new Region_DAO().getForIdRegion(region)); }