public Generator()
{
InitializeComponent();
PriorQueryCombo.DropDownClosed += PriorQueryComboOnDropDownClosed;
if (ScriptResults != null && ScriptResults.Any())
{
PriorQueryCombo.ItemsSource = ScriptResults.OrderByDescending(r => r.ScriptTime);
var result = ScriptResults.OrderByDescending(r => r.ScriptTime).FirstOrDefault();
if (result != null)
{
PriorQueryCombo.SelectedItem = result;
SqlEditor.Text = result.InputScript;
SqlOutput.Text = result.OutputSql;
CSharpOutput.Text = result.OutputCSharp;
ServerCombo.Text = result.Server;
}
}
else
{
SqlEditor.Text = "SELECT TOP 100 * FROM Nutshell.dbo.Customer -- Example Script";
}
}
private void ClearHistory_Click(object sender, RoutedEventArgs e)
{
ScriptResults.Clear();
SqlGenerator.Properties.Settings.Default.Save();
PriorQueryCombo.ItemsSource = null;
}
private static void TestScript(IScript script, string artist, string album)
{
ScriptResults scriptResults = new ScriptResults();
Thread searchThread = new Thread(new ThreadStart(delegate
{
try
{
script.Search(artist, album, scriptResults);
}
catch (ThreadAbortException)
{
throw;
}
catch (Exception e)
{
Console.WriteLine("FAILED: Script {0} threw an exception while searching: {1}", script.Name, e.Message);
return; //Skip this script, try the next
}
}));
searchThread.Start();
searchThread.Join();
if (!scriptResults.ResultFound)
{
Console.WriteLine("FAILED: Script {0} produced no results for {1} / {2}", script.Name, artist, album);
}
}
//Input se utiliza en las páginas de keypad para ingreso de numeros
public static ScriptResults Input(ref ReceptionPointState rpState, string data, string source)
{
ScriptResults rs = new ScriptResults();
Customer oCustomer = null;
if (rpState.CurrentPageKey == "CelPag3")
{
try
{
oCustomer = Customer.Get(data, 0);
rpState.SessionParameters.Set("IDCliente", oCustomer.Id.ToString());
rpState.SessionParameters.Set("FirstName", oCustomer.FirstName.ToString());
rpState.SessionParameters.Set("LastName", oCustomer.LastName.ToString());
rpState.SessionParameters.Set("Texto", "SI"); //variable para servicio condicional - muestra boton
rpState.GotoPage("CelPag4", _universalTimeout);
}
catch (Exception ex)
{
rpState.SessionParameters.Set("Texto","NO");
SaveLog("Kiosko1Cel", "Error en busqueda de cliente: " + ex.Message + " datavalue: " + data, EventLogEntryType.Error);
}
}
else if (rpState.CurrentPageKey == "CelPag8")
{
rpState.SessionParameters.Set("Telefono", data);
rpState.SessionParameters.Set("Saldo", DateTime.Now.ToString());
rpState.GotoPage("CelPag9", _universalTimeout);
}
return rs;
}
private async void Button_Click(object sender, RoutedEventArgs e)
{
try
{
SqlOutput.Text = "Generating Script...";
CSharpOutput.Text = "Generating Script...";
_CodeGenerator = new CodeGenerator(ConnectionString);
await _CodeGenerator.GenerateQuerySchema(Query);
var sqlResult = await _CodeGenerator.GetSqlScript();
var cSharpResult = await _CodeGenerator.GetPocoScript();
SqlOutput.Text = sqlResult;
CSharpOutput.Text = cSharpResult;
if (ScriptResults == null)
{
ScriptResults = new ScriptResultList();
}
var lastResult = ScriptResults.FirstOrDefault(r => r.InputScript == Query);
ScriptResult newResult = new ScriptResult();
// If there already is a matching result, update the run time
if (lastResult != null)
{
lastResult.ScriptTime = DateTime.Now;
}
else
{
newResult.Server = Server;
newResult.InputScript = Query;
newResult.OutputCSharp = cSharpResult;
newResult.OutputSql = sqlResult;
newResult.ScriptTime = DateTime.Now;
ScriptResults.CullList(newResult);
ScriptResults.Add(newResult);
}
PriorQueryCombo.ItemsSource = ScriptResults.OrderByDescending(r => r.ScriptTime);
PriorQueryCombo.Text = (lastResult == null) ? newResult.ToString() : lastResult.ToString();
SqlGenerator.Properties.Settings.Default.Save();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
SqlOutput.Text = string.Format("/*{0}*/", ex.Message);
CSharpOutput.Text = string.Format("/*{0}*/", ex.Message);
}
}
private void BuildDynamicData(PythonModel pe, OrganizationMember om)
{
pe.DictionaryAdd("PeopleId", PeopleId ?? 0);
pe.DictionaryAdd("OrganizationId", om.OrganizationId);
var notifyIds = DbUtil.Db.StaffPeopleForOrg(om.OrganizationId);
pe.DictionaryAdd("OnlineNotifyId", notifyIds[0].PeopleId);
pe.DictionaryAdd("OnlineNotifyEmail", notifyIds[0].EmailAddress);
pe.DictionaryAdd("OnlineNotifyName", notifyIds[0].Name);
var props = typeof(OnlineRegPersonModel).GetProperties(BindingFlags.Public | BindingFlags.Instance);
foreach (var pi in props.Where(vv => vv.CanRead && vv.CanWrite))
{
switch (pi.Name)
{
case "ExtraQuestion":
AddQuestions(pe);
break;
case "Text":
AddText(pe);
break;
case "YesNoQuestion":
AddYesNo(pe);
break;
case "option":
AddDropDownOptions(pe);
break;
case "Checkbox":
AddCheckboxes(pe);
break;
case "MenuItem":
AddMenuItems(pe);
break;
case "ScriptResults":
if (ScriptResults.HasValue())
{
pe.DictionaryAdd(pi.Name, ScriptResults);
}
break;
case "memberus":
if (memberus)
{
pe.DictionaryAdd("MemberUs", memberus);
}
break;
case "otherchurch":
if (otherchurch)
{
pe.DictionaryAdd("OtherChurch", otherchurch);
}
break;
case "LoggedIn":
pe.DictionaryAdd(pi.Name, LoggedIn);
break;
case "FirstName":
pe.DictionaryAdd(pi.Name, FirstName);
break;
case "LastName":
pe.DictionaryAdd(pi.Name, LastName);
break;
}
}
}