/// <summary> /// Metodo para Consultar barrios /// </summary> public DataTable ConsultarBarrio(string scodcountry, string scoddpto, string scodcity, string scoddistrito, string snamebarrio) { DataTable dt = oConn.ejecutarDataTable("UP_WEBSIGE_CONSULTARBARRIOS", scodcountry, scoddpto, scodcity, scoddistrito, snamebarrio); EBarrio oecbarrio = new EBarrio(); if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i <= dt.Rows.Count - 1; i++) { oecbarrio.codComunity = dt.Rows[i]["cod_Community"].ToString().Trim(); oecbarrio.codcountry = dt.Rows[i]["cod_country"].ToString().Trim(); oecbarrio.coddpto = dt.Rows[i]["cod_dpto"].ToString().Trim(); oecbarrio.codcity = dt.Rows[i]["cod_City"].ToString().Trim(); oecbarrio.codDistrict = dt.Rows[i]["cod_District"].ToString().Trim(); oecbarrio.NameCommunity = dt.Rows[i]["Name_Community"].ToString().Trim(); oecbarrio.ComunityStatus = Convert.ToBoolean(dt.Rows[i]["Comunity_Status"].ToString().Trim()); oecbarrio.CommunityCreateBy = dt.Rows[i]["Community_CreateBy"].ToString().Trim(); oecbarrio.CommunityDateBy = Convert.ToDateTime(dt.Rows[i]["Community_DateBy"].ToString().Trim()); oecbarrio.CommunityModiBy = dt.Rows[i]["Community_ModiBy"].ToString().Trim(); oecbarrio.CommunityDateModiBy = Convert.ToDateTime(dt.Rows[i]["Community_DateModiBy"].ToString().Trim()); } } return(dt); } else { return(null); } }
public EBarrio ActualizarBarrio(string scodbarrio, string scodcountry, string scoddpto, string scodcity, string scoddistrito, string snamebarrio, bool bstatusbarrio, string sBarrioModiBy, DateTime tBarrioDateModiBy) { DBarrio odabarrio = new DBarrio(); EBarrio oeabarrio = odabarrio.ActualizarBarrio(scodbarrio, scodcountry, scoddpto, scodcity, scoddistrito, snamebarrio, bstatusbarrio, sBarrioModiBy, tBarrioDateModiBy); odabarrio = null; return(oeabarrio); }
/// <summary> /// Metodo para registrar Barrios /// </summary> public EBarrio RegistrarBarrio(string scodbarrio, string scodcountry, string scoddpto, string scodcity, string scoddistrito, string snamebarrio, bool bstatusbarrio, string sBarrioCreateBy, DateTime tBarrioDateBy, string sBarrioModiBy, DateTime tBarrioDateModiBy) { DBarrio odrbarrio = new DBarrio(); EBarrio oerbarrio = odrbarrio.RegistrarBarrio(scodbarrio, scodcountry, scoddpto, scodcity, scoddistrito, snamebarrio, bstatusbarrio, sBarrioCreateBy, tBarrioDateBy, sBarrioModiBy, tBarrioDateModiBy); odrbarrio = null; return(oerbarrio); }
/// <summary> /// Metodo para Actualizar Barrios /// </summary> public EBarrio ActualizarBarrio(string scodbarrio, string scodcountry, string scoddpto, string scodcity, string scoddistrito, string snamebarrio, bool bstatusbarrio, string sBarrioModiBy, DateTime tBarrioDateModiBy) { DataTable dt = oConn.ejecutarDataTable("UP_WEBSIGE_ACTUALIZARBARRIO", scodbarrio, scodcountry, scoddpto, scodcity, scoddistrito, snamebarrio, bstatusbarrio, sBarrioModiBy, tBarrioDateModiBy); EBarrio oeabarrio = new EBarrio(); oeabarrio.codComunity = scodbarrio; oeabarrio.codcountry = scodcountry; oeabarrio.coddpto = scoddpto; oeabarrio.codcity = scodcity; oeabarrio.codDistrict = scoddistrito; oeabarrio.NameCommunity = snamebarrio; oeabarrio.ComunityStatus = bstatusbarrio; oeabarrio.CommunityModiBy = sBarrioModiBy; oeabarrio.CommunityDateModiBy = tBarrioDateModiBy; return(oeabarrio); }