private void btnSave_Click(object sender, RoutedEventArgs e)
{
string Query = "INSERT INTO sales_agent_master VALUES ('" + this.agnt_nameTextBox.Text + "', '" + this.agnt_addrTextBox.Text + "', '" + this.agnt_phneTextBox.Text + "'); ";
SqlCommand cmdDataBase = new SqlCommand(Query, conDataBase);
SqlDataReader myReader;
try
{
conDataBase.Open();
myReader = cmdDataBase.ExecuteReader();
MessageBox.Show("Saved");
while (myReader.Read())
{
adpt.Update(dt);
con.Close();
Fillprod_masterDataGrid();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//reload window after add to show details
var salesAgentWindow = new SalesAgentWindow();
salesAgentWindow.Show();
Close();
}
private void ListViewItem_Sales_Selected(object sender, RoutedEventArgs e)
{
var salesAgentWindow = new SalesAgentWindow();
salesAgentWindow.Show();
Close();
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
if (agnt_nameTextBox.Text != "")
{
con = new SqlConnection(connectionString);
con.Open();
cmd = new SqlCommand("DELETE FROM [sales_agent_master] WHERE [agnt_name] = '" + agnt_nameTextBox.Text.ToString() + "'", con);
reader = cmd.ExecuteReader();
if (reader.Read())
{
MessageBox.Show("success");
var salesAgentWindow = new SalesAgentWindow();
salesAgentWindow.Show();
Close();
}
else
{
//reload window after add to show details
//ALSO code is completely busted, datagrid panics for some reason and code identifies the delete as failing, hence why
//this is in the else portion of the statement
//but it doesnt actually fail (the datagrid wigs out before it redirects to the view tab)
var salesAgentWindow = new SalesAgentWindow();
salesAgentWindow.Show();
Close();
}
reader.Close();
con.Close();
}
else
{
MessageBox.Show("Please Select Record to Delete");
}
}