public Sales GetById(Guid id)
{
Sales sales = null;
using (var em = EntityManagerFactory.CreateInstance(ds))
{
string sql = "SELECT s.ID, s.SalesCode, s.SalesDate, s.CustomerId, c.CustomerName, c.Address,"
+ "s.SalesmanId, sl.SalesmanName,s.PaymentMethod, s.Status, s.Notes, s.GrandTotal, "
+ "s.CreatedDate, s.ModifiedDate, s.CreatedBy, s.ModifiedBy, "
+ "s.AmountInWords, s.DueDate, s.PrintCounter, s.TermOfPayment "
+ "FROM (Sales s INNER JOIN Customer c ON s.CustomerId = c.ID) "
+ "INNER JOIN Salesman sl ON s.SalesmanId = sl.ID "
+ "WHERE s.ID='{" + id + "}'";
sales = em.ExecuteObject <Sales>(sql, new SalesMapper());
if (sales != null)
{
sales.SalesItems = salesItemRepository.GetBySalesId(sales.ID);
}
}
return(sales);
}
private void LoadSalesItems(Guid id)
{
var salesItems = salesItemRepository.GetBySalesId(id);
lvwSales.Items.Clear();
decimal total = 0;
foreach (var salesItem in salesItems)
{
total = total + (salesItem.Qty * salesItem.Price);
PopulateSalesItem(salesItem);
}
lblTotal.Text = total.ToString("N0").Replace(",", ".");
}
