C#
Get Monthly Balance Trend
1. getMonthlyBalanceTrend.cs
These four packages are required to be used.
Step 1. Create class file to store content of the web response.
2. GetMonthlyBalanceTrend.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, both header and content are 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 ‘getMonthlyBalanceTrend’ class.
Step 5. Obtain error code. If error code is ‘010000’ which means invocation successful, populate attributes of the ‘getMonthlyBalanceTrend’ class into the Grid View and Label. 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 getMonthlyBalanceTrend.cs
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace Demo
{
public class gmbtRootObject
{
public gmbtContent Content { get; set; }
}
public class gmbtContent
{
public gmbtServiceResponse ServiceResponse { get; set; }
}
public class gmbtServiceResponse
{
public TrendData TrendData { get; set; }
public gmbtServiceRespHeader ServiceRespHeader { get; set; }
}
public class gmbtServiceRespHeader
{
public string ErrorText { get; set; }
public object ErrorDetails { get; set; }
public string GlobalErrorID { get; set; }
}
public class TrendData
{
[JsonConverter(typeof(ArrayConverter<MonthEndBalance>))]
public List<MonthEndBalance> MonthEndBalance { get; set; }
public CurrentMonth CurrentMonth { get; set; }
}
public class CurrentMonth
{
public string Year_Month { get; set; }
public string Balance { get; set; }
}
public class MonthEndBalance
{
public string Year_Month { get; set; }
public string Balance { get; set; }
}
}
Overview of getMonthlyBalanceTrend.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 GetMonthlyBalanceTrend : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
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)
{
gvGetMonthlyBalanceTrend.DataSource = null;
gvGetMonthlyBalanceTrend.DataBind();
try
{
string userID = txtUserID.Text;
Session["userid"] = userID;
string pin = txtPassword.Text;
Session["pin"] = pin;
string accountID = txtAccountID.Text;
string numMonths = txtnumMonths.Text;
string otp;
if (Session["otp"] == null)
{
otp = "1";
}
else
{
otp = Session["otp"].ToString();
}
var header = new HeaderJson();
header.userID = userID;
header.PIN = pin;
header.serviceName = "getMonthlyBalanceTrend";
header.OTP = otp;
var headerJson = new HeaderJsonObject();
headerJson.Header = header;
string strHeader = JsonConvert.SerializeObject(headerJson);
var content = new ContentJson();
content.accountID = accountID;
content.numMonths = numMonths;
var contentJson = new ContentJsonObject();
contentJson.Content = content;
string strContent = JsonConvert.SerializeObject(contentJson);
string url = "http://tbankonline.com/SMUtBank_API/Gateway?Header=" + strHeader + "&Content=" + strContent;
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();
}
gmbtRootObject gmbt = new gmbtRootObject();
gmbt = JsonConvert.DeserializeObject<gmbtRootObject>(result);
string globalErrorID = gmbt.Content.ServiceResponse.ServiceRespHeader.GlobalErrorID.ToString();
if (globalErrorID == "010000")
{
if (gmbt.Content.ServiceResponse.TrendData.MonthEndBalance == null)
{
lblTest.Text = "No Record";
lblCurrentBalance.Text = gmbt.Content.ServiceResponse.TrendData.CurrentMonth.Balance.ToString();
lblCurrentYearMonth.Text = gmbt.Content.ServiceResponse.TrendData.CurrentMonth.Year_Month.ToString();
return;
}
int counter = gmbt.Content.ServiceResponse.TrendData.MonthEndBalance.Count();
DataTable dt = new DataTable();
DataColumn col1 = new DataColumn(" ", typeof(string));
DataColumn col2 = new DataColumn("Balance", typeof(string));
DataColumn col3 = new DataColumn("Year_Month", typeof(string));
dt.Columns.Add(col1);
dt.Columns.Add(col2);
dt.Columns.Add(col3);
// 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] = gmbt.Content.ServiceResponse.TrendData.MonthEndBalance[i].Balance.ToString();
dt.Rows[i][col3] = gmbt.Content.ServiceResponse.TrendData.MonthEndBalance[i].Year_Month.ToString();
}
gvGetMonthlyBalanceTrend.DataSource = dt;
gvGetMonthlyBalanceTrend.DataBind();
lblCurrentBalance.Text = gmbt.Content.ServiceResponse.TrendData.CurrentMonth.Balance.ToString();
lblCurrentYearMonth.Text = gmbt.Content.ServiceResponse.TrendData.CurrentMonth.Year_Month.ToString();
}
else if (globalErrorID == "010041")
{
otp = utilities.newOTP();
Session["otp"] = otp;
}
else
{
lblTest.Text = gmbt.Content.ServiceResponse.ServiceRespHeader.ErrorText.ToString();
string errorMessage = gmbt.Content.ServiceResponse.ServiceRespHeader.ErrorDetails.ToString();
lblErrorMessage.Text = errorMessage;
}
}
catch (Exception ex)
{
lblExceptionMsg.Text = ex.ToString();
}
}
}
}
}
Created with the Personal Edition of HelpNDoc: What is a Help Authoring tool?