/// <summary> /// Handles the Click event of the btnSave control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> private void btnSave_Click(object sender, EventArgs e) { try { if (DateTime.Parse(dtPostedDate.Text).Year < DateTime.Parse(GlobalVariable.SystemDate).Year) { XtraMessageBox.Show(ResourceHelper.GetResourceValueByName("ResPostedDateLessSysemDate"), ResourceHelper.GetResourceValueByName("ResDetailContent"), MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var message = _dbOptionsPresenter.Save(); if (message != null) { XtraMessageBox.Show(message, ResourceHelper.GetResourceValueByName("ResDetailContent"), MessageBoxButtons.OK, MessageBoxIcon.Error); } _globalVariable.PostedDate = dtPostedDate.EditValue.ToString(); GlobalVariable.StartedDate = dtPostedDate.EditValue.ToString();//LINHMC gan lai de luu lai gia tri thay doi ngay hach toan //_dbOptionsPresenter.Display(); Close(); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message, ResourceHelper.GetResourceValueByName("ResExceptionCaption"), MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnLock_Click(object sender, EventArgs e) { if (dtReportPeriod.ToDate >= DateTime.Parse(GlobalVariable.DBStartDate)) //if (dtExcuteDate.DateTime >= DateTime.Parse(GlobalVariable.DBStartDate)) { IsLock = 1; ActionMode = ActionModeEnum.Lock; _dbOptionsPresenter.Save(); _audittingLogPresenter.Save(); GlobalVariable.LockVoucherSeason = LockDateSeason; GlobalVariable.LockVoucherDateFrom = LockDateFrom.ToLongDateString(); GlobalVariable.LockVoucherDateTo = LockDateTo.ToLongDateString(); RefeshForm(); XtraMessageBox.Show("Khóa sổ thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); btnLock.Enabled = false; btnUnlock.Enabled = true; } else { XtraMessageBox.Show("Ngày khóa sổ không được nhỏ hơn ngày khởi tạo dữ liệu!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
/// <summary> /// Handles the ButtonClick event of the btnOldDatabasePath control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="DevExpress.XtraEditors.Controls.ButtonPressedEventArgs"/> instance containing the event data.</param> /// <summary> /// Handles the Click event of the btnFinish control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> private void btnFinish_Click(object sender, EventArgs e) { try { if (treeView1.Nodes.Count > 0) { Cursor = Cursors.WaitCursor; lstCheck.Clear(); foreach (TreeNode node in treeView1.Nodes) { GetCheckNode(node); } progressBar1.Visible = true; progressBar1.Minimum = 0; progressBar1.Maximum = lstCheck.Count; int i = 0; var restore = new Restore { Action = RestoreActionType.Database, Database = txtDatabaseName.Text.Trim(), ReplaceDatabase = true, ContinueAfterError = true }; if (!System.IO.File.Exists(AppDomain.CurrentDomain.BaseDirectory + DatabaseTemplatePath)) { XtraMessageBox.Show("Đường dẫn cơ sở dữ liệu mẫu không tồn tại", "Thông báo lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var backupDeviceItem = new BackupDeviceItem(AppDomain.CurrentDomain.BaseDirectory + DatabaseTemplatePath, DeviceType.File); restore.Devices.Add(backupDeviceItem); var fileList = restore.ReadFileList(_server); restore.RelocateFiles.Add(new RelocateFile(fileList.Rows[0][0].ToString().Trim(), btnDatabasePath.Text + @"\" + txtDatabaseName.Text.Trim() + ".mdf")); restore.RelocateFiles.Add(new RelocateFile(fileList.Rows[1][0].ToString().Trim(), btnDatabasePath.Text + @"\" + txtDatabaseName.Text.Trim() + "_log.ldf")); restore.SqlRestore(_server); var database = _server.Databases[txtDatabaseName.Text.Trim()]; if (database != null) { database.SetOnline(); } //update options var message = _dbOptionsPresenter.Save(); if (message != null) { XtraMessageBox.Show(message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { progressBar1.Value = i; } //set connect string cho khởi tạo db mới hoặc db đang sử dụng //xu ly password var password = RegistryHelperTransform.GetValueByRegistryKey("Password"); if (!string.IsNullOrEmpty(password)) { password = Crypto.Decrypting(password, "@bgt1me"); } if (isNewDB) { //add new connection string var dataProvider = ConfigurationManager.AppSettings.Get("ConnectionStringName"); var appConfig = ConfigurationManager.OpenExeConfiguration(Assembly.GetExecutingAssembly().Location); var connectionString = string.Format( "Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", RegistryHelper.GetValueByRegistryKey("InstanceName"), txtDatabaseName.Text.Trim(), RegistryHelper.GetValueByRegistryKey("UserName"), password); if (appConfig.ConnectionStrings.ConnectionStrings[dataProvider] == null) //AnhNT: Thêm điều kiện check nếu chưa tồn tại connection thì mới add { appConfig.ConnectionStrings.ConnectionStrings.Add( new ConnectionStringSettings(dataProvider, connectionString)); } else//Nếu tồn tại thì modify { appConfig.ConnectionStrings.ConnectionStrings[dataProvider].ConnectionString = connectionString; } appConfig.Save(ConfigurationSaveMode.Full); ConfigurationManager.RefreshSection("connectionStrings"); } //chuyển đổi dữ liệu string connectString = BuildConnectionString(cbSelectServer.Text, cboSelectSourceDB.Text); foreach (var check in lstCheck) { var result = model.ConvertDB(connectString, check.Name.Substring(4)); if (result == null) { i = i + 1; progressBar1.Value = i; _result = true; } else { _result = false; XtraMessageBox.Show(check.Text + ":" + result, "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } if (_result == false) { var databaseForDelete = GlobalVariable.Server.Databases[txtDatabaseName.Text.Trim()]; databaseForDelete.Drop(); } else { DialogResult dialogResult = new DialogResult(); if (isNewDB) { dialogResult = XtraMessageBox.Show( "Chuyển đổi cơ sở dữ liệu thành công!Bạn có muốn sử dụng cơ sở dữ liệu đã chuyển đổi", "Thông báo ", MessageBoxButtons.YesNo, MessageBoxIcon.Information); Cursor = Cursors.Default; } else { dialogResult = XtraMessageBox.Show( "Chuyển đổi cơ sở dữ liệu thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information); Cursor = Cursors.Default; } if (dialogResult == DialogResult.Yes) { ////update registry RegistryHelperTransform.RemoveConnectionString(); RegistryHelperTransform.SetValueForRegistry("DatabaseName", txtDatabaseName.Text); var dbPathLenght = btnDatabasePath.Text.LastIndexOf(@"\", StringComparison.Ordinal); var dbPath = btnDatabasePath.Text; if (dbPathLenght == -1) { dbPath = dbPath + @"\"; } RegistryHelperTransform.SetValueForRegistry("DatabasePath", dbPath); RegistryHelperTransform.SaveConfigFile(); System.Windows.Forms.Application.Restart(); } else { if (isNewDB) { var dataProvider = ConfigurationManager.AppSettings.Get("ConnectionStringName"); var appConfig = ConfigurationManager.OpenExeConfiguration(Assembly.GetExecutingAssembly().Location); //xu ly password var password = RegistryHelperTransform.GetValueByRegistryKey("Password"); if (!string.IsNullOrEmpty(password)) { password = Crypto.Decrypting(password, "@bgt1me"); } var connectionString = string.Format( "Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", RegistryHelperTransform.GetValueByRegistryKey("InstanceName"), RegistryHelperTransform.GetValueByRegistryKey("DatabaseName"), RegistryHelperTransform.GetValueByRegistryKey("UserName"), password); appConfig.ConnectionStrings.ConnectionStrings[dataProvider].ConnectionString = connectionString; appConfig.Save(ConfigurationSaveMode.Full); ConfigurationManager.RefreshSection("connectionStrings"); } Close(); } } } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.ToString(), "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// Handles the Click event of the btnFinish control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> private void btnFinish_Click(object sender, EventArgs e) { try { Cursor = Cursors.WaitCursor; var restore = new Restore { Action = RestoreActionType.Database, Database = txtDatabaseName.Text.Trim(), ReplaceDatabase = true, ContinueAfterError = true }; if (!System.IO.File.Exists(AppDomain.CurrentDomain.BaseDirectory + DatabaseTemplatePath)) { XtraMessageBox.Show(ResourceHelper.GetResourceValueByName("ResDatabaseTempNotExist"), ResourceHelper.GetResourceValueByName("ResExceptionCaption"), MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var backupDeviceItem = new BackupDeviceItem(AppDomain.CurrentDomain.BaseDirectory + DatabaseTemplatePath, DeviceType.File); restore.Devices.Add(backupDeviceItem); var fileList = restore.ReadFileList(_server); string PathBackUp = btnDatabasePath.Text; string ExportXmlPath = ""; if (!Directory.Exists(PathBackUp)) { string BPath = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName; PathBackUp = Path.Combine(BPath, "BACKUP"); ExportXmlPath = Path.Combine(BPath, "EXPORTXML"); System.IO.Directory.CreateDirectory(PathBackUp); System.IO.Directory.CreateDirectory(ExportXmlPath); DBOptions.Add(new DBOptionModel { OptionId = "PathBackup", OptionValue = PathBackUp, ValueType = 0, Description = "Thư mục sao lưu", IsSystem = false }); DBOptions.Add(new DBOptionModel { OptionId = "PathXML", OptionValue = ExportXmlPath, ValueType = 0, Description = "", IsSystem = false }); } restore.RelocateFiles.Add(new RelocateFile(fileList.Rows[0][0].ToString().Trim(), PathBackUp + @"\" + txtDatabaseName.Text.Trim() + ".mdf")); restore.RelocateFiles.Add(new RelocateFile(fileList.Rows[1][0].ToString().Trim(), PathBackUp + @"\" + txtDatabaseName.Text.Trim() + "_log.ldf")); restore.SqlRestore(_server); var database = _server.Databases[txtDatabaseName.Text.Trim()]; if (database != null) { database.SetOnline(); } ////LinhMC change logicalName, ThangNK comment lại khi chuyển sang tư vấn nó ko lỗi //if (_server != null) //{ // var databaseName = txtDatabaseName.Text.Trim(); // string strCommand = "ALTER DATABASE " + databaseName + " MODIFY FILE (NAME = aBigTime, NEWNAME = " + // databaseName + "); ALTER DATABASE " + databaseName + // " MODIFY FILE (NAME = aBigTime_log, NEWNAME = " + databaseName + "_log);"; // _server.ConnectionContext.ExecuteNonQuery(strCommand); //} //update registry RegistryHelper.RemoveConnectionString(); RegistryHelper.SetValueForRegistry("DatabaseName", txtDatabaseName.Text); var dbPathLenght = PathBackUp.LastIndexOf(@"\", StringComparison.Ordinal); var dbPath = PathBackUp; if (dbPathLenght == -1) { dbPath = dbPath + @"\"; } RegistryHelper.SetValueForRegistry("DatabasePath", dbPath); RegistryHelper.SaveConfigFile(); //update options var message = _dbOptionsPresenter.Save(); if (message != null) { XtraMessageBox.Show(message, ResourceHelper.GetResourceValueByName("ResDetailContent"), MessageBoxButtons.OK, MessageBoxIcon.Error); } else { //update currency //_currencyPresenter.DisplayByCurrencyCode(cboCurrencyAccounting.EditValue == null ? null : cboCurrencyAccounting.EditValue.ToString()); //if (CurrencyId != 0) //{ // IsActive = true; // _currencyPresenter.Save(); //} //_currencyPresenter.DisplayByCurrencyCode(cboCurrencyAccounting.EditValue == null ? null : cboCurrencyLocal.EditValue.ToString()); //if (CurrencyId != 0) //{ // IsActive = true; // _currencyPresenter.Save(); //} //_currencyPresenter.DisplayByCurrencyCode(cboCurrencyAccounting.EditValue == null ? null : cboCurrencyCodeOfSalary.EditValue.ToString()); //if (CurrencyId != 0) //{ // IsActive = true; // _currencyPresenter.Save(); //} XtraMessageBox.Show(ResourceHelper.GetResourceValueByName("ResCreateDBSucces"), ResourceHelper.GetResourceValueByName("ResDetailContent"), MessageBoxButtons.OK, MessageBoxIcon.Information); } ////update account //_accountPresenter.DisplayByAccountCode("11122"); //CurrencyCode = cboCurrencyLocal.EditValue.ToString().Trim(); //_accountPresenter.Save(); //_accountPresenter.DisplayByAccountCode("11222"); //CurrencyCode = cboCurrencyLocal.EditValue.ToString().Trim(); //_accountPresenter.Save(); Cursor = Cursors.Default; System.Windows.Forms.Application.Restart(); } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.ToString(), ResourceHelper.GetResourceValueByName("ResExceptionCaption"), MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// Handles the Click event of the btnFinish control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> private void btnFinish_Click(object sender, EventArgs e) { try { Cursor = Cursors.WaitCursor; var restore = new Restore { Action = RestoreActionType.Database, Database = txtDatabaseName.Text.Trim(), ReplaceDatabase = true, ContinueAfterError = true }; if (!System.IO.File.Exists(AppDomain.CurrentDomain.BaseDirectory + DatabaseTemplatePath)) { XtraMessageBox.Show(ResourceHelper.GetResourceValueByName("ResDatabaseTempNotExist"), ResourceHelper.GetResourceValueByName("ResExceptionCaption"), MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var backupDeviceItem = new BackupDeviceItem(AppDomain.CurrentDomain.BaseDirectory + DatabaseTemplatePath, DeviceType.File); restore.Devices.Add(backupDeviceItem); var fileList = restore.ReadFileList(_server); restore.RelocateFiles.Add(new RelocateFile(fileList.Rows[0][0].ToString().Trim(), btnDatabasePath.Text + @"\" + txtDatabaseName.Text.Trim() + ".mdf")); restore.RelocateFiles.Add(new RelocateFile(fileList.Rows[1][0].ToString().Trim(), btnDatabasePath.Text + @"\" + txtDatabaseName.Text.Trim() + "_log.ldf")); restore.SqlRestore(_server); var database = _server.Databases[txtDatabaseName.Text.Trim()]; if (database != null) { database.SetOnline(); } ////LinhMC change logicalName, ThangNK comment lại khi chuyển sang tư vấn nó ko lỗi //if (_server != null) //{ // var databaseName = txtDatabaseName.Text.Trim(); // string strCommand = "ALTER DATABASE " + databaseName + " MODIFY FILE (NAME = aBigTime, NEWNAME = " + // databaseName + "); ALTER DATABASE " + databaseName + // " MODIFY FILE (NAME = aBigTime_log, NEWNAME = " + databaseName + "_log);"; // _server.ConnectionContext.ExecuteNonQuery(strCommand); //} //update registry RegistryHelper.RemoveConnectionString(); RegistryHelper.SetValueForRegistry("DatabaseName", txtDatabaseName.Text); RegistryHelper.SetValueForRegistry("DatabasePath", btnDatabasePath.Text + @"\"); RegistryHelper.SaveConfigFile(); //update options var message = _dbOptionsPresenter.Save(); if (message != null) { XtraMessageBox.Show(message, ResourceHelper.GetResourceValueByName("ResDetailContent"), MessageBoxButtons.OK, MessageBoxIcon.Error); } else { //update currency _currencyPresenter.DisplayByCurrencyCode(cboCurrencyAccounting.EditValue == null ? null : cboCurrencyAccounting.EditValue.ToString()); if (CurrencyId != 0) { IsActive = true; _currencyPresenter.Save(); } _currencyPresenter.DisplayByCurrencyCode(cboCurrencyAccounting.EditValue == null ? null : cboCurrencyLocal.EditValue.ToString()); if (CurrencyId != 0) { IsActive = true; _currencyPresenter.Save(); } _currencyPresenter.DisplayByCurrencyCode(cboCurrencyAccounting.EditValue == null ? null : cboCurrencyCodeOfSalary.EditValue.ToString()); if (CurrencyId != 0) { IsActive = true; _currencyPresenter.Save(); } XtraMessageBox.Show(ResourceHelper.GetResourceValueByName("ResCreateDBSucces"), ResourceHelper.GetResourceValueByName("ResDetailContent"), MessageBoxButtons.OK, MessageBoxIcon.Information); } //update account _accountPresenter.DisplayByAccountCode("11122"); CurrencyCode = cboCurrencyLocal.EditValue.ToString().Trim(); _accountPresenter.Save(); _accountPresenter.DisplayByAccountCode("11222"); CurrencyCode = cboCurrencyLocal.EditValue.ToString().Trim(); _accountPresenter.Save(); //update cac khoan luong LoadPayItem(); if (cboCurrencyCodeOfSalary.EditValue.Equals("USD")) { foreach (var payItem in _payItems) { _payItemPresenter.Display(payItem.PayItemId.ToString(CultureInfo.InvariantCulture)); CreditAccountCode = "11121"; _payItemPresenter.Save(); } } else { foreach (var payItem in _payItems) { _payItemPresenter.Display(payItem.PayItemId.ToString(CultureInfo.InvariantCulture)); CreditAccountCode = "11122"; _payItemPresenter.Save(); } } LoadAutoBusiness(); if (cboCurrencyLocal.EditValue != null && cboCurrencyAccounting.EditValue != null) { var lstAutoBusinessByNotUSD = _autoAutoBusiness.Where(w => w.CurrencyCode != null && w.CurrencyCode != string.Empty && w.CurrencyCode != cboCurrencyAccounting.EditValue.ToString()).ToList(); foreach (var autoBusiness in lstAutoBusinessByNotUSD) { _autoBusinessPresenter.Display(autoBusiness.AutoBusinessId.ToString(CultureInfo.InvariantCulture)); CurrencyCode = cboCurrencyLocal.EditValue.ToString(); _autoBusinessPresenter.Save(); } } Cursor = Cursors.Default; System.Windows.Forms.Application.Restart(); } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.ToString(), ResourceHelper.GetResourceValueByName("ResExceptionCaption"), MessageBoxButtons.OK, MessageBoxIcon.Error); } }