public UtilityService(IPhotosService photoService, IConversationService conversationService, IProfileService profileService, IKatushaDbContext dbContext, IDocumentStore ravenStore,
IPhotoRepositoryDB photoRepository, IProfileRepositoryDB profileRepository, IUserRepositoryDB userRepository, IPhotoBackupService photoBackupService,
ICountriesToVisitRepositoryDB countriesToVisitRepository, ILanguagesSpokenRepositoryDB languagesSpokenRepository, ISearchingForRepositoryDB searchingForRepository,
IConversationRepositoryDB conversationRepository, IProfileRepositoryRavenDB profileRepositoryRaven, IVisitRepositoryRavenDB visitRepositoryRaven, IConversationRepositoryRavenDB conversationRepositoryRaven,
IKatushaFileSystem fileSystem)
{
_conversationRepositoryRaven = conversationRepositoryRaven;
_fileSystem = fileSystem;
_visitRepositoryRaven = visitRepositoryRaven;
_profileRepositoryRaven = profileRepositoryRaven;
_photoRepository = photoRepository;
_photoService = photoService;
_conversationService = conversationService;
_profileService = profileService;
_conversationRepository = conversationRepository;
_countriesToVisitRepository = countriesToVisitRepository;
_languagesSpokenRepository = languagesSpokenRepository;
_searchingForRepository = searchingForRepository;
_ravenStore = ravenStore as KatushaRavenStore;
_profileRepository = profileRepository;
_userRepository = userRepository;
_photoBackupService = photoBackupService;
_dbContext = dbContext; // as KatushaDbContext;
_resourceManager = ResourceManager.GetInstance();
_countries = _resourceManager.GetCountries();
_languages = _resourceManager.GetLanguages();
}
public static void ClearDatabase(IKatushaDbContext dbContext)
{
foreach (var tableName in new string[] { "CountriesToVisits", "Conversations", "LanguagesSpokens", "SearchingFors", "Visits", "PhotoBackups", "Photos", "States" })
{
dbContext.Database.ExecuteSqlCommand("TRUNCATE TABLE [" + tableName + "]");
}
dbContext.Database.ExecuteSqlCommand("DELETE FROM [Profiles]");
dbContext.Database.ExecuteSqlCommand("DELETE FROM [Users]");
dbContext.Database.ExecuteSqlCommand("DBCC CHECKIDENT ([Users], RESEED, 1)");
dbContext.Database.ExecuteSqlCommand("DBCC CHECKIDENT ([Profiles], RESEED, 1)");
}
public static void Delete(IKatushaDbContext dbContext)
{
var context = dbContext as KatushaDbContext;
if (context == null)
{
return;
}
foreach (var tableName in new string[] { "Resources", "ConfigurationDatas", "ResourceLookups", "GeoCountries", "GeoLanguages", "GeoNames", "GeoTimeZones" })
{
dbContext.Database.ExecuteSqlCommand("TRUNCATE TABLE [" + tableName + "]");
}
ClearLocal <Resource>(context);
ClearLocal <ConfigurationData>(context);
ClearLocal <ResourceLookup>(context);
ClearLocal <GeoCountry>(context);
ClearLocal <GeoLanguage>(context);
ClearLocal <GeoName>(context);
ClearLocal <GeoTimeZone>(context);
}
public ConfigParser(IKatushaDbContext dbContext)
{
var configurationData = new ConfigurationType(Section.Configuration)
{
Repository = new ConfigurationDataRepositoryDB(dbContext),
MinimumAllowed = 2,
MaximumAllowed = 2,
LanguageOrder = -1,
OrderOrder = -1
};
var resource = new ConfigurationType(Section.Resource)
{
Repository = new ResourceRepositoryDB(dbContext),
MinimumAllowed = 3,
MaximumAllowed = 3,
LanguageOrder = 0,
OrderOrder = -1
};
var resourceLookup = new ConfigurationType(Section.ResourceLookup)
{
Repository = new ResourceLookupRepositoryDB(dbContext),
MinimumAllowed = 6,
MaximumAllowed = 6,
LanguageOrder = 0,
OrderOrder = 4
};
_dependencies = new Dictionary <Section, ConfigurationType> {
{ Section.Configuration, configurationData },
{ Section.Resource, resource },
{ Section.ResourceLookup, resourceLookup }
};
//_geoTimeZoneRepository = new GeoTimeZoneRepositoryDB(dbContext);
//_geoNameRepository = new GeoNameRepositoryDB(dbContext);
//_geoCountryRepository = new GeoCountryRepositoryDB(dbContext);
//_geoLanguageRepository = new GeoLanguageRepositoryDB(dbContext);
}
public GeoCountryRepositoryDB(IKatushaDbContext dbContext)
{
_dbContext = dbContext as KatushaDbContext;
}
public GeoLanguageRepositoryDB(IKatushaDbContext dbContext) { _dbContext = dbContext as KatushaDbContext; }
protected BaseFriendlyNameRepositoryDB(IKatushaDbContext dbContext) : base(dbContext)
{
}
public ProfileRepositoryDB(IKatushaDbContext dbContext) : base(dbContext)
{
}
public static List <string> Reset(IKatushaDbContext dbContext)
{
Delete(dbContext);
return(Set(dbContext));
}
protected BaseGuidRepositoryDB(IKatushaDbContext dbContext) : base(dbContext)
{
}
public ResourceLookupRepositoryDB(IKatushaDbContext context) : base(context)
{
}
public GeoCountryRepositoryDB(IKatushaDbContext dbContext) { _dbContext = dbContext as KatushaDbContext; }
public GeoTimeZoneRepositoryDB(IKatushaDbContext dbContext)
{
_dbContext = dbContext as KatushaDbContext;
}
public ConversationRepositoryDB(IKatushaDbContext dbContext) : base(dbContext)
{
}
public GeoNameRepositoryDB(IKatushaDbContext dbContext) { _dbContext = dbContext as KatushaDbContext; }
public CountriesToVisitRepositoryDB(IKatushaDbContext dbContext) : base(dbContext)
{
}
public SearchingForRepositoryDB(IKatushaDbContext dbContext) : base(dbContext)
{
}
protected BaseDetailGuidRepositoryDB(IKatushaDbContext context) : base(context)
{
}
public static List <string> Set(IKatushaDbContext dbContext)
{
var parser = new ConfigParser(dbContext);
return(parser.Parse());
}
public LanguagesSpokenRepositoryDB(IKatushaDbContext dbContext) : base(dbContext)
{
}
public PhotoBackupRepositoryDB(IKatushaDbContext dbContext) : base(dbContext)
{
}
public VisitRepositoryDB(IKatushaDbContext dbContext) : base(dbContext)
{
}
public UserRepositoryDB(IKatushaDbContext dbContext) : base(dbContext)
{
}
protected BaseRepositoryDB(IKatushaDbContext context)
{
var dbContext = context as DbContext;
DbContext = dbContext;
}
protected BaseDetailFriendlyNameRepositoryDB(IKatushaDbContext context) : base(context)
{
}
public GeoLanguageRepositoryDB(IKatushaDbContext dbContext)
{
_dbContext = dbContext as KatushaDbContext;
}
public ConfigParser(IKatushaDbContext dbContext)
{
var configurationData = new ConfigurationType(Section.Configuration) {
Repository = new ConfigurationDataRepositoryDB(dbContext),
MinimumAllowed = 2,
MaximumAllowed = 2,
LanguageOrder = -1,
OrderOrder = -1
};
var resource = new ConfigurationType(Section.Resource) {
Repository = new ResourceRepositoryDB(dbContext),
MinimumAllowed = 3,
MaximumAllowed = 3,
LanguageOrder = 0,
OrderOrder = -1
};
var resourceLookup = new ConfigurationType(Section.ResourceLookup) {
Repository = new ResourceLookupRepositoryDB(dbContext),
MinimumAllowed = 6,
MaximumAllowed = 6,
LanguageOrder = 0,
OrderOrder = 4
};
_dependencies = new Dictionary<Section, ConfigurationType> {
{Section.Configuration, configurationData},
{Section.Resource, resource},
{Section.ResourceLookup, resourceLookup}
};
//_geoTimeZoneRepository = new GeoTimeZoneRepositoryDB(dbContext);
//_geoNameRepository = new GeoNameRepositoryDB(dbContext);
//_geoCountryRepository = new GeoCountryRepositoryDB(dbContext);
//_geoLanguageRepository = new GeoLanguageRepositoryDB(dbContext);
}
public ConfigurationDataRepositoryDB(IKatushaDbContext context)
: base(context)
{
}
public StateRepositoryDB(IKatushaDbContext dbContext)
{
_dbContext = dbContext as KatushaDbContext;
}
public RepositoryDB(IKatushaDbContext context) : base(context)
{
}
public GeoTimeZoneRepositoryDB(IKatushaDbContext dbContext) { _dbContext = dbContext as KatushaDbContext; }
public GeoNameRepositoryDB(IKatushaDbContext dbContext)
{
_dbContext = dbContext as KatushaDbContext;
}
