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;
}
}
