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