Esempio n. 1
0
        protected void fillCustData()
        {
            String[] entId = Request.QueryString.GetValues("entityId");

            Panel_Customer.GroupingText = "Entity Details";

            Dictionary <String, Object> custObj = ActionLibrary.customerDetails.getContactDetails(entId[0], Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());

            String localId = "";


            if (custObj.ContainsKey(ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_CONTACT_DETAILS))
            {
                BackEndObjects.Contacts cOBJ = (BackEndObjects.Contacts)custObj[ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_CONTACT_DETAILS];
                Label_Cust_Name.Text  = cOBJ.getContactName();
                Label_Email.Text      = cOBJ.getEmailId();
                Label_Contact_No.Text = cOBJ.getMobNo();
                Label_From_Site.Text  = cOBJ.getFromSite();
                localId = cOBJ.getLocalityId();

                //If the contact object is created from the site then get the Main proudct details
                if (cOBJ.getFromSite().Equals("Y"))
                {
                    Dictionary <String, BackEndObjects.ProductCategory> mainProds = BackEndObjects.MainBusinessEntity.getProductDetailsforMainEntitybyIdDB(cOBJ.getContactEntityId());
                    String mainProdList = "";

                    foreach (KeyValuePair <String, BackEndObjects.ProductCategory> kvp in mainProds)
                    {
                        mainProdList = (mainProdList.Equals("") ? ((BackEndObjects.ProductCategory)kvp.Value).getProductCategoryName() : mainProdList +
                                        "," + ((BackEndObjects.ProductCategory)kvp.Value).getProductCategoryName());
                    }

                    Label_Main_Business.Text = (!mainProdList.Equals("") ? mainProdList : Label_Main_Business.Text);
                }
            }
            else
            {
                BackEndObjects.MainBusinessEntity mBObj = (BackEndObjects.MainBusinessEntity)custObj[ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_MAIN_BUSINESS_ENTITY];
                Label_Cust_Name.Text  = mBObj.getEntityName();
                Label_Email.Text      = mBObj.getEmailId();
                Label_Contact_No.Text = mBObj.getPhNo();
                Label_From_Site.Text  = "Y";

                Dictionary <String, BackEndObjects.ProductCategory> mainProds = mBObj.getMainProductServices();
                //BackEndObjects.MainBusinessEntity.getProductDetailsforMainEntitybyIdDB(mBObj.getEntityId());
                String mainProdList = "";

                if (mainProds != null)
                {
                    foreach (KeyValuePair <String, BackEndObjects.ProductCategory> kvp in mainProds)
                    {
                        mainProdList = (mainProdList.Equals("") ? ((BackEndObjects.ProductCategory)kvp.Value).getProductCategoryName() : mainProdList + "," + ((BackEndObjects.ProductCategory)kvp.Value).getProductCategoryName());
                    }
                }

                Label_Main_Business.Text = (!mainProdList.Equals("") ? mainProdList : Label_Main_Business.Text);
                if (mBObj.getAddressDetails() != null)
                {
                    localId = mBObj.getAddressDetails().getLocalityId();
                }
            }

            if (localId != null && !localId.Equals(""))
            {
                BackEndObjects.Localities lclObj = BackEndObjects.Localities.getLocalitybyIdDB(localId);
                BackEndObjects.City       ctObj  = BackEndObjects.Localities.getCityDetailsforLocalitywoOtherAsscLocalitiesDB(localId);
                BackEndObjects.State      stObj  = BackEndObjects.City.getStateDetailsforCitywoOtherAsscCitiesDB(ctObj.getCityId());
                BackEndObjects.Country    cntObj = BackEndObjects.State.getCountryDetailsforStatewoOtherAsscStatesDB(stObj.getStateId());

                Label_Country.Text  = cntObj.getCountryName();
                Label_State.Text    = stObj.getStateName();
                Label_City.Text     = ctObj.getCityName();
                Label_Locality.Text = lclObj.getLocalityName();
            }
        }
