private void btnButton_Click(object sender, EventArgs e) { if (btnButton.Text.Trim() == "BACKUP") { #region Backup oBackup = new DataAccess.SystemFunction(); if (txtDBBackup.Text.Trim() != string.Empty) { if (oBackup.IsDatabaseExits()) { oBackup.BackupDatabase(txtDBBackup.Text); oFrmMsgBox = new Forms.frmMessageBox("DATABASE SUCCESSFULL BACKUP IN PATH :" + " " + txtDBBackup.Text); oFrmMsgBox.MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); } else { oFrmMsgBox = new Forms.frmMessageBox("DATABASE DOES NOT EXISTS"); oFrmMsgBox.MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); } } else { oFrmMsgBox = new Forms.frmMessageBox("PLEASE SELECT DISTINATION FOLDER TO SAVE THE FILE."); oFrmMsgBox.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.SystemFunction(); //if (oRestore.IsDatabaseExits()) //{ // oRestore.DropDatabase(); //} oRestore.RestoreDatabase(txtDBRestore.Text); oFrmMsgBox = new Forms.frmMessageBox("DATABASE SUCCESSFULLY RESTORED"); oFrmMsgBox.MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); } txtDBRestore.Text = string.Empty; return; #endregion } }
private void btnLogin_Click(object sender, EventArgs e) { oUser = new DataAccess.User(); oUtility = new CommonFunction.CommonFunction(); if (oUtility.Decrypt(oDefUser.USERNAME.Trim()) == txtUsername.Text && oUtility.Decrypt(oDefUser.PASSWORD.Trim()) == txtPassword.Text) //Default Login { this.Hide(); this.ShowInTaskbar = false; ePublicVariable.eVariable.sUsername = txtUsername.Text; ePublicVariable.eVariable.sPassword = txtPassword.Text; ePublicVariable.eVariable.sFullname = oUtility.Decrypt(oDefUser.FULLNAME); ePublicVariable.eVariable.sRole = oUtility.Decrypt(oDefUser.ROLE); oMainForm = new MAIN(); oMainForm.ShowDialog(); } else { #region CheckDatabase oDatabase = new DataAccess.SystemFunction(); if (!oDatabase.IsDatabaseExits()) { oFrmMsgBox = new frmMessageBox("DATABASE DOES NOT EXISTS. PLEASE RESTORE FIRST THE DATABASE. THANK YOU"); oFrmMsgBox.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())) { this.ShowInTaskbar = false; this.Hide(); ePublicVariable.eVariable.sUsername = txtUsername.Text; ePublicVariable.eVariable.sPassword = txtPassword.Text; oMainForm = new MAIN(); oMainForm.ShowDialog(); } else { oFrmMsgBox = new Forms.frmMessageBox("PLEASE ENTER CORRECT USERNAME AND PASSWORD."); oFrmMsgBox.MessageType = frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); txtUsername.Focus(); } #endregion } }
void IsDBExists() { oDatabase = new DataAccess.SystemFunction(); if (!oDatabase.IsDatabaseExits()) { oFrmMsgBox = new Forms.frmMessageBox("DATABASE DOES NOT EXISTS. PLEASE RESTORE FIRST THE DATABASE. THANK YOU"); oFrmMsgBox.MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); Maintenance.frmBackupRestoreDB oFrmDB = new Maintenance.frmBackupRestoreDB(); oFrmDB.ShowDialog(); return; } }
private void btnLock_Click(object sender, EventArgs e) { oDatabase = new DataAccess.SystemFunction(); if (!oDatabase.IsDatabaseExits()) { oFrmMsgBox = new Forms.frmMessageBox("DATABASE DOES NOT EXISTS. PLEASE RESTORE FIRST THE DATABASE. THANK YOU"); oFrmMsgBox.MessageType = Forms.frmMessageBox.MESSAGE_TYPE.INFO; oFrmMsgBox.ShowDialog(); Maintenance.frmBackupRestoreDB oFrmDB = new Maintenance.frmBackupRestoreDB(); oFrmDB.ShowDialog(); return; } ClearControls(); Forms.frmLock oFrm = new Forms.frmLock(eVariable.sPassword); oFrm.ShowDialog(); }