public ActionResult Index() { try { int Branvch_ID = Convert.ToInt32(Session["Branvch_ID"]); var Demoe = db.Demoes.Where(i => i.Branch_ID == Branvch_ID).OrderByDescending(i => i.ID).ToList(); List <DemoPlaneModel> DemoPlaneModelList = new List <DemoPlaneModel>(); foreach (var d in Demoe) { DemoPlaneModel DemoPlaneModel = new DemoPlaneModel(); PlaneModel planeModel = new PlaneModel(); DemoModel demoModel = new DemoModel(); demoModel.Branch_ID = d.Branch_ID; demoModel.Date = d.Date; demoModel.Email_ID = d.Email_ID; demoModel.First_Name = d.First_Name; demoModel.GYM_ID = d.GYM_ID; demoModel.ID = d.ID; demoModel.Interested_Plane_ID = d.Interested_Plane_ID; demoModel.Last_Name = d.Last_Name; demoModel.Mobile = d.Mobile; demoModel.Start_Date = d.Start_Date; var Name = db.Planes.Where(i => i.ID == d.Interested_Plane_ID).FirstOrDefault(); if (Name != null) { planeModel.Name = Name.Name; } DemoPlaneModel.PlaneModel = planeModel; DemoPlaneModel.DemoModel = demoModel; DemoPlaneModelList.Add(DemoPlaneModel); } return(View(DemoPlaneModelList)); } catch (Exception ex) { return(RedirectToAction("Contact", "Home")); } }
public ActionResult Today_Visit(Int64 ID) { try { var Demoe = db.Demoes.Where(i => i.GYM_ID == ID && DbFunctions.TruncateTime(i.Date) == DbFunctions.TruncateTime(DateTime.Now)).OrderByDescending(i => i.ID).ToList(); List <DemoPlaneModel> DemoPlaneModelList = new List <DemoPlaneModel>(); foreach (var d in Demoe) { DemoPlaneModel DemoPlaneModel = new DemoPlaneModel(); PlaneModel planeModel = new PlaneModel(); DemoModel demoModel = new DemoModel(); demoModel.Branch_ID = d.Branch_ID; demoModel.Date = d.Date; demoModel.Email_ID = d.Email_ID; demoModel.First_Name = d.First_Name; demoModel.GYM_ID = d.GYM_ID; demoModel.ID = d.ID; demoModel.Interested_Plane_ID = d.Interested_Plane_ID; demoModel.Last_Name = d.Last_Name; demoModel.Mobile = d.Mobile; demoModel.Start_Date = d.Start_Date; var Name = db.Planes.Where(i => i.ID == d.Interested_Plane_ID).FirstOrDefault(); if (Name != null) { planeModel.Name = Name.Name; } DemoPlaneModel.PlaneModel = planeModel; DemoPlaneModel.DemoModel = demoModel; DemoPlaneModelList.Add(DemoPlaneModel); } return(View(DemoPlaneModelList)); } catch (Exception ex) { return(RedirectToAction("Contact", "Home")); } }