/// <summary> /// Metodo para Registrar Nodos Comerciales /// Modificaciones: 26-06-09 Se elimina el parametro sNodeCommercial es un identity Ing. Mauricio Ortiz /// Modificaciones: 10-06-2011 Se agrega parámetros para registrar relación entre el Nodo Comercial y Canales. Angel Ortiz. /// Modificaciones: 10-06-2011 Se agrega parámetro para insertar registro de dirección. Angel Ortiz. /// </summary> public ENodeComercial RegistrarNodeComercial(string scommercialNodeName, int iidNodeComType, int icorporacionId, string sdireccion, bool bNodeCommercialStatus, string sNodeCommercialCreateBy, DateTime tNodeCommercialDateBy, string sNodeCommercialModiBy, DateTime tNodeCommercialDatemodiBy, string sNodeCommercial_codCountry, string sNodeCommercial_codDepartment, string sNodeCommercial_codProvince, string sNodeCommercial_codDistrict, string sNodeCommercial_codCommunity) { oConn = new Conexion(1); int idNode = Convert.ToInt32(oConn.ejecutarEscalar("UP_WEBSIGE_REGISTERNODECOMERCIAL", scommercialNodeName, iidNodeComType, icorporacionId, sdireccion, bNodeCommercialStatus, sNodeCommercialCreateBy, tNodeCommercialDateBy, sNodeCommercialModiBy, tNodeCommercialDatemodiBy, sNodeCommercial_codCountry, sNodeCommercial_codDepartment, sNodeCommercial_codProvince, sNodeCommercial_codDistrict, sNodeCommercial_codCommunity)); ENodeComercial oernodecome = new ENodeComercial(); oernodecome.NodeCommercial = idNode; oernodecome.commercialNodeName = scommercialNodeName; oernodecome.idNodeComType = iidNodeComType; oernodecome.id_corporacion = icorporacionId; oernodecome.NodeCommercialDireccion = sdireccion; oernodecome.NodeCommercialStatus = bNodeCommercialStatus; oernodecome.NodeCommercialCreateBy = sNodeCommercialCreateBy; oernodecome.NodeCommercialDateBy = tNodeCommercialDateBy; oernodecome.NodeCommercialModiBy = sNodeCommercialModiBy; oernodecome.NodeCommercialDatemodiBy = tNodeCommercialDatemodiBy; oernodecome.NodeCommercial_codCountry = sNodeCommercial_codCountry; oernodecome.NodeCommercial_codDepartment = sNodeCommercial_codDepartment; oernodecome.NodeCommercial_codProvince = sNodeCommercial_codProvince; oernodecome.NodeCommercial_codDistrict = sNodeCommercial_codDistrict; oernodecome.NodeCommercial_codCommunity = sNodeCommercial_codCommunity; return(oernodecome); }
/// <summary> /// Ontener /// 22/03/2011 Ditmar Estrada /// </summary> /// <returns></returns> public List <ENodeComercial> Get_NodeComercialBy_idPlanning(string sid_Planning) { oConn = new Conexion(1); List <ENodeComercial> oListENodeComercial = new List <ENodeComercial>(); try { SqlDataReader sdr = oConn.ejecutarDataReader("UP_WEBXPLORA_AD_OBTENER_NODECOMERCIAL_BY_idPlanning", sid_Planning); while (sdr.Read()) { ENodeComercial oENodeComercial = new ENodeComercial(); oENodeComercial.NodeCommercial = (Int32)sdr.GetValue(sdr.GetOrdinal("id_NodeCommercial")); oENodeComercial.commercialNodeName = (String)sdr.GetValue(sdr.GetOrdinal("commercialNodeName")); oENodeComercial.idNodeComType = (Int32)sdr.GetValue(sdr.GetOrdinal("idNodeComType")); oENodeComercial.NodeCommercialStatus = (Boolean)sdr.GetValue(sdr.GetOrdinal("NodeCommercial_Status")); oENodeComercial.NodeCommercialCreateBy = (String)sdr.GetValue(sdr.GetOrdinal("NodeCommercial_CreateBy")); oENodeComercial.NodeCommercialDateBy = (DateTime)sdr.GetValue(sdr.GetOrdinal("NodeCommercial_DateBy")); oENodeComercial.NodeCommercialModiBy = (String)sdr.GetValue(sdr.GetOrdinal("NodeCommercial_ModiBy")); oENodeComercial.NodeCommercialDatemodiBy = (DateTime)sdr.GetValue(sdr.GetOrdinal("NodeCommercial_DatemodiBy")); oListENodeComercial.Add(oENodeComercial); } sdr.Close(); } catch (Exception ex) { throw ex; } return(oListENodeComercial); }
/// <summary> /// consulta cademas de la tabla intermedia /// 02/02/2011 Magaly Jiménez /// </summary> /// <param name="sID_CADENA"></param> /// <returns></returns> public DataTable ObtenerCADENA(string sID_CADENA) { DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_AD_OBTENENODECOMERCIALTMP", sID_CADENA); EPuntosDV oePdvtmp = new EPuntosDV(); ENodeComercial oeNodetmp = new ENodeComercial(); if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i <= dt.Rows.Count - 1; i++) { //oePdvtmp.pdvcodChannel = dt.Rows[i]["pdv_codChannel"].ToString().Trim(); //oeNodetmp.NodeCommercial = Convert.ToInt32(dt.Rows[i]["NodeCommercial"].ToString().Trim()); //oeNodetmp.commercialNodeName = dt.Rows[i]["commercialNodeName"].ToString().Trim(); //oeNodetmp.NodeCommercialStatus = Convert.ToBoolean(dt.Rows[i]["NodeCommercialStatus"].ToString().Trim()); } } return(dt); } else { return(null); } }
/// <summary> /// Actualiza nombre de cadena o nodo comercial y estado en Bd intermedia /// 03/02/2011 Magaly Jiménez /// </summary> /// <param name="iNodeCommercial"></param> /// <param name="scommercialNodeName"></param> /// <param name="bNodeCommercialStatus"></param> /// <returns></returns> public ENodeComercial ActualizarNodeComercialTMP(int iNodeCommercial, string scommercialNodeName, bool bNodeCommercialStatus) { DNodeComercial odanodecomecadena = new DNodeComercial(); ENodeComercial oeanodecomecadena = odanodecomecadena.ActualizarNodeComercialTMP(iNodeCommercial, scommercialNodeName, bNodeCommercialStatus); odanodecomecadena = null; return(oeanodecomecadena); }
/// <summary> /// Metodo para Actualizar Nodos Comerciales /// Modificaciones: 26-06-09 Se cambia el parametro sNodeCommercial es un int Ing. Mauricio Ortiz /// Modificaciones: 15-08-11 Se agrega el parametro iIdCorporacion de tipo int. Joseph Gonzales /// </summary> public ENodeComercial ActualizarNodeComercial(int iNodeCommercial, string scommercialNodeName, int iidNodeComType, int iIdCorporacion, string sNodeCommercial_Direccion, bool bNodeCommercialStatus, string sNodeCommercialModiBy, DateTime tNodeCommercialDatemodiBy, string sNodeCommercial_codCountry, string sNodeCommercial_codDepartment, string sNodeCommercial_codProvince, string sNodeCommercial_codDistrict, string sNodeCommercial_codCommunity) { DNodeComercial odanodecome = new DNodeComercial(); ENodeComercial oeanodecome = odanodecome.ActualizarNodeComercial(iNodeCommercial, scommercialNodeName, iidNodeComType, iIdCorporacion, sNodeCommercial_Direccion, bNodeCommercialStatus, sNodeCommercialModiBy, tNodeCommercialDatemodiBy, sNodeCommercial_codCountry, sNodeCommercial_codDepartment, sNodeCommercial_codProvince, sNodeCommercial_codDistrict, sNodeCommercial_codCountry); odanodecome = null; return(oeanodecome); }
/// <summary> /// Método para Registrar Nodos Comerciales /// Modificaciones: 26-06-09 Se elimina el parametro sNodeCommercial es un identity Ing. Mauricio Ortiz. /// Modificaciones: 10-06-11 Se agrega parámetros para registrar relación entre el Nodo Comercial y Canales. Angel Ortiz. /// Modificaciones: 12-08-11 Se agrega el párámetro iIdCorporacion para registrar por corporación(no obligatorio). Angel Ortiz. /// </summary> public ENodeComercial RegistrarNodeComercial(string scommercialNodeName, int iidNodeComType, int iIdCorporacion, string sdireccion, bool bNodeCommercialStatus, string sNodeCommercialCreateBy, DateTime tNodeCommercialDateBy, string sNodeCommercialModiBy, DateTime tNodeCommercialDatemodiBy, string sNodeCommercial_codCountry, string sNodeCommercial_codDepartment, string sNodeCommercial_codProvince, string sNodeCommercial_codDistrict, string sNodeCommercial_codCommunity) { DNodeComercial odrnodecome = new DNodeComercial(); ENodeComercial oernodecome = odrnodecome.RegistrarNodeComercial(scommercialNodeName, iidNodeComType, iIdCorporacion, sdireccion, bNodeCommercialStatus, sNodeCommercialCreateBy, tNodeCommercialDateBy, sNodeCommercialModiBy, tNodeCommercialDatemodiBy, sNodeCommercial_codCountry, sNodeCommercial_codDepartment, sNodeCommercial_codProvince, sNodeCommercial_codDistrict, sNodeCommercial_codCommunity); odrnodecome = null; return(oernodecome); }
/// <summary> /// Actualiza nombre de cadena o nodo comercial y estado en DB intermedia /// 03/02/2011 Magaly Jiménez /// </summary> /// <param name="iNodeCommercial"></param> /// <param name="scommercialNodeName"></param> /// <param name="bNodeCommercialStatus"></param> /// <returns></returns> public ENodeComercial ActualizarNodeComercialTMP(int iNodeCommercial, string scommercialNodeName, bool bNodeCommercialStatus) { oConn = new Conexion(2); DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_AD_ACTUALIZARNODECOMERCIALDENODOTMP", iNodeCommercial, scommercialNodeName, bNodeCommercialStatus); ENodeComercial oeanodecomeCadena = new ENodeComercial(); //oeanodecome.NodeCommercial = iNodeCommercial; //oeanodecome.commercialNodeName = scommercialNodeName; //oeanodecome.NodeCommercialStatus = bNodeCommercialStatus; return(oeanodecomeCadena); }
/// <summary> /// Metodo para consultar Nodos Comerciales /// Modificaciones: 26-06-09 Se elimina el parametro sNodeCommercial n/a para la consulta Ing. Mauricio Ortiz /// Modificaciones: 14-08-1 Se agrega los campos de corporación. /// </summary> public DataTable ConsultarNodeComercial(string snamenodeComercial, int idtipo, int idCorporacion) { oConn = new Conexion(1); DataTable dt = oConn.ejecutarDataTable("UP_WEBSIGE_SEARCHNODECOMERCIAL", snamenodeComercial, idtipo, idCorporacion); ENodeComercial oecnodecome = new ENodeComercial(); if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i <= dt.Rows.Count - 1; i++) { oecnodecome.NodeCommercial = Convert.ToInt32(dt.Rows[i]["NodeCommercial"].ToString().Trim()); oecnodecome.commercialNodeName = dt.Rows[i]["commercialNodeName"].ToString().Trim(); oecnodecome.idNodeComType = Convert.ToInt32(dt.Rows[i]["idNodeComType"].ToString().Trim()); oecnodecome.NodeComType_name = dt.Rows[i]["NodeComType_name"].ToString().Trim(); oecnodecome.NodeCommercialDireccion = dt.Rows[i]["NodeCommercial_Direccion"].ToString().Trim(); oecnodecome.id_corporacion = Convert.ToInt32(dt.Rows[i]["NodeCommercial_corp_id"].ToString().Trim()); oecnodecome.corporacion_name = dt.Rows[i]["corp_name"].ToString().Trim(); oecnodecome.NodeCommercialStatus = Convert.ToBoolean(dt.Rows[i]["NodeCommercial_Status"].ToString().Trim()); oecnodecome.NodeCommercialCreateBy = dt.Rows[i]["NodeCommercial_CreateBy"].ToString().Trim(); oecnodecome.NodeCommercialDateBy = Convert.ToDateTime(dt.Rows[i]["NodeCommercial_DateBy"].ToString().Trim()); oecnodecome.NodeCommercialModiBy = dt.Rows[i]["NodeCommercial_ModiBy"].ToString().Trim(); oecnodecome.NodeCommercial_codCountry = dt.Rows[i]["NodeCommercial_codCountry"].ToString().Trim(); oecnodecome.Country_name = dt.Rows[i]["Name_Country"].ToString().Trim(); oecnodecome.NodeCommercial_codDepartment = dt.Rows[i]["NodeCommercial_codDepartment"].ToString().Trim(); oecnodecome.Department_name = dt.Rows[i]["Name_dpto"].ToString().Trim(); oecnodecome.NodeCommercial_codProvince = dt.Rows[i]["NodeCommercial_codProvince"].ToString().Trim(); oecnodecome.Province_name = dt.Rows[i]["Name_City"].ToString().Trim(); oecnodecome.NodeCommercial_codDistrict = dt.Rows[i]["NodeCommercial_codDistrict"].ToString().Trim(); oecnodecome.District_name = dt.Rows[i]["Name_Local"].ToString().Trim(); oecnodecome.NodeCommercial_codCommunity = dt.Rows[i]["NodeCommercial_codCommunity"].ToString().Trim(); oecnodecome.Community_name = dt.Rows[i]["Name_Community"].ToString().Trim(); } } return(dt); } else { return(null); } }
/// <summary> /// Metodo para Actualizar Nodos Comerciales /// Modificaciones: 26-06-09 Se cambia el parametro sNodeCommercial es un int Ing. Mauricio Ortiz /// Se agrega parametro para el atributo direccion. - Angel Ortiz 30/06/2011 /// </summary> public ENodeComercial ActualizarNodeComercial(int iNodeCommercial, string scommercialNodeName, int iidNodeComType, int iIdCorporacion, string sNodeCommercial_Direccion, bool bNodeCommercialStatus, string sNodeCommercialModiBy, DateTime tNodeCommercialDatemodiBy, string sNodeCommercial_codCountry, string sNodeCommercial_codDepartment, string sNodeCommercial_codProvince, string sNodeCommercial_codDistrict, string sNodeCommercial_codCommunity) { oConn = new Conexion(1); DataTable dt = oConn.ejecutarDataTable("UP_WEBSIGE_ACTUALIZARNODECOMERCIAL", iNodeCommercial, scommercialNodeName, iidNodeComType, iIdCorporacion, sNodeCommercial_Direccion, bNodeCommercialStatus, sNodeCommercialModiBy, tNodeCommercialDatemodiBy, sNodeCommercial_codCountry, sNodeCommercial_codDepartment, sNodeCommercial_codProvince, sNodeCommercial_codDistrict, sNodeCommercial_codCommunity); ENodeComercial oeanodecome = new ENodeComercial(); oeanodecome.NodeCommercial = iNodeCommercial; oeanodecome.commercialNodeName = scommercialNodeName; oeanodecome.idNodeComType = iidNodeComType; oeanodecome.id_corporacion = iIdCorporacion; oeanodecome.NodeCommercialDireccion = sNodeCommercial_Direccion; oeanodecome.NodeCommercialStatus = bNodeCommercialStatus; oeanodecome.NodeCommercialModiBy = sNodeCommercialModiBy; oeanodecome.NodeCommercialDatemodiBy = tNodeCommercialDatemodiBy; oeanodecome.NodeCommercial_codCountry = sNodeCommercial_codCountry; oeanodecome.NodeCommercial_codDepartment = sNodeCommercial_codDepartment; oeanodecome.NodeCommercial_codProvince = sNodeCommercial_codProvince; oeanodecome.NodeCommercial_codDistrict = sNodeCommercial_codDistrict; oeanodecome.NodeCommercial_codCommunity = sNodeCommercial_codCommunity; return(oeanodecome); }