Exemple #1
0
        public TimeSignatureDialogViewModel(BarInfo info)
        {
            BarInfo = info;

            TimeSignatureControls = new TimeSignatureControlsViewModel()
            {
                TempoNumericBoxValue = info.Tempo,
                SelectedBeats        = info.Beats,
                SelectedNoteLength   = info.NoteLength
            };

            this.ObservableForProperty(x => x.TimeSignatureControls.TempoNumericBoxValue)
            .Subscribe(x => BarInfo = new BarInfo(
                           x.Value,
                           TimeSignatureControls.SelectedBeats,
                           TimeSignatureControls.SelectedNoteLength
                           ));

            this.ObservableForProperty(x => x.TimeSignatureControls.SelectedBeats)
            .Subscribe(x => BarInfo = new BarInfo(
                           TimeSignatureControls.TempoNumericBoxValue,
                           x.Value,
                           TimeSignatureControls.SelectedNoteLength
                           ));

            this.ObservableForProperty(x => x.TimeSignatureControls.SelectedNoteLength)
            .Subscribe(x => BarInfo = new BarInfo(
                           TimeSignatureControls.TempoNumericBoxValue,
                           TimeSignatureControls.SelectedBeats,
                           x.Value
                           ));
        }
Exemple #2
0
	private void CreateBars() {
		var barInfoTypes = BarInfo.GetBarInfoTypesToShow();
		foreach (BarInfoType barInfoType in barInfoTypes) {
			BarInfo barInfo = new BarInfo(barInfoType);
			Bar bar = CreateBar(barInfo);
			AddBar(bar);
		}
	}
        /// <summary>
        /// This checks the users name and bar number against the Washington State Bar Association website.
        /// IF the name matches exactly, lisence type is lawyer, AND eligibility is yes return true. Else
        /// return false because the lawyer is not valid.
        /// </summary>
        /// <param name="name">Name of lawyer, must be full name as given to the bar association</param>
        /// <param name="barNumber"> bar number as a string</param>
        /// <param name="email">string that holds the provided email</param>
        /// <returns>true if lawyer is valid and information matches, false otherwise</returns>
        public async Task <bool> IsValidLawyerAsync(int barNumber, string email)
        {
            BarInfo lawyer = await FetchBarInfoAsync(BuildUrl(barNumber));

            return(lawyer.Eligible.ToLower().Trim() == "yes" &&
                   lawyer.Type.ToLower().Trim() == "lawyer" &&
                   lawyer.Email == email);
        }
Exemple #4
0
	private Bar CreateBar(BarInfo barInfo) {
		BarType barType = barInfo.GetBarType();
		Bar prefab = GetBarPrefab(barType);
		Bar bar = Instantiate(prefab);
		bar.ApplyBarInfo(barInfo);
		bar.transform.SetParent(barLayoutGroup.transform);
		bar.transform.localScale = new Vector3(1, 1, 1);
		bar.SetColor(WhitTools.GetColorWithRandomHue(0.6f, 1.0f));
		return bar;
	}
Exemple #5
0
        public int Updata(BarInfo barInfo)
        {
            //定义参数集合,可以动态添加元素
            List <SQLiteParameter> listPs = new List <SQLiteParameter>();
            //构造update的sql语句
            string sql = "update BarInfo set btime=@time where bnumber=@number";

            listPs.Add(new SQLiteParameter("@time", barInfo.Btime));
            listPs.Add(new SQLiteParameter("@number", barInfo.BNumber));
            //执行语句并返回结果
            return(SqliteHelper.ExecuteNonQuery(sql, listPs.ToArray()));
        }
Exemple #6
0
        /// <summary>
        /// 插入数据
        /// </summary>
        /// <param name="info"></param>
        /// <returns></returns>
        public int Insert(BarInfo info)
        {
            //构造insert语句
            string sql = "insert into BarInfo(bnumber,btype,bweight,btime) values(@number,@type,@weight,@time)";

            //构造sql语句的参数
            SQLiteParameter[] ps =
            {
                new SQLiteParameter("@number", info.BNumber),
                new SQLiteParameter("@type",   info.BType),
                new SQLiteParameter("@weight", info.BWeight),
                new SQLiteParameter("@time",   info.Btime)
            };
            return(SqliteHelper.ExecuteNonQuery(sql, ps));
        }
