Web Development

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Drawing;
using System.IO;




public partial class Main_frmIndex : System.Web.UI.Page
{
    CommonBL BL = new CommonBL();
    protected void Page_Load(object sender, EventArgs e)
    {
        AssignData();
    }

    private void AssignData()
    {
        DataSet ds = new DataSet();
        ds = BL.GetDataSet("Select top 2 id,Product_Category,Category_id,Prd_Name,Prd_Pack,Prd_Details,Prd_Indication,PackImage,ProductLogo,pId from tbl_Products Inner join tbl_CategoryMaster On tbl_Products.Category_id = tbl_CategoryMaster.pId where tbl_Products.Active= 1 and tbl_Products.DeletedFlag =0 and tbl_CategoryMaster.Active= 1 and tbl_CategoryMaster.DeletedFlag =0 order by tbl_Products.UpdatedDate desc");
        StringBuilder strShow = new StringBuilder();
        strShow = strShow.AppendLine("<table width='100%' border='0' cellspacing='0' cellpadding='0'><tr>");

        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            if (i == 0)
            {
                strShow = strShow.AppendLine("<td width='50%' class='rightline'  valign='top' align='left'>");
            }
            else
            {
                strShow = strShow.AppendLine("<td width='50%' valign='top' align='left' class='padl10'>");
            }
            strShow = strShow.AppendLine("<table border='0' width='100%' cellpadding='0' cellspacing='0'>");
            strShow = strShow.AppendLine("<tr><td class='subheader vat padt10'>" + ds.Tables[0].Rows[i]["Product_Category"] + "</td></tr>");
            strShow = strShow.AppendLine("<tr><td class='padt10'><img src='../Uploads/Products/" + ds.Tables[0].Rows[i]["PackImage"] + "' width='124' height='114' alt='' /></td></tr>");
            //strShow = strShow.AppendLine("<tr><td>" + ds.Tables[0].Rows[i]["Prd_Name"] + "<br/>" + ds.Tables[0].Rows[i]["Prd_Details"] + "<br/></td></tr>");
            strShow = strShow.AppendLine("<tr><td>" + ds.Tables[0].Rows[i]["Prd_Name"] + "</td></tr>");
            strShow = strShow.AppendLine("<tr><td class='padr5 padb15'><a class='more' href='../Main/frmProductDetails.aspx?id=" + ds.Tables[0].Rows[i]["Id"].ToString() + "'>more...</a></td></tr></table></td>");
        }
        strShow.AppendLine("</tr></table>");


        lblShow.InnerHtml = strShow.ToString();
    }
}

body {

    .field-validation-error     {color:#f00;}
    .field-validation-valid     {display:none;}
    .input-validation-error     {border:1px solid #f00; background-color: #fee}
    .validation-summary-errors   {font-weight: bold; color #f00;}
    .validation-summary-valid    {display: none;}
}

Line 22:     using System.Web.WebPages;
Line 23:     using System.Web.Mvc;
Line 24:     using System.Web.Mvc.Ajax;                 <==== ERROR HERE IN RED
Line 25:     using System.Web.Mvc.Html;
Line 26:     using System.Web.Routing;

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