private void BindData() { if (BillId != null && !BillId.Equals(Guid.Empty)) { PurchaseInvoiceBO purchaseInvoiceBO = new PurchaseInvoiceBO(); //Bind data to purchase invoice information Bill bill = purchaseInvoiceBO.GetBillById(session, BillId); lblCode.Text = bill.Code; lblIssuedDate.Text = bill.IssuedDate.ToString(); lblSumOfPromotion.Text = bill.SumOfPromotion != 0 ? String.Format("{0:#,###}", bill.SumOfPromotion) : "0"; lblSumOfTax.Text = bill.SumOfTax != 0 ? String.Format("{0:#,###}", bill.SumOfTax) : "0"; lblSumOfTotalPrice.Text = bill.SumOfItemPrice != 0 ? String.Format("{0:#,###}", bill.SumOfItemPrice) : "0"; lblTotal.Text = bill.Total != 0 ? String.Format("{0:#,###}", bill.Total) : "0"; lblOrganization.Text = String.Format("{0} - {1}", bill.SourceOrganizationId.Code, bill.SourceOrganizationId.Name); if (bill.RowStatus.Equals(Utility.Constant.ROWSTATUS_BOOKED_ENTRY)) { lblBookingStatus.Text = "Đã ghi sổ"; } else { lblBookingStatus.Text = "Chưa ghi sổ"; } //Bind data to booking entries gridview PurchaseInvoiceTransactionBO purchaseInvoiceTransactionBO = new PurchaseInvoiceTransactionBO(); var datasource = //session.GetObjectByKey<NAS.DAL.Invoice.PurchaseInvoice>(BillId).PurchaseInvoiceTransactions; purchaseInvoiceTransactionBO.GetTransactionsAndRelatedTransactions(session, BillId); gridviewBookingEntriesForm.SetDataSource(datasource); } }
protected void GridPlanning_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { e.Cancel = true; PurchaseInvoiceTransactionBO purchaseInvoiceTransactionBO = new PurchaseInvoiceTransactionBO(); purchaseInvoiceTransactionBO.DeletePlanningTransaction(session, Guid.Parse(e.Keys["TransactionId"].ToString())); GridPlanning.DataSource = purchaseInvoiceTransactionBO.GetPlanningTransactionsOfBill(session, BillId); GridPlanning.DataBind(); }
protected void GridPlanning_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { e.Cancel = true; GridPlanning.CancelEdit(); PurchaseInvoiceTransactionBO purchaseInvoiceTransactionBO = new PurchaseInvoiceTransactionBO(); purchaseInvoiceTransactionBO.UpdatePlanningTransaction(session, Guid.Parse(e.Keys["TransactionId"].ToString()), (DateTime)e.NewValues["IssueDate"], (string)e.NewValues["Code"], (double)e.NewValues["Amount"], (string)e.NewValues["Description"], CurrencyId); GridPlanning.DataSource = purchaseInvoiceTransactionBO.GetPlanningTransactionsOfBill(session, BillId); GridPlanning.DataBind(); }
public void DataBind() { if (BillId != null) { PurchaseInvoiceTransactionBO purchaseInvoiceTransactionBO = new PurchaseInvoiceTransactionBO(); GridPlanning.DataSource = purchaseInvoiceTransactionBO.GetPlanningTransactionsOfBill(session, BillId); GridPlanning.DataBind(); PaymentVoucherTransactionBO paymentVoucherTransactionBO = new PaymentVoucherTransactionBO(); GridActual.DataSource = paymentVoucherTransactionBO.GetActuallyCollectedOfBill(session, BillId); GridActual.KeyFieldName = "GeneralJournalId"; GridActual.DataBind(); } }
void Set_M_ListTransaction() { if (m_Bill != null) { saleInvoiceTransactionBO = new SaleInvoiceTransactionBO(); purchaseInvoiceTransactionBO = new PurchaseInvoiceTransactionBO(); //SalesInvoice _SalesInvoice = session.GetObjectByKey<SalesInvoice>(m_Bill.BillId); //if (_SalesInvoice == null) //{ NAS.DAL.Invoice.PurchaseInvoice _PurchaseInvoice = session.GetObjectByKey <NAS.DAL.Invoice.PurchaseInvoice>(m_Bill.BillId); m_ListTransaction = purchaseInvoiceTransactionBO.GetTransactionsAndRelatedTransactions(session, m_Bill.BillId); //} //else //{ // m_ListTransaction = saleInvoiceTransactionBO.GetTransactionsAndRelatedTransactions(session, m_Bill.BillId); //} } }
protected override void CloneBillTransaction(Session session, Guid billId, ref Bill ret) { PurchaseInvoiceTransactionBO invoiceTransactionBO = new PurchaseInvoiceTransactionBO(); var transactions = invoiceTransactionBO.GetTransactions(session, billId); ObjectBO objectBO = new ObjectBO(); foreach (var invoiceTransaction in transactions) { PurchaseInvoiceTransaction sourcePurchaseInvoiceTransaction = (PurchaseInvoiceTransaction)invoiceTransaction; PurchaseInvoiceTransaction purchaseInvoiceTransaction = new PurchaseInvoiceTransaction(session) { Amount = sourcePurchaseInvoiceTransaction.Amount, Code = String.Format("BT_{0}", ret.Code), CreateDate = DateTime.Now, Description = String.Format("BT_{0}", ret.Code), IssueDate = sourcePurchaseInvoiceTransaction.IssueDate, PurchaseInvoiceId = (NAS.DAL.Invoice.PurchaseInvoice)ret, RowStatus = Utility.Constant.ROWSTATUS_ACTIVE, UpdateDate = DateTime.Now }; purchaseInvoiceTransaction.Save(); //Create CMS Object for Transaction NAS.DAL.CMS.ObjectDocument.Object transactionCMSObject = objectBO.CreateCMSObject(session, DAL.CMS.ObjectDocument.ObjectTypeEnum.INVOICE_PURCHASE); TransactionObject transactionObject = new TransactionObject(session) { ObjectId = transactionCMSObject, TransactionId = purchaseInvoiceTransaction }; transactionObject.Save(); //Clone GeneralJournal var generalJournals = sourcePurchaseInvoiceTransaction.GeneralJournals .Where(r => r.RowStatus >= Utility.Constant.ROWSTATUS_ACTIVE); foreach (var sourceGeneralJournal in generalJournals) { GeneralJournal generalJournal = new GeneralJournal(session) { AccountId = sourceGeneralJournal.AccountId, CreateDate = DateTime.Now, Credit = sourceGeneralJournal.Credit, CurrencyId = sourceGeneralJournal.CurrencyId, Debit = sourceGeneralJournal.Debit, Description = sourceGeneralJournal.Description, JournalType = sourceGeneralJournal.JournalType, RowStatus = Utility.Constant.ROWSTATUS_ACTIVE, TransactionId = purchaseInvoiceTransaction }; generalJournal.Save(); //Create CMS object for GeneralJournal NAS.DAL.CMS.ObjectDocument.Object generalJournalCMSObject = objectBO.CreateCMSObject(session, DAL.CMS.ObjectDocument.ObjectTypeEnum.INVOICE_PURCHASE); GeneralJournalObject generalJournalObject = new GeneralJournalObject(session) { GeneralJournalId = generalJournal, ObjectId = generalJournalCMSObject }; generalJournalObject.Save(); } } }