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 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 DgvOrder_CellClick(object sender, DataGridViewCellEventArgs e)
{
dgvOrderDet.Rows.Clear();
//int orderID = Convert.ToInt32(dgvOrder.CurrentCell.Value.ToString());
int orderID = 0;
if (dgvOrder.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
dgvOrder.CurrentRow.Selected = true;
orderID = Convert.ToInt32(dgvOrder.Rows[e.RowIndex].Cells["orderID"].FormattedValue.ToString());
}
var list = HelperOrderDet.GetOrderDetModelList(orderID);
foreach (var item in list)
{
dgvOrderDet.Rows.Add(item.Products.productID, item.Products.proName, item.priceEach, item.quantityOrdered, item.Employees.eFirstName + " " + item.Employees.eLastName);
}
}
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);
}
}
}
