예제 #1
0
        private void btnExport_Click(object sender, RoutedEventArgs e)
        {
            DateTime dtBegin      = (DateTime)deBegin.EditValue;
            DateTime dtEnd        = (DateTime)deEnd.EditValue;
            string   formatString = "dd.MM.yy HH_mm";

            DocumentPreviewWindow preview = new DocumentPreviewWindow();
            CollectionViewLink    link    = new CollectionViewLink();

            link.PrintingSystem.ExportOptions.PrintPreview.DefaultExportFormat = DevExpress.XtraPrinting.PrintingSystemCommand.ExportXlsx;
            link.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName     = string.Format("{0} (с {1} по {2})", Item.Description, dtBegin.ToString(formatString), dtEnd.ToString(formatString));
            link.PaperKind        = DevExpress.Xpf.Drawing.Printing.PaperKind.A4;
            link.Margins.Bottom   = link.Margins.Top = link.Margins.Left = link.Margins.Right = 10;
            link.ExportServiceUri = string.Format("http://{0}/ExportService.svc", Global.Default.ServerIPAddress);
            LinkPreviewModel model = new LinkPreviewModel(link);

            CollectionViewSource collectionViewSource = new CollectionViewSource
            {
                Source = Trends
            };

            link.CollectionView = collectionViewSource.View;

            link.DetailTemplate       = (DataTemplate)Resources["trendDataTemplate"];
            link.ReportHeaderTemplate = (DataTemplate)Resources["trendHeaderTemplate"];

            preview.Model = model;
            link.CreateDocument(false);
            preview.ShowDialog();
        }
예제 #2
0
        public void ViewReport()
        {
            XtraReportBASELINE_ITEMS baselineReport  = new XtraReportBASELINE_ITEMS();
            PROJECT_REPORT           dbProjectReport = loaderCollection.GetObject <PROJECT_REPORT>();

            if (dbProjectReport != null)
            {
                string reportString = dbProjectReport.REPORT.ToString();
                using (StreamWriter sw = new StreamWriter(new MemoryStream()))
                {
                    sw.Write(reportString);
                    sw.Flush();
                    baselineReport.LoadLayout(sw.BaseStream);
                }
            }

            //make sure disciplines are all populated
            PopulateNavigationalProperties();
            baselineReport.AssignProperties(loadPROJECT, loadBASELINE, MainViewModel.Entities);
            DocumentPreviewWindow previewWindow = new DocumentPreviewWindow();

            previewWindow.PreviewControl.DocumentSource = baselineReport;
            previewWindow.WindowStartupLocation         = WindowStartupLocation.CenterScreen;
            previewWindow.WindowState        = WindowState.Maximized;
            baselineReport.RequestParameters = false;
            baselineReport.CreateDocument(true);
            previewWindow.ShowDialog();
        }
예제 #3
0
        private void OnPrint()
        {
            XtraReport report;

            if (IsByCustomer)
            {
                report = new SalesReport();
                if (SelectedCustomer != null)
                {
                    report.DataSource = Transactions.Where(c => c.Customer.Id == SelectedCustomer.Id).ToList();
                }
            }
            else
            {
                report            = new AllTransactionReport();
                report.DataSource = Transactions;
            }

            var window = new DocumentPreviewWindow();

            window.PreviewControl.DocumentSource = report;
            report.CreateDocument(true);
            report.PrintingSystem.Document.AutoFitToPagesWidth = 1;
            window.WindowStartupLocation = WindowStartupLocation.CenterScreen;
            window.WindowState           = WindowState.Maximized;
            window.ShowDialog();
        }
