private void LoadPayablePaymentItems(Guid id)
{
var payablePaymentItems = payablePaymentItemRepository.GetByPayablePaymentId(id);
lvwPayablePayment.Items.Clear();
decimal cash = 0;
decimal bank = 0;
decimal giro = 0;
decimal correction = 0;
decimal total = 0;
foreach (var payablePaymentItem in payablePaymentItems)
{
cash = cash + payablePaymentItem.Cash;
bank = bank + payablePaymentItem.Bank;
giro = giro + payablePaymentItem.Giro;
correction = correction + payablePaymentItem.Correction;
total = total + (payablePaymentItem.Cash + payablePaymentItem.Bank + payablePaymentItem.Giro + payablePaymentItem.Correction);
PopulatePayablePaymentItem(payablePaymentItem);
}
lblCash.Text = cash.ToString("N0").Replace(",", ".");
lblBank.Text = bank.ToString("N0").Replace(",", ".");
lblGiro.Text = giro.ToString("N0").Replace(",", ".");
lblCorrection.Text = correction.ToString("N0").Replace(",", ".");
lblTotal.Text = total.ToString("N0").Replace(",", ".");
}
public PayablePayment GetById(Guid id)
{
PayablePayment payablePayment = null;
using (var em = EntityManagerFactory.CreateInstance(ds))
{
string sql = "SELECT p.ID, p.PaymentCode, p.PaymentDate, "
+ "p.TotalCash, p.TotalBank, p.TotalGiro, p.TotalCorrection, p.GrandTotal, p.Notes, "
+ "p.CreatedDate,p.ModifiedDate, p.CreatedBy, p.ModifiedBy "
+ "FROM PayablePayment p "
+ "WHERE "
+ "p.ID='{" + id + "}'";
payablePayment = em.ExecuteObject <PayablePayment>(sql, new PayablePaymentMapper());
if (payablePayment != null)
{
payablePayment.PayablePaymentItems = payablePaymentItemRepository.GetByPayablePaymentId(payablePayment.ID);
}
}
return(payablePayment);
}