website/Bankerror.aspx.cs at master · ashupandith/website · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using System.Security.Cryptography;
using System.Text;

public partial class Bankerror : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["HPSCDBNEW"].ConnectionString);
        using (SqlCommand cmd = new SqlCommand())
        {
            cmd.CommandText = "Update ApplicantDetails set IsPayment=NULL where RegestrationNumber =@RegestrationNumber";
            cmd.Parameters.AddWithValue("@RegestrationNumber", "");
            if (con.State != ConnectionState.Open)
            {
                con.Open();
            }
            cmd.Connection = con;

            cmd.ExecuteNonQuery();
            con.Close();
         }
           string[] merc_hash_vars_seq;
                string merc_hash_string = string.Empty;
                string merc_hash = string.Empty;
                string mihpayid = string.Empty;
                string mode = string.Empty;
                string status = string.Empty;
                string key = string.Empty;
                string txnid = string.Empty;
                string amount = string.Empty;
                string Firstname = string.Empty;
                string udf1 = string.Empty;
                string udf2 = string.Empty;
                string udf3 = string.Empty;
                string Error = string.Empty;
                string bankcode = string.Empty;
                string bank_ref_num = string.Empty;
                string hash_seq = "key|txnid|amount|productinfo|firstname|email|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10";
                    merc_hash_vars_seq = hash_seq.Split('|');
                    Array.Reverse(merc_hash_vars_seq);
                    merc_hash_string = ConfigurationManager.AppSettings["SALT"] + "|" + Request.Form["status"];
                    foreach (string merc_hash_var in merc_hash_vars_seq)
                    {
                        merc_hash_string += "|";
                        merc_hash_string = merc_hash_string + (Request.Form[merc_hash_var] != null ? Request.Form[merc_hash_var] : "");
                    }
                    merc_hash = Generatehash512(merc_hash_string).ToLower();
                   if (merc_hash != Request.Form["hash"])
                    {
                        Response.Write("Hash value did not matched");

                    }
                    else
                    {
                       mihpayid = Request.Form["mihpayid"];
                        mode = Request.Form["mode"];
                        status = Request.Form["status"];
                        key = Request.Form["key"];
                        txnid = Request.Form["txnid"];
                        amount = Request.Form["amount"];
                        Firstname = Request.Form["Firstname"];
                        udf1 = Request.Form["udf1"];
                        udf2 = Request.Form["udf2"];
                        udf3 = Request.Form["udf3"];
                        Error = Request.Form["Error"];
                        bankcode = Request.Form["bankcode"];
                        bank_ref_num = Request.Form["bank_ref_num"];
                      using (SqlCommand cmdbank = new SqlCommand())
                        {
                            cmdbank.CommandText = "insert into Tbl_bankDetail (mihpayid ,mode,status,key_key,txnid,amount,Firstname,udf1,udf2,udf3,Error,bankcode,bank_ref_num) values (@mihpayid ,@mode,@status,@key_key,@txnid,@amount,@Firstname,@udf1,@udf2,@udf3,@Error,@bankcode,@bank_ref_num)";
                            cmdbank.Parameters.AddWithValue("@mihpayid", mihpayid);
                            cmdbank.Parameters.AddWithValue("@mode", mode);
                            cmdbank.Parameters.AddWithValue("@status", status);
                            cmdbank.Parameters.AddWithValue("@key_key", key);
                            cmdbank.Parameters.AddWithValue("@txnid", txnid);
                            cmdbank.Parameters.AddWithValue("@amount", amount);
                            cmdbank.Parameters.AddWithValue("@Firstname", Firstname);
                            cmdbank.Parameters.AddWithValue("@udf1", udf1);
                            cmdbank.Parameters.AddWithValue("@udf2", udf2);
                            cmdbank.Parameters.AddWithValue("@udf3", udf3);
                            cmdbank.Parameters.AddWithValue("@Error", Error);
                            cmdbank.Parameters.AddWithValue("@bankcode", bankcode);
                            cmdbank.Parameters.AddWithValue("@bank_ref_num", bank_ref_num);
                             cmdbank.Connection = con;
                             if (con.State != ConnectionState.Open)
                             {
                                 con.Open();
                             }
                             cmdbank.ExecuteNonQuery();

                      }


                    }
        }
    public string Generatehash512(string text)
    {
        byte[] message = Encoding.UTF8.GetBytes(text);

        UnicodeEncoding UE = new UnicodeEncoding();
        byte[] hashValue;
        SHA512Managed hashString = new SHA512Managed();
        string hex = "";
        hashValue = hashString.ComputeHash(message);
        foreach (byte x in hashValue)
        {
            hex += String.Format("{0:x2}", x);
        }
        return hex;
    }
    }