public void Delete(LaundryDaySummaryDataEntity p_daysummary)
 {
     using(var session = NHibernateHelper.OpenSession())
     {
         using(var transaction = session.BeginTransaction())
         {
             try
             {
                 session.Delete(p_daysummary);
                 transaction.Commit();
             }
             catch(Exception ex)
             {
                 transaction.Rollback();
                 throw ex;
             }
         }
     }
 }
Exemplo n.º 2
0
        public void saveNewHeaderAndNewDaySummary()
        {
            // test for new header and new day
            // should create new record for daysummary
            LaundryHeaderDataEntity header = new LaundryHeaderDataEntity();
            LaundryDetailDataEntity detail = new LaundryDetailDataEntity();
            LaundryJobChargesDataEntity jobcharge = new LaundryJobChargesDataEntity();

            LaundryCategoryDataEntity category = new LaundryCategoryDao().GetByName("Colored Garments");
            LaundryServiceDataEntity service = new LaundryServiceDao().GetByName("Wash - Dry - Fold");
            LaundryPriceSchemeDataEntity pricescheme = new LaundryPriceSchemeDao().GetByCategoryService(service,category);

            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.ReceivedDate = DateTime.Now;
            header.DueDate = DateTime.Now.AddDays(5); // add 5 days for due date

            detail.Header = header; // set header entity in detail for nhibernate to pickup and map
            detail.Category = category;
            detail.Service = service;
            detail.Kilo = 5;
            detail.Amount = pricescheme.Price * Convert.ToDecimal(detail.Kilo);
            detail.ItemQty = 20;

            jobcharge.Charge = new LaundryChargeDao().GetByName("Delivery");
            jobcharge.Header = header; // set header entity in jobcharge for nhibernate to pickup and map

            header.DetailEntities.Add(detail); // add detail to header details list
            header.JobChargeEntities.Add(jobcharge); // add charges to header charges list

            header.ClaimFlag = false;
            header.AmountDue = detail.Amount;
            header.TotalItemQty = detail.ItemQty;
            header.TotalCharge = jobcharge.Charge.Amount;
            header.TotalDiscount = 0;
            header.TotalAmountDue = (header.AmountDue + header.TotalCharge) - header.TotalDiscount;
            header.TotalPayment = header.TotalAmountDue;

            if(header.TotalPayment == header.TotalAmountDue){
                header.PaidFlag = true;
            }
            else{
                header.PaidFlag = false;
            }

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

            // set daysummary
            LaundryDaySummaryDataEntity daysummary = new LaundryDaySummaryDataEntity();
            daysummary.DayStamp = Convert.ToDateTime(DateTime.Now.ToShortDateString());
            daysummary.TotalSales += header.TotalPayment;
            daysummary.TransCount += 1;
            daysummary.HeaderEntities.Add(header); // set header entity in daysummary for nhibernate to pickup and map
            header.DaySummary = daysummary; // set daysummary entity in header for nhibernate to pickup and map

            custdao.SaveOrUpdate(customer); // save or update customer
            // save daysummary record; no need to explicitly save header,detail,jobcharges,paymentdetail, etc for new daysummary record
            // this will handle the saving for the linked tables

            // FIX: save new header & new daysummary thru laundrydao instead of laundrydaysummary
            LaundryDao dao = new LaundryDao();
            dao.SaveOrUpdate(header);
        }
 public void saveNewDaysummary()
 {
     LaundryDaySummaryDataEntity daysummary = new LaundryDaySummaryDataEntity();
 }
        private bool SaveDaySummary(LaundryHeaderDataEntity headerEntity)
        {
            try{
                DateTime today = Convert.ToDateTime(DateTime.Now.ToShortDateString()); // daystamp in daysummary should be date only (no time);
                LaundryDaySummaryDataEntity daySummary = m_summaryDao.GetByDay(today);

                headerEntity.PaymentDetailEntities = m_headerEntity.PaymentDetailEntities;

                if(daySummary != null)
                {
                    if(m_view.GetTitle().Contains("NEW"))
                        daySummary.TransCount += 1;
                    //TODO: totalsales should be totalamoutdue - balance
                    if(headerEntity.PaymentDetailEntities[headerEntity.PaymentDetailEntities.Count-1] != null)
                        daySummary.TotalSales += headerEntity.PaymentDetailEntities[headerEntity.PaymentDetailEntities.Count-1].Amount;
                    else
                        daySummary.TotalSales += 0;

                    headerEntity.DaySummary = daySummary;
                    // update daysummary with transcount and totalsales
                    m_summaryDao.Update(daySummary);
                }else{
                    // set daysummary
                    daySummary = new LaundryDaySummaryDataEntity();
                    daySummary.DayStamp = Convert.ToDateTime(DateTime.Now.ToShortDateString());
                    //TODO: totalsales should be amounttender - amount change.
                    if(headerEntity.PaymentDetailEntities[headerEntity.PaymentDetailEntities.Count-1] != null)
                        daySummary.TotalSales += headerEntity.PaymentDetailEntities[headerEntity.PaymentDetailEntities.Count-1].Amount;
                    else
                        daySummary.TotalSales += 0;

                    if(m_view.GetTitle().Contains("NEW"))
                        daySummary.TransCount += 1;

                    // set header entity in daysummary for nhibernate to pickup and map
                    daySummary.HeaderEntities.Add(headerEntity);
                    // set daysummary entity in header for nhibernate to pickup and map
                    m_headerEntity.DaySummary = daySummary;
                    //m_chargeDao.SaveOrUpdate(headerEntity.
                    //m_customerDao.SaveOrUpdate(headerEntity.Customer);
                    // save daysummary record; no need to explicitly save header,detail,jobcharges,paymentdetail, etc for new daysummary record
                    // this will handle the saving for the linked tables
                }
                m_laundryDao.SaveOrUpdate(headerEntity);
            }catch(Exception ex){
                MessageService.ShowError("Unexpected exception occured while saving your entries.\nPlease see log file for technical details.","Error in Saving", ex);
                return false;
            }
            return true;
        }