C#

Features ›› Wealth ›› getCustomerStocks ›› Sample Code ››
Parent Previous Next

Get Customer Stocks


1. getCustomerStocks.cs


These five packages are required to be used.




Step 1. Create class file to store content of the web response.





2. GetCustomerStocks.aspx.cs


These 15 packages are required to be used.




Code in Common

(1). Check if user id and password is inside session. When the user id and password is inside user session, it will automatically populate into the user id and pin textbox, so that the user need not manually type his user id and password repeatedly.




Step 2. Store details entered by the user. If user id, password, and OTP exist in session, user need not enter again (refer to common stuff).




Step 3. Create URL which will be post to the server. User inputs need to be stored in the class created, and serialize into JSON format. In this function, only header is needed.




Step 4. Post to the server, and store response. URL is sent using web request function, and a response will be send back from the server. The response need to be deserialized into the ‘getCustomerStocks’ class.




Step 5. Obtain error code. If error code is ‘010000’ which means invocation successful, populate attributes of the ‘getCustomerStocks’ class into the Label and Gridview. If error code is '010041', it means OTP has expired, and we will use the newOTP() function to prompt the user for the OTP again. Else, we will display the ErrorText and ErrorDetails.


The newOTP() function can be referred to under Common Stuff Section




Overview of getCustomerStocks.cs


using Newtonsoft.Json;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;


namespace Demo

{

   public class getCustomerStocksDepository

   {

       public string symbol { get; set; }

       public string quantity { get; set; }

       public string price { get; set; }

       public string tradingDate { get; set; }

       public string customerID { get; set; }

   }


   public class getCustomerStocksDepositoryList

   {

       [JsonConverter(typeof(ArrayConverter<getCustomerStocksDepository>))]

       public List<getCustomerStocksDepository> Depository { get; set; }

   }


   public class getCustomerStocksServiceRespHeader

   {

       public string ErrorText { get; set; }

       public object ErrorDetails { get; set; }

       public string GlobalErrorID { get; set; }

   }


   public class getCustomerStocksServiceResponse

   {

       public getCustomerStocksDepositoryList DepositoryList { get; set; }

       public getCustomerStocksServiceRespHeader ServiceRespHeader { get; set; }

   }


   public class getCustomerStocksContent

   {

       public getCustomerStocksServiceResponse ServiceResponse { get; set; }

   }


   public class getCustomerStocksRootObject

   {

       public getCustomerStocksContent Content { get; set; }

   }

}


Download



Overview of GetCustomerStocks.aspx.cs


using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using DotNetOpenAuth.OAuth2;

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using System.Collections.Specialized;

using System.Configuration;

using System.Net;

using System.IO;

using System.Windows.Forms;

using System.Data;


namespace Demo

{

   public partial class GetCustomerStocks : System.Web.UI.Page

   {

       protected void Page_Load(object sender, EventArgs e)

       {

           if (Page.IsPostBack == false)

           {

               if (Session["userid"] != null)

               {

                   txtUserID.Text = (string)Session["userid"];

                   txtPassword.Text = (string)Session["pin"];

               }

           }

       }


       protected void btnSend_Click(object sender, EventArgs e)

       {

           if (Page.IsValid)

           {

               gvCustomerStocks.DataSource = null;

               gvCustomerStocks.DataBind();


               try

               {

                   string userID = txtUserID.Text;

                   Session["userid"] = userID;

                   string pin = txtPassword.Text;

                   Session["pin"] = pin;


                   string otp;

                   if (Session["otp"] == null)

                   {

                       otp = "";

                   }

                   else

                   {

                       otp = Session["otp"].ToString();

                   }


                   var header = new HeaderJson();

                   header.userID = userID;

                   header.PIN = pin;

                   header.serviceName = "getCustomerStocks";

                   header.OTP = otp;

                   var headerJson = new HeaderJsonObject();

                   headerJson.Header = header;

                   string strHeader = JsonConvert.SerializeObject(headerJson);


                   string url = "http://tbankonline.com/SMUtBank_API/Gateway?Header=" + strHeader;


                   var webRequest = (HttpWebRequest)WebRequest.Create(url);

                   webRequest.ContentType = "application/json";

                   webRequest.Method = "POST";


                   var result = "";

                   var httpResponse = (HttpWebResponse)webRequest.GetResponse();

                   using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))

                   {

                       result = streamReader.ReadToEnd();

                   }


                   getCustomerStocksRootObject CS = new getCustomerStocksRootObject();

                   CS = JsonConvert.DeserializeObject<getCustomerStocksRootObject>(result);


                   string globalErrorID = CS.Content.ServiceResponse.ServiceRespHeader.GlobalErrorID.ToString();


                   if (globalErrorID == "010000")

                   {

                       int counter = CS.Content.ServiceResponse.DepositoryList.Depository.Count();

                       DataTable dt = new DataTable();

                       DataColumn col1 = new DataColumn("  ", typeof(string));

                       DataColumn col2 = new DataColumn("Symbol", typeof(string));

                       DataColumn col3 = new DataColumn("Quantity", typeof(string));

                       DataColumn col4 = new DataColumn("Price", typeof(string));

                       DataColumn col5 = new DataColumn("Trading Date", typeof(string));

                       DataColumn col6 = new DataColumn("Customer ID", typeof(string));


                       dt.Columns.Add(col1);

                       dt.Columns.Add(col2);

                       dt.Columns.Add(col3);

                       dt.Columns.Add(col4);

                       dt.Columns.Add(col5);

                       dt.Columns.Add(col6);


                       // put data into the data table

                       for (int i = 0; i <= counter - 1; i++)

                       {

                           DataRow row = dt.NewRow();

                           dt.Rows.Add(row);

                           dt.Rows[i][col1] = i + 1;


                           //dt.Rows[i][col2] = CS.Content.ServiceResponse.DepositoryList.Depository[i].symbol?.ToString() ?? " ";

                           string symbolname = CS.Content.ServiceResponse.DepositoryList.Depository[i].symbol?.ToString() ?? " ";

                           var z = utilities.getStockSymbols();

                           for (int x = 0; x < z.Count(); x++)

                           {

                               if (symbolname == z[x].symbol)

                               {

                                   dt.Rows[i][col2] = z[x].company;

                               }

                           }


                           dt.Rows[i][col3] = CS.Content.ServiceResponse.DepositoryList.Depository[i].quantity?.ToString() ?? " ";

                           dt.Rows[i][col4] = CS.Content.ServiceResponse.DepositoryList.Depository[i].price?.ToString() ?? " ";

                           dt.Rows[i][col5] = CS.Content.ServiceResponse.DepositoryList.Depository[i].tradingDate?.ToString() ?? " ";

                           dt.Rows[i][col6] = CS.Content.ServiceResponse.DepositoryList.Depository[i].customerID?.ToString() ?? " ";

                       }

                       gvCustomerStocks.DataSource = dt;

                       gvCustomerStocks.DataBind();

                   }

                   else if (globalErrorID == "010041")

                   {

                       otp = utilities.newOTP();

                       Session["otp"] = otp;

                   }

                   else

                   {

                       lblTest.Text = CS.Content.ServiceResponse.ServiceRespHeader.ErrorText.ToString();

                       string errorMessage = CS.Content.ServiceResponse.ServiceRespHeader.ErrorDetails.ToString();

                       lblErrorMessage.Text = errorMessage;

                   }

               }

               catch (Exception ex)

               {

                   lblExceptionMsg.Text = ex.ToString();

               }

           }

       }

   }

}


Download

Created with the Personal Edition of HelpNDoc: Benefits of a Help Authoring Tool