void CreateUser(NHibernate.ISession s, string Name, string Pass, string RoleName) { if (!AConst.Roles.Contains(RoleName)) { throw new Exception("Unkown role" + RoleName); } var newUserRole = (from role in s.Query <GlRole>() where role.Name == RoleName select role).ToList().FirstOrDefault(); if (newUserRole == null) { throw new Exception("Unable to find role " + RoleName + " in databases"); } s.SaveOrUpdate(new GlUser() { Name = Name, Password = Pass }); var createdUser = (from item in s.Query <GlUser>() where item.Name == Name select item).ToList().FirstOrDefault(); if (createdUser == null) { throw new Exception("Unable to create user " + Name + " with role " + RoleName); } createdUser.UserRoles = new List <GlUserRole>() { new GlUserRole() { CurrentUser = createdUser, CurrentRole = newUserRole } }; s.SaveOrUpdate(createdUser); }
public bool removeIstruttore(Istruttore i) { // elimina i collegamenti coi corsi che tiene Corso[] corsi_che_tiene = i.Corsi.ToArray(); foreach (Corso c in corsi_che_tiene) { c.Istruttori.Remove(i); i.Corsi.Remove(c); } istruttori.Remove(i); using (NHibernate.ISession session = HibernateHelper.Open()) using (NHibernate.ITransaction transaction = session.BeginTransaction()) try { foreach (Corso c in corsi_che_tiene) { session.SaveOrUpdate(c); } session.SaveOrUpdate(i); session.Delete(i); transaction.Commit(); return(true); } catch (Exception exc) { Log.Instance.WriteLine(Log.LogLevel.Error, "instance::removeIstruttore(" + (i != null ? i.ID.ToString() : "null") + "):" + exc.Message); return(false); } }
/// <summary> /// Saves the alias. /// </summary> /// <param name="evt">The evt.</param> /// <param name="name">The name.</param> /// <param name="message">The message.</param> private void SaveAlias(Event evt, string name, Message message) { bool hasTagInDictionary = _aliasLookup.ContainsKey(message.From); var alias = new Alias { Event = evt, Name = name, Number = message.From }; //get Instance of existing hashtag if (hasTagInDictionary) { alias = _aliasLookup[message.From]; alias.Name = name; } //save hashtage using (var trans = _session.BeginTransaction()) { _session.SaveOrUpdate(alias); trans.Commit(); } //update hashtag collection if (!hasTagInDictionary) { _aliasLookup.Add(message.From, alias); } }
private void SaveAndRetrieve(NHibernate.ISession session, TEntity item) { using (var transaction = session.BeginTransaction()) { session.SaveOrUpdate(item); //session.Flush(); transaction.Commit(); } }
private void CreateAndSaveArt(string pArtist, string pAlbum, string pPath, NHibernate.ISession pDataSession, ArtType pType) { var key = pArtist + "|" + pAlbum; var art = new Art(); art.ArtType = (int)pType; art.Key = key; art.Path = pPath; try { pDataSession.SaveOrUpdate(art); } catch { } // ignore. }
public static bool saveIscrizione(Iscrizione p) { using (NHibernate.ISession session = HibernateHelper.Open()) using (NHibernate.ITransaction transaction = session.BeginTransaction()) try { session.SaveOrUpdate(p); transaction.Commit(); return(true); } catch (Exception exc) { Log.Instance.WriteLine(Log.LogLevel.Error, "saveIscrizione(" + (p != null ? p.ID.ToString() : "null") + "):" + exc.Message); return(false); } }
public static List <Match> ToDb(this NHibernate.ISession session, IList <Entity.NHibernate.EventParent> competitions, DateTime dt) { PrepareForDb(ref competitions); List <Match> matches = new List <Match>(); // save both stores, this saves everything else via cascading // save both stores, this saves everything else via cascading var gcomps = competitions.GroupBy(_ => _.Key); // populate the database foreach (var competition in gcomps) { using (var transaction = session.BeginTransaction()) { var fcompetition = competition.First(); var gmatches = gcomps.SelectMany(_ => _.SelectMany(c => c.Matches.Where(m => new DateTime(m.Start) < dt))).ToList(); //foreach (var match in gmatches) // match.EventParent = fcompetition; if (session.QueryOver <Entity.NHibernate.EventParent>().RowCount() == 0 || session.QueryOver <Entity.NHibernate.EventParent>().Where(x => x.Key == competition.Key).RowCount() == 0) { session.SaveOrUpdate(competition.First()); } //var gmatches = gcomps.SelectMany(_ => _.SelectMany(c => c.Matches)); //foreach (var m in gmatches) // m.EventParent = fcompetition; var gml = gmatches.ToList(); matches.AddRange(gml); session.ToDb(gml); transaction.Commit(); } } return(matches); }
public bool UpdateNewsLatterSetting(NewsLetterSetting _NewsLetterSetting) { try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { NewsLetterSetting objNewsLetterSetting = new NewsLetterSetting(); try { objNewsLetterSetting = session.Query <NewsLetterSetting>().Where(t => t.userId == _NewsLetterSetting.userId).SingleOrDefault(); } catch (Exception ex) { objNewsLetterSetting = null; } using (NHibernate.ITransaction transaction = session.BeginTransaction()) { if (objNewsLetterSetting == null) { session.Save(_NewsLetterSetting); } else { objNewsLetterSetting.groupReport_Daily = _NewsLetterSetting.groupReport_Daily; objNewsLetterSetting.groupReport_7 = _NewsLetterSetting.groupReport_7; objNewsLetterSetting.groupReport_15 = _NewsLetterSetting.groupReport_15; objNewsLetterSetting.groupReport_30 = _NewsLetterSetting.groupReport_30; objNewsLetterSetting.groupReport_60 = _NewsLetterSetting.groupReport_60; objNewsLetterSetting.groupReport_90 = _NewsLetterSetting.groupReport_90; objNewsLetterSetting.others = _NewsLetterSetting.others; session.SaveOrUpdate(objNewsLetterSetting); } transaction.Commit(); } } return(true); } catch (Exception ex) { return(false); } }
public static bool saveIscrizioni(List <Iscrizione> p) { using (NHibernate.ISession session = HibernateHelper.Open()) using (NHibernate.ITransaction transaction = session.BeginTransaction()) try { foreach (Iscrizione i in p) { session.SaveOrUpdate(i); } transaction.Commit(); return(true); } catch (Exception exc) { Log.Instance.WriteLine(Log.LogLevel.Error, "saveIscrizioni::" + exc.Message); return(false); } }
public static bool savePersona(Persona p) { using (NHibernate.ISession session = HibernateHelper.Open()) using (NHibernate.ITransaction transaction = session.BeginTransaction()) try { session.SaveOrUpdate(p); transaction.Commit(); return(true); } catch (Exception exc) { Log.Instance.WriteLine(Log.LogLevel.Error, "savePersona(" + (p != null ? p.Nome ?? string.Empty + " " + p.Cognome ?? string.Empty : "null") + "):" + exc.Message); return(false); } }
public static bool savePersona(Persona[] p) { using (NHibernate.ISession session = HibernateHelper.Open()) using (NHibernate.ITransaction transaction = session.BeginTransaction()) try { foreach (Persona pers in p) { session.SaveOrUpdate(pers); } transaction.Commit(); return(true); } catch (Exception exc) { Log.Instance.WriteLine(Log.LogLevel.Error, "savePersone:" + exc.Message); return(false); } }
public static bool ToDb(this NHibernate.ISession session, IList <Entity.NHibernate.EventParent> competitions) { // save both stores, this saves everything else via cascading var gcomps = competitions.GroupBy(_ => _.Key); foreach (var competition in gcomps) { var fcompetition = competition.First(); var competitionId = fcompetition.Id; if (session.QueryOver <Entity.NHibernate.EventParent>().RowCount() == 0 || session.QueryOver <Entity.NHibernate.EventParent>().Where(x => x.Key == competition.Key).RowCount() == 0) { session.SaveOrUpdate(competition.First()); } var gmatches = gcomps.SelectMany(_ => _.SelectMany(c => c.Matches)); session.ToDb(gmatches.ToList()); } return(true); }
public static bool ToDb(this NHibernate.ISession session, IList <Match> matches) { // save both stores, this saves everything else via cascading var gmatches = matches.GroupBy(_ => _.Id); foreach (var match in gmatches) { var fmatch = match.First(); var matchId = fmatch.Id; //foreach (var market in gmatches.SelectMany(_ => _.SelectMany(xc => xc.Markets))) //{ // market.Match = fmatch; //} //if (session.QueryOver<Match>().RowCount() == 0 || session.QueryOver<Match>().Where(x => x.Id == match.Key).RowCount() == 0) session.SaveOrUpdate(fmatch); var gmarkets = match.SelectMany(_ => _.Markets.GroupBy(_j => _j.Id)); foreach (var market in gmarkets) { var fmarket = market.First(); //if (session.QueryOver<Market>().RowCount() == 0 || session.QueryOver<Market>().Where(x => x.Id == market.Key).RowCount() == 0) //{ //fmarket.Match = fmatch; session.SaveOrUpdate(fmarket); //} var gcontracts = market.SelectMany(_ => _.Contracts.GroupBy(_j => _j.Id)); foreach (var contract in gcontracts) { var fcontract = contract.First(); //if (session.QueryOver<Contract>().RowCount() == 0 || session.QueryOver<Contract>().Where(x => x.Id == contract.Key).RowCount() == 0) //{ //fcontract.Market = fmarket; session.SaveOrUpdate(fcontract); //} foreach (var price in contract.SelectMany(x => x.Prices)) { // var id = session.QueryOver<Contract>().RowCount(); //if (session.QueryOver<Contract>().RowCount() == 0 || session.QueryOver<Contract>().Where(x => x.Id == market.Key).RowCount() == 0) //{ //price.Id = i + 1; //price.Contract = fcontract; session.SaveOrUpdate(price); //i++; // } } } //var gteams= match.SelectMany(_ => _.Teams.GroupBy(_j => _j.Key)); //foreach (var matchteam in gteams) //{ // var fmt = matchteam.First(); // fmt.Id = i; // session.Save(matchteam); // i++; //} } } return(true); }