public HttpResponseMessage Put()
{
string jsonData = String.Empty;
if (Util.GetIsAuthenticatedByAuthenADFS())
{
jsonData = Request.Content.ReadAsStringAsync().Result;
}
if (!String.IsNullOrEmpty(jsonData))
{
try {
JObject jsonObject = new JObject(JsonConvert.DeserializeObject <dynamic>(jsonData));
object obj = Util.GetPPIDByAuthenADFS();
string ppid = obj.GetType().GetProperty("ppid").GetValue(obj, null).ToString();
string winaccountName = obj.GetType().GetProperty("winaccountName").GetValue(obj, null).ToString();
jsonObject.Add("personID", (!String.IsNullOrEmpty(ppid) ? ppid : winaccountName));
jsonObject.Add("createdBy", winaccountName);
jsonData = JsonConvert.SerializeObject(jsonObject);
}
catch {
jsonData = String.Empty;
}
}
DataTable dt = TransRegistered.Set("PUT", jsonData).Tables[0];
return(Request.CreateResponse(HttpStatusCode.OK, Util.APIResponse.GetData(dt)));
}
public HttpResponseMessage Get(string cuid = null)
{
string transRegisteredID = String.Empty;
string transProjectID = String.Empty;
string[] cuidArray = Util.CUID2Array(cuid);
if (cuidArray != null)
{
int i = 1;
foreach (var data in cuidArray)
{
if (i.Equals(1))
{
transRegisteredID = data;
}
if (i.Equals(2))
{
transProjectID = data;
}
i++;
}
}
List <object> list = new List <object>();
if (Util.GetIsAuthenticatedByAuthenADFS())
{
object obj = Util.GetPPIDByAuthenADFS();
string ppid = obj.GetType().GetProperty("ppid").GetValue(obj, null).ToString();
string winaccountName = obj.GetType().GetProperty("winaccountName").GetValue(obj, null).ToString();
DataSet ds = TransRegistered.Get(transRegisteredID, (!String.IsNullOrEmpty(ppid) ? ppid : winaccountName), transProjectID);
DataTable dtTransRegistered = ds.Tables[0];
DataTable dtTransInvoiceFee = ds.Tables[1];
DataTable dtTransFeeType = ds.Tables[2];
if (dtTransRegistered.Rows.Count > 0)
{
List <object> listTransRegisters = TransRegistered.GetDataSource("TransRegistered", dtTransRegistered);
List <object> transInvoiceFees = TransRegistered.GetDataSource("TransInvoiceFee", dtTransInvoiceFee);
List <object> transFeeTypes = TransRegistered.GetDataSource("TransFeeType", dtTransFeeType);
JObject transRegistered = new JObject(JsonConvert.DeserializeObject <dynamic>(JsonConvert.SerializeObject(listTransRegisters[0])));
transRegistered.Add("invoiceFee", JToken.FromObject(transInvoiceFees));
transRegistered.Add("transFeeType", JToken.FromObject(transFeeTypes));
list.Add(transRegistered);
}
}
return(Request.CreateResponse(HttpStatusCode.OK, Util.APIResponse.GetData(list)));
}
public HttpResponseMessage GetList(string paymentStatus = null)
{
List <object> list = new List <object>();
if (Util.GetIsAuthenticatedByAuthenADFS())
{
object obj = Util.GetPPIDByAuthenADFS();
string ppid = obj.GetType().GetProperty("ppid").GetValue(obj, null).ToString();
string winaccountName = obj.GetType().GetProperty("winaccountName").GetValue(obj, null).ToString();
DataSet ds = TransRegistered.GetList((!String.IsNullOrEmpty(ppid) ? ppid : winaccountName), paymentStatus);
list = TransRegistered.GetDataSource("TransRegistered", ds.Tables[0]);
}
return(Request.CreateResponse(HttpStatusCode.OK, Util.APIResponse.GetData(list)));
}
public HttpResponseMessage Get(string projectCategory)
{
string jsonData = String.Empty;
if (Util.GetIsAuthenticatedByAuthenADFS())
{
jsonData = Request.Content.ReadAsStringAsync().Result;
}
List <object> list = new List <object>();
if (!String.IsNullOrEmpty(jsonData))
{
int errorCode = 0;
string invoiceID = String.Empty;
string totalFeeAmount = String.Empty;
string lastPaymentDate = String.Empty;
string taxNo = String.Empty;
string suffix = String.Empty;
string billerID = String.Empty;
string ref1 = String.Empty;
string ref2 = String.Empty;
string ref3 = String.Empty;
string campus = String.Empty;
string profitCenter = String.Empty;
string branchNo = String.Empty;
string subBranch = String.Empty;
string merchantName = String.Empty;
string paidAmount = String.Empty;
string paidStatus = String.Empty;
string actionDate = String.Empty;
dynamic qrCodeObj = null;
try {
JObject jsonObject = new JObject(JsonConvert.DeserializeObject <dynamic>(jsonData));
string transRegisteredID = jsonObject["transRegisteredID"].ToString();
string transProjectID = jsonObject["transProjectID"].ToString();
object obj = Util.GetPPIDByAuthenADFS();
string ppid = obj.GetType().GetProperty("ppid").GetValue(obj, null).ToString();
string winaccountName = obj.GetType().GetProperty("winaccountName").GetValue(obj, null).ToString();
string personID = (!String.IsNullOrEmpty(ppid) ? ppid : winaccountName);
object scbReq = null;
DataSet ds1 = TransRegistered.Get(transRegisteredID, personID, transProjectID);
DataTable dt1 = ds1.Tables[0];
if (dt1.Rows.Count > 0)
{
DataRow dr1 = dt1.Rows[0];
personID = dr1["personID"].ToString();
invoiceID = dr1["invoiceID"].ToString();
totalFeeAmount = String.Format("{0:0.00}", dr1["totalFeeAmount"]);
lastPaymentDate = dr1["lastPaymentDateForQRCode"].ToString();
DataSet ds2 = ProjectCategory.Get(projectCategory);
DataTable dt2 = ds2.Tables[0];
if (dt2.Rows.Count > 0)
{
DataRow dr2 = dt2.Rows[0];
string systemRef = dr2["systemRef"].ToString();
DataSet ds3 = Util.ExecuteCommandStoredProcedure(Util.infinityConnectionString, "sp_rscGetFinPayBankQRCode",
new SqlParameter("@systemRef", systemRef));
DataTable dt3 = ds3.Tables[0];
if (dt3.Rows.Count > 0)
{
DataRow dr3 = dt3.Rows[0];
taxNo = dr3["taxNo"].ToString();
suffix = dr3["suffix"].ToString();
billerID = (taxNo + suffix);
campus = dr3["campus"].ToString();
profitCenter = dr3["profitCenter"].ToString();
branchNo = dr3["branchNo"].ToString();
subBranch = dr3["subBranch"].ToString();
merchantName = dr3["systemRef"].ToString();
}
}
}
else
{
errorCode = 2;
}
if (errorCode.Equals(0))
{
ref1 = (campus + profitCenter + branchNo + subBranch + invoiceID.Substring(6));
ref2 = (invoiceID.Substring(3) + lastPaymentDate);
ref3 = personID;
scbReq = new {
biller_id = billerID,
merchant_name = merchantName,
amount = totalFeeAmount,
ref_1 = ref1,
ref_2 = ref2,
ref_3 = ref3
};
string username = "******";
string password = "******";
string tokenBasicEncoded = String.Format("{0}{1}", "Basic ", Convert.ToBase64String(Encoding.GetEncoding("UTF-8").GetBytes(username + ":" + password)));
var client = new RestClient("https://smartedu.mahidol.ac.th/scbapi/muBarcode/muQrCodeGen");
var request = new RestRequest(Method.POST);
request.AddHeader("Authorization", tokenBasicEncoded);
request.AddHeader("cache-control", "no-cache");
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", JsonConvert.SerializeObject(scbReq), ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
qrCodeObj = JsonConvert.DeserializeObject(response.Content);
errorCode = (qrCodeObj.qr_code == "00" ? 0 : 1);
if (errorCode.Equals(0))
{
jsonObject.Add("personID", (!String.IsNullOrEmpty(ppid) ? ppid : winaccountName));
jsonObject.Add("transInvoiceID", invoiceID);
jsonObject.Add("billerID", billerID);
jsonObject.Add("merchantName", merchantName);
jsonObject.Add("qrRef_1", ref1);
jsonObject.Add("qrRef_2", ref2);
jsonObject.Add("qrRef_3", ref3);
jsonObject.Add("qrImage", (qrCodeObj != null ? qrCodeObj.qr_image64 : null));
jsonObject.Add("qrNewRef_1", (qrCodeObj != null ? qrCodeObj.qr_new_ref_1 : null));
jsonObject.Add("paidAmount", totalFeeAmount);
jsonObject.Add("createdBy", winaccountName);
jsonData = JsonConvert.SerializeObject(jsonObject);
DataSet ds3 = Util.ExecuteCommandStoredProcedure(Util.connectionString, "sp_rscSetTransInvoiceRef",
new SqlParameter("@jsonData", jsonData));
DataTable dt3 = ds3.Tables[0];
if (dt3.Rows.Count > 0)
{
DataRow dr3 = dt3.Rows[0];
merchantName = dr3["merchantName"].ToString();
paidAmount = dr3["paidAmount"].ToString();
paidStatus = dr3["paidStatus"].ToString();
errorCode = int.Parse(dr3["errorCode"].ToString());
actionDate = dr3["actionDate"].ToString();
}
else
{
errorCode = 1;
qrCodeObj = null;
}
}
}
else
{
errorCode = 2;
}
}
catch {
errorCode = 1;
}
list.Add(new {
errorCode = errorCode,
qrCode = (qrCodeObj != null ? qrCodeObj.qr_code : null),
qrMessage = (qrCodeObj != null ? qrCodeObj.qr_message : null),
qrFormat = (qrCodeObj != null ? qrCodeObj.qr_format : null),
qrImage64 = (qrCodeObj != null ? qrCodeObj.qr_image64 : null),
qrResponse = (qrCodeObj != null ? qrCodeObj.qr_response : null),
qrRef1 = (!String.IsNullOrEmpty(ref1) ? ref1 : null),
qrRef2 = (!String.IsNullOrEmpty(ref2) ? ref2 : null),
qrRef3 = (!String.IsNullOrEmpty(ref3) ? ref3 : null),
qrNewRef1 = (qrCodeObj != null ? qrCodeObj.qr_new_ref_1 : null),
merchantName = (!String.IsNullOrEmpty(merchantName) ? merchantName : null),
paidAmount = (!String.IsNullOrEmpty(paidAmount) ? paidAmount : null),
paidStatus = (!String.IsNullOrEmpty(paidStatus) ? paidStatus : null),
actionDate = (!String.IsNullOrEmpty(actionDate) ? actionDate : null),
});
}
return(Request.CreateResponse(HttpStatusCode.OK, Util.APIResponse.GetData(list.ToList())));
}
public dynamic Get(
string projectCategory = null,
string cuid = null
)
{
string transProjectID = string.Empty;
string[] cuidArray = Util.CUID2Array(cuid);
if (cuidArray != null)
{
int i = 1;
foreach (var data in cuidArray)
{
if (i.Equals(1))
{
transProjectID = data;
}
i++;
}
}
string personID = String.Empty;
if (Util.GetIsAuthenticatedByAuthenADFS())
{
object obj = Util.GetPPIDByAuthenADFS();
string ppid = obj.GetType().GetProperty("ppid").GetValue(obj, null).ToString();
string winaccountName = obj.GetType().GetProperty("winaccountName").GetValue(obj, null).ToString();
personID = (!String.IsNullOrEmpty(ppid) ? ppid : winaccountName);
}
DataSet ds = TransProject.Get(projectCategory, transProjectID);
DataTable dtTransProject = ds.Tables[0];
DataTable dtTransLocation = ds.Tables[1];
DataTable dtTransFeeType = ds.Tables[2];
List <object> list = new List <object>();
if (dtTransProject.Rows.Count > 0)
{
List <object> transProjects = TransProject.GetDataSource("TransProject", dtTransProject);
List <object> transLocations = TransProject.GetDataSource("TransLocation", dtTransLocation);
List <object> transFeeTypes = TransProject.GetDataSource("TransFeeType", dtTransFeeType);
JObject transProject = new JObject(JsonConvert.DeserializeObject <dynamic>(JsonConvert.SerializeObject(transProjects[0])));
DataSet dsTransRegistered = TransRegistered.Get("", personID, transProjectID);
DataTable dtTransRegistered = dsTransRegistered.Tables[0];
List <object> transRegistered = TransRegistered.GetDataSource("TransRegistered", dtTransRegistered);
DataSet dsTransRegisteredWithTransProjectIDs = TransRegistered.GetListWithTransProjectIDs(personID, transProject["sameProject"].ToString());
DataTable dtTransRegisteredWithTransProjectIDs = dsTransRegisteredWithTransProjectIDs.Tables[0];
List <object> transRegisteredWithTransProjectIDs = TransRegistered.GetDataSource("TransRegisteredWithTransProjectIDs", dtTransRegisteredWithTransProjectIDs);
transProject.Add("transLocation", JToken.FromObject(transLocations));
transProject.Add("transFeeType", JToken.FromObject(transFeeTypes));
transProject.Add("transRegistered", JToken.FromObject(transRegistered));
transProject.Add("transRegisteredWithTransProjectIDs", JToken.FromObject(transRegisteredWithTransProjectIDs));
list.Add(transProject);
JObject parameters = new JObject();
parameters.Add("projectCategory", projectCategory);
parameters.Add("transProjectID", transProjectID);
DataTable dt = SysEvent.Set(Request.RequestUri.ToString(), JsonConvert.SerializeObject(parameters), personID).Tables[0];
}
return(Request.CreateResponse(HttpStatusCode.OK, Util.APIResponse.GetData(list)));
}