Esempio n. 2
0
        protected void loadClientAndVendorDetails(String rfId, String otherEntId)
        {
            String entId   = Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString();
            String context = Request.QueryString.GetValues("context")[0];

            context = context.Equals("client") || context.Equals("clientInvoiceGrid") ? "client" : context;

            String localId     = "";
            String vendDetails = "";
            String custDetails = "";
            String vendContact = "";
            String custContact = "";

            //Populate the vendor details
            Dictionary <String, Object> vendObj = ActionLibrary.customerDetails.
                                                  getContactDetails(otherEntId, Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());

            if (vendObj.ContainsKey(ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_CONTACT_DETAILS))
            {
                BackEndObjects.Contacts cOBJ = (BackEndObjects.Contacts)vendObj[ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_CONTACT_DETAILS];

                if (context.Equals("client"))
                {
                    Label_Vendor_Name.Text = cOBJ.getContactName();
                    vendContact            = cOBJ.getMobNo();
                    vendDetails           += cOBJ.getStreetName() + ",";
                    localId = cOBJ.getLocalityId();
                }
                else
                {
                    Label_Client_Name.Text = cOBJ.getContactName();
                    custContact            = cOBJ.getMobNo();
                    custDetails           += cOBJ.getStreetName() + ",";
                    localId = cOBJ.getLocalityId();
                }
            }
            else
            {
                BackEndObjects.MainBusinessEntity mBObj      = (BackEndObjects.MainBusinessEntity)vendObj[ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_MAIN_BUSINESS_ENTITY];
                BackEndObjects.AddressDetails     addrObjEnt = BackEndObjects.AddressDetails.getAddressforMainBusinessEntitybyIdDB(mBObj.getEntityId());
                if (context.Equals("client"))
                {
                    Label_Vendor_Name.Text = mBObj.getEntityName();
                    vendContact            = mBObj.getPhNo();
                    if (addrObjEnt != null)
                    {
                        vendDetails += addrObjEnt.getAddrLine1() + ",";
                    }
                }
                else
                {
                    Label_Client_Name.Text = mBObj.getEntityName();
                    custContact            = mBObj.getPhNo();
                    if (addrObjEnt != null)
                    {
                        custDetails += addrObjEnt.getAddrLine1() + ",";
                    }
                }
                if (mBObj.getAddressDetails() != null)
                {
                    localId = mBObj.getAddressDetails().getLocalityId();
                }
            }

            if (localId != null && !localId.Equals(""))
            {
                BackEndObjects.Localities lclObj = BackEndObjects.Localities.getLocalitybyIdDB(localId);
                BackEndObjects.City       ctObj  = BackEndObjects.Localities.getCityDetailsforLocalitywoOtherAsscLocalitiesDB(localId);
                String cityId = (ctObj != null && ctObj.getCityId() != null && !ctObj.getCityId().Equals("") ? ctObj.getCityId() : localId);
                BackEndObjects.State stObj = BackEndObjects.City.getStateDetailsforCitywoOtherAsscCitiesDB(cityId);
                if (cityId.Equals(localId))
                {
                    ctObj = BackEndObjects.City.getCitybyIdwoLocalitiesDB(localId);
                }
                String stateId = (stObj != null && stObj.getStateId() != null && !stObj.getStateId().Equals("") ? stObj.getStateId() : localId);
                BackEndObjects.Country cntObj = BackEndObjects.State.getCountryDetailsforStatewoOtherAsscStatesDB(stateId);
                if (stateId.Equals(localId))
                {
                    stObj = BackEndObjects.State.getStatebyIdwoCitiesDB(stateId);
                }

                if (context.Equals("client"))
                {
                    vendDetails += lclObj.getLocalityName() + "<br/>" + ctObj.getCityName() + "<br/>" + stObj.getStateName() + "<br/>" + cntObj.getCountryName() + "<br/> Phone:" + vendContact;
                }
                else
                {
                    custDetails += lclObj.getLocalityName() + "<br/>" + ctObj.getCityName() + "<br/>" + stObj.getStateName() + "<br/>" + cntObj.getCountryName() + "<br/> Phone:" + custContact;
                }
            }
            if (context.Equals("client"))
            {
                Label_Vendor_Addr.Text = vendDetails;
            }
            else
            {
                Label_Client_Addr.Text = custDetails;
            }

            //Get the customer details
            BackEndObjects.MainBusinessEntity custObj = BackEndObjects.MainBusinessEntity.getMainBusinessEntitybyIdwithLessDetailsDB(entId);

            if (context.Equals("client"))
            {
                Label_Client_Name.Text = custObj.getEntityName();
                custContact            = custObj.getPhNo();
            }
            else
            {
                Label_Vendor_Name.Text = custObj.getEntityName();
                vendContact            = custObj.getPhNo();
            }

            BackEndObjects.AddressDetails addrObj = BackEndObjects.AddressDetails.getAddressforMainBusinessEntitybyIdDB(entId);

            if (addrObj.getLocalityId() != null && !addrObj.getLocalityId().Equals(""))
            {
                if (context.Equals("client"))
                {
                    custDetails += addrObj.getAddrLine1() + ",";
                }
                else
                {
                    vendDetails += addrObj.getAddrLine1() + ",";
                }

                localId = addrObj.getLocalityId();

                if (localId != null && !localId.Equals(""))
                {
                    BackEndObjects.Localities lclObj = BackEndObjects.Localities.getLocalitybyIdDB(localId);
                    BackEndObjects.City       ctObj  = BackEndObjects.Localities.getCityDetailsforLocalitywoOtherAsscLocalitiesDB(localId);
                    String cityId = (ctObj != null && ctObj.getCityId() != null && !ctObj.getCityId().Equals("") ? ctObj.getCityId() : localId);
                    BackEndObjects.State stObj = BackEndObjects.City.getStateDetailsforCitywoOtherAsscCitiesDB(cityId);
                    if (cityId.Equals(localId))
                    {
                        ctObj = BackEndObjects.City.getCitybyIdwoLocalitiesDB(localId);
                    }
                    String stateId = (stObj != null && stObj.getStateId() != null && !stObj.getStateId().Equals("") ? stObj.getStateId() : localId);
                    BackEndObjects.Country cntObj = BackEndObjects.State.getCountryDetailsforStatewoOtherAsscStatesDB(stateId);
                    if (stateId.Equals(localId))
                    {
                        stObj = BackEndObjects.State.getStatebyIdwoCitiesDB(stateId);
                    }

                    if (context.Equals("client"))
                    {
                        custDetails += lclObj.getLocalityName() + "<br/>" + ctObj.getCityName() + "<br/>" + stObj.getStateName() + "<br/>" + cntObj.getCountryName() + "<br/> Phone:" + custContact;
                    }
                    else
                    {
                        vendDetails += lclObj.getLocalityName() + "<br/>" + ctObj.getCityName() + "<br/>" + stObj.getStateName() + "<br/>" + cntObj.getCountryName() + "<br/> Phone:" + vendContact;
                    }
                }
            }
            if (context.Equals("client"))
            {
                Label_Client_Addr.Text = custDetails;
            }
            else
            {
                Label_Vendor_Addr.Text = vendDetails;
            }
        }
