//Quering agains DB according to user input //>>??? Find GP realization of different queries in model according to user select in view private IQueryable <IDates> ConditionalQuering(DWH_REPLICAEntities db, Parameters pm) { IQueryable <IDates> result = null; switch (pm.entitySelected) { case "ACQ": result = QueriesToDbSet.GetByDate(db.FD_ACQ_D, pm.dateFrom, pm.dateTo); break; case "ECOMM": result = QueriesToDbSet.GetByDate(db.FD_ACQ_M, pm.dateFrom, pm.dateTo); break; case "MT": break; } if (pm.listInclude) { result = QueriesToDbSet.GetByMerchants(result); } return(result); }
public void excelExportTest() { DWH_REPLICAEntities db = new DWH_REPLICAEntities(); MainModel model = new MainModel(); Parameters parameters_ = new Parameters(); Execution execution = new Execution(); parameters_.entitySelected = "ACQ"; execution.parameters = parameters_; model.entity = QueriesToDbSet.GetByDate(db.FD_ACQ_D, new DateTime(2016, 09, 01, 00, 00, 00), new DateTime(2016, 09, 03, 00, 00, 00)); string codeBase = System.Reflection.Assembly.GetExecutingAssembly().CodeBase; UriBuilder uri = new UriBuilder(codeBase); string path = Directory.GetParent(Directory.GetParent(uri.Path).ToString()).ToString(); path = path + "\\App_Data\\report.xlsx"; ExcelPackage e = new ExcelPackage(new FileInfo(path)); execution.ExcelExport(path, model); }