public void InsertVoiceRecord(Voicing voicing)
{
using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
{
try
{
const string query =
"insert into voicing(NameID,TelephoneID,CompanyId,AppDate,"
+ "AppTime,FileName,Sequence,pPrevious,nNext,"
+ "LiveorVoice)values("
+ "@NameID,@TelephoneID,@CompanyId,@AppDate,"
+ "@AppTime,@FileName,@Sequence,@pPrevious,@nNext,"
+ "@LiveorVoice)";
int rowsAffectd = db.Execute(query, voicing);
}
catch (Exception er)
{
string s1 = er.Message;
//Log.WhichProgram = "Labcorp Interface";
Log.LogMessage(er.ToString());
}
}
}
private static void CreateVoiceFile(string toBeVoiced, string nameID, string companyID, string department,
string dateOfAppointment,string timeOfAppointment)
{
string fileName = string.Empty;
string sequence = string.Empty;
string liveOrVoice = string.Empty;
fileName = GetFileNameFromDateTimeString() + ".wav";
//Create voice file
//Save voice file
//Insert live into voicing table
//Insert vouce mail into voicing table
reader = new SpeechSynthesizer();
// reader.
// reader.Volume = 200;
// reader.Rate = 200;
reader.SelectVoice("Microsoft Zira Desktop");
reader.SelectVoice(System.Configuration.ConfigurationManager.AppSettings["voiceName"]);
try
{
reader.SetOutputToWaveFile(System.Configuration.ConfigurationManager.AppSettings["voiceFilePath"] + fileName, new SpeechAudioFormatInfo(11025, AudioBitsPerSample.Eight, AudioChannel.Mono));
//********************************************************************************
//used for testing
//reader.SetOutputToWaveFile("\\\\1lake-reminder2\\c\\Waldenltd\\voicetest\\" + department + ".wav", new SpeechAudioFormatInfo(11025, AudioBitsPerSample.Eight, AudioChannel.Mono));
//****************************************************************************************
reader.Speak(toBeVoiced);
}
catch (Exception er)
{
string s1 = er.Message;
}
//insert live
sequence = "1";
liveOrVoice = "L";
try
{
voicing = new Voicing();
voicing.NameID = int.Parse(nameID);
voicing.CompanyID = int.Parse(companyID);
voicing.AppDate = dateOfAppointment;
voicing.AppTime = timeOfAppointment;
voicing.FileName = fileName;
voicing.Sequence = int.Parse(sequence);
voicing.pPrevious = "Null";
voicing.nNext = "Null";
voicing.LiveorVoice = liveOrVoice;
patientRecords.InsertVoiceRecord(voicing);
}
catch (Exception er)
{
//Log.WhichProgram = "Labcorp Interface";
Log.LogMessage(er.ToString());
}
//insert voice
sequence = "1";
liveOrVoice = "V";
try
{
voicing = new Voicing();
voicing.NameID = int.Parse(nameID);
voicing.CompanyID = int.Parse(companyID);
voicing.AppDate = dateOfAppointment;
voicing.AppTime = timeOfAppointment;
voicing.FileName = fileName;
voicing.Sequence = int.Parse(sequence);
voicing.pPrevious = "Null";
voicing.nNext = "Null";
voicing.LiveorVoice = liveOrVoice;
patientRecords.InsertVoiceRecord(voicing);
}
catch (Exception er)
{
//Log.WhichProgram = "Labcorp Interface";
Log.LogMessage(er.ToString());
}
}