public static List <DictrictList> GetDictrict(string Province, string Amphur)
        {
            List <DictrictList> Dictrict = new List <DictrictList>();

            #region
            //string sql = "Select DistrictId,DistrictName from tbl_District where ProvinceId = '" + Province.Trim() + "' AND AmphurId = '" + Amphur.Trim() + "'";
            //DataSet ds_s = new Class1().SqlGet(sql, "tbl_District");
            //long row = ds_s.Tables[0].Rows.Count;
            //if (row != 0)
            //{
            //    for (int i = 0; i < row; i++)
            //    {
            //        string DistrictName = ds_s.Tables["tbl_District"].Rows[i]["DistrictName"].ToString();
            //        string DistrictId = ds_s.Tables["tbl_District"].Rows[i]["DistrictId"].ToString();

            //        Dictrict.Add(new DictrictList { Dtext = DistrictName, Dvalue = DistrictId });
            //    }
            //}
            #endregion

            ApiGet apiData = new ApiGet();

            var provincename = JsonConvert.DeserializeObject <List <DeliveryCost> >(apiData.GetDataDeliveryCost("http://ccp-info.com/APIDeliveryCost/api/DeliveryCost/getdata"));
            var q            = provincename.Where(x => x.DeliveryCostProvince == Province && x.DeliveryCostDistrict == Amphur);//.GroupBy(x => new { x.DeliveryCostProvince, x.DeliveryCostDistrict,x.DeliveryCostTambon, x.DeliveryCostDistance, x.DeliveryCostY4, x.DeliveryCostY3 });

            foreach (var d in q)
            {
                Dictrict.Add(new DictrictList {
                    Dtext = d.DeliveryCostTambon, Dvalue = d.DeliveryCostDistance + "|" + d.DeliveryCostY4 + "|" + d.DeliveryCostY3 + "|" + d.DeliveryCostID
                });
            }

            return(Dictrict);
        }
        //public static async System.Threading.Tasks.Task<List<ProvinceList>> GetProvinceAsync()
        //{
        //    List<ProvinceList> Provinceget = new List<ProvinceList>();

        //    var result = await NetworkServices.GetDistance();

        //    #region
        //    //foreach (var name in result)
        //    //{
        //    //    var P_Province = name.DeliveryCostProvince;

        //    //}
        //    #endregion

        //    result.ForEach(c =>
        //    {
        //        var P_Province = c.DeliveryCostProvince;
        //        Provinceget.Add(new ProvinceList { Pvalueqq = P_Province.ToString()});
        //    }
        //    );

        //    return Provinceget;
        //}


        public static List <ProvinceList> GetProvince()
        {
            List <ProvinceList> Province = new List <ProvinceList>();

            #region
            //string sql = "Select ProvinceId,ProvinceName from tbl_Province";
            //DataSet ds_s = new Class1().SqlGet(sql, "tbl_Provice");
            //long row = ds_s.Tables[0].Rows.Count;
            //if (row != 0)
            //{
            //    for (int i = 0; i < row; i++)
            //    {
            //        string ProvinceId = ds_s.Tables["tbl_Provice"].Rows[i]["ProvinceId"].ToString();
            //        string provincename = ds_s.Tables["tbl_Provice"].Rows[i]["ProvinceName"].ToString();
            //        Province.Add(new ProvinceList { Ptext = provincename, Pvalue = ProvinceId });

            //    }
            //}
            #endregion

            ApiGet apiData = new ApiGet();

            var provincename = JsonConvert.DeserializeObject <List <DeliveryCost> >(apiData.GetDataDeliveryCost("http://ccp-info.com/APIDeliveryCost/api/DeliveryCost/getdata"));
            var q            = provincename.GroupBy(x => x.DeliveryCostProvince).Select(x => x);
            foreach (var d in q)
            {
                Province.Add(new ProvinceList {
                    Ptext = d.Key
                });                                             //, Pvalue = ProvinceId
            }

            return(Province);
        }
        public static List <AmpureList> GetAmpure(string Province)
        {
            List <AmpureList> Ampure = new List <AmpureList>();

            #region
            //string sql = "Select AmphurId,AmphurName from tbl_Amphur where ProvinceId = '" + Province.Trim() + "'";
            //DataSet ds_s = new Class1().SqlGet(sql, "tbl_Amphur");
            //long row = ds_s.Tables[0].Rows.Count;
            //if (row != 0)
            //{
            //    for (int i = 0; i < row; i++)
            //    {
            //        string amphurname = ds_s.Tables["tbl_Amphur"].Rows[i]["AmphurName"].ToString();
            //        string AmphurId = ds_s.Tables["tbl_Amphur"].Rows[i]["AmphurId"].ToString();
            //        Ampure.Add(new AmpureList { Atext = amphurname, Avalue = AmphurId });
            //    }
            //}
            #endregion

            ApiGet apiData = new ApiGet();

            var provincename = JsonConvert.DeserializeObject <List <DeliveryCost> >(apiData.GetDataDeliveryCost("http://ccp-info.com/APIDeliveryCost/api/DeliveryCost/getdata"));
            var q            = provincename.Where(x => x.DeliveryCostProvince == Province).GroupBy(x => new { x.DeliveryCostProvince, x.DeliveryCostDistrict, x.DeliveryCostDistance, x.DeliveryCostY4, x.DeliveryCostY3 });

            foreach (var d in q)
            {
                Ampure.Add(new AmpureList {
                    Atext = d.Key.DeliveryCostDistrict, Avalue = d.Key.DeliveryCostDistance + "|" + d.Key.DeliveryCostY4 + "|" + d.Key.DeliveryCostY3
                });
            }

            return(Ampure);
        }