public List <ZonaIntervencion_E> listarTodo() { List <ZonaIntervencion_E> lZonaInter = new List <ZonaIntervencion_E>(); try { using (cmd = new SqlCommand("SP_LISTAR_ZONAS_INTEVENCION", cnx.CONSel)) { cnx.CONSel.Open(); cmd.CommandType = CommandType.StoredProcedure; dr = cmd.ExecuteReader(); while (dr.Read()) { ZonaIntervencion_E ZonaInter = new ZonaIntervencion_E(); ZonaInter.idZonaIntervencion = Convert.ToInt32(dr["ID"]); ZonaInter.tipoAmbito = Convert.ToString(dr["AMBITO"]).ToUpper(); ZonaInter.codigoUbigeo = Convert.ToString(dr["COD. UBIGEO"]); ZonaInter.activo = Convert.ToBoolean(dr["ACTIVO"]); ZonaInter.nombUsuarioReg = Convert.ToString(dr["REGISTRADO POR"]); ZonaInter.fechaRegistro = Convert.ToString(dr["FECHA REGISTRO"]); ZonaInter.nombUsuarioMod = Convert.ToString(dr["MODIFICADO POR"]); ZonaInter.fechaModificacion = Convert.ToString(dr["FECHA MODIFICACION"]); lZonaInter.Add(ZonaInter); } } }catch (Exception ex) { ut.logsave(this, ex); Debug.WriteLine("Error al listar zona de intervención: " + ex.Message.ToString() + ex.StackTrace.ToString()); } finally { cnx.CONSel.Close(); } return(lZonaInter); }
public ZonaIntervencion_E obtenerZonaIntervecion(string codUbigeo) { ZonaIntervencion_E ZonaInter_E = new ZonaIntervencion_E(); try { using (cmd = new SqlCommand("SP_OBTENER_ZONA_INTERVENCION", cnx.CONSel)) { cnx.CONSel.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CODUBIGEO", codUbigeo); dr = cmd.ExecuteReader(); while (dr.Read()) { ZonaIntervencion_E ZonaInter = new ZonaIntervencion_E(); ZonaInter.idZonaIntervencion = Convert.ToInt32(dr["ID"]); ZonaInter.idTipoAmbito = Convert.ToInt32(dr["ID AMBITO"]); ZonaInter.tipoAmbito = Convert.ToString(dr["AMBITO"]).ToUpper(); ZonaInter.codigoUbigeo = Convert.ToString(dr["COD. UBIGEO"]); ZonaInter_E = ZonaInter; } } } catch (Exception ex) { ut.logsave(this, ex); Debug.WriteLine("Error al obtener ambito de la zona de intervención: " + ex.Message.ToString() + ex.StackTrace.ToString()); } finally { cnx.CONSel.Close(); } return(ZonaInter_E); }