private void evoButton1_Click(object sender, EventArgs e) { DatabaseCredential credential = new DatabaseCredential(); credential.ServerName = "teerayut0si0nb"; credential.DatabaseName = "test"; credential.Username = "******"; credential.Password = "******"; credential.Provider = DatabaseProvider.SQLSERVER; Database sqlDB = DatabaseManager.CreateDatabase(credential); StringBuilder sb = new StringBuilder(); sb.AppendLine("SELECT * FROM TB_TORO WHERE NAME=:NAME"); DataRequest req = new DataRequest(sb.ToString()); req.Parameters.Add("NAME", DataType.NVarChar, "TORO"); DataTable dt = sqlDB.ExecuteQuery(req); evoTextBox1.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { evoTextBox1.Text += dt.Rows[i][0] + "\r\n"; } }
public ErrorItem TestConnection(DatabaseProvider eProvider, string servername, string databaseName, string username, string password) { DatabaseCredential credential = new DatabaseCredential(); credential.Provider = eProvider; credential.ServerName = servername; credential.DatabaseName = databaseName; credential.Username = username; credential.Password = password; return(DatabaseManager.TestConnection(credential)); }
/// <summary> /// Login operation /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns>Return true if login complete. Otherwise return false.</returns> public bool Login(NZString username, NZString password) { ConfigurationController prc = new ConfigurationController(); UserValidator userValidator = new UserValidator(); ErrorItem errorItem = null; //== Load last database configuration. Map <string, string> mapConfig = prc.LoadConfiguration(); DatabaseCredential credential = new DatabaseCredential(); credential.Provider = (DatabaseProvider)Enum.Parse(typeof(DatabaseProvider), mapConfig[ConfigurationController.S_KEY_PROVIDER_NAME].Value); credential.ServerName = mapConfig[ConfigurationController.S_KEY_SERVER_NAME].Value; credential.DatabaseName = mapConfig[ConfigurationController.S_KEY_DATABASE_NAME].Value; credential.Username = mapConfig[ConfigurationController.S_KEY_USERNAME].Value; credential.Password = mapConfig[ConfigurationController.S_KEY_PASSWORD].Value; credential.ConnectionTimeout = mapConfig[ConfigurationController.S_KEY_CONNECTION_TIMEOUT].Value; int iCommandTimeout = 0; if (Int32.TryParse(mapConfig[ConfigurationController.S_KEY_COMMAND_TIMEOUT].Value, out iCommandTimeout)) { Database.m_iDefaultCommandTimeout = iCommandTimeout; } else { Database.m_iDefaultCommandTimeout = 30; } //== Test database connection ans register current database. errorItem = DatabaseManager.TestConnection(credential); if (errorItem == null) { // Initialize DAO Factory. SystemMaintenance.DAO.DAOFactory.SetProvider(credential.Provider); // Register current database. Common.RegisterCurrentDatabase(DatabaseManager.CreateDatabase(credential)); // Register message loader. ApplicationContextManager.RegisterMessageLoader(new DBMessageLoader(Common.CurrentDatabase)); } else { MessageBox.Show(errorItem.Message.MessageDescription, null, MessageBoxButtons.OK, MessageBoxIcon.Error); // Release current database. Common.UnregisterUserInformation(); return(false); } userValidator.ValidateLogin(username, password); // Singin user information session. UserBIZ userBiz = new UserBIZ(); UserDTO userDTO = userBiz.LoadUser(username); userBiz.RegisterMachine(username); UserInfo userInfo = new UserInfo(); userInfo.DateFormat = (eDateFormat)userDTO.DATE_FORMAT.StrongValue; userInfo.LanguageCD.Value = userDTO.LANG_CD.Value; userInfo.LastLogin.Value = DateTime.Now; userInfo.UserCD.Value = userDTO.USER_ACCOUNT.Value; userInfo.Username.Value = userDTO.FULL_NAME.Value; userInfo.Machine.Value = Environment.MachineName; userInfo.GroupCode.Value = userDTO.GROUP_CD.Value; Common.RegisterUserInformation(userInfo); // Store last user login. IniFile ini = new IniFile(System.IO.Path.Combine(Application.StartupPath, Common.CONFIG_FILENAME)); ini.Write(S_SECTION, S_USER, username.StrongValue); ini.Dispose(); return(true); }