예제 #1
0
        public DataTable DMT_Get_CustomerBeneficiary(DMT_GetBeneClass obj)
        {
            //SqlParameter[] param = new SqlParameter[2];
            //param[0] = new SqlParameter("@UserId", obj.UserId.ToString());
            //param[1] = new SqlParameter("@CustomerMobile", obj.CustomerMobile);

            string[,] param = { { "UserId", obj.UserId.ToString() }, { "CustomerMobile", obj.CustomerMobile } };
            DataTable dtTemp = sqlhelper.ExecuteProcForDataTable("DMT_GET_CUSTOMRBENEFICIARY", param);

            return(dtTemp);
        }
        public COM.MEMBERS.SQLReturnMessageNValue CheckValidation(int operator_code, string NumToRch, string Amount, string AccountNo)
        {
            string[,] param = { { "operator_code", operator_code.ToString() } };
            DataTable dtTemp = sqlhelper.ExecuteProcForDataTable("CYBERPLAT_VALIDATION", param);

            if (dtTemp.Rows.Count > 0)
            {
                if (!string.IsNullOrWhiteSpace(NumToRch))
                {
                    Regex regex = new Regex(dtTemp.Rows[0]["auth_regex"].ToString());
                    Match match = regex.Match(NumToRch);
                    if (!match.Success)
                    {
                        M.Outval = 0; M.Outmsg = dtTemp.Rows[0]["auth_msg"].ToString(); return(M);
                    }
                }
                else
                {
                    M.Outval = 0; M.Outmsg = "number is required!"; return(M);
                }
                if (dtTemp.Rows[0]["auth_name2"].ToString() != "N")
                {
                    if (!string.IsNullOrWhiteSpace(AccountNo))
                    {
                        Regex regex = new Regex(dtTemp.Rows[0]["auth_regex2"].ToString());
                        Match match = regex.Match(AccountNo);
                        if (!match.Success)
                        {
                            M.Outval = 0; M.Outmsg = dtTemp.Rows[0]["auth_msg2"].ToString(); return(M);
                        }
                    }
                    else
                    {
                        M.Outval = 0; M.Outmsg = "parameters 2 Required!"; return(M);
                    }
                }
                M.Outval = 1; M.Outmsg = "Validated"; return(M);
            }
            return(M);
        }