public static List <string> GetCountry(string ConnectionString)
        {
            OIUserSessionFacade  fac        = new OIUserSessionFacade(ConnectionString);
            List <CountryEntity> lstCountry = fac.GetCountries();
            var Country = (from a in lstCountry select a.CountryWithISOCode).Distinct().ToList();

            return(Country);
        }
Exemple #2
0
        public ActionResult popupUserFilter(OIUserSessionFilterEntity model)
        {
            // Save data to database for Session Filter.
            OIUserSessionFacade fac = new OIUserSessionFacade(this.CurrentClient.ApplicationDBConnectionString);

            int id = model.UserId;

            model.UserId = Helper.oUser.UserId;
            fac.InsertOrUpdateUserSessionFilter(model);
            return(Json(new { result = true, message = id > 0 ? CommonMessagesLang.msgCommanUpdateMessage : CommonMessagesLang.msgCommanInsertMessage }, JsonRequestBehavior.AllowGet));
        }
Exemple #3
0
        public ActionResult popupUserFilter(string UserId)
        {
            // Open Session filter popup and set data to Popup
            OIUserSessionFacade fac = new OIUserSessionFacade(this.CurrentClient.ApplicationDBConnectionString);

            model = fac.GetUserSessionFilterByUserId(Helper.oUser.UserId);
            if (model.UserId > 0)
            {
                model.OrderByColumn = model.OrderByColumn == null ? "SrcRecordId" : model.OrderByColumn;
            }
            else
            {
                model = new OIUserSessionFilterEntity();
                model.OrderByColumn = "SrcRecordId";
            }
            return(PartialView("~/Views/OI/OIUserSessionFilter/_popupUserFilter.cshtml", model));
        }