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); }
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)); }
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)); }