Website Translation Architecture And Implementation?
Mar 18, 2011
I'm conducting a project in which a website should have multi-language support.Now, this website is supposed to serve about 500K+ visitors a day, so it must be super-efficient.
I've created a table of parameters {[ID],[Name]} AND a linkage-table {[objectID],[parameterID],[languageID],[value]}. I think it's the best way to deploy multi-language support while having the privilege to translate different parameters for each language.
As far as I know, server's memory is much faster than a physical HDD. Therefore, I'm planning to store ASP.NET Application State objects for my translation architecture.[URL]
View 3 Replies
Similar Messages:
Apr 28, 2010
I have implemented the 3-tier architecture project; DAL, BAL, and presentation layer are three layers in it. I am going to implement the following scenario:
Presentation layer calls to a function in the BAL layer which returns 2 string variable, and in turn this function from BAL layer calls to a DAL layer function which also returns 2 string variable. How can I implement the above scenario?
View 2 Replies
Feb 7, 2011
Are there any tools out there which I can use to implement the Entity Translation Pattern? I dont want to write all the mappings by hand.
View 2 Replies
Feb 27, 2011
I'm fairly new to dependency injection but it seems like a proper DI implementation will be fairly complex.
For example, DI requires a centralized class that manages the configuration and resolves the dependencies at runtime.
DI is also based on the concept of using interfaces. For example, a SpecialLogger should use an ILogger interface.
The centralized DI manager class will need to register types - for example, associate ILogger to SpecialLogger.
SpecialLogger will also need to implement the ILogger interface so SpecialLogger can be used through the DI ILogger interface.
Therefore, it seems like a sln using DI will need multiple projects to support DI. Here is an example for logging:
* MyCompany.MyDivision.Framework.DI.Management - this would have the DI manager where dependency types are registered and resolved at runtime
* MyCompany.MyDivision.Framework.Logging - this would have the implementation of a logging class. The main logging class would need to implement ILogger.
* MyCompany.MyDivision.Framework.DI.Interfaces - this would have the ILogger interface.
Interfaces would need to be stored in a separate class library from the DI manager because both the DI manager and SpecialLogger use the ILogger interface. Since the DI manager associates SpecialLogger to ILogger a circular reference would be encountered without a separate class library to store the ILogger interface.
View 1 Replies
Feb 28, 2011
I have been learning C# for the last year or so and trying to incorporate best practices along the way. Between StackOverflow and other web resources, I thought I was on the right track to properly separating my concerns, but now I am having some doubts and want to make sure I am going down the right path before I convert my entire website over to this new architecture.
The current website is old ASP VBscript and has a existing database that is pretty ugly (no foreign keys and such) so at least for the first version in .NET I do not want to use and have to learn any ORM tools at this time.
I have the following items that are in separate namespaces and setup so that the UI layer can only see the DTOs and Business layers, and the Data layer can only be seen from the Business layer. Here is a simple example:
[Code]....
Am I completely off base? Should I also have the same properties in my BLL and not pass back DTOs to my UI? what is wrong and what is right. Keep in mind I am not a expert yet.
I would like to implement interfaces to my architecture, but I am still learning how to do that.
View 4 Replies
Feb 15, 2011
I am working on a web application project with a layered architectural style having DAL, BLL, Service Layer and Presentation Layer. It's going to be a Web forms application.
My intent is to try using some of the new features of .Net 3.5 or 4.0.
Currently, I am thinking through different approaches for implementing Authentication in this project.
I have a query regarding the design of the application, particularly Authentication.
In which layer should I have Authentication class? BLL? If I implement the Authentication class in BLL, should I be having an app.config in the same class library project to contain the Database connection string and all.
View 7 Replies
Feb 16, 2010
In a project im working on there are many sql tables containing different ID, Name pairs. Those are represented as Enums in classes that need them however that requires casting since tables contain ID only.Also when serialize the Enum contains the ID not value.
View 3 Replies
Jul 22, 2010
not sure if I'm posting to the right thread or not.. but here is the questiondoes anyone know how to implement a best pratice on SEO?One of the example is: if the user types "brand new canon camera" then I want the system to find a sequence of string in the database that contains "new", "cannon", "camera". It is ok with or without the word "brand". However if the user types "HP laptop DV1000" and i want the system to find all HP laptop whether new or not but limited to specific series.
View 3 Replies
Jul 19, 2010
I am searching for the advantages and disadvantages of the explicit interface implementation
View 1 Replies
Feb 10, 2010
I am in the process of redesigning our main product, a knowledge database system for clients to access clinical and specialist advice articles. There is a requirement to add "Social Networking" to this allowing users to connect and post remarks etc...
This is somewhat similar to the Facebook wall scenario - where Articles, Photos, Groups, Products, Events, ActivityFeed can all have comments. I am at a lose as to the database design I would need to implement this. All comments must allow for Moderation/Approval/Spam Reporting etc...
I originally thought a individual table for each Comments entity ex: ArticleComment, ProductComment would work as the comments themselves are not all directly related. Each table having the same exact columns. But this makes life abit awkward as then this creates a separation between something that for all purposes is the same i.e. They are all comments.
The other design idea was to have a single Comment table with an "arc" type relationship to related tables with FK references back to the source.
The other option was to have a single Comment table with an Object Type and XID but this breaks the rules of relation and does not all for referential integrity.
I am at a lose and don't know what to do. I have asked over at SQLCentral.com and all I have done is raised more questions than answers about what to do.
Design 1: This would require exact copies of this table for all the entities.
-- Photo Comments --
CREATE TABLE dbo.PhotoComment
(
CommentID int IDENTITY(1,1) NOT NULL,
PhotoID int NOT NULL,
Body ntext NOT NULL,
ReportedAsSpam bit NOT NULL CONSTRAINT [DF_PhotoComment_ReportedAsSpam] DEFAULT (0),
IsSpam bit NOT NULL CONSTRAINT [DF_PhotoComment_IsSpam] DEFAULT (0),
IsApproved bit NOT NULL CONSTRAINT [DF_PhotoComment_IsApproved] DEFAULT (1),
CreatedDate datetime NOT NULL,
CreatedBy uniqueidentifier NOT NULL,
UpdatedDate datetime NOT NULL,
UpdatedBy uniqueidentifier NOT NULL,
IsDeleted bit NOT NULL CONSTRAINT [DF_PhotoComment_IsDeleted] DEFAULT (0),
CONSTRAINT [PK_PhotoComment] PRIMARY KEY (CommentID),
CONSTRAINT [FK_PhotoComment_PhotoID] FOREIGN KEY (PhotoID) REFERENCES dbo.Photo(PhotoID),
CONSTRAINT [FK_PhotoComment_CreatedBy] FOREIGN KEY (CreatedBy) REFERENCES dbo.aspnet_Users(UserId),
CONSTRAINT [FK_PhotoComment_UpdatedBy] FOREIGN KEY (UpdatedBy) REFERENCES dbo.aspnet_Users(UserId)
)
Design 2: The "Arc" relationship
CREATE TABLE dbo.Comment
(
CommentID int IDENTITY(1,1) NOT NULL,
CommentType char(1) NOT NULL CHECK(CommentType IN ('A','I','E','G','U','P')),
Body ntext NOT NULL,
ReportedAsSpam bit NOT NULL CONSTRAINT [DF_Comment_ReportedAsSpam] DEFAULT (0),
IsSpam bit NOT NULL CONSTRAINT [DF_Comment_IsSpam] DEFAULT (0),
IsApproved bit NOT NULL CONSTRAINT [DF_Comment_IsApproved] DEFAULT (1),
CreatedDate datetime NOT NULL,
CreatedBy uniqueidentifier NOT NULL,
UpdatedDate datetime NOT NULL,
UpdatedBy uniqueidentifier NOT NULL,
IsDeleted bit NOT NULL CONSTRAINT [DF_Comment_IsDeleted] DEFAULT (0),
CONSTRAINT [PK_Comment] PRIMARY KEY (CommentID),
CONSTRAINT [FK_Comment_CreatedBy] FOREIGN KEY (CreatedBy) REFERENCES dbo.aspnet_Users(UserId),
CONSTRAINT [FK_Comment_UpdatedBy] FOREIGN KEY (UpdatedBy) REFERENCES dbo.aspnet_Users(UserId),
CONSTRAINT [UC_Comment_CommentID_CommentType] UNIQUE (CommentID, CommentType)
)
-- Article Comments --
CREATE TABLE dbo.ArticleComment
(
ArticleID int NOT NULL,
CommentID int NOT NULL,
CommentType char(1) CONSTRAINT [DF_ArticleComment_CommentType] DEFAULT 'A', CHECK (CommentType = 'A'),
CONSTRAINT [PK_ArticleComment] PRIMARY KEY CLUSTERED (ArticleID, CommentID),
CONSTRAINT [FK_ArticleComment_ArticleID] FOREIGN KEY (ArticleID) REFERENCES dbo.Article(ArticleID),
CONSTRAINT [FK_ArticleComment_CommentID] FOREIGN KEY (CommentID) REFERENCES dbo.Comment(CommentID),
CONSTRAINT [FK_ArticleComment_CommentID_CommentType] FOREIGN KEY (CommentID, CommentType) REFERENCES dbo.Comment(CommentID, CommentType)
)
Design 3: The one that breaks the rules
CREATE TABLE dbo.Comment
(
CommentID int IDENTITY(1,1) NOT NULL,
ObjectType char(1) NOT NULL, /* A = Article, P = Photo etc... */
XID int NOT NULL, /* Would be the ID of the main entity being queried. */
Body ntext NOT NULL,
ReportedAsSpam bit NOT NULL CONSTRAINT [DF_Comment_ReportedAsSpam] DEFAULT (0),
IsSpam bit NOT NULL CONSTRAINT [DF_Comment_IsSpam] DEFAULT (0),
IsApproved bit NOT NULL CONSTRAINT [DF_Comment_IsApproved] DEFAULT (1),
CreatedDate datetime NOT NULL,
CreatedBy uniqueidentifier NOT NULL,
UpdatedDate datetime NOT NULL,
UpdatedBy uniqueidentifier NOT NULL,
IsDeleted bit NOT NULL CONSTRAINT [DF_Comment_IsDeleted] DEFAULT (0),
CONSTRAINT [PK_Comment] PRIMARY KEY (CommentID),
CONSTRAINT [FK_Comment_CreatedBy] FOREIGN KEY (CreatedBy) REFERENCES dbo.aspnet_Users(UserId),
CONSTRAINT [FK_Comment_UpdatedBy] FOREIGN KEY (UpdatedBy) REFERENCES dbo.aspnet_Users(UserId),
CONSTRAINT [UC_Comment_CommentID_ObjectType_XID] UNIQUE (CommentID, ObjectType, XID)
)
-- Ex: Get all comments for article ID 23.
SELECT * FROM Comment Where ObjectType ='A' and XID = '23'
View 1 Replies
Jun 2, 2010
I want a program that can keep track of all components that need translation (labels, strings, fields), and then I can give the pieces to a person to translate and gather the translated text back into to the program and it will compile all of the text into a new application in the foreign language. I did find Sisulizer (a localization tool) but it doesnt work with Asp.net Controls properly.
View 4 Replies
Jul 25, 2012
How to create a forum in my website??
View 1 Replies
Nov 29, 2010
Currently I am implementing print functionality in a website. Can any one tell me what are the best practice to implement this?
View 2 Replies
Jan 7, 2011
I want to put my website project and admin website under same project as I want to use session and authentication of the main site. Also I want to show the admin, the page, where he has made changes. But the problem is whenever I will change anything in admin pages, I've to build the entire website. I don't want to do that. Can I build that separately?
I don't want to choose the option of building all pages separately as well.
Is there any alternatives of doing that. Separate projects for admin and website will come up with many other challenges. So I would like to avoid that.
View 2 Replies
May 22, 2010
I'm in the middle-end of written a big website that work a lot with the db.
In every call a page runs 5-12 different queries.What I did was build an execute class that uses MySqlConnector API, which get string that represent the sql and the parameters and then just execute the query and return DataTable. In addition to that I have a class that hold all the function that call the execute class functions. For example in the class I have getAllProducts, getOldestProducts etc... and in each and every one of them theres sql statements.
Recently I watch the LINQ video series(How Do I with LINQ - on this site) and it looked good.As I sees it my way is very good because it just open connection execute the sql get the result and close the connection.The question is what is the best performance wise way to build this site? Is it my way that I use all along? Is it using LINQ? Or working with DataSet/TypedDataSet is the preferred way?
View 4 Replies
Mar 30, 2010
How to build a web application using ASP.NET , this web app isa portal and i can edit in the interface of each web page at runtime ,[URL]How can i do that ???? , is that require sharepoint WSS , sharepoint designer , PathInfo , Forms server ????And if that web app require these apps , how can i use them to build web app like , i looking for a tutorial
View 1 Replies
Nov 15, 2010
We are using a .net web application and my environment is as follows:-
SERVER : Server: Windows 2003
.NET FRAMEWORK : 3.5
ASP.NET FRAMEWORK : ASP.NET 2.0
Template used : ASP.NET Web application project ( not a web site)
I have code in global.asax.cs which is like below. This code dynamically loading the web.config. Is this right? Since the deployment accidentally the web.config been copied mutlitple times (in past) which was bringin uat web.config to prod and causing the prod to point to uat databae, we did this way, i.e dynamically reading the param values from a file and loading them to web.config dynamically.
Is this right? The web site is loosing connection string once a while and making the site to go down. One thing i noticed is in DEV / QA / UAT we have the ASP.NET version tab in iis set to 2.0, but in prod it's been set to 1.1. I told them to change, but somebody arguing how it worked for a while and suddenly stopped. I don't know the answer. Could somebody tell me or point me to a direction to fix this.
private void LoadConfig()
{
string xml = null;
FileStream fs = null;
StreamReader str = null;
System.Xml.XmlDocument xmlDoc = null;
System.Xml.XmlNode xmlNode = null;
EventLog _eventLog = null;
try
{
// Get the Config path from registry, parse and set the static properties of the class.
string configFile = CompName.CoreLib.SystemUtilities.RegistryUtility.ReadValue("ConfigPath") + @"ApplSettingsConfig.xml";
//string configFile = @"C:" + @"Common.Config";
// Read the XML Config File
fs = File.OpenRead(configFile);
str = new StreamReader(fs);
xml = str.ReadToEnd();
str.Close();
fs.Close();..............................
View 2 Replies
Dec 21, 2010
I've been all around the net for weeks now trying to figure out the best way to set up a Multi-tenant website (building a web app that multiple companies and their employees will use). As far as a database goes, I am interested in using one database with a copied set of tables for each company. As far as managing the login and security in MVC2 I am lost with the myriad of examples (mostly old and not MVC) that I have seen. So ideally my app would allow a company rep to register their company and then be able to add their own employees to the site. Then all employees could login and be securely associated with their own company's tables (table names would be appended with their AccountID).
I'm not sure if this would be handled using routing or session variables or what the more ideal and up to date methods might be. Like others who have discussed this issue, it seems like this should be a much more fleshed out solution as it is becoming a more common use on the internet. I'm even willing to simplify the database down to one set of tables that stores an AccountID in each row if needed.
View 1 Replies
Jul 28, 2010
I have a ASP.net website, i have a page, based on the query string, i grab certain information from database and display the image.
I need create a javascript to put in the javascript in otherwebsite, and then this image will display in that website.
The functionality is same as good ads something like below.
<script type="text/javascript"><!--
google_ad_client = "......";
/* Ad for AdSelector */
google_ad_slot = "....";
google_ad_width = 1;
google_ad_height = 2;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
View 4 Replies
Oct 11, 2010
I need to create a search engine for my website that searches my entire content and files stored in a database.What is the best way and easy to accomplish this?If can, please provide a few samples or links.
View 4 Replies
Mar 26, 2011
I reffer users from my website to another website (not my own website, I dont have any access to code).How can I detect a user registered in this website I have reffered to....
View 2 Replies
Jul 23, 2010
There are various website speed test online tools available. Few of them are listed on: [URL] I tested my website using iweb and selfseo. My website is showing 0.03KB Average speed per KB everywhere. Even google also is giving same kind of results.I tested the site using Page Speed and YSlow. I have already followed most of the recommendations suggested by these tools like efficient use CSS, contents across the domains, caching, compression and all. But still I am getting the same average speed per kb. Page speed is showing around 85/100 as my page speed score, so I guess I have optimized my site a lot. My questions here are:
1. What are the other factors affecting the avg speed per kb of a website?
2. How to improve the Avg speed per kb?
3. Is there anything related with the Server Software and Hardware that I have to check?
Note: I tested by uploading a plain html page with simple text "Hello World", but the avg speed per kb is the same for this page as well. Same is the case with the rest of the pages.
Application Platform : ASP.Net 3.5, C#3.0, LINQ as Data Access, SQL Server 2008
Server Platform : Windows Server 2003.
View 2 Replies
Aug 5, 2010
I want to create a suite of three products. One is a website, so that is set in stone. Another is a mobile application, so that will be written as an application (for whatever devices). The third product is something that the user can use locally on their machine. However, I'm not sure if I want to make it a desktop application or a local website. With a desktop application, if I make a significant change to my business rules, I have to make it in three places (assuming the dll change needs a GUI change). However, if I make it a local website, then almost everything would be the same as the regular website. Desktop applications seem to provide more controls that are easier to use though. And since I'm taking this project on alone (right now) easy sounds best. But I don't want to sacrifice easy now for easy later.
The website I want to write will be using MVC architecture. I'm not even sure how to deploy a website yet either to a server or to a local machine. The only thing I've done was set up a local website before for a website that was already created in house by my co-workers. And that was solely ASP.Net, no MVC architecture.
My questions are:What do you guys think would be best in the long run; a local website that mimics the regular website or a desktop application?
Is there a way to create an install package to install a website so the user doesn't have to tinker with their computer at all?
View 4 Replies
Feb 25, 2010
A classic scenario for you to ponder over and feedback to me.I have been requsted to create a website. So far so good.But the site will have a total of 1 (ONE) page only.The page itself will only contain a form that users will submit.it will:1 - Register the details in the form into a single database table.2 - Send an email out to the customer and form admin to processI am thinking 2 ways of doing this:Plan A - Create the usual asp.net website with only one page saving directly onto database table.Plan B - Create a HTML page only,use javascript to send the data to a WCF service, which processes and saves the data.
View 3 Replies
Jul 29, 2010
anyone kind enough to transcribe this php to ASP.NET ??
<?php
if(isset($_POST['data']) && $_POST['data'] != '') {
$output = $_POST['data'];
$newfile = time() . ".xml";
$file = fopen ($newfile, "w");
fwrite($file, $output);
fclose ($file);
echo 'file created: ' . $newfile;
} else {
View 2 Replies
