public void createNewAlarm(DateTime dateOut, int tableNum, string TextMessage)
{
tempAlarm = new newAlarm();
tempAlarm.Alarm(alarm_index, dateOut, tableNum, TextMessage, con);
alarm_index++;
tempAlarm.insertToDB();
updateListBox();
}
public Alarm(SqlConnection c)
{
tempAlarm = new newAlarm();
InitializeComponent();
con = c;
updateListBox();
if (dataGridView1.Rows.Count == 0)
{
alarm_index = 1;
MessageBox.Show("1");
}
}
private void StopAndDeleteAlarm(newAlarm alarmNum)
{
SqlCommand deleteAlarmFromDB;
deleteAlarmFromDB = new SqlCommand("DELETE FROM alarm WHERE table_num=@table_num and alarm_num = @alarm_num; ", con);
deleteAlarmFromDB.Parameters.Add(new SqlParameter("@table_num", SqlDbType.Int));
deleteAlarmFromDB.Parameters["@table_num"].Value = alarmNum.tableNum;
deleteAlarmFromDB.Parameters.Add(new SqlParameter("@alarm_num", SqlDbType.Int));
deleteAlarmFromDB.Parameters["@alarm_num"].Value = alarmNum.alarm_num;
deleteAlarmFromDB.ExecuteNonQuery();
alarmNum = null;
updateListBox();
}