MVC-application with Web n Mobile

http://www.asp.net/whitepapers/add-mobile-pages-to-your-aspnet-web-forms-mvc-application

Custom Helpers in Asp.net MVC4

http://www.codeproject.com/Tips/832640/Custom-Helpers-in-Asp-net-MVC

Software Design/Architecture

1. Quick overview on object oriented programming and concept.

2. What is software design?

3. What is software architecture? What are roles of a software architecture?

4. Who needs an architect?

5. Is design dead?

6. Refactoring – What, Why, When & How?

7. What is code smell and types of code smell?

8. Unit Testing and Test Driven Development overview

9. Design Patterns:

a. Creational Patterns

i. Abstract Factory

ii. Builder

iii. Factory Method

iv. Prototype

v. Singleton

b. Structural Patterns

i. Adapter

ii. Bridge

iii. Composite

iv. Decorator

v. Façade

vi. Flyweight

vii. Proxy

c. Behavioral Patterns

i. Chain of Responsibility

ii. Command

iii. Interpreter

iv. Iterator

v. Mediator

vi. Memento

vii. Observer

viii. State

ix. Strategy

x. Template Method

xi. Visitor

10. Design Principles

a. Single Responsibility Principle (SRP)

b. Open Closed Principle (OCP)

c. Liskov Substitution Principle (LSP)

d. Interface Segregation Principle (ISP)

e. Dependency Inversion Principle (DIP)

f. DRY – Don’t Repeat yourself

g. Once and only once

h. Tell Don’t Ask

i. The Law of Demeter

j. Inversion of Control

k. Dependency Injection

Request Query String Protection

HTTP Request Query String Protection

http://www.codeproject.com/Articles/20404/HTTP-Request-Query-String-Protection

AJAX in MVC using jQuery and JSON Object

AJAX in MVC using jQuery and JSON Object

In previous post I have expalined about the difference between Webforms and MVC. In this post I am gonna help you on how to implement AJAX in MVC using jQuery.

Before starting with AJAX in MVC, lets have quick glance at what Ajax is all about.

What is AJAX? 

• AJAX is an acronym for 'Asynchronous JavaScript and XML'. It is a technique for creating fast and dynamic web pages.
• AJAX allows to update specific parts of web pages asynchronously by exchanging small amounts of data with the server behind the scenes (request from UI get the modified data back from server). It is possible to update parts of a web page, without reloading the whole page.
• Classic web pages, (which do not use AJAX) must reload the entire page if the content should change.
• Examples of applications using AJAX: Google Maps, Gmail, Youtube, and Facebook tabs.

Earlier, XML is used to exchange the data with Server, ie using XMLHttpRequest object. But these days JSON(JavaScript Object Notation) is used to send and receive the data from UI to server. 

What is JSON?

JSON is short for JavaScript Object Notation, It is a lightweight data-interchange format that is easy for humans to read and write, and for machines to parse and generate. JSON is based on the object notation of the JavaScript language. However, it does not require JavaScript to read or write because it is a text format that is language independent. Its more like key-value pair.

 Here is the example for JSON which is equivalent of XML.

Ajax in MVC:

Ajax in MVC can be used in two ways, one is using unobtrusive java script and other one is using jQuery Ajax. Lets concentrate on jQuery Ajax.

To perform Ajax using jQuery we use $.ajax() method. There are different shorter forms $.ajax() of to perform specific operations.

• To Load data - $.load()
• To Get data - $.get()
• To Post data - $.post()

These operations are having limited options. So we do use generalized AJAX if we want to have more control.

Ajax syntax is explained below.

     $.ajax({

            url: url,

            type: 'POST',

            data: Data,

            dataType: 'json',

            contentType: "application/json; charset=utf-8",

            success: function (result) {

            },

            error: function failCallBk(XMLHttpRequest, textStatus, errorThrown) {

                alert("Some error occured while processing your request.");

            }

        });

**url: Type: String 

It is pointing to Action method in your controller. It will be having value like "Area/Controller/Action"

  

**type: Type: String

 Ajax type is defined using type GET to get the data, POST is to post data.

