protected void GridPlanning_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { e.Cancel = true; SaleInvoiceTransactionBO saleInvoiceTransactionBO = new SaleInvoiceTransactionBO(); saleInvoiceTransactionBO.DeletePlanningTransaction(session, Guid.Parse(e.Keys["TransactionId"].ToString())); GridPlanning.DataSource = saleInvoiceTransactionBO.GetPlanningTransactionsOfBill(session, BillId); GridPlanning.DataBind(); }
protected void GridPlanning_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { e.Cancel = true; GridPlanning.CancelEdit(); SaleInvoiceTransactionBO saleInvoiceTransactionBO = new SaleInvoiceTransactionBO(); saleInvoiceTransactionBO.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 = saleInvoiceTransactionBO.GetPlanningTransactionsOfBill(session, BillId); GridPlanning.DataBind(); }
public void DataBind() { if (BillId != null) { SaleInvoiceTransactionBO saleInvoiceTransactionBO = new SaleInvoiceTransactionBO(); GridPlanning.DataSource = saleInvoiceTransactionBO.GetPlanningTransactionsOfBill(session, BillId); GridPlanning.DataBind(); ReceiptVoucherTransactionBO receiptVoucherTransactionBO = new ReceiptVoucherTransactionBO(); GridActual.DataSource = receiptVoucherTransactionBO.GetActuallyCollectedOfBill(session, BillId); GridActual.KeyFieldName = "GeneralJournalId"; GridActual.DataBind(); } }
private void BindData() { if (BillId != null && !BillId.Equals(Guid.Empty)) { SalesInvoiceBO salesInvoiceBO = new SalesInvoiceBO(); //Bind data to purchase invoice information Bill bill = salesInvoiceBO.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 SaleInvoiceTransactionBO saleInvoiceTransactionBO = new SaleInvoiceTransactionBO(); var datasource = //session.GetObjectByKey<NAS.DAL.Invoice.PurchaseInvoice>(BillId).PurchaseInvoiceTransactions; saleInvoiceTransactionBO.GetTransactions(session, BillId); gridviewBookingEntriesForm.SetDataSource(datasource); /*2014-01-15 ERP-1396 Khoa.Truong INS START*/ //Bind data to voucher booking entries gridview datasource = saleInvoiceTransactionBO.GetVoucherTransactions(session, BillId); gridviewVoucherBookingEntriesForm.SetDataSource(datasource); //Bind data to inventory booking entries gridview datasource = saleInvoiceTransactionBO.GetInventoryTransactions(session, BillId); gridviewInventoryBookingEntriesForm.SetDataSource(datasource); /*2014-01-15 ERP-1396 Khoa.Truong INS END*/ } }
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) { SaleInvoiceTransactionBO invoiceTransactionBO = new SaleInvoiceTransactionBO(); var transactions = invoiceTransactionBO.GetTransactions(session, billId); ObjectBO objectBO = new ObjectBO(); foreach (var invoiceTransaction in transactions) { SaleInvoiceTransaction sourceSaleInvoiceTransaction = (SaleInvoiceTransaction)invoiceTransaction; SaleInvoiceTransaction saleInvoiceTransaction = new SaleInvoiceTransaction(session) { Amount = sourceSaleInvoiceTransaction.Amount, Code = String.Format("BT_{0}", ret.Code), CreateDate = DateTime.Now, Description = String.Format("BT_{0}", ret.Code), IssueDate = sourceSaleInvoiceTransaction.IssueDate, SalesInvoiceId = (NAS.DAL.Invoice.SalesInvoice)ret, RowStatus = Utility.Constant.ROWSTATUS_ACTIVE, UpdateDate = DateTime.Now }; saleInvoiceTransaction.Save(); //Create CMS Object for Transaction NAS.DAL.CMS.ObjectDocument.Object transactionCMSObject = objectBO.CreateCMSObject(session, DAL.CMS.ObjectDocument.ObjectTypeEnum.INVOICE_SALE); TransactionObject transactionObject = new TransactionObject(session) { ObjectId = transactionCMSObject, TransactionId = saleInvoiceTransaction }; transactionObject.Save(); //Clone GeneralJournal var generalJournals = sourceSaleInvoiceTransaction.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 = saleInvoiceTransaction }; generalJournal.Save(); //Create CMS object for GeneralJournal NAS.DAL.CMS.ObjectDocument.Object generalJournalCMSObject = objectBO.CreateCMSObject(session, DAL.CMS.ObjectDocument.ObjectTypeEnum.INVOICE_SALE); GeneralJournalObject generalJournalObject = new GeneralJournalObject(session) { GeneralJournalId = generalJournal, ObjectId = generalJournalCMSObject }; generalJournalObject.Save(); } } }
protected void cpBooking_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e) { switch (e.Parameter) { case "view": //grdBooking.DetailRows.CollapseAllRows(); //if (Session["SaleBillId"] == null) //{ // return; //} SaleInvoiceTransactionBO saleInvoiceTransactionBO = new SaleInvoiceTransactionBO(); XPCollection <Transaction> collectTransaction = saleInvoiceTransactionBO.GetTransactionsAndRelatedTransactions(session, Guid.Parse(Session["SaleBillId"].ToString())); //session = XpoHelper.GetNewSession(); //SalesInvoice salesInvoice = session.GetObjectByKey<SalesInvoice>(Guid.Parse(Session["SaleBillId"].ToString())); //CriteriaOperator filter = new BinaryOperator("SalesInvoiceId", Guid.Parse(Session["SaleBillId"].ToString()), BinaryOperatorType.Equal); //XPCollection<SaleInvoiceTransaction> saleInvoiceTransaction = new XPCollection<SaleInvoiceTransaction>(session, filter); grdBooking.DataSource = collectTransaction; grdBooking.DataBind(); //cpBooking.JSProperties.Add("cpEnable", "true"); break; case "booking": //salesInvoice = session.GetObjectByKey<SalesInvoice>(Guid.Parse(Session["SaleBillId"].ToString())); //filter = new BinaryOperator("SalesInvoiceId", Guid.Parse(Session["SaleBillId"].ToString()), BinaryOperatorType.Equal); //saleInvoiceTransaction = new XPCollection<SaleInvoiceTransaction>(session, filter); //foreach (SaleInvoiceTransaction item in saleInvoiceTransaction) //{ // double credit = 0; // double debit = 0; // filter = new GroupOperator(GroupOperatorType.And, // new BinaryOperator("TransactionId", item.TransactionId, BinaryOperatorType.Equal), // new BinaryOperator("RowStatus", ROW_NEW, BinaryOperatorType.Equal)); // XPCollection<GeneralJournal> generalJournal = new XPCollection<GeneralJournal>(session, filter); // foreach (GeneralJournal x in generalJournal) // { // filter = new GroupOperator(GroupOperatorType.And, // new BinaryOperator("TransactionId", item.TransactionId, BinaryOperatorType.Equal), // new BinaryOperator("AccountId", x.AccountId, BinaryOperatorType.Equal), // new BinaryOperator("RowStatus", ROW_NEW, BinaryOperatorType.Equal)); // XPCollection<GeneralJournal> generalJ = new XPCollection<GeneralJournal>(session, filter); // if (generalJ.Count >= 2) // { // cpBooking.JSProperties.Add("cpUnbooked", "1"); // return; // } // credit += x.Credit; // debit += x.Debit; // } // if (credit != debit) // { // cpBooking.JSProperties.Add("cpUnbooked", "2"); // return; // } //} //foreach (SaleInvoiceTransaction item in saleInvoiceTransaction) //{ // item.RowStatus = ROW_NOT_DELETE; // item.Save(); // filter = new BinaryOperator("TransactionId", item.TransactionId, BinaryOperatorType.Equal); // XPCollection<GeneralJournal> generalJournal = new XPCollection<GeneralJournal>(session, filter); // double milsec = 0; // foreach (GeneralJournal x in generalJournal) // { // NAS.DAL.Accounting.AccountChart.Account account = session.GetObjectByKey<NAS.DAL.Accounting.AccountChart.Account>(x.AccountId.AccountId); // //General general = new General(); // //general.BalanceUpdate(session, account, x, false, x.Debit-x.Credit); // AccountingBO accountBO = new AccountingBO(); // accountBO.CreateGeneralLedger(session, x.TransactionId.TransactionId, x.GeneralJournalId,milsec); // milsec += 10; // } //} ////salesInvoice.RowStatus = ROW_NOT_DELETE; //salesInvoice.Save(); //grdBooking.DetailRows.CollapseAllRows(); //grdBooking.Columns["Thao tác"].Visible = false; //cpBooking.JSProperties.Add("cpSuccess", "true"); break; default: break; } }