DeserializeObject JSON to Object in asp.net C#, OR We can say Convert JSON to C# Object

using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Web.Script.Serialization;

string example = System.IO.File.ReadAllText("D://Result.txt");
var JsonResult = JObject.Parse(example);
if (JsonResult["transaction_details"] != null)
{
 var success = JsonResult["transaction_details"].First.ToString();
 if (success != null)
 {
  int len = success.ToString().IndexOf(":") + 1;
  var FinalJson = JObject.Parse(success.Substring(len));
  if (FinalJson != null)
  {
    IntentFlowProperty flight = Newtonsoft.Json.JsonConvert.DeserializeObject(FinalJson.ToString());
  }
 }
}
        
        
public class IntentFlowProperty
    {
        public string mihpayid { get; set; }
        public object request_id { get; set; }
        public object bank_ref_num { get; set; }
        public string amt { get; set; }
        public string transaction_amount { get; set; }
        public string txnid { get; set; }
        public string additional_charges { get; set; }
        public string productinfo { get; set; }
        public string firstname { get; set; }
        public string bankcode { get; set; }
        public object udf1 { get; set; }
        public object udf3 { get; set; }
        public object udf4 { get; set; }
        public object udf5 { get; set; }
        public object field2 { get; set; }
        public object field9 { get; set; }
        public object error_code { get; set; }
        public string addedon { get; set; }
        public string payment_source { get; set; }
        public object card_type { get; set; }
        public string error_Message { get; set; }
        public string net_amount_debit { get; set; }
        public string disc { get; set; }
        public string mode { get; set; }
        public string PG_TYPE { get; set; }
        public string card_no { get; set; }
        public object udf2 { get; set; }
        public object field5 { get; set; }
        public object field7 { get; set; }
        public string status { get; set; }
        public string unmappedstatus { get; set; }
        public object Merchant_UTR { get; set; }
        public object Settled_At { get; set; }
        public object App_Name { get; set; }
    }
    
   

JSON Strting:- {"status":1,"msg":"1 out of 1 Transactions Fetched Successfully","transaction_details":{"SAOAO1000010147-20210608185806":{"mihpayid":"403993715523232833","request_id":null,"bank_ref_num":null,"amt":"1.00","transaction_amount":"1.00","txnid":"SAOAO1000010147-20210608185806","additional_charges":"0.00","productinfo":"ABCDEF","firstname":"MURLI","bankcode":"INTENT","udf1":null,"udf3":null,"udf4":null,"udf5":null,"field2":null,"field9":null,"error_code":null,"addedon":"2021-06-08 18:58:07","payment_source":"payuPureS2S","card_type":null,"error_Message":"","net_amount_debit":"0.00","disc":"0.00","mode":"UPI","PG_TYPE":"UPI-PG","card_no":"","udf2":null,"field5":null,"field7":null,"status":"pending","unmappedstatus":"in progress","Merchant_UTR":null,"Settled_At":null,"App_Name":null}}}

Check Is Android Device from Asp.net

 		private bool IsAndroidMobile()
        {
            //https://www.thecodingguys.net/blog/asp-net-mobile-detection
            try
            {
                string strUserAgent = Request.UserAgent.ToString().ToLower();
                bool MobileDevice = Request.Browser.IsMobileDevice;
                if (strUserAgent != null)
                {
                    if (MobileDevice == true && strUserAgent.Contains("android"))
                    {
                        return true;
                    }
                }
            }
            catch
            {
                //throw;
            }
            return false;
        }

Sonar Qube Executon step

SonarScanner.MSBuild.exe begin /k:"project-key" /d:sonar.login="GeneratedToken"
MSBuild.exe path to solution.sln /t:Rebuild
SonarScanner.MSBuild.exe end /d:sonar.login="GeneratedToken"

SonarScanner.MSBuild.exe begin /k:"PROJECT_XXXX" /d:sonar.login="ccdf3266ae033ade65a691854ac73c6b51c846a6"
"C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\MSBuild\Current\Bin\MSBuild.exe" D:\Murli\Projects\XYZ\XYZ_SonarQube.sln /t:Rebuild /p:VisualStudioVersion=14.0
SonarScanner.MSBuild.exe end /d:sonar.login="ccdf3266ae033ade65a691854ac73c6b51c846a6"

To know more https://docs.sonarqube.org/latest/analysis/scan/sonarscanner-for-msbuild/

Javascript getElementById based on a partial string

document.querySelector('[id$="MySufixIdString"]').id;

The selector means: get an element where the attribute [id] ending with the string "MySufixIdString".

^ matches the start
* matches any position
$ matches the end

Generate Backup of Store Procedure on Oracle

	follwoing 2 ways to get the Procedure details in oracle

Way 1:

Select OBJECT_NAME As ProcName,
   dbms_metadata.GET_DDL('PROCEDURE',u.object_name) As Details
From user_objects u
Where object_type = 'PROCEDURE'; 
   
Way 2:
   
Select OBJECT_NAME As ProcName,
 dbms_metadata.GET_DDL('PROCEDURE',OBJECT_NAME) As Details  
From ALL_OBJECTS  
Where  object_type = 'PROCEDURE' and OWNER = 'SYSTEM' 
Order by Object_Name
 
 

Get File Execution Location

 AppDomain.CurrentDomain.BaseDirectory

Oracle Some Important Notes

 Oracle Notes:-

1. From the Procedure Data Result(s) OUT TYPES.cursor_type Count must be same as declared

2. Post Every Insert/Update/Delete must commit without this change will not reflect.

3. Every If() Then statement closed with End If; (Semicolumn is must)

4. For Writing select query we can wite like this OPEN L_RECORDSET2 for select  'true' as col from dual; (Here dual is default table available on oracle)

5. Insert Records like this

Insert into MY_TBL_DETAILS (ID, PRODUCTTYPE, REFNO , CREATEDDATE) 

values (SEQ_MY_TBL_DETAILS.NEXTVAL,L_PRODUCTTYPE, L_REFNO, TO_CHAR(sysdate, 'DD-MON-YYYY HH:MI:SS'));   

commit;

6. Update Records like this

UPDATE MY_TBL_DETAILS SET PRODUCTTYPE = 'TestProduct' WHERE REFNO = L_REFNO;

Commit; 

7. Sequece Creation

CREATE SEQUENCE  SEQ_MY_TBL_DETAILS

MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;

CREATE OR REPLACE TRIGGER MY_TBL_DETAILS_SEQ

BEFORE INSERT ON MY_TBL_DETAILS 

FOR EACH ROW

BEGIN

SELECT SEQ_MY_TBL_DETAILS.NEXTVAL

INTO   :new.id

FROM   dual;

END;

/

ALTER TRIGGER MY_TBL_DETAILS_SEQ ENABLE;

8. Update Query with latest records

DECLARE tempVariable NUMBER;

         BEGIN

           SELECT Count(*) INTO tempVariable FROM MY_TBL_DETAILS Where REFNO = L_REFNO;

           IF (tempVariable > 0) then

              UPDATE MY_TBL_DETAILS SET STATUS = (CASE WHEN L_STATUS IS NULL THEN STATUS ELSE L_STATUS END)

                ,MESSAGE = (CASE WHEN L_MESSAGE IS NULL THEN MESSAGE ELSE L_MESSAGE END)

              WHERE ID IN (Select Id FROM (SELECT ID, rownum RN FROM (SELECT ID from MY_TBL_DETAILS Where REFNO = L_REFNO ORDER BY ID DESC)) 

              WHERE RN = 1);

            End If;

End;