/// <summary>
/// Metodo para Consultar Cadenas
/// Requerimiento No:<>
/// </summary>
public DataTable ConsultarCadenas(string snameCadena)
{
DataTable dt = oConn.ejecutarDataTable("UP_WESIGE_SEARCH_CADENAS", snameCadena);
ECadenas oescadena = new ECadenas();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oescadena.idmarketChain = Convert.ToInt32(dt.Rows[i]["id_marketChain"].ToString().Trim());
oescadena.MarketChainname = dt.Rows[i]["MarketChain_name"].ToString().Trim();
oescadena.MarketChainStatus = Convert.ToBoolean(dt.Rows[i]["MarketChain_Status"].ToString().Trim());
oescadena.MarketChainCreateBy = dt.Rows[i]["MarketChain_CreateBy"].ToString().Trim();
oescadena.MarketChainDateBy = Convert.ToDateTime(dt.Rows[i]["MarketChain_DateBy"].ToString().Trim());
oescadena.MarketChainModiBy = dt.Rows[i]["MarketChain_ModiBy"].ToString().Trim();
oescadena.MarketChainDateModiBy = Convert.ToDateTime(dt.Rows[i]["MarketChain_DateModiBy"].ToString().Trim());
}
}
return(dt);
}
else
{
return(null);
}
}
/// <summary>
/// Metodo para Actualizar Cadenas
/// Requerimiento No:<>
/// </summary>
public ECadenas ActualizarCadena(int iidCadena, string snameCadena, bool bstatuscadena, string sModiByCadena, DateTime tDateModiByCadena)
{
DCadenas odacadenas = new DCadenas();
ECadenas oeacanales = odacadenas.ActualizarCadena(iidCadena, snameCadena, bstatuscadena, sModiByCadena, tDateModiByCadena);
odacadenas = null;
return(oeacanales);
}
/// <summary>
/// Metodo para Registrar Cadenas
/// Requerimiento No:<>
/// </summary>
public ECadenas RegisterCadena(string snameCadena, bool bstatuscadena, string sCrateByCadena,
DateTime tDateByCadena, string sModiByCadena, DateTime tDateModiByCadena)
{
DCadenas odcadenas = new DCadenas();
ECadenas oecanales = odcadenas.RegisterCadena(snameCadena, bstatuscadena, sCrateByCadena, tDateByCadena,
sModiByCadena, tDateModiByCadena);
odcadenas = null;
return(oecanales);
}
/// <summary>
/// Metodo para Actualizar Cadenas
/// Requerimiento No:<>
/// </summary>
public ECadenas ActualizarCadena(int iidCadena, string snameCadena, bool bstatuscadena, string sModiByCadena, DateTime tDateModiByCadena)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_SIGE_ACTUALIZACADENA", iidCadena, snameCadena, bstatuscadena, sModiByCadena, tDateModiByCadena);
ECadenas oeacadenas = new ECadenas();
//oeacadenas.idmarketChain = iidCadena;
oeacadenas.MarketChainname = snameCadena;
oeacadenas.MarketChainStatus = bstatuscadena;
oeacadenas.MarketChainModiBy = sModiByCadena;
oeacadenas.MarketChainDateModiBy = tDateModiByCadena;
return(oeacadenas);
}
/// <summary>
/// Metodo para Registrar Cadenas
/// Requerimiento No:<>
/// </summary>
public ECadenas RegisterCadena(string snameCadena, bool bstatuscadena, string sCrateByCadena,
DateTime tDateByCadena, string sModiByCadena, DateTime tDateModiByCadena)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_SIGE_REGISTERCADENA", snameCadena, bstatuscadena, sCrateByCadena,
tDateByCadena, sModiByCadena, tDateModiByCadena);
ECadenas oecadenas = new ECadenas();
//oecadenas.idmarketChain = sidCadena;
oecadenas.MarketChainname = snameCadena;
oecadenas.MarketChainStatus = bstatuscadena;
oecadenas.MarketChainCreateBy = sCrateByCadena;
oecadenas.MarketChainDateBy = tDateByCadena;
oecadenas.MarketChainModiBy = sModiByCadena;
oecadenas.MarketChainDateModiBy = tDateModiByCadena;
return(oecadenas);
}
