private void BtRowDelPro_Click(object sender, EventArgs e)
{
var pro = HelperProduct.GetProduct(proID);
if (pro != null)
{
var result = MessageBox.Show("Bu işlem geri alınamaz. Yine de silinsin mi?", "SİL?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
r = Helper.CRUD(null, null, pro, null, null, EntityState.Deleted, "product");
if (r.isSuccess)
{
DisplayProducts();
DisplayOrders();
lblWarningPro.Visible = true;
lblWarningPro.Text = "Ürün silindi!";
}
else
{
lblWarningPro.Visible = true;
lblWarningPro.Text = r.Message;
}
}
}
}
private void BtEditPro_Click(object sender, EventArgs e)
{
var pro = HelperProduct.GetProduct(proID);
int previousCateID = Convert.ToInt32(pro.cateID);
if (pro != null)
{
int c = 0;
if (!Helper.I(tbProName1.Text))
{
pro.proName = tbProName1.Text; c++;
}
if (!Helper.I(tbPrePrice1.Text))
{
pro.prePrice = Convert.ToDouble(tbPrePrice1.Text); c++;
}
if (!Helper.I(tbSalePrice1.Text))
{
pro.salePrice = Convert.ToDouble(tbSalePrice1.Text); c++;
}
if (!Helper.I(tbStock1.Text))
{
pro.quantity = Convert.ToInt32(tbStock1.Text); c++;
}
pro.cateID = Convert.ToInt32(cbCategory1.SelectedValue);
if (previousCateID != pro.cateID)
{
c++;
}
r = Helper.CRUD(null, null, pro, null, null, EntityState.Modified, "product");
if (r.isSuccess)
{
tbProName1.Clear(); cbCategory1.SelectedIndex = 0;
tbPrePrice1.Clear(); tbSalePrice1.Clear(); tbStock1.Clear();
DisplayProducts();
DisplayOrders();
if (c != 0)
{
lblWarningPro.Visible = true;
lblWarningPro.Text = "Ürün bilgileri düzenlendi!";
}
}
else
{
lblWarningPro.Visible = true;
lblWarningPro.Text = r.Message;
}
}
gbEditPro.Enabled = false;
}
private void BtCompleteOrder_Click(object sender, EventArgs e)
{
bool result = Helper.I(tbQuantity.Text);
if (result)
{
MessageBox.Show("Adet bilgisini giriniz!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
int custID = HelperCustomer.GetCustomerID(cbCustomers.GetItemText(cbCustomers.SelectedItem));
var pro = HelperProduct.GetProduct(sellProID);
if (pro != null)
{
if (pro.quantity < Convert.ToInt32(tbQuantity.Text))
{
if (pro.quantity == 0)
{
MessageBox.Show("Bu ürün tükenmiştir!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show($"Bu üründen stokta {pro.quantity} adet kaldı!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
Orders ord = new Orders {
piece = Convert.ToInt32(tbQuantity.Text),
orderDate = DateTime.Now.Date,
productID = sellProID,
customerID = custID
};
r = Helper.CRUD(null, null, null, ord, null, EntityState.Added, "order");
if (r.isSuccess)
{
pro.quantity -= Convert.ToInt32(tbQuantity.Text);
rr = Helper.CRUD(null, null, pro, null, null, EntityState.Modified, "product");
}
tbQuantity.Clear();
DisplayProducts();
DisplayOrders();
}
}
}
}
void SubDisplayOrders(List <OrderModel> list)
{
foreach (var item in list)
{
string ctName = HelperCate.GetCate(Convert.ToInt32(HelperProduct.GetProduct(Convert.ToInt32(item.Products.productID)).cateID)).cateName;
dgvOrders.Rows.Add(item.Customers.cFirstName + " " + item.Customers.cLastName,
ctName, item.Products.proName, item.piece, item.Products.salePrice,
Convert.ToDateTime(item.orderDate).ToShortDateString());
profit += (Convert.ToDouble(item.Products.salePrice) - Convert.ToDouble(item.Products.prePrice));
}
lblProfit.Text = profit.ToString();
}
private void DgvSellPro_CellClick(object sender, DataGridViewCellEventArgs e)
{
gbSellPro.Visible = true;
string sellProName = null, sellProPrice = null, sellProExp = null;
if (dgvSellPro.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
dgvSellPro.CurrentRow.Selected = true;
sellProName = dgvSellPro.Rows[e.RowIndex].Cells["sellProName"].FormattedValue.ToString();
sellProPrice = dgvSellPro.Rows[e.RowIndex].Cells["sellProPrice"].FormattedValue.ToString();
sellProExp = dgvSellPro.Rows[e.RowIndex].Cells["sellProExp"].FormattedValue.ToString();
}
sellProID = HelperProduct.GetProductID(sellProName, Convert.ToDouble(sellProPrice), sellProExp);
tbSelectedPro.Text = HelperProduct.GetProduct(sellProID).proName;
}
private void DgvProducts_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (command == "updProduct")
{
int proID = 0;
if (dgvProducts.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
dgvProducts.CurrentRow.Selected = true;
proID = Convert.ToInt32(dgvProducts.Rows[e.RowIndex].Cells["productID"].FormattedValue.ToString());
}
var pro = HelperProduct.GetProduct(proID);
if (pro != null)
{
FormUpdatePro f = new FormUpdatePro(pro);
f.Show();
this.Hide();
}
}
else if (command == "delProduct")
{
int proID = 0;
if (dgvProducts.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
dgvProducts.CurrentRow.Selected = true;
proID = Convert.ToInt32(dgvProducts.Rows[e.RowIndex].Cells["productID"].FormattedValue.ToString());
}
var pro = HelperProduct.GetProduct(proID);
if (pro != null)
{
if (HelperOrderDet.SoldProductsList().Contains(proID))
{
MessageBox.Show("Bu ürün daha önce satıldığı için listeden çıkaramazsınız!");
}
else
{
var result = HelperProduct.CUD(pro, EntityState.Deleted);
MessageBox.Show(result == true ? "Ürün başarıyla silindi!" : "HATA!");
}
}
}
}
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);
}
}
}