예제 #4
0
        public void ViewReport()
        {
            XtraReportPROGRESS_ITEMS progressReport  = new XtraReportPROGRESS_ITEMS();
            PROJECT_REPORT           dbProjectReport = loaderCollection.GetObject <PROJECT_REPORT>();

            if (dbProjectReport != null)
            {
                string reportString = dbProjectReport.REPORT.ToString();
                using (StreamWriter sw = new StreamWriter(new MemoryStream()))
                {
                    sw.Write(reportString);
                    sw.Flush();
                    progressReport.LoadLayout(sw.BaseStream);
                }
            }

            PROJECTSummaryBuilder projectSummaryBuilder = new PROJECTSummaryBuilder(currentPROJECTSummary);

            CalculateStatsForReport(projectSummaryBuilder);
            progressReport.AssignProperties(currentPROJECTSummary, loadPROGRESS.PROJECT.NAME);
            DocumentPreviewWindow previewWindow = new DocumentPreviewWindow();

            previewWindow.PreviewControl.DocumentSource = progressReport;
            previewWindow.WindowStartupLocation         = WindowStartupLocation.CenterScreen;
            previewWindow.WindowState        = WindowState.Maximized;
            progressReport.RequestParameters = false;
            progressReport.CreateDocument(true);
            previewWindow.ShowDialog();
        }
예제 #5
0
        private void OnPreviewDocument()
        {
            var viewModel = new DocumentPreviewViewModel();
            var preview   = new DocumentPreviewWindow(viewModel);

            preview.Show();
        }
        private void Print()
        {
            XtraReport report = new XtraReport1();

            ReportData = new SignsJobCardReportData();

            var aluminumSheets = SelectedAluminumSheets.Split(',');

            ReportData.AluminumSheet2_03MM  = aluminumSheets.Contains("2.03mm") ? "P" : "";
            ReportData.AluminumSheet3_175MM = aluminumSheets.Contains("3.175mm") ? "P" : "";
            ReportData.AluminumSheet3_0MM   = aluminumSheets.Contains("3.0mm") ? "P" : "";
            ReportData.AluminumSheet2_0MM   = aluminumSheets.Contains("2.0mm") ? "P" : "";
            ReportData.AluminumSheet1_5MM   = aluminumSheets.Contains("1.5mm") ? "P" : "";
            ReportData.AluminumSheet1MM     = aluminumSheets.Contains("1.0mm") ? "P" : "";


            report.DataSource = new List <SignsJobCardReportData> {
                ReportData
            };

            DocumentPreviewWindow window = new DocumentPreviewWindow();

            window.PreviewControl.DocumentSource = report;
            report.CreateDocument();
            window.Show();
        }
예제 #7
0
        private void _bbidocgiareport_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
        {
            MemBerAll             report = new MemBerAll();
            DocumentPreviewWindow window = new DocumentPreviewWindow();

            window.PreviewControl.DocumentSource = report;
            report.CreateDocument(true);
            window.ShowDialog();
        }
예제 #8
0
        private void ShowPreview(object sender, RoutedEventArgs e)
        {
            Report report = new Report();
            DocumentPreviewWindow window = new DocumentPreviewWindow();

            window.PreviewControl.DocumentSource = report;
            report.CreateDocument(true);
            window.ShowDialog();
        }
예제 #9
0
        private void button2_Click(object sender, RoutedEventArgs e)
        {
            ReportAfleverEtiket report = new ReportAfleverEtiket();
            var window = new DocumentPreviewWindow();

            window.PreviewControl.DocumentSource = report;
            report.CreateDocument();
            window.Show();
        }