** data: Type: PlainObject or String or Array

This optional parameter represents an object whose properties are serialized into properly encoded parameters to be passed to the request. If specified, the request is made using the POST method. If omitted, the GET method is used.

**dataType: (xml, json, script, or html) Represents what kind of data you are you're expecting back from the server. If none is specified, jQuery will try to infer it based on the MIME type of the response (an XML MIME type will yield XML, in 1.4 JSON will yield a JavaScript object, in 1.4 script will execute the script, and anything else will be returned as a string).

**contentType (default: 'application/x-www-form-urlencoded; charset=UTF-8')
Type: String
When sending data to the server, use this content type. Default is "application/x-www-form-urlencoded; charset=UTF-8", which is fine for most cases. If you explicitly pass in a content-type to $.ajax(), then it is always sent to the server (even if no data is sent). The W3C XMLHttpRequest specification dictates that the charset is always UTF-8; specifying another charset will not force the browser to change the encoding.

These are the basic parameters, there are many other parameters also you can use to optmiize the request based on your requirement.

For an example, lets assume a typical situation where you want to submit your form data. Consider you want to submit your first name and last name.

Here are the steps to submit data using AJAX and JSON Object.

View Code: 

<table>

    <tr>

        <td>

            First name

            <br />

            @Html.TextBox("FirstName", "", new { id = "firstName" })

        </td>

        <td>

            Last Name

            <br />

            @Html.TextBox("LastName", "", new { id = "lastName" })

        </td>

        <td>

            <button type="submit" id="submitData">Submit Data</button>

        </td>

    </tr>

</table>

Model Code: 

 public class UserDataViewModel

    {

        public string FirstName { get; set; }

        public string LastName { get; set; }

    }

Controller Code where Ajax will be pointing:

     [HttpPost]

     public JsonResult SubmitUserData(UserDataViewModel userData)

        {

            /* To use the UserDataViewModel  dierctly here make sure that 

               you create JSON data in AJAX in the same way.

               Property names should be same in both model aswell as in the JSON object

             */

       

            // Perform your actions here.

            return Json("data submitted");

            

        }

jQuery Code:

        //Get First and Last Name.

        var firstName = $("#firstName").val();

        var lastName = $("#lastName").val();

        // create JSON Object

        var ajxUserData = {

            "FirstName":firstName,

            "LastName":lastName

        }

        // Then stringify data

        var data = JSON.stringify({ userData: ajxUserData });

        //Then Create URL

        var url = "User/UserData/SubmitUserData" // User is a AreaName, UserData is a Controller and SubmitUserData is ActionMethod

        $.ajax({

            url: url,

            type: 'POST',

            data: data,

            dataType: 'json',

            contentType: "application/json; charset=utf-8",

            success: function (result) {

                // In result you will get result that you return, for this example you get "data submitted"

            },

            error: function failCallBk(XMLHttpRequest, textStatus, errorThrown) {

                alert("Some error occured while processing your request.");

            }

        });

    });

Hope this helps.! Happy Coding.
Please do like and share it, if you find it useful.

http://www.spinyourworldbyjaw.blogspot.in/2014/09/ajax-in-mvc-using-jquery-and-json-object.html

Internet

Debug

Immediate Window

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

HTML

<html>
<a href='http://localhost:3769/Users/FileDownLoad.aspx?FilePathID=11029' target='_blank'>test</a>
</html>


tml>
<a href='http://http://192.168.1.95:8888/Users/FileDownLoad.aspx?FilePathID=11029' target='_blank'>test</a>
</html>

Handling multiple submit buttons on the same form - MVC

http://www.dotnet-tricks.com/Tutorial/mvc/cM1X161112-Handling-multiple-submit-buttons-on-the-same-form---MVC-Razor.html

AngularJS

http://www.codeproject.com/Articles/803294/Part-Introduction-to-AngularJS

http://www.codeproject.com/Articles/869433/AngularJS-MVC-Repository

MVC questions

http://www.codeproject.com/Articles/556995/MVC-interview-questions-with-answers

What is the difference between each version of MVC

