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
}
}
