private void upGen()
{
sqLite = new SQLiteConnection(dbConString);
if (MessageBox.Show("Update Selected Column?", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.No)
{
MessageBox.Show("Updation Process Canceled");
}
else
{
try
{
sqLite.Open();
SQLiteCommand createCommand = new SQLiteCommand(Query, sqLite);
createCommand.ExecuteNonQuery();
MessageBox.Show("Record Updated");
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
ShowEvents sh = new ShowEvents();
sqLite.Close();
this.Hide();
sh.Show();
}
}
}
private void showEvent_Click(object sender, RoutedEventArgs e)
{
ShowEvents sh = new ShowEvents();
this.Hide();
sh.Show();
}
private void subButton_Click(object sender, RoutedEventArgs e)
{
sqLite = new SQLiteConnection(dbConString);
if (prizeBox.Text.Equals(null) || nameBox.Text.Equals(null) || courseBox.Equals(null) || rollBox.Equals(null) || semBox.Equals(null) || collBox.Equals(null))
{
MessageBox.Show("Fill all the details");
}
else
{
if (MessageBox.Show("Update Prize?", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.No)
{
MessageBox.Show("Updation Process Canceled");
}
else
{
apTable = selectedTable + "_approval";
try
{
sqLite.Open();
Query = "UPDATE '" + selectedTable + "' SET Prize = '" + prizeBox.Text + "' WHERE EID='" + this.SBox.Text + "' OR NAME = '" + this.SBox.Text + "'";
SQLiteCommand createCommand = new SQLiteCommand(Query, sqLite);
createCommand.ExecuteNonQuery();
Query = "UPDATE '" + apTable + "' SET Prize = '" + prizeBox.Text + "' WHERE EID='" + this.SBox.Text + "' OR NAME = '" + this.SBox.Text + "'";
createCommand = new SQLiteCommand(Query, sqLite);
createCommand.ExecuteNonQuery();
MessageBox.Show("Record Updated");
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
ShowEvents sh = new ShowEvents();
sqLite.Close();
this.Hide();
sh.Show();
}
}
}
}
