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