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(",", "."); }