public void saveNewPaymentDetail()
        {
            // test for saving new paymentdetail for partial payments
            RefillHeaderDataEntity header = new RefillDao().GetByID(2);

            header.AmountTender += 10.00M; // accumulate amount tender with current payment
            // set paymentdetail
            RefillPaymentDetailDataEntity paymentdetail = new RefillPaymentDetailDataEntity();
            paymentdetail.Amount = 10.00M; // current amount tender or payment
            paymentdetail.PaymentDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
            paymentdetail.Header = header;

            // TODO: should update paidflag in header if total balance = 0.

            // update daysummary
            DateTime daysummaryDay = Convert.ToDateTime(DateTime.Now.ToShortDateString());
            RefillDaySummaryDataEntity daysummary = new RefillDaySummaryDao().GetByDay(daysummaryDay);
            if(daysummary != null)
            {
                daysummary.TotalSales += paymentdetail.Amount;
                daysummary.DayStamp = daysummaryDay;
            }
            RefillDaySummaryDao dao = new RefillDaySummaryDao();
            dao.SaveOrUpdate(daysummary);

            // update header, save payment detail etc.
            header.PaymentDetailEntities.Add(paymentdetail);
            RefillDao ldao = new RefillDao();
            ldao.Update(header);
        }
        public void saveNewHeaderAndUpdateDaySummary()
        {
            // test for new header but with existing daysummary
            // should not save new record for daysummary
            // should only update existing daysummary with transcount and sales

            DateTime sampleDay = Convert.ToDateTime(DateTime.Now.ToShortDateString()); // daystamp in daysummary should be date only (no time);

            RefillDaySummaryDao summarydao = new RefillDaySummaryDao();
            RefillDaySummaryDataEntity summary = summarydao.GetByDay(sampleDay);
            if(summary!= null)
            {
                RefillHeaderDataEntity header = new RefillHeaderDataEntity();
                RefillDetailDataEntity detail = new RefillDetailDataEntity();

                RefillTransactionTypeDataEntity transactionType = new RefillTransactionTypeDao().GetByName("Delivery");
                RefillProductTypeDataEntity productType = new RefillProductTypeDao().GetByName("5 Gal at 15");

                CustomerDao custdao = new CustomerDao();
                CustomerDataEntity customer = custdao.GetByName("John Dee");
                if(customer == null)
                {
                    customer = new CustomerDataEntity();
                    customer.Name = "John Dee";
                    customer.Address = "Cebu";
                    customer.ContactNumber = "111-1111";
                }
                header.Customer = customer;
                header.Date = DateTime.Now;
                header.TransactionType = transactionType;

                detail.Header = header; // set header entity in detail for nhibernate to pickup and map
                detail.ProductType = productType;
                detail.Qty = 20;
                detail.Amount = productType.Price * Convert.ToDecimal(detail.Qty);
                detail.StoreBottleQty = 10;
                detail.StoreCapQty = 10;

                header.DetailEntities.Add(detail); // add detail to header details list
                header.AmountDue = detail.Amount;
                header.TotalQty = detail.Qty;
                header.AmountTender += 25.00M; // accumulate amount tender with current amount tender

                // TODO: should update paidflag in header if total balance = 0.

                // set paymentdetail
                RefillPaymentDetailDataEntity paymentdetail = new RefillPaymentDetailDataEntity();
                paymentdetail.Amount = header.AmountTender;
                paymentdetail.PaymentDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
                paymentdetail.Header = header;
                header.PaymentDetailEntities.Add(paymentdetail);

                summary.TransCount += 1;
                summary.TotalSales += header.AmountTender;
                header.DaySummary = summary;

                // update daysummary with transcount and totalsales
                RefillDaySummaryDao dao = new RefillDaySummaryDao();
                dao.Update(summary);

                // save header,details,etc.
                RefillDao ldao = new RefillDao();
                ldao.SaveOrUpdate(header);
            }
        }