private void SubmitEdits_Click(object sender, RoutedEventArgs e)
{
if (!string.IsNullOrWhiteSpace(EditName.Text) && !string.IsNullOrWhiteSpace(EditDescription.Text) && !string.IsNullOrWhiteSpace(EditPrice.Text) && !string.IsNullOrWhiteSpace(EditQuantity.Text))
{
try
{
connection.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "update items set ITEM_NAME=@ItemName,ITEM_PRICE=@ItemPrice,ITEM_DESCRIPTION=@ItemDescription,ITEM_QUANTATY=@ItemQuantity where ITEM_ID=@ItemId";
cmd.Parameters.AddWithValue("@ItemName", EditName.Text);
cmd.Parameters.AddWithValue("@ItemPrice", EditPrice.Text);
cmd.Parameters.AddWithValue("@ItemDescription", EditDescription.Text);
cmd.Parameters.AddWithValue("@ItemQuantity", EditQuantity.Text);
cmd.Parameters.AddWithValue("@ItemId", EditId.Text);
cmd.Connection = connection;
cmd.ExecuteNonQuery();
MySqlCommand Com = new MySqlCommand("Select * from items ", connection);
MySqlDataAdapter adp = new MySqlDataAdapter(Com);
DataSet ds = new DataSet();
adp.Fill(ds, "LoadDataBinding");
EditDataGrid.DataContext = ds;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
connection.Close();
MessageBox.Show("Successfully updated", "Success");
EditName.Clear();
EditDescription.Clear();
EditPrice.Clear();
EditQuantity.Clear();
EditId.Clear();
}
}
else
{
MessageBox.Show("Cannot Edit Empty Row ", "ERROR");
}
}
private void DeleteEdits_Click(object sender, RoutedEventArgs e)
{
if (!string.IsNullOrWhiteSpace(EditName.Text) && !string.IsNullOrWhiteSpace(EditDescription.Text) && !string.IsNullOrWhiteSpace(EditPrice.Text) && !string.IsNullOrWhiteSpace(EditQuantity.Text))
{
MessageBoxResult choice = MessageBox.Show("delete selected item ?", "confirmation", MessageBoxButton.YesNo);
if (choice == MessageBoxResult.Yes)
{
try
{
connection.Open();
MySqlCommand cmd = new MySqlCommand("delete from items where ITEM_ID='" + int.Parse(EditId.Text) + "'", connection);
cmd.ExecuteNonQuery();
MySqlCommand Com = new MySqlCommand("Select * from items ", connection);
MySqlDataAdapter adp = new MySqlDataAdapter(Com);
DataSet ds = new DataSet();
adp.Fill(ds, "LoadDataBinding");
EditDataGrid.DataContext = ds;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
connection.Close();
EditId.Clear();
EditName.Clear();
EditQuantity.Clear();
EditPrice.Clear();
EditDescription.Clear();
MessageBox.Show("item deleted", "confirmed");
}
}
}
else
{
MessageBox.Show("Select a row to delete", "ERROR");
}
}
private void RefreshEverything()
{
// ----- Refresh most of the fields on the three main tabs.
string sqlText;
SqlConnection linkToDB;
SqlDataReader stateReader;
// ----- Initialize.
ActiveStateID = -1L;
// ----- Open a database connection.
linkToDB = General.OpenConnection();
if (linkToDB == null)
{
return;
}
// ----- See if a custom state already exists.
// ----- Adjust the display.
if (ActiveStateID == -1L)
{
// ----- Set up the display for a new entry.
AddName.Enabled = true;
AddAbbreviation.Enabled = true;
ActAdd.Enabled = true;
EditID.Text = "N/A";
EditName.Clear();
EditAbbreviation.Clear();
EditName.Enabled = false;
EditAbbreviation.Enabled = false;
ActEdit.Enabled = false;
DeleteID.Text = "N/A";
DeleteName.Text = "N/A";
DeleteAbbreviation.Text = "N/A";
ActDelete.Enabled = false;
}
else
{
// ----- Set up the display for an existing item.
AddName.Enabled = false;
AddAbbreviation.Enabled = false;
ActAdd.Enabled = false;
EditID.Text = ActiveStateID.ToString();
EditName.Text = AddName.Text;
EditAbbreviation.Text = AddAbbreviation.Text;
EditName.Enabled = true;
EditAbbreviation.Enabled = true;
ActEdit.Enabled = true;
DeleteID.Text = ActiveStateID.ToString();
DeleteName.Text = AddName.Text;
DeleteAbbreviation.Text = AddAbbreviation.Text;
ActDelete.Enabled = true;
}
// ----- Refresh the SQL statement previews.
RefreshAddPreview();
RefreshEditPreview();
RefreshDeletePreview();
}
private void RefreshEverything()
{
// ----- Refresh most of the fields on the three main tabs.
string sqlText;
SqlConnection linkToDB;
SqlDataReader stateReader;
// ----- Initialize.
ActiveStateID = -1L;
// ----- Open a database connection.
linkToDB = General.OpenConnection();
if (linkToDB == null)
{
return;
}
// ----- See if a custom state already exists.
sqlText = "SELECT * FROM StateRegion WHERE RegionType = 99";
stateReader = General.OpenReader(sqlText, linkToDB);
if ((stateReader != null) && (stateReader.HasRows == true))
{
// ----- Existing custom state record.
stateReader.Read();
ActiveStateID = (long)(int)stateReader["ID"];
AddName.Text = (string)stateReader["FullName"];
AddAbbreviation.Text = (string)stateReader["Abbreviation"];
}
else
{
// ----- No custom state record.
AddName.Clear();
AddAbbreviation.Clear();
}
if (stateReader != null)
{
stateReader.Close();
}
// ----- Adjust the display.
if (ActiveStateID == -1L)
{
// ----- Set up the display for a new entry.
AddName.Enabled = true;
AddAbbreviation.Enabled = true;
ActAdd.Enabled = true;
EditID.Text = "N/A";
EditName.Clear();
EditAbbreviation.Clear();
EditName.Enabled = false;
EditAbbreviation.Enabled = false;
ActEdit.Enabled = false;
DeleteID.Text = "N/A";
DeleteName.Text = "N/A";
DeleteAbbreviation.Text = "N/A";
ActDelete.Enabled = false;
}
else
{
// ----- Set up the display for an existing item.
AddName.Enabled = false;
AddAbbreviation.Enabled = false;
ActAdd.Enabled = false;
EditID.Text = ActiveStateID.ToString();
EditName.Text = AddName.Text;
EditAbbreviation.Text = AddAbbreviation.Text;
EditName.Enabled = true;
EditAbbreviation.Enabled = true;
ActEdit.Enabled = true;
DeleteID.Text = ActiveStateID.ToString();
DeleteName.Text = AddName.Text;
DeleteAbbreviation.Text = AddAbbreviation.Text;
ActDelete.Enabled = true;
}
// ----- Refresh the SQL statement previews.
RefreshAddPreview();
RefreshEditPreview();
RefreshDeletePreview();
}
