/// <summary>
///Nombre Metodo: SEARCHCANALES
///Función: Permite Consultar Canales
/// </summary>
public DataTable ObtenerCanales(string sCodChannel, string sChannelName)
{
oConn = new Conexion(1);
DataTable dt = oConn.ejecutarDataTable("UP_WEB_SEARCHCANALES", sCodChannel, sChannelName);
ECanales oeCanales = new ECanales();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oeCanales.codChannel = dt.Rows[i]["cod_Channel"].ToString().Trim();
oeCanales.Company_id = Convert.ToInt32(dt.Rows[i]["Company_id"].ToString().Trim());
oeCanales.ChannelName = dt.Rows[i]["Channel_Name"].ToString().Trim();
oeCanales.Channeldescription = dt.Rows[i]["Channel_description"].ToString().Trim();
oeCanales.ChannelType = Convert.ToInt32(dt.Rows[i]["chtype_id"].ToString().Trim());
oeCanales.ChannelStatus = Convert.ToBoolean(dt.Rows[i]["Channel_Status"].ToString().Trim());
oeCanales.ChannelCreateBy = dt.Rows[i]["Channel_CreateBy"].ToString().Trim();
oeCanales.ChannelDateBy = Convert.ToDateTime(dt.Rows[i]["Channel_DateBy"].ToString().Trim());
oeCanales.ChannelModiBy = dt.Rows[i]["Channel_ModiBy"].ToString().Trim();
oeCanales.ChannelDateModiBy = Convert.ToDateTime(dt.Rows[i]["Channel_DateModiBy"].ToString().Trim());
}
}
return(dt);
}
else
{
return(null);
}
}
public ECanales RegistrarCanalesTMP(string scodChannel, string sChannelName, string sChannelType, bool bChannelStatus)
{
DCanales odrCanales = new DCanales();
ECanales oerCanales = odrCanales.RegistrarCanalesTMP(scodChannel, sChannelName, sChannelType, bChannelStatus);
return(oerCanales);
}
//---Metodo de Consulta de Canales
public DataTable BuscarCanales(string scodchannel, string sChannelName)
{
ECanales oeCanales = new ECanales();
DataTable dtCanales = odseCanales.ObtenerCanales(scodchannel, sChannelName);
odseCanales = null;
return(dtCanales);
}
public ECanales Actualizar_Canales_TMP(string scodChannel, string sChannelName, string sChannelType, bool bChannelStatus)
{
DCanales odaCanales = new DCanales();
ECanales oeacanales = odaCanales.Actualizar_Canales_TMP(scodChannel, sChannelName, sChannelType, bChannelStatus);
odaCanales = null;
return(oeacanales);
}
//----Metodo que permite Actualizar Canales Ing. Carlos Alberto Hernandez R
public ECanales Actualizar_Canales(string scodChannel, int iCompany_id, string sChannelName, string sChanneldescription, int iChannel_type, bool bChannelStatus, string sChannelModiBy, DateTime tChannelDateModiBy)
{
DCanales odaCanales = new DCanales();
ECanales oeaCanales = odaCanales.Actualizar_Canales(scodChannel, iCompany_id, sChannelName, sChanneldescription, iChannel_type, bChannelStatus, sChannelModiBy, tChannelDateModiBy);
odaCanales = null;
return(oeaCanales);
}
//----Metodo que permite registrar Canales
public ECanales RegistrarCanales(string scodChannel, int iCompany_id, string sChannelName, string sChanneldescription, int iChannelType, bool bChannelStatus, string sChannelCreateBy, DateTime tChannelDateBy, string sChannelModiBy, DateTime tChannelDateModiBy)
{
DCanales odrCanales = new DCanales();
ECanales oerCanales = odrCanales.RegistrarCanalesPK(scodChannel, iCompany_id, sChannelName, sChanneldescription, iChannelType, bChannelStatus, sChannelCreateBy, tChannelDateBy, sChannelModiBy, tChannelDateModiBy);
odrCanales = null;
return(oerCanales);
}
public ECanales Actualizar_Canales_TMP(string scodChannel, string sChannelName, string sChannelType, bool bChannelStatus)
{
oConn = new Conexion(2);
DataTable dt = oConn.ejecutarDataTable("UP_WEB_ACTUALIZA_CHANNEL_TMP", scodChannel, sChannelName, sChannelType, Convert.ToInt32(bChannelStatus));
ECanales oeacanales = new ECanales();
return(oeacanales);
}
public ECanales RegistrarCanalesTMP(string scodChannel, string sChannelName, string sChannelType, bool bChannelStatus)
{
oConn = new Conexion(2);
DataTable dt = oConn.ejecutarDataTable("UP_WEB_REGISTERCHANNEL_TMP", scodChannel, sChannelName, sChannelType, Convert.ToInt32(bChannelStatus));
ECanales oercanales = new ECanales();
return(oercanales);
}
//Metodo para Actualizar Canales Ing. Carlos Alberto Hernandez R
public ECanales Actualizar_Canales(string scodChannel, int iCompany_id, string sChannelName, string sChanneldescription, int iChannelType, bool bChannelStatus, string sChannelModiBy, DateTime tChannelDateModiBy)
{
oConn = new Conexion(1);
DataTable dt = oConn.ejecutarDataTable("UP_WEB_ACTUALIZA_CHANNEL", scodChannel, iCompany_id, sChannelName, sChanneldescription, iChannelType, bChannelStatus, sChannelModiBy, tChannelDateModiBy);
ECanales oeacanales = new ECanales();
oeacanales.codChannel = scodChannel;
oeacanales.Company_id = iCompany_id;
oeacanales.ChannelName = sChannelName;
oeacanales.Channeldescription = sChanneldescription;
oeacanales.ChannelType = iChannelType;
oeacanales.ChannelStatus = bChannelStatus;
oeacanales.ChannelModiBy = sChannelModiBy;
oeacanales.ChannelDateModiBy = tChannelDateModiBy;
return(oeacanales);
}
//Método para Registrar Canales
/// <summary>
/// Modificación: se agrega campo de company_id
/// 20/10/2010 Magaly Jiménez
/// </summary>
/// <param name="scodChannel"></param>
/// <param name="iCompany_id"></param>
/// <param name="sChannelName"></param>
/// <param name="sChanneldescription"></param>
/// <param name="bChannelStatus"></param>
/// <param name="sChannelCreateBy"></param>
/// <param name="tChannelDateBy"></param>
/// <param name="sChannelModiBy"></param>
/// <param name="tChannelDateModiBy"></param>
/// <returns></returns>
public ECanales RegistrarCanalesPK(string scodChannel, int iCompany_id, string sChannelName, string sChanneldescription, int iChannelType, bool bChannelStatus, string sChannelCreateBy, DateTime tChannelDateBy, string sChannelModiBy, DateTime tChannelDateModiBy)
{
oConn = new Conexion(1);
DataTable dt = oConn.ejecutarDataTable("UP_WEB_REGISTERCHANNEL", scodChannel, iCompany_id, sChannelName, sChanneldescription, iChannelType, bChannelStatus, sChannelCreateBy, tChannelDateBy, sChannelModiBy, tChannelDateModiBy);
ECanales oercanales = new ECanales();
oercanales.codChannel = scodChannel;
oercanales.Company_id = iCompany_id;
oercanales.ChannelName = sChannelName;
oercanales.Channeldescription = sChanneldescription;
oercanales.ChannelType = iChannelType;
oercanales.ChannelStatus = bChannelStatus;
oercanales.ChannelCreateBy = sChannelCreateBy;
oercanales.ChannelDateBy = tChannelDateBy;
oercanales.ChannelModiBy = sChannelModiBy;
oercanales.ChannelDateModiBy = tChannelDateModiBy;
return(oercanales);
}
// Metodo para consultar Asignación de informe por usuario de tabla CLIE_Users_Reports
/// <summary>
/// Modificación: se modifica consulta se cambia de grilla a consulta normal con cuatro parametros
/// 12/10/2010 Magaly Jiménez
/// </summary>
/// <param name="iCompany_id"></param>
/// <param name="iPerson_id"></param>
/// <param name="scod_Channel"></param>
/// <param name="icod_Strategy"></param>
/// <returns>dt</returns>
public DataTable ConsultarAsignciónInfoaUsu(int iCompany_id, int iPerson_id, string scod_Channel, int icod_Strategy)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_AD_CONSULTARCLIE_USERS_REPORTS", iCompany_id, iPerson_id, scod_Channel, icod_Strategy);
EInfoaUsaurio oeCinfoaUsuario = new EInfoaUsaurio();
ECompany oeCliente = new ECompany();
EUsuario oeUsuario = new EUsuario();
EEstrategy oeStrategy = new EEstrategy();
ECanales oeCanal = new ECanales();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oeCinfoaUsuario.id_userinforme = Convert.ToInt32(dt.Rows[i]["id_userinforme"].ToString().Trim());
oeCinfoaUsuario.Person_id = Convert.ToInt32(dt.Rows[i]["Person_id"].ToString().Trim());
//oeUsuario.nameuser = dt.Rows[i]["name_user"].ToString().Trim();
oeCinfoaUsuario.cod_Channel = dt.Rows[i]["cod_Channel"].ToString().Trim();
oeCinfoaUsuario.cod_subchannel = dt.Rows[i]["cod_subchannel"].ToString().Trim();
oeCinfoaUsuario.cod_Subnivel = dt.Rows[i]["cod_Subnivel"].ToString().Trim();
//oeCanal.ChannelName = dt.Rows[i]["Canal"].ToString().Trim();
oeCinfoaUsuario.cod_Strategy = Convert.ToInt32(dt.Rows[i]["cod_Strategy"].ToString().Trim());
//oeStrategy.StrategyName = dt.Rows[i]["Strategy_Name"].ToString().Trim();
oeCinfoaUsuario.Company_id = Convert.ToInt32(dt.Rows[i]["Company_id"].ToString().Trim());
// oeCliente.CompanyName = dt.Rows[i]["Company_Name"].ToString().Trim();
oeCinfoaUsuario.userinfo_status = Convert.ToBoolean(dt.Rows[i]["userinfo_status"].ToString().Trim());
oeCinfoaUsuario.userinfo_CreateBy = dt.Rows[i]["userinfo_CreateBy"].ToString().Trim();
oeCinfoaUsuario.userinfo_DateBy = Convert.ToDateTime(dt.Rows[i]["userinfo_DateBy"].ToString().Trim());
oeCinfoaUsuario.userinfo_ModiBy = dt.Rows[i]["userinfo_ModiBy"].ToString().Trim();
oeCinfoaUsuario.userinfo_DateModiBy = Convert.ToDateTime(dt.Rows[i]["userinfo_DateModiBy"].ToString().Trim());
}
}
return(dt);
}
else
{
return(null);
}
}
