public ActionResult HomePage(string search) { //if(Session["User_id"] != null && Session["User_name"] != null) //{ // Session["User_id"].ToString(); // Session["User_name"].ToString(); //} //if (Session["Rest_id"] != null) //{ // Session["Rest_id"].ToString(); //} //if (Session["scode"] != null) //{ // Session["scode"].ToString(); //} var rate = db.Rating_tbl.ToList(); var platter = db.tbl_platter.OrderByDescending(r => r.rating).ToList(); var rest = db.tbl_restaurent.ToList(); JoinClass item = new JoinClass(); item.platterdetails = platter; item.restaurentdetails = rest; item.ratingdetails = rate; return(PartialView(item)); }
public IActionResult PostList(ClientSearchModel model) { ViewData.Add("GenderItems", EnumHelper.SelectListFor <GenderEnum>()); ViewData.Add("TypePersonItems", EnumHelper.SelectListFor <TypePersonEnum>()); JoinClass jointest = new JoinClass(); jointest.ClientSearchModel = model; IQueryable <ClientWeb> clients = _context.ClientWeb; if (ModelState.IsValid) { if (model.SearchCodClient != null) { clients = clients.Where(c => c.CodClient.Contains(model.SearchCodClient)); } if (model.SearchEmail != null) { clients = clients.Where(c => c.Email.Contains(model.SearchCodClient)); } if (model.SearchSfirstName != null) { clients = clients.Where(c => c.SfirstName.Contains(model.SearchSfirstName)); } if (model.SearchSlastName != null) { clients.Where(c => c.SlastName.Equals(model.SearchSlastName)); } clients.Where(c => c.Gender.Equals(model.SearchGender)); jointest.Clients = clients.ToList(); return(View("list", jointest)); } else { jointest.Clients = clients.Take(50).ToList(); } return(View("list", jointest)); }
public IActionResult List() { ClientSearchModel client = new ClientSearchModel(); ViewData.Add("GenderItems", EnumHelper.SelectListFor <GenderEnum>()); ViewData.Add("TypePersonItems", EnumHelper.SelectListFor <TypePersonEnum>()); ViewData["messageAction"] = HttpContext.Session.GetString("messageAction"); List <ClientWeb> clients = _context.ClientWeb.Take(50).ToList(); JoinClass jointest = new JoinClass { Clients = clients, ClientSearchModel = client }; return(View(jointest)); }
static void Main(string[] args) { FromClass fromClass = new FromClass(); fromClass.exam(); SimpleLinq simpleLinq = new SimpleLinq(); simpleLinq.exam(); FromFrom fromFrom = new FromFrom(); fromFrom.exam(); GroupByClass groupByClass = new GroupByClass(); groupByClass.exam(); JoinClass joinClass = new JoinClass(); joinClass.exam(); }
private static void Main(string[] args) { JoinClass joinClass = new JoinClass(); joinClass.JoinDemo(); }