1. I am planning to implement a partial View which has a table to display Purchase History of selected Customer, when a new item is selected in the View fields, then the partial View should display the values in the Table, but I don't know how to render partial view when using Web Api
2. Another one is same this partial view contains one dropdown list, list box, add and delete buttons, when we select an item from dropdown list and say add then it will add in the listbox, when we select from listbox and say delete it will delete from the listbox. But by default when a Customer is selected it will display the selected items of this purchase in the Listbox.

        public object Get()
        {<br />
            dynamic model = null;

            using (AppDevSecEntities ctx = new AppDevSecEntities())
            {
                BSCCrystalReportsViewerEntities ctx2 = new BSCCrystalReportsViewerEntities();

                string maxCustId = ctx.Customers.OrderByDescending(x => x.LastName).First().CustId;
        DataTable Orders = Common.ConvertToDataTable<Order>(ctx.Orders.Where(x=> x.CustId==maxCustId));
        DataTable SelectedProducts = Common.ConvertToDataTable<Product>(ctx.Products.Where(x=> x.CustId==maxCustId));

                //return
                model= 
                    new
                    {
                        SingleCustomer = ctx.spGetShortSingleCustomer(maxCustId).FirstOrDefault(),
                        Orders = Common.ConvertToDataTable<Order>(ctx.Orders.Where(x=> x.CustId==maxCustId)), //This is DataTable type
            SelectedProducts = Common.ConvertToDataTable<Product>(ctx.Products.Where(x=> x.CustId==maxCustId)) //This is DataTable type
                    };
            }

            return model;
        }

public object Get()
        {<br />
            dynamic model = null;

            using (AppDevSecEntities ctx = new AppDevSecEntities())
            {
                BSCCrystalReportsViewerEntities ctx2 = new BSCCrystalReportsViewerEntities();

                string maxCustId = ctx.Customers.OrderByDescending(x => x.LastName).First().CustId;
        DataTable Orders = Common.ConvertToDataTable<Order>(ctx.Orders.Where(x=> x.CustId==maxCustId));
        DataTable SelectedProducts = Common.ConvertToDataTable<Product>(ctx.Products.Where(x=> x.CustId==maxCustId));

                //return
                model= 
                    new
                    {
                        SingleCustomer = ctx.spGetShortSingleCustomer(maxCustId).FirstOrDefault(),
                        Orders = Common.ConvertToDataTable<Order>(ctx.Orders.Where(x=> x.CustId==maxCustId)), //This is DataTable type
            SelectedProducts = Common.ConvertToDataTable<Product>(ctx.Products.Where(x=> x.CustId==maxCustId)) //This is DataTable type
                    };
            }

            return model;
        }

        $.get("/api/EmployeeAPI/Get").then(function (data) {

            var list = $("#ddlProduct");
            var selectedValue = list.val();

            list.empty();

            $.each(data.Products, function (index, Product) {
                $("<option>").attr("value", Product.ProductID).text(Product.ProductName).appendTo(list);
            });

            if ((selectedValue == null) || (selectedValue == undefined)) {
                list.prepend("<option value='-1' selected='selected'>Select value</option>");
                list[0].selectedIndex = 0;
            }
            else {
                list.val(selectedValue);
            }           

            var date;

            if ((data.SingleCustomer.PurchaseDate != null) && (data.SingleCustomer.PurchaseDate != '') && (data.SingleCustomer.PurchaseDate != 'undefined')) {
                date = data.SingleCustomer.PurchaseDate;
                var d = new Date(date.split("/").reverse().join("-"));
                var dd = d.getDate();
                var mm = d.getMonth() + 1;

                if (dd < 10) { dd = '0' + dd }
                if (mm < 10) { mm = '0' + mm }

                var yy = d.getFullYear() + "";
                var Purchasedday = yy + "-" + mm + "-" + dd;

                $("#dtFieldPurchaseDate").val(Purchasedday);
            }

            if ((data.SingleCustomer.RePurchaseDate != null) && (data.SingleCustomer.RePurchaseDate != '') && (data.SingleCustomer.RePurchaseDate != 'undefined')) {
                date = data.SingleCustomer.RePurchaseDate;
                var d = new Date(date.split("/").reverse().join("-"));
                var dd = d.getDate();
                var mm = d.getMonth() + 1;

                if (dd < 10) { dd = '0' + dd }
                if (mm < 10) { mm = '0' + mm }

                var yy = d.getFullYear() + "";
                var Purchasedday = yy + "-" + mm + "-" + dd;

                $("#dtFieldRePurchaseDate").val(Purchasedday);
            }
        });

