Help with some C#?

[Dan Czarnecki]

Ok, so here's the problem I'm having right now.

This project I'm working on for my web development class, a license plate database, is having an issue performing a search.

Here is the code I have right now for the elements that work with the search:

namespace LicensePlateCollection.Models
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    [Table("Country")]
    public partial class Country
    {
        public Country()
        {
            Plates = new HashSet<Plate>();
        }

        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        [Display(Name="Country")]
        public int CountryID { get; set; }

        [StringLength(50)]
        [Display(Name="Country")]
        public string CountryName { get; set; }

        public virtual ICollection<Plate> Plates { get; set; }
    }
}


using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Net;
using System.Web;
using System.Web.Mvc;
using LicensePlateCollection.Models;

namespace LicensePlateCollection.Controllers
{
    public class PlatesController : Controller
    {
        private LicensePlateCollectionContext db = new LicensePlateCollectionContext();

        // GET: Plates
        public ActionResult Index()
        {
        //    var plates = db.Plates.Include(p => p.Country).Include(p => p.State_Province).Include(p => p.Type);
        //    return View(plates.ToList());
            return View();
        }

        public ActionResult Index(CountryName)
        {
           
        }

        // GET: Plates/Details/5
        public ActionResult Details(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            Plate plate = db.Plates.Find(id);
            if (plate == null)
            {
                return HttpNotFound();
            }
            return View(plate);
        }

        // GET: Plates/Create
        public ActionResult Create()
        {
            ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "CountryName");
            ViewBag.StateID = new SelectList(db.State_Province, "State_ProvinceID", "State_ProvinceName");
            ViewBag.TypeID = new SelectList(db.Types, "TypeID", "Description");
            return View();
        }

        // POST: Plates/Create
        // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
        // more details see http://go.microsoft.com/fwlink/?LinkId=317598.
        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult Create([Bind(Include = "LicensePlateID,Year,CountryID,StateID,TypeID")] Plate plate)
        {
            if (ModelState.IsValid)
            {
                db.Plates.Add(plate);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "CountryName", plate.CountryID);
            ViewBag.StateID = new SelectList(db.State_Province, "State_ProvinceID", "State_ProvinceName", plate.StateID);
            ViewBag.TypeID = new SelectList(db.Types, "TypeID", "Description", plate.TypeID);
            return View(plate);
        }

        // GET: Plates/Edit/5
        public ActionResult Edit(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            Plate plate = db.Plates.Find(id);
            if (plate == null)
            {
                return HttpNotFound();
            }
            ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "CountryName", plate.CountryID);
            ViewBag.StateID = new SelectList(db.State_Province, "State_ProvinceID", "State_ProvinceName", plate.StateID);
            ViewBag.TypeID = new SelectList(db.Types, "TypeID", "Description", plate.TypeID);
            return View(plate);
        }

        // POST: Plates/Edit/5
        // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
        // more details see http://go.microsoft.com/fwlink/?LinkId=317598.
        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult Edit([Bind(Include = "LicensePlateID,Year,CountryID,StateID,TypeID")] Plate plate)
        {
            if (ModelState.IsValid)
            {
                db.Entry(plate).State = EntityState.Modified;
                db.SaveChanges();
                return RedirectToAction("Index");
            }
            ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "CountryName", plate.CountryID);
            ViewBag.StateID = new SelectList(db.State_Province, "State_ProvinceID", "State_ProvinceName", plate.StateID);
            ViewBag.TypeID = new SelectList(db.Types, "TypeID", "Description", plate.TypeID);
            return View(plate);
        }

        // GET: Plates/Delete/5
        public ActionResult Delete(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            Plate plate = db.Plates.Find(id);
            if (plate == null)
            {
                return HttpNotFound();
            }
            return View(plate);
        }

        // POST: Plates/Delete/5
        [HttpPost, ActionName("Delete")]
        [ValidateAntiForgeryToken]
        public ActionResult DeleteConfirmed(int id)
        {
            Plate plate = db.Plates.Find(id);
            db.Plates.Remove(plate);
            db.SaveChanges();
            return RedirectToAction("Index");
        }

        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                db.Dispose();
            }
            base.Dispose(disposing);
        }
    }
}


namespace LicensePlateCollection.Models
{
    using System;
    using System.Data.Entity;
    using System.Linq;

    public class SearchModel
    {
        public String CountryName { get; set; }
        public String State_ProvinceName { get; set; }
    }
}

@model LicensePlateCollection.Models.SearchModel

@{
    ViewBag.Title = "Index";
}

<h2>Search</h2>
<p>
    @Html.ActionLink("Create New", "Create")
</p>

@using(Html.BeginForm())
{
    @Html.LabelFor(m => m.CountryName);
    @Html.EditorFor(m => m.CountryName);
}

Most of the code was just generated directly with the tools in Visual Studio, but you'll probably be able to figure out the code which is mine.

I know there's something that I need to add in order to get the search to actually work, but I can't seem to exactly figure that out.

Any help would be appreciated.

Thanks in advance.

[Paul Clapham]

Dan Czarnecki wrote:This project I'm working on for my web development class, a license plate database, is having an issue performing a search.

Did you mention somewhere in your post what that issue was? I didn't see it, but there was a lot of code so maybe I scrolled right by it. When trying to solve a problem, it does help to know what the problem is.