private void GetListData()
{
kinectdataEntities con = new kinectdataEntities();
List <Alarm> list = con.Alarms.ToList();
Imported1.ItemsSource = list;
}
private void GetListData()
{
kinectdataEntities con = new kinectdataEntities();
List <Eventdata> list = con.Eventdatas.ToList();
Imported.ItemsSource = list;
}
private void myEvent(object source, ElapsedEventArgs e)
{
string ctime = DateTime.Now.ToString("HH:mm");
kinectdataEntities con = new kinectdataEntities();
// Alarm alarmdataRow = Imported1.SelectedItem as Alarm;
var alarmD = (from p in con.Alarms
select p.AlarmTime).ToList();
//MessageBox.Show(ctime.ToString());
if (alarmD != null && alarmD.Count > 0)
{
foreach (var item in alarmD)
{
string altime = Convert.ToString(item);
string alTime = altime.Substring(11, 5);
string curtime = DateTime.Now.ToString("HH:mm");
//MessageBox.Show(alTime+curtime);
// MessageBox.Show(curtime);
int x1 = string.Compare(curtime, alTime);
string x = Convert.ToString(x1);
// MessageBox.Show(x);
//x = "0";
//x1 = 0;
//if (x1 == 0)
//{
// //StopAlarm.Visibility = System.Windows.Visibility.Visible;
// if (AlarmFlag == 1)
// {
// for (int i = 300; i < 3000; i += 100)
// {
// Console.Beep(i, 1000);
// }
// AlarmFlag = 0;
// }
//}
}
}
//MessageBox.Show(alarmD);
//if (AlarmFlag == 0 && x == "0")
//{
// for (int i = 300; i < 3000; i += 100)
// {
// Console.Beep(i, 1000);
// }
// //Console.Beep(5000, 1000);
//}
}
private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
kinectdataEntities con = new kinectdataEntities();
Alarm alarmdataRow = Imported1.SelectedItem as Alarm;
var alarmD = (from p in con.Alarms
where p.Id == alarmdataRow.Id
select p).Single();
con.Alarms.Remove(alarmD);
con.SaveChanges();
System.Windows.MessageBox.Show("Record deleted successfully.");
GetListData();
}
private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
kinectdataEntities con = new kinectdataEntities();
Eventdata eventdataRow = Imported.SelectedItem as Eventdata;
var events = (from p in con.Eventdatas
where p.Id == eventdataRow.Id
select p).Single();
con.Eventdatas.Remove(events);
con.SaveChanges();
System.Windows.MessageBox.Show("Record deleted successfully.");
GetListData();
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
Imported.Visibility = System.Windows.Visibility.Visible;
kinectdataEntities con = new kinectdataEntities();
var cDate = DateTime.Now.Date;
List <Eventdata> todayList = con.Eventdatas.Where(t => t.eventdate == cDate).ToList();
foreach (var item in todayList)
{
PromptBuilder builder1 = new PromptBuilder();
builder1.StartSentence();
builder1.AppendText(item.@event);
builder1.EndSentence();
SpeechSynthesizer synthesizer = new SpeechSynthesizer();
synthesizer.Speak(builder1);
synthesizer.Dispose();
}
}
