private void cbxCategory_DropDownClosed(object sender, EventArgs e)
{
if (cbxCategory.SelectedItem.ToString() == "<Select Category>")
{
DataObjectsInitializer.checkDatabaseConnection();
DataRow IDRow = DatabaseConnectionObject.datasetObject_Global.Tables["TableIDNmbers"].Rows.Find("TabExp");
lblExpID.Text = IDRow["Table Prefix"].ToString() + IDRow["Next ID Number"].ToString();
//cbxCategory.SelectedIndex = 0;
tbxAmount.Text = "0";
tbxAmount.BackColor = Color.Black;
tbxDescription.Text = "";
btnSaveExp.Enabled = false;
tbxDescription.Enabled = false;
tbxAmount.Enabled = false;
}
else
{
DataObjectsInitializer.checkDatabaseConnection();
DataRow IDRow = DatabaseConnectionObject.datasetObject_Global.Tables["TableIDNumbers"].Rows.Find("TabExp");
lblExpID.Text = IDRow["Table Prefix"].ToString() + IDRow["Next ID Number"].ToString();
//cbxCategory.SelectedIndex = 0;
tbxAmount.Text = "0";
tbxAmount.BackColor = Color.Black;
tbxDescription.Text = "";
btnSaveExp.Enabled = false;
tbxDescription.Enabled = true;
tbxAmount.Enabled = true;
}
}
private void btnSaveExp_Click(object sender, EventArgs e)
{
OleDbTransaction oledbTrans = null;
try
{
oledbTrans = DatabaseConnectionObject.connectionObj_Global.BeginTransaction();
Dictionary <String, Object> Dic2Use = new Dictionary <string, object> {
};
Dic2Use.Add("ExpenseID", lblExpID.Text);
Dic2Use.Add("UserID", GlobalVariables.CurrentSessionID);
Dic2Use.Add("Date", dtPickerExpense.Value.ToLocalTime().ToString());
Dic2Use.Add("Expense Category", cbxCategory.SelectedItem.ToString());
Dic2Use.Add("Description", tbxDescription.Text);
Dic2Use.Add("Amount", tbxAmount.Text);
new DataTableManager("Expenses", DatabaseConnectionObject.datasetObject_Global, oledbTrans, GlobalVariables.CurrentSessionID).CreateRow(Dic2Use, Dic2Use["ExpenseID"].ToString());
Dic2Use.Clear();
String NextIDNmber = DatabaseConnectionObject.datasetObject_Global.Tables["TableIDNumbers"].Rows.Find("TabExp")["Next ID Number"].ToString();
NextIDNmber = (long.Parse(NextIDNmber) + 1).ToString();
Dic2Use.Clear();
Dic2Use.Add("Next ID Number", NextIDNmber);
new DataTableManager("TableIDNumbers", DatabaseConnectionObject.datasetObject_Global, oledbTrans, GlobalVariables.CurrentSessionID).EditRow("TabExp", Dic2Use);
oledbTrans.Commit();
MessageBox.Show(lblExpID.Text + " Expense Sucessfully saved", "Sucess");
DataObjectsInitializer.checkDatabaseConnection();
DataRow IDRow = DatabaseConnectionObject.datasetObject_Global.Tables["TableIDNumbers"].Rows.Find("TabExp");
lblExpID.Text = IDRow["Table Prefix"].ToString() + IDRow["Next ID Number"].ToString();
cbxCategory.SelectedIndex = 0;
tbxAmount.Text = "0";
tbxDescription.Text = "";
btnSaveExp.Enabled = false;
}
catch (Exception ex) {
if (oledbTrans != null)
{
oledbTrans.Rollback();
}
MessageBox.Show("Reason: " + ex.Message.ToString(), "Error Saving Expenses");
}
}
private void BackupAndRestore_Load(object sender, EventArgs e)
{
try
{
DataObjectsInitializer.checkDatabaseConnection();
lblCurrBackpSession.Text = "Current Session ID: " + GlobalVariables.CurrentSessionID;
lblTotalEntries.Text = "Total Backup Rows: " + DatabaseConnectionObject.datasetObject_Global.Tables["BackupSessions"].Rows.Count.ToString();
if (DatabaseConnectionObject.datasetObject_Global.Tables["BackupSessions"].Rows.Count == 0)
{
btnBackup.Enabled = false;
}
}
catch (Exception ex) {
MessageBox.Show("Reason: " + ex.Message.ToString(), "Error Initalising Backup");
this.Close();
}
}
private void btnDelete_Click_1(object sender, EventArgs e)
{
OleDbTransaction transactionObj = null;
try
{
DialogResult result = MessageBox.Show("Are You Sure you Want to Delete " + lstBxItmID.SelectedItem.ToString() + " ?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (result == System.Windows.Forms.DialogResult.No)
{
}
else if (result == System.Windows.Forms.DialogResult.Yes)
{
transactionObj = DatabaseConnectionObject.connectionObj_Global.BeginTransaction();
DataObjectsInitializer ItemsTableObj = new DataObjectsInitializer("Items", DatabaseConnectionObject.datasetObject_Global, transactionObj);
DataObjectsInitializer TableIDTableObj = new DataObjectsInitializer("TableIDNumbers", DatabaseConnectionObject.datasetObject_Global, transactionObj);
//DataRow Row2Delete = DatabaseConnectionObject.datasetObject_Global.Tables["Items"].Rows.Find(DeleteDictionary[lstBxItmID.SelectedItem.ToString()]);
new DataTableManager("Items", DatabaseConnectionObject.datasetObject_Global, transactionObj, GlobalVariables.CurrentSessionID).Delete(DeleteDictionary[lstBxItmID.SelectedItem.ToString()]);
transactionObj.Commit();
MessageBox.Show("Item - " + lstBxItmID.SelectedItem.ToString() + " successfully deleted", "Success");
DeleteList.Remove(lstBxItmID.SelectedItem.ToString());
tbxItmID.Text = "";
btnDelete.Enabled = false;
lstBxItmID.DataSource = DeleteList;
}
}
catch (Exception ex) {
if (transactionObj != null)
{
transactionObj.Rollback();
}
MessageBox.Show("Error Deleting Item : " + ex.Message.ToString(), "Error Deleting Item");
}
}
private void ManageExpenses_Load(object sender, EventArgs e)
{
try{
DataObjectsInitializer.checkDatabaseConnection();
DataRow IDRow = DatabaseConnectionObject.datasetObject_Global.Tables["TableIDNumbers"].Rows.Find("TabExp");
lblExpID.Text = IDRow["Table Prefix"].ToString() + IDRow["Next ID Number"].ToString();
cbxCategory.SelectedIndex = 0;
tbxAmount.Text = "0";
tbxAmount.BackColor = Color.Black;
tbxDescription.Text = "";
btnSaveExp.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show("Reason: " + ex.Message.ToString(), "Error Initalising Expense Module");
this.Close();
}
}
public Boolean populate_DataSet()
{
List <string> listOfTableNames = new List <string> {
"Items", "DebtDetails", "Debtors", "Users", "Sales", "Purchases", "TableIDNumbers", "Units", "Settings", "SessionData", "BackUpSessions", "Expenses"
};
datasetObject_Global.Clear();
foreach (string Table_Name in listOfTableNames)
{
DataObjectsInitializer DataObject = new DataObjectsInitializer(Table_Name, datasetObject_Global, connectionObj_Global);
// MessageBox.Show("Dataset Now has : " + datasetObject_Global.Tables.Count.ToString() + " tables!!");
}
return(true);
}
public DataTableManager(String TableName, DataSet datasetObject, OleDbTransaction transacttionObj, String BackupSessionID)
{
dbObject = new DataObjectsInitializer(TableName, datasetObject, transacttionObj, BackupSessionID);
dbSessionObject = new DataObjectsInitializer("BackUpSessions", datasetObject, transacttionObj, BackupSessionID);
TableNam = TableName;
}