public ucDailySalesReport()
        {
            try
            {
                InitializeComponent();

                nepDate = new DateConverter(GlobalClass.TConnectionString);

                NumericColumn            = new Style();
                NumericColumn.TargetType = typeof(DataGridCell);
                NumericColumn.Setters.Add(new Setter {
                    Property = DataGridCell.HorizontalAlignmentProperty, Value = HorizontalAlignment.Right
                });



                txtTDate.SelectedDate = nepDate.GetLastDateOfBSMonth(DateTime.Today);
                txtFDate.SelectedDate = nepDate.GetFirstDateOfBSMonth(DateTime.Today);

                dgDailySales.Columns.Add(new DataGridTextColumn {
                    Header = "In", Binding = new Binding("Date1"), Width = 150
                });
                dgDailySales.Columns.Add(new DataGridTextColumn {
                    Header = "Out", Binding = new Binding("Date2"), Width = 150,
                });                                                                                                                // CellContentStringFormat = "{0:MM/dd/yyyy hh:mm tt}",
                dgDailySales.Columns.Add(new DataGridTextColumn {
                    Header = "Interval", Binding = new Binding("Column3"), Width = 100
                });
                dgDailySales.Columns.Add(new DataGridTextColumn {
                    Header = "Vehicle Type", Binding = new Binding("Column4"), Width = 100
                });
                dgDailySales.Columns.Add(new DataGridTextColumn {
                    Header = "Rate", Binding = new Binding("Column6"), Width = 200
                });
                dgDailySales.Columns.Add(new DataGridTextColumn {
                    Header = "Party", Binding = new Binding("Column5"), Width = 150
                });
                dgDailySales.Columns.Add(new DataGridTextColumn {
                    Header = "User", Binding = new Binding("Column7"), Width = 200
                });
                dgDailySales.Columns.Add(new DataGridTextColumn {
                    Header = "Charged Amount", Binding = new Binding("Decimal1")
                    {
                        StringFormat = "#0.00"
                    }, Width = 150, CellStyle = NumericColumn
                });                                                                                                                                                                                  //CellContentStringFormat = "{0:#0.00}",
                dgDailySales.Columns.Add(new DataGridTextColumn {
                    Header = "Amount", Binding = new Binding("Decimal2")
                    {
                        StringFormat = "#0.00"
                    }, Width = 150, CellStyle = NumericColumn
                });                                                                                                                                                                         //CellContentStringFormat = "{0:#0.00}",

                this.DataContext = ViewModel = new vmDailySales();
            }
            catch (Exception ex)
            {
                MessageBox.Show(GlobalClass.GetRootException(ex).Message, "Sales Report", MessageBoxButton.OK, MessageBoxImage.Error);
            }
        }