//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);
}
}
//----Metodo que permite registrar Reportes vs Servicios
public EReportsStrategit RegistrarRepVsSer(int icod_Strategy, int iReport_id, bool bReportSt_Status,
string sReportSt_CreateBy, DateTime tReportSt_DateBy, string sReportSt_ModiBy, DateTime tReportSt_DateModiBy)
{
DReportsStrategit odrRepVsSer = new DReportsStrategit();
EReportsStrategit oeRepVsSer = odrRepVsSer.RegistrarRepVsEsPK(icod_Strategy, iReport_id, bReportSt_Status,
sReportSt_CreateBy, tReportSt_DateBy, sReportSt_ModiBy, tReportSt_DateModiBy);
odrRepVsSer = null;
return(oeRepVsSer);
}
//----Metodo que permite Actualizar Informes vs servicios ing. Mauricio Ortiz
public EReportsStrategit Actualizar_InformeVsServ(int iReportSt_id, int icod_Strategy, bool bReportSt_Status,
string sReportSt_ModiBy, DateTime tReportSt_DateModiBy)
{
Lucky.Data.Common.Application.DReportsStrategit odainformesvsServ = new Lucky.Data.Common.Application.DReportsStrategit();
EReportsStrategit oeaInformevsServ = odainformesvsServ.Actualizar_informevsServ(iReportSt_id, icod_Strategy, bReportSt_Status,
sReportSt_ModiBy, tReportSt_DateModiBy);
odainformesvsServ = null;
return(oeaInformevsServ);
}
//---Metodo de Consulta de Informes vs Servicios
public DataTable BuscarRepVsServ(int icodStrategy, int ReportId)
{
Lucky.Data.Common.Application.DReportsStrategit odseRepVsServ = new Lucky.Data.Common.Application.DReportsStrategit();
EReportsStrategit oeRepVsServ = new EReportsStrategit();
DataTable dtRepVsServ = odseRepVsServ.ObtenerRepVsEs(icodStrategy, ReportId);
odseRepVsServ = null;
return(dtRepVsServ);
}
//Método para Actualizar Informes VS servicios
public EReportsStrategit Actualizar_informevsServ(int iReportSt_id, int icod_Strategy, bool bReportSt_Status,
string sReportSt_ModiBy, DateTime tReportSt_DateModiBy)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_ACTUALIZA_INFORMEvsSERVICIO", iReportSt_id, icod_Strategy, bReportSt_Status,
sReportSt_ModiBy, tReportSt_DateModiBy);
EReportsStrategit oeaInformevsServ = new EReportsStrategit();
oeaInformevsServ.ReportSt_Status = bReportSt_Status;
oeaInformevsServ.ReportSt_ModiBy = sReportSt_ModiBy;
oeaInformevsServ.ReportSt_DateModiBy = tReportSt_DateModiBy;
return(oeaInformevsServ);
}
//Metodo para Registrar reportes vs servicios
public EReportsStrategit RegistrarRepVsEsPK(int icod_Strategy, int iReport_id, bool bReportSt_Status,
string sReportSt_CreateBy, DateTime tReportSt_DateBy, string sReportSt_ModiBy, DateTime tReportSt_DateModiBy)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_REGISTERREPVSSERV", icod_Strategy, iReport_id, bReportSt_Status,
sReportSt_CreateBy, tReportSt_DateBy, sReportSt_ModiBy, tReportSt_DateModiBy);
EReportsStrategit oerRepvsEs = new EReportsStrategit();
oerRepvsEs.cod_Strategy = icod_Strategy;
oerRepvsEs.Report_id = iReport_id;
oerRepvsEs.ReportSt_Status = bReportSt_Status;
oerRepvsEs.ReportSt_CreateBy = sReportSt_CreateBy;
oerRepvsEs.ReportSt_DateBy = tReportSt_DateBy;
oerRepvsEs.ReportSt_ModiBy = sReportSt_ModiBy;
oerRepvsEs.ReportSt_DateModiBy = tReportSt_DateModiBy;
return(oerRepvsEs);
}
//Nombre Metodo: SEARCHinfvsserv
//Función: Permite Consultar informes vs servicios
public DataTable ObtenerInfXServicio(int icodStrategy)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_CONSULTAREPORTESXESTRATEGIA", icodStrategy);
EReportsStrategit oeRepvsEs = new EReportsStrategit();
EReports oeReports = new EReports();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oeRepvsEs.Report_id = Convert.ToInt32(dt.Rows[i]["Report_id"].ToString().Trim());
oeReports.ReportNameReport = dt.Rows[i]["Report_NameReport"].ToString().Trim();
}
}
return(dt);
}
else
{
return(null);
}
}