private void exportDbBtn_Click(object sender, RoutedEventArgs e)
{
try
{
string query = Export.Vendor(this);
SaveQuery.ToDatabase(query);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failed to generate query", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void exportSqlBtn_Click(object sender, RoutedEventArgs e)
{
try
{
string query = Export.Quest(this.Quest);
SaveQuery.ToFile("Quest " + Quest.EntryId, query);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failed to generate query", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void exportSqlBtn_Click(object sender, RoutedEventArgs e)
{
try
{
string query = Export.Vendor(this);
SaveQuery.ToFile("Vendor " + npcTb.Text + ".sql", query);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failed to generate query", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void exportDbBtn_Click(object sender, RoutedEventArgs e)
{
try
{
if (SaveQuery.CheckDuplicateHandleOverride(Export.C.Quest, Quest.EntryId))
{
string query = Export.Quest(this.Quest);
SaveQuery.ToDatabase(query);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failed to generate query", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public IHttpActionResult PostQuery(SaveQuery q)
{
try
{
SaveQuery qs = new SaveQuery();
qs.UserName = "******";
qs.Query_Name = q.Query_Name;
qs.Query = q.Query;
qs.DatabaseName = q.DatabaseName;
qs.insertQuery(qs);
return(Ok("Successfull"));
}
catch (Exception ex)
{
return(BadRequest(ex.ToString()));
}
}
public IHttpActionResult SaveQuery(string UserName)
{
try
{
SaveQuery qss = new SaveQuery();
var qs = qss.GetSave_Query(UserName).ToList();
foreach (var i in qs)
{
Console.WriteLine(i);
}
return(Ok(qs.ToList()));
}
catch (Exception ex)
{
return(BadRequest(ex.ToString()));
}
}
private void exportSqlBtn_Click(object sender, RoutedEventArgs e)
{
try
{
string query = Export.Item(_item);
if (NeedsWeaponExportWindow())
{
OpenWeaponExportWindow(query, WeaponExportWindow.SaveType.File);
}
else
{
SaveQuery.ToFile("Item " + _item.EntryId, query);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failed to generate query", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void exportDbBtn_Click(object sender, RoutedEventArgs e)
{
try
{
string query = Export.Item(_item);
if (NeedsWeaponExportWindow())
{
OpenWeaponExportWindow(query, WeaponExportWindow.SaveType.Database);
}
else if (SaveQuery.CheckDuplicateHandleOverride(Export.C.Item, _item.EntryId))
{
SaveQuery.ToDatabase(query);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failed to generate query", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
/// <summary>
/// Export to chosen output and close window
/// </summary>
private void DoExport()
{
try
{
if (_SaveType == SaveType.Database)
{
SaveQuery.ToDatabase(Query);
}
else
{
SaveQuery.ToFile($"Item {ItemId}", Query);
}
}
catch
{
Logger.Log("WeaponExportWindow: Failed to generate query.", Logger.Status.Error, true);
}
Close();
}
/// <summary>
/// Export to chosen output and close window
/// </summary>
private void DoExport()
{
try
{
if (_SaveType == SaveType.Database)
{
SaveQuery.ToDatabase(Query);
}
else
{
SaveQuery.ToFile($"Item {ItemId}", Query);
}
// Change never show setting if checked
Properties.Settings.Default.disableWeaponCreationNotice = neverShowAgainCb.IsChecked == true;
Properties.Settings.Default.Save();
}
catch
{
Logger.Log("WeaponExportWindow: Failed to generate query.", Logger.Status.Error, true);
}
Close();
}
private void Context_Delete(object sender, RoutedEventArgs e)
{
// Generate delete query
List <string[]> qParts = new List <string[]>();
bool success = true;
switch (SelectedTarget)
{
case Target.Creature:
qParts.Add(new string[2] {
"creature_template", "entry"
});
qParts.Add(new string[2] {
"creature_template_addon", "entry"
});
qParts.Add(new string[2] {
"creature", "id"
});
break;
case Target.Item:
qParts.Add(new string[2] {
"item_template", "entry"
});
break;
case Target.Quest:
qParts.Add(new string[2] {
"quest_template", "ID"
});
qParts.Add(new string[2] {
"quest_addon", "ID"
});
break;
default:
success = false;
MessageBox.Show(
String.Format("Cannot delete a {0} in Trinity Creator.\nPlease delete it manually in the database.", Enum.GetName(typeof(Target), SelectedTarget)),
"Failed to delete", MessageBoxButton.OK, MessageBoxImage.Information);
break;
}
// Confirm & execute
try
{
DataRowView r = dataGrid.SelectedItem as DataRowView; // trigger possible error before asking confirmation
int id = int.Parse(r.Row[0].ToString());
string selectedTargetName = Enum.GetName(typeof(Target), SelectedTarget);
Export.C type;
if (success && MessageBoxResult.Yes == MessageBox.Show(
string.Format("Are you sure you want to delete {0} {1}?", selectedTargetName, id),
"Confirm delete", MessageBoxButton.YesNoCancel, MessageBoxImage.Warning))
{
switch (SelectedTarget)
{
case Target.Creature:
type = Export.C.Creature;
break;
case Target.Quest:
type = Export.C.Quest;
break;
case Target.Item:
type = Export.C.Item;
break;
case Target.GameObject:
type = Export.C.GameObject;
break;
default:
MessageBox.Show($"TrinityCreator is unable to delete {selectedTargetName}s.");
return;
}
// Delete & refresh
SaveQuery.DeleteCreation(type, id);
searchBtn.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
// notify
MessageBox.Show(string.Format("Successfully deleted id {0} from database.", id), "Success", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
catch // Occurs when not selecting a row
{
MessageBox.Show("Failed to delete selected target. Please delete it manually.",
"Failed to delete", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void exportDbBtn_Click(object sender, RoutedEventArgs e)
{
string query = Export.Loot(this);
SaveQuery.ToDatabase(query);
}
private void exportSqlBtn_Click(object sender, RoutedEventArgs e)
{
string query = Export.Loot(this);
SaveQuery.ToFile(((ComboBoxItem)lootTypeCb.SelectedValue).Content.ToString() + " Loot Template " + entryTb.Text + ".sql", query);
}