//Metodo para Actualizar Clientes Puntos de venta Ing. Mauricio Ortiz
/// <summary>
/// Modifica: se agregan 2 campos codigo y sector
/// 21/09/2010 Magaly Jiménez
/// Modificación: se agrega campo de cod_Oficina
/// 12/11/2010 Magaly Jiménez
/// </summary>
/// <param name="iCompany_id"></param>
/// <param name="iid_PointOfsale"></param>
/// <param name="bClientPDV_Status"></param>
/// <param name="sClientPDV_ModiBy"></param>
/// <param name="tClientPDV_DateModiBy"></param>
/// <returns>oepdv</returns>
public EPuntosDV Actualizar_PDVClient(int iCompany_id, int iid_PointOfsale, string sClientPDV_Code, int iid_sector, long lcod_Oficina, int iId_Dex, bool bClientPDV_Status, string sClientPDV_ModiBy, DateTime tClientPDV_DateModiBy, string pdv_alias)
{
Lucky.Data.Common.Application.DPuntosDV odaPDV = new Lucky.Data.Common.Application.DPuntosDV();
EPuntosDV oepdv = odaPDV.Actualizar_PDVClient(iCompany_id, iid_PointOfsale, sClientPDV_Code, iid_sector, lcod_Oficina, iId_Dex, bClientPDV_Status, sClientPDV_ModiBy, tClientPDV_DateModiBy, pdv_alias);
odaPDV = null;
return(oepdv);
}
/// <summary>
/// Actualiza tabla Pointsale_Planning desde PDV_Cliente.
/// 09/03/2011 Magaly Jiménez
/// </summary>
/// <param name="iid_ClientPDV"></param>
/// <param name="lcod_Oficina"></param>
/// <param name="iid_malla"></param>
/// <param name="iid_sector"></param>
/// <returns></returns>
public EPuntosDV Actualizar_PDVPlanningPDVClient(int iid_ClientPDV, long lcod_Oficina, int iid_malla, int iid_sector, string pdv_contact)
{
Lucky.Data.Common.Application.DPuntosDV odaplaPDV = new Lucky.Data.Common.Application.DPuntosDV();
EPuntosDV oepdv = odaplaPDV.Actualizar_PDVPlanningPDVClient(iid_ClientPDV, lcod_Oficina, iid_malla, iid_sector, pdv_contact);
odaplaPDV = null;
return(oepdv);
}
//---Metodo de Consulta de Clientes del Puntos de venta
public DataTable BuscarPDVClient(int iid_PointOfsale)
{
Lucky.Data.Common.Application.DPuntosDV odsePDV = new Lucky.Data.Common.Application.DPuntosDV();
DataTable dtPDVClient = odsePDV.ObtenerPDVClient(iid_PointOfsale);
odsePDV = null;
return(dtPDVClient);
}
/// <summary>
/// Actualiza cadena en tabla de cadena en BD intermedia
/// 03/02/2011 Magaly Jiménez
/// </summary>
/// <param name="spdv_codChannel"></param>
/// <param name="bpdv_status"></param>
/// <param name="sNodeCommercial"></param>
/// <returns></returns>
public EPuntosDV Actualizar_Cadena(string spdv_codChannel, string sNodeCommercial)
{
Lucky.Data.Common.Application.DPuntosDV odaCadenatmp = new Lucky.Data.Common.Application.DPuntosDV();
EPuntosDV oecadenatmp = odaCadenatmp.Actualizar_Cadenatmp(spdv_codChannel, sNodeCommercial);
odaCadenatmp = null;
return(oecadenatmp);
}
/// <summary>
///INSERTA pdvCliente en BD intermedia
/// 02/02/2011 Magaly Jiménez
/// </summary>
/// <returns></returns>
public EPuntosDV RegistrarClientPDVTMP()
{
Lucky.Data.Common.Application.DPuntosDV odrPDVtmp = new Lucky.Data.Common.Application.DPuntosDV();
EPuntosDV oepdvtmp = odrPDVtmp.registrarClientPDVPKTMP();
odrPDVtmp = null;
return(oepdvtmp);
}
/// <summary>
/// actualiza en planning campos modificados desde PDV
/// 09/03/2011 Magaly Jiménez
/// </summary>
/// <param name="iid_ClientPDV"></param>
/// <param name="scod_City"></param>
/// <param name="iidNodeComType"></param>
/// <param name="sNodeCommercial"></param>
/// <returns></returns>
public EPuntosDV Actualizar_NodePlaPDV(int iid_ClientPDV, string scod_City, int iidNodeComType, string sNodeCommercial)
{
Lucky.Data.Common.Application.DPuntosDV odanodePDV = new Lucky.Data.Common.Application.DPuntosDV();
EPuntosDV oenodepdv = odanodePDV.Actualizar_NodoPlanningPDV(iid_ClientPDV, scod_City, iidNodeComType, sNodeCommercial);
odanodePDV = null;
return(oenodepdv);
}
/// <summary>
/// llena grilla de consulta
/// </summary>
/// <param name="iiCompany_id"></param>
/// <param name="spdv_codCountry"></param>
/// <param name="spdv_codChannel"></param>
/// <param name="iidNodeComType"></param>
/// <param name="sNodeCommercial"></param>
/// <returns></returns>
public DataTable ConsultarPDVClientGrilla(int iiCompany_id, string spdv_codCountry, string spdv_codChannel, int iidNodeComType, string sNodeCommercial)
{
Lucky.Data.Common.Application.DPuntosDV odsePDVGV = new Lucky.Data.Common.Application.DPuntosDV();
EPuntosDV oePDVGVGV = new EPuntosDV();
DataTable dtPDVClientGV = odsePDVGV.ConsultarPDVClientGrilla(iiCompany_id, spdv_codCountry, spdv_codChannel, iidNodeComType, sNodeCommercial);
odsePDVGV = null;
return(dtPDVClientGV);
}
/// <summary>
/// consulta cademas de la tabla intermedia
/// 02/02/2011 Magaly Jiménez
/// </summary>
/// <param name="sID_CADENA"></param>
/// <returns></returns>
public DataTable ObtenerCanedatmp(string sID_CADENA)
{
Lucky.Data.Common.Application.DPuntosDV odsecadenatmp = new Lucky.Data.Common.Application.DPuntosDV();
EPuntosDV oecadenatmp = new EPuntosDV();
DataTable dtCadenatmp = odsecadenatmp.ObtenerCADENA(sID_CADENA);
odsecadenatmp = null;
return(dtCadenatmp);
}
//---Metodo de Consulta de Puntos de venta
public DataTable BuscarPDV(string sPdvCodProvince, string sPdvRegTax, string sPdvName, string sPdvChannel)
{
Lucky.Data.Common.Application.DPuntosDV odsePDV = new Lucky.Data.Common.Application.DPuntosDV();
EPuntosDV oePDV = new EPuntosDV();
DataTable dtPDV = odsePDV.ObtenerPDV(sPdvCodProvince, sPdvRegTax, sPdvName, sPdvChannel);
odsePDV = null;
return(dtPDV);
}
/// <summary>
/// Metodo para Actualizar PDV
/// Módificación 25/08/2010 se elimina parametro spdvCode ya no existe en la tabla. Ing. Mauricio Ortiz.
/// </summary>
/// <param name="iid_PointOfsale"></param>
/// <param name="sid_typeDocument"></param>
/// <param name="spdv_RegTax"></param>
/// <param name="spdv_contact1"></param>
/// <param name="spdv_position1"></param>
/// <param name="spdv_contact2"></param>
/// <param name="spdv_position2"></param>
/// <param name="spdv_RazónSocial"></param>
/// <param name="spdv_Name"></param>
/// <param name="spdv_Phone"></param>
/// <param name="spdv_Anexo"></param>
/// <param name="spdv_Fax"></param>
/// <param name="spdv_codCountry"></param>
/// <param name="spdv_codDepartment"></param>
/// <param name="spdv_codProvince"></param>
/// <param name="spdv_codDistrict"></param>
/// <param name="spdv_codCommunity"></param>
/// <param name="spdv_Address"></param>
/// <param name="spdv_email"></param>
/// <param name="spdv_codChannel"></param>
/// <param name="iidNodeComType"></param>
/// <param name="sNodeCommercial"></param>
/// <param name="iid_Segment"></param>
/// <param name="bpdv_status"></param>
/// <param name="sPdv_ModiBy"></param>
/// <param name="tPdv_DateModiBy"></param>
/// <returns></returns>
public EPuntosDV Actualizar_PDV(int iid_PointOfsale, string sid_typeDocument, string spdv_RegTax,
string spdv_contact1, string spdv_position1, string spdv_contact2, string spdv_position2, string spdv_RazónSocial,
string spdv_Name, string spdv_Phone, string spdv_Anexo, string spdv_Fax, string spdv_codCountry,
string spdv_codDepartment, string spdv_codProvince, string spdv_codDistrict, string spdv_codCommunity,
string spdv_Address, string spdv_email, string spdv_codChannel, int iidNodeComType, string sNodeCommercial, int iid_Segment,
bool bpdv_status, string sPdv_ModiBy, DateTime tPdv_DateModiBy)
{
Lucky.Data.Common.Application.DPuntosDV odaPDV = new Lucky.Data.Common.Application.DPuntosDV();
EPuntosDV oepdv = odaPDV.Actualizar_PDV(iid_PointOfsale, sid_typeDocument, spdv_RegTax,
spdv_contact1, spdv_position1, spdv_contact2, spdv_position2, spdv_RazónSocial, spdv_Name, spdv_Phone, spdv_Anexo, spdv_Fax, spdv_codCountry,
spdv_codDepartment, spdv_codProvince, spdv_codDistrict, spdv_codCommunity, spdv_Address, spdv_email, spdv_codChannel, iidNodeComType, sNodeCommercial, iid_Segment,
bpdv_status, sPdv_ModiBy, tPdv_DateModiBy);
odaPDV = null;
return(oepdv);
}
//----
/// <summary>
/// Metodo que permite registrar PDV
/// Módificación 25/08/2010 se elimina parametro spdvCode ya no existe en la tabla. Ing. Mauricio Ortiz.
/// </summary>
/// <param name="sid_typeDocument"></param>
/// <param name="spdvRegTax"></param>
/// <param name="spdvcontact1"></param>
/// <param name="spdvposition1"></param>
/// <param name="spdvcontact2"></param>
/// <param name="spdvposition2"></param>
/// <param name="spdvRazónSocial"></param>
/// <param name="spdvName"></param>
/// <param name="spdvPhone"></param>
/// <param name="spdvAnexo"></param>
/// <param name="spdvFax"></param>
/// <param name="spdvcodCountry"></param>
/// <param name="spdvcodDepartment"></param>
/// <param name="spdvcodProvince"></param>
/// <param name="spdvcodDistrict"></param>
/// <param name="spdvcodCommunity"></param>
/// <param name="spdvAddress"></param>
/// <param name="spdvemail"></param>
/// <param name="spdvcodChannel"></param>
/// <param name="iidNodeComType"></param>
/// <param name="sNodeCommercial"></param>
/// <param name="iid_Segment"></param>
/// <param name="bpdvstatus"></param>
/// <param name="sPdvCreateBy"></param>
/// <param name="tPdvDateBy"></param>
/// <param name="sPdvModiBy"></param>
/// <param name="tPdvDateModiBy"></param>
/// <returns>oepdv</returns>
public EPuntosDV RegistrarPDV(string sid_typeDocument, string spdvRegTax,
string spdvcontact1, string spdvposition1, string spdvcontact2, string spdvposition2, string spdvRazónSocial,
string spdvName, string spdvPhone, string spdvAnexo, string spdvFax, string spdvcodCountry, string spdvcodDepartment,
string spdvcodProvince, string spdvcodDistrict, string spdvcodCommunity, string spdvAddress, string spdvemail,
string spdvcodChannel, int iidNodeComType, string sNodeCommercial, int iid_Segment, bool bpdvstatus, string sPdvCreateBy, DateTime tPdvDateBy,
string sPdvModiBy, DateTime tPdvDateModiBy)
{
Lucky.Data.Common.Application.DPuntosDV odrPDV = new Lucky.Data.Common.Application.DPuntosDV();
EPuntosDV oepdv = odrPDV.registrarPDVPK(sid_typeDocument, spdvRegTax,
spdvcontact1, spdvposition1, spdvcontact2, spdvposition2, spdvRazónSocial,
spdvName, spdvPhone, spdvAnexo, spdvFax, spdvcodCountry, spdvcodDepartment,
spdvcodProvince, spdvcodDistrict, spdvcodCommunity, spdvAddress, spdvemail,
spdvcodChannel, iidNodeComType, sNodeCommercial, iid_Segment, bpdvstatus, sPdvCreateBy, tPdvDateBy,
sPdvModiBy, tPdvDateModiBy);
odrPDV = null;
return(oepdv);
}