Exemple #7
0
    void SetNextText(bool isPositiveAnswer, bool isImmediatelly = false)
    {
        bool isLose;

        currentStorySettings = GameManager.Instance.StoryManager.GetNextStory(currentStorySettings, isPositiveAnswer, out isLose);

        if (currentStorySettings != null)
        {
            isAnswerButtonsEnabled = false;
            card.HideText(() =>
            {
                card.ShowText(currentStorySettings, () => { isAnswerButtonsEnabled = true; }, isImmediatelly);
            });
        }
        else
        {
            EndGamePopup endGamePopup = Instantiate(endGamePopupPrefab, transform);
            endGamePopup.transform.localPosition = Vector3.zero;
            endGamePopup.Show("ПРОДОЛЖЕНИЕ СЛЕДУЕТ :)");
            PlayerPrefs.DeleteAll();
        }

        StoryManager storyManager = GameManager.Instance.StoryManager;

        foreach (var parameter in storyManager.ValueByType)
        {
            BarInfo barInfo = barsInfo.Find((item) => item.parameterType == parameter.Key);

            if (barInfo != null)
            {
                Image image   = barInfo.image;
                float current = image.fillAmount;
                float delta   = current - (float)parameter.Value / storyManager.MaxValue;

                if (!Mathf.Approximately(delta, 0f))
                {
                    DOTween.To(() => 0f, (value) =>
                    {
                        image.fillAmount = current - value * delta;
                    }, 1, 0.1f)
                    .SetId(this);
                }
            }
        }
    }
Exemple #8
0
        public void UpSqlite(BarInfo barInfo)
        {
            //根据编号查询结果
            BarInfo barInfo2 = infoDal.GetByNumber(barInfo.BNumber);

            if (barInfo2 == null)
            {
                infoDal.Insert(barInfo);
            }
            else
            {
                long nowtick = TimeTransitionHelper.GetCurrentTimeUnix();
                if (nowtick - barInfo.Btime > 1200)//20分钟后可再次扫码
                {
                    infoDal.Updata(barInfo);
                }
            }
        }
Exemple #9
0
        public static BarInfo ConvertToWeekly(BarInfo data)
        {
            DateTime dt       = DateTime.MinValue;
            DateTime lastDate = DateTime.MinValue;

            data.Token.periodicity = Periodicity.Week;
            BarInfo ret = new BarInfo {
                Token = data.Token
            };
            var srtData = data.OrderBy(x => x.TimeStamp);

            foreach (var itm in srtData)
            {
                if (dt.Date < itm.TimeStamp.Date)
                {
                    dt = CloseWeekDate(itm.TimeStamp);
                    ret.Add(new Bar
                    {
                        Close     = itm.Close,
                        High      = itm.High,
                        Low       = itm.Low,
                        Open      = itm.Open,
                        TimeStamp = dt,
                        Volume    = itm.Volume
                    });
                }
                else
                {
                    var bar = ret[ret.Count - 1];
                    bar.Close   = itm.Close;
                    bar.High    = bar.High > itm.High ? bar.High : itm.High;
                    bar.Low     = bar.Low < itm.High ? bar.Low : itm.Low;
                    bar.Volume += itm.Volume;
                }
                lastDate = itm.TimeStamp;
            }
            if (ret.Count > 0)
            {
                ret[ret.Count - 1].TimeStamp = lastDate;
            }
            return(ret);
        }
Exemple #10
0
    IEnumerator MoveBar(BarInfo info)
    {
        if (grade != Grade.F)
        {
            float current = gradeBar.material.GetFloat("_Fill");
            float init    = current;
            float time    = Time.time;
            while (true)
            {
                float t = (Time.time - time) / 0.25f;
                current = Mathf.Lerp(init, info.value, t);
                gradeBar.material.SetFloat("_Fill", current);

                if ((current >= info.value && info.value != 0) || (info.value == 0.0f && current == 0.0F))
                {
                    break;
                }
                else
                {
                    yield return(null);
                }
            }

            if (info.value >= 1.0F && info.action == BarInfo.Action.Increase)
            {
                AddGrade();
            }
            else if (info.value == 0.0F && info.action == BarInfo.Action.Decrease)
            {
                DecreaseGrade();
            }
        }

        barActions.Dequeue();
        if (barActions.Count > 0)
        {
            callNextAction = true;
        }
    }
