public BootStrapper()
{
try
{
DatabaseConnectionObject.connectionObj_Global = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Database Password=aryampa;Data Source=E:\\PROGRAMMING STAFF\\VISUAL STUDIO PROJECTS\\DATABASE\\ShabaFinalDb.mdb");
DatabaseConnectionObject.datasetObject_Global = new DataSet();
DatabaseConnectionObject.connectionObj_Global.Open();
DatabaseConnectionObject databaseConnObj = new DatabaseConnectionObject();
Boolean populationResults = databaseConnObj.populate_DataSet();
if (populationResults)
{
MessageBox.Show("Success!!!!!");
}
//ManageItems ManageItemsForm = new ManageItems();
//ManageItemsForm.ShowDialog();
}
catch (Exception ex) {
MessageBox.Show("Startup Error: [**" + ex.Message.ToString() + "**]", "Startup Error!");
Application.Exit();
}
}
public static void checkDatabaseConnection()
{
if (DatabaseConnectionObject.connectionObj_Global.State == ConnectionState.Closed)
{
DatabaseConnectionObject.connectionObj_Global.Open();
DatabaseConnectionObject conObj = new DatabaseConnectionObject();
if (!conObj.populate_DataSet())
{
throw new Exception("Error Populating Dataset");
}
}
}
private void Login_Load(object sender, EventArgs e)
{
String DatabasePath = Path.GetDirectoryName(Application.ExecutablePath) + "\\ShabaLite.mdb";
OleDbTransaction transactionObj = null;
try
{
DatabaseConnectionObject.connectionObj_Global = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Database Password=aryampa;Data Source=" + DatabasePath);
DatabaseConnectionObject.datasetObject_Global = new DataSet();
DatabaseConnectionObject.connectionObj_Global.Open();
DatabaseConnectionObject databaseConnObj = new DatabaseConnectionObject();
Boolean populationResults = databaseConnObj.populate_DataSet();
if (populationResults)
{
transactionObj = DatabaseConnectionObject.connectionObj_Global.BeginTransaction();
//DataObjectsInitializer SettingsDataObj = new DataObjectsInitializer("Settings", DatabaseConnectionObject.datasetObject_Global, transactionObj,"");
GlobalVariables.CurrentSessionID = new DataTableManager("Settings", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID).Search("Setting Value", "CurrentSessionID", true, false).ToString();
GlobalVariables.FirstBackupPerformed = new DataTableManager("Settings", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID).Search("Setting Value", "FirstBackupPerformed", true, false).ToString();
GlobalVariables.LastBackupDate = new DataTableManager("Settings", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID).Search("Setting Value", "LastBackupDate", true, false).ToString();
GlobalVariables.LastBackupID = new DataTableManager("Settings", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID).Search("Setting Value", "LastBackupID", true, false).ToString();
GlobalVariables.LastBackupSuccess = new DataTableManager("Settings", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID).Search("Setting Value", "LastBackupSuccess", true, false).ToString();
if (GlobalVariables.FirstBackupPerformed == "NO")
{
DialogResult backupNowQestion = MessageBox.Show("Initial Backup of Data has never been performed. Click YES to Perform the Backp Now or NO to Exit the application", "Backup Not Done", MessageBoxButtons.YesNo);
if (backupNowQestion == DialogResult.Yes)// Perform Inital Backup
{
DateTime CurrentDate = DateTime.Now;
DataTableManager DTM_Settings = new DataTableManager("Settings", DatabaseConnectionObject.datasetObject_Global, transactionObj, "");
DataTableManager DTM_SessionData = new DataTableManager("SessionData", DatabaseConnectionObject.datasetObject_Global, transactionObj, "");
Dictionary <String, Object> dicSessionData = new Dictionary <string, object> {
};
dicSessionData.Add("Session ID", new DateTimeUtility().ToEpochFormat(CurrentDate));
dicSessionData.Add("Date Created", new DateTimeUtility().ToEpochFormat(CurrentDate));
dicSessionData.Add("Date Backedup", new DateTimeUtility().ToEpochFormat(CurrentDate));
DTM_SessionData.CreateRow(dicSessionData, dicSessionData["Session ID"].ToString());
Dictionary <String, Object> EditDic = new Dictionary <string, object> {
};
EditDic.Add("Setting Value", "YES");
DTM_Settings.EditRow("FirstBackupPerformed", EditDic);
EditDic.Clear();
EditDic.Add("Setting Value", new DateTimeUtility().ToEpochFormat(CurrentDate));
DTM_Settings.EditRow("LastBackupDate", EditDic);
EditDic.Clear();
EditDic.Add("Setting Value", new DateTimeUtility().ToEpochFormat(CurrentDate));
DTM_Settings.EditRow("CurrentSessionID", EditDic);
EditDic.Clear();
EditDic.Add("Setting Value", new DateTimeUtility().ToEpochFormat(CurrentDate));
DTM_Settings.EditRow("LastBackupID", EditDic);
EditDic.Clear();
EditDic.Add("Setting Value", "YES");
DTM_Settings.EditRow("LastBackupSuccess", EditDic);
transactionObj.Commit();
MessageBox.Show("Success! Intial Backup Performed", "Sucess!");
GlobalVariables.CurrentSessionID = new DataTableManager("Settings", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID).Search("Setting Value", "CurrentSessionID", true, false).ToString();
GlobalVariables.FirstBackupPerformed = new DataTableManager("Settings", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID).Search("Setting Value", "FirstBackupPerformed", true, false).ToString();
GlobalVariables.LastBackupDate = new DataTableManager("Settings", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID).Search("Setting Value", "LastBackupDate", true, false).ToString();
GlobalVariables.LastBackupID = new DataTableManager("Settings", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID).Search("Setting Value", "LastBackupID", true, false).ToString();
GlobalVariables.LastBackupSuccess = new DataTableManager("Settings", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID).Search("Setting Value", "LastBackupSuccess", true, false).ToString();
}
else
{
throw new Exception("Application Will Exit Because Intial Backup Was not Performed.");
}
}
// MessageBox.Show("Success!!!!!");
}
}
catch (Exception ex)
{
if (transactionObj != null)
{
transactionObj.Rollback();
}
MessageBox.Show("Startup Error: [**" + ex.Message.ToString() + "**]", "Startup Error!");
Application.Exit();
}
}
private void btnCreateNew_Click_1(object sender, EventArgs e)
{
OleDbTransaction transactionObj = null;
try
{
if (tbxNewItmName.Text == "")
{
tbxNewItmName.BackColor = Color.Red;
tbxNewItmName.Focus();
throw new Exception("Please Provide a Name");
}
if (tbxNewItmDescrip.Text == "")
{
tbxNewItmDescrip.BackColor = Color.Red;
tbxNewItmDescrip.Focus();
throw new Exception("Please Provide a description for the new Item");
}
if (DatabaseConnectionObject.connectionObj_Global.State == ConnectionState.Closed)
{
DatabaseConnectionObject.connectionObj_Global.Open();
DatabaseConnectionObject conObj = new DatabaseConnectionObject();
if (!conObj.populate_DataSet())
{
throw new Exception("Error Populating Dataset");
}
}
transactionObj = DatabaseConnectionObject.connectionObj_Global.BeginTransaction();
//DataObjectsInitializer NewItemDataObj = new DataObjectsInitializer("Items", DatabaseConnectionObject.datasetObject_Global, transactionObj);
//DataObjectsInitializer IDtableObj = new DataObjectsInitializer("TableIDNumbers", DatabaseConnectionObject.datasetObject_Global, transactionObj);
DataTableManager dbNewItems = new DataTableManager("Items", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID);
DataTableManager dbIDTableNmbers = new DataTableManager("TableIDNumbers", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID);
String CurrentNextID_Nmber = dbIDTableNmbers.Search("Next ID Number", "TabItems", true, false).ToString();
Dictionary <String, Object> Dic2Use = new Dictionary <string, object> {
};
Dic2Use.Add("Next ID Number", (long.Parse(CurrentNextID_Nmber) + 1).ToString());
dbIDTableNmbers.EditRow("TabItems", Dic2Use);
Dic2Use.Clear();
Dic2Use.Add("Item ID", tbxItmID.Text);
Dic2Use.Add("Item Name", tbxNewItmName.Text);
Dic2Use.Add("Description", tbxNewItmDescrip.Text);
dbNewItems.CreateRow(Dic2Use, tbxItmID.Text);
transactionObj.Commit();
MessageBox.Show("Item " + tbxNewItmName.Text + " Successfully Created", "Success");
btnCreateNew.Enabled = false;
btnNewItem.Enabled = true;
}
catch (Exception ex) {
if (transactionObj != null)
{
transactionObj.Rollback();
}
MessageBox.Show("Error Creating New Item" + Environment.NewLine + " Message: " + ex.Message.ToString(), "Error");
}
}
