示例#1
0
        // POST: api/WealthPlanList
        //public void Post([FromBody]string value)
        //public WealthPlanListResponse Post([FromBody]string value)
        public WealthPlanListResponse Post(WealthPlanList wealthPlanList)
        {
            WealthPlanListPersistance wealthPlanListPersistance = new WealthPlanListPersistance();

            if (wealthPlanListPersistance == null)
            {
                throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound));
            }

            //WealthPlan wealthPlan = new WealthPlan();

            return(wealthPlanListPersistance.GetWealthPlanList(wealthPlanList));
        }
        //public ArrayList GetWealthPlan(WealthPlan wealthPlan)
        public WealthPlanListResponse GetWealthPlanList(WealthPlanList wealthPlanList)
        {
            /*
             * OdbcConnection conn = null;
             * OdbcCommand command = null;
             * OdbcDataReader mySQLReader = null;
             */

            SqlConnection conn        = null;
            SqlCommand    command     = null;
            SqlDataReader mySQLReader = null;

            List <WealthPlanListName> wealthPlanListName = new List <WealthPlanListName>();

            WealthPlanListName wpln = null;

            WealthPlanListResponse wealthPlanListResponse = new WealthPlanListResponse();

            wealthPlanListResponse.Message = "Not Found";
            wealthPlanListResponse.Status  = "Fail";

            try
            {
                string myConnectionString = ConfigurationManager.ConnectionStrings["localDB"].ConnectionString;;
                //conn = new OleDbConnection(myConnectionString);
                conn = new SqlConnection(myConnectionString);

                conn.Open();

                //command = new OleDbCommand();
                command                = new SqlCommand();
                command.Connection     = conn;
                command.CommandTimeout = 0;

                SqlParameter param = null;

                //--------------------------------  Check WealthPlanName  ----------------
                command.CommandType = CommandType.Text;
                command.CommandText = "select wp.WealthPlanName, li.Mobile_No from SrvA_WealthPlan_Cloud wp left join SrvA_Login_Cloud li on wp.AccessToken = li.AccessToken and wp.Flag = 1 where Mobile_No = (select top 1 Mobile_No from SrvA_Login_Cloud where Flag = 1 and AccessToken = @AccessToken)";

                command.Parameters.Clear();
                param = null;

                param           = new SqlParameter("@AccessToken", System.Data.SqlDbType.NVarChar, -1); //nvarchar(max)
                param.Value     = wealthPlanList.AccessToken == null ? "" : wealthPlanList.AccessToken.Trim();
                param.Direction = ParameterDirection.Input;
                command.Parameters.Add(param);

                mySQLReader = command.ExecuteReader();

                while (mySQLReader.Read())
                {
                    wpln = new WealthPlanListName();

                    wpln.WealthPlanName = mySQLReader.GetString(mySQLReader.GetOrdinal("WealthPlanName"));
                    wealthPlanListName.Add(wpln);
                    //wealthPlanListName.WealthPlanName = mySQLReader.GetString(mySQLReader.GetOrdinal("WealthPlanName"));
                    //mySQLReader.GetString(mySQLReader.GetOrdinal("UnitHolder"));
                    //forgotResponse.Message = mySQLReader.GetDataTypeName(mySQLReader.GetOrdinal("Mobile_No"));
                    //forgotResponse.Message = mySQLReader.GetValue(mySQLReader.GetOrdinal("Mobile_No")).ToString();
                    //wealthPlan.Mobile_No = mySQLReader.GetString(mySQLReader.GetOrdinal("Mobile_No"));
                    //forgotResponse.Message = "Waiting for OTP";
                }
                mySQLReader.Close();
                //--------------------------------  /Check WealthPlanName  ----------------
                wealthPlanListResponse.Data    = wealthPlanListName;
                wealthPlanListResponse.Message = "Success";
                wealthPlanListResponse.Status  = "OK";

                return(wealthPlanListResponse);
            }

            catch (Exception ex)
            {
                wealthPlanListResponse.Message = ex.ToString();
                wealthPlanListResponse.Status  = "Fail";
                return(wealthPlanListResponse);
            }
            finally
            {
                if (mySQLReader != null)
                {
                    mySQLReader.Close();
                }
                if (conn != null)
                {
                    conn.Close();
                }
            }
        }