예제 #10
0
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            DocumentPreviewWindow preview = new DocumentPreviewWindow();
            PrintableControlLink  link    = new PrintableControlLink(view);
            LinkPreviewModel      model   = new LinkPreviewModel(link);

            preview.Model = model;
            link.CreateDocument(true);
            preview.ShowDialog();
        }
        private void ShowPrintPreview(GridControl grid)
        {
            DocumentPreviewWindow preview = new DocumentPreviewWindow();
            PrintableControlLink  link    = new PrintableControlLink(grid.View as DevExpress.Xpf.Printing.IPrintableControl);

            link.ExportServiceUri = "../ExportService1.svc";
            LinkPreviewModel model = new LinkPreviewModel(link);

            preview.Model = model;
            link.CreateDocument(false);
            preview.ShowDialog();
        }
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            DocumentPreviewWindow preview = new DocumentPreviewWindow();
            PrintableControlLink  link    = new PrintableControlLink(grid.View as DevExpress.Xpf.Printing.IPrintableControl);

            link.ExportServiceUri = "../ExportService1.svc";
            LinkPreviewModel model = new LinkPreviewModel(link);

            preview.Model = model;
            link.CreateDocument(true);
            preview.ShowDialog();
        }
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            RichEditDocumentServer documentServer = new RichEditDocumentServer();

            documentServer.Text = "RichEditDocumentServer Print Preview.";
            LegacyPrintableComponentLink link   = new LegacyPrintableComponentLink(documentServer);
            DocumentPreviewWindow        window = new DocumentPreviewWindow();

            window.PreviewControl.DocumentSource = link;
            link.CreateDocument(false);
            window.ShowDialog();
        }
        private void button1_Click(object sender, RoutedEventArgs e)
        {
            PrintableControlLink  link    = new PrintableControlLink((DevExpress.Xpf.Grid.TableView)gridControl1.View, "My Document");
            DocumentPreviewWindow preview = new DocumentPreviewWindow();

            preview.PreviewControl.DocumentSource = link;
            link.CreateDocument(true);

            ThemeManager.SetThemeName(preview, ThemeManager.GetThemeName(gridControl1));

            preview.Show();
        }
예제 #15
0
        private void PrintXtraReport()
        {
            var xtraReport = new XtraReport2();

            var window = new DocumentPreviewWindow {
                WindowStartupLocation = WindowStartupLocation.CenterScreen
            };

            window.PreviewControl.DocumentSource = xtraReport;
            xtraReport.CreateDocument(true);
            window.ShowDialog();
        }
예제 #16
0
        void ShowProducts()
        {
            var model = new ReportPreviewModel {
                ServiceUri = "../ReportService.svc",
                ReportName = "Reports.ProductReport"
            };
            var window = new DocumentPreviewWindow {
                Model = model
            };

            window.Show();
            model.CreateDocument();
        }
예제 #17
0
        private void button1_Click(object sender, RoutedEventArgs e)
        {
            ReportHelper.ReportGeneratonHelper helper = new ReportHelper.ReportGeneratonHelper();
            XtraReport            report = helper.GenerateReport(grid, grid.ItemsSource);
            DocumentPreviewWindow dp     = new DocumentPreviewWindow()
            {
                Owner = this
            };

            dp.PreviewControl.DocumentSource = report;
            report.CreateDocument(false);
            dp.ShowDialog();
        }
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            var link = new PrintableControlLink((TableView)gridControl1.View);

            link.PageHeaderTemplate = (DataTemplate)Resources["PageHeader"];
            link.PageFooterTemplate = (DataTemplate)Resources["PageFooter"];

            DocumentPreviewWindow wnd = new DocumentPreviewWindow();

            wnd.PreviewControl.DocumentSource = link;
            link.CreateDocument();
            wnd.Show();
        }
        public void ShowPreview(string serviceUri, string reportName)
        {
            ReportServicePreviewModel model = new ReportServicePreviewModel(serviceUri);

            model.ReportName = reportName;
            DocumentPreviewWindow preview = new DocumentPreviewWindow()
            {
                Model = model
            };

            model.CreateDocument();
            preview.ShowDialog();
        }
