void FilterGrid() { NotificationData filterNotificationData = new NotificationData(); filterNotificationData.MachineCode = filterMachine.Text.Equals(filterMachineLabel) ? null : filterMachine.Text; NotificationData.errorCategory category = NotificationData.errorCategory.NA; Enum.TryParse(filterCategory.Text, out category); filterNotificationData.category = category; filterNotificationData.FilterNotifyStart = DateTime.Parse(filterStartDate.Value.ToString()); filterNotificationData.FilterNotifyEnd = DateTime.Parse(filterEndDate.Value.ToString()); notificationGrid.ItemsSource = objGeneralDba.GetNotifications(filterNotificationData); }
public NotificationData GetTriggerDataUsingNotificationQuery(string query) { NotificationData notificationData = (NotificationData)null; try { using (OracleConnection conn = new OracleConnection(Connection.connectionString)) { if (conn.State == ConnectionState.Closed) { conn.Open(); } using (OracleDataReader oracleDataReader = new OracleCommand(query, conn).ExecuteReader()) { if (oracleDataReader.HasRows) { if (oracleDataReader.Read()) { notificationData = new NotificationData(); NotificationData.errorCategory category = NotificationData.errorCategory.TRIGGER; Enum.TryParse(Convert.ToString(oracleDataReader["TRIGGER_TYPE"]), out category); notificationData.category = category; if (notificationData.category == NotificationData.errorCategory.NA) { notificationData.category = NotificationData.errorCategory.TRIGGER; } if (notificationData.category == NotificationData.errorCategory.ERROR) { notificationData.ErrorCode = Convert.ToString(oracleDataReader["N_VALUE"]); } notificationData.MachineCode = Convert.ToString(oracleDataReader["MACHINE"]); //notificationData.TriggerStatus = int.Parse(Convert.ToString(oracleDataReader["IS_TRIGGER"])) == 1; notificationData.IsCleared = !(int.Parse(Convert.ToString(oracleDataReader["IS_TRIGGER"])) == 1); } } } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(notificationData); }