public static int ImportRegionStats(this IKpiImportController controller, HttpPostedFileBase httpPostedFileBase, string[] sheetNames, IRegionRepository regionRepository, ITopCellRepository<CdmaRegionStat> cdmaStatRepository) { List<CdmaRegionStat> statList = httpPostedFileBase.ImportInfo( x => { List<CdmaRegionStat> stats = new List<CdmaRegionStat>(); using (ExcelImporter excelImporter = new ExcelImporter(x, sheetNames)) { foreach (string sheetName in sheetNames) { using (DataTable statTable = excelImporter[sheetName]) { ImportExcelListService<CdmaRegionStat> service = new ImportExcelListService<CdmaRegionStat>(stats, statTable); service.Import(); } } } return stats; }, "佛山"); if (statList.Count > 0) { OptimizeRegion firstOrDefault = regionRepository.GetAllList().FirstOrDefault( x => x.Region == statList[0].Region); if (firstOrDefault != null) { controller.SaveTimeKpiStatsService.CurrentCity = firstOrDefault.City; controller.Save3GStatsService.CurrentCity = firstOrDefault.City; } } return cdmaStatRepository.SaveStats(statList); }
public static KpiImportResult Import(this IKpiImportController controller, HttpPostedFileBase httpPostedFileBase, string[] sheetNames, IRegionRepository regionRepository, ITopCellRepository <CdmaRegionStat> cdmaStatRepository) { List <CdmaRegionStat> statList = httpPostedFileBase.ImportInfo( x => { List <CdmaRegionStat> stats = new List <CdmaRegionStat>(); using (ExcelImporter excelImporter = new ExcelImporter(x, sheetNames)) { foreach (string sheetName in sheetNames) { using (DataTable statTable = excelImporter[sheetName]) { ImportExcelListService <CdmaRegionStat> service = new ImportExcelListService <CdmaRegionStat>(stats, statTable); service.Import(); } } } return(stats); }, "佛山"); if (statList.Count > 0) { OptimizeRegion firstOrDefault = regionRepository.GetAllList().FirstOrDefault( x => x.Region == statList[0].Region); if (firstOrDefault != null) { controller.SaveTimeKpiStatsService.CurrentCity = firstOrDefault.City; controller.Save3GStatsService.CurrentCity = firstOrDefault.City; } } int regionStatsSaved = cdmaStatRepository.SaveStats(statList); ExcelStatsImportRepository <TopDrop2GCellExcel> drop2GExcelRepository = httpPostedFileBase.ImportInfo( x => new ExcelStatsImportRepository <TopDrop2GCellExcel>(x, "掉话TOP30小区"), "佛山"); int topDrop2GSaved = controller.SaveTimeKpiStatsService.Save(drop2GExcelRepository.StatList); ExcelStatsImportRepository <TopConnection3GCellExcel> connection3GExcelRepository = httpPostedFileBase.ImportInfo( x => new ExcelStatsImportRepository <TopConnection3GCellExcel>(x, "连接TOP30小区"), "佛山"); int topConnection3GSaved = controller.Save3GStatsService.Save(connection3GExcelRepository.StatList); return(new KpiImportResult { RegionStatsSaved = regionStatsSaved, TopDrop2GSaved = topDrop2GSaved, TopConnection3GSaved = topConnection3GSaved }); }
public static KpiImportResult Import(this IKpiImportController controller, HttpPostedFileBase httpPostedFileBase, string[] sheetNames, IRegionRepository regionRepository, ITopCellRepository<CdmaRegionStat> cdmaStatRepository) { List<CdmaRegionStat> statList = httpPostedFileBase.ImportInfo( x => { List<CdmaRegionStat> stats = new List<CdmaRegionStat>(); using (ExcelImporter excelImporter = new ExcelImporter(x, sheetNames)) { foreach (string sheetName in sheetNames) { using (DataTable statTable = excelImporter[sheetName]) { ImportExcelListService<CdmaRegionStat> service = new ImportExcelListService<CdmaRegionStat>(stats, statTable); service.Import(); } } } return stats; }, "佛山"); if (statList.Count > 0) { OptimizeRegion firstOrDefault = regionRepository.GetAllList().FirstOrDefault( x => x.Region == statList[0].Region); if (firstOrDefault != null) { controller.SaveTimeKpiStatsService.CurrentCity = firstOrDefault.City; controller.Save3GStatsService.CurrentCity = firstOrDefault.City; } } int regionStatsSaved = cdmaStatRepository.SaveStats(statList); ExcelStatsImportRepository<TopDrop2GCellExcel> drop2GExcelRepository = httpPostedFileBase.ImportInfo( x => new ExcelStatsImportRepository<TopDrop2GCellExcel>(x, "掉话TOP30小区"), "佛山"); int topDrop2GSaved = controller.SaveTimeKpiStatsService.Save(drop2GExcelRepository.StatList); ExcelStatsImportRepository<TopConnection3GCellExcel> connection3GExcelRepository = httpPostedFileBase.ImportInfo( x => new ExcelStatsImportRepository<TopConnection3GCellExcel>(x, "连接TOP30小区"), "佛山"); int topConnection3GSaved = controller.Save3GStatsService.Save(connection3GExcelRepository.StatList); return new KpiImportResult { RegionStatsSaved = regionStatsSaved, TopDrop2GSaved = topDrop2GSaved, TopConnection3GSaved = topConnection3GSaved }; }
public ActionResult Index(KpiListViewModel postedModel) { IEnumerable <CdmaRegionStat> stats = cdmaStatRepository.Stats.ToList().GetLastDateStats( regionRepository.GetAllList(), postedModel.StatDate); DateTime endDate = (stats.Any()) ? stats.First().StatDate : DateTime.Today.AddDays(-1); KpiListViewModel viewModel = new KpiListViewModel { CdmaStats = stats, EndDate = endDate, StatDate = endDate, StartDate = endDate.AddDays(-7), Cities = regionNamesService.Query().ToList() }; return(View(viewModel)); }
public IEnumerable <string> GetRegions(string city) { return(_regionRepository.GetAllList().Where(x => x.City == city) .Select(x => x.Region).Distinct().OrderBy(x => x)); }