private Competition GetCompetition(int competitionId) { using (var session = NHibernateFactory.OpenSession()) { return(session.Query <Competition>().FirstOrDefault(c => c.Id == competitionId)); } }
protected void Page_Load(object sender, EventArgs e) { string id = Request.QueryString["Id"]; if (!string.IsNullOrWhiteSpace(id)) { try { ISession session = NHibernateFactory.OpenSession(); using (var transactionScope = session.BeginSaveTransaction()) { var profile = session.QueryOver <Profile>().Where(x => x.ActivationId == id).SingleOrDefault(); if (profile != null) { profile.ActivationId = null; session.Update(profile); } else { throw new ArgumentException("There is no profile with this activationId"); } transactionScope.Commit(); } session.Close(); } catch { lblMessage.Text = "Cannot activate this id"; } } }
private void RegistreraAnmalan(RegistrationViewModel vm) { using (var session = NHibernateFactory.OpenSession()) { using (var transaction = session.BeginTransaction()) { var player = HamtaPlayer(vm.SpelareId); var competition = HamtaCompetition(vm.TavlingsId); if (player != null && competition != null) { PlayerStatus playerStatus; var playerStatuses = session.QueryOver <PlayerStatus>().Where(ps => ps.Player.Id == player.Id && ps.Competition.Id == competition.Id).List <PlayerStatus>(); if (playerStatuses.Count > 0) { playerStatus = playerStatuses[0]; } else { playerStatus = new PlayerStatus(); } playerStatus.Competition = competition; playerStatus.Player = player; playerStatus.Status = NHibernate.Enums.PlayerCompetitionStatus.Registered; session.SaveOrUpdate(playerStatus); transaction.Commit(); } } } }
private List <PlayerCompetitionDTO> GetPlayerCompetitions(int spelareId) { var competitions = new List <Competition>(); using (var session = NHibernateFactory.OpenSession()) { competitions = session.Query <Competition>().Where(c => c.Date.Year == DateTime.Now.Year).OrderBy(c => c.Date).ToList(); } var playerCompetitons = new List <PlayerCompetitionDTO>(); foreach (var competition in competitions) { var pc = new PlayerCompetitionDTO() { CompetitionId = competition.Id, CompetitionName = competition.Name, CompetitionDate = competition.Date, Greenfee = competition.Greenfee, RegistrationOpens = competition.RegistrationOpens }; var player = competition.Players.Where(p => p.Player.Id == spelareId).ToList <PlayerStatus>(); if (player.Count() > 0) { pc.PlayerStatus = player.First().Status; } playerCompetitons.Add(pc); } return(playerCompetitons); }
public ActionResult Standings() { var vm = new StandingsViewModel(); // hämta data för tabell var standings = new List <Standing>(); using (var session = NHibernateFactory.OpenSession()) { standings = session.Query <Standing>().Where(s => s.Year == DateTime.Now.Year).ToList(); } foreach (var standing in standings) { var s = new StandingPlayerDTO() { Placering = standing.Place, Namn = string.Format("{0} {1}", standing.Player.FirstName, standing.Player.LastName), PDGA = standing.Player.PdgaNumber, TotalPoang = standing.TotalPoints, DGT1Placering = standing.DGT1Place, DGT1Poang = standing.DGT1Points, DGT2Placering = standing.DGT2Place, DGT2Poang = standing.DGT2Points, DGT3Placering = standing.DGT3Place, DGT3Poang = standing.DGT3Points, DGT4Placering = standing.DGT4Place, DGT4Poang = standing.DGT4Points, DGT5Placering = standing.DGT5Place, DGT5Poang = standing.DGT5Points }; vm.Standings.Add(s); } // Debug - test ... //for (int i = 0; i < 30; i++) //{ // vm.Standings.Add(new StandingPlayerDTO() // { // Placering = 30-i, // Namn = "Peter Bygde", // PDGA = "8558", // TotalPoang = i + 23, // DGT1Placering = 23, // DGT1Poang = 12, // DGT2Placering = 23, // DGT2Poang = 12, // DGT3Placering = 23, // DGT3Poang = 12, // DGT4Placering = 23, // DGT4Poang = 12, // DGT5Placering = 23, // DGT5Poang = 12 // }); //} return(View(vm)); }
private bool SpelareRegistrerad(int competitionId, int playerId) { using (var session = NHibernateFactory.OpenSession()) { var playerStatuses = session.QueryOver <PlayerStatus>().Where(ps => ps.Player.Id == playerId && ps.Competition.Id == competitionId).List <PlayerStatus>(); return(playerStatuses.Count > 0); } }
public Competition HamtaCompetition(int id) { using (var session = NHibernateFactory.OpenSession()) { var competition = session.Get <Competition>(id); return(competition); } }
public List <PlayerStatus> HamtaCompetitionPlayers(int id) { using (var session = NHibernateFactory.OpenSession()) { var competition = session.Get <Competition>(id); return(competition != null?competition.Players.ToList() : new List <PlayerStatus>()); } }
public static IServiceCollection AddNHibernate(this IServiceCollection services, NHibernateSettings settings) { ISessionFactory sessionFactory = NHibernateFactory.CreateSessionFactory(settings); return(services .AddSingleton(sessionFactory) .AddScoped(_ => sessionFactory.OpenSession()) .AddScoped <ITransactional, NHibernateTransactional>()); }
private ISession GetSession() { //if (NS.Component.NHibernate.NHibernateContext.Current != null) // singletonSession= NS.Component.NHibernate.NHibernateContext.Current.Session; //else singletonSession = NHibernateFactory.OpenSession(); return(singletonSession); }
public void Init() { var factory = new NHibernateFactory(); var configuration = factory.GetConfiguration(); var sessionFactory = factory.GetSessionFactory(); _session = sessionFactory.OpenSession(); new SchemaExport(configuration).Execute(true, true, false, _session.Connection, Console.Out); }
public WCFNHibernateDataAccessor(DataAccessorConfiguration config) { this.config = config; if (config.IsoLevel != null) { IsoLevel = config.IsoLevel.Value; } NHibernateFactory.Initialize(this.config); }
private void SparaPlayer(Player player) { using (var session = NHibernateFactory.OpenSession()) { using (var transaction = session.BeginTransaction()) { session.SaveOrUpdate(player); transaction.Commit(); } } }
public void Init() { using (var session = NHibernateFactory.OpenSession()) { var keys = session.QueryOver <APIKey>().List(); foreach (var key in keys) { cache.Add(key.ApiKey, key); } } }
private void Form1_Load(object sender, EventArgs e) { try { ExceptionHandler.Default.EmailFeaturesEnabled = false; //HibernatingRhinos.Profiler.Appender.NHibernate.NHibernateProfiler.Initialize(); NHibernateFactory.Initialize(); } catch (System.Exception ex) { } }
public T GetById(int id) { try { using (ISession session = NHibernateFactory.OpenSession()) return(session.Get <T>(id)); } catch (ADOException ex) { throw new DatabaseException("GetById " + _typeName + " entity exception.", ex); } }
public IList <T> GetList() { try { using (ISession session = NHibernateFactory.OpenSession()) return(session.CreateCriteria <T>().List <T>()); } catch (ADOException ex) { throw new DatabaseException("GetList " + _typeName + " entities exception.", ex); } }
private void ConfigureDependencies() { var factory = new NHibernateFactory(); var factoryProxy = new NHibernateFactoryProxy(); factoryProxy.Initialize(factory.GetConfiguration, factory.GetSessionFactory); var nHibernateSession = new NHibernateSession(factoryProxy); _uow = new UoW(nHibernateSession); _service = new OrderService(_uow); }
protected void btn_ADD_Click(object sender, EventArgs e) { UserAccessMapperService userAccessService = new UserAccessMapperService(); UserAccessNHibernate userAccess = new UserAccessNHibernate(); Guid newId = Guid.NewGuid(); //ADD A NEW DISCIPLINE userAccess = new UserAccessNHibernate { ID = newId, USER_ID = Session["SelectedUserID"].ToString(), FIRST_NAME = Session["SelectedUserFirstName"].ToString(), LAST_NAME = Session["SelectedUserLastName"].ToString(), SCHOOL_CDE = ddl_SchoolCodes.SelectedValue, }; if (ddl_SchoolCodes.SelectedValue.Length < 2) { ParentPortlet.ShowFeedback("Please Select a School Code before Saving."); return; } var nHibernateSession = new NHibernateFactory().GetSessionFactory().OpenSession(); try { using (var transaction = nHibernateSession.BeginTransaction()) { nHibernateSession.Save(userAccess); transaction.Commit(); ParentPortlet.ShowFeedback(FeedbackType.Success, "Access Successfully Added!"); } } catch (Exception exception) { var msg = PortalUser.Current.IsSiteAdmin ? "Selected Access was not added! Error: " + exception.Message : "Selected Access was not added! "; this.ParentPortlet.ShowFeedback(FeedbackType.Error, msg); ExceptionManager.Publish(exception); return; } finally { nHibernateSession.Close(); } InitScreen(); }
public Player HamtaPlayer(long spelareId) { using (var session = NHibernateFactory.OpenSession()) { var players = session.QueryOver <Player>().Where(p => p.Id == spelareId).List <Player>(); if (players.Count > 0) { return(players[0]); } } return(null); }
private void DeleteCompetitionResults(int competitionId) { using (var session = NHibernateFactory.OpenSession()) { var results = session.QueryOver <Result>().Where(r => r.Competition.Id == competitionId).List <Result>(); foreach (var r in results) { session.Delete(r); } session.Flush(); } }
private void DeleteStandings() { using (var session = NHibernateFactory.OpenSession()) { var standings = session.QueryOver <Standing>().List <Standing>(); foreach (var s in standings) { session.Delete(s); } session.Flush(); } }
public Player HamtaPlayer(string PDGANummer) { using (var session = NHibernateFactory.OpenSession()) { var players = session.QueryOver <Player>().Where(p => p.PdgaNumber == PDGANummer).List <Player>(); if (players.Count > 0) { return(players[0]); } } return(null); }
protected void Page_Load(object sender, EventArgs e) { var session = NHibernateFactory.OpenSession(); AmazonHandler amazon = new AmazonHandler(InternalBodyArchitectService.PaymentsManager); try { amazon.ProcessOrderRequest(session, Request.Form, Request); } catch (Exception ex) { ExceptionHandler.Default.Process(ex); } }
protected void Page_Load(object sender, EventArgs e) { var session = NHibernateFactory.OpenSession(); var payPal = new TransferujHandler(InternalBodyArchitectService.PaymentsManager); try { payPal.ProcessOrderRequest(session, Request.Form, Context); } catch (Exception ex) { ExceptionHandler.Default.Process(ex); } }
public NRepository() { Assembly ass = Assembly.Load("NHib.Types, Version=1.0.0.0, Culture=neutral, PublicKeyToken=92be0c10c668dbeb"); Dictionary <string, string> drivers = new Dictionary <string, string> { { "connection.provider", ConfigurationManager.AppSettings["nhib-provider"] }, //NHibernate.Connection.DriverConnectionProvider { "connection.driver_class", ConfigurationManager.AppSettings["nhib-driver"] }, //NHibernate.Driver.MySqlDataDriver { "connection.connection_string", ConfigurationManager.AppSettings["nhib-connection_string"] }, //Server=127.0.0.1;database=SrkTestServiceDb;Uid=root;Pwd=; { "dialect", ConfigurationManager.AppSettings["nhib-dialect"] } //NHibernate.Dialect.MySQL5Dialect }; factory = new NHibernateFactory(drivers, ass); factory.Configure(); }
protected void Page_Load(object sender, EventArgs e) { BodyArchitect.Logger.Log.Write("PayPalOrderProcessing started", TraceEventType.Information, "PayPal"); var session = NHibernateFactory.OpenSession(); PayPalHandler payPal = new PayPalHandler(InternalBodyArchitectService.PaymentsManager); try { payPal.ProcessOrderRequest(session, Request.Form, Request); } catch (Exception ex) { ExceptionHandler.Default.Process(ex); } }
public static IServiceCollection ComposeNHibernateDependencies(this IServiceCollection services) { services.AddSingleton <INHibernateFactoryProxy, NHibernateFactoryProxy>( sp => { var nHibernateFactory = new NHibernateFactory(); var nHibernateFactoryProxy = new NHibernateFactoryProxy(); nHibernateFactoryProxy.Initialize(nHibernateFactory.GetConfiguration, nHibernateFactory.GetSessionFactory); return(nHibernateFactoryProxy); }); services.AddTransient <INHibernateSession, NHibernateSession>(); return(services); }
public virtual void createTestFixture() { Dictionary <string, string> properties = CreatePropertiesForSqlLite();// CreatePropertiesForSqlCE(); configuration = new Configuration { Properties = properties }; ModelMapper mapping = new ModelMapper(); mapping.AddMappings(typeof(ProfileMapping).Assembly.GetTypes()); configuration.AddMapping(mapping.CompileMappingForAllExplicitlyAddedEntities()); sessionFactory = configuration.BuildSessionFactory(); NHibernateFactory.Initialize(sessionFactory); CreateDatabase(); }
public void Remove(T entity) { try { using (ISession session = NHibernateFactory.OpenSession()) { using (ITransaction transaction = session.BeginTransaction()) { session.Delete(entity); transaction.Commit(); } } } catch (ADOException ex) { throw new DatabaseException("Remove " + _typeName + " entity exception.", ex); } }