private void backgroundWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { string _message; string _caption; SplashScreenManager.CloseForm(); if (oDbUtilityBL.IsCompleted) { _message = cboOption.SelectedIndex == 1 ? "Database restore successfully completed" : "Database backup successfully completed"; _caption = cboOption.SelectedIndex == 1 ? "Database Restore" : "Database Backup"; barStatus.Caption = _message; DbUtilityHelper.DisplayMessageBox(_message, "information"); } else { DbUtilityHelper.DisplayMessageBox("Sorry database " + cboOption.Properties.Items[cboOption.SelectedIndex].ToString().ToLower() + " could not be completed", "error"); } canClose = true; EnableControls(true); }
/// <summary> /// Initializes the application's default skin /// </summary> private void Initialize() { try { if (settingBL.GetUISetting() != null) { DevExpress.LookAndFeel.UserLookAndFeel.Default.SetSkinStyle(Singleton.Instance.UISettings.Name); //set checked status of the selected skin name foreach (BarItem barItem in bar.Manager.Items) { if (barItem.GetType() == typeof(BarCheckItem)) { if (barItem.Caption.Equals(Singleton.Instance.UISettings.Name)) { ((BarCheckItem)barItem).Checked = true; } } } } SetDefaultServerSettings(); }catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void SetDefaultServerSettings() { try { PopulateServers(); ServerSetting oServerSetting = settingBL.GetServerSetting(); if (oServerSetting != null) { lkeServer.EditValue = oServerSetting.Name; if (lkeServer.EditValue != null) { PopulateDatabases(lkeServer.EditValue.ToString()); lkeDatabases.EditValue = oServerSetting.Database; } txtUserName.Text = oServerSetting.UserName; txtPassword.Text = oServerSetting.Password; } else { DbUtilityHelper.DisplayMessageBox("Default server setting could not be loaded. Try again.", "warning"); } } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox("Default server setting could not be loaded. Try again.\n" + ex.Message, "error"); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (lkeServer.EditValue != null && lkeDatabase.EditValue != null && !String.IsNullOrEmpty(txtUserName.Text) && !String.IsNullOrEmpty(txtPassword.Text)) { oServerSettingBL = new ServerSetting() { Name = lkeServer.EditValue.ToString(), UserName = txtUserName.Text.Trim(), Password = EncryptDecrypt.Encrypt(txtPassword.Text.Trim(), "123"), Database = lkeDatabase.EditValue.ToString() }; if (oSettingBL.Add(oServerSettingBL)) { DbUtilityHelper.DisplayMessageBox("Server setting successfully saved", "information"); } else { DbUtilityHelper.DisplayMessageBox("Server setting could not be saved. Please try agin!", "error"); } } else { DbUtilityHelper.DisplayMessageBox("Required fields can not be blank.", "warning"); } } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void Populate() { try { oBackupSetting = oSettingBL.GetBackupSetting(); if (oBackupSetting != null) { if (oBackupSetting.On == "day/week") { dtEveryDayWeekTime.EditValue = oBackupSetting.Time; List <string> _days = oSettingBL.GetBackupDays(oBackupSetting.Day); foreach (var _controls in layoutControl1.Controls) { if (_controls is CheckButton) { var _btn = _controls as CheckButton; foreach (var _d in _days) { if (_btn.Text == _d) { _btn.Checked = true; break; } } } } } else if (oBackupSetting.On == "every month") { cboEveryMonthDay.EditValue = oBackupSetting.Day; dtEveryMonthTime.EditValue = oBackupSetting.Time; } else if (oBackupSetting.On == "every year") { cboEveryYearMonth.EditValue = oBackupSetting.Month; cboEveryYearDay.EditValue = oBackupSetting.Day; dtEveryYearTime.EditValue = oBackupSetting.Time; } txtBackupLocation.Text = oBackupSetting.BackupLocation; List <string> _cboOptions = new List <string>(); foreach (var i in cboBackupPeriod.Properties.Items) { _cboOptions.Add(i.ToString().ToLower()); } cboBackupPeriod.SelectedIndex = _cboOptions.IndexOf(oBackupSetting.On); } } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void lkeServer_EditValueChanged(object sender, EventArgs e) { try { lkeDatabase.Properties.DataSource = oDbUtilityBL.GetDatabases(lkeServer.EditValue.ToString()); } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox("The system could not load databases. Try again\n" + ex.Message, "warning"); } }
private bool RequiredFieldsNotBlank(string type) { try { if (lkeServer.EditValue == null) { DbUtilityHelper.DisplayMessageBox("Please select the server before proceeding", "warning"); return(false); } else if ((chkWindowsAuthentication.CheckState == CheckState.Unchecked && UserName.ToLower().Equals("admin")) && (String.IsNullOrWhiteSpace(txtUserName.Text) || String.IsNullOrWhiteSpace(txtPassword.Text))) { DbUtilityHelper.DisplayMessageBox("User name and/or password can not be blank", "warning"); if (String.IsNullOrWhiteSpace(txtUserName.Text)) { txtUserName.Focus(); } else { txtPassword.Focus(); } return(false); } else if (lkeDatabases.EditValue == null) { DbUtilityHelper.DisplayMessageBox("Please select the database", "warning"); return(false); } if (type.ToLower().Equals("backup")) { if (String.IsNullOrWhiteSpace(txtBackupLocation.Text)) { DbUtilityHelper.DisplayMessageBox("Please select database backup location", "warning"); return(false); } } else //restore { if (String.IsNullOrWhiteSpace(txtDBBackupFile.Text)) { DbUtilityHelper.DisplayMessageBox("Please select the database backup file", "warning"); return(false); } } return(true); } catch (Exception ex) { return(false); } }
private void btnRefresh_Click(object sender, EventArgs e) { try { PopulateServers(); } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox("Server instances could not be loaded. Try again!\n" + ex.Message, "error"); } }
private void btnBackupLocation_Click(object sender, EventArgs e) { try { folderBrowserDialog.ShowDialog(); txtBackupLocation.Text = folderBrowserDialog.SelectedPath; } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void lkeServer_EditValueChanged(object sender, EventArgs e) { try { //Populates databases from the specified server name PopulateDatabases(lkeServer.EditValue.ToString()); } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox("Databases could not be loaded. Please select the server again.\n" + ex.Message, "error"); } }
/// <summary> /// Generates new password /// </summary> /// <returns></returns> private string GeneratePassword() { try { return(String.Format("p@$$admin@{0}", DateTime.Today.Day.ToString())); } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox("Password could not be generated at this time. Try again\n" + ex.Message, "error"); return(null); } }
private void btnRemove_Click(object sender, EventArgs e) { try { lstReceivers.Items.RemoveAt(lstReceivers.SelectedIndex); btnRemove.Enabled = lstReceivers.ItemCount > 0 ? true : false; } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void cboBackupPeriod_SelectedIndexChanged(object sender, EventArgs e) { try { on = cboBackupPeriod.SelectedItem.ToString().ToLower(); HideShow(on); } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox("Please try agin. \n" + ex.Message, "error"); } }
private void btnLogin_Click(object sender, EventArgs e) { if (loggedInAs == LoginType.GUEST) { UserName = "******"; this.Close(); } else if (noOfTries < MAX_TRIES) { if (!String.IsNullOrWhiteSpace(txtUserName.Text) && !String.IsNullOrWhiteSpace(txtPassword.Text)) { var _userName = txtUserName.Text.Trim(); var _password = txtPassword.Text.Trim(); if (ValidateLogin(_userName, _password)) { UserName = _userName; this.Close(); } else { DbUtilityHelper.DisplayMessageBox("Incorrect user name and/or password. Please retry again.", "Error"); txtUserName.Text = UserName = String.Empty; txtPassword.Text = String.Empty; txtUserName.Focus(); noOfTries++; } } else { if (string.IsNullOrWhiteSpace(txtUserName.Text)) { DbUtilityHelper.DisplayMessageBox("User name can not be blank", "warning"); UserName = string.Empty; txtUserName.Focus(); } else { DbUtilityHelper.DisplayMessageBox("Password can not be blank", "warning"); txtPassword.Focus(); } } } else { DbUtilityHelper.DisplayMessageBox("Too many wrong login attempts. Good Bye!", "Information"); UserName = string.Empty; this.Close(); } }
/// <summary> /// Validates login information /// </summary> /// <param name="userName"></param> /// <param name="password"></param> /// <returns>Returns true if user name/password are correct</returns> private bool ValidateLogin(string userName, string password) { try { //default user name is admin (lower case) and password combination is p@$$admin@{today's date} eg: p@$$admin@21 return(userName.ToLower().Equals("admin") && password.Equals(GeneratePassword()) ? true : false); } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox("The system could allow you to login. Try later!\n" + ex.Message, "error"); UserName = null; return(false); } }
/// <summary> /// Populates the SQL Server instance names /// </summary> private void PopulateServers() { try { SplashScreenManager.ShowForm(typeof(WaitForm1)); lkeServer.Properties.DataSource = oDbUtilityBL.GetServers(); SplashScreenManager.CloseForm(); } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void barSettingServer_ItemClick(object sender, ItemClickEventArgs e) { try { frmServerSetting oServerSetting = new frmServerSetting(); if (!IsAlreadyOpened(oServerSetting)) { oServerSetting.ShowDialog(); } } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void barSettingEmail_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { frmEmailSetting setting = new frmEmailSetting(); if (!IsAlreadyOpened(setting)) { setting.ShowDialog(); } } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void btnSend_Click(object sender, EventArgs e) { try { if (!string.IsNullOrWhiteSpace(txtEmail.Text) && !string.IsNullOrWhiteSpace(txtPassword.Text) && lstReceivers.ItemCount > 0 && !string.IsNullOrWhiteSpace(txtHost.Text)) { SplashScreenManager.ShowForm(typeof(WaitForm1)); MailMessage message = new MailMessage(); SmtpClient smtp = new SmtpClient(); message.From = new MailAddress(txtEmail.Text.Trim()); foreach (var re in GetReceiversEmail()) { message.To.Add(new MailAddress(re)); } message.Subject = "Database backup info"; message.Body = string.Format("Dear all, <br><br>This is to inform you that a database backup has been successfully taken on <b>{0}</b><br><br>regards", DateTime.Now.ToString("f")); // txtBody.Text; message.IsBodyHtml = true; smtp.Port = 587; smtp.Host = txtHost.Text.Trim(); //"smtp.gmail.com"; smtp.EnableSsl = true; smtp.UseDefaultCredentials = false; smtp.Credentials = new NetworkCredential(txtEmail.Text, txtPassword.Text); smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.Send(message); SplashScreenManager.CloseForm(); DbUtilityHelper.DisplayMessageBox("Message sucessfully sent", "information"); } else { DbUtilityHelper.DisplayMessageBox("Required fields cannot be blank", "warning"); } } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox("Email could not be sent at this time. Please try again!\n" + ex.Message, "error"); } }
private void PopulateData() { try { oServerSettingBL = oSettingBL.GetServerSetting(); if (oServerSettingBL != null) { lkeServer.EditValue = oServerSettingBL.Name; txtUserName.Text = oServerSettingBL.UserName; txtPassword.Text = oServerSettingBL.Password; lkeDatabase.EditValue = oServerSettingBL.Database; } } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
/// <summary> /// Populates databases unders the selected server /// </summary> /// <param name="serverName"></param> private void PopulateDatabases(string serverName) { try { //SplashScreenManager.ShowForm(typeof(WaitForm1)); if (!string.IsNullOrEmpty(serverName)) { lkeDatabases.Properties.DataSource = oDbUtilityBL.GetDatabases(serverName); } //SplashScreenManager.CloseForm(); } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void btnSelectDBFile_Click(object sender, EventArgs e) { try { OpenFileDialog _dlg = new OpenFileDialog(); _dlg.Filter = "Files to Extract |*.bak;*.zip"; _dlg.ShowDialog(); if (!String.IsNullOrWhiteSpace(_dlg.FileName)) { txtDBBackupFile.Text = _dlg.FileName; } } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox("Some error > " + ex.Message, "Error"); } }
private void dayOfWeek_Clicked(object sender, EventArgs e)//string dayOfTheWeek, bool isDayToAdd) { try { CheckButton _chkBtn = (CheckButton)sender; selectedDays = string.Empty; if (_chkBtn.Checked) { customDays.Add(Convert.ToInt32(_chkBtn.Tag), _chkBtn.Text); _chkBtn.Appearance.BackColor = Color.Gold; _chkBtn.Appearance.BackColor2 = Color.Goldenrod; } else { customDays.Remove(Convert.ToInt32(_chkBtn.Tag)); _chkBtn.Appearance.BackColor = _chkBtn.Appearance.BackColor2 = Color.Transparent; } var _list = customDays.Keys.ToList(); _list.Sort(); foreach (var key in _list) { if (!string.IsNullOrEmpty(selectedDays)) { selectedDays = selectedDays + "," + customDays[key]; } else { selectedDays = customDays[key]; } } //DbUtilityHelper.DisplayMessageBox(_selectedDays, "information"); } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox("Days selected could not be set. Try again later. \n" + ex.Message, "error"); } }
static void Main() { bool mutexCreated = true; using (Mutex mutex = new Mutex(true, "DbUtility", out mutexCreated)) { if (mutexCreated) { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); DevExpress.Skins.SkinManager.EnableFormSkins(); DevExpress.Skins.SkinManager.EnableMdiFormSkins(); frmLogin loging = new frmLogin(); Application.Run(loging); if (loging.UserName != null) { Application.Run(new frmDbUtility() { UserName = loging.UserName }); } } else { Process current = Process.GetCurrentProcess(); foreach (Process process in Process.GetProcessesByName(current.ProcessName)) { if (process.Id != current.Id) { DbUtilityHelper.DisplayMessageBox("Another instance of DB Utility is already running.", "information"); //XtraMessageBox.Show("Another instance of DB Utility is already running.", MessageBoxButtons.OK, MessageBoxIcon.Information); break; } } } } }
private void barSkin_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { if (!String.IsNullOrWhiteSpace(e.Item.Caption)) { DevExpress.LookAndFeel.UserLookAndFeel.Default.SetSkinStyle(e.Item.Caption); ((BarCheckItem)e.Item).Checked = true; uiSetting = new UISetting() { Type = "Skin", Name = e.Item.Caption }; settingBL.Add(uiSetting); } }catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void cboOption_SelectedIndexChanged(object sender, EventArgs e) { try { //controls the visibility of the form controls based on the option (Backup/Restore) selected layoutControlItem1.Visibility = cboOption.SelectedIndex == 1 ? DevExpress.XtraLayout.Utils.LayoutVisibility.Always : DevExpress.XtraLayout.Utils.LayoutVisibility.Never; layoutControlItem8.Visibility = cboOption.SelectedIndex == 1 ? DevExpress.XtraLayout.Utils.LayoutVisibility.Always : DevExpress.XtraLayout.Utils.LayoutVisibility.Never; layoutControlItem6.Visibility = cboOption.SelectedIndex == 1 ? DevExpress.XtraLayout.Utils.LayoutVisibility.Always : DevExpress.XtraLayout.Utils.LayoutVisibility.Never; layoutControlItem12.Visibility = cboOption.SelectedIndex == 1 ? DevExpress.XtraLayout.Utils.LayoutVisibility.Never : DevExpress.XtraLayout.Utils.LayoutVisibility.Always; layoutControlItem15.Visibility = cboOption.SelectedIndex == 1 ? DevExpress.XtraLayout.Utils.LayoutVisibility.Never : DevExpress.XtraLayout.Utils.LayoutVisibility.Always; layoutControlItem5.Visibility = cboOption.SelectedIndex == 1 ? DevExpress.XtraLayout.Utils.LayoutVisibility.Never : DevExpress.XtraLayout.Utils.LayoutVisibility.Always; layBackupDatabase.Visibility = cboOption.SelectedIndex == 0 ? DevExpress.XtraLayout.Utils.LayoutVisibility.Always : DevExpress.XtraLayout.Utils.LayoutVisibility.Never; layRestoreDatabase.Visibility = cboOption.SelectedIndex == 1 ? DevExpress.XtraLayout.Utils.LayoutVisibility.Always : DevExpress.XtraLayout.Utils.LayoutVisibility.Never; this.Height = cboOption.SelectedIndex == 1 ? 450 : 430; } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void btnBackup_Click(object sender, EventArgs e) { try { prgBarDbUtility.Text = (0).ToString(); if (RequiredFieldsNotBlank("backup")) { oDbUtilityBL.DbName = lkeDatabases.EditValue.ToString().Trim(); oDbUtilityBL.DbBackupLocation = txtBackupLocation.Text.Trim(); oDbUtilityBL.TaskIsBackup = true; if (chkWindowsAuthentication.CheckState == CheckState.Unchecked) { oDbUtilityBL.UserName = txtUserName.Text.Trim(); oDbUtilityBL.Password = txtPassword.Text.Trim(); } //users are not allowed to close the form canClose = false; oDbUtilityBL.IsLoginSecured = chkWindowsAuthentication.CheckState == CheckState.Unchecked ? false : true; oDbUtilityBL.ServerName = lkeServer.EditValue.ToString(); oDbUtilityBL.Connect(); SplashScreenManager.ShowForm(typeof(WaitForm1)); backgroundWorker.RunWorkerAsync(); } } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void PopulateData() { try { emailSetting = settingBL.GetEmailSetting(); if (emailSetting != null) { txtEmail.Text = emailSetting.SenderEmail; txtPassword.Text = emailSetting.Password; foreach (var re in emailSetting.ReceiversEmail) { lstReceivers.Items.Add(re); } txtHost.Text = emailSetting.Host; btnRemove.Enabled = lstReceivers.ItemCount > 0 ? true : false; } } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(txtEmail.Text.Trim()) && !string.IsNullOrEmpty(txtPassword.Text.Trim()) && !string.IsNullOrEmpty(txtHost.Text.Trim()) && lstReceivers.ItemCount > 0) { emailSetting = new EmailSetting() { SenderEmail = txtEmail.Text.Trim(), Password = EncryptDecrypt.Encrypt(txtPassword.Text.Trim(), "123"), Host = txtHost.Text.Trim() }; emailSetting.ReceiversEmail = GetReceiversEmail(); if (settingBL.Add(emailSetting)) { DbUtilityHelper.DisplayMessageBox("Email setting successfully saved", "information"); } else { DbUtilityHelper.DisplayMessageBox("Email setting could not be saved. Please try agin!", "error"); } } else { DbUtilityHelper.DisplayMessageBox("Required fields cannot be blank.", "warning"); } } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (!string.IsNullOrWhiteSpace(txtReceiverEmail.Text)) { //setting.ReceiversEmail.Add(txtReceiverEmail.Text.Trim()); lstReceivers.Items.Add(txtReceiverEmail.Text.Trim()); txtReceiverEmail.Text = string.Empty; lstReceivers.Refresh(); btnRemove.Enabled = lstReceivers.ItemCount > 0 ? true : false; txtReceiverEmail.Focus(); } else { DbUtilityHelper.DisplayMessageBox("Receiver's email address cannot be blank", "warning"); } } catch (Exception ex) { DbUtilityHelper.DisplayMessageBox(ex.Message, "error"); } }