从详细信息中搜索日期asp.Net mvc 5 [英] Search date from the detail asp.Net mvc 5

问题描述

点击搜索后，什么都没发生我正在尝试使用date属性过滤详细信息首先在asp.net mvc 5代码中.但它不起作用.我只创建了一个模型类，代码首先从该模型类中生成一个控制器并对其进行查看.现在，我想针对日期过滤索引页面上的详细信息.这是我正在使用的代码.

on clicking search,nothing happenI am trying to filter the detail with date property in asp.net mvc 5 code first. but it's not working. i have only create a model class from which code first generate a controller and view for it. now i want to filter the detail on the index page with respect to date. here is the code i am using.

模型类:-

 public class Meeting
 {
    public int MeetingID { get; set; }
    public String Name { get; set; }
    public String designation { get; set; }
    [Display(Name = "9:00 - 10:00")]
    public String NineToTen { get; set; }
    [Display(Name = "10:00 - 11:00")]
    public String TenToEleven { get; set; }
    [Display(Name = "11:00 - 12:00")]
    public String ElevenToTwelve { get; set; }
    [Display(Name = "12:00 - 1:00")]
    public String TwelveToOne { get; set; }
    [Display(Name = "1:00 - 2:00")]
    public String OneToTwo { get; set; }
    [Display(Name = "2:00 - 3:00")]
    public String TwoToThree { get; set; }
    [Display(Name = "3:00 - 4:00")]
    public String ThreeToFour { get; set; }
    [Required(ErrorMessage = "Please Enter the Date")]
    [DataType(DataType.Date)]
    [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}", ApplyFormatInEditMode = false)]
    [Display(Name = "Meeting Date")]
    public DateTime Date { 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 MSS.Models;

namespace MSS.Controllers
{
    public class MeetingController : Controller
    {
        private OurDbContext db = new OurDbContext();

        // GET: /Meeting/
        public ActionResult Index(DateTime? fromDate, DateTime? toDate)
    {
        if (!fromDate.HasValue) fromDate = DateTime.Now.Date;
        if (!toDate.HasValue) toDate = fromDate.GetValueOrDefault(DateTime.Now.Date).Date.AddDays(1);
        if (toDate < fromDate) toDate = fromDate.GetValueOrDefault(DateTime.Now.Date).Date.AddDays(1);
        ViewBag.fromDate = fromDate;
        ViewBag.toDate = toDate;
        var Meeting = db.meeting.Where(c => c.Date >= fromDate && c.Date < toDate).ToList();

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

        // GET: /Meeting/Create
        public ActionResult Create()
        {
            return View(new Meeting { Name = User.Identity.Name });
        }

        // POST: /Meeting/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="MeetingID,Name,designation,NineToTen,TenToEleven,ElevenToTwelve,TwelveToOne,OneToTwo,TwoToThree,ThreeToFour,Date")] Meeting meeting)
        {
            if (ModelState.IsValid)
            {
                db.meeting.Add(meeting);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            return View(meeting);
        }

        // GET: /Meeting/Edit/5
        public ActionResult Edit(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            Meeting meeting = db.meeting.Find(id);
            if (meeting == null)
            {
                return HttpNotFound();
            }
            return View(meeting);
        }

        // POST: /Meeting/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="MeetingID,Name,designation,NineToTen,TenToEleven,ElevenToTwelve,TwelveToOne,OneToTwo,TwoToThree,ThreeToFour,Date")] Meeting meeting)
        {
            if (ModelState.IsValid)
            {
                db.Entry(meeting).State = EntityState.Modified;
                db.SaveChanges();
                return RedirectToAction("Index");
            }
            return View(meeting);
        }

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

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

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

查看:-

  @model IEnumerable<MSS.Models.Meeting>

  @{
    ViewBag.Title = "Index";
  }

  <h2>Index</h2>

  <p>
   @Html.ActionLink("Create New", "Create")
  </p>
  @{
    var fromDate = (DateTime)ViewBag.fromDate;
    var toDate = (DateTime)ViewBag.toDate;
  }

 @using (Html.BeginForm("Index", "Meeting", FormMethod.Get))
 {
    <div>
        From Date: @Html.TextBox("fromDate", string.Format("{0:dd MMM yyy}", fromDate), new { @class = "datefield", type = "date" })
        To Date: @Html.TextBox("toDate", string.Format("{0:dd MMM yyy}", fromDate), new { @class = "datefield", type = "date" })
        <input type="submit" value="Search" />
    </div>
}
<table class="table">
 <tr>
     <th>
         @Html.DisplayNameFor(model => model.Name)
     </th>
     <th>
         @Html.DisplayNameFor(model => model.designation)
     </th>
     <th>
         @Html.DisplayNameFor(model => model.NineToTen)
     </th>
     <th>
         @Html.DisplayNameFor(model => model.TenToEleven)
     </th>
     <th>
         @Html.DisplayNameFor(model => model.ElevenToTwelve)
     </th>
     <th>
         @Html.DisplayNameFor(model => model.TwelveToOne)
     </th>
     <th>
         @Html.DisplayNameFor(model => model.OneToTwo)
     </th>
     <th>
         @Html.DisplayNameFor(model => model.TwoToThree)
     </th>
     <th>
         @Html.DisplayNameFor(model => model.ThreeToFour)
     </th>
     <th>
         @Html.DisplayNameFor(model => model.Date)
     </th>
     <th></th>
 </tr>

 @foreach (var item in Model) {
 <tr>
    <td>
        @Html.DisplayFor(modelItem => item.Name)
    </td>
    <td>
        @Html.DisplayFor(modelItem => item.designation)
    </td>
    <td>
        @Html.DisplayFor(modelItem => item.NineToTen)
    </td>
    <td>
        @Html.DisplayFor(modelItem => item.TenToEleven)
    </td>
    <td>
        @Html.DisplayFor(modelItem => item.ElevenToTwelve)
    </td>
    <td>
        @Html.DisplayFor(modelItem => item.TwelveToOne)
    </td>
    <td>
        @Html.DisplayFor(modelItem => item.OneToTwo)
    </td>
    <td>
        @Html.DisplayFor(modelItem => item.TwoToThree)
    </td>
    <td>
        @Html.DisplayFor(modelItem => item.ThreeToFour)
    </td>
    <td>
        @Html.DisplayFor(modelItem => item.Date)
    </td>
    <td>
        @Html.ActionLink("Edit", "Edit", new { id=item.MeetingID }) |
        @Html.ActionLink("Details", "Details", new { id=item.MeetingID }) |
        @Html.ActionLink("Delete", "Delete", new { id=item.MeetingID })
    </td>
</tr>
}

推荐答案

您将返回完整的数据集，而不是返回已过滤的数据.您可能想尝试以下行-

You are returning the complete dataset instead of returning the filtered data. You might wanna try the below line -

return View(Meeting);

这篇关于从详细信息中搜索日期asp.Net mvc 5的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！