/// <summary>
///Nombre Metodo: Search_ItemsServicios
///Función: Permite Consultar servicios Lucky
/// </summary>
public DataTable ObtenerItemServicios(int iCodStrategy, int icompanyid)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_SEARCHITEMSSERVICIOS", iCodStrategy, icompanyid);
EStrategit_Points oeStrategyPoint = new EStrategit_Points();
EEstrategy oeEstrategy = new EEstrategy();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oeStrategyPoint.idcodPoint = Convert.ToInt32(dt.Rows[i]["id_cod_Point"].ToString().Trim());
oeStrategyPoint.codPoint = dt.Rows[i]["cod_Point"].ToString().Trim();
oeStrategyPoint.DescriptionPoint = dt.Rows[i]["Description_Point"].ToString().Trim();
oeEstrategy.codCountry = dt.Rows[i]["cod_Country"].ToString().Trim();
oeStrategyPoint.codStrategy = Convert.ToInt32(dt.Rows[i]["cod_Strategy"].ToString().Trim());
oeStrategyPoint.company_id = Convert.ToInt32(dt.Rows[i]["company_id"].ToString().Trim());
oeStrategyPoint.cod_Channel = dt.Rows[i]["cod_Channel"].ToString().Trim();
oeStrategyPoint.Report_Id = Convert.ToInt32(dt.Rows[i]["Report_Id"].ToString().Trim());
oeStrategyPoint.StatusPoint = Convert.ToBoolean(dt.Rows[i]["Status_Point"].ToString().Trim());
oeStrategyPoint.PointCreateBy = dt.Rows[i]["Point_CreateBy"].ToString().Trim();
oeStrategyPoint.PointDateBy = dt.Rows[i]["Point_DateBy"].ToString().Trim();
oeStrategyPoint.PointModiBy = dt.Rows[i]["Point_ModiBy"].ToString().Trim();
oeStrategyPoint.PointDateModiBy = dt.Rows[i]["Point_DateModiBy"].ToString().Trim();
}
}
return(dt);
}
else
{
return(null);
}
}
//Nombre Metodo: SEARCHinfvsserv
//Función: Permite Consultar informes vs servicios
public DataTable ObtenerRepVsEs(int icodStrategy, int ReportId)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_SEARCHINFvsSERV", icodStrategy, ReportId);
EReportsStrategit oeRepvsEs = new EReportsStrategit();
EEstrategy oeEstrategy = new EEstrategy();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oeRepvsEs.ReportSt_id = Convert.ToInt32(dt.Rows[i]["ReportSt_id"].ToString().Trim());
oeRepvsEs.Report_id = Convert.ToInt32(dt.Rows[i]["Report_id"].ToString().Trim());
oeEstrategy.codCountry = (dt.Rows[i]["cod_Country"].ToString().Trim());
oeRepvsEs.cod_Strategy = Convert.ToInt32(dt.Rows[i]["cod_Strategy"].ToString().Trim());
oeRepvsEs.ReportSt_Status = Convert.ToBoolean(dt.Rows[i]["ReportSt_Status"].ToString().Trim());
}
}
return(dt);
}
else
{
return(null);
}
}
/// <summary>
///Nombre Metodo: Search_Servicios
///Función: Permite Consultar servicios Lucky
/// </summary>
public DataTable ObtenerServicios(string sStrategyName, string scodcountry)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_SEARCHSERVICIOS", sStrategyName, scodcountry);
EEstrategy oeEstrategy = new EEstrategy();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oeEstrategy.codStrategy = Convert.ToInt32(dt.Rows[i]["cod_Strategy"].ToString().Trim());
oeEstrategy.StrategyName = dt.Rows[i]["Strategy_Name"].ToString().Trim();
oeEstrategy.StrategyDescription = dt.Rows[i]["Strategy_Description"].ToString().Trim();
oeEstrategy.codCountry = dt.Rows[i]["cod_Country"].ToString().Trim();
oeEstrategy.StrategyStatus = Convert.ToBoolean(dt.Rows[i]["Strategy_Status"].ToString().Trim());
oeEstrategy.StrategyCreateBy = dt.Rows[i]["Strategy_CreateBy"].ToString().Trim();
oeEstrategy.StrategyDateBy = dt.Rows[i]["Strategy_DateBy"].ToString().Trim();
oeEstrategy.StrategyModiBy = dt.Rows[i]["Strategy_ModiBy"].ToString().Trim();
oeEstrategy.StrategyDateModiBy = dt.Rows[i]["Strategy_DateModiBy"].ToString().Trim();
}
}
return(dt);
}
else
{
return(null);
}
}
//----Metodo que permite Actualizar Servicios Ing. Carlos Alberto Hernandez
public EEstrategy Actualizar_Servicios(int icodstrategy, string sStrategyName, string sStrategyDescription, string scodCountry, bool sStrategyStatus, string sStrategyModiBy, string sStrategyDateModiBy)
{
Lucky.Data.Common.Application.DEstrategy odaservicios = new Lucky.Data.Common.Application.DEstrategy();
EEstrategy oeaservicios = odaservicios.Actualizar_Servicios(icodstrategy, sStrategyName, sStrategyDescription, scodCountry, sStrategyStatus, sStrategyModiBy, sStrategyDateModiBy);
odaservicios = null;
return(oeaservicios);
}
//----Metodo que permite registrar Servicios
public EEstrategy RegistrarServicios(string sStrategyName, string sStrategyDescription, string scodCountry, bool sStrategyStatus, string sStrategyCreateBy, string sStrategyDateBy, string sStrategyModiBy, string sStrategyDateModiBy)
{
Lucky.Data.Common.Application.DEstrategy odrservicios = new Lucky.Data.Common.Application.DEstrategy();
EEstrategy oeservicios = odrservicios.RegistrarServiciosPK(sStrategyName, sStrategyDescription, scodCountry, sStrategyStatus, sStrategyCreateBy, sStrategyDateBy, sStrategyModiBy, sStrategyDateModiBy);
odrservicios = null;
return(oeservicios);
}
//---Metodo de Consulta de Servicios
public DataTable BuscarServicios(string sStrategyName, string scodcountry)
{
Lucky.Data.Common.Application.DEstrategy odsestrategias = new Lucky.Data.Common.Application.DEstrategy();
EEstrategy oeestrategias = new EEstrategy();
DataTable dtServicios = odsestrategias.ObtenerServicios(sStrategyName, scodcountry);
odsestrategias = null;
return(dtServicios);
}
//Método para Actualizar Servicios Ing. Carlos Alberto Hernandez
public EEstrategy Actualizar_Servicios(int icodstrategy, string sStrategyName, string sStrategyDescription, string scodCountry, bool sStrategyStatus, string sStrategyModiBy, String sStrategyDateModiBy)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_ACTUALIZAR_SERVICIOS", icodstrategy, sStrategyName, sStrategyDescription, scodCountry, sStrategyStatus, sStrategyModiBy, sStrategyDateModiBy);
EEstrategy oeaServicios = new EEstrategy();
oeaServicios.codStrategy = icodstrategy;
oeaServicios.StrategyName = sStrategyName;
oeaServicios.StrategyDescription = sStrategyDescription;
oeaServicios.codCountry = scodCountry;
oeaServicios.StrategyStatus = Convert.ToBoolean(sStrategyStatus.ToString().Trim());
oeaServicios.StrategyModiBy = sStrategyModiBy;
oeaServicios.StrategyDateModiBy = sStrategyDateModiBy;
return(oeaServicios);
}
//Método para Registrar Servicios
public EEstrategy RegistrarServiciosPK(string sStrategyName, string sStrategyDescription, string scodCountry, bool sStrategyStatus, string sStrategyCreateBy, string sStrategyDateBy, string sStrategyModiBy, String sStrategyDateModiBy)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_REGISTERSERVICES", sStrategyName, sStrategyDescription, scodCountry, sStrategyStatus, sStrategyCreateBy, sStrategyDateBy, sStrategyModiBy, sStrategyDateModiBy);
EEstrategy oerServicios = new EEstrategy();
oerServicios.StrategyName = sStrategyName;
oerServicios.StrategyDescription = sStrategyDescription;
oerServicios.codCountry = scodCountry;
oerServicios.StrategyStatus = Convert.ToBoolean(sStrategyStatus.ToString().Trim());
oerServicios.StrategyCreateBy = sStrategyCreateBy;
oerServicios.StrategyDateBy = sStrategyDateBy;
oerServicios.StrategyModiBy = sStrategyModiBy;
oerServicios.StrategyDateModiBy = sStrategyDateModiBy;
return(oerServicios);
}
// 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);
}
}
public DataTable Menu(string spresupuesto)
{
Conexion oConn = new Conexion();
DataTable dt = null;
EEstrategy oesUsuario = new EEstrategy();
dt = oConn.ejecutarDataTable("UP_WEBSIGE_PLALLENASERVICES", spresupuesto);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oesUsuario.codStrategy = Convert.ToInt32(dt.Rows[i]["cod_Strategy"].ToString().Trim());
oesUsuario.StrategyName = dt.Rows[i]["Strategy_Name"].ToString().Trim();
}
}
return(dt);
}
else
{
return(null);
}
}