I have three tables in my MSSQL database. I have already created three class files. What I need to do MVC C# index.chtml file display all data result report. Below my these 3 tables classes only display Region Name but not display deliveryDay.DeliveryDay. It should be display Monday, Friday any day. Can anyone please tell me how do I display day?
public class DeliveryTime
{
[Key]
[DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
public int DeliveryAuto { get; set; }
[Required]
public int DeliveryTimeId { get; set; }
[Required]
public int DeliveryPeriodID { get; set; }
[Required]
[Display(Name = "Delivery Day:")]
public string DeliveryDay { get; set; }
}
public class SubRegion
{
[DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
[Key]
public int SubregionID { get; set; }
[Required]
[Display(Name = "Sub Region Name:")]
public string SubregionName { get; set; }
// [Display(Name = "Region Name:")]
public int RegionID { get; set; }
[Display(Name = "Region Name:")]
public virtual Region ReName { get; set; }
[Required]
public int DeliveryTimeId { get; set; }
[Display(Name = "Delivery Day(s):")]
public virtual DeliveryTime deliveryDay { get; set; }
public virtual IEnumerable<DeliveryTime> deliveryTime { get; set; }
public virtual IEnumerable<Region> region { get; set; }
}
public class Region
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int RegionID { get; set; }
[Required]
[Display(Name = "Region Name:")]
public string ReName { get; set; }
public virtual IEnumerable<SubRegion> subRegion { get; set; }
}
This is my Controller
public ActionResult Index(int? page)
{
var tLCSubRegion = db.TLCSubRegion.Include(s => s.ReName).ToList();
if (Request.HttpMethod != "GET")
{
page = 1;
}
int pageSize = 20;
int pageNumber = (page ?? 1);
return View(tLCSubRegion.ToPagedList(pageNumber, pageSize));
}
This is my Index.chtml page
@model PagedList.IPagedList<WebVer5.Models.SubRegion>
@foreach (var item in Model)
{
@Html.DisplayFor(modelItem => item.ReName.ReName)
@Html.DisplayFor(modelItem => item.deliveryDay.DeliveryDay)
}