http://www.dotnetlibrary.com/InterviewQa/GetInterviewQa?interviewQaId=48

ASP.Net MVC Authentication

 http://www.codeproject.com/Articles/578374/AplusBeginner-splusTutorialplusonplusCustomplusF

http://www.itorian.com/2013/11/customize-users-profile-in-aspnet.html

ASP.Net MVC Image

http://www.asp.net/web-pages/tutorials/files,-images,-and-media/9-working-with-images

ASP.Net Grid

Grid with inner grid(collapsible show hide) and file 


  <%@ Page Title="" Language="C#" MasterPageFile="~/MasterPages/Census.master" AutoEventWireup="true"
    Inherits="Users_PlanDocument" CodeBehind="PlanDocument.aspx.cs" %>

<%@ Import Namespace="JulyUtilities" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentTitle" runat="Server">
    Plan Document
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" runat="Server">
    <script src="../ClientScript/OnlineDocument.js" type="text/javascript"></script>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="MainContent" runat="Server">
    <div style="border: solid 0px red; padding: 10px 10px 10px 10px;">
        <table border="0" cellpadding="0" cellspacing="0" width="100%" style="background-color: #fff;
            border-bottom: solid 0px #cbcaca;">
            <tr>
                <td class="TableContainerMiddle">
                    <div style="width: 20px; float: left; padding-left: 5px;">
                        <img src="../App_Themes/<%=Session["CurrentTheme"] %>/Images/Icon/title_icon.png"
                            alt="" />
                    </div>
                    <div class="Title_CSS" style="padding-left: 30px;">
                        Plan Document Files
                    </div>
                </td>
            </tr>
            <tr>
                <td colspan="0" class="containerBorderLR">
                    <%--  <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                        <ContentTemplate>--%>
                    <div style="padding: 10px 10px 10px 10px;">
                        <asp:GridView ID="gvPlanDocumentsInfo" Width="100%" GridLines="None" runat="server"
                            AutoGenerateColumns="False" CssClass="mGridDataRequest" AlternatingRowStyle-CssClass="alt"
                            AllowPaging="True" DataKeyNames="PlanDocId" PageSize="10" EmptyDataText="Record Not Available"
                            OnPageIndexChanging="gvPlanDocuments_PageIndexChanging" OnRowDataBound="gvPlanDocumentsInfo_RowDataBound"
                            PagerStyle-CssClass="gridViewPager">
                            <Columns>
                                <asp:TemplateField>
                                    <ItemTemplate>
                                        <a href="javascript:switchViews('div<%# Eval("PlanDocId") %>', 'one');">
                                            <img id="imgdiv<%# Eval("PlanDocId") %>" alt="Click to show/hide orders" border="0"
                                                src="../App_Themes/<%=Session["CurrentTheme"] %>/Images/Icon/minus-2.png" />
                                        </a>
                                    </ItemTemplate>
                                    <HeaderStyle Width="4%" />
                                    <ItemStyle Width="4%" />
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Project Type">
                                    <ItemTemplate>
                                        <a href="javascript:switchViews('div<%# Eval("PlanDocId") %>', 'one');"><span id="imgdiv<%# Eval("PlanDocId") %>">
                                            <%# Eval("ProjectType")%></span> </a>
                                        <asp:Image ID="Image1" ImageUrl="~/Images/new.gif" runat="server" Visible='<%# Eval("HasNewFile") %>' />
                                    </ItemTemplate>
                                    <HeaderStyle Width="20%" />
                                    <ItemStyle Width="20%" />
                                </asp:TemplateField>
                                <asp:BoundField DataField="SubType" HeaderText="Sub Type">
                                    <HeaderStyle Width="18%" />
                                    <ItemStyle Width="18%" />
                                </asp:BoundField>
                                <asp:BoundField DataField="ProjectDesc" HeaderText="Project Description" />
                                <asp:BoundField DataField="DateEffective" HeaderText="Effective Date" DataFormatString="{0:MM/dd/yyyy}">
                                    <HeaderStyle Width="14%" />
                                    <ItemStyle Width="14%" />
                                </asp:BoundField>
                                <asp:TemplateField>
                                    <ItemTemplate>
                                        <tr>
                                            <td colspan="100%" style="border: solid 0px red;">
                                                <div id="div<%# Eval("PlanDocId") %>" style="display: none; position: relative; left: 12px;">
                                                    <asp:GridView ID="gvPlanDocumentsFileInfo" Width="100%" GridLines="None" runat="server"
                                                        AutoGenerateColumns="False" CssClass="mGridDataRequest" AlternatingRowStyle-CssClass="alt"
                                                        EmptyDataText="Record Not Available">
                                                        <Columns>
                                                            <asp:TemplateField HeaderText="File Name">
                                                                <ItemTemplate>
                                                                    <div style="width: 100%; border: solid 0px blue;">
                                                                        <div style="width: 5%; height: 10px; float: left; border: solid 0px red;">
                                                                            <img src='<%# clsStyle.GetIconSrcByExtension(System.IO.Path.GetExtension(Eval("FilePath").ToString())) %>'
                                                                                alt="" />
                                                                        </div>
                                                                        <div style="border: solid 0px red; float: left; width: 95%">
                                                                            <%-- <asp:HyperLink ID="lnkFileName" runat="server" NavigateUrl='<%# WebApp.GetClientPortalFilesUrl(Eval("FilePath").ToString()) %>'
                                                                                        Target="_blank" Text='<%# Eval("FileName").ToString().Replace("_", "-") %>'></asp:HyperLink>--%>
                                                                            <asp:LinkButton ID="lnkFileName" runat="server" Text='<%# Eval("FileName").ToString().Replace("_", "-") %>'
                                                                                CommandName='<%# Eval("FilePathID") %>' CommandArgument='<%# Eval("FilePath") %>'
                                                                                OnClick="lnkFileName_Click" />
                                                                            <%--<img id="img" src='<%# clsStyle.GetIconSrcByDate(Eval("DateUpload").ToString()) %>'
                                                                                alt="" />--%>
                                                                            <asp:Image ID="Image1" ImageUrl="~/Images/new.gif" runat="server" Visible='<%# Eval("HasNewFile") %>' />
                                                                        </div>
                                                                    </div>
                                                                </ItemTemplate>
                                                                <HeaderStyle Width="45%" />
                                                                <ItemStyle Width="45%" />
                                                            </asp:TemplateField>
                                                            <asp:BoundField DataField="FileDescription" HeaderText="File Description">
                                                                <HeaderStyle Width="30%" />
                                                                <ItemStyle Width="30%" />
                                                            </asp:BoundField>
                                                            <asp:BoundField DataField="FileCategory" HeaderText="File Category">
                                                                <HeaderStyle Width="25%" />
                                                                <ItemStyle Width="25%" />
                                                            </asp:BoundField>
                                                        </Columns>
                                                        <AlternatingRowStyle CssClass="alt"></AlternatingRowStyle>
                                                        <PagerStyle CssClass="pgr" />
                                                    </asp:GridView>
                                                </div>
                                            </td>
                                        </tr>
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                        </asp:GridView>
                    </div>
                    <%--  </ContentTemplate>
                    </asp:UpdatePanel>--%>
                    <div style="padding-left: 102px; padding-bottom: 10px;">
                    </div>
                    <div style="padding: 10px 0 5px 0px;">
                        &nbsp;
                    </div>
                </td>
            </tr>
            <tr>
                <td colspan="0" class="containerBottom" style="border-right: solid 0px red;">
                    &nbsp;
                </td>
            </tr>
        </table>
        <script type="text/javascript">
            $(document).ready(function () {
                $('img[src=""]').css('display', 'none');
            });
        </script>
    </div>
