private void PrintMethod() { Mouse.OverrideCursor = Cursors.Wait; DS ds = new DS(); ds.RequiredCategory.Rows.Clear(); int i = 0; foreach (var item in categories.Where(w => w.RequiredQty > 0)) { ds.RequiredCategory.Rows.Add(); ds.RequiredCategory[i]["Serial"] = i + 1; ds.RequiredCategory[i]["Category"] = item.Category + " " + item.Company; ds.RequiredCategory[i]["Required"] = item.RequiredQty; i++; } ReportWindow rpt = new ReportWindow(); RequiredCategoryReport requiredCategoryRPT = new RequiredCategoryReport(); requiredCategoryRPT.SetDataSource(ds.Tables["RequiredCategory"]); rpt.crv.ViewerCore.ReportSource = requiredCategoryRPT; Mouse.OverrideCursor = null; rpt.ShowDialog(); //requiredCategoryRPT.PrintOptions.PrinterName = _selectedPrinter; //requiredCategoryRPT.PrintToPrinter(1, true, 0, 0); }
private void PrintMethod() { Mouse.OverrideCursor = Cursors.Wait; DS ds = new DS(); ds.Sale.Rows.Clear(); int i = 0; foreach (var item in _supplyOfferCategories) { ds.Sale.Rows.Add(); ds.Sale[i]["Client"] = _selectedSupplyOffer.Client.Name; ds.Sale[i]["Serial"] = i + 1; ds.Sale[i]["Category"] = item.Category + " " + item.Company; ds.Sale[i]["Qty"] = item.Qty; ds.Sale[i]["Price"] = Math.Round(Convert.ToDecimal(item.CostAfterTax), 2); ds.Sale[i]["TotalPrice"] = Math.Round(Convert.ToDecimal(item.CostTotalAfterTax), 2); ds.Sale[i]["BillPrice"] = Math.Round(Convert.ToDecimal(_selectedSupplyOffer.CostAfterTax), 2); i++; } ReportWindow rpt = new ReportWindow(); SupplyOfferReport supplyOfferRPT = new SupplyOfferReport(); supplyOfferRPT.SetDataSource(ds.Tables["Sale"]); rpt.crv.ViewerCore.ReportSource = supplyOfferRPT; Mouse.OverrideCursor = null; _currentWindow.Hide(); rpt.ShowDialog(); _currentWindow.ShowDialog(); }
private void PrintMethod() { Mouse.OverrideCursor = Cursors.Wait; DS ds = new DS(); ds.RequiredCategory.Rows.Clear(); int i = 0; foreach (var item in _categoryServ.GetAllRequiredCategories().Where(w => w.RequiredQty > 0)) { ds.RequiredCategory.Rows.Add(); ds.RequiredCategory[i]["Serial"] = i + 1; ds.RequiredCategory[i]["Company"] = item.Company; ds.RequiredCategory[i]["Category"] = item.Category; //ds.RequiredCategory[i]["Cost"] = item.Cost; //ds.RequiredCategory[i]["Qty"] = item.Qty; ds.RequiredCategory[i]["Required"] = item.RequiredQty; i++; } ReportWindow rpt = new ReportWindow(); RequiredCategoryReport requiredCategoryRPT = new RequiredCategoryReport(); requiredCategoryRPT.SetDataSource(ds.Tables["RequiredCategory"]); rpt.crv.ViewerCore.ReportSource = requiredCategoryRPT; Mouse.OverrideCursor = null; rpt.ShowDialog(); }
protected void gameSubmissionDone(object sender, RunWorkerCompletedEventArgs e) { if (e.Cancelled) { this.enableInterface(); return; } ReportWindow report = new ReportWindow(analyzer, this); report.ShowDialog(); if (report.SentOrSaved) { analyzer.game.Submitted = true; Games.saveCustomGames(); } if (askAboutGame()) { return; } submitGame.IsEnabled = Games.HasUnsubmittedGames; this.enableInterface(); }
private void ExecuteSave() { Mouse.OverrideCursor = Cursors.Wait; DateTime _dt = DateTime.Now; _saleOfferServ.AddSaleOffer(_newSaleOffer); int _saleOfferID = _saleOfferServ.GetLastSaleOfferID(); foreach (var item in _saleOfferCategories) { SaleOfferCategory _saleOfferCategory = new SaleOfferCategory { CategoryID = item.CategoryID, PriceAfterDiscount = item.PriceAfterDiscount, PriceTotalAfterDiscount = item.PriceTotalAfterDiscount, Price = item.Price, PriceTotal = item.PriceTotal, Discount = item.Discount, DiscountValue = item.DiscountValue, DiscountValueTotal = item.DiscountValueTotal, SaleOfferID = _saleOfferID, Qty = item.Qty }; _saleOfferCategoryServ.AddSaleOfferCategory(_saleOfferCategory); } DS ds = new DS(); ds.Sale.Rows.Clear(); int i = 0; foreach (var item in _saleOfferCategories) { ds.Sale.Rows.Add(); ds.Sale[i]["Client"] = _selectedClient.Name; ds.Sale[i]["Serial"] = i + 1; ds.Sale[i]["Category"] = item.Category + " " + item.Company; ds.Sale[i]["Qty"] = item.Qty; ds.Sale[i]["Price"] = Math.Round(Convert.ToDecimal(item.PriceAfterDiscount), 2); ds.Sale[i]["TotalPrice"] = Math.Round(Convert.ToDecimal(item.PriceTotalAfterDiscount), 2); ds.Sale[i]["BillPrice"] = Math.Round(Convert.ToDecimal(_newSaleOffer.PriceAfterDiscount), 2);; i++; } ReportWindow rpt = new ReportWindow(); SaleOfferReport saleOfferRPT = new SaleOfferReport(); saleOfferRPT.SetDataSource(ds.Tables["Sale"]); rpt.crv.ViewerCore.ReportSource = saleOfferRPT; Mouse.OverrideCursor = null; _currentWindow.Hide(); rpt.ShowDialog(); NewSaleOffer = new SaleOffer(); NewSaleOfferCategory = new SaleOfferCategoryVM(); SaleOfferCategories = new ObservableCollection <SaleOfferCategoryVM>(); NewSaleOffer.Date = DateTime.Now; OldPrices = new ObservableCollection <SaleCategory>(); _currentWindow.ShowDialog(); }
private void PrintMethod() { Mouse.OverrideCursor = Cursors.Wait; DS ds = new DS(); ds.ClientAccount.Rows.Clear(); int i = 0; foreach (var item in _clientAccounts) { ds.ClientAccount.Rows.Add(); ds.ClientAccount[i]["Serial"] = i + 1; ds.ClientAccount[i]["Client"] = _selectedClient.Name; ds.ClientAccount[i]["DateFrom"] = _dateFrom; ds.ClientAccount[i]["DateTo"] = _dateTo; ds.ClientAccount[i]["Date"] = item.Date; ds.ClientAccount[i]["Statement"] = item.Statement; ds.ClientAccount[i]["Debit"] = item.Debit; ds.ClientAccount[i]["Credit"] = item.Credit; ds.ClientAccount[i]["TotalDebit"] = _selectedClientAccount.TotalDebit; ds.ClientAccount[i]["TotalCredit"] = _selectedClientAccount.TotalCredit; ds.ClientAccount[i]["DuringAccount"] = Math.Abs(Convert.ToDecimal(_selectedClientAccount.DuringAccount)); if (_selectedClientAccount.DuringAccount > 0) { ds.ClientAccount[i]["DuringAccountType"] = "له"; } else if (_selectedClientAccount.DuringAccount < 0) { ds.ClientAccount[i]["DuringAccountType"] = "عليه"; } ds.ClientAccount[i]["NotDuringAccount"] = Math.Abs(Convert.ToDecimal(_selectedClientAccount.OldAccount)); if (_selectedClientAccount.OldAccount > 0) { ds.ClientAccount[i]["NotDuringAccountType"] = "له"; } else if (_selectedClientAccount.OldAccount < 0) { ds.ClientAccount[i]["NotDuringAccountType"] = "عليه"; } ds.ClientAccount[i]["CurrentAccount"] = Math.Abs(Convert.ToDecimal(_selectedClientAccount.CurrentAccount)); if (_selectedClientAccount.CurrentAccount > 0) { ds.ClientAccount[i]["CurrentAccountType"] = "له"; } else if (_selectedClientAccount.CurrentAccount < 0) { ds.ClientAccount[i]["CurrentAccountType"] = "عليه"; } i++; } ReportWindow rpt = new ReportWindow(); ClientAccountReport accountClientRPT = new ClientAccountReport(); accountClientRPT.SetDataSource(ds.Tables["ClientAccount"]); rpt.crv.ViewerCore.ReportSource = accountClientRPT; Mouse.OverrideCursor = null; rpt.ShowDialog(); }
private void ExecuteSaveAsync() { Mouse.OverrideCursor = Cursors.Wait; _selectedSupplyOffer.Client = _selectedClient; _supplyOfferServ.UpdateSupplyOffer(_selectedSupplyOffer); _supplyOfferCategoryServ.DeleteSupplyOfferCategories(ID); foreach (var item in _supplyOfferCategories) { SupplyOfferCategory _supplyOfferCategory = new SupplyOfferCategory { CategoryID = item.CategoryID, Cost = item.Cost, CostAfterDiscount = item.CostAfterDiscount, CostAfterTax = item.CostAfterTax, CostTotal = item.CostTotal, CostTotalAfterDiscount = item.CostTotalAfterDiscount, CostTotalAfterTax = item.CostTotalAfterTax, Discount = item.Discount, DiscountValue = item.DiscountValue, DiscountValueTotal = item.DiscountValueTotal, SupplyOfferID = ID, Qty = item.Qty, Tax = item.Tax, TaxValue = item.TaxValue, TaxValueTotal = item.TaxValueTotal }; _supplyOfferCategoryServ.AddSupplyOfferCategory(_supplyOfferCategory); } DS ds = new DS(); ds.Sale.Rows.Clear(); int i = 0; foreach (var item in _supplyOfferCategories) { ds.Sale.Rows.Add(); ds.Sale[i]["Client"] = _selectedClient.Name; ds.Sale[i]["Serial"] = i + 1; ds.Sale[i]["Category"] = item.Category + " " + item.Company; ds.Sale[i]["Qty"] = item.Qty; ds.Sale[i]["Price"] = Math.Round(Convert.ToDecimal(item.CostAfterTax), 2); ds.Sale[i]["TotalPrice"] = Math.Round(Convert.ToDecimal(item.CostTotalAfterTax), 2); ds.Sale[i]["BillPrice"] = Math.Round(Convert.ToDecimal(_selectedSupplyOffer.CostAfterTax), 2); i++; } ReportWindow rpt = new ReportWindow(); SupplyOfferReport supplyOfferRPT = new SupplyOfferReport(); supplyOfferRPT.SetDataSource(ds.Tables["Sale"]); rpt.crv.ViewerCore.ReportSource = supplyOfferRPT; Mouse.OverrideCursor = null; _currentWindow.Hide(); rpt.ShowDialog(); _currentWindow.Close(); }
//主动上报 private void Button_Click_Report(object sender, RoutedEventArgs e) { Topmost = false ; ReportWindow window = new ReportWindow(); window.ShowDialog(); Topmost = true; }
private void BtnReportSearch_Click(object sender, RoutedEventArgs e) { ReportWindow window = new ReportWindow() { ShowInTaskbar = false, Owner = this }; window.ShowDialog(); }
private static void Report(Exception e, bool waitForClose) { if (e != null) { var logger = LogManager.GetLogger("UnHandledException"); logger.Fatal(ExceptionFormatter.FormatException(e)); var reportWindow = new ReportWindow(e); if (waitForClose) { reportWindow.ShowDialog(); } else { reportWindow.Show(); } } }
//public ICommand ReportCommand { get; set; } //xử lí public MainViewModel() { LoadedWindowCommand = new RelayCommand <Window>((p) => { return(true); }, (p) => { isLoaded = true; p.Hide(); //Ẩn màn hình menu //Đăng nhập LoginWindow loginWindow = new LoginWindow(); loginWindow.ShowDialog(); var loginVM = loginWindow.DataContext as LoginViewModel; //Lấy data context từ static resource LoginVM ngoài LoginWindow.xaml //loginWindow là màn hình login, còn loginVM là dữ liệu của màn hình đó if (loginVM.isLogin) //Login được mới hiện menu { p.Show(); } else { p.Close(); } } ); MasterCommand = new RelayCommand <object>((p) => { return(true); }, (p) => { MasterWindow wd = new MasterWindow(); wd.ShowDialog(); }); TransactionCommand = new RelayCommand <object>((p) => { return(true); }, (p) => { TransactionWindow wd = new TransactionWindow(); wd.ShowDialog(); }); ReportCommand = new RelayCommand <object>((p) => { return(true); }, (p) => { ReportWindow wd = new ReportWindow(); wd.ShowDialog(); }); }
private void PrintMethod() { Mouse.OverrideCursor = Cursors.Wait; DS ds = new DS(); ds.Sale.Rows.Clear(); int i = 0; foreach (var item in _saleCategories) { ds.Sale.Rows.Add(); ds.Sale[i]["ID"] = ID; ds.Sale[i]["Date"] = _selectedSale.Date; ds.Sale[i]["Client"] = _selectedSale.Client.Name; ds.Sale[i]["Serial"] = i + 1; ds.Sale[i]["Category"] = item.Category + " " + item.Company; ds.Sale[i]["Qty"] = item.Qty; ds.Sale[i]["Price"] = Math.Round(Convert.ToDecimal(item.PriceAfterDiscount), 2); ds.Sale[i]["TotalPrice"] = Math.Round(Convert.ToDecimal(item.PriceTotalAfterDiscount), 2); ds.Sale[i]["BillPrice"] = _selectedSale.PriceAfterDiscount; ds.Sale[i]["OldDebt"] = Math.Abs(Convert.ToDecimal(_selectedSale.OldDebt)); ds.Sale[i]["TransportCost"] = _selectedSale.TransportCost; ds.Sale[i]["BillTotal"] = Math.Abs(Convert.ToDecimal(_selectedSale.PriceTotal)); ds.Sale[i]["Paid"] = _selectedSale.Paid; ds.Sale[i]["NewDebt"] = Math.Abs(Convert.ToDecimal(_selectedSale.NewDebt)); if (_selectedSale.NewDebt > 0) { ds.Sale[i]["Type"] = "له"; } else if (_selectedSale.NewDebt < 0) { ds.Sale[i]["Type"] = "عليه"; } ds.Sale[i]["Salesperson"] = _selectedSale.Salesperson.Name; ds.Sale[i]["PrintingMan"] = _selectedSale.PrintingMan; if (_selectedSale.OldDebt > 0) { ds.Sale[i]["Type2"] = "له"; } else if (_selectedSale.OldDebt < 0) { ds.Sale[i]["Type2"] = "عليه"; } ds.Sale[i]["Address"] = _selectedSale.Client.Address; try { ToWord toWord = new ToWord(Math.Abs(Convert.ToDecimal(_selectedSale.NewDebt)), currencies[0]); ds.Sale[i]["NewDebtAR"] = toWord.ConvertToArabic(); } catch { ds.Sale[i]["NewDebtAR"] = string.Empty; } i++; } ReportWindow rpt = new ReportWindow(); SaleReport saleRPT = new SaleReport(); saleRPT.SetDataSource(ds.Tables["Sale"]); rpt.crv.ViewerCore.ReportSource = saleRPT; Mouse.OverrideCursor = null; _currentWindow.Hide(); rpt.ShowDialog(); _currentWindow.ShowDialog(); //var dialog = new PrintDialog(); //dialog.PrintVisual(_currentWindow, "ss"); //bool? print = dialog.ShowDialog(); //if (print.HasValue && print.Value) //{ // string startupPath = Environment.CurrentDirectory; // printorderRPT.Load(startupPath + @"\..\..\PrintingOrderPaperRpt.rpt"); // printorderRPT.SetDataSource(ds.Tables["PrintOrder"]); // printorderRPT.Subreports[0].SetDataSource(ds.Tables["PrintOrderRaws"]); // printorderRPT.PrintOptions.PrinterName = dialog.PrintQueue.Name; // try // { // printorderRPT.PrintToPrinter(1, true, 0, 0); // } // catch { } //} }
private void Btn_Report_Click(object sender, RoutedEventArgs e) { if (rbText != null) { if (TB_Report.Text != null) { try { int ReportID = int.Parse(TB_Report.Text.ToString()); } catch { MessageBox.Show("Введите целое число"); return; } ReportWindow RW = new ReportWindow(); switch (rbText) { case "Client": { RW.InfoList = LoadClientInfo(int.Parse(TB_Report.Text.ToString())); cmndReport = new SqlCommand("select count(Rides_ID) from Rides where ClientID=@ClientID", connect); SqlParameter param = new SqlParameter(); param.ParameterName = "@ClientID"; param.Value = int.Parse(TB_Report.Text.ToString()); cmndReport.Parameters.Add(param); SqlDataReader reader = cmndReport.ExecuteReader(); while (reader.Read()) { object num = reader.GetValue(0); RW.RidesCount = int.Parse(num.ToString()); } reader.Close(); cmndReport = new SqlCommand("select sum(Distance) from Rides where ClientID=@ClientID", connect); param = new SqlParameter(); param.ParameterName = "@ClientID"; param.Value = int.Parse(TB_Report.Text.ToString()); cmndReport.Parameters.Add(param); reader = cmndReport.ExecuteReader(); while (reader.Read()) { object num = reader.GetValue(0); RW.DistanceSum = double.Parse(num.ToString()); } reader.Close(); cmndReport = new SqlCommand("select sum(Summary) from Rides where ClientID=@ClientID", connect); param = new SqlParameter(); param.ParameterName = "@ClientID"; param.Value = int.Parse(TB_Report.Text.ToString()); cmndReport.Parameters.Add(param); reader = cmndReport.ExecuteReader(); while (reader.Read()) { object num = reader.GetValue(0); RW.Sum = int.Parse(num.ToString()); } reader.Close(); } break; case "Driver": { RW.InfoList = LoadDriverInfo(int.Parse(TB_Report.Text.ToString())); cmndReport = new SqlCommand("select count(Rides_ID) from Rides where DriverID=@DriverID", connect); SqlParameter param = new SqlParameter(); param.ParameterName = "@DriverID"; param.Value = int.Parse(TB_Report.Text.ToString()); cmndReport.Parameters.Add(param); SqlDataReader reader = cmndReport.ExecuteReader(); while (reader.Read()) { object num = reader.GetValue(0); RW.RidesCount = int.Parse(num.ToString()); } reader.Close(); cmndReport = new SqlCommand("select sum(Distance) from Rides where DriverID=@DriverID", connect); param = new SqlParameter(); param.ParameterName = "@DriverID"; param.Value = int.Parse(TB_Report.Text.ToString()); cmndReport.Parameters.Add(param); reader = cmndReport.ExecuteReader(); while (reader.Read()) { object num = reader.GetValue(0); RW.DistanceSum = double.Parse(num.ToString()); } reader.Close(); cmndReport = new SqlCommand("select sum(Summary) from Rides where DriverID=@DriverID", connect); param = new SqlParameter(); param.ParameterName = "@DriverID"; param.Value = int.Parse(TB_Report.Text.ToString()); cmndReport.Parameters.Add(param); reader = cmndReport.ExecuteReader(); while (reader.Read()) { object num = reader.GetValue(0); RW.Sum = int.Parse(num.ToString()); } reader.Close(); } break; } RW.ShowDialog(); } } }
private void PrintMethod(string parameter) { Mouse.OverrideCursor = Cursors.Wait; DS ds = new DS(); ds.Sale.Rows.Clear(); int i = 0; foreach (var item in _saleCategories) { ds.Sale.Rows.Add(); ds.Sale[i]["ID"] = ID; ds.Sale[i]["Date"] = _selectedSale.Date; ds.Sale[i]["Client"] = _selectedSale.Client.Name; ds.Sale[i]["Serial"] = i + 1; ds.Sale[i]["Category"] = item.Category + " " + item.Company; ds.Sale[i]["Qty"] = item.Qty; ds.Sale[i]["Price"] = Math.Round(Convert.ToDecimal(item.Price), 2); ds.Sale[i]["TotalPrice"] = Math.Round(Convert.ToDecimal(item.PriceTotal), 2); ds.Sale[i]["BillPrice"] = _selectedSale.Price; ds.Sale[i]["OldDebt"] = Math.Abs(Convert.ToDecimal(_selectedSale.OldDebt)); ds.Sale[i]["BillTotal"] = Math.Abs(Convert.ToDecimal(_selectedSale.PriceTotal)); ds.Sale[i]["Paid"] = _selectedSale.CashPaid; ds.Sale[i]["DiscountPaid"] = _selectedSale.DiscountPaid; ds.Sale[i]["NewDebt"] = Math.Abs(Convert.ToDecimal(_selectedSale.NewDebt)); if (_selectedSale.NewDebt > 0) { ds.Sale[i]["Type"] = "له"; } else if (_selectedSale.NewDebt < 0) { ds.Sale[i]["Type"] = "عليه"; } if (_selectedSale.OldDebt > 0) { ds.Sale[i]["Type2"] = "له"; } else if (_selectedSale.OldDebt < 0) { ds.Sale[i]["Type2"] = "عليه"; } i++; } ReportWindow rpt = new ReportWindow(); if (parameter == "Client") { SaleReport saleRPT = new SaleReport(); saleRPT.SetDataSource(ds.Tables["Sale"]); rpt.crv.ViewerCore.ReportSource = saleRPT; Mouse.OverrideCursor = null; } else { SaleReport2 saleRPT = new SaleReport2(); saleRPT.SetDataSource(ds.Tables["Sale"]); rpt.crv.ViewerCore.ReportSource = saleRPT; Mouse.OverrideCursor = null; } _currentWindow.Hide(); rpt.ShowDialog(); _currentWindow.ShowDialog(); }
public void Print(object pp) { string type = ""; if (LableType == "Lable16") { type = "L16"; } else if (LableType == "Lable24") { type = "L24"; } else if (LableType == "Lable18") { type = "L18"; } //PrintWindow _print = new PrintWindow(new ObservableCollection<object>(ListOfGroupD)); //_print.ShowDialog(); if (NoLangthVis == "Visible") { if (string.IsNullOrEmpty(LableType)) { CustomDialogBox tempDB = new CustomDialogBox("Enter Lable.", DialogType.Information); tempDB.ShowDialog(); } else if (string.IsNullOrEmpty(NoOfLable)) { CustomDialogBox tempDB = new CustomDialogBox("Enter LabelNo.", DialogType.Information); tempDB.ShowDialog(); } else if (string.IsNullOrEmpty(TextAlign)) { CustomDialogBox tempDB = new CustomDialogBox("Select TextAlign.", DialogType.Information); tempDB.ShowDialog(); } else { GroupDetail _GRoupDetail = new GroupDetail(); ReportWindow _ReportWindow = new ReportWindow(PrintGD, ListOfGridSC, NoOfLable, type, TextAlign, FontStyle, FontWeight, Font); _ReportWindow.ShowDialog(); } } else { if (ListOfGroupD.Where(a => a.IsCheck == true).Count() > 0) { if (string.IsNullOrEmpty(LableType)) { CustomDialogBox tempDB = new CustomDialogBox("Enter Lable.", DialogType.Information); tempDB.ShowDialog(); } else if (string.IsNullOrEmpty(TextAlign)) { CustomDialogBox tempDB = new CustomDialogBox("Select TextAlign.", DialogType.Information); tempDB.ShowDialog(); } else { ObservableCollection <GroupDetail> _GD = new ObservableCollection <GroupDetail>(ListOfGroupD.Where(w => w.IsCheck == true).ToList()); foreach (GroupDetail item in _GD) { item.Lable5 = item.Lable5; } ReportWindow _ReportWindow = new ReportWindow(ListOfGridSC, _GD, type, TextAlign, FontStyle, FontWeight, Font); _ReportWindow.ShowDialog(); } } else { CustomDialogBox tempDB = new CustomDialogBox("No Date Found.", DialogType.Information); tempDB.ShowDialog(); } } }
private void ExecuteSave() { Mouse.OverrideCursor = Cursors.Wait; DateTime _dt = DateTime.Now; _newSale.RegistrationDate = _dt; _saleServ.AddSale(_newSale); int _saleID = _saleServ.GetLastSaleID(); foreach (var item in _saleCategories) { SaleCategory _saleCategory = new SaleCategory { CategoryID = item.CategoryID, Cost = item.Cost, PriceAfterDiscount = item.PriceAfterDiscount, PriceTotalAfterDiscount = item.PriceTotalAfterDiscount, CostTotal = item.CostTotal, Price = item.Price, PriceTotal = item.PriceTotal, Discount = item.Discount, DiscountValue = item.DiscountValue, DiscountValueTotal = item.DiscountValueTotal, SaleID = _saleID, Qty = item.Qty }; _saleCategoryServ.AddSaleCategory(_saleCategory); Category cat = _categoryServ.GetCategory(item.CategoryID); cat.Qty = cat.Qty - item.Qty; _categoryServ.UpdateCategory(cat); } ClientAccount _account = new ClientAccount { ClientID = _newSale.ClientID, Date = _newSale.Date, RegistrationDate = _dt, Statement = "فاتورة مبيعات رقم " + _saleID, Credit = _newSale.Paid, Debit = _newSale.PriceAfterDiscount + _newSale.TransportCost }; _clientAccountServ.AddAccount(_account); if (_newSale.Paid > 0) { Safe _safe = new Safe { Date = _newSale.Date, RegistrationDate = _dt, Statement = "فاتورة مبيعات رقم " + _saleID + " للعميل: " + _selectedClient.Name, Amount = _newSale.Paid, Source = 4 }; _safeServ.AddSafe(_safe); } DS ds = new DS(); ds.Sale.Rows.Clear(); int i = 0; foreach (var item in _saleCategories) { ds.Sale.Rows.Add(); ds.Sale[i]["ID"] = _saleID; ds.Sale[i]["Date"] = _newSale.Date; ds.Sale[i]["Client"] = _selectedClient.Name; ds.Sale[i]["Serial"] = i + 1; ds.Sale[i]["Category"] = item.Category + " " + item.Company; ds.Sale[i]["Qty"] = item.Qty; ds.Sale[i]["Price"] = Math.Round(Convert.ToDecimal(item.PriceAfterDiscount), 2); ds.Sale[i]["TotalPrice"] = Math.Round(Convert.ToDecimal(item.PriceTotalAfterDiscount), 2); ds.Sale[i]["BillPrice"] = Math.Round(Convert.ToDecimal(_newSale.PriceAfterDiscount), 2);; ds.Sale[i]["OldDebt"] = Math.Abs(Convert.ToDecimal(_newSale.OldDebt)); ds.Sale[i]["TransportCost"] = _newSale.TransportCost; ds.Sale[i]["BillTotal"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSale.PriceTotal), 2)); ds.Sale[i]["Paid"] = _newSale.Paid; ds.Sale[i]["NewDebt"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSale.NewDebt), 2)); if (_newSale.NewDebt > 0) { ds.Sale[i]["Type"] = "له"; } else if (_newSale.NewDebt < 0) { ds.Sale[i]["Type"] = "عليه"; } ds.Sale[i]["Salesperson"] = _selectedSalesperson.Name; ds.Sale[i]["PrintingMan"] = _newSale.PrintingMan; if (_newSale.OldDebt > 0) { ds.Sale[i]["Type2"] = "له"; } else if (_newSale.OldDebt < 0) { ds.Sale[i]["Type2"] = "عليه"; } ds.Sale[i]["Address"] = _selectedClient.Address; try { ToWord toWord = new ToWord(Math.Abs(Convert.ToDecimal(_newSale.NewDebt)), currencies[0]); ds.Sale[i]["NewDebtAR"] = toWord.ConvertToArabic(); } catch { ds.Sale[i]["NewDebtAR"] = string.Empty; } i++; } ReportWindow rpt = new ReportWindow(); SaleReport saleRPT = new SaleReport(); saleRPT.SetDataSource(ds.Tables["Sale"]); rpt.crv.ViewerCore.ReportSource = saleRPT; Mouse.OverrideCursor = null; _currentWindow.Hide(); rpt.ShowDialog(); NewSale = new Sale(); NewSaleCategory = new SaleCategoryVM(); SaleCategories = new ObservableCollection <SaleCategoryVM>(); NewSale.Date = DateTime.Now; OldPrices = new ObservableCollection <SaleCategory>(); _currentWindow.ShowDialog(); }
private void OverigeRapporten_Click(object sender, RoutedEventArgs e) { ReportWindow repVal = new ReportWindow(mijnenOverzicht); repVal.ShowDialog(); }
private async void ExecuteSaveAsync() { if (NewSupply.Future == true && NewSupplyFuture.Place == null) { await _currentWindow.ShowMessageAsync("فشل الإضافة", "يجب كتابة مكان الدفع", MessageDialogStyle.Affirmative, new MetroDialogSettings() { AffirmativeButtonText = "موافق", DialogMessageFontSize = 25, DialogTitleFontSize = 30 }); return; } Mouse.OverrideCursor = Cursors.Wait; DateTime _dt = DateTime.Now; _newSupply.RegistrationDate = _dt; _supplyServ.AddSupply(_newSupply); int _supplyID = _supplyServ.GetLastSupplyID(); foreach (var item in _supplyCategories) { SupplyCategory _supplyCategory = new SupplyCategory { CategoryID = item.CategoryID, Cost = item.Cost, CostAfterDiscount = item.CostAfterDiscount, CostAfterTax = item.CostAfterTax, CostTotal = item.CostTotal, CostTotalAfterDiscount = item.CostTotalAfterDiscount, CostTotalAfterTax = item.CostTotalAfterTax, Discount = item.Discount, DiscountValue = item.DiscountValue, DiscountValueTotal = item.DiscountValueTotal, SupplyID = _supplyID, Qty = item.Qty, Tax = item.Tax, TaxValue = item.TaxValue, TaxValueTotal = item.TaxValueTotal, Price = item.Price }; _supplyCategoryServ.AddSupplyCategory(_supplyCategory); Category cat = _categoryServ.GetCategory(item.CategoryID); if (cat.Qty + item.Qty != 0) { cat.Cost = (item.CostTotalAfterDiscount + (cat.Cost * cat.Qty)) / (cat.Qty + item.Qty); } cat.Qty = cat.Qty + item.Qty; cat.Price = item.Price; _categoryServ.UpdateCategory(cat); } if (_newSupply.Future == true) { _newSupplyFuture.Change = _newSupply.Change; _newSupplyFuture.SupplyID = _supplyID; if (_newSupplyFuture.Cheque == false) { _newSupplyFuture.ChequeNumber = null; } _supplyFutureServ.AddSupplyFuture(_newSupplyFuture); _placesSuggestions.Add(_newSupplyFuture.Place); } ClientAccount _account = new ClientAccount { ClientID = _newSupply.ClientID, Date = _newSupply.Date, RegistrationDate = _dt, Statement = "فاتورة مشتريات رقم " + _supplyID, Credit = _newSupply.CostAfterTax, Debit = _newSupply.CashPaid }; _clientAccountServ.AddAccount(_account); if (_newSupply.DiscountPaid != 0 || _newSupply.TotalDiscount != 0) { _account = new ClientAccount { ClientID = _newSupply.ClientID, Date = _newSupply.Date, RegistrationDate = _dt, Statement = "خصومات فاتورة مشتريات رقم " + _supplyID, Credit = _newSupply.DiscountPaid, Debit = _newSupply.TotalDiscount }; _clientAccountServ.AddAccount(_account); } if (_newSupply.CashPaid > 0) { Safe _safe = new Safe { Date = _newSupply.Date, RegistrationDate = _dt, Statement = "فاتورة مشتريات رقم " + _supplyID + " من العميل : " + _selectedClient.Name, Amount = -_newSupply.CashPaid, Source = 3 }; _safeServ.AddSafe(_safe); } DS ds = new DS(); ds.Sale.Rows.Clear(); int i = 0; foreach (var item in _supplyCategories) { ds.Sale.Rows.Add(); ds.Sale[i]["ID"] = _supplyID; ds.Sale[i]["Date"] = _newSupply.Date; ds.Sale[i]["Client"] = _selectedClient.Name; ds.Sale[i]["Serial"] = i + 1; ds.Sale[i]["Category"] = item.Category + " " + item.Company; ds.Sale[i]["Qty"] = item.Qty; ds.Sale[i]["Price"] = Math.Round(Convert.ToDecimal(item.CostAfterTax), 2); ds.Sale[i]["TotalPrice"] = Math.Round(Convert.ToDecimal(item.CostTotalAfterTax), 2); ds.Sale[i]["BillPrice"] = Math.Round(Convert.ToDecimal(_newSupply.CostAfterTax), 2); ds.Sale[i]["OldDebt"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSupply.OldDebt), 2)); ds.Sale[i]["Paid"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSupply.CashPaid + _newSupply.DiscountPaid), 2)); ds.Sale[i]["NewDebt"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSupply.NewDebt), 2)); if (_newSupply.NewDebt > 0) { ds.Sale[i]["PrintingMan"] = "له"; } else if (_newSupply.NewDebt < 0) { ds.Sale[i]["PrintingMan"] = "عليه"; } if (_newSupply.OldDebt > 0) { ds.Sale[i]["Type"] = "له"; } else if (_newSupply.OldDebt < 0) { ds.Sale[i]["Type"] = "عليه"; } ds.Sale[i]["BillTotal"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSupply.OldDebt), 2) + Math.Round(Convert.ToDecimal(_newSupply.CostAfterTax), 2)); if (Math.Round(Convert.ToDecimal(_newSupply.OldDebt), 2) + Math.Round(Convert.ToDecimal(_newSupply.CostAfterTax), 2) > 0) { ds.Sale[i]["Type2"] = "له"; } else if (Math.Round(Convert.ToDecimal(_newSupply.OldDebt), 2) + Math.Round(Convert.ToDecimal(_newSupply.CostAfterTax), 2) < 0) { ds.Sale[i]["Type2"] = "عليه"; } i++; } ReportWindow rpt = new ReportWindow(); SupplyReport supplyRPT = new SupplyReport(); supplyRPT.SetDataSource(ds.Tables["Sale"]); rpt.crv.ViewerCore.ReportSource = supplyRPT; Mouse.OverrideCursor = null; _currentWindow.Hide(); rpt.ShowDialog(); NewSupply = new Supply(); NewSupplyCategory = new SupplyCategoryVM(); NewSupplyFuture = new SupplyFuture(); SupplyCategories = new ObservableCollection <SupplyCategoryVM>(); NewSupply.Date = DateTime.Now; NewSupplyFuture.Date = DateTime.Now; OldCosts = new ObservableCollection <SupplyCategory>(); _currentWindow.ShowDialog(); }
private void ExecuteSave(string parameter) { try { Mouse.OverrideCursor = Cursors.Wait; DateTime _dt = DateTime.Now; _newSale.RegistrationDate = _dt; _saleServ.AddSale(_newSale); int _saleID = _saleServ.GetLastSaleID(); foreach (var item in _saleCategories) { SaleCategory _saleCategory = new SaleCategory { CategoryID = item.CategoryID, Cost = item.Cost, CostTotal = item.CostTotal, Price = item.Price, PriceTotal = item.PriceTotal, SaleID = _saleID, Qty = item.Qty }; _saleCategoryServ.AddSaleCategory(_saleCategory); Category cat = _categoryServ.GetCategory(item.CategoryID); cat.Qty = cat.Qty - item.Qty; _categoryServ.UpdateCategory(cat); } ClientAccount _account = new ClientAccount { ClientID = _newSale.ClientID, Date = _newSale.Date, RegistrationDate = _dt, Statement = "فاتورة مبيعات رقم " + _saleID, Credit = _newSale.CashPaid + _newSale.DiscountPaid, Debit = _newSale.Price }; _clientAccountServ.AddAccount(_account); if (_newSale.CashPaid > 0) { Safe _safe = new Safe { Date = _newSale.Date, RegistrationDate = _dt, Statement = "فاتورة مبيعات رقم " + _saleID + " للعميل: " + _selectedClient.Name, Amount = _newSale.CashPaid, Source = 4 }; _safeServ.AddSafe(_safe); } DS ds = new DS(); ds.Sale.Rows.Clear(); int i = 0; foreach (var item in _saleCategories) { ds.Sale.Rows.Add(); ds.Sale[i]["ID"] = _saleID; ds.Sale[i]["Date"] = _newSale.Date; ds.Sale[i]["Client"] = _selectedClient.Name; ds.Sale[i]["Serial"] = i + 1; ds.Sale[i]["Category"] = item.Category + " " + item.Company; ds.Sale[i]["Qty"] = item.Qty; ds.Sale[i]["Price"] = Math.Round(Convert.ToDecimal(item.Price), 2); ds.Sale[i]["TotalPrice"] = Math.Round(Convert.ToDecimal(item.PriceTotal), 2); ds.Sale[i]["BillPrice"] = Math.Round(Convert.ToDecimal(_newSale.Price), 2);; ds.Sale[i]["OldDebt"] = Math.Abs(Convert.ToDecimal(_newSale.OldDebt)); ds.Sale[i]["BillTotal"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSale.PriceTotal), 2)); ds.Sale[i]["Paid"] = _newSale.CashPaid; ds.Sale[i]["DiscountPaid"] = _newSale.DiscountPaid; ds.Sale[i]["NewDebt"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSale.NewDebt), 2)); if (_newSale.NewDebt > 0) { ds.Sale[i]["Type"] = "له"; } else if (_newSale.NewDebt < 0) { ds.Sale[i]["Type"] = "عليه"; } if (_newSale.OldDebt > 0) { ds.Sale[i]["Type2"] = "له"; } else if (_newSale.OldDebt < 0) { ds.Sale[i]["Type2"] = "عليه"; } i++; } ReportWindow rpt = new ReportWindow(); if (parameter == "Client") { SaleReport saleRPT = new SaleReport(); saleRPT.SetDataSource(ds.Tables["Sale"]); rpt.crv.ViewerCore.ReportSource = saleRPT; Mouse.OverrideCursor = null; } else { SaleReport2 saleRPT = new SaleReport2(); saleRPT.SetDataSource(ds.Tables["Sale"]); rpt.crv.ViewerCore.ReportSource = saleRPT; Mouse.OverrideCursor = null; } _currentWindow.Hide(); rpt.ShowDialog(); NewSale = new Sale(); NewSaleCategory = new SaleCategoryVM(); SaleCategories = new ObservableCollection <SaleCategoryVM>(); NewSale.Date = DateTime.Now; OldPrices = new ObservableCollection <SaleCategory>(); _currentWindow.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public void OpenReportWindow(Window w) { ReportWindow window = new ReportWindow(); window.ShowDialog(); }