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ı");
}
