protected void Application_Start(object sender, EventArgs e) { var container = new UnityContainer(); RegisterUnityComponents(container); GlobalConfiguration.Configure(config => { config.MapHttpAttributeRoutes(); config.Routes.MapHttpRoute( name: "AdminApi", routeTemplate: "api/admin/{controller}/{action}" ); config.Routes.MapHttpRoute( name: "DefaultApi", routeTemplate: "api/{controller}/{action}" ); config.Routes.MapHttpRoute( name: "Index", routeTemplate: "{controller}/{action}", defaults: new { controller = "Home", action = "Index" } ); var jsonFormatter = config.Formatters.JsonFormatter; jsonFormatter.SerializerSettings.ContractResolver = new NHibernateContractResolver(); jsonFormatter.UseDataContractJsonSerializer = false; }); NHibernateHelper.Configure(AppSettings.DefaultConnection); }
static void Main(string[] args) { NHibernateHelper.Configure("Data Source=HALA\\SQLEXPRESS;Initial Catalog=HSEvents;Integrated Security=True;"); using (var session = NHibernateHelper.OpenSession()) { new AttendeesCreator().Run(session); } using (var repo = new NHGetAllRepository <EventExecution>()) { repo.Delete(x => x.Event == null); } }
private void CheckConnectionMethod(object parameter) { var passwordBox = parameter as PasswordBox; if (passwordBox == null) { return; } var configureResults = NHibernateHelper.Configure(DbDataSource, DbInitialCatalog, DbUserId, passwordBox.Password, IntergatedSecurity); if (!configureResults) { ShowInfoMessage("Ошибка подключения к базе данных.\r\nПодробные сведения об ошибке:\r\n" + NHibernateHelper.LastError); } else { ShowInfoMessage("Успешное подключение к базе данных"); } }
private void SaveMethod(object parameter) { var passwordBox = parameter as PasswordBox; if (passwordBox == null) { return; } ApplicationState.SetValue("DbDataSource", DbDataSource); ApplicationState.SetValue("DbInitialCatalog", DbInitialCatalog); if (IntergatedSecurity) { ApplicationState.SetValue("DbUserId", String.Empty); ApplicationState.SetValue("DbPassword", String.Empty); } else { ApplicationState.SetValue("DbUserId", DbUserId); var password = passwordBox.Password; ApplicationState.SetValue("DbPassword", password); } var configureResults = NHibernateHelper.Configure(DbDataSource, DbInitialCatalog, DbUserId, passwordBox.Password, IntergatedSecurity); if (!configureResults) { ShowInfoMessage("Ошибка подключения к базе данных.\r\nПодробные сведения об ошибке:\r\n" + NHibernateHelper.LastError); } else { ApplicationState.SaveConnectionSettings(); CancelCommand.Execute(null); } }
private void LoginMethod(object parameter) { InProgress = true; var dbDataSource = ApplicationState.GetValue <string>("DbDataSource"); var dbInitialCatalog = ApplicationState.GetValue <string>("DbInitialCatalog"); var dbUserId = ApplicationState.GetValue <string>("DbUserId"); var dbPassword = ApplicationState.GetValue <string>("DbPassword"); var integratedSecurity = ApplicationState.GetValue <bool>("IntegratedSecurity"); NHibernateHelper.Configure(dbDataSource, dbInitialCatalog, dbUserId, dbPassword, integratedSecurity); var passwordBox = parameter as PasswordBox; if (passwordBox == null) { return; } if (!CheckConnection()) { ErrorMessage = "Ошибка подключения к БД."; ShowError = true; InProgress = false; return; } var accountRepository = new AccountRepository(); var account = accountRepository.GetByLogin(LoginText); if (!account.IsNew) { byte[] hash = GenerateSaltedHash(GetBytes(passwordBox.Password), GetBytes(account.Salt)); string hashStr = Convert.ToBase64String(hash); if (string.Equals(hashStr, account.HashedPassword)) { var userAccRepository = new Repository <UserAcc>(); User = userAccRepository.GetById(account.Id); ApplicationState.SetValue("User", User); InProgress = false; if (RememberCreditentials) { ApplicationState.SetValue("RememberCreditentials", RememberCreditentials); ApplicationState.SetValue("LdapAuth", LdapAuth); ApplicationState.SetValue("UserId", LoginText); ApplicationState.SetValue("UserPassword", passwordBox.Password); } else { ApplicationState.SetValue("RememberCreditentials", false); ApplicationState.SetValue("LdapAuth", false); ApplicationState.SetValue("UserId", String.Empty); ApplicationState.SetValue("UserPassword", String.Empty); } ApplicationState.SaveUserCreditentials(); return; } } ErrorMessage = "Ошибка. Неверный логин/пароль."; ShowError = true; InProgress = false; }