Esempio n. 3
0
        protected void fillCustData()
        {
            Dictionary <String, Object> custObj = (Dictionary <String, Object>)Session[SessionFactory.ALL_SALE_ALL_POTENTIAL_SELECTED_CUSTOMER_OBJ];
            String localId = "";


            if (custObj.ContainsKey(ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_CONTACT_DETAILS))
            {
                BackEndObjects.Contacts cOBJ = (BackEndObjects.Contacts)custObj[ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_CONTACT_DETAILS];
                Label_Cust_Name.Text  = cOBJ.getContactName();
                Label_Email.Text      = cOBJ.getEmailId();
                Label_Contact_No.Text = cOBJ.getMobNo();
                Label_From_Site.Text  = cOBJ.getFromSite();
                localId = cOBJ.getLocalityId();

                //If the contact object is created from the site then get the Main proudct details
                if (cOBJ.getFromSite().Equals("Y"))
                {
                    Dictionary <String, BackEndObjects.ProductCategory> mainProds = BackEndObjects.MainBusinessEntity.getProductDetailsforMainEntitybyIdDB(cOBJ.getContactEntityId());
                    String mainProdList = "";

                    foreach (KeyValuePair <String, BackEndObjects.ProductCategory> kvp in mainProds)
                    {
                        mainProdList = (mainProdList.Equals("") ? ((BackEndObjects.ProductCategory)kvp.Value).getProductCategoryName() : mainProdList +
                                        "," + ((BackEndObjects.ProductCategory)kvp.Value).getProductCategoryName());
                    }

                    Label_Main_Business.Text = (!mainProdList.Equals("") ? mainProdList : Label_Main_Business.Text);
                }
                else
                {
                    String[] prodCatArray = cOBJ.getProdList().Split(new String[] { "," }, StringSplitOptions.RemoveEmptyEntries);
                    String   mainProdList = "";

                    for (int i = 0; i < prodCatArray.Length; i++)
                    {
                        mainProdList = (mainProdList.Equals("") ? BackEndObjects.ProductCategory.getProductCategorybyIdwoFeaturesDB(prodCatArray[i]).getProductCategoryName() : mainProdList +
                                        "," + BackEndObjects.ProductCategory.getProductCategorybyIdwoFeaturesDB(prodCatArray[i]).getProductCategoryName());
                    }

                    Label_Main_Business.Text = (!mainProdList.Equals("") ? mainProdList : Label_Main_Business.Text);
                }
            }
            else
            {
                BackEndObjects.MainBusinessEntity mBObj = (BackEndObjects.MainBusinessEntity)custObj[ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_MAIN_BUSINESS_ENTITY];
                Label_Cust_Name.Text  = mBObj.getEntityName();
                Label_Email.Text      = mBObj.getEmailId();
                Label_Contact_No.Text = mBObj.getPhNo();
                Label_From_Site.Text  = "Y";

                Dictionary <String, BackEndObjects.ProductCategory> mainProds = mBObj.getMainProductServices();
                //BackEndObjects.MainBusinessEntity.getProductDetailsforMainEntitybyIdDB(mBObj.getEntityId());
                String mainProdList = "";

                if (mainProds != null)
                {
                    foreach (KeyValuePair <String, BackEndObjects.ProductCategory> kvp in mainProds)
                    {
                        mainProdList = (mainProdList.Equals("") ? ((BackEndObjects.ProductCategory)kvp.Value).getProductCategoryName() : mainProdList + "," + ((BackEndObjects.ProductCategory)kvp.Value).getProductCategoryName());
                    }
                }

                Label_Main_Business.Text = (!mainProdList.Equals("") ? mainProdList : Label_Main_Business.Text);
                if (mBObj.getAddressDetails() != null)
                {
                    localId = mBObj.getAddressDetails().getLocalityId();
                }
            }

            if (localId != null && !localId.Equals(""))
            {
                BackEndObjects.Localities lclObj = BackEndObjects.Localities.getLocalitybyIdDB(localId);

                BackEndObjects.City ctObj = BackEndObjects.Localities.getCityDetailsforLocalitywoOtherAsscLocalitiesDB(localId);

                String cityId = (ctObj != null && ctObj.getCityId() != null && !ctObj.getCityId().Equals("") ? ctObj.getCityId() : localId);
                BackEndObjects.State stObj = BackEndObjects.City.getStateDetailsforCitywoOtherAsscCitiesDB(cityId);
                if (cityId.Equals(localId))
                {
                    ctObj = BackEndObjects.City.getCitybyIdwoLocalitiesDB(localId);
                }

                String stateId = (stObj != null && stObj.getStateId() != null && !stObj.getStateId().Equals("") ? stObj.getStateId() : localId);
                BackEndObjects.Country cntObj = BackEndObjects.State.getCountryDetailsforStatewoOtherAsscStatesDB(stateId);
                if (stateId.Equals(localId))
                {
                    stObj = BackEndObjects.State.getStatebyIdwoCitiesDB(stateId);
                }

                if (cntObj != null && cntObj.getCountryName() != null && !cntObj.getCountryName().Equals(""))
                {
                    Label_Country.Text = cntObj.getCountryName();
                }

                if (stObj != null && stObj.getStateName() != null && !stObj.getStateName().Equals(""))
                {
                    Label_State.Text = stObj.getStateName();
                }

                if (ctObj != null && ctObj.getCityName() != null && !ctObj.getCityName().Equals(""))
                {
                    Label_City.Text = ctObj.getCityName();
                }

                if (lclObj != null && lclObj.getLocalityName() != null && !lclObj.getLocalityName().Equals(""))
                {
                    Label_Locality.Text = lclObj.getLocalityName();
                }
            }
        }