Exemple #11
0
        static void Main(string[] args)
        {
            MemoryStream output = new MemoryStream();

            BarInfo test = new BarInfo(1, false);
            DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(BarInfo));

            serializer.WriteObject(output, test);

            serializer = new DataContractJsonSerializer(typeof(Block[]));
            Console.WriteLine(output.ToArray());
            for (int i = 0; i < 5; i++)
            {
                output = new MemoryStream();
                Block[] blocks = new Block[2];
                blocks[1] = timeBlock();
                blocks[0] = dateBlock();
                serializer.WriteObject(output, blocks);
                Console.Write(i == 0 ? '[' : ',');
                Console.WriteLine(ByteToCharArray(output.ToArray()));
                Thread.Sleep(2000);
            }
            output.Dispose();
        }
Exemple #12
0
	public override void ApplyBarInfo(BarInfo barInfo) {
		base.ApplyBarInfo(barInfo);

	}
Exemple #13
0
        //private static List<BarInfo> Barinfo_list { get; set; } = new List<BarInfo>();

        public static void Do(out List <BarInfo> barinfo_list_list)
        {
            barinfo_list_list = new List <BarInfo>();
            //while (true)
            //{

            bool EndOfPages   = false;
            int  CountOfPages = 1;

            while (EndOfPages == false)
            {
                HtmlDocument doc = new HtmlDocument();
                //doc.LoadHtml(getRequest(@"http://gdebar.ru/bars?mainType[0]=3&withFilter=1&p=" + CountOfPages.ToString() + "&fromUrl=/bars"));
                doc.LoadHtml(Program.getRequest(@"http://gdebar.ru/bars?mainType[0]=3&withFilter=1&p=" + CountOfPages.ToString() + "&fromUrl=/bars"));
                //http://gdebar.ru/bars?mainType[0]=3&withFilter=1&p=' + str(i) + '&fromUrl=/bars
                //HtmlNodeCollection l = doc.DocumentNode.SelectNodes("//section[@class = 'catalog__list']");
                //Console.WriteLine(doc.DocumentNode.SelectNodes("//div[@class = 'catalog__list']").Count);

                if (doc.DocumentNode.SelectNodes("//section[@class = 'catalog__list']")[0].InnerText.Contains("По данному запросу заведений не найдено :("))
                {
                    EndOfPages = true;
                    Console.WriteLine("stop");
                    continue;
                }
                else
                {
                    Console.WriteLine("continue");
                }

                //Console.WriteLine(doc.Encoding.EncodingName);
                //Console.WriteLine(doc);
                HtmlNodeCollection BarCollection = doc.DocumentNode.SelectNodes("//div[@class = 'place-card__specif']/a");

                for (int i = 0; i < BarCollection.Count; i++)
                {
                    if (!BarCollection[i].InnerText.Contains("\r\n"))
                    {
                        BarCollection.Remove(BarCollection[i]);
                    }
                }


                foreach (var item in BarCollection)     //тестовый вывод
                {
                    Console.WriteLine(item.InnerText);
                    // Console.WriteLine(item.Attributes["href"].Value);
                }
                Console.WriteLine(BarCollection.Count);


                foreach (var item in BarCollection)
                {
                    HtmlDocument doc_2 = new HtmlDocument();
                    doc_2.LoadHtml(Program.getRequest("http://gdebar.ru" + item.Attributes["href"].Value + "/menu"));
                    HtmlNodeCollection Menu = doc_2.DocumentNode.SelectNodes("//div[@class = 'menu__dish d-flex align-items-center justify-content-between p-2']");
                    //if (Menu == null) continue;
                    if (doc_2.DocumentNode.SelectNodes("//div[@class = 'text-center alert alert-danger h1']") != null)
                    {
                        continue;
                    }
                    if (Menu == null)
                    {
                        BarInfo info = new BarInfo();

                        HtmlNodeCollection ff = doc_2.DocumentNode.SelectNodes("//div[@id = 'bar-gallery-main']/div/a");    // отсюда берем ссылки на пикчи
                        if (ff != null)
                        {
                            foreach (var item_3 in ff)
                            {
                                info.PictureLinks.Add(item_3.Attributes["href"].Value);
                            }
                        }
                        else
                        {
                            info.PictureLinks.Add(null);
                        }

                        if (doc_2.DocumentNode.SelectNodes("//div[@class = 'dropdown-menu dropdown-menu--tooltip']/a") != null)
                        {
                            HtmlNodeCollection subwayy = doc_2.DocumentNode.SelectNodes("//div[@class = 'dropdown-menu dropdown-menu--tooltip']/a");

                            List <string> twmm = new List <string>();
                            foreach (var item_2 in subwayy)
                            {
                                twmm.Add(item_2.InnerText.Replace("\n", "").Trim().Split("  ")[0]);
                            }
                            info.NearSubway = twmm.ToArray();
                        }
                        else if (doc_2.DocumentNode.SelectNodes("//div[@class = 'metro d-flex align-items-start pl-4 mt-2 flex-wrap']") != null)
                        {
                            List <string> twm = new List <string>();

                            HtmlNode temp = doc_2.DocumentNode.SelectNodes("//div[@class = 'metro d-flex align-items-start pl-4 mt-2 flex-wrap']")[0];
                            string   sub  = temp.InnerText.Replace("\r\n", "").Trim().Split("  ")[0];
                            twm.Add(sub);
                            info.NearSubway = twm.ToArray();
                        }
                        else
                        {
                            info.NearSubway = new string[] { "отсутствует" };
                        }

                        if (doc_2.DocumentNode.SelectNodes("//a[@class = 'fancybox3']")[0].InnerText.ToLower().Contains("работает"))
                        {
                            info.WorkTime = doc_2.DocumentNode.SelectNodes("//a[@class = 'fancybox3']")[0].InnerText.Replace("\r\n", "").Split("работает ")[1].Replace("   ", "");
                        }
                        else
                        {
                            info.WorkTime = "время работы неизвестно";
                        }
                        if (doc_2.DocumentNode.SelectNodes("//a[@class = 'roistat-phone']") != null)
                        {
                            info.Phone = doc_2.DocumentNode.SelectNodes("//a[@class = 'roistat-phone']")[0].InnerText.Trim();
                        }
                        else
                        {
                            info.Phone = doc_2.DocumentNode.SelectNodes("//div[@class = 'phone bar__main--info__line d-flex align-items-center justify-content-start mb-4 w-100 flex-nowrap']")[0].InnerText.Trim();
                        }
                        string        add  = doc_2.DocumentNode.SelectNodes("//span[@class = 'font-weight-light mr-0']")[0].InnerText.Trim();
                        List <string> poss = Yandex.Yandex.GetPos(Apikey, add);
                        Console.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------");
                        Console.WriteLine(poss[0].Split(" ")[1]);
                        Console.WriteLine("---------------------------------------------------");
                        info.Lat = Convert.ToDouble(poss[0].Split(" ")[1].Replace(".", ","));       //широта
                        info.Lng = Convert.ToDouble(poss[0].Split(" ")[0].Replace(".", ","));       //долгота

                        info.BarName = item.InnerText.Trim();
                        if (info.BarName.Contains('ё'))
                        {
                            info.BarName.Replace("ё", "е");
                        }

                        info.HasMenu = false;
                        barinfo_list_list.Add(info);

                        continue;
                    }

                    BarInfo   barinfo   = new BarInfo();
                    MenuItems menuitems = new MenuItems();
                    //barinfo.NearSubway[0] = doc_2.DocumentNode.SelectNodes("//div[@class = 'metro d-flex align-items-start pl-4 mt-2 flex-wrap']/div");
                    //HtmlNodeCollection temp = doc_2.DocumentNode.SelectNodes("//div[@class = 'metro d-flex align-items-start pl-4 mt-2 flex-wrap']");
                    HtmlNodeCollection subway = doc_2.DocumentNode.SelectNodes("//div[@class = 'dropdown-menu dropdown-menu--tooltip']/a");
                    Console.WriteLine(item.InnerText.Trim());
                    if (doc_2.DocumentNode.SelectNodes("//div[@class = 'dropdown-menu dropdown-menu--tooltip']/a") != null)
                    {
                        subway = doc_2.DocumentNode.SelectNodes("//div[@class = 'dropdown-menu dropdown-menu--tooltip']/a");

                        List <string> twm = new List <string>();
                        foreach (var item_2 in subway)
                        {
                            twm.Add(item_2.InnerText.Replace("\n", "").Trim().Split("  ")[0]);
                        }
                        barinfo.NearSubway = twm.ToArray();
                    }
                    else if (doc_2.DocumentNode.SelectNodes("//div[@class = 'metro d-flex align-items-start pl-4 mt-2 flex-wrap']") != null)
                    {
                        List <string> twm = new List <string>();

                        HtmlNode temp = doc_2.DocumentNode.SelectNodes("//div[@class = 'metro d-flex align-items-start pl-4 mt-2 flex-wrap']")[0];
                        string   sub  = temp.InnerText.Replace("\r\n", "").Trim().Split("  ")[0];
                        twm.Add(sub);
                        barinfo.NearSubway = twm.ToArray();
                    }
                    else
                    {
                        barinfo.NearSubway = new string[] { "отсутствует" };
                    }


                    //HtmlNode tttt = doc_2.DocumentNode.SelectNodes("//div[@class = 'metro d-flex align-items-start pl-4 mt-2 flex-wrap']")[0];


                    foreach (var item_2 in Menu)
                    {
                        //barinfo = new BarInfo();
                        menuitems = new MenuItems();
                        HtmlNode subtitle_path_2 = item_2.ParentNode.ParentNode.ParentNode; //сладкая вода - не обязательная subtitle_2
                        HtmlNode subtitle_path   = subtitle_path_2.ParentNode.ParentNode;   //вода
                        HtmlNode title_path      = subtitle_path.ParentNode.ParentNode;     //бар
                                                                                            //Console.WriteLine(name_path.InnerText);
                                                                                            //Console.WriteLine(subtitle_path.InnerText);

                        menuitems.BarName = item.InnerText.Replace("\r", "").Replace("\n", "").Trim();
                        if (menuitems.BarName.Contains('ё'))
                        {
                            menuitems.BarName.Replace("ё", "е");
                        }

                        //if (title_path.Name == "parent") Console.WriteLine("1");
                        if (title_path.GetAttributeValue("class", "") == "parent")
                        {
                            if (title_path.ChildNodes[0].InnerText.Contains(" ("))
                            {
                                menuitems.Title = title_path.ChildNodes[0].InnerText.Split(" (")[0];           //главная принадлежность
                            }
                            else
                            {
                                menuitems.Title = title_path.ChildNodes[0].InnerText;
                            }
                            Console.WriteLine(title_path.ChildNodes[0].InnerText);
                        }
                        if (subtitle_path.ChildNodes[0].InnerText.Contains(" ("))
                        {
                            menuitems.Subtitle = subtitle_path.ChildNodes[0].InnerText.Split(" (")[0];         //вторичная принадлежность
                        }
                        else
                        {
                            menuitems.Subtitle = subtitle_path.ChildNodes[0].InnerText;
                        }
                        if (subtitle_path_2.ChildNodes[0].ChildNodes[0].InnerText.Contains(" ("))
                        {
                            menuitems.Subtitle_2 = subtitle_path_2.ChildNodes[0].ChildNodes[0].InnerText.Split(" (")[0];       // если существует, то третичная
                        }
                        else
                        {
                            menuitems.Subtitle_2 = subtitle_path_2.ChildNodes[0].ChildNodes[0].InnerText;
                        }

                        Console.WriteLine(subtitle_path.ChildNodes[0].InnerText);
                        Console.WriteLine(subtitle_path_2.ChildNodes[0].ChildNodes[0].InnerText);

                        HtmlNodeCollection childrens = item_2.ChildNodes;
                        //Console.WriteLine(childrens.Count);
                        menuitems.Dish  = childrens[0].ChildNodes[0].InnerText;
                        menuitems.Price = Convert.ToInt32(childrens[1].InnerText.Split(" ")[0]);

                        Console.WriteLine("блюдо - " + childrens[0].ChildNodes[0].InnerText);
                        Console.WriteLine("цена - " + childrens[1].InnerText);


                        Menuitems_list.Add(menuitems);

                        //Console.WriteLine(subtitle_path.ChildNodes[0].InnerText);
                        //Console.WriteLine(name_path.ChildNodes[0].ChildNodes[0].InnerText);

                        //Console.WriteLine(title_path.ChildNodes[0].InnerText);
                        //Console.WriteLine(name_path.Name);
                        //Console.WriteLine(subtitle_path.Name);
                        //Console.WriteLine(title_path.OriginalName);
                    }


                    Console.WriteLine("-");
                    //Console.WriteLine(item);
                    //doc_2.LoadHtml(getRequest("http://gdebar.ru" + item.Attributes["href"].Value));
                    HtmlNodeCollection f = doc_2.DocumentNode.SelectNodes("//div[@id = 'bar-gallery-main']/div/a");    // отсюда берем ссылки на пикчи

                    foreach (var item_3 in f)
                    {
                        barinfo.PictureLinks.Add(item_3.Attributes["href"].Value);
                    }
                    if (doc_2.DocumentNode.SelectNodes("//a[@class = 'fancybox3']")[0].InnerText.ToLower().Contains("работает"))
                    {
                        barinfo.WorkTime = doc_2.DocumentNode.SelectNodes("//a[@class = 'fancybox3']")[0].InnerText.Replace("\r\n", "").Split("работает ")[1].Replace("   ", "");
                    }
                    else
                    {
                        barinfo.WorkTime = "отсутсвует";
                    }
                    if (doc_2.DocumentNode.SelectNodes("//a[@class = 'roistat-phone']") != null)
                    {
                        barinfo.Phone = doc_2.DocumentNode.SelectNodes("//a[@class = 'roistat-phone']")[0].InnerText.Trim();
                    }
                    else
                    {
                        barinfo.Phone = doc_2.DocumentNode.SelectNodes("//div[@class = 'phone bar__main--info__line d-flex align-items-center justify-content-start mb-4 w-100 flex-nowrap']")[0].InnerText.Trim();
                    }
                    string        address = doc_2.DocumentNode.SelectNodes("//span[@class = 'font-weight-light mr-0']")[0].InnerText.Trim();
                    List <string> pos     = Yandex.Yandex.GetPos(Apikey, address);
                    Console.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------");
                    Console.WriteLine(pos[0].Split(" ")[1]);
                    Console.WriteLine("---------------------------------------------------");
                    barinfo.Lat = Convert.ToDouble(pos[0].Split(" ")[1].Replace(".", ","));       //широта
                    barinfo.Lng = Convert.ToDouble(pos[0].Split(" ")[0].Replace(".", ","));       //долгота
                    Console.WriteLine("dddddddddddddddd - " + barinfo.Lat);

                    barinfo.BarName = item.InnerText.Trim();
                    if (barinfo.BarName.Contains('ё'))
                    {
                        barinfo.BarName.Replace("ё", "е");
                    }

                    barinfo.HasMenu = true;
                    barinfo_list_list.Add(barinfo);
                }
                Console.WriteLine(CountOfPages);
                CountOfPages += 1;
                Thread.Sleep(2000);
            }
            //запись в бд
            // ClearBD("barinfo");
            //ClearBD("menuitems");
            //PastIntoBD(barinfo_list_list, Menuitems_list);

            Console.WriteLine("--------------------------------------------------------------------");
            //Thread.Sleep(50000); //86400000 - это сутки
            //}
        }
