public class ResultViewModel { public IEnumerable<Users> users { get; set; } } public class Users { public int UserID { get; set; } public string UserName { get; set; } public string Email { get; set; } public DateTime Date { get; set; } public int DeptID { get; set; } }
[HttpPost] public ActionResult ServiceOrderManager(SOMViewModel model) { DateTime date = Convert.ToDateTime(model.Date); List<int> items = new List<int>(); foreach (var objItem in model.Departments) { if (objItem.IsSelected) { //you can get the selected item id here items.Add(objItem.DeptID); } } List<Users> us = new List<Users>(); foreach (var item in items) { var list = from u in db.tbl_User join ul in db.tbl_User_Login on u.UserID equals ul.User_ID join d in db.tbl_Departments on ul.User_ID equals d.User_id join r in db.tbl_Roles on u.Role_ID equals r.Role_ID join p in db.tbl_PreCodes on u.Pre_Code_ID equals p.Pre_Code_ID join w in db.tbl_WMPages on u.WM_Page_ID equals w.WM_Page_ID where u.CreatedDate == date || d.Department_ID == item select new { u.UserID, u.Name, u.EmailID, u.CreatedDate, d.Department_ID }; var lst = list.ToList(); if (lst.Count > 0) { foreach (var i in lst) { Users user = new Users { UserID = Convert.ToInt32(lst.ElementAt(0).UserID), UserName = lst.ElementAt(0).Name, Email = lst.ElementAt(0).EmailID, Date = Convert.ToDateTime(lst.ElementAt(0).CreatedDate), DeptID = Convert.ToInt32(lst.ElementAt(0).Department_ID) }; us.Add(user); } } } var resultmodel = new ResultViewModel { users = us.ToList() }; return RedirectToAction("ServiceOrderManagerResult", "Login",resultmodel); } public virtual ActionResult ServiceOrderManagerResult(ResultViewModel model) { List<ResultViewModel> lst = new List<ResultViewModel>(); lst.Add(model); return View(lst); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)