public void LoadRefillHeaderAndInventoryData(List<RefillHeaderDataEntity> m_headers,
RefillCustInventoryHeaderDataEntity custInv)
{
this.txtamttender.Enabled = true;
txtBottlesOnHand.Text = (custInv != null) ? custInv.BottlesOnHand.ToString() : "0";
txtCapsOnHand.Text = (custInv != null) ? custInv.CapsOnHand.ToString() : "0";
bottlesOnHand = Int32.Parse(txtBottlesOnHand.Text);
capsOnHand = Int32.Parse(txtCapsOnHand.Text);
txtReturnedBottles.Enabled = (txtBottlesOnHand.Text != "0") ? true : false;
txtReturnedCaps.Enabled = (txtCapsOnHand.Text != "0") ? true : false;
this.refillHeaders = m_headers;
totalAmountDue = 0.00M;
foreach(RefillHeaderDataEntity header in this.refillHeaders)
{
dgvOutBalance.Rows.Add(header.Date.ToShortDateString(), header.RefillHeaderID, header.TotalQty,
header.AmountDue.ToString("N2"), header.AmountTender.ToString("N2"),
(header.AmountDue - header.AmountTender).ToString("N2"));
totalAmountDue += (header.AmountDue - header.AmountTender);
}
txtTotalAmtDue.Text = totalAmountDue.ToString("N2");
txtbalance.Text = totalAmountDue.ToString("N2");
}
public RefillCustInventoryDetailDataEntity GetDetailByDay(RefillCustInventoryHeaderDataEntity header, DateTime daystamp)
{
using(var session = NHibernateHelper.OpenSession())
{
var query = session.QueryOver<RefillCustInventoryDetailDataEntity>()
.Where(x => x.Header == header)
.And(x => x.Date == daystamp)
.SingleOrDefault();
return query;
}
}
public RefillingReturnPaymentPresenter(IRefillReturnPaymentView m_view)
{
this.m_view = m_view;
m_customerDao = new CustomerDao();
m_refillDao = new RefillDao();
m_refillReportDao = new RefillReportDao();
m_custInvDao = new RefillCustomerInventoryDao();
m_daysummaryDao = new RefillDaySummaryDao();
m_invDao = new RefillInventoryDao();
customer = new CustomerDataEntity();
custInv = new RefillCustInventoryHeaderDataEntity();
}
public void Delete(RefillCustInventoryHeaderDataEntity p_custinv)
{
using(var session = NHibernateHelper.OpenSession())
{
using(var transaction = session.BeginTransaction())
{
try
{
session.Delete(p_custinv);
transaction.Commit();
}
catch(Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public void GetRefillJOsByCustomer(string customerName)
{
try
{
customer = m_customerDao.GetByName(customerName) as CustomerDataEntity;
List<RefillHeaderDataEntity> refillHeaders = m_refillReportDao.GetUnpaidTransactionsReport(customer) as List<RefillHeaderDataEntity>;
custInv = m_custInvDao.GetByCustomer(customer) as RefillCustInventoryHeaderDataEntity;
if((custInv == null || (custInv.BottlesOnHand == 0 && custInv.CapsOnHand == 0))
&& refillHeaders.Count == 0)
{
MessageService.ShowInfo("No records found for customer: " + customerName);
return;
}
m_view.LoadRefillHeaderAndInventoryData(refillHeaders, custInv);
}
catch(Exception ex)
{
MessageService.ShowError("Unable to display data; an unexpected error occurred.\n" +
"Please check error log for details.\n", ex);
}
}
public void saveNewHeaderAndNewDaySummary()
{
// test for new header and new day
// should create new record for daysummary
RefillHeaderDataEntity header = new RefillHeaderDataEntity();
RefillDetailDataEntity detail = new RefillDetailDataEntity();
RefillTransactionTypeDataEntity transactionType = new RefillTransactionTypeDao().GetByName("Delivery");
RefillProductTypeDataEntity productType = new RefillProductTypeDao().GetByName("5 Gal at 25");
CustomerDao custdao = new CustomerDao();
CustomerDataEntity customer = custdao.GetByName("Vanessa Dee");
if(customer == null)
{
customer = new CustomerDataEntity();
customer.Name = "Vanessa Dee";
customer.Address = "Cebu";
customer.ContactNumber = "111-1111";
}
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 = 10;
detail.Amount = productType.Price * Convert.ToDecimal(detail.Qty);
detail.StoreBottleQty = 10;
detail.StoreCapQty = 10;
// update main inventory
// TODO: fix proper handling of inventory per type of bottle???
RefillInventoryDao refillInvDao = new RefillInventoryDao();
RefillInventoryHeaderDataEntity inv = new RefillInventoryHeaderDataEntity();
//inv = refillInvDao.GetByName("Cap");
//inv.TotalQty = 500;
//inv.QtyOnHand -= detail.StoreCapQty;
//inv.QtyReleased += detail.StoreCapQty;
//refillInvDao.Update(inv);
inv = refillInvDao.GetByName("5 Gal Bottle");
inv.QtyOnHand -= detail.StoreBottleQty;
inv.QtyReleased += detail.StoreBottleQty;
refillInvDao.Update(inv);
// update cust inventory
RefillCustomerInventoryDao custInvDao = new RefillCustomerInventoryDao();
RefillCustInventoryHeaderDataEntity custInv= new RefillCustInventoryHeaderDataEntity();
custInv.Customer = customer;
custInv.CapsOnHand += detail.StoreCapQty;
custInv.BottlesOnHand += detail.StoreBottleQty;
header.Customer = customer;
header.DetailEntities.Add(detail); // add detail to header details list
header.AmountDue = detail.Amount;
header.TotalQty = detail.Qty;
header.AmountTender = header.AmountDue;
if(header.AmountTender == header.AmountTender){
header.PaidFlag = true;
}
else{
header.PaidFlag = false;
}
// set paymentdetail
RefillPaymentDetailDataEntity paymentdetail = new RefillPaymentDetailDataEntity();
paymentdetail.Amount = header.AmountTender;
paymentdetail.PaymentDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
paymentdetail.Header = header;
header.PaymentDetailEntities.Add(paymentdetail);
// set daysummary
RefillDaySummaryDataEntity daysummary = new RefillDaySummaryDataEntity();
daysummary.DayStamp = Convert.ToDateTime(DateTime.Now.ToShortDateString());
daysummary.TotalSales += header.AmountTender;
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
custInvDao.SaveOrUpdate(custInv);
// 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
RefillDao ldao = new RefillDao();
ldao.SaveOrUpdate(header);
}
private RefillCustInventoryDetailDataEntity CreateNewCustInventoryDetail(RefillCustInventoryHeaderDataEntity header,
int returnedBottles, int returnedCaps, DateTime returnDate)
{
RefillCustInventoryDetailDataEntity detail = new RefillCustInventoryDetailDataEntity();
detail.Header = header;
detail.BottlesReturned = returnedBottles;
detail.CapsReturned = returnedCaps;
detail.Date = returnDate;
return detail;
}
private bool UpdateRefillCustomerInventory(RefillHeaderDataEntity headerEntity)
{
try{
RefillInventoryHeaderDataEntity inventoryHeader = new RefillInventoryHeaderDataEntity();
RefillCustInventoryHeaderDataEntity customerInvHeader = m_customerInvDao.GetByCustomer(headerEntity.Customer);
if(customerInvHeader == null){
customerInvHeader = new RefillCustInventoryHeaderDataEntity();
customerInvHeader.Customer = headerEntity.Customer;
}
foreach(RefillDetailDataEntity detail in headerEntity.DetailEntities){
if(detail.ProductType.Name.StartsWith("5 Gal",true,null)){
inventoryHeader = m_refillInvDao.GetByName("5 Gal");
if(inventoryHeader != null){
inventoryHeader.QtyOnHand -= detail.StoreBottleQty;
inventoryHeader.QtyReleased += detail.StoreBottleQty;
customerInvHeader.CapsOnHand += detail.StoreCapQty;
customerInvHeader.BottlesOnHand += detail.StoreBottleQty;
m_refillInvDao.Update(inventoryHeader);
m_customerInvDao.SaveOrUpdate(customerInvHeader);
UpdateCapsQty(detail, customerInvHeader, false);
UpdateInventoryDetail(inventoryHeader);
}
}
}
}catch(Exception ex){
MessageService.ShowError("Unexpected exception occured while processing your request.\nPlease see log file for technical details","Error", ex);
return false;
}
return true;
}
private void UpdateCapsQty(RefillDetailDataEntity detail, RefillCustInventoryHeaderDataEntity customerInvHeader, bool voided)
{
RefillInventoryHeaderDataEntity inventoryHeader = new RefillInventoryHeaderDataEntity();
inventoryHeader = m_refillInvDao.GetByName("Caps");
if(inventoryHeader != null){
if(!voided){
inventoryHeader.QtyOnHand -= detail.StoreCapQty;
inventoryHeader.QtyReleased += detail.StoreCapQty;
customerInvHeader.CapsOnHand += detail.StoreCapQty;
}else{
inventoryHeader.QtyOnHand += detail.StoreCapQty;
inventoryHeader.QtyReleased -= detail.StoreCapQty;
customerInvHeader.CapsOnHand -= detail.StoreCapQty;
}
m_refillInvDao.Update(inventoryHeader);
UpdateInventoryDetail(inventoryHeader);
}
}
