public Parameters() { dateFrom = DateTime.Now; dateTo = DateTime.Now; dateFormatPublish = new List <string> { "DAY", "MONTH", "YEAR" }; //{ "d.m.y", "dd.mm.yy", "dd/mm/yy", "M-yy" }; entityPublish = new List <string> { "ACQ", "MT", "ECOMM" }; PropertyRepo.propertyInitilize(typeof(FD_ACQ_D)); entitySelected = typeof(FD_ACQ_D).ToString(); ParametersPublish = (from s in PropertyRepo.properyList select s.propertyName).ToList(); //new List<string> { "MERCHANT", "PAY_SYS", "TYPE_TRANSACTION", "DT_REG", "ALL", "none" }; listCount = QueriesToDbSet.GetList(); selectedDateFormat = from s in dateFormatPublish select new SelectListItem { Text = s.ToString() }; selectedParameters = from s in ParametersPublish select new SelectListItem { Text = s.ToString() }; selectedEntity = from s in entityPublish select new SelectListItem { Text = s.ToString() }; }
//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); }