public void CreateLink()
{
using (var context = TestDwhDbContext.CreateDWHDbContext()) {
var keyCache = new BasePrimaryKeyCache();
var hubRepo = new HubRepository <H_TestHub_Default>(context, HashFunctions.MD5, null);
var linkRepo = new LinkRepository <L_TestLink_Default>(context, HashFunctions.MD5, keyCache, DVKeyCaching.Enabled);
var loadDate = DateTime.Now;
hubRepo.Insert(hubs, loadDate);
linkRepo.Insert(new L_TestLink_Default(hub1.PrimaryKey, hub2.PrimaryKey), loadDate);
linkRepo.Insert(new L_TestLink_Default(hub1.PrimaryKey, hub2.PrimaryKey), loadDate);
}
}
public void TestQueriesAndInsert()
{
using (var context = TestDwhDbContext.CreateDWHDbContext()) {
var hubRepo = new HubRepository <H_TestHub_Stores>(context, HashFunctions.MD5, null);
var satelliteRepo = new SatelliteRepository <S_TestSatellite_Stores>(context, HashFunctions.MD5);
var linkRepo = new LinkRepository <L_TestLink_Stores>(context, HashFunctions.MD5, null, DVKeyCaching.Disabled);
var loadDate = DateTime.Now;
// HUB - storing info
hubRepo.Insert(TestHub1, loadDate, loadInformation: LoadInfo1);
var hub = hubRepo.GetByKey(TestHub1.PrimaryKey);
Assert.Equal(LoadInfo1.RecordSource, hub.RecordSource);
Assert.Equal(LoadInfo1.LoadedBy, hub.LoadedBy);
// SATELLITE - storing info
Hub1Satellite1 = satelliteRepo.Insert(Hub1Satellite1, loadDate, loadInformation: LoadInfo1);
var sat = satelliteRepo.GetCurrent(s => s.Reference == TestHub1.PrimaryKey).Single();
Assert.Equal(LoadInfo1.RecordSource, sat.RecordSource);
Assert.Equal(LoadInfo1.LoadedBy, sat.LoadedBy);
// LINK - storing info
Link1 = linkRepo.Insert(Link1, loadDate, loadInformation: LoadInfo1);
var link = linkRepo.GetByKey(Link1.PrimaryKey);
Assert.Equal(LoadInfo1.RecordSource, link.RecordSource);
Assert.Equal(LoadInfo1.LoadedBy, link.LoadedBy);
}
}
public void KeyCachingIsSharedByAllInstances()
{
using (var context = TestDwhDbContext.CreateDWHDbContext()) {
var keyCache = new BasePrimaryKeyCache();
var hubRepo = new HubRepository <H_TestHub_Default>(context, HashFunctions.MD5, null);
var linkRepo = new LinkRepository <L_TestLink_Default>(context, HashFunctions.MD5, keyCache, DVKeyCaching.Enabled);
var loadDate = DateTime.Now;
hubRepo.Insert(hubs, loadDate);
//single insert
var insertedLink = linkRepo.Insert(new L_TestLink_Default(hub1.PrimaryKey, hub2.PrimaryKey), loadDate);
//new repository created -> cache is initialized from memory context
// -> cache already kontains the key
linkRepo = new LinkRepository <L_TestLink_Default>(context, HashFunctions.MD5, keyCache, DVKeyCaching.Enabled);
// same key again -> insert prevented
var insertedLink2 = linkRepo.Insert(new L_TestLink_Default(hub1.PrimaryKey, hub2.PrimaryKey), loadDate);
var list = linkRepo.Get();
Assert.NotNull(list);
Assert.Single(list);
}
}
public void TestQueriesAndInsert()
{
using (var context = TestDwhDbContext.CreateDWHDbContext()) {
var referenceRepo = new CRUDRepository <LoadInformation, long>(context);
var hubRepo = new HubRepository <H_TestHub_References>(context, HashFunctions.MD5, null);
var satelliteRepo = new SatelliteRepository <S_TestSatellite_References>(context, HashFunctions.MD5);
var linkRepo = new LinkRepository <L_TestLink_References>(context, HashFunctions.MD5, null, DVKeyCaching.Disabled);
var loadDate = DateTime.Now;
// REFERENCE ENTRY - inserting and data persistence tests
var load1Key = referenceRepo.Insert(LoadInfo1);
var load2Key = referenceRepo.Insert(LoadInfo2);
var hubList = referenceRepo.Get();
Assert.NotEmpty(hubList);
Assert.Equal(2, hubList.Count());
Assert.False(load1Key == default);
Assert.False(load2Key == default);
var loadInfo = referenceRepo.Get(x => x.PrimaryKey == load2Key).Single();
Assert.Equal(LoadInfo2.RecordSource, loadInfo.RecordSource);
Assert.Equal(LoadInfo2.LoadedBy, loadInfo.LoadedBy);
// HUB - referencing
TestHub1 = hubRepo.Insert(TestHub1, loadDate, loadReference: LoadInfo1);
TestHub2 = hubRepo.Insert(TestHub2, loadDate, loadReference: LoadInfo2);
Assert.Equal(load1Key, TestHub1.LoadReference);
Assert.Equal(load2Key, TestHub2.LoadReference);
// SATELLITE - referencing
Hub1Satellite1 = satelliteRepo.Insert(Hub1Satellite1, loadDate, loadReference: LoadInfo1);
Hub2Satellite1 = satelliteRepo.Insert(Hub2Satellite1, loadDate, loadReference: LoadInfo2);
Assert.Equal(load1Key, Hub1Satellite1.LoadReference);
Assert.Equal(load2Key, Hub2Satellite1.LoadReference);
var satelliteList = satelliteRepo.GetCurrent();
Assert.NotEmpty(satelliteList);
Assert.Equal(2, satelliteList.Count());
// LINK - referencing
Link1 = linkRepo.Insert(Link1, loadDate, loadReference: LoadInfo1);
Assert.Equal(load1Key, Link1.LoadReference);
Link1 = linkRepo.Get().Single();
Assert.Equal(load1Key, Link1.LoadReference);
}
}
public void LinkKeyCaching()
{
//Caching enabled -> same key is ignored
using (var context = TestDwhDbContext.CreateDWHDbContext()) {
var keyCache = new BasePrimaryKeyCache();
var hubRepo = new HubRepository <H_TestHub_Default>(context, HashFunctions.MD5, null);
var linkRepo = new LinkRepository <L_TestLink_Default>(context, HashFunctions.MD5, keyCache, DVKeyCaching.Enabled);
var loadDate = DateTime.Now;
hubRepo.Insert(hubs, loadDate);
//single insert
var insertedLink = linkRepo.Insert(new L_TestLink_Default(hub1.PrimaryKey, hub2.PrimaryKey), loadDate);
// same key again
var insertedLink2 = linkRepo.Insert(new L_TestLink_Default(hub1.PrimaryKey, hub2.PrimaryKey), loadDate);
Assert.Equal(insertedLink.PrimaryKey, insertedLink2.PrimaryKey);
var queriedLinks = linkRepo.Get();
Assert.NotNull(queriedLinks);
Assert.Single(queriedLinks);
}
//caching disabled -> insert throws exception
using (var context = TestDwhDbContext.CreateDWHDbContext()) {
var hubRepo = new HubRepository <H_TestHub_Default>(context, HashFunctions.MD5, null);
var linkRepo = new LinkRepository <L_TestLink_Default>(context, HashFunctions.MD5, null, DVKeyCaching.Disabled);
var loadDate = DateTime.Now;
hubRepo.Insert(hubs, loadDate);
//single insert
var insertedLink = linkRepo.Insert(new L_TestLink_Default(hub1.PrimaryKey, hub2.PrimaryKey), loadDate);
// same key again
Assert.Throws <InvalidOperationException>(() => linkRepo.Insert(new L_TestLink_Default(hub1.PrimaryKey, hub2.PrimaryKey), loadDate));
}
}
public void KeyCalculation()
{
using (var context = TestDwhDbContext.CreateDWHDbContext()) {
var keyCache = new BasePrimaryKeyCache();
var hubRepo = new HubRepository <H_TestHub_Default>(context, HashFunctions.MD5, null);
var linkRepo = new LinkRepository <L_TestLink_Default>(context, HashFunctions.MD5, keyCache, DVKeyCaching.Enabled);
var loadDate = DateTime.Now;
hubRepo.Insert(hubs, loadDate);
L_TestLink_Default link = new L_TestLink_Default(hub1.PrimaryKey, hub2.PrimaryKey);
//single insert
var insertedLink = linkRepo.Insert(link, loadDate);
Assert.Equal(HashFunctions.MD5(link.GetBusinessKeyString()), insertedLink.PrimaryKey);
}
}
private async void gridView1_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
tblLink link = e.Row as tblLink;
if (link == null)
{
return;
}
link.Type = UserManagement.UserSession.Type;
if (link.Id > 0)
{
await rpLink.Update(link);
}
else
{
await rpLink.Insert(link);
}
}
public ActionResult LinkFormPost()
{
try
{
CreateRepos();
string url = Request["url"];
LinkRepo.Insert(Request["url"], int.Parse(Session["UserId"].ToString()), Request["source"], Request["taget"], Request["name"], Request["summary"]);
return(Redirect("/link"));
}
catch (Exception ex)
{
Console.Write(ex);
return(Content("Xảy ra lỗi hệ thống ! Vui lòng thử lại."));
}
finally
{
DisposeRepos();
}
}
public bool CreateDefaults()
{
bool aboutIsEmpty = AboutRepository.IsEmpty().GetAwaiter().GetResult();
//aboutIsEmpty = false;
if (aboutIsEmpty == false)
{
return(false);
}
if (aboutIsEmpty)
{
try
{
var newAbout = new About
{
created_at = DateTime.Now,
updated_at = DateTime.Now,
photo = $@"http://res.cloudinary.com/djqq6o8su/image/upload/mkvg51472rnjves4etg0",
title = "Mr Photographer",
desc = "Photographer based in Somewhere"
};
AboutRepository.Insert(newAbout);
SaveAsync().GetAwaiter().GetResult();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
}
bool galleryIsEmpty = GalleryRepository.IsEmpty().GetAwaiter().GetResult();
//galleryIsEmpty = false;
if (galleryIsEmpty)
{
try
{
string[] names = new string[] { "People", "Landscape" };
foreach (var name in names)
{
var newItem = new Gallery
{
created_at = DateTime.Now,
updated_at = DateTime.Now,
name = name
};
GalleryRepository.Insert(newItem);
}
SaveAsync().GetAwaiter().GetResult();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
}
bool linkIsEmpty = LinkRepository.IsEmpty().GetAwaiter().GetResult();
//linkIsEmpty = false;
if (linkIsEmpty)
{
try
{
string[] names = new string[] { "yourfacebookname", "yourinsntagramname", "yourtwittername", "youryourtubename" };
foreach (var name in names)
{
var newItem = new Link
{
created_at = DateTime.Now,
updated_at = DateTime.Now,
name = name
};
LinkRepository.Insert(newItem);
}
SaveAsync().GetAwaiter().GetResult();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
}
bool logoIsEmpty = LogoRepository.IsEmpty().GetAwaiter().GetResult();
//logoIsEmpty = false;
if (logoIsEmpty)
{
try
{
string[] photos = new string[] { "http://res.cloudinary.com/djqq6o8su/image/upload/iwrwnlkuxlbypgdn05kp" };
foreach (var photo in photos)
{
var newItem = new Logo
{
created_at = DateTime.Now,
updated_at = DateTime.Now,
photo = photo
};
LogoRepository.Insert(newItem);
}
SaveAsync().GetAwaiter().GetResult();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
}
bool slideIsEmpty = SlideRepository.IsEmpty().GetAwaiter().GetResult();
//slideIsEmpty = false;
if (slideIsEmpty)
{
try
{
string[] names = new string[]
{
"http://res.cloudinary.com/djqq6o8su/image/upload/rrcbpzjxm5mesjptu9lc",
"http://res.cloudinary.com/djqq6o8su/image/upload/iib9veyowj3wpyirbmlo",
"http://res.cloudinary.com/djqq6o8su/image/upload/qgo6zbmwwd0kyanaoynz"
};
foreach (var name in names)
{
var newItem = new Slide
{
created_at = DateTime.Now,
updated_at = DateTime.Now,
name = name
};
SlideRepository.Insert(newItem);
}
SaveAsync().GetAwaiter().GetResult();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
}
bool photoIsEmpty = PhotoRepository.IsEmpty().GetAwaiter().GetResult();
//photoIsEmpty = false;
if (photoIsEmpty)
{
try
{
string[] names = new string[]
{
"http://res.cloudinary.com/djqq6o8su/image/upload/tub2v7olse0lwbq9vzrv",
"http://res.cloudinary.com/djqq6o8su/image/upload/hvxogea37wkzqv5o6kkv",
"http://res.cloudinary.com/djqq6o8su/image/upload/dp62d2vwochkoy2y82ee",
"http://res.cloudinary.com/djqq6o8su/image/upload/lifml3ceohhebylxgue6",
"http://res.cloudinary.com/djqq6o8su/image/upload/ki6pdlhihsvaakimfnml",
"http://res.cloudinary.com/djqq6o8su/image/upload/itwquw92jfpht6yi1ilk",
"http://res.cloudinary.com/djqq6o8su/image/upload/jplpld8tp4bxvskdpdzr"
};
string[] names2 = new string[]
{
"http://res.cloudinary.com/djqq6o8su/image/upload/vp8ahga7g1h8f6zx2d0x",
"http://res.cloudinary.com/djqq6o8su/image/upload/ozljewvxh83ahvob1aml",
"http://res.cloudinary.com/djqq6o8su/image/upload/tgrcyaoqx8jwi7mksakd",
"http://res.cloudinary.com/djqq6o8su/image/upload/nnsii3wvw6gn40qcldwf",
"http://res.cloudinary.com/djqq6o8su/image/upload/e23tgxmvw8jkeje3apjk",
"http://res.cloudinary.com/djqq6o8su/image/upload/tb0rpo4gvhxv0cyyb31z",
"http://res.cloudinary.com/djqq6o8su/image/upload/k90gojfb903m7hoknvs5",
"http://res.cloudinary.com/djqq6o8su/image/upload/yqmqqvltyfgt6wbza9zg",
"http://res.cloudinary.com/djqq6o8su/image/upload/vrlwiz6u8gcrygbruzw3",
"http://res.cloudinary.com/djqq6o8su/image/upload/xapqjqz9vs5kwhqh0cr5"
};
var galleryPeople = GalleryRepository.GetAsync(item => item.name == "People").GetAwaiter().GetResult().FirstOrDefault();
var galleryLandscape = GalleryRepository.GetAsync(item => item.name == "Landscape").GetAwaiter().GetResult().FirstOrDefault();
foreach (var name in names)
{
var newItem = new Photo
{
created_at = DateTime.Now,
updated_at = DateTime.Now,
name = name,
Gallery = galleryPeople
};
PhotoRepository.Insert(newItem);
}
foreach (var name in names2)
{
var newItem = new Photo
{
created_at = DateTime.Now,
updated_at = DateTime.Now,
name = name,
Gallery = galleryLandscape
};
PhotoRepository.Insert(newItem);
}
SaveAsync().GetAwaiter().GetResult();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
}
bool userIsEmpty = UserManager.Users.Count() == 0;
if (userIsEmpty)
{
//var user = new ApplicationUser
//{
// ApiToken = "some",
// UserName = "******",
// Email = "*****@*****.**",
// EmailConfirmed = true,
// DateAdd = DateTime.Now,
// DateUpd = DateTime.Now
//};
//await UserManager.CreateAsync(user, "admin");
ApplicationDbInitializer.SeedRoles(RoleManager);
ApplicationDbInitializer.SeedUsers(UserManager, appSettings);
//await SaveAsync();
//new SignInManager<User>().SignInAsync
//UserManager.Users.ToList().ForEach( async(user)=> {
// await _userManager.DeleteAsync(user);
//});
}
if (aboutIsEmpty || galleryIsEmpty || linkIsEmpty || logoIsEmpty || photoIsEmpty || slideIsEmpty || userIsEmpty)
{
return(true);
}
else
{
return(false);
}
}