internal static void LoadStructureCache(bool clearExternal) { ClearInternalStructureCache(); if (clearExternal) { ClearExternalStructureCache(); } if (GetSiteCache() == null) { SetSiteCache(SiteRepository.GetAll().ToDictionary(n => n.Id)); } if (GetContentCache() == null) { SetContentCache(ContentRepository.GetAll().ToDictionary(n => n.Id)); } IEnumerable <Field> fields = new Field[0]; if (GetFieldCache() == null || GetContentFieldCache() == null) { fields = FieldRepository.GetAll(); } if (GetFieldCache() == null) { SetFieldCache(fields.ToDictionary(n => n.Id)); } if (GetStatusTypeCache() == null) { SetStatusTypeCache(StatusTypeRepository.GetAll().ToDictionary(n => n.Id)); } if (GetUserCache() == null) { SetUserCache(UserRepository.GetAllUsersList().ToDictionary(n => n.Id)); } if (GetContentFieldCache() == null) { var dict = new Dictionary <int, List <int> >(); foreach (var item in fields) { if (dict.ContainsKey(item.ContentId)) { dict[item.ContentId].Add(item.Id); } else { dict.Add(item.ContentId, new List <int> { item.Id }); } } SetContentFieldCache(dict); } }
public async Task <IActionResult> GetAll(int RecordLimit) { ResponseHelper objHelper = new ResponseHelper(); try { var vList = await SiteRepository.GetAll(RecordLimit); if (vList == null) { objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Get Empty Data"; } else { objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Get Successfully"; objHelper.Data = vList; } return(Ok(objHelper)); } catch { objHelper.Status = StatusCodes.Status500InternalServerError; objHelper.Message = "Get Unsuccessful"; return(StatusCode(StatusCodes.Status500InternalServerError, objHelper)); } }
private void UpdateDataGrid() { using (var session = SharpArch.NHibernate.NHibernateSession.GetDefaultSessionFactory().OpenSession()) { SiteRepository siteRepository = new SiteRepository(session); dataGrid1.DataContext = siteRepository.GetAll().ToList(); } }
public void Should_return_all_sites() { using (var context = new WeapsyDbContext(_contextOptions)) { var repository = new SiteRepository(Shared.CreateNewContextFactory(context), Shared.CreateNewMapper()); var sites = repository.GetAll(); Assert.AreEqual(2, sites.Count); } }
public SelectList Sites() { SiteRepository repository = new SiteRepository(); List <SiteEntity> allSites = repository.GetAll().ToList(); List <SiteEntity> userSites = (from site in allSites where site.AspNetUsers_Id == IdUser select site).ToList(); return(new SelectList(userSites, "IdSite", "URL")); }
public ActionResult <IEnumerable <Site> > Get() { try { return(Ok(_repo.GetAll())); } catch (Exception e) { return(BadRequest(e)); } }
public ShowSitesViewModel GetSitesVerifyByIdUser(string idUser, int page = 1, string sort = "URL", string sortdir = "ASC") { int pageSize = 4; ShowSitesViewModel m = new ShowSitesViewModel(); SiteRepository siteRepository = new SiteRepository(); List <SiteEntity> sitesAvailable = siteRepository.GetAll().Where(x => x.IsActive.Value).ToList(); m.PageSize = pageSize; m.TotalRecord = (from r in sitesAvailable where r.AspNetUsers_Id.Equals(idUser) && r.Verified == true select r).Count(); m.NoOfPages = (m.TotalRecord / m.PageSize) + ((m.TotalRecord % m.PageSize) > 0 ? 1 : 0); var ListSitesVerify = (from site in sitesAvailable orderby(sort + " " + sortdir) where site.AspNetUsers_Id.Equals(idUser) && site.Verified == true select site).Skip((page - 1) * m.PageSize).Take(m.PageSize).ToList(); m.ListSitesVerify = ListSitesVerify; return(m); }
internal static void LoadStructureCache(bool clearExternal) { ClearInternalStructureCache(); if (clearExternal) { ClearExternalStructureCache(); } if (GetSiteCache() == null) { Dictionary <int, Site> value = SiteRepository.GetAll().ToDictionary(n => n.Id); SetValueToStorage(_siteCache, value, HttpContextItems.SiteCache); } if (GetContentCache() == null) { Dictionary <int, Content> value = ContentRepository.GetAll().ToDictionary(n => n.Id); SetValueToStorage(_contentCache, value, HttpContextItems.ContentCache); } IEnumerable <Field> fields = new Field[0]; if (GetFieldCache() == null || GetContentFieldCache() == null) { fields = FieldRepository.GetAll(); } if (GetFieldCache() == null) { Dictionary <int, Field> value = fields.ToDictionary(n => n.Id); SetValueToStorage(_fieldCache, value, HttpContextItems.FieldCache); } if (GetStatusTypeCache() == null) { Dictionary <int, StatusType> value = StatusTypeRepository.GetAll().ToDictionary(n => n.Id); SetValueToStorage(_statusTypeCache, value, HttpContextItems.StatusType); } if (GetUserCache() == null) { Dictionary <int, User> value = UserRepository.GetAllUsersList().ToDictionary(n => n.Id); SetValueToStorage(_userCache, value, HttpContextItems.User); } if (GetContentFieldCache() == null) { var dict = new Dictionary <int, List <int> >(); foreach (var item in fields) { if (dict.ContainsKey(item.ContentId)) { dict[item.ContentId].Add(item.Id); } else { dict.Add(item.ContentId, new List <int> { item.Id }); } } SetValueToStorage(_contentFieldCache, dict, HttpContextItems.ContentFieldCache); } }
public ActionResult Index() { repo.FixDB(); return(View(repo.GetAll())); }
public static IEnumerable <ListItem> GetAllSites() { return(SiteRepository.GetAll().Select(s => new ListItem(s.Id.ToString(), s.Name)).ToArray()); }
public bool SaveProduct(Models.Publisher.CreateProductModel _createModel, string UserIdentity, Models.Core.FileUpload fileUpload) { //Creamos los repositorios SiteRepository siteRepository = new SiteRepository(); AspNetUserRepository aspNetUserRepository = new AspNetUserRepository(); ProductTypeRepository productTypeRepository = new ProductTypeRepository(); PartnerRepository partnerRepository = new PartnerRepository(); ProductRepository productRepository = new ProductRepository(); //Obtenemos los conjuntos List <SiteEntity> sites = siteRepository.GetAll().ToList(); List <AspNetUserEntity> users = aspNetUserRepository.GetAll().ToList(); List <ProductTypeEntity> productstype = productTypeRepository.GetAll().ToList(); List <PartnerEntity> partners = partnerRepository.GetAll().ToList(); //Obtenemos las entidades deseadas. SiteEntity site = (from s in sites where s.IdSite == _createModel.SiteTypeSelecc select s).FirstOrDefault(); AspNetUserEntity user = (from u in users where u.Id == UserIdentity select u).FirstOrDefault(); ProductTypeEntity productType = (from pr in productstype where pr.IdProductType == _createModel.ProductTypeSelect select pr).FirstOrDefault(); PartnerEntity partner = (from p in partners where p.IdPartner == _createModel.ParterTypeSelect select p).FirstOrDefault(); ProductEntity product = new ProductEntity { //AspNetUser = user, AspNetUsers_Id = UserIdentity, IdProduct = Guid.NewGuid(), Price = _createModel.PriceSelecc, ShortDescription = _createModel.Name, FullDescription = string.Empty, StartTime = Helpers.DateTimeHelper.GetCurrentDateString(), EndTime = Helpers.DateTimeHelper.GetCurrentDateString(0, 30), RegistrationDate = DateTime.Now, SITE_IdSite = site.IdSite, PRODUCT_TYPE_IdProductType = productType.IdProductType, PARTNER_IdPartner = partner.IdPartner, Image = string.Empty, IsActive = true, IsPremium = _createModel.IsPremium }; if (fileUpload != null) { product.Image = Helpers.AzureStorageHelper.CreateBlobImageFile(fileUpload.FileData, fileUpload.Filextension); } else { product.Image = Helpers.AzureStorageHelper.CreateBlobImageFile(getImageFromUrl(""), ".png"); } productRepository.Add(product); if (_createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_SUBSCRIBERS)) || _createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_PUSH_CREW)) || _createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_PUSH_ENGAGE))) { AddProductSettingEntity(product, "pushApiToken", _createModel.Token); } else if (_createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_MAIL_CHIMP))) { AddProductSettingEntity(product, "mailChimpApiToken", _createModel.Token); AddProductSettingEntity(product, "mailChimpList", _createModel.ListMCSelecc); AddProductSettingEntity(product, "mailChimpTemplate", Convert.ToString(_createModel.TemplateMCSelecc)); } else if (_createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_CAMPAIGN_MONITOR))) { AddProductSettingEntity(product, "campaignMonitorApiToken", _createModel.Token); AddProductSettingEntity(product, "campaignMonitorList", _createModel.ListCMSelecc); AddProductSettingEntity(product, "campaignMonitorClient", Convert.ToString(_createModel.ClientCMSelecc)); AddProductSettingEntity(product, "campaignMonitorSegment", Convert.ToString(_createModel.SegmentCMSelecc)); } else if (_createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_AWEBER))) { AddProductSettingEntity(product, "aweberApiToken", _createModel.Token); AddProductSettingEntity(product, "aweberList", _createModel.ListAWSelecc); AddProductSettingEntity(product, "aweberApplicationKey", _createModel.providerAWeberApiResult.ApplicationKey); AddProductSettingEntity(product, "aweberApplicationSecret", _createModel.providerAWeberApiResult.ApplicationSecret); AddProductSettingEntity(product, "aweberOAuthToken", _createModel.providerAWeberApiResult.OAuthToken); AddProductSettingEntity(product, "aweberOAuthTokenSecret", _createModel.providerAWeberApiResult.OAuthTokenSecret); AddProductSettingEntity(product, "aweberOauthVerifier", _createModel.providerAWeberApiResult.OauthVerifier); AddProductSettingEntity(product, "aweberCallbackURL", _createModel.providerAWeberApiResult.CallbackURL); } else if (_createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_SEND_GRID))) { AddProductSettingEntity(product, "sendGridApiToken", _createModel.Token); AddProductSettingEntity(product, "sendGridList", _createModel.ListSGSelecc); AddProductSettingEntity(product, "sendGridSender", _createModel.SenderSGSelecc); AddProductSettingEntity(product, "sendGridUnsubscribeGroup", _createModel.UnsubscribeGroupSGSelecc); } else if (_createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_ACTIVE_CAMPAIGN))) { AddProductSettingEntity(product, "activeCampaignApiToken", _createModel.Token); AddProductSettingEntity(product, "activeCampaignList", _createModel.ListACSelecc); AddProductSettingEntity(product, "activeCampaignUrl", _createModel.URLACSelecc); } else if (_createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_GETRESPONSE))) { AddProductSettingEntity(product, "getResponseApiToken", _createModel.Token); AddProductSettingEntity(product, "getResponseList", _createModel.ListGRSelecc); AddProductSettingEntity(product, "getResponseFromField", _createModel.FromFieldGRSelecc); } else if (_createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_ICONTACT))) { // Crear campaign y guardar el Id string IdCampaign = string.Empty; AddProductSettingEntity(product, "icontactIdCampaign", _createModel.IContact.IdCampaign); AddProductSettingEntity(product, "icontactApiAppId", _createModel.IContact.ApiAppId); AddProductSettingEntity(product, "icontactUserName", _createModel.IContact.ApiUserName); AddProductSettingEntity(product, "icontactUserPassword", _createModel.IContact.ApiUserPassword); AddProductSettingEntity(product, "icontactAccountId", _createModel.IContact.AccountId); AddProductSettingEntity(product, "icontactClientFolderId", _createModel.IContact.ClientFolderId); AddProductSettingEntity(product, "icontactIdList", _createModel.IContact.ListId); } else if (_createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_SENDINBLUE))) { //Store product settings AddProductSettingEntity(product, "sendinBlueApiKey", _createModel.Token); AddProductSettingEntity(product, "sendinBlueCategory", _createModel.SendinBlue.Category); AddProductSettingEntity(product, "sendinBlueFromEmail", _createModel.SendinBlue.FromEmail); AddProductSettingEntity(product, "sendinBlueListId", _createModel.SendinBlue.ListIds[0].ToString()); } else if (_createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_ONE_SIGNAL))) { AddProductSettingEntity(product, "oneSignalApiKey", _createModel.Token); AddProductSettingEntity(product, "oneSignalAppId", _createModel.ListAppOSSelecc); AddProductSettingEntity(product, "oneSignalAppKey", _createModel.AuthAppOSSelecc); } else if (_createModel.ParterTypeSelect.Equals(new Guid(Utils.Constants.PROVIDER_MAILJET))) { AddProductSettingEntity(product, "mailJetApiKey", _createModel.Token); AddProductSettingEntity(product, "mailJetList", _createModel.ListMJSelecc); AddProductSettingEntity(product, "mailJetSegment", _createModel.SegmentMJSelecc); AddProductSettingEntity(product, "mailJetSecretKey", _createModel.SecretKeyMJ); } return(true); }