Exemple #14
0
        /// <summary>
        /// Выполняет парсинг сайта KudaGo мск
        /// </summary>
        public static void Do(out List <BarInfo> barinfo_list_list)
        {
            barinfo_list_list = new List <BarInfo>();
            HttpClient client = new HttpClient();

            double PagesForKudaGo = 1;

            for (int j = 0; j < PagesForKudaGo; j++)
            {
                Console.WriteLine("J = " + j + "   Pages = " + PagesForKudaGo);
                int    page = j + 1;
                string url  = "https://kudago.com/public-api/v1.4/places/?lang=&page=" + page + "&fields=&expand=&order_by=&text_format=&ids=&location=msk&has_showings=&showing_since=&showing_until&categories=bar&lon=&lat=&radius=";
                PagesForKudaGo += 1;
                string stuff      = client.GetStringAsync(url).GetAwaiter().GetResult();
                var    rootobject = JsonConvert.DeserializeObject <MainJson.Rootobject>(stuff);
                PagesForKudaGo = Math.Ceiling((double)rootobject.count / 20);



                for (int i = 0; i < rootobject.results.Length; i++)
                {
                    if (rootobject.results[i].is_closed == true)
                    {
                        continue;
                    }

                    BarInfo barinfo = new BarInfo();
                    // Console.WriteLine(rootobject.results[i].title + rootobject.results[i].id + "      " + rootobject.results[i].is_closed + "    " + rootobject.results[i].subway);
                    barinfo.NearSubway = rootobject.results[i].subway.Split(", ");
                    barinfo.BarName    = rootobject.results[i].title;
                    if (barinfo.BarName.Contains('ё'))
                    {
                        barinfo.BarName.Replace("ё", "е");
                    }
                    barinfo.HasMenu = false;
                    barinfo.Phone   = rootobject.results[i].phone;
                    url             = "https://kudago.com/public-api/v1.4/places/" + rootobject.results[i].id + "/?expand=images";
                    stuff           = client.GetStringAsync(url).GetAwaiter().GetResult();
                    var rootobject1 = JsonConvert.DeserializeObject <Details.Rootobject>(stuff);
                    if (rootobject1.address.Contains("«Трёхгорная мануфактура»"))
                    {
                        rootobject1.address = rootobject1.address.Replace("«Трёхгорная мануфактура»,", "");
                    }
                    else if (rootobject1.address.Contains("башня «Империя»"))
                    {
                        rootobject1.address = rootobject1.address.Replace("башня «Империя»", "");
                    }
                    Console.WriteLine(rootobject1.address);
                    List <string> pos = Yandex.Yandex.GetPos(Apikey, rootobject1.address);

                    barinfo.Lat = Convert.ToDouble(pos[0].Split(" ")[1].Replace(".", ","));       //широта
                    barinfo.Lng = Convert.ToDouble(pos[0].Split(" ")[0].Replace(".", ","));       //долгота

                    //barinfo.Lat = rootobject1.coords.lat;
                    //barinfo.Lng = rootobject1.coords.lon;
                    if (rootobject1.timetable == "")
                    {
                        barinfo.WorkTime = "время работы неизвестно";
                    }
                    else
                    {
                        barinfo.WorkTime = rootobject1.timetable;
                    }


                    for (int k = 0; k < rootobject1.images.Length; k++)
                    {
                        barinfo.PictureLinks.Add(rootobject1.images[k].image);
                    }
                    //Barinfo_list.Add(barinfo);
                    barinfo_list_list.Add(barinfo);
                }
                Console.WriteLine();
                Thread.Sleep(2000);
            }
            //PastIntoBD(barinfo_list_list);
        }
