public string RequestOTP(clsRequestOTP objclsRequestOTP) { using (ClsUser_DAL obj = new ClsUser_DAL()) { return(obj.RequestOTP(objclsRequestOTP)); } }
public string RequestOTP(clsRequestOTP objclsRequestOTP) { try { string Response = ""; DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@Ref_User_ID", objclsRequestOTP.Ref_User_ID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@OTP", objclsRequestOTP.OTP, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Flag", objclsRequestOTP.Flag, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Type", objclsRequestOTP.Type, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@IsValidate", objclsRequestOTP.IsValidate, DbType.Boolean); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); DataSet ds = objDbHelper.ExecuteDataSet(Constant.RequestOTP, ObJParameterCOl, CommandType.StoredProcedure); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { Response = ds.Tables[0].Rows[0]["RESPONSE"].ToString(); } } return(Response); } catch (Exception ex) { throw ex; } }