public BillReceipt GetById(Guid id)
{
BillReceipt billReceipt = null;
using (var em = EntityManagerFactory.CreateInstance(ds))
{
string sql = "SELECT b.ID, b.BillReceiptCode, b.BillReceiptDate, "
+ "b.GrandTotal, b.Notes, b.PrintCounter, "
+ "b.SalesmanId, s.SalesmanName, "
+ "b.CreatedDate, b.ModifiedDate, b.CreatedBy, b.ModifiedBy "
+ "FROM "
+ "BillReceipt b INNER JOIN Salesman s ON b.SalesmanId = s.ID "
+ "WHERE b.ID='{" + id + "}'";
billReceipt = em.ExecuteObject <BillReceipt>(sql, new BillReceiptMapper());
if (billReceipt != null)
{
billReceipt.BillReceiptItems = billReceiptItemRepository.GetByBillReceiptId(billReceipt.ID);
}
}
return(billReceipt);
}
private void LoadBillReceiptItems(Guid id)
{
var billReceiptItems = billReceiptItemRepository.GetByBillReceiptId(id);
lvwBillReceipt.Items.Clear();
decimal total = 0;
foreach (var billReceiptItem in billReceiptItems)
{
total = total + billReceiptItem.Total;
PopulateBillReceiptItem(billReceiptItem);
}
lblTotal.Text = total.ToString("N0").Replace(",", ".");
}