void IsDBExists() { oDatabase = new DataAccess.BackupRestoreDB(); if (!oDatabase.IsDatabaseExits()) { oFrmMsgBox = new Forms.frmMessageBox(eVariable.TransactionMessage.DATABASE_DOES_NOT_EXISTS.ToString().Replace("_", " ")); oFrmMsgBox.m_MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); Maintenance.frmBackupRestoreDB oFrmDB = new Maintenance.frmBackupRestoreDB(); oFrmDB.ShowDialog(); return; } }
private void btnButton_Click(object sender, EventArgs e) { try { if (btnButton.Text.Trim() == "BACKUP") { #region Backup oBackup = new DataAccess.BackupRestoreDB(); if (txtDBBackup.Text.Trim() != string.Empty) { if (oBackup.IsDatabaseExits()) { if (oBackup.BackupDatabase(txtDBBackup.Text)) { oFrmMsgBox = new Forms.frmMessageBox(eVariable.TransactionMessage.DATABASE_HAS_BEEN_SUCESSFULLY_BACKUP_IN_PATH.ToString().Replace("_", " ") + " " + txtDBBackup.Text); oFrmMsgBox.m_MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); } else { oFrmMsgBox = new Forms.frmMessageBox(eVariable.TransactionMessage.DATABASE_BACKUP_FAILED.ToString().Replace("_", " ")); oFrmMsgBox.m_MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); } } else { oFrmMsgBox = new Forms.frmMessageBox(eVariable.TransactionMessage.THE_DATABASE_DOES_NOT_EXITS.ToString().Replace("_", " ")); oFrmMsgBox.m_MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); } } else { oFrmMsgBox = new Forms.frmMessageBox(eVariable.TransactionMessage.PLEASE_SELECT_DISTINATION_PATH_TO_SAVE_THE_FILE.ToString().Replace("_", " ")); oFrmMsgBox.m_MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); } txtDBBackup.Text = string.Empty; return; #endregion } else { #region Restore if (txtDBRestore.Text.Trim() != String.Empty) { oRestore = new DataAccess.BackupRestoreDB(); if (oRestore.RestoreDatabase(txtDBRestore.Text)) { oFrmMsgBox = new Forms.frmMessageBox(eVariable.TransactionMessage.DATABASE_HAS_BEEN_SUCESSFULLY_RESTORED.ToString().Replace("_", " ")); oFrmMsgBox.m_MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); } else { oFrmMsgBox = new Forms.frmMessageBox(eVariable.TransactionMessage.DATABASE_RESTORATION_FAILED.ToString().Replace("_", " ")); oFrmMsgBox.m_MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); } } txtDBRestore.Text = string.Empty; return; #endregion } } catch (Exception ex) { } }
private void btnLogin_Click(object sender, EventArgs e) { oUser = new DataAccess.User(); oCommonFunction = new CommonFunction.CommonFunction(); if (oCommonFunction.Decrypt(oDefUser.USERNAME.Trim()) == txtUsername.Text && oCommonFunction.Decrypt(oDefUser.PASSWORD.Trim()) == txtPassword.Text) //Default Login { this.ShowInTaskbar = false; this.Hide(); oMainForm = new MAIN(txtUsername.Text, txtPassword.Text, oCommonFunction.Decrypt(oDefUser.FULLNAME), oCommonFunction.Decrypt(oDefUser.ROLE)); oMainForm.ShowDialog(); return; } else { #region CheckDatabase oDatabase = new DataAccess.BackupRestoreDB(); if (!oDatabase.IsDatabaseExits()) { oFrmMsgBox = new frmMessageBox(ePublicVariable.eVariable.TransactionMessage.THE_DATABASE_DOES_NOT_EXITS.ToString().Replace("_", " ")); oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); Maintenance.frmBackupRestoreDB oFrm = new Maintenance.frmBackupRestoreDB(); oFrm.ShowDialog(); } #endregion #region DBLogin if (oUser.IsLogin(txtUsername.Text.Trim(), txtPassword.Text.Trim())) { foreach (DataRow row in oUser.GetUser("username", txtUsername.Text).Rows) { oMUser = new Model.User(); oMUser.USERNAME = row[0].ToString(); oMUser.FULLNAME = row[1].ToString(); oMUser.PASSWORD = row[2].ToString(); oMUser.ROLE = row[3].ToString(); oMUser.CONTACT_NO = row[4].ToString(); oMUser.ADDRESS = row[5].ToString(); } this.ShowInTaskbar = false; this.Hide(); oMainForm = new MAIN(oMUser); oMainForm.ShowDialog(); return; } else { lblNotification.Text = "THE USERNAME AND PASSWORD YOU HAVE ENTERED ARE INCORRECT"; txtUsername.Focus(); } #endregion } }