Example #1
0
        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));
        }
Example #3
0
        /// <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);
        }
Example #5
0
        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);
        }
Example #7
0
        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);
        }
Example #11
0
        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);
        }
Example #12
0
        public ActionResult Daily()
        {
            var model = new DailyViewModel()
            {
                DailyReadingsHtml = DailyReadingsScraper.GetReadings(),
                EditPostViewModel = EditViewModelFactory.GetNewEditPostViewModel(),
                //todo:getflashcards

            };

            return View(model);
        }
Example #13
0
        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));
        }
Example #14
0
        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));
            }
        }
Example #15
0
        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);
        }
Example #16
0
        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));
        }
Example #17
0
        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);
        }
Example #19
0
        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);
        }
Example #20
0
        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);
        }
Example #23
0
        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));
        }
Example #24
0
        // 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);
        }
Example #26
0
        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;
                }
            };
        }
Example #27
0
        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));
            }
        }
Example #28
0
        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));
        }