/// <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); } }