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();
}
