Web Development

@model MvcApplication1.Models.UserProfile

@{
    ViewBag.Title = "UserProfile";
}
 
<form method="post"> 
    <input type="text" name="userName" />
    <input type="submit" value="Search By Name" />
</form>

<div id="restaurantList">
    @foreach (var item in ViewBag.users)
    {
        <div>
            <h4>@item.UserName</h4>
            <div>
                @item.Country
            </div>
            <div>
                Mail: @item.Email
            </div>
            <hr />
        </div>
    }
</div>

 <script src="~/Scripts/jquery-1.8.2.min.js"></script>
<script src="~/Scripts/jquery-ui-1.9.2.min.js"></script> 
@Styles.Render("~/Content/themes/base/css")

<script type="text/javascript">
    $(document).ready(function () {
        
        $("#userName").autocomplete({
            source: function (request, response) {
                 
                $.ajax({
                    url: "~/Home/AutoCompleteName",
                    type: "POST",
                    dataType: "json",
                    data: { term: request.term },
                    success: function (data) {
                        response($.map(data, function (item) {
                            return { label: item.Country, value: item.Country };
                        }))
                    }
                })
            },
            messages: {
                noResults: "", results: ""
            }
        });
    })
</script>

 public ActionResult UserProfile(string userName = null)
{
            string conString = "User Id=RDB; password=RDB; Data Source=172.18.164.146:1521/XE; Pooling=false;";

            OracleConnection con = new OracleConnection();
            con.ConnectionString = conString;
            con.Open();

            OracleCommand cmd = con.CreateCommand();
            cmd.CommandText = "select USR_USERNAME, USR_COUNTRY, USR_EMAIL_ADDR from OBRS_USER";

            OracleDataReader reader = cmd.ExecuteReader();
            _db.UserProfiles = new List<Models.UserProfile>();
            UserProfile user;
            while (reader.Read())
            {
                user = new UserProfile();
                user.UserName = reader.GetString(0);
                user.Country = reader.GetString(1);
                user.Email = reader.GetString(2); 
                _db.UserProfiles.Add(user);
            } 
            var model =
                _db.UserProfiles
                   .OrderByDescending(r => r.UserName)
                   .Where(r => userName == null || r.UserName.StartsWith(userName));
                            ViewBag.users = model;
            return View();
        }

        public JsonResult AutoCompleteName(string term)
        {
            var result = (from r in _db.UserProfiles
                          where r.UserName.ToLower().Contains(term.ToLower())
                          select new { r.UserName }).Distinct();
            return Json(result, JsonRequestBehavior.AllowGet);
        }