Exemplo n.º 1
0
        /// <summary>
        /// Loads all people donations from web
        /// </summary>
        public static async Task LoadDonationsAsync(string url, Donations donations, dynamic party, int year)
        {
            dynamic donationRecords = await LoadIndexAsync(url);

            foreach (var record in donationRecords)
            {
                Donor donor = new Donor()
                {
                    City        = record.addrCity,
                    CompanyId   = record.companyId ?? 0,
                    Name        = record.firstName,
                    Surname     = record.lastName,
                    TitleBefore = record.titleBefore,
                    TitleAfter  = record.titleAfter,
                    DateOfBirth = record.birthDate
                };
                Gift gift = new Gift()
                {
                    Amount      = record.money ?? record.value,
                    ICO         = party.ic,
                    Party       = party.longName,
                    Description = record.description,
                    Date        = record.date ?? new DateTime(year, 1, 1),
                    GiftType    = (record.money is null) ? Sponzoring.TypDaru.NefinancniDar : Sponzoring.TypDaru.FinancniDar
                };

                donations.AddDonation(donor, gift);
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// Loads all people donations from web
        /// </summary>
        /// <param name="url"></param>
        /// <param name="donations"></param>
        /// <param name="party"></param>
        /// <param name="year"></param>
        /// <returns></returns>
        public static async Task LoadPeopleDonationsAsync(string url, Donations donations, dynamic party, int year)
        {
            dynamic donationRecords = await LoadIndexAsync(url);

            foreach (var record in donationRecords)
            {
                Donor donor = new Donor()
                {
                    City        = record.addrCity,
                    Name        = record.firstName,
                    Surname     = record.lastName,
                    TitleBefore = record.titleBefore,
                    TitleAfter  = record.titleAfter,
                    DateOfBirth = record.birthDate
                };
                Gift gift = new Gift()
                {
                    Amount      = record.money ?? record.value,
                    ICO         = party.ic,
                    Party       = party.longName,
                    Description = record.description,
                    Date        = record.date ?? new DateTime(year, 1, 1)
                };

                donations.AddDonation(donor, gift);
            }
        }
Exemplo n.º 3
0
        /// <summary>
        /// Loads all people donations from web
        /// </summary>
        public static async Task LoadDonationsAsync(string url, Donations donations, dynamic party, int year)
        {
            dynamic donationRecords = await LoadIndexAsync(url);

            foreach (var record in donationRecords)
            {
                string firstName    = record.firstName;
                string lastName     = record.lastName;
                string titlesBefore = record.titleBefore;
                string titlesAfter  = record.titleAfter;

                var cleanedName     = Validators.SeparateNameFromTitles(firstName);
                var cleanedLastName = Validators.SeparateNameFromTitles(lastName);

                titlesBefore = MergeTitles(titlesBefore, cleanedName.titulyPred, cleanedLastName.titulyPred);
                titlesAfter  = MergeTitles(titlesAfter, cleanedName.titulyPo, cleanedLastName.titulyPo);
                // if (!string.IsNullOrEmpty(cleanedName.titulyPred)
                //     || !string.IsNullOrEmpty(cleanedName.titulyPo)
                //     || !string.IsNullOrEmpty(cleanedLastName.titulyPred)
                //     || !string.IsNullOrEmpty(cleanedLastName.titulyPo))
                // {
                //     var lines = new List<string>()
                //     {
                //         $"Opraven titul pro {party.longName} [{party.ic}] za rok [{year}]:",
                //         $"jmeno: {firstName} => {cleanedName.jmeno}",
                //         $"prijmeni: {lastName} => {cleanedLastName.jmeno}",
                //         $"titulyPred: {titlesBefore}",
                //         $"titulyZa: {titlesAfter}"
                //     };
                //     System.IO.File.AppendAllLines(@"d:\udhpsherrs.txt",lines,Encoding.UTF8);
                // }

                Donor donor = new Donor()
                {
                    City        = record.addrCity,
                    CompanyId   = record.companyId,
                    Name        = cleanedName.jmeno,
                    Surname     = cleanedLastName.jmeno,
                    TitleBefore = titlesBefore,
                    TitleAfter  = titlesAfter,
                    DateOfBirth = record.birthDate
                };
                Gift gift = new Gift()
                {
                    Amount      = record.money ?? record.value,
                    ICO         = party.ic,
                    Party       = party.longName,
                    Description = record.description,
                    Date        = record.date ?? new DateTime(year, 1, 1),
                    GiftType    = (record.money is null) ? Sponzoring.TypDaru.NefinancniDar : Sponzoring.TypDaru.FinancniDar
                };

                donations.AddDonation(donor, gift);
            }
        }
Exemplo n.º 4
0
        /// <summary>
        /// Uploads new donations to FirmaEvent table
        /// </summary>
        /// <param name="donations"></param>
        public static void UploadCompanyDonations(Donations donations)
        {
            foreach (var companyDonations in donations.GetDonations())
            {
                var donor = companyDonations.Key;

                Firma firma = null;
                try
                {
                    firma = Firma.FromIco(donor.CompanyId);
                }
                catch (Exception)
                {
                }

                if (firma is null)
                {
                    Console.WriteLine($"Chybějící firma v db - ICO: {donor.CompanyId}, nazev: {donor.Name}");
                    continue;
                }

                var firmaEvents = firma.Events(ev => ev.Type == (int)FirmaEvent.Types.Sponzor).ToList();

                foreach (var donation in companyDonations.Value)
                {
                    var eventToRemove = firmaEvents.Where(oe => oe.AddInfoNum == donation.Amount &&
                                                          oe.Description == donation.ICO &&
                                                          oe.DatumOd.HasValue &&
                                                          oe.DatumOd.Value.Year == donation.Date.Year).FirstOrDefault();
                    if (eventToRemove is null)
                    {
                        // add event
                        var newEvent = new FirmaEvent()
                        {
                            AddInfo     = NormalizePartyName(donation.Party, donation.ICO),
                            DatumOd     = donation.Date,
                            AddInfoNum  = donation.Amount,
                            Description = donation.ICO,
                            Zdroj       = _zdroj,
                            Note        = donation.Description,
                            Type        = (int)FirmaEvent.Types.Sponzor
                        };
                        firma.AddOrUpdateEvent(newEvent, _user, checkDuplicates: false);
                    }
                    else
                    {
                        firmaEvents.Remove(eventToRemove);
                    }
                }
            }
        }
Exemplo n.º 5
0
        static async Task Main(string[] args)
        {
            _partyNames = LoadPartyNames();
            var peopleDonations  = new Donations(new DonorEqualityComparer());
            var companyDonations = new Donations(new DonorEqualityComparer());

            #region loading from web
            foreach (string indexUrl in _addresses)
            {
                var index = await LoadIndexAsync(indexUrl);

                string key  = index.election.key;
                int    year = GetYearFromText(key);

                foreach (var party in index.parties)
                {
                    IEnumerable <dynamic> files = party.files;
                    // osoby
                    string penizeFoUrl = files.Where(f => f.subject == "penizefo").Select(f => f.url).FirstOrDefault();
                    await LoadDonationsAsync(penizeFoUrl, peopleDonations, party, year);

                    string nepenizeFoUrl = files.Where(f => f.subject == "bupfo").Select(f => f.url).FirstOrDefault();
                    await LoadDonationsAsync(nepenizeFoUrl, peopleDonations, party, year);

                    //firmy
                    string penizePoUrl = files.Where(f => f.subject == "penizepo").Select(f => f.url).FirstOrDefault();
                    await LoadDonationsAsync(penizePoUrl, companyDonations, party, year);

                    string nepenizePoUrl = files.Where(f => f.subject == "buppo").Select(f => f.url).FirstOrDefault();
                    await LoadDonationsAsync(nepenizePoUrl, companyDonations, party, year);
                }
            }
            #endregion

            #region saving to db
            UploadPeopleDonations(peopleDonations);
            UploadCompanyDonations(companyDonations);

            #endregion
        }
Exemplo n.º 6
0
        /// <summary>
        /// Uploads new donations to OsobaEvent table
        /// </summary>
        /// <param name="donations"></param>
        public static void UploadPeopleDonations(Donations donations)
        {
            foreach (var personDonations in donations.GetDonations())
            {
                var donor = personDonations.Key;

                Osoba osoba = Osoba.GetOrCreateNew(donor.TitleBefore, donor.Name, donor.Surname, donor.TitleAfter,
                                                   donor.DateOfBirth, Osoba.StatusOsobyEnum.Sponzor, _user);

                var osobaEvents = osoba.NoFilteredEvents(ev => ev.Type == (int)OsobaEvent.Types.Sponzor).ToList();

                foreach (var donation in personDonations.Value)
                {
                    var eventToRemove = osobaEvents.Where(oe => oe.AddInfoNum == donation.Amount &&
                                                          oe.AddInfo == donation.ICO &&
                                                          oe.DatumOd.HasValue &&
                                                          oe.DatumOd.Value.Year == donation.Date.Year).FirstOrDefault();
                    if (eventToRemove is null)
                    {
                        // add event
                        var newEvent = new OsobaEvent()
                        {
                            Organizace = NormalizePartyName(donation.Party, donation.ICO),
                            DatumOd    = donation.Date,
                            AddInfoNum = donation.Amount,
                            AddInfo    = donation.ICO,
                            Zdroj      = _zdroj,
                            Note       = donation.Description,
                            Type       = (int)OsobaEvent.Types.Sponzor
                        };
                        osoba.AddOrUpdateEvent(newEvent, _user, checkDuplicates: false);
                    }
                    else
                    {
                        osobaEvents.Remove(eventToRemove);
                    }
                }
            }
        }
Exemplo n.º 7
0
        /// <summary>
        /// Uploads new donations to FirmaEvent table
        /// </summary>
        public static void UploadCompanyDonations(Donations donations)
        {
            foreach (var companyDonations in donations.GetDonations())
            {
                var donor = companyDonations.Key;

                Firma firma = null;
                try
                {
                    firma = Firma.FromIco(donor.CompanyId);
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }

                if (firma is null)
                {
                    Console.WriteLine($"Chybějící firma v db - ICO: {donor.CompanyId}, nazev: {donor.Name}");
                    continue;
                }

                foreach (var donation in companyDonations.Value)
                {
                    // add event
                    var sponzoring = new Sponzoring()
                    {
                        DarovanoDne = donation.Date,
                        Hodnota     = donation.Amount,
                        IcoPrijemce = donation.ICO,
                        Zdroj       = _zdroj,
                        Popis       = donation.Description,
                        Typ         = (int)donation.GiftType
                    };
                    firma.AddSponsoring(sponzoring, _user);
                }
            }
        }
Exemplo n.º 8
0
        /// <summary>
        /// Loads all company donations from web
        /// </summary>
        /// <param name="url"></param>
        /// <param name="donations"></param>
        /// <param name="party"></param>
        /// <param name="year"></param>
        /// <returns></returns>
        public static async Task LoadCompanyDonationsAsync(string url, Donations donations, dynamic party, int year)
        {
            dynamic donationRecords = await LoadIndexAsync(url);

            foreach (var record in donationRecords)
            {
                Donor donor = null;
                try
                {
                    donor = new Donor()
                    {
                        City      = record.addrCity,
                        Name      = record.company,
                        CompanyId = record.companyId
                    };
                }
                catch (Exception)
                {
                    donor = new Donor()
                    {
                        City = record.addrCity,
                        Name = record.company,
                    };
                    Console.WriteLine($"Špatný formát IČO: [{record.companyId}], url:[{url}]");
                }

                Gift gift = new Gift()
                {
                    Amount      = record.money ?? record.value,
                    ICO         = party.ic,
                    Party       = party.longName,
                    Description = record.description,
                    Date        = record.date ?? new DateTime(year, 1, 1)
                };

                donations.AddDonation(donor, gift);
            }
        }
Exemplo n.º 9
0
        /// <summary>
        /// Uploads new donations to OsobaEvent table
        /// </summary>
        public static void UploadPeopleDonations(Donations donations)
        {
            foreach (var personDonations in donations.GetDonations())
            {
                var donor = personDonations.Key;

                Osoba osoba = Osoba.GetOrCreateNew(donor.TitleBefore, donor.Name, donor.Surname, donor.TitleAfter,
                                                   donor.DateOfBirth, Osoba.StatusOsobyEnum.Sponzor, _user);

                // Výjimka pro Radek Jonke 24.12.1970
                if (osoba.Jmeno == "Radek" &&
                    osoba.Prijmeni == "Jonke" &&
                    osoba.Narozeni != null &&
                    osoba.Narozeni.Value.Year == 1970 &&
                    osoba.Narozeni.Value.Month == 12 &&
                    osoba.Narozeni.Value.Day == 24)
                {
                    continue;
                }

                foreach (var donation in personDonations.Value)
                {
                    // add event
                    var sponzoring = new Sponzoring()
                    {
                        DarovanoDne = donation.Date,
                        Hodnota     = donation.Amount,
                        IcoPrijemce = donation.ICO,
                        Zdroj       = _zdroj,
                        Popis       = donation.Description,
                        Typ         = (int)donation.GiftType
                    };

                    osoba.AddOrUpdateSponsoring(sponzoring, _user);
                }
            }
        }