public Int32 ValidateOTP(OtpValidationVM _vm)
{
try
{
using (SqlCommand dataCmd = new SqlCommand("ValidateOTP", objCommonDB.con))
{
dataCmd.CommandType = CommandType.StoredProcedure;
dataCmd.Parameters.AddWithValue("@flag", _vm._flag);
dataCmd.Parameters["@flag"].Direction = ParameterDirection.InputOutput;
dataCmd.Parameters.Add(new SqlParameter("@otp", _vm._otp));
dataCmd.Parameters.Add(new SqlParameter("@UserId", _vm._userId));
dataCmd.Parameters.Add(new SqlParameter("@IPAddress", _vm._ipAddress));
dataCmd.Parameters.Add(new SqlParameter("@OSVersion", _vm._osVersion));
dataCmd.Parameters.Add(new SqlParameter("@OtherDetail", _vm._otherDetail));
dataCmd.Parameters.Add(new SqlParameter("@ExeType", _vm._exeType));
if (objCommonDB.con.State == ConnectionState.Closed)
{
objCommonDB.con.Open();
}
dataCmd.ExecuteNonQuery();
return(Convert.ToInt32(dataCmd.Parameters["@flag"].Value));
}
}
catch (Exception ex)
{
return(0);
}
finally
{
if (objCommonDB.con.State == ConnectionState.Open)
{
objCommonDB.con.Close();
}
}
}
