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(); } } }