예제 #20
0
        private void ShowPreview(object sender, RoutedEventArgs e)
        {
            RemoteDocumentSource remoteSource = new RemoteDocumentSource();

            remoteSource.ServiceUri = @"http://localhost:50786/ReportService1.svc";
            remoteSource.ReportName = "ReportService.Reports.Report, Reporting";

            DocumentPreviewWindow window = new DocumentPreviewWindow();

            window.PreviewControl.DocumentSource = remoteSource;
            remoteSource.CreateDocument();

            window.ShowDialog();
        }
        private void button1_Click(object sender, RoutedEventArgs e)
        {
            SimpleLink            link    = new SimpleLink("ListViewDocument");
            DocumentPreviewWindow preview = new DocumentPreviewWindow();

            preview.PreviewControl.DocumentSource = link;

            link.PageHeaderTemplate = (DataTemplate)Resources["printHeaderTemplate"];
            link.DetailTemplate     = (DataTemplate)Resources["printDataTemplate"];
            link.DetailCount        = listView1.Items.Count;
            link.CreateDetail      += new EventHandler <CreateAreaEventArgs>(link_CreateDetail);
            link.CreateDocument(true);
            preview.ShowDialog();
        }
예제 #22
0
        private void Print()
        {
            XtraReport report = new JournalVoucherReport();

            report.DataSource = new List <JournalVoucherModel> {
                Entity
            };

            DocumentPreviewWindow window = new DocumentPreviewWindow();

            window.PreviewControl.DocumentSource = report;
            report.CreateDocument();
            window.Show();
        }
예제 #23
0
        private void ShowPreview(object sender, RoutedEventArgs e)
        {
            OpenFileDialog ofd = new OpenFileDialog();

            if (ofd.ShowDialog() == true)
            {
                Report report = new Report();
                report.xrRichText1.Rtf = File.ReadAllText(ofd.FileName);

                DocumentPreviewWindow window = new DocumentPreviewWindow();
                window.PreviewControl.DocumentSource = report;
                report.CreateDocument(true);
                window.ShowDialog();
            }
        }
        private void Print()
        {
            XtraReport report = new ChequeDepositVoucherReport();

            Entity.AccountNo    = Branch.AccountNumber;
            Entity.Branch       = Branch.BranchName;
            Entity.CustomerName = Branch.CompanyName;
            report.DataSource   = new List <DepositSlipLineViewModel> {
                Entity
            };

            DocumentPreviewWindow window = new DocumentPreviewWindow();

            window.PreviewControl.DocumentSource = report;
            report.CreateDocument();
            window.Show();
        }
        private void Print()
        {
            XtraReport report = new JournalVoucherReceiptReport();

            //JVR.AccountNo = TransactionType.AccountCode;
            ////JVR.Branch = Branch.BranchName;
            ////JVR.CustomerName = Branch.CompanyName;
            report.DataSource = new List <JournalVoucherReceiptModel> {
                Entity
            };

            DocumentPreviewWindow window = new DocumentPreviewWindow();

            window.PreviewControl.DocumentSource = report;
            report.CreateDocument();
            window.Show();
        }
예제 #26
0
        public void Print(Window ownerWindow)
        {
            //TableViewAllEmployees.ShowPrintPreviewDialog(ownerWindow);

            using (var print = new PrintableControlLink(TableViewAllEmployees))
            {
                var preview = new DocumentPreviewWindow
                {
                    Owner = ownerWindow,
                    Model = new LinkPreviewModel(print)
                };

                print.CreateDocument(true);

                preview.FlowDirection = FlowDirection.RightToLeft;
                preview.ShowDialog();
            }
        }
예제 #27
0
        private void ShowPreviewWindow(string filePath)
        {
            if (string.IsNullOrEmpty(filePath))
            {
                return;
            }

            if (OpenDocumentByNativeApplication)
            {
                ShowPreviewByNativeApplication(filePath);
            }
            else
            {
                var viewModel = new DocumentPreviewViewModel();
                var preview   = new DocumentPreviewWindow(viewModel);
                viewModel.FilePath = filePath;
                preview.Show();
            }
        }
