private void btnDelete_Click(object sender, EventArgs e)
{
try
{
string connectionString = page.ConnString();
SqlConnection openConnection = new SqlConnection(connectionString);
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet dataset = new DataSet();
adapter.SelectCommand = new SqlCommand();
adapter.SelectCommand.Connection = openConnection;
adapter.SelectCommand.CommandText = "Delete from OWNER where OWNER_ID = '" + txtOwnerID.Text + "';";
openConnection.Open();
adapter.Fill(dataset, "Owner");
adapter.Dispose();
dataset.Dispose();
openConnection.Close();
this.Hide();
Delete delForm = new Delete(page);
delForm.Show();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private bool updateWithSQL(string updateStatement)
{
bool updateSuccess;
string connectionString = loginForm.ConnString();
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
try
{
SqlCommand command = new SqlCommand(); //Create a new command.
command.CommandText = updateStatement; //Set the SQL to execute.
command.Connection = sqlConnection; //Connect to the database.
command.ExecuteNonQuery();
updateSuccess = true;
}
catch (Exception ex)
{
MessageBox.Show("Error updating database. Exception details: \n\n" + ex.Message);
updateSuccess = false;
}
sqlConnection.Close();
return(updateSuccess);
}
private void btnRefresh_Click(object sender, EventArgs e)
{
string searchConnectionString = frmLogin.ConnString();
SqlConnection openConnection = new SqlConnection(searchConnectionString);
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet dataset = new DataSet();
adapter.SelectCommand = new SqlCommand();
adapter.SelectCommand.Connection = openConnection;
openConnection.Open();
if (this.rbBuilding.Checked)
{
adapter.SelectCommand.CommandText = "select * from BUILDING;";
adapter.Fill(dataset, "BUILDING");
deleteGrid.AutoGenerateColumns = true;
deleteGrid.DataSource = dataset;
deleteGrid.DataMember = "BUILDING";
}
else if (this.rbCensus.Checked)
{
adapter.SelectCommand.CommandText = "select * from CENSUS_TRACT;";
adapter.Fill(dataset, "CENSUS TRACT");
deleteGrid.AutoGenerateColumns = true;
deleteGrid.DataSource = dataset;
deleteGrid.DataMember = "CENSUS TRACT";
}
else if (this.rbMortgager.Checked)
{
adapter.SelectCommand.CommandText = "select * from MORTGAGER;";
adapter.Fill(dataset, "MORTGAGER");
deleteGrid.AutoGenerateColumns = true;
deleteGrid.DataSource = dataset;
deleteGrid.DataMember = "MORTGAGER";
}
else if (this.rbOwner.Checked)
{
adapter.SelectCommand.CommandText = "select * from OWNER;";
adapter.Fill(dataset, "OWNER");
deleteGrid.AutoGenerateColumns = true;
deleteGrid.DataSource = dataset;
deleteGrid.DataMember = "OWNER";
}
else if (this.rbUnit.Checked)
{
adapter.SelectCommand.CommandText = "select * from UNIT;";
adapter.Fill(dataset, "UNIT");
deleteGrid.AutoGenerateColumns = true;
deleteGrid.DataSource = dataset;
deleteGrid.DataMember = "UNIT";
}
else
{
MessageBox.Show("Please select an option");
}
openConnection.Close();
adapter.Dispose();
dataset.Dispose();
}
public bool check_BuildingID()
{
string serachConnectionString;
SqlConnection openConnection;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
DataSet newDataSet = new DataSet();
serachConnectionString = frmLogin.ConnString();
openConnection = new SqlConnection(serachConnectionString);
bool Building_ID_exists = true;
try
{
SqlCommand newCommand = new SqlCommand("SELECT c.Building_ID FROM Building c WHERE c.Building_ID= '" + txt_buildingID.Text + "'", openConnection);
sqlDataAdapter.SelectCommand = newCommand;
sqlDataAdapter.Fill(newDataSet, "Building_ID_exits");
if (newDataSet.Tables[0].Rows.Count > 0)
{
int db_Building_ID = int.Parse(newDataSet.Tables[0].Rows[0][0].ToString());
Building_ID_exists = true;
}
else
{
Building_ID_exists = false;
}
sqlDataAdapter.Dispose();
newDataSet.Dispose();
openConnection.Close();
}
catch (SqlException error)
{
MessageBox.Show(error.Message);
sqlDataAdapter.Dispose();
newDataSet.Dispose();
openConnection.Close();
Building_ID_exists = false;
}
return(Building_ID_exists);
}
public int fetch_Mortgager_ID()
{
int Mortgager_ID = 0;
string serachConnectionString;
SqlConnection openConnection;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
DataSet newDataSet = new DataSet();
serachConnectionString = frmLogin.ConnString();
openConnection = new SqlConnection(serachConnectionString);
SqlCommand newCommand = new SqlCommand("SELECT MAX(c.Mortgager_ID) FROM Mortgager C", openConnection);
sqlDataAdapter.SelectCommand = newCommand;
sqlDataAdapter.Fill(newDataSet, "max_Mortgager_ID");
Mortgager_ID = 1 + int.Parse(newDataSet.Tables[0].Rows[0][0].ToString());
sqlDataAdapter.Dispose();
newDataSet.Dispose();
openConnection.Close();
return(Mortgager_ID);
}
public int fetch_buildingID()
{
int buildingID = 0;
string serachConnectionString;
SqlConnection openConnection;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
DataSet newDataSet = new DataSet();
serachConnectionString = frmLogin.ConnString();
openConnection = new SqlConnection(serachConnectionString);
SqlCommand newCommand = new SqlCommand("SELECT MAX(b.Building_ID) FROM Building b", openConnection);
sqlDataAdapter.SelectCommand = newCommand;
sqlDataAdapter.Fill(newDataSet, "Max_Building_ID");
buildingID = 1 + int.Parse(newDataSet.Tables[0].Rows[0][0].ToString());
sqlDataAdapter.Dispose();
newDataSet.Dispose();
openConnection.Close();
return(buildingID);
}