</asp:Content>

 ***************************************************
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using July.BusinessServiceLayer.Facades;
using July.BusinessServiceLayer.Entities;
using July.BusinessServiceLayer.Helpers;
using JulyUtilities;

public partial class Users_PlanDocument : BasePage
{
    List<PlanDocument> planDocuments = new List<PlanDocument>();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindPlanDocument();
        }
    }

    private void BindPlanDocument()
    {
        PlanDocumentService _planDocumentsService = new PlanDocumentService();
        planDocuments = _planDocumentsService.GetAllPlanDocuments(Convert.ToInt32(Page.CurrentWebUser().CurrentPlan.PlanID));


        var comparer = new EqualityComparerUtil<PlanDocument>((arg1, arg2) => { return arg1.PlanDocId.EqualsIgnoreCase(arg2.PlanDocId); },
                                                                 (arg) => arg.PlanDocId.GetHashCode());

        var distinct = planDocuments.Distinct(comparer);

        gvPlanDocumentsInfo.DataSource = distinct.ToList();
        gvPlanDocumentsInfo.DataBind();
    }

    protected void gvPlanDocuments_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvPlanDocumentsInfo.PageIndex = e.NewPageIndex;
        BindPlanDocument();
    }

    protected void gvPlanDocumentsInfo_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            GridView gv = e.Row.FindControl("gvPlanDocumentsFileInfo") as GridView;
            var data = from f in planDocuments where f.PlanDocId == gvPlanDocumentsInfo.DataKeys[e.Row.RowIndex].Value.ToString() select f;
            //var data = from f in planDocuments where f.PlanDocId == gvPlanDocumentsInfo.DataKeys[e.Row.RowIndex].Value.ToString() orderby f.DateEffective,f.HasNewFile descending select f;
            gv.DataSource = data.ToList();
            gv.DataBind();
        }
    }

    protected void lnkFileName_Click(object sender, EventArgs e)
    {
        LinkButton lnkDownLoad = new LinkButton();
        lnkDownLoad = (LinkButton)sender;
        FileDownload fileDownload = new FileDownload();
        fileDownload.FilePathID = Convert.ToInt32(lnkDownLoad.CommandName);
        fileDownload.DownloadedBy = Convert.ToInt32(Page.CurrentWebUser().Contact.ContactId);

        string path = lnkDownLoad.CommandArgument;

        System.IO.FileInfo file = new System.IO.FileInfo(path);

        if (file.Exists)
        {
            if (new FileDownloadService().InsertFileDownloadHistory(fileDownload))
            {
                Response.Clear();
                Response.ContentType = "application/ms-word";
                //Modified by Mamun Issue # 17 (Error: Found Duplicate Headers error in Chrome)
                Response.AddHeader("Content-Disposition", "attachment; filename=\"" + lnkDownLoad.Text + "\"");
                //End Issue # 17
                Response.TransmitFile(path);
                Response.End();
            }
        }
        else
        {
            ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "FileDownload", "alert('This file does not exist.')", true);
        }
    }
}

