public ActionResult FilterCurrent()
        {
            List <int> alarms = (List <int>)Session["alarmIDs"];
            int        plcID  = 1;
            string     lang   = "en";

            if (Session["AlarmPlcID"] != null)
            {
                plcID = (int)Session["AlarmPlcID"];
            }
            if (Session["AlarmLang"] != null)
            {
                if (Session["AlarmLang"].ToString().Length >= 2)
                {
                    lang = Session["AlarmLang"].ToString();
                }
            }
            if (alarms != null)
            {
                Session["alarmIDs"] = null;

                AlarmHelper AH = new AlarmHelper();
                List <AlarmHelper.alarm_texts> model = new List <AlarmHelper.alarm_texts>();
                model = AH.SelectAlarmsTexts(Session["AlarmDB"].ToString(), alarms, plcID, lang);
                return(View("Filter", model));
            }
            Session["tempforview"] = "Problem with accesing current alarms";
            return(RedirectToAction("Index", "Alarm"));
        }
        public ActionResult FilterAll()
        {
            int    plcID = 1;
            string lang  = "en";

            if (Session["AlarmPlcID"] != null)
            {
                plcID = (int)Session["AlarmPlcID"];
            }
            if (Session["AlarmLang"] != null)
            {
                if (Session["AlarmLang"].ToString().Length >= 2)
                {
                    lang = Session["AlarmLang"].ToString();
                }
            }
            AlarmHelper AH = new AlarmHelper();
            List <AlarmHelper.alarm_texts> model = new List <AlarmHelper.alarm_texts>();

            model = AH.SelectAlarmsTexts(Session["AlarmDB"].ToString(), null, plcID, lang);
            return(View("Filter", model));
        }
        public JsonResult getAlarmConfig()
        {
            try
            {
                int    plcID = 1;
                string DB    = string.Empty;
                string table = string.Empty;
                foreach (string key in Session.Keys)
                {
                    if (key.Contains("plcID") && key.Contains(Request.QueryString["plc"].ToString()))
                    {
                        plcID = int.Parse(Session[key].ToString());
                    }
                    if (key.Contains("dbName") && key.Contains(Request.QueryString["plc"].ToString()))
                    {
                        DB = Session[key].ToString();
                    }
                    if (key.Contains("tableName") && key.Contains(Request.QueryString["plc"].ToString()))
                    {
                        table = Session[key].ToString();
                    }
                }
                AlarmHelper AH = new AlarmHelper();
                List <AlarmHelper.alarm_texts> data = new List <AlarmHelper.alarm_texts>();
                AlarmGraphConfig ALG = new AlarmGraphConfig();
                data = AH.SelectAlarmsTexts(DB, null, plcID);
                bool firstEn = true;
                bool firstCz = true;
                bool firstDe = true;
                bool firstPl = true;
                foreach (AlarmHelper.alarm_texts text in data)
                {
                    switch (text.lang)
                    {
                    case "en":
                        if (firstEn)
                        {
                            ALG.EN = new List <string>();
                        }
                        firstEn = false;
                        ALG.EN.Add(text.title);
                        break;

                    case "cs":
                        if (firstCz)
                        {
                            ALG.CZ = new List <string>();
                        }
                        firstCz = false;
                        ALG.CZ.Add(text.title);
                        break;

                    case "de":
                        if (firstDe)
                        {
                            ALG.DE = new List <string>();
                        }
                        firstDe = false;
                        ALG.DE.Add(text.title);
                        break;

                    case "pl":
                        if (firstPl)
                        {
                            ALG.PL = new List <string>();
                        }
                        firstPl = false;
                        ALG.PL.Add(text.title);
                        break;

                    default:
                        if (firstEn)
                        {
                            ALG.EN = new List <string>();
                        }
                        firstEn = false;
                        ALG.EN.Add(text.title);
                        break;
                    }
                }
                return(Json(ALG));
            } catch (Exception e)
            {
                return(null);
            }
        }