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"));
}
}
