//Método que Permite Consultar segmentos
public DataTable ObtenerSegments(int iid_SegmentsType)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_SEARCHSEGMENTS", iid_SegmentsType);
ESegments oeSegments = new ESegments();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oeSegments.id_Segment = Convert.ToInt32(dt.Rows[i]["id_Segment"].ToString().Trim());
oeSegments.Segment_Name = dt.Rows[i]["Segment_Name"].ToString().Trim();
oeSegments.id_SegmentsType = Convert.ToInt32(dt.Rows[i]["id_SegmentsType"].ToString().Trim());
oeSegments.Segment_Status = Convert.ToBoolean(dt.Rows[i]["Segment_Status"].ToString().Trim());
oeSegments.Segment_CreateBy = dt.Rows[i]["Segment_CreateBy"].ToString().Trim();
oeSegments.Segment_DateBy = Convert.ToDateTime(dt.Rows[i]["Segment_DateBy"].ToString().Trim());
oeSegments.Segment_ModiBy = dt.Rows[i]["Segment_ModiBy"].ToString().Trim();
oeSegments.Segment_DateModiBy = Convert.ToDateTime(dt.Rows[i]["Segment_DateModiBy"].ToString().Trim());
}
}
return(dt);
}
else
{
return(null);
}
}
//----Metodo que permite Actualizar segmentos Ing. Mauricio Ortiz
public ESegments Actualizar_Segments(int iid_Segment, int iid_SegmentsType, bool bSegment_Status,
string sSegment_ModiBy, DateTime tSegment_DateModiBy)
{
DSegments odaSegments = new DSegments();
ESegments oeaSegments = odaSegments.Actualizar_Segments(iid_Segment, iid_SegmentsType, bSegment_Status,
sSegment_ModiBy, tSegment_DateModiBy);
odaSegments = null;
return(oeaSegments);
}
//---Metodo de Consulta de segmento para actualizar Ing. Mauricio Ortiz
public DataTable BuscarSegmentsActual(string sSegment_Name, int iid_SegmentsType)
{
DSegments odseSegments = new DSegments();
ESegments oeSegments = new ESegments();
DataTable dtSegments = odseSegments.ObtenerSegmentsActual(sSegment_Name, iid_SegmentsType);
odseSegments = null;
return(dtSegments);
}
//---Metodo de Consulta de segmento Ing. Mauricio Ortiz
public DataTable BuscarSegments(int iid_SegmentsType)
{
DSegments odseSegments = new DSegments();
ESegments oeSegments = new ESegments();
DataTable dtSegments = odseSegments.ObtenerSegments(iid_SegmentsType);
odseSegments = null;
return(dtSegments);
}
//Método que permite registrar segmento Ing. Mauricio Ortiz
public ESegments RegistrarSegments(string sSegment_Name, int iid_SegmentsType, bool bSegment_Status,
string sSegment_CreateBy, DateTime tSegment_DateBy, string sSegment_ModiBy, DateTime tSegment_DateModiBy)
{
DSegments odrSegments = new DSegments();
ESegments oeSegments = odrSegments.RegistrarSegments(sSegment_Name, iid_SegmentsType, bSegment_Status,
sSegment_CreateBy, tSegment_DateBy, sSegment_ModiBy, tSegment_DateModiBy);
odrSegments = null;
return(oeSegments);
}
//Método para Actualizar Segments
public ESegments Actualizar_Segments(int iid_Segment, int iid_SegmentsType, bool bSegment_Status,
string sSegment_ModiBy, DateTime tSegment_DateModiBy)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_ACTUALIZA_SEGMENTS", iid_Segment, iid_SegmentsType, bSegment_Status,
sSegment_ModiBy, tSegment_DateModiBy);
ESegments oeaSegments = new ESegments();
oeaSegments.id_Segment = iid_Segment;
oeaSegments.id_SegmentsType = iid_SegmentsType;
oeaSegments.Segment_Status = bSegment_Status;
oeaSegments.Segment_ModiBy = sSegment_ModiBy;
oeaSegments.Segment_DateModiBy = tSegment_DateModiBy;
return(oeaSegments);
}
///Metodo para Registrar segmentos
public ESegments RegistrarSegments(string sSegment_Name, int iid_SegmentsType, bool bSegment_Status,
string sSegment_CreateBy, DateTime tSegment_DateBy, string sSegment_ModiBy, DateTime tSegment_DateModiBy)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_REGISTERSEGMENTS", sSegment_Name, iid_SegmentsType, bSegment_Status,
sSegment_CreateBy, tSegment_DateBy, sSegment_ModiBy, tSegment_DateModiBy);
ESegments oerSegments = new ESegments();
oerSegments.Segment_Name = sSegment_Name;
oerSegments.id_SegmentsType = iid_SegmentsType;
oerSegments.Segment_Status = bSegment_Status;
oerSegments.Segment_CreateBy = sSegment_CreateBy;
oerSegments.Segment_DateBy = tSegment_DateBy;
oerSegments.Segment_ModiBy = sSegment_ModiBy;
oerSegments.Segment_DateModiBy = tSegment_DateModiBy;
return(oerSegments);
}
//Método que Permite Consultar segmentos para actualizar
public DataTable ObtenerSegmentsActual(string sSegment_Name, int iid_SegmentsType)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEB_SEARCHPSEGMENTSACTUAL", sSegment_Name, iid_SegmentsType);
ESegments oeSegments = new ESegments();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oeSegments.id_Segment = Convert.ToInt32(dt.Rows[i]["id_Segment"].ToString().Trim());
oeSegments.Segment_Name = dt.Rows[i]["Segment_Name"].ToString().Trim();
oeSegments.id_SegmentsType = Convert.ToInt32(dt.Rows[i]["id_SegmentsType"].ToString().Trim());
oeSegments.Segment_Status = Convert.ToBoolean(dt.Rows[i]["Segment_Status"].ToString().Trim());
}
}
return(dt);
}
else
{
return(null);
}
}