public ActionResult UploadFiles(int? id)
       {
           CI cI = db.Database.Find(id);
           foreach (string upload in Request.Files)
           {

               if (Request.Files[upload].FileName != "")

               {
                   string path = Server.MapPath("~/App_Data/uploads/" + id + "/");
                   string filename = Path.GetFileName(Request.Files[upload].FileName);
                   Response.Write(path);

                   Request.Files[upload].SaveAs(Path.Combine(path, filename));

               }
           }

           return View("Upload");
       }

@{
    ViewBag.Title = "Upload";
}

<h2>Upload</h2>
<script src="~/Scripts/jquery-1.11.1.min.js"></script>
<script>
    $(document).ready(function () {
        $('#btnUploadFile').on('click', function () {
            var data = new FormData();
            var files = $("#fileUpload").get(0).files;
            // Add the uploaded image content to the form data collection
            if (files.length > 0) {
                data.append("UploadedImage", files[0]);
            }
            // Make Ajax request with the contentType = false, and procesDate = false
            var ajaxRequest = $.ajax({
                type: "POST",
                url: "",
                contentType: false,
                processData: false,
                data: data
            });

            ajaxRequest.done(function (xhr, textStatus) {
                @ViewBag.Message
            });
        });
    });
</script>
<input type="file" name="FileUpload1" id="fileUpload" /><br />
<input id="btnUploadFile" type="button" value="Upload File" />
@Html.ActionLink("Documents", "Downloads")

The remote name could not be resolved: 'smtp.gmail.com'

Source File: e:\Vijaya\Online_Book_Shopping\ForgetPassword.aspx.cs Line: 62

}

protected void Button1_Click(object sender, EventArgs e)
{
    string username = "";
    string password = "";
    string constr = ConfigurationManager.ConnectionStrings["CS"].ConnectionString;
    SqlConnection con = new SqlConnection(constr);
    {

        SqlCommand cmd = new SqlCommand("select Name, Password from dbo.RegisteredUsers where Email=@email", con);
        cmd.Parameters.AddWithValue("Email", txtemail.Text);
        con.Open();
        using (SqlDataReader dr = cmd.ExecuteReader())
        {
            if (dr.Read())
            {
                username = dr["Name"].ToString();
                password = dr["Password"].ToString();

            }

        }
        con.Close();

        if (!string.IsNullOrEmpty(username))
        {
            MailMessage msg = new MailMessage();
            msg.From = new MailAddress("nilusilu3@gmail.com");
            msg.To.Add(txtemail.Text);
            msg.Subject = " Recover your Password";
            msg.Body = ("Your Username is:" + username + "<br/><br/>" + "Your Password is:" + password);
            msg.IsBodyHtml = true;

            SmtpClient smt = new SmtpClient();
            smt.Host = "smtp.gmail.com";
            System.Net.NetworkCredential ntwd = new NetworkCredential();
            ntwd.UserName = "nilusilu3@gmail.com"; //Your Email ID<br />
            ntwd.Password = ""; // Your Password<br />
            smt.UseDefaultCredentials = true;
            smt.Credentials = ntwd;
            smt.Port = 587;
            smt.EnableSsl= true;
            smt.Send(msg);
            lblmsg.Text = "Username and Password Sent Successfully";
            lblmsg.ForeColor = System.Drawing.Color.ForestGreen;
        }
    }

}

        public DataSet Get()
        {
            DataSet dsAllListsOfForm = new DataSet();
            dsAllListsOfForm.Tables.Clear();

            dynamic objCollection; DataTable table;
            using (AppDevSecEntities ctx = new AppDevSecEntities())
            {
                objCollection = (from c in ctx.Departments orderby c.DepartmentName select c).AsQueryable();
                table = Common.ConvertToDataTable<Department>(objCollection);
                dsAllListsOfForm.Tables.Add(table);

                objCollection = (from c in ctx.FunctionalCatagories orderby c.FunctionalCatagoryName select c).AsQueryable();
                table = Common.ConvertToDataTable<FunctionalCatagory>(objCollection);
                dsAllListsOfForm.Tables.Add(table);

                objCollection = (from c in ctx.BusinessUnits orderby c.BusinessUnitName select c).AsQueryable();
                table = Common.ConvertToDataTable<BusinessUnit>(objCollection);
                dsAllListsOfForm.Tables.Add(table);

                objCollection = (from c in ctx.Locations orderby c.LocationName select c).AsQueryable();
                table = Common.ConvertToDataTable<Location>(objCollection);
                dsAllListsOfForm.Tables.Add(table);
            }

            return dsAllListsOfForm;
       }