Exemple #15
0
 public bool Edit(BarInfo barInfo)
 {
     return(infoDal.Updata(barInfo) > 0);
 }
Exemple #16
0
 public bool Add(BarInfo barInfo)
 {
     return(infoDal.Insert(barInfo) > 0);
 }
Exemple #17
0
        /// <summary>
        /// Чтение данных из бд
        /// </summary>
        private static void ReadBD()
        {
            //выборка данных из бд
            Models.ModelOfBar       bar   = new Models.ModelOfBar();
            Models.ModelOfMenuItems items = new Models.ModelOfMenuItems();
            Models.ModelOfUserRate  rate  = new Models.ModelOfUserRate();

            string           connectionString = "Server=localhost;Port=5432;User ID=postgres;Password=3400430;Database=Menu;";
            NpgsqlConnection npgSqlConnection = new NpgsqlConnection(connectionString);

            npgSqlConnection.Open();
            Console.WriteLine("Соединение с БД открыто");
            NpgsqlCommand    npgSqlCommand    = new NpgsqlCommand("SELECT * FROM barinfo", npgSqlConnection);
            NpgsqlDataReader npgSqlDataReader = npgSqlCommand.ExecuteReader();

            if (npgSqlDataReader.HasRows)
            {
                Console.WriteLine("Таблица: BarInfo");
                Console.WriteLine("");
                foreach (DbDataRecord dbDataRecord in npgSqlDataReader)
                {
                    bar = new Models.ModelOfBar();
                    //Console.WriteLine(dbDataRecord["BarName"] + "   " + dbDataRecord["Latitude"] + "   " + dbDataRecord["Longitude"] + "   " + dbDataRecord["Phone"] + "   " + dbDataRecord["WorkTime"] + "   " + dbDataRecord["Pictures"]);
                    bar.BarName  = dbDataRecord["BarName"].ToString();
                    bar.Lat      = Convert.ToDouble(dbDataRecord["Latitude"]);
                    bar.Lng      = Convert.ToDouble(dbDataRecord["Longitude"]);
                    bar.Phone    = dbDataRecord["Phone"].ToString();
                    bar.WorkTime = dbDataRecord["WorkTime"].ToString();
                    bar.HasMenu  = Convert.ToBoolean(dbDataRecord["HasMenu"]);
                    string[] temp = dbDataRecord["Pictures"].ToString().Split("|");
                    foreach (var item in temp)
                    {
                        if (item != "")
                        {
                            bar.PictureLinks.Add(item);
                        }
                    }
                    BarInfo.Add(bar);
                }
            }
            else
            {
                Console.WriteLine("Запрос не вернул строк в BarInfo");
            }
            npgSqlDataReader.Close();



            npgSqlCommand    = new NpgsqlCommand("SELECT * FROM menuitems", npgSqlConnection);
            npgSqlDataReader = npgSqlCommand.ExecuteReader();
            if (npgSqlDataReader.HasRows)
            {
                Console.WriteLine("Таблица: MenuItems");
                Console.WriteLine("");
                foreach (DbDataRecord dbDataRecord in npgSqlDataReader)
                {
                    items = new Models.ModelOfMenuItems();
                    // Console.WriteLine(dbDataRecord["Title"] + "   " + dbDataRecord["Subtitle"] + "   " + dbDataRecord["Subtitle_2"] + "   " + dbDataRecord["Dish"] + "   " + dbDataRecord["Price"] + "   " + dbDataRecord["BarName"]);
                    items.Title      = dbDataRecord["Title"].ToString();
                    items.Subtitle   = dbDataRecord["Subtitle"].ToString();
                    items.Subtitle_2 = dbDataRecord["Subtitle_2"].ToString();
                    items.Dish       = dbDataRecord["Dish"].ToString();
                    items.Price      = Convert.ToInt32(dbDataRecord["Price"]);
                    items.BarName    = dbDataRecord["BarName"].ToString();
                    MenuItems.Add(items);
                }
            }
            else
            {
                Console.WriteLine("Запрос не вернул строк в MenuItems");
            }
            npgSqlDataReader.Close();


            npgSqlCommand    = new NpgsqlCommand("SELECT * FROM UserRate", npgSqlConnection);
            npgSqlDataReader = npgSqlCommand.ExecuteReader();
            if (npgSqlDataReader.HasRows)
            {
                Console.WriteLine("Таблица: UserRate");
                Console.WriteLine("");
                foreach (DbDataRecord dbDataRecord in npgSqlDataReader)
                {
                    rate = new Models.ModelOfUserRate();
                    // Console.WriteLine(dbDataRecord["Title"] + "   " + dbDataRecord["Subtitle"] + "   " + dbDataRecord["Subtitle_2"] + "   " + dbDataRecord["Dish"] + "   " + dbDataRecord["Price"] + "   " + dbDataRecord["BarName"]);
                    rate.BarName = dbDataRecord["BarName"].ToString();

                    string[] temp = dbDataRecord["Likes"].ToString().Split(",");
                    foreach (var item in temp)
                    {
                        if (item != "")
                        {
                            rate.Likes.Add(Convert.ToInt64(item));
                        }
                    }

                    temp = dbDataRecord["Dislikes"].ToString().Split(",");
                    foreach (var item in temp)
                    {
                        if (item != "")
                        {
                            rate.Dislikes.Add(Convert.ToInt64(item));
                        }
                    }


                    UserRate.Add(rate);
                }
            }
            else
            {
                Console.WriteLine("Запрос не вернул строк в MenuItems");
            }


            Console.WriteLine("чтение завершено");
            npgSqlDataReader.Close();
            npgSqlConnection.Close();
        }
Exemple #18
0
	public virtual void ApplyBarInfo(BarInfo barInfo) {
		this.barInfo = barInfo;
		barText.text = barInfo.text;
	}