Esempio n. 4
0
        protected void loadClientAndVendorDetails()
        {
            String context     = Request.QueryString.GetValues("context")[0];
            String ClientEntId = "";
            String vendorId    = "";

            Label_To.Text = "Vendor Details:";

            if (context.Equals("client"))
            {
                ClientEntId = Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString();
                vendorId    = Request.QueryString.GetValues("respCompId")[0];
            }
            else
            {
                Dictionary <String, bool> accessList = (Dictionary <String, bool>)Session[SessionFactory.ACCESSLIST_FOR_USER];

                if (!accessList[BackEndObjects.EntityAccessListRecord.ENTITY_ACCESS_LIST_RECORD_ACCESS_EDIT_POTENTIAL] &&
                    !accessList[BackEndObjects.EntityAccessListRecord.ENTITY_ACCESS_LIST_RECORD_ACCESS_OWNER_ACCESS])
                {
                    Button_Create_PO.Enabled = false;
                }

                ClientEntId = Request.QueryString.GetValues("EntId")[0];
                vendorId    = Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString();
                Label1.Text = "Sales Order";
            }

            String localId     = "";
            String vendDetails = "";
            String custDetails = "";
            String vendContact = "";
            String custContact = "";

            //Populate the vendor details
            Dictionary <String, Object> vendObj = ActionLibrary.customerDetails.getContactDetails(vendorId, Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());

            if (vendObj.ContainsKey(ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_CONTACT_DETAILS))
            {
                BackEndObjects.Contacts cOBJ = (BackEndObjects.Contacts)vendObj[ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_CONTACT_DETAILS];

                Label_Vendor_Name.Text = cOBJ.getContactName();
                vendContact            = cOBJ.getMobNo();
                localId = cOBJ.getLocalityId();
            }
            else
            {
                BackEndObjects.MainBusinessEntity mBObj = (BackEndObjects.MainBusinessEntity)vendObj[ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_MAIN_BUSINESS_ENTITY];
                Label_Vendor_Name.Text = mBObj.getEntityName();
                vendContact            = mBObj.getPhNo();

                if (mBObj.getAddressDetails() != null)
                {
                    localId = mBObj.getAddressDetails().getLocalityId();
                }
            }

            if (localId != null && !localId.Equals(""))
            {
                BackEndObjects.Localities lclObj = BackEndObjects.Localities.getLocalitybyIdDB(localId);
                BackEndObjects.City       ctObj  = BackEndObjects.Localities.getCityDetailsforLocalitywoOtherAsscLocalitiesDB(localId);
                String cityId = (ctObj != null && ctObj.getCityId() != null && !ctObj.getCityId().Equals("") ? ctObj.getCityId() : localId);
                BackEndObjects.State stObj = BackEndObjects.City.getStateDetailsforCitywoOtherAsscCitiesDB(cityId);
                if (cityId.Equals(localId))
                {
                    ctObj = BackEndObjects.City.getCitybyIdwoLocalitiesDB(localId);
                }
                String stateId = (stObj != null && stObj.getStateId() != null && !stObj.getStateId().Equals("") ? stObj.getStateId() : localId);
                BackEndObjects.Country cntObj = BackEndObjects.State.getCountryDetailsforStatewoOtherAsscStatesDB(stateId);
                if (stateId.Equals(localId))
                {
                    stObj = BackEndObjects.State.getStatebyIdwoCitiesDB(stateId);
                }

                vendDetails += lclObj.getLocalityName() + "<br/>" + ctObj.getCityName() + "<br/>" + stObj.getStateName() + "<br/>" + cntObj.getCountryName() + "<br/> Phone:" + vendContact;
            }
            Label_Vendor_Addr.Text = vendDetails;

            //Get the customer details
            //BackEndObjects.MainBusinessEntity.getMainBusinessEntitybyIdwithLessDetailsDB(ClientEntId);
            Dictionary <String, Object> custObj = ActionLibrary.customerDetails.getContactDetails(ClientEntId, Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());

            if (custObj.ContainsKey(ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_CONTACT_DETAILS))
            {
                BackEndObjects.Contacts cOBJ = (BackEndObjects.Contacts)custObj[ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_CONTACT_DETAILS];

                Label_Client_Name.Text = cOBJ.getContactName();
                custContact            = cOBJ.getMobNo();
                localId = cOBJ.getLocalityId();
            }
            else
            {
                BackEndObjects.MainBusinessEntity mBObj = (BackEndObjects.MainBusinessEntity)custObj[ActionLibrary.customerDetails.RETURN_OBJECT_TYPE_MAIN_BUSINESS_ENTITY];
                Label_Client_Name.Text = mBObj.getEntityName();
                custContact            = mBObj.getPhNo();

                if (mBObj.getAddressDetails() != null)
                {
                    localId = mBObj.getAddressDetails().getLocalityId();
                }
            }

            //BackEndObjects.AddressDetails addrObj=BackEndObjects.AddressDetails.getAddressforMainBusinessEntitybyIdDB(ClientEntId);

            /*if (addrObj.getLocalityId() != null && !addrObj.getLocalityId().Equals(""))
             * {
             *  custDetails += addrObj.getAddrLine1() + ",";
             *  localId = addrObj.getLocalityId();
             *
             *  BackEndObjects.Localities lclObj = BackEndObjects.Localities.getLocalitybyIdDB(localId);
             *  BackEndObjects.City ctObj = BackEndObjects.Localities.getCityDetailsforLocalitywoOtherAsscLocalitiesDB(localId);
             *  BackEndObjects.State stObj = BackEndObjects.City.getStateDetailsforCitywoOtherAsscCitiesDB(ctObj.getCityId());
             *  BackEndObjects.Country cntObj = BackEndObjects.State.getCountryDetailsforStatewoOtherAsscStatesDB(stObj.getStateId());
             *
             *  custDetails += lclObj.getLocalityName() + "<br/>" + ctObj.getCityName() + "<br/>" + stObj.getStateName() + "<br/>" + cntObj.getCountryName() + "<br/> Phone:" + custContact;
             *
             * }*/
            if (localId != null && !localId.Equals(""))
            {
                BackEndObjects.Localities lclObj = BackEndObjects.Localities.getLocalitybyIdDB(localId);
                BackEndObjects.City       ctObj  = BackEndObjects.Localities.getCityDetailsforLocalitywoOtherAsscLocalitiesDB(localId);
                String cityId = (ctObj != null && ctObj.getCityId() != null && !ctObj.getCityId().Equals("") ? ctObj.getCityId() : localId);
                BackEndObjects.State stObj = BackEndObjects.City.getStateDetailsforCitywoOtherAsscCitiesDB(cityId);
                if (cityId.Equals(localId))
                {
                    ctObj = BackEndObjects.City.getCitybyIdwoLocalitiesDB(localId);
                }
                String stateId = (stObj != null && stObj.getStateId() != null && !stObj.getStateId().Equals("") ? stObj.getStateId() : localId);
                BackEndObjects.Country cntObj = BackEndObjects.State.getCountryDetailsforStatewoOtherAsscStatesDB(stateId);
                if (stateId.Equals(localId))
                {
                    stObj = BackEndObjects.State.getStatebyIdwoCitiesDB(stateId);
                }

                custDetails += lclObj.getLocalityName() + "<br/>" + ctObj.getCityName() + "<br/>" + stObj.getStateName() + "<br/>" + cntObj.getCountryName() + "<br/> Phone:" + custContact;
            }
            Label_Client_Addr.Text = custDetails;
        }