using System;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

    }

}

​

​

using System;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

    }

}

​

​

​

​

​

​

2 Tables.  

​

Table 1     FSA_BDP_Session         Table 2   FSA_BDP_Caller

SessionKey (Primary Key)

CallerKey   -------------------------------------     CallerKey

StudentSSN                  SSN

BorrowerType                    FirstName

etc                     MiddleName

                        LastName

                        DOB

                        Address

​

​

C#/asp.Net 

​

Private string SessionKey

{

    get { return hidSessionKey.Value }

              set { hidSessionKey.Value = value; }

}

Private string SessionKey

{

    get { return hidCallerKey.Value }

              set { hidCallerKey.Value = value; }

}

Private bedBDP.BdpSession CallSession {get { return Main.Bed.BDp.Session(SessionKey); } }

Private bedBDP.BdpSession CallSession1 {get { return Main.Bed.BDp.Session(CallerKey); } }

Public void Launch (string sessionkey)

{

SessionKey = sessionkey;

CallerKey = CallerKey;

upPdem.Visible =  true;

BindData();

}

​

protected void btnSave_Click(object sender, EventArgs e)

{

Try

{

corSQL = Main.BED.CORE.SQLIntranet;

if (CallerKey == null)

{

conn.ExecuteSP(“spBED_BDP_Main”, conn.SqlParameter(“QueryID”, “SavNewSession”),

conn.ExecuteSP(“spBED_BDP_Main”, conn.SqlParameter(“QueryID”, “savNewCaller”),

​

’SavNewCaller’ ’SavNewSession’conn.SqlParameter(“@FirstName”, txtFirstName.Text),

conn.SqlParameter(“@MiddleName”, txtMiddleName.Text),

conn.SqlParameter(“@LastName”, txtLastName.Text),

conn.SqlParameter(“@StudentSSN”, txtSSN.Text),

conn.SqlParameter(“@SSN”, txtSSN.Text),

conn.SqlParameter(“@DOB”, txtDOB.Text),

conn.SqlParameter(“@Phone”, txtPhone.Text),

conn.SqlParameter(“@Address”, txtDOB.Text),

conn.SqlParameter(“@CreatedBy”, Main.BED.Core.UserId),

conn.SqlParameter(“@Email”, txtEmail.Text)).Tables[0].Rows[0][0].ToString();

}

if (CallerKey != null)

​

{

conn.ExecuteSP(“spBED_BDP_Main”, conn.SqlParameter(“QueryID”, “UpdateSession”),

​

conn.SqlParameter(“@FirstName”, txtFirstName.Text),

conn.SqlParameter(“@MiddleName”, txtMiddleName.Text),

conn.SqlParameter(“@LastName”, txtLastName.Text),

conn.SqlParameter(“@StudentSSN”, txtSSN.Text),

conn.SqlParameter(“@SSN”, txtSSN.Text),

conn.SqlParameter(“@DOB”, txtDOB.Text),

conn.SqlParameter(“@Phone”, txtPhone.Text),

conn.SqlParameter(“@Address”, txtDOB.Text),

conn.SqlParameter(“@CreatedBy”, Main.BED.Core.UserId),

conn.SqlParameter(“@Email”, txtEmail.Text)).Tables[0].Rows[0][0].ToString();

}

Main.Bed.Core.LogSuccess();

}

Catch (Exception ex)

​

StoredProcedure

​

else if @QueryID=’SavNewSession’

begin

    insert into FSA_BDP_Session (InteractionID, Student SSN, FirstTime, LoanType, BDSchoolKey, SchoolCOde, Prior20140620, TransferCredit, BDDischarge, ForbREquested, Servicers, Notes, NSLDSByKey, NSLDSTime, SessionType)

    values  (@InteractionID, @Student@SSN, FirstTime, @LoanType, @BDSchoolKey, @SchoolCOde, @Prior20140620, @TransferCredit, @BDDischarge, @ForbREquested, @Servicers, @Notes, @NSLDSByKey, @NSLDSTime, @SessionType);

select SCOPE_IDENTITY();

else if @QueryID=’SavNewCaller’

    begin

insert into FSA_BDP_Caller (CallerType, SSN, FirstNAme, MIddleName, LastName, DOB, Phone< Email, Address, CreatedBy)

values (@CallerType, @SSN, @FirstNAme, @MIddleName, @LastName, @DOB, @Phone, @Email, @Address, @CreatedBy);

select SCOPE_IDENTITY();

​

​

​

else if @QueryID=’UpdateSession’

begin

    update FSA_BDP_Caller set SSN=@SSN, FirstName=@FirstName,  MIddleName=@ MIddleName, LastName=@LastName, DOB=@DOB, Phone= @Phone, Email=@Email, Address=@Address, CreatedBy=@CreatedBy, where CallerKey=@CallerKey

end

​