public static Dictionary <string, string> PopulateCache() { using (Lib.Data.DbEntities db = new Data.DbEntities()) { return(db.ZkratkaStrany.ToDictionary(z => z.ICO, e => e.KratkyNazev)); } }
public bool Delete(string audituser) { var zdroj = this.GetUrl(local: false); using (DbEntities db = new Data.DbEntities()) { var oe = db.OsobaEvent.Where(m => m.Zdroj == zdroj).FirstOrDefault(); if (oe != null) { oe.Delete(audituser, true); } else { var fe = db.FirmaEvent.Where(m => m.Zdroj == zdroj).FirstOrDefault(); if (fe != null) { db.FirmaEvent.Remove(fe); } } db.SaveChanges(); } var ret = ES.Manager.GetESClient_Ucty().Delete <BankovniPolozka>(this.Id); return(ret.Result == Result.Deleted); }
public static IEnumerable <Osoba> GetAllByNameAscii(string jmeno, string prijmeni, DateTime?narozeni) { jmeno = Devmasters.TextUtil.RemoveDiacritics(jmeno); prijmeni = Devmasters.TextUtil.RemoveDiacritics(prijmeni); using (Lib.Data.DbEntities db = new Data.DbEntities()) { if (narozeni.HasValue) { return(db.Osoba.AsNoTracking() .Where(m => m.JmenoAscii == jmeno && m.PrijmeniAscii == prijmeni && (m.Narozeni == narozeni) ).ToArray()); } else { return(db.Osoba.AsNoTracking() .Where(m => m.JmenoAscii == jmeno && m.PrijmeniAscii == prijmeni ).ToArray()); } } }
public static Osoba Get(int Id) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { return(db.Osoba.Where(m => m.InternalId == Id).AsNoTracking().FirstOrDefault()); } }
public void Delete(string user, bool skipTransactionDelete) { if (this.pk > 0) { using (DbEntities db = new Data.DbEntities()) { if (skipTransactionDelete == false && this.Zdroj?.StartsWith("https://www.hlidacstatu.cz/ucty/transakce/") == true) { //delete link in connected transaction TransparentniUcty.BankovniPolozka bp = TransparentniUcty.BankovniPolozka.Get(this.Zdroj.Replace("https://www.hlidacstatu.cz/ucty/transakce/", "")); if (bp != null) { if (bp.Comments.Length > 0) { bp.Comments = new TransparentniUcty.BankovniPolozka.Comment[] { }; bp.Save(user); } } } db.OsobaEvent.Attach(this); db.Entry(this).State = System.Data.Entity.EntityState.Deleted; Audit.Add <OsobaEvent>(Audit.Operations.Delete, user, this, null); db.SaveChanges(); } } }
public static IEnumerable <Sponzoring> GetByPrijemce(int osobaId) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { return(db.Sponzoring .Where(s => s.OsobaIdPrijemce == osobaId)); } }
public static IEnumerable <Sponzoring> GetByPrijemce(string icoPrijemce) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { return(db.Sponzoring .Where(s => s.IcoPrijemce == icoPrijemce)); } }
public static IEnumerable <OsobaEvent> GetByEvent(Expression <Func <OsobaEvent, bool> > predicate) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { var events = db.OsobaEvent .Where(predicate); return(events.ToList()); } }
public static OsobaEvent GetById(int id) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { return(db.OsobaEvent .Where(m => m.pk == id ) .FirstOrDefault()); } }
public OsobaExternalId[] ExternalIds() { if (_externalIds == null) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { _externalIds = db.OsobaExternalId.Where(o => o.OsobaId == this.InternalId).ToArray(); } } return(_externalIds); }
public static Osoba GetByNameId(string nameId) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { return(db.Osoba .Where(m => m.NameId == nameId ) .FirstOrDefault()); } }
public static Osoba GetByInternalId(int id) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { return(db.Osoba .Where(m => m.InternalId == id ) .FirstOrDefault()); } }
public void Delete(string user) { if (this.Id > 0) { using (DbEntities db = new Data.DbEntities()) { db.Sponzoring.Attach(this); db.Entry(this).State = System.Data.Entity.EntityState.Deleted; Audit.Add <Sponzoring>(Audit.Operations.Delete, user, this, null); db.SaveChanges(); } } }
public static Dictionary <int, Osoba> GetAllSponsors() { using (DbEntities db = new Data.DbEntities()) { var ids = db.OsobaEvent .Where(m => m.Type == (int)OsobaEvent.Types.Sponzor).Distinct().Select(m => m.OsobaId) .Distinct() .ToArray(); return(ids .Join(StaticData.Politici.Get(), i => i, p => p.InternalId, (i, p) => p) .ToDictionary(k => k.InternalId, o => o)); } }
public static Osoba GetByExternalID(string exId, OsobaExternalId.Source source) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { var oei = db.OsobaExternalId.Where(m => m.ExternalId == exId && m.ExternalSource == (int)source).FirstOrDefault(); if (oei == null) { return(null); } else { return(Get(oei.OsobaId)); } } }
public void Delete(string user) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { db.Osoba.Attach(this); db.Entry(this).State = System.Data.Entity.EntityState.Deleted; foreach (var oe in this.Events()) { oe.Delete(user, false); } Audit.Add <Osoba>(Audit.Operations.Delete, user, this, null); db.SaveChanges(); } }
public static void Add(int osobaId, string externalId, Source externalsource) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { var exist = db.OsobaExternalId .Where(m => m.OsobaId == osobaId && m.ExternalId == externalId && m.ExternalSource == (int)externalsource) .FirstOrDefault(); if (exist == null) { OsobaExternalId oei = new Data.OsobaExternalId(osobaId, externalId, externalsource); db.OsobaExternalId.Add(oei); db.SaveChanges(); } } }
public static Firma FromTransactionId(Data.TransparentniUcty.BankovniPolozka transaction) { using (DbEntities db = new Data.DbEntities()) { string url = transaction.GetUrl(false); var found = db.FirmaEvent .Where(m => m.Zdroj == url) .FirstOrDefault(); if (found != null) { return(FromIco(found.ICO)); } } return(null); }
public void Save() { using (Lib.Data.DbEntities db = new Data.DbEntities()) { db.Review.Attach(this); if (this.Id == 0) { db.Entry(this).State = System.Data.Entity.EntityState.Added; } else { db.Entry(this).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } }
// search all people by name, surname and dob public static IEnumerable <Osoba> FindAll(string name, string birthYear, bool extendedSearch = true) { if (string.IsNullOrWhiteSpace(name) && string.IsNullOrWhiteSpace(birthYear)) { return(new Osoba[0]); } string nquery = Devmasters.TextUtil.RemoveDiacritics(name.NormalizeToPureTextLower()); birthYear = birthYear?.Trim(); bool isValidYear = int.TryParse(birthYear, out int validYear); // diakritika, velikost if (extendedSearch) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { return(db.Osoba.AsNoTracking() .Where(m => ( m.PrijmeniAscii.StartsWith(nquery) == true || m.JmenoAscii.StartsWith(nquery) == true || (m.JmenoAscii + " " + m.PrijmeniAscii).StartsWith(nquery) == true || (m.PrijmeniAscii + " " + m.JmenoAscii).StartsWith(nquery) == true ) && (!isValidYear || m.Narozeni.Value.Year == validYear) ).Take(200).ToArray()); } } else { return(Lib.StaticData.Politici.Get() .Where(m => ( m.PrijmeniAscii.StartsWith(nquery, StringComparison.InvariantCultureIgnoreCase) == true || m.JmenoAscii.StartsWith(nquery, StringComparison.InvariantCultureIgnoreCase) == true || (m.JmenoAscii + " " + m.PrijmeniAscii).StartsWith(nquery, StringComparison.InvariantCultureIgnoreCase) == true || (m.PrijmeniAscii + " " + m.JmenoAscii).StartsWith(nquery, StringComparison.InvariantCultureIgnoreCase) == true ) && (!isValidYear || m.Narozeni.Value.Year == validYear) ) .Take(200)); } }
public Osoba Save(params OsobaExternalId[] externalIds) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { this.JmenoAscii = Devmasters.Core.TextUtil.RemoveDiacritics(this.Jmeno); this.PrijmeniAscii = Devmasters.Core.TextUtil.RemoveDiacritics(this.Prijmeni); this.PuvodniPrijmeniAscii = Devmasters.Core.TextUtil.RemoveDiacritics(this.PuvodniPrijmeni); if (string.IsNullOrEmpty(this.NameId)) { this.NameId = GetUniqueNamedId(); } db.Osoba.Attach(this); this.LastUpdate = DateTime.Now; if (this.InternalId == 0) { db.Entry(this).State = System.Data.Entity.EntityState.Added; } else { db.Entry(this).State = System.Data.Entity.EntityState.Modified; } try { db.SaveChanges(); } catch (Exception e) { Console.Write(e.ToString()); } if (externalIds != null) { foreach (var ex in externalIds) { ex.OsobaId = this.InternalId; OsobaExternalId.Add(ex); } } } return(this); }
public static IEnumerable <string> GetOrganisations(string jmeno, int?eventTypeId, int maxNumOfResults = 1500) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { var result = db.OsobaEvent .Where(m => m.Type == eventTypeId) .Where(m => m != null) .Where(m => m.Organizace.Contains(jmeno)) //.OrderBy(m => m.AddInfo) .Select(m => m.Organizace) .Distinct() .Take(maxNumOfResults) .ToList(); return(result); } }
public static Osoba GetByTransactionId(Data.TransparentniUcty.BankovniPolozka transaction) { if (transaction == null) { return(null); } using (DbEntities db = new Data.DbEntities()) { string url = transaction.GetUrl(local: false); var found = db.OsobaEvent .Where(m => m.Zdroj == url) .FirstOrDefault(); if (found != null) { return(GetByInternalId(found.OsobaId)); } } return(null); }
public static IEnumerable <Osoba> GetAllByName(string jmeno, string prijmeni, DateTime?narozeni) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { if (narozeni.HasValue) { return(db.Osoba.AsNoTracking() .Where(m => m.Jmeno == jmeno && m.Prijmeni == prijmeni && m.Narozeni == narozeni ).ToArray()); } else { return(db.Osoba.AsNoTracking() .Where(m => m.Jmeno == jmeno && m.Prijmeni == prijmeni ).ToArray()); } } }
public string GetUniqueNamedId() { string basic = Devmasters.Core.TextUtil.ShortenText(this.JmenoAscii, 23) + "-" + Devmasters.Core.TextUtil.ShortenText(this.PrijmeniAscii, 23).Trim(); basic = basic.ToLowerInvariant().Replace(" ", "-"); Osoba exists = null; int num = 0; string checkUniqueName = basic; using (Lib.Data.DbEntities db = new Data.DbEntities()) { do { exists = db.Osoba .Where(m => m.NameId.StartsWith(checkUniqueName)) .OrderByDescending(m => m.NameId) .FirstOrDefault(); if (exists != null) { System.Text.RegularExpressions.Regex r = new System.Text.RegularExpressions.Regex(@"(?<num>\d{1,})$", System.Text.RegularExpressions.RegexOptions.IgnorePatternWhitespace); var m = r.Match(exists.NameId); if (m.Success) { num = Convert.ToInt32(m.Groups["num"].Value); } num++; checkUniqueName = basic + "-" + num.ToString(); } else { return(checkUniqueName); } } while (exists != null); } return(basic); }
public FirmaEvent AddOrUpdateEvent(FirmaEvent ev, string user, bool rewrite = false, bool checkDuplicates = true) { if (ev == null) { return(null); } //if (ev.Type == (int)OsobaEvent.Types.Sponzor) //{ // return AddSponsoring(ev.AddInfo, ev.DatumOd.Value.Year, ev.AddInfoNum.Value, ev.Zdroj, user); //} //check duplicates using (DbEntities db = new Data.DbEntities()) { FirmaEvent exists = null; if (ev.pk > 0 && checkDuplicates) { exists = db.FirmaEvent .AsNoTracking() .FirstOrDefault(m => m.pk == ev.pk ); } else if (checkDuplicates) { exists = db.FirmaEvent .AsNoTracking() .FirstOrDefault(m => m.ICO == this.ICO && m.Type == ev.Type && m.AddInfo == ev.AddInfo && m.AddInfoNum == ev.AddInfoNum && m.DatumOd == ev.DatumOd && m.DatumDo == ev.DatumDo && m.Zdroj == ev.Zdroj ); if (exists != null) { ev.pk = exists.pk; } } if (exists != null && rewrite) { db.FirmaEvent.Remove(exists); Audit.Add <FirmaEvent>(Audit.Operations.Delete, user, exists, null); db.SaveChanges(); exists = null; } if (exists == null) { ev.ICO = this.ICO; db.FirmaEvent.Add(ev); Audit.Add(Audit.Operations.Create, user, ev, null); db.SaveChanges(); return(ev); } else { ev.ICO = this.ICO; ev.pk = exists.pk; db.FirmaEvent.Attach(ev); db.Entry(ev).State = System.Data.Entity.EntityState.Modified; Audit.Add(Audit.Operations.Create, user, ev, exists); db.SaveChanges(); return(ev); } } }
public static FirmaEvent CreateOrUpdate(FirmaEvent firmaEvent, string user) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { // create if (firmaEvent.pk == 0 && firmaEvent.ICO.Length > 0) { //firmaEvent.Organizace = ParseTools.NormalizaceStranaShortName(firmaEvent.Organizace); firmaEvent.Created = DateTime.Now; // check if event exists so we are not creating duplicities... var oe = db.FirmaEvent .Where(ev => ev.ICO == firmaEvent.ICO && ev.AddInfo == firmaEvent.AddInfo && ev.DatumOd == firmaEvent.DatumOd && ev.Type == firmaEvent.Type) //&& ev.Organizace == firmaEvent.Organizace) .FirstOrDefault(); if (oe != null) { return(oe); } db.FirmaEvent.Add(firmaEvent); db.SaveChanges(); //Firmy.Get(firmaEvent.ICO).FlushCache(); Audit.Add(Audit.Operations.Update, user, firmaEvent, null); return(firmaEvent); } // update if (firmaEvent.pk > 0) { var eventToUpdate = db.FirmaEvent .Where(ev => ev.pk == firmaEvent.pk ).FirstOrDefault(); var eventOriginal = eventToUpdate.ShallowCopy(); if (eventToUpdate != null) { eventToUpdate.DatumOd = firmaEvent.DatumOd; eventToUpdate.DatumDo = firmaEvent.DatumDo; //eventToUpdate.Organizace = ParseTools.NormalizaceStranaShortName(firmaEvent.Organizace); eventToUpdate.AddInfoNum = firmaEvent.AddInfoNum; eventToUpdate.AddInfo = firmaEvent.AddInfo; eventToUpdate.Title = firmaEvent.Title; eventToUpdate.Type = firmaEvent.Type; eventToUpdate.Zdroj = firmaEvent.Zdroj; //eventToUpdate.Status = firmaEvent.Status; eventToUpdate.Created = DateTime.Now; db.SaveChanges(); //Osoby.GetById.Get(firmaEvent.OsobaId).FlushCache(); Audit.Add(Audit.Operations.Update, user, eventToUpdate, eventOriginal); return(eventToUpdate); } } } return(firmaEvent); }
public static OsobaEvent CreateOrUpdate(OsobaEvent osobaEvent, string user) { using (Lib.Data.DbEntities db = new Data.DbEntities()) { // create if (osobaEvent.pk == 0 && osobaEvent.OsobaId > 0) { osobaEvent.Organizace = ParseTools.NormalizaceStranaShortName(osobaEvent.Organizace); osobaEvent.Created = DateTime.Now; // check if event exists so we are not creating duplicities... var oe = db.OsobaEvent .Where(ev => ev.OsobaId == osobaEvent.OsobaId && ev.Title == osobaEvent.Title && ev.DatumOd == osobaEvent.DatumOd && ev.Type == osobaEvent.Type && ev.Organizace == osobaEvent.Organizace) .FirstOrDefault(); if (oe != null) { return(oe); } db.OsobaEvent.Add(osobaEvent); db.SaveChanges(); Audit.Add(Audit.Operations.Update, user, osobaEvent, null); return(osobaEvent); } // update if (osobaEvent.pk > 0) { var eventToUpdate = db.OsobaEvent .Where(ev => ev.pk == osobaEvent.pk ).FirstOrDefault(); var eventOriginal = eventToUpdate.ShallowCopy(); if (eventToUpdate != null) { eventToUpdate.DatumOd = osobaEvent.DatumOd; eventToUpdate.DatumDo = osobaEvent.DatumDo; eventToUpdate.Organizace = ParseTools.NormalizaceStranaShortName(osobaEvent.Organizace); eventToUpdate.AddInfoNum = osobaEvent.AddInfoNum; eventToUpdate.AddInfo = osobaEvent.AddInfo; eventToUpdate.Title = osobaEvent.Title; eventToUpdate.Type = osobaEvent.Type; eventToUpdate.Zdroj = osobaEvent.Zdroj; eventToUpdate.Created = DateTime.Now; db.SaveChanges(); Audit.Add(Audit.Operations.Update, user, eventToUpdate, eventOriginal); return(eventToUpdate); } } } return(osobaEvent); }