Wednesday 6 February 2019

Get query string data in mvc

////////////////////// LoginController


using GoNoise.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data;
using System.Web.UI;

namespace LoginTest.Controllers
{
    public class LoginController : Controller
    {


public string VerifyUserEmail(string id,string Email)
        {
            SqlParameter[] parmdel = new SqlParameter[]
                   {
                   new SqlParameter("@UserEmailID",Email),
                   new SqlParameter("@EmailOTP",id)

                  };
            int result = ConnectionClass.ExecuteNonQuery(ConnectionClass.con, CommandType.StoredProcedure, "sp_userverify_Email", parmdel);
            string msg = "Invalid OTP, Please try again.";
            if (result>0)
            {
                msg = "Email verification is completed";
            }
            return "<div style='font-size: 20px;color: green;position: absolute;top: 20%;left: 35%; border: solid 1px #bfdac0;padding: 20px 30px; '> <img src='../images/done.png' / style=margin-right: 12px; margin-bottom: -9px;'>" + msg+"</div>";
        }
   }
}

///////////////////// HTML new page

@{

    Layout = null;
} 
<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>VerifyUserEmail</title>
</head>
<body>
   
</body>
</html>





No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...