예제 #28
0
        private void btnExport_Click(object sender, RoutedEventArgs e)
        {
            //Global.Default.ShowForm(ref ExportDocumentPanel, "Форма экспорта данных.", "/WebControl;component/Forms/DataGridExport.xaml", new Size(800, 600), true, this);

            DateTime dtBegin      = (DateTime)deBegin.EditValue;
            DateTime dtEnd        = (DateTime)deEnd.EditValue;
            string   formatString = "dd.MM.yy HH_mm";

            DocumentPreviewWindow preview = new DocumentPreviewWindow();
            PrintableControlLink  link    = new PrintableControlLink(gridControl.View as DevExpress.Xpf.Printing.IPrintableControl);

            link.PrintingSystem.ExportOptions.PrintPreview.DefaultExportFormat = DevExpress.XtraPrinting.PrintingSystemCommand.ExportXlsx;
            link.PrintingSystem.ExportOptions.PrintPreview.DefaultFileName     = string.Format("Отчет Ангидрит. МТБ. (с {0} по {1})", dtBegin.ToString(formatString), dtEnd.ToString(formatString));
            link.PaperKind        = DevExpress.Xpf.Drawing.Printing.PaperKind.A4;
            link.Margins.Bottom   = link.Margins.Top = link.Margins.Left = link.Margins.Right = 10;
            link.ExportServiceUri = string.Format("http://{0}/ExportService.svc", Global.Default.ServerIPAddress);
            LinkPreviewModel model = new LinkPreviewModel(link);

            preview.Model = model;
            link.CreateDocument(false);
            preview.ShowDialog();
        }
예제 #29
0
        private void Window_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.Key == Key.F1)
            {
                XtraReport1 report            = new XtraReport1();
                SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
                FF.FileName = Properties.Settings.Default.path;
                ((SqlDataSource)report.DataSource).ConnectionParameters = FF;
                XtraReportPreviewModel model   = new XtraReportPreviewModel(report);
                DocumentPreviewWindow  windoww = new DocumentPreviewWindow()
                {
                    Model = model
                };
                report.CreateDocument(true);
                windoww.ShowDialog();
                //using (ReportPrintTool printTool = new ReportPrintTool(report))
                //{

                //    printTool.Print();

                //    //or printTool.PrintDialog();
                //}
            }
        }
