public MainViewModel(MainWindow mainWindow)
{
DispatcherTimer dispatcherTimer = new DispatcherTimer();
dispatcherTimer.set_Interval(new TimeSpan(0, 0, 1));
this._timer = dispatcherTimer;
// ISSUE: explicit constructor call
base.\u002Ector();
this._timer.add_Tick(new EventHandler(this.timer_Tick));
this.parent = mainWindow;
this._googleConnector = new GoogleConnector();
this.Items = new ObservableCollection <TrackingEntry>(this._googleConnector.GetEntries());
this.SheetTypes = new ObservableCollection <SheetType>((IEnumerable <SheetType>) new SheetType[2]
{
new SheetType()
{
Description = "Use Google",
IsSelected = true
},
new SheetType()
{
Description = "Use Excel",
IsSelected = false
}
});
}
public ActionResult Create(Usuario usuario2)
{
GeocodeResponse geoPosicion = GoogleConnector.MakeRequest(usuario2.Contacto.AddressNumber, usuario2.Contacto.StreetName, usuario2.Contacto.CityName, usuario2.Contacto.CountryName);
Console.WriteLine(geoPosicion);
usuario2.Contacto.Latitud = geoPosicion.results[0].geometry.location.lat;
usuario2.Contacto.Longitud = geoPosicion.results[0].geometry.location.lng;
db.Contacto.Add(usuario2.Contacto);
db.Usuarios.Add(usuario2);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
public GDriveManager(GoogleConnector connector)
{
this.Service = connector.Drive;
}
// Please set the following connection strings in app.config for this WebJob to run:
// AzureWebJobsDashboard and AzureWebJobsStorage
static void Main()
{
try
{
Console.WriteLine("*** STT stating ***");
DBConnector dbConnector = new DBConnector();
GoogleConnector googleConnector = new GoogleConnector();
string AZURE_TEMP_FOLDER_PATH = ConfigurationManager.AppSettings["AZURE_TEMP_FOLDER_PATH"];
var groups = dbConnector.AllBlobNotProcessed((int)MediaExtensions.WAV, ApiSourceId.Both).GroupBy(i => i.InterviewID).ToList();
Console.WriteLine("Not processed wavs groups count : " + groups.Count());
if (groups.Count() > 0)
{
AzureConnector azureConnector = new AzureConnector();
foreach (var group in groups)
{
if (group.Count() > 0)
{
var tempPath = String.Empty;
foreach (var item in group)
{
Console.WriteLine("-----------------------------------------------------");
Console.WriteLine(item.MediaURL);
List <Microsoft.CognitiveServices.Speech.SpeechRecognitionResult> recognizedItems = new List <Microsoft.CognitiveServices.Speech.SpeechRecognitionResult>();
var tempFolderName = Guid.NewGuid().ToString();
tempPath = System.IO.Path.Combine(AZURE_TEMP_FOLDER_PATH, item.InterviewID.ToString());
Console.WriteLine("Interviw LanguageID :" + item.LanguageID);
Console.WriteLine("InterviwID : " + item.InterviewID);
Console.WriteLine("MediaShortName : ", item.MediaShortName);
var apisource = dbConnector.GetInterviewApiSource(item.InterviewID, item.LanguageID);
if (apisource != null)
{
List <SpeechToText> list = new List <SpeechToText>();
if (apisource.SourceID.Equals(ApiSourceId.Azure))
{
if (item.ApiSourceID == ApiSourceId.Azure)
{
#region STT Microsoft
//Only select Question Order
var questionOrder = item.MediaShortName.Substring(item.MediaShortName.Length - 5, 1);
Stream stream = azureConnector.GetMediaBlob(item.MediaURL);
var temp_audio_file = SharedHelper.CreateFileLocaly(stream, tempFolderName, tempPath);
SpeechRecognitionMS.ContinuousRecognitionWithFileAsync(temp_audio_file, item.LanguageID, recognizedItems).Wait();
foreach (var recognitionResult in recognizedItems)
{
var text = recognitionResult.Text;
var result = SharedHelper.BuildSentimentKeyWordsScoreAsync(text, item.LanguageID);
var sTT = new SpeechToText()
{
Confidence = "Microsoft",
Text = text,
SentimentScore = result.Result.Score,
KeyWords = result.Result.KeyWords,
};
list.Add(sTT);
}
var jsonResult = Newtonsoft.Json.JsonConvert.SerializeObject(list);
int quest = 0;
if (int.TryParse(questionOrder, out quest))
{
dbConnector.AddSpeechToText(item.InterviewID, quest, jsonResult);
}
#endregion
}
}
else
{
if (item.ApiSourceID == ApiSourceId.Google)
{
#region STT Google
//STT Google to be tested , then delete the old web Job
//Only select Question Order
var questionOrder = item.MediaShortName.Substring(item.MediaShortName.Length - 5, 1);
Console.WriteLine("QuestionOrder : " + questionOrder);
Console.WriteLine("Media Url : " + item.MediaURL);
var response = SpeechRecognitionGoogle.stt_google(item.MediaShortName, item.LanguageID);
if (response != null)
{
foreach (var result in response.Results)
{
foreach (var alternative in result.Alternatives)
{
var text = alternative.Transcript;
var result_ms = SharedHelper.BuildSentimentKeyWordsScoreAsync(text, String.IsNullOrEmpty(item.LanguageID) ? System.Configuration.ConfigurationManager.AppSettings["LanguageCode"] : item.LanguageID);
Console.WriteLine($"currrent google speech to text : {alternative.Transcript}");
var sTT = new SpeechToText()
{
Confidence = "google",
Text = text,
SentimentScore = result_ms.Result.Score,
Order = int.Parse(questionOrder),
KeyWords = result_ms.Result.KeyWords,
};
list.Add(sTT);
}
}
}
var jsonResult = Newtonsoft.Json.JsonConvert.SerializeObject(list);
Console.WriteLine($"Json google speech: {jsonResult}");
dbConnector.AddSpeechToText(item.InterviewID, int.Parse(questionOrder), jsonResult, (int)ApiSourceId.Google);
#endregion
}
}
}
dbConnector.UpdateInterviewMediaStatus(item.MediaURL, 1);
//TODO::Delete wavs from google storage at the end of the process
googleConnector.DeleteObject(item.MediaShortName);
var _result = dbConnector.AllBlobProcessed(item.InterviewID, (int)MediaExtensions.WAV);
if (_result == "TRUE")
{
dbConnector.InsertOrUpdateAVTaskTracker(DBOperationType.Update.ToString(), "", item.InterviewID, TaskLabel.texte.ToString(), (int)StatusId.Finished, 0);
}
}
DeleteTempFiles_If_All_Files_Are_treated(dbConnector, ApiSourceId.Azure, group.FirstOrDefault().InterviewID, tempPath);
}
}
}
}
catch (Exception e)
{
SharedHelper.GetFullException(e);
}
Console.WriteLine("***GoogleRecognizeSST Finished ***");
}
