private void DgvCustomers_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (command == "delCustomer")
{
int cusID = 0;
if (dgvCustomers.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
dgvCustomers.CurrentRow.Selected = true;
cusID = Convert.ToInt32(dgvCustomers.Rows[e.RowIndex].Cells["customerID"].FormattedValue.ToString());
}
var cus = HelperCustomer.GetCustomer(cusID);
var sign = HelperSignin.GetUserCus(cus.Signin.signinID);
if (cus != null)
{
if (HelperOrder.ActiveCustomersList().Contains(cusID))
{
MessageBox.Show("Bu müşteri daha önce satın alım yaptığı için sistemden çıkaramazsınız!");
}
else
{
cus.Signin.signinID = 0;
HelperCustomer.CUD(cus, EntityState.Modified);
var result1 = HelperCustomer.CUD(cus, EntityState.Deleted);
var result2 = HelperSignin.CUD(sign, EntityState.Deleted);
MessageBox.Show(result1 == true && result2 == true ? "Müşteri başarıyla sistemden çıkarıldı!" : "HATA!");
}
}
}
else if (command == "maintenance")
{
MessageBox.Show("Sistemin bakımda olması sebebiyle bu işlem geçici bir süreliğine askıya alınmıştır!");
}
}
public static ResultSet CRUD(Customers cus, Cate cate, Products pro, Orders ord, Signin sign, EntityState state, string table)
{
ResultSet r = new ResultSet();
try {
switch (table)
{
case "customer": r = HelperCustomer.CRUD(cus, state); break;
case "category": r = HelperCate.CRUD(cate, state); break;
case "product": r = HelperProduct.CRUD(pro, state); break;
case "order": r = HelperOrder.CRUD(ord, state); break;
case "signin": r = HelperSignin.CRUD(sign, state); break;
default: break;
}
if (r.Message != null)
{
MessageBox.Show(r.Message, "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
return(r);
}
catch (Exception e) {
r.Message = e.Message;
}
return(r);
}
void DisplayOrders(string section, string query, DateTime firstDate, DateTime lastDate)
{
profit = 0; dgvOrders.Rows.Clear();
List <OrderModel> list = new List <OrderModel>();
List <OrderModel> list2 = new List <OrderModel>();
if (section == "customer")
{
list = HelperOrder.GetOrderModelCusList(query);
}
else if (section == "product")
{
list = HelperOrder.GetOrderModelProList(query);
}
else if (section == "category")
{
list = HelperOrder.GetOrderModelCateList(query);
}
else
{
list = HelperOrder.GetOrderModelList();
}
foreach (var item in list)
{
if (Convert.ToDateTime(item.orderDate).Ticks >= firstDate.Ticks &&
Convert.ToDateTime(item.orderDate).Ticks <= lastDate.Ticks)
{
list2.Add(item);
}
}
SubDisplayOrders(list2);
}
private void FormPayment_Load(object sender, EventArgs e)
{
var list = HelperOrder.GetOrderModelList(cusID, status);
foreach (var item in list)
{
dgvOrder.Rows.Add(item.orderID, Convert.ToDateTime(item.orderDate).ToShortDateString(), item.orderStatus, item.amount);
}
}
private bool FinishOrder()
{
var ord = HelperOrder.GetOrder(HelperOrder.GetOrderList().Count);
if (ord != null)
{
ord.orderStatus = "Tamamlanmış";
var result = HelperOrder.CUD(ord, EntityState.Modified);
if (result)
{
openOrder = false;
return(true);
}
return(false);
}
return(false);
}
private void BtPay_Click(object sender, EventArgs e)
{
var control1 = HelperOrder.GetOrder(ordID).amount - HelperPayment.GetAmountPayed(ordID) - Convert.ToDouble(tbPay.Text);
var control2 = HelperCustomer.GetCustomer(cusID).creditLimit - Convert.ToDouble(tbPay.Text);
if (control1 < 0 || control2 < 0)
{
if (control1 < 0)
{
MessageBox.Show("Lütfen borcunuza eşit veya daha düşük bir miktar giriniz!");
}
else
{
MessageBox.Show("Bakiyeniz bu işlem için yetersizdir!");
}
}
else
{
Payment p = new Payment {
paymentDate = DateTime.Now.Date,
amountPayed = Convert.ToInt32(tbPay.Text),
customerID = cusID,
orderID = ordID
};
HelperPayment.CUD(p, EntityState.Added);
var cus = HelperCustomer.GetCustomer(cusID);
if (cus != null)
{
cus.creditLimit -= p.amountPayed;
HelperCustomer.CUD(cus, EntityState.Modified);
}
var debt = HelperOrder.GetOrder(ordID).amount - HelperPayment.GetAmountPayed(ordID);
dgvPayment.Rows.Add(p.paymentID, Convert.ToDateTime(p.paymentDate).ToShortDateString(), p.amountPayed);
lblDebt.Text = $"Bu siparişe ait kalan borç: {debt}";
lblCredit.Visible = true;
lblCredit.Text = $"Kalan bakiyeniz: {cus.creditLimit}";
if (debt == 0)
{
MessageBox.Show("Bu siparişe ait borcunuzun tamamını ödediniz!");
}
}
}
void DisplayOrders(DateTime firstDate, DateTime lastDate)
{
profit = 0; dgvOrders.Rows.Clear();
List <OrderModel> list = new List <OrderModel>();
List <OrderModel> list2 = new List <OrderModel>();
list = HelperOrder.GetOrderModelList();
foreach (var item in list)
{
if (Convert.ToDateTime(item.orderDate).Ticks >= firstDate.Ticks &&
Convert.ToDateTime(item.orderDate).Ticks <= lastDate.Ticks)
{
list2.Add(item);
}
}
SubDisplayOrders(list2);
}
private void DgvOrder_CellClick(object sender, DataGridViewCellEventArgs e)
{
dgvPayment.Rows.Clear();
if (dgvOrder.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
dgvOrder.CurrentRow.Selected = true;
ordID = Convert.ToInt32(dgvOrder.Rows[e.RowIndex].Cells["orderID"].FormattedValue.ToString());
}
var list = HelperPayment.GetPaymentList(ordID);
foreach (var p in list)
{
dgvPayment.Rows.Add(p.paymentID, Convert.ToDateTime(p.paymentDate).ToShortDateString(), p.amountPayed);
}
var debt = HelperOrder.GetOrder(ordID).amount - HelperPayment.GetAmountPayed(ordID);
lblDebt.Visible = true;
lblDebt.Text = $"Bu siparişe ait kalan borç: {debt}";
}
private void BtAddToBasket_Click(object sender, EventArgs e)
{
int empID = Convert.ToInt32(cBoxEmployee.SelectedValue);
int proID = Convert.ToInt32(cBoxProduct.SelectedValue);
var pro = HelperProduct.GetProduct(proID);
if (pro != null)
{
if (!Helper.isNumber(tbQuantity.Text) || Convert.ToInt32(tbQuantity.Text) <= 0)
{
btAddToBasket.Enabled = false;
MessageBox.Show("Hatalı giriş yaptınız!");
}
else if (pro.quantity < Convert.ToInt32(tbQuantity.Text))
{
if (pro.quantity == 0)
{
MessageBox.Show("Bu ürün tükenmiştir!");
}
else
{
MessageBox.Show($"Bu üründen stokta {pro.quantity} adet kaldı!");
}
}
else
{
if (!openOrder)
{
Orders ord = new Orders {
orderDate = DateTime.Now.Date,
orderStatus = "Açık",
amount = 0,
customerID = cusID
};
var result1 = HelperOrder.CUD(ord, EntityState.Added);
if (result1)
{
openOrder = true;
OrderDetails ordDet = new OrderDetails {
productID = proID,
priceEach = HelperProduct.GetProduct(proID).proPrice,
quantityOrdered = Convert.ToInt32(tbQuantity.Text),
orderID = ord.orderID,
employeeID = empID
};
var result2 = HelperOrderDet.CUD(ordDet, EntityState.Added);
if (result2)
{
btFinishOrder.Enabled = true;
MessageBox.Show("Ürün sepete eklendi!");
ord.amount += ordDet.priceEach * ordDet.quantityOrdered;
HelperOrder.CUD(ord, EntityState.Modified);
}
else
{
MessageBox.Show("HATA!");
}
}
}
else
{
OrderDetails ordDet = new OrderDetails {
productID = proID,
priceEach = pro.proPrice,
quantityOrdered = Convert.ToInt32(tbQuantity.Text),
orderID = HelperOrder.GetOrderList().Count,
employeeID = empID
};
var ord = HelperOrder.GetOrder(Convert.ToInt32(ordDet.orderID));
var result = HelperOrderDet.CUD(ordDet, EntityState.Added);
if (result)
{
btFinishOrder.Enabled = true;
MessageBox.Show("Ürün sepete eklendi!");
ord.amount += ordDet.priceEach * ordDet.quantityOrdered;
HelperOrder.CUD(ord, EntityState.Modified);
}
else
{
MessageBox.Show("HATA!");
}
}
pro.quantity -= Convert.ToInt32(tbQuantity.Text);
HelperProduct.CUD(pro, EntityState.Modified);
}
}
}
private void FormDisplaySold_Load(object sender, EventArgs e)
{
var list = HelperOrderDet.GetOrderDetbyEmpModelList(empID);
foreach (var item in list)
{
dgvSoldProducts.Rows.Add(item.Products.productID, item.Products.proName, item.priceEach, item.quantityOrdered, HelperOrder.GetCusFullNameByOrderId(item.Orders.orderID));
}
}
private void button2_Click(object sender, EventArgs e)
{
//Satışı tamamla butonu
//toplam tutar hesapla
int totalPrice = 0;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
totalPrice += Convert.ToInt32(dataGridView1.Rows[i].Cells[5].Value);
}
label1.Text = totalPrice.ToString();
Cashier cashier = HelperCashier.GetByName(label3.Text);
customer = HelperCustomer.GetByID(customer.CustomerID);
Order or = new Order()
{
customerID = customer.CustomerID,
orderDate = DateTime.Now,
cashierID = cashier.cashierID,
totalPrice = Convert.ToInt32(label1.Text),
};
var ekle = HelperOrder.CUD(or, System.Data.Entity.EntityState.Added);
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
p.Add(HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value)));
}
int k = 0;
foreach (var item in p)
{
for (; k < dataGridView1.Rows.Count;)
{
item.stock -= Convert.ToInt32(dataGridView1.Rows[k].Cells[4].Value);
var a = HelperProduct.CUD(item, System.Data.Entity.EntityState.Modified);
break;
}
k++;
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
//fiş için yapılanlar
List <string> temp = new List <string>();
string ad = dataGridView1.Rows[i].Cells[0].Value.ToString();
string id = dataGridView1.Rows[i].Cells[1].Value.ToString();
string birimFiyat = dataGridView1.Rows[i].Cells[2].Value.ToString();
string indirim = dataGridView1.Rows[i].Cells[3].Value.ToString();
string adet = dataGridView1.Rows[i].Cells[4].Value.ToString();
string tutar = dataGridView1.Rows[i].Cells[5].Value.ToString();
temp.Add(ad);
temp.Add(id);
temp.Add(birimFiyat);
temp.Add(indirim);
temp.Add(adet);
temp.Add(tutar);
receipt.Add(temp);
}
foreach (var item in p)
{
ord = new OrderDetail();
ord.orderID = or.orderID;
ord.productID = item.productID;
ord.unitPrice = item.unitPrice;
for (; j < dataGridView1.Rows.Count; j++)
{
ord.count = Convert.ToInt32(dataGridView1.Rows[j].Cells[4].Value);
break;
}
j++;
var ekle2 = HelperOrderDetail.CUD(ord, System.Data.Entity.EntityState.Added);
}
ReceiptForm rpf = new ReceiptForm(receipt, customer, label1.Text);
rpf.Show();
this.Hide();
}
void DisplayOrders()
{
profit = 0; dgvOrders.Rows.Clear();
SubDisplayOrders(HelperOrder.GetOrderModelList());
}
