public ActionResult GetMembershipDue(Guid contactId, Guid membershipId) { DailyViewModel viewModel = new DailyViewModel(); Membership membership = _dbContext.Memberships.Find(membershipId); if (membershipId != null) { // decimal totalCustomerFees = 0; var dailyMemberShipFeeOfContact = _dbContext.Daily.Where(d => d.ContactId == contactId && d.MembershipId == membershipId).ToList(); if (dailyMemberShipFeeOfContact.Count == 0) { viewModel.Total = membership.Fees; } if (dailyMemberShipFeeOfContact.Count != 0) { var dailyLastDue = dailyMemberShipFeeOfContact.LastOrDefault(); viewModel.Total = dailyLastDue.Due; } } if (membership == null) { return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); } else { viewModel.Due = membership.Fees; } return(Json(new { success = true, Total = viewModel.Total }, JsonRequestBehavior.AllowGet)); }
public IActionResult Index() { DateTime data = DateTime.Now; ViewBag.start = data.ToString("yyyy-MM-dd"); DailyViewModel dvm = new DailyViewModel { ListaConsumPerZi = _context.Indexes.Where(elem => elem.DataOra.Year == data.Year && elem.DataOra.Month == data.Month && elem.DataOra.Day == data.Day).ToList(), ListaPrognozaPerZi = _context.PrognozaEnergieModels.Where(elem => elem.DataOra.Year == data.Year && elem.DataOra.Month == data.Month && elem.DataOra.Day == data.Day).ToList() }; List <AxisLabelData> chartData = new List <AxisLabelData>(); for (int i = 0; i < dvm.ListaPrognozaPerZi.Count; i++) { chartData.Add(new AxisLabelData { x = dvm.ListaPrognozaPerZi[i].Ora, y = dvm.ListaPrognozaPerZi[i].Valoare, y1 = dvm.ListaConsumPerZi.Count > 1 ? Math.Round(dvm.ListaConsumPerZi[i].ValueEnergyPlusA / 1000, 1): 0 }); } dvm.ChartData = chartData; ViewBag.dataSource = chartData; return(View(dvm)); }
/// <summary> /// Initializes a new instance of the <see cref="MainViewModel"/> class. /// </summary> /// <param name="downloadReportCommand"> /// The download report command. /// </param> /// <param name="ignoreCommand"> /// The ignore command. /// </param> /// <param name="openUriCommand"> /// The open uri command. /// </param> /// <param name="clipboardCommand"> /// The clipboard command. /// </param> /// <param name="daily"> /// The daily. /// </param> /// <param name="monthly"> /// The monthly. /// </param> /// <param name="settingsViewModel">Settings viewmodel.</param> public MainViewModel( IDownloadReportCommand downloadReportCommand, IBaseCommand ignoreCommand, OpenUriCommand openUriCommand, IBaseCommand clipboardCommand, DailyViewModel daily, MonthlyViewModel monthly, SettingsViewModel settingsViewModel) { downloadReportCommand.ReportDownloaded += this.ReportDownloaded; downloadReportCommand.Executing += (sender, args) => { this.IsBusy = true; }; this.DownloadReportCommand = downloadReportCommand; ignoreCommand.Executed += (sender, args) => { this.Error = null; }; this.IgnoreCommand = ignoreCommand; this.OpenUriCommand = openUriCommand; this.ClipboardCommand = clipboardCommand; this.daily = daily; this.monthly = monthly; this.settings = settingsViewModel; }
public void Then_filters_should_not_be_empty() { var fakeDownloadReportCommand = A.Fake <IDownloadReportCommand>(); var vm = new DailyViewModel(fakeDownloadReportCommand); fakeDownloadReportCommand.ReportDownloaded += Raise.With(CreateEventArgs()).Now; Assert.AreNotEqual(0, vm.Filters.Count); }
public ActionResult Create() { DailyViewModel viewModel = new DailyViewModel(); ViewBag.BatchId = new SelectList(_dbContext.Batch, "Id", "Name"); viewModel.GetHeadList = viewModel.getList(); ViewBag.Memberships = new SelectList(_dbContext.Memberships, "Id", "MembershipName"); return(View(viewModel)); }
public void Then_FilterStart_should_be_the_first_value() { var fakeDownloadReportCommand = A.Fake<IDownloadReportCommand>(); var vm = new DailyViewModel(fakeDownloadReportCommand); fakeDownloadReportCommand.ReportDownloaded += Raise.With(CreateEventArgs()).Now; var expected = new DateTime(2011, 1, 1); Assert.AreEqual(expected, vm.FilterStart.Date); }
public ActionResult Index() { ViewBag.Particular = new SelectList(_dbContext.Particular, "Id", "Name"); //ViewBag.Products = new SelectList(_dbContext.Products, "Id", "Name"); //ViewBag.Contacts = new SelectList(_dbContext.Contacts.OrderBy(c => c.FirstName), "Id", "FullName"); DailyViewModel viewModelforHeadList = new DailyViewModel(); ViewBag.HeadList = viewModelforHeadList.getList(); return(View()); }
public void And_FilterStart_has_been_set_filtering_should_be_done() { var fakeDownloadReportCommand = A.Fake<IDownloadReportCommand>(); var vm = new DailyViewModel(fakeDownloadReportCommand); vm.FilterStart = new DailyFilter(new DateTime(2011, 2, 1)); fakeDownloadReportCommand.ReportDownloaded += Raise.With(CreateEventArgs()).Now; Assert.AreEqual(4, vm.FilteredValues.Count); }
public void Then_FilterEnd_should_be_the_last_value() { var fakeDownloadReportCommand = A.Fake <IDownloadReportCommand>(); var vm = new DailyViewModel(fakeDownloadReportCommand); fakeDownloadReportCommand.ReportDownloaded += Raise.With(CreateEventArgs()).Now; var expected = new DateTime(2011, 5, 1); Assert.AreEqual(expected, vm.FilterEnd.Date); }
public void And_FilterStart_has_been_set_filtering_should_be_done() { var fakeDownloadReportCommand = A.Fake <IDownloadReportCommand>(); var vm = new DailyViewModel(fakeDownloadReportCommand); vm.FilterStart = new DailyFilter(new DateTime(2011, 2, 1)); fakeDownloadReportCommand.ReportDownloaded += Raise.With(CreateEventArgs()).Now; Assert.AreEqual(4, vm.FilteredValues.Count); }
public async Task <DailyViewModel> GetPagedList(DateTime start, DateTime end, int pageIndex, int pageSize) { var pagedList = await _dailyService.GetDailys(start, end, pageIndex, pageSize); var result = new DailyViewModel(pagedList.PageIndex, pagedList.PageSize, pagedList.Count, pagedList.Items) { Start = start, End = end }; return(result); }
public ActionResult Daily() { var model = new DailyViewModel() { DailyReadingsHtml = DailyReadingsScraper.GetReadings(), EditPostViewModel = EditViewModelFactory.GetNewEditPostViewModel(), //todo:getflashcards }; return View(model); }
public ActionResult GetContactDueHistory(Guid contactId) { ContactPaymentHistory contactPaymentHistory = new ContactPaymentHistory(); decimal?total = 0; decimal?totalAmtTaken = 0; decimal?outStanding = 0; var contactDues = _dbContext.Daily. Where(d => d.ContactId == contactId).OrderBy(d => d.CreatedDate).ToList(); List <DailyViewModel> customerDueFeesList = new List <DailyViewModel>(); IEnumerable <DailyViewModel> dailyViewModelEnu; decimal?creditTotal = 0; decimal?debitTotal = 0; foreach (var contactPayment in contactDues) { creditTotal += contactPayment.Credit; debitTotal += contactPayment.Debit; DailyViewModel viewModel = new DailyViewModel() { Head = contactPayment.HeadName, Invoice = contactPayment.Invoice, CustomerName = contactPayment.Contact.FullName, Particular = contactPayment.Particular.Name, Date = contactPayment.Date, Total = contactPayment.DailyTotal, Credit = contactPayment.Credit, Debit = contactPayment.Debit, Due = contactPayment.Due, Net = creditTotal - debitTotal }; total = viewModel.Total + total; totalAmtTaken = viewModel.Credit + totalAmtTaken; customerDueFeesList.Add(viewModel); } contactPaymentHistory.Total = total; contactPaymentHistory.TotalAmountTaken = totalAmtTaken; outStanding = total - totalAmtTaken; contactPaymentHistory.OutStanding = outStanding; dailyViewModelEnu = customerDueFeesList; contactPaymentHistory.DailyItemViewModel = dailyViewModelEnu; string modelString = RenderRazorViewToString("_GetContactDueHistory", contactPaymentHistory); return(Json(new { ModelString = modelString }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetDailyForDatatable() { using (var context = new ApplicationDbContext()) { var dailyies = context.Daily.OrderByDescending(d => d.Date).ToList(); List <DailyViewModel> dailyViewModelList = new List <DailyViewModel>(); IEnumerable <DailyViewModel> dailyViewModelEnu; foreach (var daily in dailyies) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; List <DailyItemViewModel> dailyItemViewModelList = new List <DailyItemViewModel>(); foreach (var item in daily.DailyItems) { DailyItemViewModel dailyItemViewModel = new DailyItemViewModel(); dailyItemViewModel.Id = item.Id; dailyItemViewModel.Name = item.StoreProduct.Product.Name; dailyItemViewModel.Quantity = item.Quantity; dailyItemViewModel.MRPPerUnit = item.MRPPerUnit; dailyItemViewModel.ItemAmount = item.ItemAmount; dailyItemViewModelList.Add(dailyItemViewModel); } viewModel.DailyItemViewModels = dailyItemViewModelList; dailyViewModelList.Add(viewModel); } dailyViewModelEnu = dailyViewModelList; var result = new { iTotalRecords = dailyies.Count, iTotalDisplayRecords = dailyies.Count, aaData = dailyViewModelList }; return(Json(result, JsonRequestBehavior.AllowGet)); } }
public void Then_Values_are_updated() { var fakeDownloadReportCommand = A.Fake<IDownloadReportCommand>(); var vm = new DailyViewModel(fakeDownloadReportCommand); // This causes the viewmodel to get the initial values fakeDownloadReportCommand.ReportDownloaded += Raise.With(CreateEventArgs()).Now; Assert.AreEqual(5, vm.FilteredValues.Count, "Before changing filter theres hould be 5 values"); // Change the end filter vm.FilterEnd = new DailyFilter(new DateTime(2011, 1, 1)); Assert.AreEqual(11, vm.FilteredValues[0].Timestamp.Month); Assert.AreEqual(12, vm.FilteredValues[1].Timestamp.Month); Assert.AreEqual(1, vm.FilteredValues[2].Timestamp.Month); }
public IActionResult Index(int index = 1) { // only accept indexes between 1 and 10 if (index < 1 || index > 10) { return(RedirectToAction(nameof(Done))); } var model = new DailyViewModel { Comment = new Comment(), ImageHalf = new ImageGrid() // TODO: Write a service for ImageHalfs and a method to get one of // today's ImageHalfs by a number }; return(View(model)); }
public ActionResult GetInvoice(string headName) { DailyViewModel viewModel = new DailyViewModel(); var dailyInvoice = _dbContext.Daily.Where(d => d.HeadName == headName). OrderBy(d => d.Invoice).ToList().LastOrDefault(); decimal invoice; if (dailyInvoice == null) { invoice = 1; } else { invoice = dailyInvoice.Invoice + 1; } return(Json(new { success = true, invoice = invoice }, JsonRequestBehavior.AllowGet)); }
public void Then_Values_are_updated() { var fakeDownloadReportCommand = A.Fake <IDownloadReportCommand>(); var vm = new DailyViewModel(fakeDownloadReportCommand); // This causes the viewmodel to get the initial values fakeDownloadReportCommand.ReportDownloaded += Raise.With(CreateEventArgs()).Now; Assert.AreEqual(5, vm.FilteredValues.Count, "Before changing filter theres hould be 5 values"); // Change the end filter vm.FilterEnd = new DailyFilter(new DateTime(2011, 1, 1)); Assert.AreEqual(11, vm.FilteredValues[0].Timestamp.Month); Assert.AreEqual(12, vm.FilteredValues[1].Timestamp.Month); Assert.AreEqual(1, vm.FilteredValues[2].Timestamp.Month); }
private void InitializeMainWindow() { var settings = new Settings(); var downlodReportCommand = new DownloadReportCommand(new ReportDownloader(), settings); var daily = new DailyViewModel(downlodReportCommand); var monthly = new MonthlyViewModel(downlodReportCommand); var settingsViewmodel = new SettingsViewModel(settings); var ignoreCommand = new Command(); var openUriCommand = new OpenUriCommand(); var clipboardCommand = new CopyErrorReportToClipboardCommand(new SystemClipboard()); this.MainWindow = new MainWindow(); this.MainWindow.DataContext = new MainViewModel(downlodReportCommand, ignoreCommand, openUriCommand, clipboardCommand, daily, monthly, settingsViewmodel); }
public void Then_values_are_updated() { var fakeDownloadReportCommand = A.Fake<IDownloadReportCommand>(); var vm = new DailyViewModel(fakeDownloadReportCommand); vm.TransferUnit = TransferUnit.Kilobytes; // This causes the viewmodel to get the initial values fakeDownloadReportCommand.ReportDownloaded += Raise.With(CreateEventArgs()).Now; // Verify that initial values are using kilobytes Assert.AreEqual(vm.FilteredValues[0].Download, 1048576); Assert.AreEqual(vm.FilteredValues[0].Upload, 1048576); // Change the transfer unit to gigabytes vm.TransferUnit = TransferUnit.Gigabytes; Assert.AreEqual(vm.FilteredValues[0].Download, 1); Assert.AreEqual(vm.FilteredValues[0].Upload, 1); }
public void Then_values_are_updated() { var fakeDownloadReportCommand = A.Fake <IDownloadReportCommand>(); var vm = new DailyViewModel(fakeDownloadReportCommand); vm.TransferUnit = TransferUnit.Kilobytes; // This causes the viewmodel to get the initial values fakeDownloadReportCommand.ReportDownloaded += Raise.With(CreateEventArgs()).Now; // Verify that initial values are using kilobytes Assert.AreEqual(vm.FilteredValues[0].Download, 1048576); Assert.AreEqual(vm.FilteredValues[0].Upload, 1048576); // Change the transfer unit to gigabytes vm.TransferUnit = TransferUnit.Gigabytes; Assert.AreEqual(vm.FilteredValues[0].Download, 1); Assert.AreEqual(vm.FilteredValues[0].Upload, 1); }
public async Task <IActionResult> Index(DailyViewModel model) { if (ModelState.IsValid) { // get the currently logged in user (or null if there isn't one) var user = await _userManager.GetUserAsync(HttpContext.User); model.Comment.UserId = user?.Id; // TODO: Check for the ImageHalf in the db by its id before doing this? // to prevent this comment from being tied to a different or nonexistant image model.Comment.ImageGrid = model.ImageHalf; // attempt to add the comment to the database bool commentAdded = await _commentService.AddCommentAsync(model.Comment); } else { ModelState.AddModelError("", "Invalid input"); } return(View(model)); }
// Save to Excel File Daily Forecast public FileInfo SaveExcelFileToDisk(DailyViewModel dvm, IWebHostEnvironment environment, DateTime data) { using (var pck = new ExcelPackage()) { ExcelWorksheet ws = pck.Workbook.Worksheets.Add(data.ToString("dd.MM.yyyy")); ws.Cells["B5:Z5"].Style.Font.Bold = true; // Set Values from report in excel file // Rand 1 ws.Cells["B5"].Style.Font.Bold = true; ws.Cells["B5"].Value = "Ora"; for (int i = 0; i < 24; i++) { ws.Cells[$"{GetCharStringsFromNumber(67 + i)}5"].Value = i + 1; } // Rand 2 ws.Cells["B6"].Style.Font.Bold = true; ws.Cells["B6"].Value = "Prognoza energie [MWh]"; for (int i = 0; i < dvm.ListaPrognozaPerZi.Count; i++) { ws.Cells[$"{GetCharStringsFromNumber(67 + i)}6"].Value = dvm.ListaPrognozaPerZi[i].Valoare; } // Rand 3 ws.Cells["B7"].Style.Font.Bold = true; ws.Cells["B7"].Value = "Consum realizat [MWh]"; for (int i = 0; i < dvm.ListaConsumPerZi.Count; i++) { ws.Cells[$"{GetCharStringsFromNumber(67 + i)}7"].Value = dvm.ListaConsumPerZi[i].ValueEnergyPlusA / 1000; } ws.Cells["A:AZ"].AutoFitColumns(); // Add chart ExcelLineChart lineChart = ws.Drawings.AddChart("lineChart", eChartType.Line) as ExcelLineChart; // Set Chart Title lineChart.Title.Text = "Prognoza energie"; // Create Ranges for Chart var rangeLabel = ws.Cells["C5:Z5"]; var range1 = ws.Cells["C6:Z6"]; var range2 = ws.Cells["C7:Z7"]; // Add ranges to the chart lineChart.Series.Add(range1, rangeLabel); lineChart.Series.Add(range2, rangeLabel); // Set names of the legend lineChart.Series[0].Header = ws.Cells["B6"].Value.ToString(); lineChart.Series[1].Header = ws.Cells["B7"].Value.ToString(); // Position of the legend lineChart.Legend.Position = eLegendPosition.Right; // Size of the chart lineChart.SetSize(1200, 400); // Add the chart at cell .. lineChart.SetPosition(10, 0, 1, 0); // Write File to Disk string excelFileName = $"Prognoza energie zilnic.xlsx"; string wwwPath = environment.WebRootPath; string filePath = Path.Combine(wwwPath, "Fisiere"); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } filePath = Path.Combine(filePath, excelFileName); FileInfo fileInfo = new FileInfo(filePath); pck.SaveAs(fileInfo); return(fileInfo); } }
public void Then_values_should_not_be_empty() { var fakeDownloadReportCommand = A.Fake<IDownloadReportCommand>(); var vm = new DailyViewModel(fakeDownloadReportCommand); fakeDownloadReportCommand.ReportDownloaded += Raise.With(CreateEventArgs()).Now; Assert.AreNotEqual(0, vm.FilteredValues.Count); }
public DailyPage() { this.InitializeComponent(); this.videoMediaPlayer.AutoPlay = SettingsStore.GetValueOrDefault <bool>(AppCommonConst.IS_AUTOPLAY_TOGGLLESWITCH_ON, true); if (dailyViewModel == null) { if (!SimpleIoc.Default.IsRegistered <DailyViewModel>()) { SimpleIoc.Default.Register <DailyViewModel>(); } dailyViewModel = SimpleIoc.Default.GetInstance <DailyViewModel>(); } this.DataContext = dailyViewModel; this.navigationHelper = new NavigationHelper(this); this.videoMediaPlayer.ControlPanelTemplate = AppEnvironment.IsPhone ? Application.Current.Resources["ControlPanelControlTemplatePhone"] as ControlTemplate : Application.Current.Resources["ControlPanelControlTemplatePC"] as ControlTemplate; this.Loaded += (ss, ee) => { if (AppEnvironment.IsPhone) { szPhone.IsZoomedInViewActive = true; videoMediaPlayer.IsFullScreenVisible = false; this.videoMediaPlayer.DoubleTapped += videoMediaPlayer_DoubleTapped; szPhone.ViewChangeStarted -= szPhone_ViewChangeStarted; szPhone.ViewChangeCompleted -= szPhone_ViewChangeCompleted; szPhone.ViewChangeStarted += szPhone_ViewChangeStarted; szPhone.ViewChangeCompleted += szPhone_ViewChangeCompleted; TopTapGuestureBox.Instance.ShowTopTapGuestureUIControl(); } else { szPhone.IsZoomedInViewActive = false; videoMediaPlayer.IsFullScreenVisible = true; szPC.ViewChangeStarted -= szPC_ViewChangeStarted; szPC.ViewChangeCompleted -= szPC_ViewChangeCompleted; szPC.ViewChangeStarted += szPC_ViewChangeStarted; szPC.ViewChangeCompleted += szPC_ViewChangeCompleted; this.KeyUp += DailyPage_KeyUp; //szPCDailyFlipView.SelectionChanged += szPCDailyFlipView_SelectionChanged; } if (dailyViewModel != null) { bool hasCollection = true; if (AppEnvironment.IsPhone) { if (dailyViewModel.DailyCollection.Count == 0) { hasCollection = false; } } else { if (dailyViewModel.DailyFlipViewCollection.Count == 0) { hasCollection = false; } } if (!hasCollection) { dailyViewModel.GetDaily(dailyViewModel.DailyCollection, dailyViewModel.DailyFlipViewCollection, ApiDailyRoot.Instance.DailyUrl, AppCacheNewsFileNameConst.CACHE_DAILY_FILENAME, false); } } }; this.Unloaded += (ss, ee) => { //这里是用来即可激发ZoomSemanticButtonMessenger,使zoomSemanticButton马上隐藏 if (!AppEnvironment.IsPhone) { Messenger.Default.Send <bool>(false, AppMessengerTokenConst.IS_ZOOMSEMANTIC_BUTTON_VISIBLE); } if (AppEnvironment.IsPhone) { szPhone.IsZoomedInViewActive = true; videoMediaPlayer.IsFullScreenVisible = false; this.videoMediaPlayer.DoubleTapped -= videoMediaPlayer_DoubleTapped; //TopTapGuestureBox.Instance.HideTopTapGuestureUIControl(); } else { szPC.IsZoomedInViewActive = true; videoMediaPlayer.IsFullScreenVisible = true; this.KeyUp -= DailyPage_KeyUp; //szPCDailyFlipView.SelectionChanged -= szPCDailyFlipView_SelectionChanged; //szPCDailyFlipView.SelectedIndex = -1; } }; }
public ActionResult DisplaySearchResults(string headName, Guid?particulartId, Guid?contactId, Guid?productId, DateTime?todate, DateTime?fromdate) { if (headName != null && headName != "--Select Head--") { var dailyByHeadName = _dbContext.Daily.Where(s => s.HeadName == headName).OrderBy(d => d.CreatedDate).ToList(); List <DailyViewModel> dailyViewModelList = new List <DailyViewModel>(); IEnumerable <DailyViewModel> dailyViewModelEnu; if (particulartId != null) { var dailyByParticular = dailyByHeadName.Where(v => v.ParticularId == particulartId).OrderBy(d => d.CreatedDate).ToList(); if (todate != null && fromdate != null) { var tofromList = dailyByParticular.Where(d1 => d1.CreatedDate >= todate && d1.CreatedDate <= fromdate).OrderBy(d => d.CreatedDate).ToList(); foreach (var daily in tofromList) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; dailyViewModelList.Add(viewModel); } dailyViewModelEnu = dailyViewModelList; // return PartialView("_FilterDaily", dailyViewModelEnu); string modelString = RenderRazorViewToString("_FilterDaily", dailyViewModelEnu); return(Json(new { success = true, modelString }, JsonRequestBehavior.AllowGet)); } else { foreach (var daily in dailyByParticular) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; dailyViewModelList.Add(viewModel); } dailyViewModelEnu = dailyViewModelList; // return PartialView("_FilterDaily", dailyViewModelEnu); string modelString = RenderRazorViewToString("_FilterDaily", dailyViewModelEnu); return(Json(new { success = true, modelString }, JsonRequestBehavior.AllowGet)); } } else { if (todate != null && fromdate != null) { var tofromList = dailyByHeadName.Where(d1 => d1.CreatedDate >= todate && d1.CreatedDate <= fromdate).OrderBy(d => d.CreatedDate).ToList(); foreach (var daily in tofromList) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; dailyViewModelList.Add(viewModel); } dailyViewModelEnu = dailyViewModelList; // return PartialView("_FilterDaily", dailyViewModelEnu); string modelString = RenderRazorViewToString("_FilterDaily", dailyViewModelEnu); return(Json(new { success = true, modelString }, JsonRequestBehavior.AllowGet)); } else { foreach (var daily in dailyByHeadName) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; dailyViewModelList.Add(viewModel); } dailyViewModelEnu = dailyViewModelList; // return PartialView("_FilterDaily", dailyViewModelEnu); string modelString = RenderRazorViewToString("_FilterDaily", dailyViewModelEnu); return(Json(new { success = true, modelString }, JsonRequestBehavior.AllowGet)); } } } else if (particulartId != null) { var dailyByParticular = _dbContext.Daily.Where(s => s.ParticularId == particulartId).OrderBy(d => d.CreatedDate).ToList(); List <DailyViewModel> violationViewModelList = new List <DailyViewModel>(); IEnumerable <DailyViewModel> dailyViewModelEnu; if (todate != null && fromdate != null) { var tofromList = dailyByParticular.Where(d1 => d1.CreatedDate >= todate && d1.CreatedDate <= fromdate).ToList(); foreach (var daily in tofromList) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; violationViewModelList.Add(viewModel); } dailyViewModelEnu = violationViewModelList; // return PartialView("_FilterDaily", violationViewModelEnu); string modelString = RenderRazorViewToString("_FilterDaily", dailyViewModelEnu); return(Json(new { success = true, modelString }, JsonRequestBehavior.AllowGet)); } else { foreach (var daily in dailyByParticular) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; violationViewModelList.Add(viewModel); } dailyViewModelEnu = violationViewModelList; // return PartialView("_FilterDaily", violationViewModelEnu); string modelString = RenderRazorViewToString("_FilterDaily", dailyViewModelEnu); return(Json(new { success = true, modelString }, JsonRequestBehavior.AllowGet)); } } else if (contactId != null) { var dailyByContact = _dbContext.Daily.Where(s => s.ContactId == contactId).OrderBy(d => d.CreatedDate).ToList(); List <DailyViewModel> DailyViewModelList = new List <DailyViewModel>(); IEnumerable <DailyViewModel> dailyViewModelEnu; if (todate != null && fromdate != null) { var tofromList = dailyByContact.Where(d1 => d1.CreatedDate >= todate && d1.CreatedDate <= fromdate).ToList(); foreach (var daily in tofromList) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; DailyViewModelList.Add(viewModel); } dailyViewModelEnu = DailyViewModelList; // return PartialView("_FilterDaily", dailyViewModelEnu); string modelString = RenderRazorViewToString("_FilterDaily", dailyViewModelEnu); return(Json(new { success = true, modelString }, JsonRequestBehavior.AllowGet)); } else { foreach (var daily in dailyByContact) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; DailyViewModelList.Add(viewModel); } dailyViewModelEnu = DailyViewModelList; string modelString = RenderRazorViewToString("_FilterDaily", dailyViewModelEnu); return(Json(new { success = true, modelString }, JsonRequestBehavior.AllowGet)); // return Json(new { ModelString = modelString, JsonRequestBehavior.AllowGet }); // return Json(result, JsonRequestBehavior.AllowGet); // return PartialView("_FilterDaily", dailyViewModelEnu); } } else if (productId != null) { var dailyItems = _dbContext.DailyItem.Where(s => s.StoreProduct.ProductId == productId).OrderBy(d => d.CreatedDate).ToList(); List <DailyViewModel> violationViewModelList = new List <DailyViewModel>(); IEnumerable <DailyViewModel> dailyViewModelEnu; if (todate != null && fromdate != null) { var tofromList = dailyItems.Where(d1 => d1.CreatedDate >= todate && d1.CreatedDate <= fromdate).ToList(); foreach (var daily in tofromList.Select(x => x.Daily)) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; violationViewModelList.Add(viewModel); } dailyViewModelEnu = violationViewModelList; // return PartialView("_FilterDaily", violationViewModelEnu); string modelString = RenderRazorViewToString("_FilterDaily", dailyViewModelEnu); return(Json(new { success = true, modelString }, JsonRequestBehavior.AllowGet)); } else { foreach (var daily in dailyItems.Select(x => x.Daily)) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; violationViewModelList.Add(viewModel); } dailyViewModelEnu = violationViewModelList; // return PartialView("_FilterDaily", violationViewModelEnu); string modelString = RenderRazorViewToString("_FilterDaily", dailyViewModelEnu); return(Json(new { success = true, modelString }, JsonRequestBehavior.AllowGet)); } } else if (todate != null && fromdate != null) { // string toformatted = todate.Value.ToString("yyyy-MM-dd"); // string fromformatted = fromdate.Value.ToString("yyyy-MM-dd"); // DateTime todateFromatted = DateTime.Parse(toformatted); // DateTime fromdateFormatted = DateTime.Parse(fromdate.ToString()); var dailyList = _dbContext.Daily.ToList(); var tofromList = dailyList.Where(d1 => d1.CreatedDate >= todate && d1.CreatedDate <= fromdate).ToList(); List <DailyViewModel> violationViewModelList = new List <DailyViewModel>(); IEnumerable <DailyViewModel> dailyViewModelEnu; foreach (var daily in tofromList) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; violationViewModelList.Add(viewModel); } dailyViewModelEnu = violationViewModelList; // return PartialView("_FilterDaily", violationViewModelEnu); string modelString = RenderRazorViewToString("_FilterDaily", dailyViewModelEnu); return(Json(new { success = true, modelString }, JsonRequestBehavior.AllowGet)); } else { var dailies = _dbContext.Daily.OrderBy(d => d.CreatedDate).ToList(); List <DailyViewModel> dailyViewModelList = new List <DailyViewModel>(); IEnumerable <DailyViewModel> dailyViewModelEnu; foreach (var daily in dailies) { DailyViewModel viewModel = new DailyViewModel() { Id = daily.Id, Invoice = daily.Invoice, Ledger = daily.Contact.FullName, Particular = daily.Particular.Name, Date = daily.Date, Head = daily.HeadName, Credit = daily.Credit, Debit = daily.Debit, Net = daily.Net }; dailyViewModelList.Add(viewModel); } dailyViewModelEnu = dailyViewModelList; // return PartialView("_FilterDaily", dailyViewModelEnu); string modelString = RenderRazorViewToString("_FilterDaily", dailyViewModelEnu); return(Json(new { success = true, modelString }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Daily daily = _dbContext.Daily.Find(id); if (daily == null) { return(HttpNotFound()); } DailyViewModel viewModel = new DailyViewModel() { Head = daily.HeadName, Id = daily.Id, Invoice = daily.Invoice, Date = daily.Date, ContactId = daily.ContactId, CustomerName = daily.Contact.FullName, ParticularId = daily.ParticularId, Particular = daily.Particular.Name, Total = daily.DailyTotal, Due = daily.Due, Note = daily.Note, // Net = daily.Net }; List <DailyItemViewModel> dailyItemViewModelList = new List <DailyItemViewModel>(); foreach (var item in daily.DailyItems) { DailyItemViewModel dailyItemViewModel = new DailyItemViewModel() { Id = item.Id, BatchId = item.StoreProduct.BatchId, BatchName = item.StoreProduct.Batch.Name, AutoGenerateName = item.StoreProduct.Product.AutoGenerateName, StoreProductId = item.StoreProductId, MRPPerUnit = item.MRPPerUnit, Quantity = item.Quantity, ItemAmount = item.ItemAmount }; dailyItemViewModelList.Add(dailyItemViewModel); } viewModel.DailyItemViewModels = dailyItemViewModelList; ViewBag.BatchId = new SelectList(_dbContext.Batch, "Id", "Name"); ViewBag.Memberships = new SelectList(_dbContext.Memberships, "Id", "MembershipName"); viewModel.Head = daily.HeadName; if (viewModel.Head == "Service") { viewModel.X = 1; } else if (viewModel.Head == "Sales") { viewModel.X = 2; } else if (viewModel.Head == "Expense") { viewModel.X = 3; } else { viewModel.X = 4; } viewModel.GetHeadList = viewModel.getList(); return(View(viewModel)); }
public IActionResult Index(DateTime startDate, string submitBtn, double val1, double val2, double val3, double val4, double val5, double val6, double val7, double val8, double val9, double val10, double val11, double val12, double val13, double val14, double val15, double val16, double val17, double val18, double val19, double val20, double val21, double val22, double val23, double val24) { // Show Data For previous Day if (submitBtn == "Previous") { startDate = startDate.AddDays(-1); } else if (submitBtn == "Next") // Show Data For next Day { startDate = startDate.AddDays(1); } ViewBag.start = startDate.ToString("yyyy-MM-dd"); DailyViewModel dvm = new DailyViewModel { ListaConsumPerZi = _context.Indexes.Where(elem => elem.DataOra.Year == startDate.Year && elem.DataOra.Month == startDate.Month && elem.DataOra.Day == startDate.Day).ToList(), ListaPrognozaPerZi = _context.PrognozaEnergieModels.Where(elem => elem.DataOra.Year == startDate.Year && elem.DataOra.Month == startDate.Month && elem.DataOra.Day == startDate.Day).ToList() }; List <AxisLabelData> chartData = new List <AxisLabelData>(); for (int i = 0; i < dvm.ListaPrognozaPerZi.Count; i++) { chartData.Add(new AxisLabelData { x = dvm.ListaPrognozaPerZi[i].Ora, y = dvm.ListaPrognozaPerZi[i].Valoare, y1 = dvm.ListaConsumPerZi.Count > 1 ? Math.Round(dvm.ListaConsumPerZi[i].ValueEnergyPlusA / 1000, 1) : 0 }); // Update Elements in Database if (submitBtn == "Save data") { switch (i) { case 0: dvm.ListaPrognozaPerZi[i].Valoare = val1; break; case 1: dvm.ListaPrognozaPerZi[i].Valoare = val2; break; case 2: dvm.ListaPrognozaPerZi[i].Valoare = val3; break; case 3: dvm.ListaPrognozaPerZi[i].Valoare = val4; break; case 4: dvm.ListaPrognozaPerZi[i].Valoare = val5; break; case 5: dvm.ListaPrognozaPerZi[i].Valoare = val6; break; case 6: dvm.ListaPrognozaPerZi[i].Valoare = val7; break; case 7: dvm.ListaPrognozaPerZi[i].Valoare = val8; break; case 8: dvm.ListaPrognozaPerZi[i].Valoare = val9; break; case 9: dvm.ListaPrognozaPerZi[i].Valoare = val10; break; case 10: dvm.ListaPrognozaPerZi[i].Valoare = val11; break; case 11: dvm.ListaPrognozaPerZi[i].Valoare = val12; break; case 12: dvm.ListaPrognozaPerZi[i].Valoare = val13; break; case 13: dvm.ListaPrognozaPerZi[i].Valoare = val14; break; case 14: dvm.ListaPrognozaPerZi[i].Valoare = val15; break; case 15: dvm.ListaPrognozaPerZi[i].Valoare = val16; break; case 16: dvm.ListaPrognozaPerZi[i].Valoare = val17; break; case 17: dvm.ListaPrognozaPerZi[i].Valoare = val18; break; case 18: dvm.ListaPrognozaPerZi[i].Valoare = val19; break; case 19: dvm.ListaPrognozaPerZi[i].Valoare = val20; break; case 20: dvm.ListaPrognozaPerZi[i].Valoare = val21; break; case 21: dvm.ListaPrognozaPerZi[i].Valoare = val22; break; case 22: dvm.ListaPrognozaPerZi[i].Valoare = val23; break; case 23: dvm.ListaPrognozaPerZi[i].Valoare = val24; break; default: break; } _context.PrognozaEnergieModels.Update(dvm.ListaPrognozaPerZi[i]); } } // Save to Database _context.SaveChanges(); // Add ChartData dvm.ChartData = chartData; ViewBag.dataSource = chartData; // Save to Excel File if (submitBtn == "Get File") { var filePath = _reportService.SaveExcelFileToDisk(dvm, _env, startDate).ToString(); byte[] fileBytes = System.IO.File.ReadAllBytes(filePath); return(File(fileBytes, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Prognoza zilnic.xlsx")); } // Send Mail With File Per one day Forecast if (submitBtn == "Send Mail") { var fisierDeTrimis = _reportService.SaveExcelFileToDisk(dvm, _env, startDate).ToString(); string filePathMailModel = Path.Combine(_env.WebRootPath, "Fisiere\\MailDate.JSON"); MailModel mailModel = _reportService.GetMailModelAsync(filePathMailModel).Result; _emailSender.SendEmailAsync(mailModel.FromAdress, mailModel.ToAddress, mailModel.Subjsect, mailModel.Messaege, fisierDeTrimis); } return(View(dvm)); }