public ActionResult Report(poco poo)
{
if (Request.Form["ddlpr"].ToString() == "Processed")
{
var data3 = from t in db.Applications
join p in db.ProcessedApplications on t.id equals p.application_id
where p.comments == "Processed"
orderby t.id ascending
select t;
List <poco> lst = new List <poco>();
foreach (var j in data3)
{
poco pm = new poco();
pm.id = j.id;
pm.name = j.name;
pm.age = j.age;
pm.dob = j.dob;
pm.address = j.address;
pm.branch_Id = j.branch_Id;
pm.class_Id = j.class_Id;
lst.Add(pm);
}
// Session["datta"] = lst;
return(View(lst));
}
else
{
var data1 = (from t in db.Applications
join p in db.ProcessedApplications on t.id equals p.application_id
where p.comments != "Processed"
select t).ToList();
Session["datta1"] = data1;
List <poco> lst = new List <poco>();
foreach (var j in data1)
{
poco pm = new poco();
pm.id = j.id;
pm.name = j.name;
pm.age = j.age;
pm.dob = j.dob;
pm.address = j.address;
pm.branch_Id = j.branch_Id;
pm.class_Id = j.class_Id;
lst.Add(pm);
}
// Session["datta"] = lst;
return(View(lst));
}
//var data = from t in db.Applications
// join p in db.ProcessedApplications on t.id equals p.application_id
// where p.comments == "Processed"
// orderby t.id ascending
// select t;
// return View();
}
public ActionResult Report()
{
var data = from t in db.Applications
orderby t.id ascending
select t;
List <poco> lst = new List <poco>();
foreach (var j in data)
{
poco pm = new poco();
pm.id = j.id;
pm.name = j.name;
pm.age = j.age;
pm.dob = j.dob;
pm.address = j.address;
pm.branch_Id = j.branch_Id;
pm.class_Id = j.class_Id;
lst.Add(pm);
}
int data7 = db.Applications.Count();
Session["totalcount"] = data7;
int res = db.ProcessedApplications.Count(x => x.comments == "Processed");
Session["processedcount"] = res;
return(View(lst));
}
