public ActionResult Query(Models.UtilityModels.AnaliticModel model) { try { model.Exp = model.Exp.Substring(0, model.Exp.Length - 1); switch (model.MType) { case "OrderEntry": var predOrderEntry = Repos <Models.EDM.OrderEntry> .CreatePredicate(model.Exp); ExportToExcel("OrderEntry", dataManager.cont.OrderEntrySet.AsExpandable().Where(predOrderEntry), this); break; case "Order": var predOrder = Repos <Models.EDM.Order> .CreatePredicate(model.Exp); ExportToExcel("Order", dataManager.cont.OrderSet.AsExpandable().Where(predOrder), this); break; case "Customer": var predCustomer = Repos <Models.EDM.Customer> .CreatePredicate(model.Exp); ExportToExcel("Customer", dataManager.cont.CustomerSet.AsExpandable().Where(predCustomer), this); break; case "Address": var predAddress = Repos <Models.EDM.Address> .CreatePredicate(model.Exp); ExportToExcel("Address", dataManager.cont.AddressSet.AsExpandable().Where(predAddress), this); break; case "House": var predHouse = Repos <Models.EDM.House> .CreatePredicate(model.Exp); ExportToExcel("House", dataManager.cont.HouseSet.AsExpandable().Where(predHouse), this); break; case "Street": var predStreet = Repos <Models.EDM.Street> .CreatePredicate(model.Exp); ExportToExcel("Street", dataManager.cont.StreetSet.AsExpandable().Where(predStreet), this); break; case "City": var predCity = Repos <Models.EDM.City> .CreatePredicate(model.Exp); ExportToExcel("City", dataManager.cont.CitySet.AsExpandable().Where(predCity), this); break; case "User": var predUser = Repos <Models.EDM.User> .CreatePredicate(model.Exp); ExportToExcel("User", dataManager.cont.UserSet.AsExpandable().Where(predUser), this); break; case "Meter": var predMeter = Repos <Models.EDM.Meter> .CreatePredicate(model.Exp); ExportToExcel("Meter", dataManager.cont.MeterSet.AsExpandable().Where(predMeter), this); break; case "MeterType": var predMeterType = Repos <Models.EDM.MeterType> .CreatePredicate(model.Exp); ExportToExcel("MeterType", dataManager.cont.MeterTypeSet.AsExpandable().Where(predMeterType), this); break; case "Status": var predStatus = Repos <Models.EDM.Status> .CreatePredicate(model.Exp); ExportToExcel("Status", dataManager.cont.StatusSet.AsExpandable().Where(predStatus), this); break; } }catch (Exception e) { Debug.WriteLine(e.Message); } return(View()); }