Client Portal

For July and DP Users:

 Update sa_user set IsAccessAllPlans=1 where ContactID=52434  


SELECT * FROM Contacts  where contactId = 10030


select   * from sa_user where contactId=10030


Select * from Plans where PlanName like 'Will J%'--PlanNumber : 453061770

Select * from ProjectFile where AccountID=453061770 order by DateUpload DESC


select * from plans where planclientnumber='0372410'
select   * from ProjectFile where accountId=453065352 and projectid=44147 and webaccess=1

 select * from tblProjectFileTypes

 select * from ProjectFile 

  select * from tblProjectFileCategory

  Select * from projectTable

tblProjectFiles

tblplan_x_ref_webaccess

PlanDocs

tblProjectSubType

tblProjectFiles

tblplan_x_ref_webaccess

PlanDocs

tblProjectSubType

tblProjectFileCategory





192.168.1.66>Run>\\sharebear\Client_Project_Folders\453061578\Allocations\37656\Reviewer Reports\Test Agreement_SIGNED_20131226030858_e2b6ec3e-ddf4-49af-9066-8d82f9b9cc63.pdf



File
select top 100 * from tblprojectfiles where accountId=453061578

select top 100 * from plans where Planname='Test Plan'
https://clientportal.julyservices.com/Users/FileDownLoad.aspx?FilePathID=687198

http://localhost:3769/Users/FileDownLoad.aspx?FilePathID=687198

path=@"C:\Users\rubol\Desktop\CPFinal\PresentationLayer\ClientPortalWebUI\Content\Public\Test.pdf"

SQL

http://www.codeproject.com/Tips/586395/Split-comma-separated-IDs-to-ge

• http://social.msdn.microsoft.com/Forums/vstudio/en-US/34d5bb3d-c2ce-4191-841d-ee6e31212fea/how-to-do-zip-and-unzip-in-c-and-aspnet-by-using-ioniczipdll?forum=netfxbcl
• http://www.aspdotnet-suresh.com/2013/04/aspnet-download-multiple-files-as-zip.html

select * from plans where plannumber=453061339


SELECT * FROM Contacts  where LastName like '%Dilling%'

SELECT * FROM Contacts WHERE COntactID=57411

select   * from sa_user where contactId=22895

select * from tblPlanSpec where plannumber = 453061339


Delete From uestionnaire List
Select * 
From ccCensusUploadHistory Where  Category = 'Questionnaire' and
FinalizedBy = 'Saidur Rahman' and ccStatusID in (23245,23245 )

delete 
From ccCensusUploadHistory Where  Category = 'Questionnaire' and
FinalizedBy = 'Saidur Rahman' and ccStatusID in (23245,23245 )

Select * from ccSoloContributionOwnerInfo where PlanID=453065380
and SoloContributionOwnerInfo_ID=1987


Update ccStatus set SoloContributionOwnerInfo_ID=Null
 where PlanID=453065380 and AllocationNumber=54761


Update ccStatus set erisaCompliance_ID=Null

 where PlanID=453065380 and AllocationNumber=54761


http://support.microsoft.com/kb/813444

http://support.microsoft.com/kb/968089
http://www.techsupportall.com/solved-cannot-access-secure-sites-https-websites-not-opening-view/

http://stackoverflow.com/questions/681695/what-do-i-need-to-do-to-get-internet-explorer-8-to-accept-a-self-signed-certifica

http://msdn.microsoft.com/en-us/library/ff649247.aspx



select * from ProjectFile where filepathid=2528868

update ProjectFile
set WebAccess = 0
where  FilePathID = 2528868

BL Peters, Inc. 401(k) Plan	453064307	Plan Document Files	SP_GetPlanDocumentByPlanID
Test Plan	453061578	Participant Notices	GetParticipantNoticesFiles

Questionnaire

Contributions

select * FROM tblPlanSpec
select * FROM tblPlanSpec_Matching

Ownership Information

Test Plan > 12/12/2030

select * FROM tblCompany where Id=8503

--delete FROM tblCompanyOwnerShip where CompanyId=8503
--delete FROM tblCompanySubsidiaries where CompanyId=8503
--delete FROM tblFamilyRelationship where CompanyId=8503
--delete FROM tblCompanyOfficers where CompanyId=8503

select CompanyOwnershipID,CompanyID,OwnerTypeID,OwnerID,OwnerName,OwnerPercent
FROM tblCompanyOwnerShip where CompanyId=8503

select * FROM tblCompanySubsidiaries where CompanyId=8503

select * FROM tblFamilyRelationship where CompanyId=8503

select * FROM tblCompanyOfficers where CompanyId=8503


All Tables

non-solo:contribution
tblPlanSpec
tblPlanSpec_Matching
solo::contribution
ccSoloOwnerContributions
ccBusinessPartnerSpouse
insertEachPartnerSpouse
insertEachPartnerSpouseFunded
ccOtherEmpContributions
OtherEmployeeContributionsChild

Non-Solo:Erisa
ccErisaCompliance
tblFormW3Info
Solo:Erisa
ccErisaCompliance

Non-Solo:ownership
select * FROM tblCompany
select  * FROM tblCompanyOwnerShip
select * FROM tblCompanySubsidiaries
select * FROM tblFamilyRelationship
select * FROM tblCompanyOfficers

Solo:ownership
select * FROM tblCompany
select  * FROM tblCompanyOwnerShip
select * FROM tblCompanySubsidiaries

select * FROM tblFamilyRelationship


Immediate Window
Local File Path set:
?CensusFileUrl = "\\\\soft-rubol\\SharedRubol\\Test.docx" ;
?CensusFileUrl = "soft-rubol\\SharedRubol\\Test.docx" ;

http://www.aspsnippets.com/Articles/Add-new-Row-to-GridView-on-Button-Click-in-ASPNet.aspx

\\sicem\shared\Data\TPA_Manager\WindwardTemplates\ClientPortal\ComplaianceQuestionSOLO.docx
\\sicem\shared\Data\TPA_Manager\WindwardTemplates\ClientPortal\ComplaianceQuestion.docx