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