예제 #30
0
        private void Print_Click(object sender, RoutedEventArgs e)
        {
            var SumPricee = new FunctionsOfSum();

            var Fa_delete = new Assest.OrcDataAcess();
            var FA        = new Assest.OrcDataAcess();

            try
            {
                double afo      = 0;
                var    Filtring = new List <string>();
                foreach (string item in PriceList)
                {
                    Filtring.Add(item.Replace("SAR", ""));
                }

                var           accc = new Assest.OrcDataAcess();
                List <string> L0   = new List <string>();
                List <string> L1   = new List <string>();
                List <string> L2   = new List <string>();
                List <string> L3   = new List <string>();
                List <string> L4   = new List <string>();
                List <string> L5   = new List <string>();
                List <string> L6   = new List <string>(); //
                List <string> L7   = new List <string>(); //dis
                List <string> L8   = new List <string>(); //pricef
                List <string> L9   = new List <string>(); //dat


                /*
                 *
                 *
                 *
                 */



                DataTable tt = new DataTable();
                accc.Show(tt);

                //                Finall_Price = (Double)((Price * Discount) / 100) - Price;

                foreach (DataRow r in tt.Rows)
                {
                    L1.Add(r.Field <string>("NAME"));
                    L2.Add(r.Field <string>("BARCODE"));
                    L3.Add(r.Field <string>("PRICE_A"));
                    L4.Add(r.Field <string>("PRICE"));
                    L5.Add(r.Field <string>("ID"));
                    L6.Add(r.Field <string>("QUANTITY"));
                    L7.Add(r.Field <string>("Dis"));
                    L8.Add(r.Field <string>("Price_F"));
                }
                tt.Clear();
                accc.show3(tt);
                foreach (DataRow r in tt.Rows)
                {
                    L0.Add(r.Field <String>("NUMF"));
                }
                foreach (string asf in Filtring)
                {
                    afo += double.Parse(asf);
                }
                PriceList.Add(afo.ToString());
                Pricce.Text = "SAR " + afo.ToString();

                var RepHelper = new ReportHelper();
                var ILIST     = new List <ReportHelper>();
                ILIST.Add(new ReportHelper()
                {
                    Getprice_ = Pricce.Text
                });
                XtraReport3 report            = new XtraReport3();
                SQLiteConnectionParameters FF = new SQLiteConnectionParameters();
                FF.FileName = System.Windows.Forms.Application.StartupPath + "\\dbPascal.db";
                ((SqlDataSource)report.DataSource).ConnectionParameters = FF;
                XtraReportPreviewModel model   = new XtraReportPreviewModel(report);
                DocumentPreviewWindow  windoww = new DocumentPreviewWindow()
                {
                    Model = model
                };
                report.CreateDocument(true);
                windoww.ShowDialog();

                string id_3 = "";
                //int finalprice = int.Parse(SumPricee.sumPrice().Replace("SAR", "").Replace(",", ""));
                //double Ristt = double.Parse(afo.ToString().Replace("SAR", "").Replace(",", ""));
                //double FInaal = finalprice + Ristt;
                for (int i = 0; i < L1.Count; i++)
                {
                    if (L1[i] == Name.Text)
                    {
                        id_3 = L5[i];
                    }
                }
                List <int> sawf = new List <int>();

                foreach (string d in L0)
                {
                    sawf.Add(int.Parse(d));
                }
                #region Convert Days to arabic language
                string dayoftheweek = "";
                switch (DateTime.Now.DayOfWeek)
                {
                case DayOfWeek.Sunday:
                {
                    dayoftheweek = ".الاحد";
                    break;
                }

                case DayOfWeek.Monday:
                {
                    dayoftheweek = ".الاثنين";
                    break;
                }

                case DayOfWeek.Thursday:
                {
                    dayoftheweek = ".الخميس";
                    break;
                }

                case DayOfWeek.Saturday:
                {
                    dayoftheweek = ".السبت";
                    break;
                }

                case DayOfWeek.Friday:
                {
                    dayoftheweek = "الجمعة.";
                    break;
                }

                case DayOfWeek.Tuesday:
                {
                    dayoftheweek = "الثلاثاء.";
                    break;
                }

                case DayOfWeek.Wednesday:
                {
                    dayoftheweek = "الاربعاء.";
                    break;
                }
                }
                #endregion
                if (L0.Count == 0)
                {
                    //null
                }

                else
                {
                    numfa = sawf.Max() + 1;
                }
                if (sawf.Count == 0)
                {
                    UmAlQuraCalendar um          = new UmAlQuraCalendar();
                    String           CurrentDate = (int.Parse(DateTime.Now.Year.ToString()) < 1600) ? DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() :
                                                   um.GetYear(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetMonth(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetDayOfMonth(DateTime.Parse(DateTime.Now.ToString())).ToString();

                    for (int i = 0; i < L1.Count; i++)
                    {
                        double Price        = 0;
                        double Discount     = 0;
                        double Finall_Price = 0;
                        string Result       = "";

                        DateTime dtttt = new DateTime();
                        for (int ii = 0; ii < asdf.Count; ii++)
                        {
                            if (L1[i] == asdf[ii])
                            {
                                accc.insert3(CurrentDate, L1[i], getwholeprice(i, L4, L7), L5[i], L6[i], L3[i], L2[i], numfa.ToString(), dayoftheweek, Pricce.Text);

                                Price        = (String.IsNullOrEmpty(L4[i].Replace("SAR", ""))) ? 0 : (Double)Double.Parse(double.Parse(L4[i].Replace("SAR", "")).ToString().Replace("SAR", ""));
                                Discount     = (String.IsNullOrEmpty(L7[i].Replace("%", ""))) ? 0 : (Double)Double.Parse(double.Parse(L7[i].Replace("%", "")).ToString().Replace("%", ""));
                                Finall_Price = (Double)((Price * Discount) / 100) - Price;
                                Finall_Price = Finall_Price * int.Parse(L6[i]);
                                Result       = "SAR " + Finall_Price.ToString("N2").Replace("-", "");
                                var mainwi = new MainWindow(L1[i], L4[i], L6[i], L2[i], L3[i], L5[i], L7[i], Result);
                                mainwi.EDIT_MAX();
                            }

                            /*
                             *
                             * L1.Add(r.Field<string>("NAME"));
                             * L2.Add(r.Field<string>("BARCODE"));
                             * L3.Add(r.Field<string>("PRICE_A"));
                             * L4.Add(r.Field<string>("PRICE"));
                             * L5.Add(r.Field<string>("ID"));
                             * L6.Add(r.Field<string>("QUANTITY"));
                             * L7.Add(r.Field<string>("Dis"));
                             * L8.Add(r.Field<string>("Price_F"));
                             */
                        }
                    }

                    if (GID.Count > 0)
                    {
                        for (int i = 0; i < GID.Count; i++)
                        {
                            FA.Delete(GID[i]);
                        }
                    }
                }
                else
                {
                    #region Date

                    UmAlQuraCalendar um          = new UmAlQuraCalendar();
                    String           CurrentDate = (int.Parse(DateTime.Now.Year.ToString()) < 1600) ? DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() :
                                                   um.GetYear(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetMonth(DateTime.Parse(DateTime.Now.ToString())).ToString() + "/" + um.GetDayOfMonth(DateTime.Parse(DateTime.Now.ToString())).ToString();

                    #endregion


                    for (int i = 0; i < L1.Count; i++)
                    {
                        double Price        = 0;
                        double Discount     = 0;
                        double Finall_Price = 0;
                        string Result       = "";

                        DateTime dtttt = new DateTime();
                        for (int ii = 0; ii < asdf.Count; ii++)
                        {
                            if (L1[i] == asdf[ii])
                            {
                                accc.insert3(CurrentDate, L1[i], getwholeprice(i, L4, L7), L5[i], L6[i], L3[i], L2[i], numfa.ToString(), dayoftheweek, Pricce.Text);
                                Price        = (String.IsNullOrEmpty(L4[i].Replace("SAR", ""))) ? 0 : (Double)Double.Parse(double.Parse(L4[i].Replace("SAR", "")).ToString().Replace("SAR", ""));
                                Discount     = (String.IsNullOrEmpty(L7[i].Replace("%", ""))) ? 0 : (Double)Double.Parse(double.Parse(L7[i].Replace("%", "")).ToString().Replace("%", ""));
                                Finall_Price = (Double)((Price * Discount) / 100) - Price;
                                Finall_Price = Finall_Price * int.Parse(L6[i]);
                                Result       = "SAR " + Finall_Price.ToString("N2").Replace("-", "");
                                var mainwi = new MainWindow(L1[i], L4[i], L6[i], L2[i], L3[i], L5[i], L7[i], Result);
                                mainwi.EDIT_MAX();
                            }
                        }
                    }

                    if (GID.Count > 0)
                    {
                        for (int i = 0; i < GID.Count; i++)
                        {
                            FA.Updating_QUa("0", GID[i].ToString());
                        }
                    }
                }
                asdf.Clear();



                for (int i = 0; i < PriceList.Count; i++)
                {
                    Fa_delete._Delete(double.Parse(PriceList[i].Replace("SAR", "").Replace(",", "")));
                }
            }
            catch (Exception ex) { System.Windows.MessageBox.Show(ex.Message + ":" + ex.HResult.ToString()); }
            DD.ItemsSource = "";
            Observ.Clear();
            NameList.Clear();
            PriceList.Clear();
        }