*******************************OnlineDocument.js**********************************

// -------- Expand/Close row when click on button
function switchViews(obj, row) {
    var div = document.getElementById(obj);
    var img = document.getElementById('img' + obj);
     var $currentTheme = $("input[id$='hidCurentTheme']");
     var plusUrl = null;
     var minusUrl = null;
   
     plusUrl = '../App_Themes/' + $currentTheme.val() + '/Images/Icon/plus-2.png';
     minusUrl = '../App_Themes/' + $currentTheme.val() + '/Images/Icon/minus-2.png';
   
    if (div.style.display == "none") {
        div.style.display = "inline";
        if (row == 'alt') {

            img.src = minusUrl; //"../Images/minus-2.gif";
            mce_src = plusUrl; //"../Images/plus-2.gif";
        }
        else {
            img.src = plusUrl;//"../Images/plus-2.gif";
            mce_src = minusUrl; //"../Images/minus-2.gif";
        }
        img.alt = "Close to view other Plan";
    }
    else {
        div.style.display = "none";
        if (row == 'alt') {
            img.src = plusUrl; //"../Images/plus-2.gif";
            mce_src = plusUrl;  //"../Images/plus-2.gif";
        }
        else {
            img.src = minusUrl; //"../Images/minus-2.gif";
            mce_src = minusUrl ;//"../Images/minus-2.gif";
        }
        img.alt = "Expand to show File";
    }
}

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