private void TriggerAccess_RestoreFromMSSQL() { Accountant curr_acc = mApplicationController.mAccountant; Accountant source_acc = new ImAccountant("SourceAccount(MSSQL)"); DbManager default_factory = new SqlClientDbManager(source_acc, "PrimaryFactory"); default_factory.Database = txtMSSQLDb.Text; default_factory.HostExePath = txtMSSQLHost.Text; default_factory.Port = txtMSSQLPort.Text; default_factory.DbPassword = txtMSSQLPWD.Text; default_factory.DbUsername = txtMSSQLUID.Text; source_acc.DefaultMgrFactory = default_factory; string error; if (source_acc.ConnectMgrFactories(out error)) { if (chkBackupItemAddOn.Checked) { curr_acc.ItemAddOnMgr.RecreateTable(); IList <ItemAddOn> CurrItemAddOns = source_acc.ItemAddOnMgr.FindAllCollection(); foreach (ItemAddOn s in CurrItemAddOns) { curr_acc.ItemAddOnMgr.Store(s); } curr_acc.DataFieldMgr.RecreateTable(); IList <DataField> DataFields = source_acc.DataFieldMgr.FindAllCollection(); foreach (DataField s in DataFields) { curr_acc.DataFieldMgr.Store(s); } curr_acc.ItemDataFieldEntryMgr.RecreateTable(); IList <ItemDataFieldEntry> ItemDataFieldEntries = source_acc.ItemDataFieldEntryMgr.FindAllCollection(); foreach (ItemDataFieldEntry s in ItemDataFieldEntries) { curr_acc.ItemDataFieldEntryMgr.Store(s); } } } else { MessageBox.Show(error); } source_acc.Release(); }
public void BackupToMSSQL() { bool BackupByMSSQL = mAccountant.ConfigMgr.GetParamValue("BACKUP_MSSQLUSE").Equals("1"); if (!BackupByMSSQL) { return; } Accountant backup_acc = new ImAccountant("BackupAccount(MSSQL)"); string MSSQLUID = mAccountant.ConfigMgr.GetParamValue("BACKUP_MSSQLUID"); string MSSQLPWD = mAccountant.ConfigMgr.GetParamValue("BACKUP_MSSQLPWD"); string MSSQLDb = mAccountant.ConfigMgr.GetParamValue("BACKUP_MSSQLDB"); string MSSQLHost = mAccountant.ConfigMgr.GetParamValue("BACKUP_MSSQLHOST"); string MSSQLPort = mAccountant.ConfigMgr.GetParamValue("BACKUP_MSSQLPORT"); bool BackupItemAddOn = mAccountant.ConfigMgr.GetParamValue("BACKUP_ITEMADDON").Equals("1"); bool BackupAuthentication = mAccountant.ConfigMgr.GetParamValue("BACKUP_AUTHENTICATION").Equals("1"); bool BackupAuthorization = mAccountant.ConfigMgr.GetParamValue("BACKUP_AUTHORIZATION").Equals("1"); DbManager default_factory = new SqlClientDbManager(backup_acc, "PrimaryFactory"); default_factory.Database = MSSQLDb; default_factory.HostExePath = MSSQLHost; default_factory.Port = MSSQLPort; default_factory.DbPassword = MSSQLPWD; default_factory.DbUsername = MSSQLUID; backup_acc.DefaultMgrFactory = default_factory; string error; if (backup_acc.ConnectMgrFactories(out error)) { if (BackupItemAddOn) { backup_acc.ItemAddOnMgr.RecreateTable(); IList <ItemAddOn> CurrItemAddOns = mAccountant.ItemAddOnMgr.FindAllCollection(); foreach (ItemAddOn s in CurrItemAddOns) { backup_acc.ItemAddOnMgr.Store(s); } backup_acc.DataFieldMgr.RecreateTable(); IList <DataField> DataFields = mAccountant.DataFieldMgr.FindAllCollection(); foreach (DataField s in DataFields) { backup_acc.DataFieldMgr.Store(s); } backup_acc.ItemDataFieldEntryMgr.RecreateTable(); IList <ItemDataFieldEntry> ItemDataFieldEntries = mAccountant.ItemDataFieldEntryMgr.FindAllCollection(); foreach (ItemDataFieldEntry s in ItemDataFieldEntries) { backup_acc.ItemDataFieldEntryMgr.Store(s); } } } else { System.Windows.Forms.MessageBox.Show(error); } backup_acc.Release(); }
private void btnLogin_Click(object sender, EventArgs e) { if (!System.IO.File.Exists(txtApp.Text)) { MessageBox.Show("The Myob Application path is not set correctly!"); DialogResult = DialogResult.None; return; } if (!System.IO.File.Exists(txtDB.Text)) { MessageBox.Show("The Myob Database path is not set correctly!"); DialogResult = DialogResult.None; return; } DbManager secondary_factory = null; string network_db = "0"; if (rdoLocalDb.Checked) { secondary_factory = new OleDbManager(mAccountant, "SecondaryFactory"); secondary_factory.Database = mAccountant.GetFullPath("inventorist.mdb"); secondary_factory.DbPassword = "******"; } else if (rdoNetworkedMySQL.Checked) { secondary_factory = new MySQLDbManager(mAccountant, "SecondaryFactory"); secondary_factory.DbUsername = (txtMySQLUID.Text); secondary_factory.DbPassword = (txtMySQLPWD.Text); secondary_factory.Database = (txtMySQLDb.Text); secondary_factory.HostExePath = (txtMySQLHost.Text); secondary_factory.Port = (txtMySQLPort.Text); network_db = "1"; } else if (rdoNetworkedMSSQL.Checked) { secondary_factory = new SqlClientDbManager(mAccountant, "SecondaryFactory"); secondary_factory.DbUsername = (txtMSSQLUID.Text); secondary_factory.DbPassword = (txtMSSQLPWD.Text); secondary_factory.Database = (txtMSSQLDb.Text); secondary_factory.HostExePath = (txtMSSQLHost.Text); secondary_factory.Port = (txtMSSQLPort.Text); network_db = "2"; } mAccountant.ConfigMgr.SetParam("NETWORK_NETWORKDB", network_db); mAccountant.AddMgrFactory(secondary_factory); mAccountant.AuthItemMgrFactory = secondary_factory; mAccountant.AuthRoleMgrFactory = secondary_factory; mAccountant.AuthUserMgrFactory = secondary_factory; mAccountant.ItemAddOnMgrFactory = secondary_factory; mAccountant.GenderMgrFactory = secondary_factory; mAccountant.ItemSizeMgrFactory = secondary_factory; List <string> message = new List <string>(); if (!ValidateLogin(message)) { if (message.Count == 0) { MessageBox.Show("Invalid Login!"); } else { MessageBox.Show("Invalid Login! (" + message[0] + ")"); } DialogResult = DialogResult.None; } }