using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Runtime.Remoting.Contexts;
using getepay_sdk;
using System.Net;
using System.Security.Cryptography;

namespace Newdelhibarassocia
{
    public partial class Payment : System.Web.UI.Page
    {
        Class1 obj = new Class1();
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlDataAdapter adp;
        SqlCommand cmd;
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack)
            { }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (DropDownList1.SelectedItem.Text == "Select Type")
                {
                    RegisterStartupScript("12", "<script>alert('Choose Type of Serach')</script>");

                }
                else
                {
                    if (DropDownList1.SelectedItem.Text == "NDBA.No.")
                    {
                        string sel = "select top 1 * from Memberslist where Ndbano='" + TextBox1.Text + "'";
                        SqlDataAdapter da = new SqlDataAdapter(sel, con);
                        DataTable dt = new DataTable();
                        da.Fill(dt);
                        if (dt.Rows.Count > 0)
                        {
                            Panel1.Visible = true;
                            //Panel2.Visible= true;
                            Literal1.Text = dt.Rows[0]["Mobile_1"].ToString();
                            Label9.Text = dt.Rows[0]["Mobile_1"].ToString();
                            lblCustomerId.Text = dt.Rows[0]["Ndbano"].ToString();
                            Label7.Text = dt.Rows[0]["Bcdenroll"].ToString();
                            Label8.Text = dt.Rows[0]["F_name"].ToString() + " " + dt.Rows[0]["M_name"].ToString() + " " + dt.Rows[0]["L_name"].ToString();
                            // Label10.Text = dt.Rows[0]["CeasedDate"].ToString();

                            string qrajneeti = "select * from Membersduelist where  Ndbano='" + dt.Rows[0]["Ndbano"].ToString() + "'  order by id desc";
                            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
                            string ddue = "0";
                            string dues = "";
                            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
                            {
                                dues = dsrajneeti.Tables[0].Rows[0]["dues"].ToString();
                                if (dues != "0")
                                {
                                    DateTime dt1 = DateTime.Now.AddDays(-1);
                                    int k = 0;
                                    if (dsrajneeti.Tables[0].Rows[0]["Ndbadate"].ToString() != "")
                                    {

                                        DateTime dt2 = Convert.ToDateTime(dsrajneeti.Tables[0].Rows[0]["Ndbadate"].ToString());
                                        var monthCount = dt1.Year != dt1.Year ? ((dt1.Year - dt2.Year - 1) * 12) + (13 - dt2.Month + dt1.Month) : dt1.Month - dt2.Month;
                                        k = 100 * monthCount;
                                        if (dues != "")
                                        {
                                            int dueson = Convert.ToInt32(dues) + k;
                                            dues = dueson.ToString();
                                        }
                                    }
                                }
                                ddue = dues.ToString();
                                DateTime dateTime = Convert.ToDateTime(dsrajneeti.Tables[0].Rows[0]["Ndbadate"].ToString());
                                lbduedate.Text = dateTime.ToString("dd/MM/yyyy").Replace("12:00:00 AM", "");

                                // lbduedate.Text = dsrajneeti.Tables[0].Rows[0]["Ndbadate"].ToString();
                            }
                            Label11.Text = ddue; //due;
                            if (dues != "")
                            {
                                if (Convert.ToInt32(ddue) > 0)
                                {
                                    TextBox3.Text = ddue; //total fee;
                                }
                            }
                            //string[] saAllowedCharacters = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" };

                            //string sRandomOTP = GenerateRandomOTP(4, saAllowedCharacters);
                            //HiddenField1.Value = sRandomOTP;
                            //string messag = " NDBA User, Your OTP is " + sRandomOTP + ". Do Not share this with anyone. TEAM NDBA";
                            //string SmsStatusMsg = string.Empty;
                            //WebClient client = new WebClient();
                            //string mm = "9871482014";
                            //if (dt.Rows[0]["Mobile_1"].ToString() != "0")
                            //{
                            //    string URL = "http://www.canlog.in/api/mt/SendSMS?user=NDBA1234&password=NDBA1234&senderid=NDBATM&channel=Trans&DCS=0&flashsms=0&number=" + mm + "&text=" + messag + "&route=2";

                            //    SmsStatusMsg = client.DownloadString(URL);
                            //    if (SmsStatusMsg.Contains("<br>"))
                            //    {
                            //        SmsStatusMsg = SmsStatusMsg.Replace("<br>", ", ");

                            //    }
                            //}
                            //else
                            //{
                            //    RegisterStartupScript("12", "<script>alert('number not valid')</script>");
                            //}

                            //Repeater1.DataSource = dt;
                            //Repeater1.DataBind();
                            //Repeater1.Visible = true;
                        }
                        else
                        {
                            // Repeater1.Visible = false;
                        }
                    }

                    else if (DropDownList1.SelectedItem.Text == "Mobile No.")
                    {
                        string sel = "select top 1 * from Memberslist where  Mobile_1 like '%" + TextBox1.Text + "%'";
                        SqlDataAdapter da = new SqlDataAdapter(sel, con);
                        DataTable dt = new DataTable();
                        da.Fill(dt);
                        if (dt.Rows.Count > 0)
                        {
                            Panel1.Visible = true;
                            //Panel2.Visible = true;
                            Literal1.Text = dt.Rows[0]["Mobile_1"].ToString();
                            Label9.Text = dt.Rows[0]["Mobile_1"].ToString();
                            lblCustomerId.Text = dt.Rows[0]["Ndbano"].ToString();
                            Label7.Text = dt.Rows[0]["Bcdenroll"].ToString();
                            Label8.Text = dt.Rows[0]["F_name"].ToString() + " " + dt.Rows[0]["M_name"].ToString() + " " + dt.Rows[0]["L_name"].ToString();
                            // Label10.Text = dt.Rows[0]["CeasedDate"].ToString();

                            string qrajneeti = "select * from Membersduelist where  Ndbano='" + dt.Rows[0]["Ndbano"].ToString() + "'  order by id desc";
                            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
                            string ddue = "0";
                            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
                            {
                                ddue = dsrajneeti.Tables[0].Rows[0]["dues"].ToString();
                            }
                            Label11.Text = ddue; //due;
                            if (Convert.ToUInt32(ddue) > 0)
                            {
                                TextBox3.Text = ddue; //total fee;
                            }

                            //string[] saAllowedCharacters = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" };

                            //string sRandomOTP = GenerateRandomOTP(4, saAllowedCharacters);
                            //HiddenField1.Value = sRandomOTP;
                            ////NDBA User, Your OTP is 464654. Do Not share this with anyone. TEAM NDBA
                            ////	NDBA User, Your OTP is " + sRandomOTP + ". Do Not share this with anyone. TEAM NDBA
                            //string messag = " NDBA User, Your OTP is " + sRandomOTP + ". Do Not share this with anyone. TEAM NDBA";
                            //string SmsStatusMsg = string.Empty;
                            //WebClient client = new WebClient();
                            //// mm = "9871482014";
                            //if (dt.Rows[0]["Mobile_1"].ToString() != "0")
                            //{
                            //    string URL = "http://www.canlog.in/api/mt/SendSMS?user=NDBA1234&password=NDBA1234&senderid=NDBATM&channel=Trans&DCS=0&flashsms=0&number=" + dt.Rows[0]["Mobile_1"].ToString() + "&text=" + messag + "&route=2";

                            //    SmsStatusMsg = client.DownloadString(URL);
                            //    if (SmsStatusMsg.Contains("<br>"))
                            //    {
                            //        SmsStatusMsg = SmsStatusMsg.Replace("<br>", ", ");

                            //    }
                            //}
                            //else
                            //{
                            //    RegisterStartupScript("12", "<script>alert('number not valid')</script>");
                            //}
                            //Panel2.Visible = true;
                            //Literal1.Text = dt.Rows[0]["Mobile_1"].ToString();
                            //string[] saAllowedCharacters = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" };

                            //string sRandomOTP = GenerateRandomOTP(4, saAllowedCharacters);
                            //HiddenField1.Value = sRandomOTP;
                            //string messag = sRandomOTP + " is the OTP for your NDBA. do not share this with anyone.";
                            //string SmsStatusMsg = string.Empty;
                            //WebClient client = new WebClient();
                            //// mm = "9871482014";
                            //string URL = "http://www.canlog.in/api/mt/SendSMS?user=NDBA1234&password=NDBA1234&senderid=NDBATM&channel=Trans&DCS=0&flashsms=0&number=" + dt.Rows[0]["Mobile_1"].ToString() + "&text=" + messag + "&route=2";

                            //SmsStatusMsg = client.DownloadString(URL);
                            //if (SmsStatusMsg.Contains("<br>"))
                            //{
                            //    SmsStatusMsg = SmsStatusMsg.Replace("<br>", ", ");

                            //}
                            //Repeater1.DataSource = dt;
                            //Repeater1.DataBind();
                            //Repeater1.Visible = true;
                        }
                        else
                        {
                            // Repeater1.Visible = false;
                        }
                    }
                    else if (DropDownList1.SelectedItem.Text == "BCD Enrollment No.")
                    {
                        string sel = "select top 1 * from Memberslist where Bcdenroll like '%" + TextBox1.Text + "%'";
                        SqlDataAdapter da = new SqlDataAdapter(sel, con);
                        DataTable dt = new DataTable();
                        da.Fill(dt);
                        if (dt.Rows.Count > 0)
                        {
                            Panel1.Visible = true;
                            Literal1.Text = dt.Rows[0]["Mobile_1"].ToString();
                            Label9.Text = dt.Rows[0]["Mobile_1"].ToString();
                            lblCustomerId.Text = dt.Rows[0]["Ndbano"].ToString();
                            Label7.Text = dt.Rows[0]["Bcdenroll"].ToString();
                            Label8.Text = dt.Rows[0]["F_name"].ToString() + " " + dt.Rows[0]["M_name"].ToString() + " " + dt.Rows[0]["L_name"].ToString();
                            // Label10.Text = dt.Rows[0]["CeasedDate"].ToString();

                            string qrajneeti = "select * from Membersduelist where  Ndbano='" + dt.Rows[0]["Ndbano"].ToString() + "'  order by id desc";
                            DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
                            string ddue = "0";
                            if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
                            {
                                ddue = dsrajneeti.Tables[0].Rows[0]["dues"].ToString();
                            }
                            Label11.Text = ddue; //due;
                            if (Convert.ToUInt32(ddue) > 0)
                            {
                                TextBox3.Text = ddue; //total fee;
                            }


                            //Panel2.Visible = true;
                            //Literal1.Text = dt.Rows[0]["Mobile_1"].ToString();
                            //string[] saAllowedCharacters = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" };

                            //string sRandomOTP = GenerateRandomOTP(4, saAllowedCharacters);
                            //HiddenField1.Value = sRandomOTP;
                            //string messag = sRandomOTP + " is the OTP for your NDBA. do not share this with anyone.";
                            //string SmsStatusMsg = string.Empty;
                            //WebClient client = new WebClient();
                            //// mm = "9871482014";
                            //string URL = "http://www.canlog.in/api/mt/SendSMS?user=NDBA1234&password=NDBA1234&senderid=NDBATM&channel=Trans&DCS=0&flashsms=0&number=" + dt.Rows[0]["Mobile_1"].ToString() + "&text=" + messag + "&route=2";

                            //SmsStatusMsg = client.DownloadString(URL);
                            //if (SmsStatusMsg.Contains("<br>"))
                            //{
                            //    SmsStatusMsg = SmsStatusMsg.Replace("<br>", ", ");

                            //}
                            //Repeater1.DataSource = dt;
                            //Repeater1.DataBind();
                            //Repeater1.Visible = true;
                        }
                        else
                        {
                            //Repeater1.Visible = false;
                        }
                    }
                }
                // Literal1.Text = "9871482014";
                Panel2.Visible = false;
            }
            catch(Exception ex)
            {
                RegisterStartupScript("12", "<script>alert('Contact the systems administrator to check your registration details')</script>");
            }
        }
        private string GenerateRandomOTP(int iOTPLength, string[] saAllowedCharacters)

        {

            string sOTP = String.Empty;

            string sTempChars = String.Empty;

            Random rand = new Random();

            for (int i = 0; i < iOTPLength; i++)

            {

                int p = rand.Next(0, saAllowedCharacters.Length);

                sTempChars = saAllowedCharacters[rand.Next(0, saAllowedCharacters.Length)];

                sOTP += sTempChars;

            }

            return sOTP;

        }
        //protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        //{
        //    if (e.CommandName == "view")
        //    {
        //        string bnd = "ND"+ System.DateTime.Now.Ticks.ToString().Substring(12);
        //        HttpCookie myCookie = new HttpCookie("Siteid");
        //        myCookie.Value = bnd;
        //        myCookie.Expires = DateTime.Now.AddDays(1);
        //        Response.Cookies.Add(myCookie);
        //        Label bcno = (Label)e.Item.FindControl("lblContactName");
        //        TextBox pamount = (TextBox)e.Item.FindControl("Label5");

        //        Session["billno"] = bcno.Text;
        //        Session["bnreorll"] = bnd;

        //        string qrajneeti = "select * from Memberslist where Bcdenroll='" + bcno.Text + "'  order by id desc";
        //        DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
        //        if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
        //        {

        //            con.Open();
        //            cmd = new SqlCommand("insert into newdelhibar_bill (Billno,Name,Mobile,NDBAno,BCDno,Daten,Address,Headermessage,Paymentmode,Footermessage,totalamount,btype,Status) values (@Billno,@Name,@Mobile,@NDBAno,@BCDno,@Daten,@Address,@Headermessage,@Paymentmode,@Footermessage,@totalamount,@btype,@Status)", con);

        //            cmd.Parameters.Add("@Billno", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@Billno"].Value = bnd;
        //            cmd.Parameters.Add("@Name", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@Name"].Value = dsrajneeti.Tables[0].Rows[0]["F_name"].ToString() + " " + dsrajneeti.Tables[0].Rows[0]["M_name"].ToString() + " " + dsrajneeti.Tables[0].Rows[0]["L_name"].ToString();
        //            cmd.Parameters.Add("@Mobile", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@Mobile"].Value = dsrajneeti.Tables[0].Rows[0]["Mobile_1"].ToString();
        //            cmd.Parameters.Add("@NDBAno", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@NDBAno"].Value = dsrajneeti.Tables[0].Rows[0]["Ndbano"].ToString();
        //            cmd.Parameters.Add("@BCDno", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@BCDno"].Value = dsrajneeti.Tables[0].Rows[0]["Bcdenroll"].ToString();
        //            cmd.Parameters.Add("@Daten", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@Daten"].Value = System.DateTime.Now;
        //            cmd.Parameters.Add("@Address", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@Address"].Value = dsrajneeti.Tables[0].Rows[0]["Resid_1"].ToString();
        //            cmd.Parameters.Add("@Headermessage", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@Headermessage"].Value = "Online Member Fee";
        //            cmd.Parameters.Add("@Paymentmode", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@Paymentmode"].Value = "Online";
        //            cmd.Parameters.Add("@Footermessage", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@Footermessage"].Value = "Online Fee";
        //            cmd.Parameters.Add("@totalamount", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@totalamount"].Value = pamount.Text;
        //            cmd.Parameters.Add("@btype", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@btype"].Value = "Member ship";
        //            cmd.Parameters.Add("@Status", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@Status"].Value = "Pending";

        //            cmd.ExecuteNonQuery();
        //            con.Close();



        //            con.Open();
        //            cmd = new SqlCommand("insert into newdelhibar_rowbill (Billno,Particulars,Amount) values (@Billno,@Particulars,@Amount)", con);

        //            cmd.Parameters.Add("@Billno", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@Billno"].Value = bnd;

        //            cmd.Parameters.Add("@Particulars", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@Particulars"].Value = "Member Fee";


        //            cmd.Parameters.Add("@Amount", System.Data.SqlDbType.VarChar);
        //            cmd.Parameters["@Amount"].Value = pamount.Text;



        //            cmd.ExecuteNonQuery();
        //            con.Close();

        //            // payment online..
        //            try
        //            {
        //                string mid = ConfigurationSettings.AppSettings["Mid"].ToString();
        //                string terminal_Id = ConfigurationSettings.AppSettings["terminalId"].ToString();
        //                string mkey = ConfigurationSettings.AppSettings["key"].ToString();
        //                string miv = ConfigurationSettings.AppSettings["iv"].ToString();
        //                string murl = ConfigurationSettings.AppSettings["url"].ToString();

        //                GetepayConfig config = new GetepayConfig();
        //                config.mid = mid;
        //                config.terminalId = terminal_Id;
        //                config.key = mkey;
        //                config.iv = miv;
        //                config.url = murl;


        //                //added to solve ssl error for requery
        //                System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
        //                //GetepayRequeryResponse requeryResponse = Getepay.requeryRequest(config, getepayRequery);
        //                //  Console.WriteLine("11", requeryResponse.txnStatus);
        //                // string rns=requeryResponse.txnStatus.ToString();

        //                GetepayRequest request = new GetepayRequest();

        //                request.mid = mid.ToString();
        //                request.amount = pamount.Text;
        //                request.merchantTransactionId = bnd;
        //                request.transactionDate = System.DateTime.Now.ToString("yyyy-mm-dd hh:mm:ss");//2024-02-16 04:31:23
        //                request.terminalId = terminal_Id.ToString();
        //                request.udf1 = dsrajneeti.Tables[0].Rows[0]["Mobile_1"].ToString();
        //                request.udf2 = "ndba.patialahousecourt@gmail.com";
        //                request.udf3 = dsrajneeti.Tables[0].Rows[0]["F_name"].ToString() + " " + dsrajneeti.Tables[0].Rows[0]["M_name"].ToString() + " " + dsrajneeti.Tables[0].Rows[0]["L_name"].ToString();
        //                request.udf4 = "";
        //                request.udf5 = "";
        //                request.udf6 = "";
        //                request.udf7 = "";
        //                request.udf8 = "";
        //                request.udf9 = "";
        //                request.udf10 = murl;
        //                request.ru = "https://newdelhibarassociation.in/Paymentstatus.aspx";
        //               // request.ru = "https://localhost:44346/Paymentstatus.aspx";
        //                request.callbackUrl = "https://newdelhibarassociation.in/Paymentstatus.aspx";
        //                request.callbackUrl = "";
        //                request.currency = "INR";
        //                request.paymentMode = "ALL";
        //                request.bankId = "";
        //                request.txnType = "";
        //                request.productType = "";
        //                request.txnNote = "";
        //                request.vpa = "";

        //               // GetepayRequest getreq= new GetepayRequest(config,request);

        //                GetepayOrderResponse orderResponse = Getepay.generateRequest(config, request);
        //                //Session["pid"] = orderResponse.paymentId;

        //                HttpCookie nameCookie = new HttpCookie("Siteid");
        //                nameCookie = Request.Cookies["Siteid"];
        //                string valss = nameCookie.Value.Replace("Siteid=", "");
        //                string up = "update newdelhibar_bill set payment_id='" + orderResponse.paymentId.ToString() + "' where Billno='" + bnd + "'";
        //                obj.SaveRecord(up);
        //                Response.Redirect(orderResponse.paymentUrl, true);
        //                //string rrn=orderResponse.ToString();
        //            }
        //            catch (Exception ex)
        //            {
        //                RegisterStartupScript("12", "<script>alert('"+ ex.Message.ToString()+ "')</script>");

        //            }
        //        }

        //    }
        //}

        protected void Button2_Click(object sender, EventArgs e)
        {
            if(HiddenField1.Value== TextBox2.Text)
            {
                int kk = 0;
                string qras = "select top 1 * from newdelhibar_bill order by id desc";
                DataSet dss = obj.ReturnDataSet(qras);
                if (dss != null && dss.Tables[0].Rows.Count > 0)
                {
                    kk = Convert.ToInt32(dss.Tables[0].Rows[0]["id"].ToString()) + 1;
                }
                string bnd = kk.ToString();
                HttpCookie myCookie = new HttpCookie("Siteid");
                myCookie.Value = bnd;
                myCookie.Expires = DateTime.Now.AddDays(1);
                Response.Cookies.Add(myCookie);
                //Label bcno = (Label)e.Item.FindControl("lblContactName");
                //TextBox pamount = (TextBox)e.Item.FindControl("Label5");

                Session["billno"] = lblCustomerId.Text;
                Session["bnreorll"] = bnd;

                string qrajneeti = "select * from Memberslist where Ndbano='" + lblCustomerId.Text + "'  order by id desc";
                DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti);
                if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0)
                {

                    con.Open();
                    cmd = new SqlCommand("insert into newdelhibar_bill (Billno,Name,Mobile,NDBAno,BCDno,Daten,Address,Headermessage,Paymentmode,Footermessage,totalamount,btype,Status) values (@Billno,@Name,@Mobile,@NDBAno,@BCDno,@Daten,@Address,@Headermessage,@Paymentmode,@Footermessage,@totalamount,@btype,@Status)", con);

                    cmd.Parameters.Add("@Billno", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Billno"].Value = bnd;
                    cmd.Parameters.Add("@Name", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Name"].Value = dsrajneeti.Tables[0].Rows[0]["F_name"].ToString() + " " + dsrajneeti.Tables[0].Rows[0]["M_name"].ToString() + " " + dsrajneeti.Tables[0].Rows[0]["L_name"].ToString();
                    cmd.Parameters.Add("@Mobile", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Mobile"].Value = dsrajneeti.Tables[0].Rows[0]["Mobile_1"].ToString();
                    cmd.Parameters.Add("@NDBAno", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@NDBAno"].Value = dsrajneeti.Tables[0].Rows[0]["Ndbano"].ToString();
                    cmd.Parameters.Add("@BCDno", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@BCDno"].Value = dsrajneeti.Tables[0].Rows[0]["Bcdenroll"].ToString();
                    cmd.Parameters.Add("@Daten", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Daten"].Value = System.DateTime.Now;
                    cmd.Parameters.Add("@Address", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Address"].Value = dsrajneeti.Tables[0].Rows[0]["Resid_1"].ToString();
                    cmd.Parameters.Add("@Headermessage", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Headermessage"].Value = "Online Member Fee";
                    cmd.Parameters.Add("@Paymentmode", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Paymentmode"].Value = "Online";
                    cmd.Parameters.Add("@Footermessage", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Footermessage"].Value = "Online Fee";
                    cmd.Parameters.Add("@totalamount", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@totalamount"].Value = TextBox3.Text;
                    cmd.Parameters.Add("@btype", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@btype"].Value = "Member ship";
                    cmd.Parameters.Add("@Status", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Status"].Value = "Pending";

                    cmd.ExecuteNonQuery();
                    con.Close();



                    con.Open();
                    cmd = new SqlCommand("insert into newdelhibar_rowbill (Billno,Particulars,Amount) values (@Billno,@Particulars,@Amount)", con);

                    cmd.Parameters.Add("@Billno", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Billno"].Value = bnd;

                    cmd.Parameters.Add("@Particulars", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Particulars"].Value = "Member Fee";


                    cmd.Parameters.Add("@Amount", System.Data.SqlDbType.VarChar);
                    cmd.Parameters["@Amount"].Value = TextBox3.Text;



                    cmd.ExecuteNonQuery();
                    con.Close();

                    // payment online..
                    try
                    {
                        string mid = ConfigurationSettings.AppSettings["Mid"].ToString();
                        string terminal_Id = ConfigurationSettings.AppSettings["terminalId"].ToString();
                        string mkey = ConfigurationSettings.AppSettings["key"].ToString();
                        string miv = ConfigurationSettings.AppSettings["iv"].ToString();
                        string murl = ConfigurationSettings.AppSettings["url"].ToString();

                        GetepayConfig config = new GetepayConfig();
                        config.mid = mid;
                        config.terminalId = terminal_Id;
                        config.key = mkey;
                        config.iv = miv;
                        config.url = murl;


                        //added to solve ssl error for requery
                        System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
                        //GetepayRequeryResponse requeryResponse = Getepay.requeryRequest(config, getepayRequery);
                        //  Console.WriteLine("11", requeryResponse.txnStatus);
                        // string rns=requeryResponse.txnStatus.ToString();

                        GetepayRequest request = new GetepayRequest();

                        request.mid = mid.ToString();
                        request.amount = TextBox3.Text;
                        request.merchantTransactionId = bnd;
                        request.transactionDate = System.DateTime.Now.ToString("yyyy-mm-dd hh:mm:ss");//2024-02-16 04:31:23
                        request.terminalId = terminal_Id.ToString();
                        request.udf1 = dsrajneeti.Tables[0].Rows[0]["Mobile_1"].ToString();
                        request.udf2 = "ndba.patialahousecourt@gmail.com";
                        request.udf3 = dsrajneeti.Tables[0].Rows[0]["F_name"].ToString() + " " + dsrajneeti.Tables[0].Rows[0]["M_name"].ToString() + " " + dsrajneeti.Tables[0].Rows[0]["L_name"].ToString();
                        request.udf4 = "";
                        request.udf5 = "";
                        request.udf6 = "";
                        request.udf7 = "";
                        request.udf8 = "";
                        request.udf9 = "";
                        request.udf10 = murl;
                        request.ru = "https://newdelhibarassociation.in/Paymentstatus.aspx";
                        // request.ru = "https://localhost:44346/Paymentstatus.aspx";
                        request.callbackUrl = "https://newdelhibarassociation.in/Paymentstatus.aspx";
                        request.callbackUrl = "";
                        request.currency = "INR";
                        request.paymentMode = "ALL";
                        request.bankId = "";
                        request.txnType = "";
                        request.productType = "";
                        request.txnNote = "";
                        request.vpa = "";

                        // GetepayRequest getreq= new GetepayRequest(config,request);

                        GetepayOrderResponse orderResponse = Getepay.generateRequest(config, request);
                        //Session["pid"] = orderResponse.paymentId;

                        HttpCookie nameCookie = new HttpCookie("Siteid");
                        nameCookie = Request.Cookies["Siteid"];
                        string valss = nameCookie.Value.Replace("Siteid=", "");
                        string up = "update newdelhibar_bill set payment_id='" + orderResponse.paymentId.ToString() + "' where Billno='" + bnd + "'";
                        obj.SaveRecord(up);
                        Response.Redirect(orderResponse.paymentUrl, true);
                        //string rrn=orderResponse.ToString();
                    }
                    catch (Exception ex)
                    {
                        RegisterStartupScript("12", "<script>alert('" + ex.Message.ToString() + "')</script>");

                    }
                }

            }
            else
            {
                RegisterStartupScript("12", "<script>alert('OTP not vaild.')</script>");
            }
        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            Panel2.Visible = true;
            Panel1.Visible = false;
            string[] saAllowedCharacters = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "0" };

            string sRandomOTP = GenerateRandomOTP(4, saAllowedCharacters);
            HiddenField1.Value = sRandomOTP;
            string messag = " NDBA User, Your OTP is " + sRandomOTP + ". Do Not share this with anyone. TEAM NDBA";
            string SmsStatusMsg = string.Empty;
            WebClient client = new WebClient();
           // string mm = "9871482014";
            if (Literal1.Text != "0")
            {
                string URL = "http://www.canlog.in/api/mt/SendSMS?user=NDBA1234&password=NDBA1234&senderid=NDBATM&channel=Trans&DCS=0&flashsms=0&number=" + Literal1.Text + "&text=" + messag + "&route=2";

                SmsStatusMsg = client.DownloadString(URL);
                if (SmsStatusMsg.Contains("<br>"))
                {
                    SmsStatusMsg = SmsStatusMsg.Replace("<br>", ", ");

                }
            }
            else
            {
                RegisterStartupScript("12", "<script>alert('number not valid')</script>");
            }

        }
    }
}