Click here to Skip to main content
15,892,674 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: (untagged)
Please help, making the source code using VS.2010. mvc4 Net, with a SQLServer database, for form Login Multi Company with SQL Stored Procedures. The table-table as follows:

TabelUserPayroll
*CompanyID
*UnitID
*UserLogin
*UserPassword
*ActiveYN

TabelUserPersmissions
*CompanyID
*UnitID
*UserLogin
*IPAddress
*PermissionAccess
*PermissionView
*PermissionAdd
*PermissionEdit
*PermissionDelete
*PermissionReports

TabelMasterCompany
*CompanyID
*UnitID
*NameCompany
*CurrencyID

TabelMasterCompanyUnit
*CompanyID
*UnitID
*UnitNameCompany
*CurrencyID

TabelHeader
*CompanyID
*UnitID
*PurchaseNumber
*Vendor
*WareHouse
*CurrencyID
*Total

TabelDetail
*CompanyID
*UnitID
*PurchaseNumber
*ItemID
*Qty
*Price
Posted
Comments
member60 1-Nov-12 3:41am    
rephrase your question.

1 solution

I work at a company that makes sites for different credit unions / banks. The way we solved this was by identifying each Financial Institution (FI) first by the url and then displaying all related data for that fi.

sampleurl.com/default.aspx?fi=FI1
sampleurl.com/default.aspx?fi=FI2


For the custom theme portion, I created a dynamic CSS stylesheet that contains all of the color information for that fi, like link color, background color images and so on.... All of which is added at runtime. Granted, our approach is using WebForms once having the idea of how things should be laid out converting them to MVC shouldn't be too hard.

Here are some samples:
Obee Credit Union
Our Demo Site
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900