private void AddButton_Click(object sender, EventArgs e)
{
if (IDTextField.Text != "" && NameTextField.Text != "")
{
using (SqlCommand cmd = new SqlCommand("addBank", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", IDTextField.Text);
cmd.Parameters.AddWithValue("@name", NameTextField.Text);
cmd.Parameters.AddWithValue("@address", AddressTextField.Text);
con.Open();
try
{
cmd.ExecuteNonQuery();
StatusLabel.Text = "Successfully added";
StatusLabel.Show();
IDTextField.Text = "";
NameTextField.Text = "";
AddressTextField.Text = "";
}
catch (Exception x)
{
StatusLabel.Text = "Error!";
StatusLabel.Show();
MessageBox.Show("" + x);
}
con.Close();
bankDatagridview();
}
}
}
private void endInstallation(string reason, bool failed)
{
InstallProgress.Value = 100;
BetaRadio.Hide();
InstallButton.Hide();
UninstallButton.Hide();
UpdateButton.Hide();
ReinjectButton.Hide();
StatusText.Hide();
StatusLabel.Show();
StatusLabel.Text = operation == "UPDATE" ? "Update " + (failed ? "failed" : "complete") : (operation == "UNINSTALL" ? "Unin" : "In") + "stallation " + (failed ? " failed." : "completed!");
StatusLabel.ForeColor = failed ? Color.Red : Color.Lime;
StatusLabel2.Show();
StatusLabel2.Text = reason;
StatusCloseButton.Show();
if (platform != "Linux")
{
OpenFolderButton.Show();
}
}
private void AddButton_Click(object sender, EventArgs e)
{
if (AccNoTextField.Text != "" && TypeTextField.Text != "" && BalTextField.Text != "" && Br_idtextfield.Text != "" && cust_idtextfield.Text != "")
{
using (SqlCommand cmd = new SqlCommand("addAccount", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@accNo", AccNoTextField.Text);
cmd.Parameters.AddWithValue("@type", TypeTextField.Text);
cmd.Parameters.AddWithValue("@bal", BalTextField.Text);
cmd.Parameters.AddWithValue("@br_id", Br_idtextfield.Text);
cmd.Parameters.AddWithValue("@cid", cust_idtextfield.Text);
con.Open();
try
{
cmd.ExecuteNonQuery();
StatusLabel.Text = "Successfully added";
StatusLabel.Show();
AccNoTextField.Text = "";
TypeTextField.Text = "";
BalTextField.Text = "";
cust_idtextfield.Text = "";
Br_idtextfield.Text = "";
}
catch (Exception x)
{
StatusLabel.Text = "Error!";
StatusLabel.Show();
MessageBox.Show("" + x);
}
con.Close();
accountDatagridview();
}
}
else
{
MessageBox.Show("Values cannot be empty!");
}
}
private void AddButton_Click(object sender, EventArgs e)
{
if (CustIDTextField.Text != "" && CustNameTextField.Text != "" && AddressTextField.Text != "")
{
using (SqlCommand cmd = new SqlCommand("addCust", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cid", CustIDTextField.Text);
cmd.Parameters.AddWithValue("@name", CustNameTextField.Text);
cmd.Parameters.AddWithValue("@phone", PhoneTextField.Text);
cmd.Parameters.AddWithValue("@address", AddressTextField.Text);
con.Open();
try
{
cmd.ExecuteNonQuery();
StatusLabel.Text = "Successfully Added";
StatusLabel.Show();
CustIDTextField.Text = "";
CustNameTextField.Text = "";
PhoneTextField.Text = "";
AddressTextField.Text = "";
}
catch (Exception x)
{
StatusLabel.Text = "Error!";
StatusLabel.Show();
MessageBox.Show("" + x);
}
con.Close();
customerDatagridview();
}
}
else
{
MessageBox.Show("Value is empty!");
}
}
private void DeleteButton_Click(object sender, EventArgs e)
{
using (SqlCommand cmd = new SqlCommand("deleteCustomer", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cid", SearchCustIDTextField.Text);
con.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception x)
{
StatusLabel.Text = "Error!";
StatusLabel.Show();
MessageBox.Show("" + x);
}
con.Close();
customerDatagridview();
}
}
private void AddButton_Click(object sender, EventArgs e)
{
if (LoanNoTextField.Text != "" && AmtTextField.Text != "" && BranchNoTextfield.Text != "" && TypeTextField.Text != "" && CustIdTextField.Text != "")
{
using (SqlCommand cmd = new SqlCommand("addLoan", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@lid", LoanNoTextField.Text);
cmd.Parameters.AddWithValue("@amt", AmtTextField.Text);
cmd.Parameters.AddWithValue("@bid", BranchNoTextfield.Text);
cmd.Parameters.AddWithValue("@type", TypeTextField.Text);
cmd.Parameters.AddWithValue("@cid", CustIdTextField.Text);
con.Open();
try
{
cmd.ExecuteNonQuery();
StatusLabel.Text = "Successfully added";
StatusLabel.Show();
LoanNoTextField.Text = "";
AmtTextField.Text = "";
BranchNoTextfield.Text = "";
TypeTextField.Text = "";
CustIdTextField.Text = "";
}
catch (Exception x)
{
StatusLabel.Text = "Error!";
StatusLabel.Show();
MessageBox.Show("" + x);
}
con.Close();
loanDatagridview();
}
}
}
private void button1_MouseHover(object sender, EventArgs e)
{
StatusLabel.Text = "Log-In for Airport's Employees";
StatusLabel.Show();
}
private void button3_MouseHover(object sender, EventArgs e)
{
StatusLabel.Text = "Log-In for Government Employees";
StatusLabel.Show();
}
private void button4_MouseHover(object sender, EventArgs e)
{
StatusLabel.Text = "Check your Booking or Search for Flights";
StatusLabel.Show();
}
