private void btnExpenditure_Click(object sender, EventArgs e)
{
frmExpenditure newForm = new frmExpenditure();
newForm.Show();
this.Hide();
}
private void btnCancel_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Are you sure you want to cancel? No changes will be saved.", "Confirmation", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
frmExpenditure newForm = new frmExpenditure();
//newForm.clearDataGridView();
//newForm.loadDataGridView();
newForm.Show();
this.Hide();
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtAmount.Text) || string.IsNullOrWhiteSpace(txtDescription.Text))
{
MessageBox.Show("One or more fields are left empty. Please fill them up!", "Error");
return;
}
double amount = 0.0;
bool convertAmount = double.TryParse(txtAmount.Text, out amount);
if (convertAmount == false)
{
MessageBox.Show("Please enter numbers in the Amount field!", "Error");
return;
}
amount = Math.Round(amount, 2);
string date = dtpDate.Value.ToShortDateString();
string description = txtDescription.Text;
OleDbCommand cmd = new OleDbCommand();
OleDbConnection cn = new OleDbConnection();
cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Restaurant.accdb; Persist Security Info=False;";
cmd.Connection = cn;
bool successful = false;
try
{
//If loaded then UPDATE, if not loaded then INSERT
if (loaded == true)
{
string q = "UPDATE Cost SET costDesc='" + description + "', totalCost=" + amount + ", costDate='" + date + "' WHERE costID=" + costID;
cmd.CommandText = q;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
MessageBox.Show("Record successfully edited! Returning to previous screen!", "Successful");
successful = true;
}
else
{
string p = "SELECT Max(costID) FROM Cost";
cmd.CommandText = p;
cn.Open();
int maxId = 1;
if (cmd.ExecuteScalar() != DBNull.Value)
{
maxId = Convert.ToInt32(cmd.ExecuteScalar());
maxId = maxId + 1;
}
cn.Close();
string q = "INSERT INTO Cost(costID, costDesc, totalCost, costDate)" +
" VALUES(" + maxId + ",'" + description + "'," + amount + ",'" + date + "')";
cmd.CommandText = q;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
MessageBox.Show("Record successfully added! Returning to previous screen!", "Successful");
successful = true;
}
}
catch (Exception ex)
{
cn.Close();
MessageBox.Show("Oops... Something went wrong. Please contact the admin to make sure everything's all right!", "Sorry");
}
if (successful == true)
{
frmExpenditure newForm = new frmExpenditure();
newForm.Show();
this.Hide();
}
}
