Inheritance: INotifyPropertyChanging, INotifyPropertyChanged
コード例 #1
0
ファイル: Feed.cs プロジェクト: friism/folketsting
        public FeedEvent(CommitteeTrip trip)
        {
            this.date = trip.StartDate;
            this.BodyText = trip.Purpose.PresentText(200);

            this.ActionUrl = trip.LinkTo();
            this.ActionText = string.Format("Rejste med {0} til {1}", trip.Committee.Name, trip.Place ?? "");
        }
コード例 #2
0
ファイル: TripScraper.cs プロジェクト: friism/folketsting
        private static void HandleRow(HtmlNode row)
        {
            var onclick = row.Attributes["onclick"].Value;
            var url = onclick.Split('\'')[1];
            string ftid = url.Split('{')[1].Replace("}", "");

            var db = new DBDataContext();
            var trip = db.CommitteeTrips.SingleOrDefault(_ => _.FTId == ftid);

            //if (trip != null && trip.ActualExpenses.HasValue && trip.ActualExpenses != 0)
            //{
            //    // this trip is prolly completely accounted for
            //    return;
            //}

            var cells = row.SelectHtmlNodes("td");

            var startstring = cells.ElementAt(0).InnerText.Trim();
            var startdate = DateTime.ParseExact(startstring, "dd-MM-yyyy", null);

            var endstring = cells.ElementAt(1).InnerText.Trim();
            var enddate = DateTime.ParseExact(endstring, "dd-MM-yyyy", null);

            if (startdate.Year < 1900 || enddate.Year < 1900)
            {
                return;
            }

            var commname = cells.ElementAt(2).InnerText.Trim();

            var committee = Scrape2009.GetCommitteeId(commname, db);

            var purpose = cells.ElementAt(5).InnerText.Trim();
            var place = cells.ElementAt(3).InnerText.Trim();
            if (place.ToLower().Contains("aflyst") || purpose.ToLower().Contains("aflyst"))
            {
                // give up
                return;
            }

            var doc = Scrape2009.GetDoc("http://www.ft.dk" + url);

            var menudiv = doc.DocumentNode.SelectSingleNode("//div[@id='menuSkip']");
            if (menudiv.InnerText.ToLower().Contains("afbud"))
            {
                return;
            }

            var participantnode = menudiv.SelectHtmlNodes("p/h3").
                SingleOrDefault(_ => _.InnerText.Trim() == "Deltagere");

            if (participantnode == null)
            {
                // no politicians went, discard
                return;
            }

            var participants = participantnode.
                NextSibling.SelectHtmlNodes("li/a").
                Select(_ => _.Attributes["href"].Value);

            var polids = participants.Select(_ => Scrape2009.GetPoliticianByUrl(_, db));

            var otherparticipantnode = menudiv.SelectHtmlNodes("p/h3").
                SingleOrDefault(_ => _.InnerText.Trim() == "Øvrige deltagere");

            var othercount = 0;
            if (otherparticipantnode != null)
            {
                othercount = OtherMemberCount(otherparticipantnode);
            }

            var budgetstring = menudiv.SelectHtmlNodes("p/h3").
                Single(_ => _.InnerText.Trim() == "Budget").
                NextSibling.InnerText.Trim().Split(' ')[0]
                .Replace(".", "").Replace(",", "");

            var spendstring = menudiv.SelectHtmlNodes("p/h3").
                Single(_ => _.InnerText.Trim() == "Regnskab").
                NextSibling.InnerText.Trim().Split(' ')[0]
                .Replace(".", "").Replace(",", "");

            var provider = new CultureInfo("da-dk");
            //var provider = new CultureInfo("en-us");
            var budget = decimal.Parse(budgetstring, provider);
            var spend = decimal.Parse(spendstring, provider);

            lock (dblock)
            {
                if (trip == null)
                {
                    trip = new CommitteeTrip();
                    db.CommitteeTrips.InsertOnSubmit(trip);
                }

                trip.ActualExpenses = spend;
                trip.Budget = budget;
                trip.CommitteeId = committee;
                trip.EndDate = enddate;
                trip.Place = place;
                trip.Purpose = purpose;
                trip.StartDate = startdate;
                trip.NonPolParticipants = othercount;
                trip.FTId = ftid;
                trip.Uri = url;

                db.SubmitChanges();

                var newpols = polids.Where(_ =>
                    _.HasValue &&
                    !trip.CommitteeTripParticipants.Any(p => p.Politician.PoliticianId == _.Value)
                    );

                var tripparticipants = newpols.Select(_ =>
                    new CommitteeTripParticipant
                    {
                        CommitteeTripId = trip.CommitteeTripId,
                        ParticipantId = _.Value
                    });

                var partstodelete = trip.CommitteeTripParticipants.
                    Where(_ => !polids.Contains(_.ParticipantId));
                db.CommitteeTripParticipants.DeleteAllOnSubmit(partstodelete);

                db.CommitteeTripParticipants.InsertAllOnSubmit(tripparticipants);
                db.SubmitChanges();
            }
        }
コード例 #3
0
ファイル: DB.designer.cs プロジェクト: friism/folketsting
 private void detach_CommitteeTrips(CommitteeTrip entity)
 {
     this.SendPropertyChanging();
     entity.Committee = null;
 }
コード例 #4
0
ファイル: DB.designer.cs プロジェクト: friism/folketsting
 private void attach_CommitteeTrips(CommitteeTrip entity)
 {
     this.SendPropertyChanging();
     entity.Committee = this;
 }
コード例 #5
0
ファイル: DB.designer.cs プロジェクト: friism/folketsting
 partial void DeleteCommitteeTrip(CommitteeTrip instance);
コード例 #6
0
ファイル: DB.designer.cs プロジェクト: friism/folketsting
 partial void UpdateCommitteeTrip(CommitteeTrip instance);
コード例 #7
0
ファイル: DB.designer.cs プロジェクト: friism/folketsting
 partial void InsertCommitteeTrip(CommitteeTrip instance);