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