private void btnCash_Click(object sender, RoutedEventArgs e)
{
if (billItems.Count == 0)
{
///
return;
}
if (newReceiptID != "")
{
MessageBox.Show($"Hóa đơn này đã thanh toán, mã hóa đơn là {newReceiptID}!");
return;
}
BUS_Discount busDiscount = new BUS_Discount();
DTO_Discount curDiscount = busDiscount.GetCurrentDiscount();
string disID = "";
if (curDiscount.DiscountValue != 0)
{
disID = curDiscount.DiscountID;
}
DTO_Receipt newReceipt = new DTO_Receipt("", user, disID);
BUS_Receipt busReceipt = new BUS_Receipt();
newReceiptID = busReceipt.CreateReceipt(newReceipt);
if (newReceiptID != "")
{
BUS_ReceiptDetail busReceiptDetail = new BUS_ReceiptDetail();
bool result = true;
foreach (BillItem item in billItems)
{
DTO_ReceiptDetail newReceiptDetail = new DTO_ReceiptDetail(newReceiptID, item.id, item.amount, item.unitCost);
result = result & busReceiptDetail.CreateReceiptDetail(newReceiptDetail);
}
if (result)
{
MessageBox.Show("Tạo hóa đơn thành công!");
}
else
{
MessageBox.Show("Đã xảy ra lỗi trong quá trình tạo chi tiết hóa đơn!");
}
}
else
{
MessageBox.Show("Đã xảy ra lỗi trong quá trình tạo hóa đơn!");
}
}
public bool CreateReceiptDetail(DTO_ReceiptDetail newReceiptDetail)
{
//insert SQLite
string sql = $"INSERT INTO ReceiptDetail (ReceiptID, BeverageID, Amount, Price) VALUES ('{newReceiptDetail.ReceiptID}', '{newReceiptDetail.BeverageID}', {newReceiptDetail.Amount}, {newReceiptDetail.Price})";
SQLiteCommand insert = new SQLiteCommand(sql, getConnection().OpenAndReturn());
try
{
insert.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
public bool CreateReceiptDetail(DTO_ReceiptDetail newReceiptDetail)
{
return(dalReceiptDetail.CreateReceiptDetail(newReceiptDetail));
}
