static void EventCounts(object sender, FbRemoteEventEventArgs args)
{
string ConnectionString = "User ID=" + userdb + ";Password="******";Database=c:/trilogis/trilogis.fb20; " + "DataSource=localhost;Charset=NONE;";
FbConnection addDetailsConnection = new FbConnection(ConnectionString);
addDetailsConnection.Open();
SpeechSynthesizer synthesizer = new SpeechSynthesizer();
synthesizer.SetOutputToDefaultAudioDevice();
synthesizer.SelectVoiceByHints(VoiceGender.Female);
synthesizer.Volume = 100;
synthesizer.Rate = 0;
using (FbCommand cmd = new FbCommand("SELECT CLIENTEID FROM ULTIMOPRONTO WHERE ID = (SELECT MAX(ID) FROM ULTIMOPRONTO)", addDetailsConnection))
{
string clienti = cmd.ExecuteScalar().ToString();
if (clienti == "")
{
FbCommand scontrino = new FbCommand("SELECT LOTTONUMERO FROM LOTTI WHERE LOTTOID =(SELECT LOTTOID FROM ULTIMOPRONTO WHERE ID = (SELECT MAX(ID) FROM ULTIMOPRONTO))", addDetailsConnection);
int n = Convert.ToInt32(scontrino.ExecuteScalar());
//MessageBox.Show(n.ToString());
synthesizer.Speak("Scontrino " + n.ToString());
}
else
{
FbCommand nomecliente = new FbCommand("SELECT CLIENTERAGIONESOCIALEUP FROM CLIENTI WHERE CLIENTEID =(SELECT CLIENTEID FROM ULTIMOPRONTO WHERE ID = (SELECT MAX(ID) FROM ULTIMOPRONTO))", addDetailsConnection);
string clientenome = nomecliente.ExecuteScalar().ToString();
//MessageBox.Show(clientenome);
synthesizer.Speak(clientenome);
}
}
}
private void fbEvent_RemoteEventCounts(object sender, FbRemoteEventEventArgs e)
{
Console.WriteLine("Event {0} has {1} counts.", e.Name, e.Counts);
// SELECT first 1 * FROM anprtable ORDER BY serialno DESC
try
{
DataTable resultTable;
DataSet ds = new DataSet();
FbDataAdapter da = new FbDataAdapter("SELECT first 1 * FROM anprtable ORDER BY serialno DESC", conn);
da.Fill(ds, "mytable");
DataTable dt = ds.Tables["mytable"];
foreach (DataRow dr in dt.Rows)
{
Console.WriteLine(string.Format("Name = {0}, Desc = {1}", dr["ANPRTIME"], dr["PLATE"]));
}
resultTable = dt;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString() + "::" + ex.StackTrace);
}
}
void remoteEvent_RemoteEventCounts(object sender, FbRemoteEventEventArgs e)
{
OnLogChanged();
}
static void EventCounts(object sender, FbRemoteEventEventArgs args)
{
Console.WriteLine("Event {0} has {1} counts.", args.Name, args.Counts);
}
static void EventCounts(object sender, FbRemoteEventEventArgs args)
{
if (args.Counts > 0)
{
string selectFromAccountsWhereModifyU = "";
switch (args.Name)
{
case "acc_insert":
selectFromAccountsWhereModifyU = "Select * from \"accounts\" where MODIFY='I'";
break;
case "acc_update":
selectFromAccountsWhereModifyU = "Select * from \"accounts\" where MODIFY='U'";
break;
}
try
{
FbTransaction ft = connection.BeginTransaction();
FbCommand fb = new FbCommand(selectFromAccountsWhereModifyU, connection, ft);
FbDataReader reader = fb.ExecuteReader();
while (reader.Read())
{
string row = "Record ->";
for (var i = 0; i < reader.FieldCount; i++)
{
row += string.Format(" {0} ", reader.GetValue(i));
}
switch (args.Name)
{
case "acc_insert":
row += " Inserted";
break;
case "acc_update":
row += " Updated";
;
break;
}
Console.WriteLine(row);
}
reader.Close();
switch (args.Name)
{
case "acc_insert":
selectFromAccountsWhereModifyU = "Update \"accounts\" set MODIFY='N' where MODIFY='I'";
break;
case "acc_update":
selectFromAccountsWhereModifyU = "Update \"accounts\" set MODIFY='G' where MODIFY='U'";
break;
}
fb.CommandText = selectFromAccountsWhereModifyU;
fb.ExecuteNonQuery();
ft.Commit();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
}
