//Lấy hóa đơn của Bàn
public int getBill(int id)
{
DataTable data = DataProvider.Instance.ExcuteQuery("SELECT * FROM dbo.Bill WHERE idTable =" + id + "AND status = 0");
if (data.Rows.Count > 0)
{
ClsBill bill = new ClsBill(data.Rows[0]);
return(bill.Id);
}
return(-1);
}
public IActionResult PostBill([FromBody] ClsBill bill)
{
_log4net.Info("Post method is called!");
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var tempbill = _context.AddBill(bill);
return(Ok(tempbill));
}
public ClsBill AddBill(ClsBill item)
{
ClsBill bill = null;
if (item == null)
{
throw new NullReferenceException();
}
else
{
bill = new ClsBill()
{
BillId = item.BillId, BillOwner = item.BillOwner, FurnitureName = item.FurnitureName, BillAmount = item.BillAmount
};
_context.Bills.Add(bill);
_context.SaveChanges();
}
return(item);
}
public ClsBill GetBillById(int id)
{
ClsBill bill = _context.Bills.Find(id);
return(bill);
}
