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 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 async Task LinkRepositoryCRUDTest()
{
var context = new NoodleDbContext("NoodleDb");
context.Init();
ILinkRepository repository = new LinkRepository(context);
var id = Guid.NewGuid();
var record = new Link
{
Id = id,
ReferenceId = Guid.Empty,
Uri = "test"
};
await repository.CreateAsync(record);
record.Uri = "U_" + record.Uri;
await repository.UpdateAsync(record);
var record2 = await repository.GetByIdAsync(id);
Assert.AreEqual(record.Id, record2.Id);
Assert.AreEqual(record.Uri, record2.Uri);
await repository.DeleteAsync(record.Id);
var record3 = await repository.GetByIdAsync(id);
Assert.IsNull(record3);
}
protected void Delete_Click(object sender, EventArgs e)
{
Link link = LinkRepository.FindById(DataUtility.ParseInt(QsLinkId));
LinkRepository.Delete(link);
Response.Redirect(Cancel.NavigateUrl);
}
protected void Page_Load(object sender, EventArgs e)
{
_pager = new PagerHelper(GetCurrentPage(), GetPageSize(), LinkRepository.GetCount());
Links.DataSource = LinkRepository.CreateQuery(
"from Link l order by l.Category.Name, l.Name"
).SetFirstResult(_pager.CurrentRow).SetMaxResults(_pager.PageSize).List();
Links.DataBind();
}
public void OnGet(int id)
{
if (id > 0)
{
LinkRepository lRepository = new LinkRepository(connectionString);
Link = lRepository.Get(id);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
var repo = new LinkRepository();
gridLinks.DataSource = repo.GetAll();
gridLinks.DataBind();
}
}
public TodoAppDbContext(DbContextOptions options) : base(options)
{
context = this;
CategoryRepository = new CategoryRepository(context);
SubCategoryRepository = new SubCategoryRepository(context);
TodoRepository = new TodoRepository(context);
NoteRepository = new NoteRepository(context);
LinkRepository = new LinkRepository(context);
FileRepository = new FileRepository(context);
}
private static LinkRepository InitializeCosmosClientInstance(LinkConfig linkConfig)
{
Microsoft.Azure.Cosmos.Fluent.CosmosClientBuilder clientBuilder = new Microsoft.Azure.Cosmos.Fluent.CosmosClientBuilder(linkConfig.ConnectionString);
Microsoft.Azure.Cosmos.CosmosClient client = clientBuilder
.WithConnectionModeDirect()
.Build();
LinkRepository linkRepository = new LinkRepository(client, linkConfig.DatabaseName, linkConfig.ContainerName);
return(linkRepository);
}
public frmPrimary()
{
InitializeComponent();
dbPath = string.Empty;
folderImg = string.Empty;
db = Init();
rpLink = new LinkRepository(db);
rpMovie = new MovieRepository(db);
rpInfo = new InfoRepository(db);
}
public BookService(
DefaultDbContext context,
BookRepository bookRepository,
TagRepository tagRepository,
LinkRepository linkRepository)
: base(context)
{
_bookRepository = bookRepository;
_tagRepository = tagRepository;
_linkRepository = linkRepository;
}
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 OnGet(Guid id)
{
if (id != null)
{
LinkRepository linkRepository = new LinkRepository(connectionString);
Link = linkRepository.Get(id);
if (Link != null)
{
FileRepository fileRepository = new FileRepository(connectionString);
File = fileRepository.Get(Link.FileId);
}
}
}
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);
}
}
private static void ConfigureUniqueIdentifierGenerator()
{
string firstId = String.Empty;
using (var linkRepository = new LinkRepository(new LinkDataContext()))
{
var link = linkRepository.LastOrDefault();
if (link != null)
{
firstId = link.Id;
}
}
UniqueIdGenerator.Configure(firstId);
}
public IEnumerable <SSRSDto> GetSSRSReportsBySchoolID(int schoolID)
{
var query =
from x in DocumentRepository.All()
join y in LinkRepository.All() on x.DocumentID equals y.DocumentID
where x.DocumentTypeID == 2 && y.SchoolID == schoolID
select new SSRSJoin {
DocumentID = x.DocumentID, DocumentName = x.DocumentFilename,
DocumentTypeID = (int)x.DocumentTypeID, ExtraReportParameters = y.ExtraReportParameters, TopicID = y.TopicID, SchoolID = (int)y.SchoolID
};
var data = Mapper.Map <IEnumerable <SSRSJoin>, IEnumerable <SSRSDto> >(query.AsEnumerable());
return(data);
}
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);
}
}
public static async Task Main(string[] args)
{
Console.OutputEncoding = System.Text.Encoding.UTF8;
LinkRepository linkRepository = new LinkRepository();
LinkFilter linkFilter = new LinkFilter();
LinkService linkService = new LinkService(linkRepository);
LinkView linkView = new LinkView();
LinkController linkController = new LinkController(linkService, linkView);
linkController.StartWork();
}
private void CreateRepos()
{
mEntities = new V308CMSEntities();
ProductRepos = new ProductRepository(mEntities);
ProductRepos.PageSize = PageSize;
ProductHelper.ProductShowLimit = ProductRepos.PageSize;
AccountRepos = new AccountRepository(mEntities);
NewsRepos = new NewsRepository(mEntities);
CommentRepo = new TestimonialRepository(mEntities);
CategoryRepo = new CategoryRepository(mEntities);
LinkRepo = new LinkRepository(mEntities);
BannerRepo = new BannerRepository(mEntities);
TicketRepo = new TicketRepository(mEntities);
CouponRepo = new CouponRepository(mEntities);
CouponRepo.PageSize = PageSize;
}
public ILinkRepository <TEntity> GetLinkRepository <TEntity>() where TEntity : IDvLinkEntity, new()
{
if (_repositories == null)
{
_repositories = new Dictionary <Type, object>();
}
var type = typeof(TEntity);
if (!_repositories.ContainsKey(type))
{
_repositories[type] = new LinkRepository <TEntity>(DataVaultContext);
}
return((ILinkRepository <TEntity>)_repositories[type]);
}
protected void btnModify_Click(object sender, EventArgs e)
{
LinkModel link = new LinkModel();
link.Title = this.txtTitle.Value;
link.Url = this.txtUrl.Value;
link.ViewOrder = Convert.ToInt32(this.txtViewOrder.Value);
link.Description = this.txtDescription.Value;
link.Id = Convert.ToInt32(Request["Id"]);
var linkRepo = new LinkRepository();
linkRepo.UpdateLink(link);
this.lblError.Text = "수정되었습니다.";
}
public void TestLinkRecordSaving()
{
RepositoryResult<LinkRecord> response=default(RepositoryResult<LinkRecord>);
var now = DateTime.Now;
using (var scope = new TransactionScope())
{
using (var rep = new LinkRepository())
{
var url = string.Format("https://google.kz?id={0}", (new Random()).Next(int.MaxValue));
response = rep.CreateAndSave(url);
}
}
Assert.IsTrue(response.IsSuccess);
Assert.That(response.Data.Id, Is.GreaterThan(0));
Assert.That(response.Data.CreateDate, Is.GreaterThan(now));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.QueryString["Id"] != null)
{
LinkRepository repo = new LinkRepository();
var toBeEditedLink = repo.GetById(Request.QueryString["Id"].ToSafeInt());
if (toBeEditedLink != null)
{
txtTitle.Text = toBeEditedLink.Title;
txtHref.Text = toBeEditedLink.Href;
}
}
}
}
public IActionResult OnPostSave(int id, string email)
{
if (id > 0)
{
LinkRepository lRepository = new LinkRepository(connectionString);
Link = lRepository.Get(id);
Link.Email = email;
lRepository.Update(Link);
if (!String.IsNullOrEmpty(email))
{
EmailServices eServices = new EmailServices();
eServices.SendLink(email, $"{Request.Scheme}://{this.Request.Host}{this.Request.PathBase}/{Link.Url}");
}
return(RedirectToPage("Index", new { Id = Link.FileId }));
}
return(RedirectToPage("/Error"));
}
private void DisplayData()
{
var repo = new LinkRepository();
var link = repo.GetLink(Convert.ToInt32(Request["Id"]));
if (link != null)
{
this.txtTitle.Value = link.Title;
this.txtUrl.Value = link.Url;
this.txtViewOrder.Value = link.ViewOrder.ToString();
this.txtDescription.Value = link.Description;
}
else
{
lblError.ForeColor = System.Drawing.Color.Red;
lblError.Text = "해당되는 데이터가 없습니다.";
}
}
public static async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)] HttpRequest req,
ILogger log, ExecutionContext context)
{
var config = new ConfigurationBuilder().SetBasePath(context.FunctionAppDirectory).AddJsonFile("local.settings.json", optional: true, reloadOnChange: true).AddEnvironmentVariables().Build();
var connectionString = config.GetConnectionString("ConnectionString");
//log.LogInformation("Connection String:" + connectionString);
//Console.WriteLine(connectionString);
LinkContext.connectionString = connectionString;
string linkOriginal = req.QueryString.Value.Substring(6);
string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
dynamic data = JsonConvert.DeserializeObject(requestBody);
//linkOriginal = linkOriginal ?? data?.name;
Link link = new Link();
link.LinkOriginal = linkOriginal;
string message = "";
string responseMessage;
if (link.ValidateOriginal(ref message))
{
LinkRepository linkRepository = new LinkRepository(new LinkContext());
linkRepository.InsertLink(link);
//Console.WriteLine(link.Status);
responseMessage = JsonConvert.SerializeObject(new { Domain = linkOriginal, ShortenedLink = "https://www.linkmir.com/" + link.LinkShort, Status = link.Status });
return(new OkObjectResult(responseMessage));
}
else
{
responseMessage = message;
return(new BadRequestObjectResult(responseMessage));
}
}
protected void WriteLinks(HtmlTextWriter output)
{
Category currentCategory = null;
IList <Link> links = LinkRepository.CreateQuery(
"from Link l order by l.Category.Name, l.Name"
).List <Link>();
output.RenderBeginTag(HtmlTextWriterTag.Dl);
foreach (Link link in links)
{
if (link.Category != currentCategory)
{
if (currentCategory != null)
{
// Render the end of the DD and UL tags.
output.RenderEndTag();
output.RenderEndTag();
}
currentCategory = link.Category;
output.RenderBeginTag(HtmlTextWriterTag.Dt);
output.WriteEncodedText(currentCategory.Name);
output.RenderEndTag();
output.RenderBeginTag(HtmlTextWriterTag.Dd);
output.RenderBeginTag(HtmlTextWriterTag.Ul);
}
output.RenderBeginTag(HtmlTextWriterTag.Li);
output.AddAttribute(HtmlTextWriterAttribute.Href, link.Url);
output.AddAttribute(HtmlTextWriterAttribute.Target, "_blank");
output.AddAttribute(HtmlTextWriterAttribute.Title, string.Format("Open {0} in a new window", link.Url));
output.RenderBeginTag(HtmlTextWriterTag.A);
output.WriteEncodedText(link.Name);
output.RenderEndTag();
output.RenderEndTag();
}
// Render the end of the DD and UL tags.
output.RenderEndTag();
output.RenderEndTag();
// Render the end of the DL list.
output.RenderEndTag();
}
protected void btnSave_Click(object sender, EventArgs e)
{
LinkModel link = new LinkModel();
link.Title = txtTitle.Value;
link.Url = txtUrl.Value;
link.ViewOrder = Convert.ToInt32(txtViewOrder.Value);
link.Description = txtDescription.Value;
var repo = new LinkRepository();
int result = repo.AddLink(link);
if (result > 0)
{
lblError.Text = "저장 완료";
}
else
{
lblError.Text = "저장되지 않음";
}
}
public IActionResult OnPost(Guid id)
{
if (id != null)
{
LinkRepository linkRepository = new LinkRepository(connectionString);
Link = linkRepository.Get(id);
if (Link != null)
{
FileRepository fileRepository = new FileRepository(connectionString);
File = fileRepository.Get(Link.FileId);
string filePath = env.WebRootPath + File.Path + @"/" + File.Name;
string fileName = File.Name;
byte[] fileBytes = System.IO.File.ReadAllBytes(filePath);
Link.Count++;
linkRepository.Update(Link);
return(File(fileBytes, "application/force-download", fileName));
}
}
return(NotFound());
}
public Link GenerateNewLink(LinkRepository lRepository, int fileId)
{
if (lRepository != null)
{
Link l = new Link();
l.FileId = fileId;
l.Email = "";
l.Count = 0;
l.PublicId = Guid.NewGuid();
while (lRepository.Get(l.PublicId) != null)
{
l.PublicId = Guid.NewGuid();
}
l.Url = "/Files/Download/" + l.PublicId;
l.Id = lRepository.Add(l);
return(l);
}
else
{
return(null);
}
}
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 TestRetrieveByShortLink()
{
using (var scope = new TransactionScope())
{
var now = DateTime.Now;
LinkRecord created = null;
using (var createRep = new LinkRepository())
{
var url = string.Format("http://google.kz?id={0}", (new Random()).Next(int.MaxValue));
var response = createRep.CreateAndSave(url);
created = response.Data;
}
LinkRecord readen = null;
using(var readRep = new LinkRepository())
{
readen = readRep.RetrieveByShortLink(created.ShortLink).Data;
}
Assert.That(readen.Id, Is.EqualTo(created.Id));
Assert.That(readen.OriginalLink, Is.EqualTo(created.OriginalLink));
}
}
