private void OdeButtonClicked(object sender, EventArgs e) { var context = new MarketDBContext(); if (PaymentAmountText.Text != "") { CustomerDebt cd = context.CustomerDebts.Find(this.SelectedCustomerIDNumber); if (double.Parse(PaymentAmountText.Text) <= cd.DebtAmount) { double InputPaymentAmount = double.Parse(PaymentAmountText.Text); Payment cp = new Payment(this.SelectedCustomerIDNumber, 0, InputPaymentAmount, DateTime.Now); context.Payments.Add(cp); CustomerDebt tcd = context.CustomerDebts.Find(this.SelectedCustomerIDNumber); tcd.DebtAmount -= InputPaymentAmount; context.SaveChanges(); RefreshList(PaymentList); RefreshSum(SumLabel); PaymentAmountText.Text = String.Empty; } else { MessageBox.Show("Mevcut borçtan fazla girdiniz!"); } } }
private void searchCustomer_TextChanged_1(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { try { int customer = Convert.ToInt32(searchCustomer.Text); CustomerDebt customerDebt = CustomerDebt.getCDebt(customer); DebitSale debitSale = DebitSale.getDebitSale(customer); if (customer == null) { MessageBox.Show("The debt information of the customer entered was not found!", "ERROR"); } else { List <DebitSale> debtSoldProducts = DebitSale.getallDSale(); if (debtSoldProducts != null) { foreach (DebitSale s in debtSoldProducts) { Object[] SoldProducts_debt = { s.customer_no, s.product_no, s.CustomerDebt.debt_amount, s.sale_date, s.sale_no, s.payment_method, }; table.Rows.Add(SoldProducts_debt); } } } } catch (Exception EX) { MessageBox.Show(EX.Message, "ERROR"); } } }
public void RefreshSum(Label label) { var context = new MarketDBContext(); CustomerDebt da = context.CustomerDebts.Find(this.SelectedCustomerIDNumber); double sum = da.DebtAmount; // Set content of the label to sum SumLabel.Content = sum.ToString(); }
public List <CustomerDebt> GetListCustomerDebt() { List <CustomerDebt> list = new List <CustomerDebt>(); string query = "select * from CustomerDebt"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { CustomerDebt customerDebt = new CustomerDebt(item); list.Add(customerDebt); } return(list); }
public List <CustomerDebt> SearchCustomerDebtByName(string name) { List <CustomerDebt> list = new List <CustomerDebt>(); string query = string.Format("select * from CustomerDebt where dbo.fuConvertToUnsign1(name) like N'%' + dbo.fuConvertToUnsign1(N'{0}') + '%'", name); DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { CustomerDebt customerDebt = new CustomerDebt(item); list.Add(customerDebt); } return(list); }
private void TamamlaButtonClicked(object sender, RoutedEventArgs e) { if (ItemList.Items.IsEmpty) { MessageBox.Show("Liste boş"); return; } var context = new MarketDBContext(); long CustomerIDNumber = this.SelectedCustomerIDNumber; Sale sale = new Sale(DateTime.Now); // If there is a selected Customer (This means that we will continue with the "Cari" sale) // Else continue with the "Peşin" sale if (CustomerIDNumber != 0) { sale.CustomerIDNumber = CustomerIDNumber; } // Since ID is generated automatically we save sale to the database and then get its ID context.Sales.Add(sale); context.SaveChanges(); var query = context.CustomerDebts.Where(i => i.CustomerIDNumber == CustomerIDNumber); if (query.Count() != 0) { CustomerDebt cstdebt = query.First(); double sum = 0.0; // Loop through each item in the list for (int i = 0; i < ItemList.Items.Count; i++) { ProductItem pi = (ProductItem)ItemList.Items.GetItemAt(i); sum += (pi.Amount * pi.Price); } cstdebt.DebtAmount += sum; } else { double sum = 0.0; // Loop through each item in the list for (int i = 0; i < ItemList.Items.Count; i++) { ProductItem pi = (ProductItem)ItemList.Items.GetItemAt(i); sum += (pi.Amount * pi.Price); } CustomerDebt cstdebt = new CustomerDebt(CustomerIDNumber, sum); context.CustomerDebts.Add(cstdebt); } context.SaveChanges(); // Use the newly created sale's id Sale s = (Sale)context.Sales.Find(sale.ID); // For each product in the listview for (int i = 0; i < ItemList.Items.Count; i++) { //Create a Product-Sale duo and save them to the database ProductItem pi = (ProductItem)ItemList.Items.GetItemAt(i); ProductSale ps = new ProductSale(pi.ID, s.ID, pi.Amount); context.ProductSales.Add(ps); //Decrease the product amount in stock Stock stock = context.Stocks.Find(pi.Barcode); stock.Amount -= pi.Amount; } context.SaveChanges(); // Clear the list after sale is complete ItemList.Items.Clear(); RefreshSum(); MessageBox.Show("Satış tamamlandı"); }