public bool ReceiptVoucherCreating_CRUD() { ClearForm(); //Create temp voucher ReceiptVouches receiptVouches = receiptVouchesBO.CreateNewObject(session); //Update VoucherId VoucherId = receiptVouches.VouchesId; txtIssueDate.Date = DateTime.Now; //Get default code ArtifactCodeRuleBO artifactCodeRuleBO = new ArtifactCodeRuleBO(); txtCode.Text = artifactCodeRuleBO.GetArtifactCodeOfArtifactType(ArtifactTypeEnum.VOUCHER_RECEIPT); //Link to the bill if (BillId != Guid.Empty) { //Link bill to voucher LinkVoucherWithBill(session, BillId, receiptVouches); //Fill bill data into voucher FillBillDataIntoVoucher(session, BillId); } //Get default currency... gridlookupCurrency.ResetToDefault(); spinExchangeRate.Number = 1; UpdateGUIByCurrency(gridlookupCurrency.GetSelectedCurrency(session)); //Bind data to VoucherAllocation gridview gridviewVoucherAllocation_DataBind(); return(true); }
protected void Page_Load(object sender, EventArgs e) { artifactCodeRuleBO = new ArtifactCodeRuleBO(); if (!IsPostBack) { GenerateViewStateControlId(); GUIContext = new Context(); } //Context only has ArtifactCodeRuleListing state GUIContext.State = new ERPSystem.ArtifactCode.State.ArtifactCodeRuleListing.ArtifactCodeRuleListing(this); }
protected void Page_Load(object sender, EventArgs e) { codeRuleDefinitionBO = new CodeRuleDefinitionBO(); artifactCodeRuleBO = new ArtifactCodeRuleBO(); if (!IsPostBack) { GenerateViewStateControlId(); CodeRuleDefinitionViewData = null; GUIContext = new Context(); ArtifactCodeRuleId = Guid.Empty; } BindArtifactTypeData(); formlayoutArtifactCodeRuleEditingForm.DataBind(); treelistCodeRuleData.DataSource = CodeRuleDefinitionViewData; treelistCodeRuleData.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { artifactCodeRuleBO = new ArtifactCodeRuleBO(); dsOriginArtifact.CriteriaParameters["VoucherId"].DefaultValue = PrivateSession.Instance.VoucherId.ToString(); dsTransaction.CriteriaParameters["VoucherId"].DefaultValue = PrivateSession.Instance.VoucherId.ToString(); frmCosting.DataBind(); //Hide command column when costing was approved this.InvisibleCommandColumnGridviewIfApprovedCosting(grdTransaction, "CommonOperations"); if (PrivateSession.Instance.VoucherId != Guid.Empty) { NAS.DAL.Vouches.PaymentVouches paymentVouches = session.GetObjectByKey <NAS.DAL.Vouches.PaymentVouches>(PrivateSession.Instance.VoucherId); string sumOfCreditFormatted = String.Format("{0:#,###}", paymentVouches.SumOfCredit); lblSumOfCredit.Text = sumOfCreditFormatted; } }
protected void Page_Load(object sender, EventArgs e) { artifactCodeRuleBO = new ArtifactCodeRuleBO(); dsOriginArtifact.CriteriaParameters["VoucherId"].DefaultValue = PrivateSession.Instance.VoucherId.ToString(); dsTransaction.CriteriaParameters["VoucherId"].DefaultValue = PrivateSession.Instance.VoucherId.ToString(); frmCosting.DataBind(); if (PrivateSession.Instance.VoucherId != Guid.Empty) { NAS.DAL.Vouches.ReceiptVouches receiptVoucher = session.GetObjectByKey <NAS.DAL.Vouches.ReceiptVouches>(PrivateSession.Instance.VoucherId); string sumOfDebitFormatted = String.Format("{0:#,###}", receiptVoucher.SumOfDebit); lblSumOfDebit.Text = sumOfDebitFormatted; } this.HideGridViewColumnsWhenApprovedCosting(grdTransaction, "CommonOperations"); }
public bool PurchaseInvoiceCreating_CRUD() { //Create new temporary bill NAS.BO.Invoice.PurchaseInvoiceBO purchaseInvoiceBO = new NAS.BO.Invoice.PurchaseInvoiceBO(); Bill bill = purchaseInvoiceBO.InitTemporary(session, BillType); BillId = bill.BillId; hfBillId["BillId"] = BillId.ToString(); formlayoutInvoiceEditingForm_LoadData(); //Get default code ArtifactCodeRuleBO artifactCodeRuleBO = new ArtifactCodeRuleBO(); txtCode.Text = artifactCodeRuleBO.GetArtifactCodeOfArtifactType(ArtifactTypeEnum.INVOICE_PURCHASE); SetControlsProperties(); return(true); }
protected void grdPurchase_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { string[] p = e.Parameters.Split('|'); switch (p[0]) { case "copy": Guid id = Guid.Parse(p[1].ToString()); Bill bill = session.GetObjectByKey <Bill>(id); if (bill != null) { ArtifactCodeRuleBO artifactCodeRuleBO = new ArtifactCodeRuleBO(); Bill billCopy = new Bill(session); billCopy = bill; billCopy.BillId = new Guid(); billCopy.RowStatus = 1; billCopy.Save(); CriteriaOperator filter = new BinaryOperator("BillId", bill.BillId, BinaryOperatorType.Equal); XPCollection <BillItem> collectBillItem = new XPCollection <BillItem>(session, filter); foreach (BillItem bi in collectBillItem) { BillItem billItem = new BillItem(session); billItem = bi; billItem.BillId = billCopy; billItem.RowStatus = 1; billItem.Save(); } grdPurchase.JSProperties.Add("cpRefresh", billCopy.Code); } break; default: break; } }
protected void Page_Load(object sender, EventArgs e) { artifactCodeRuleBO = new ArtifactCodeRuleBO(); SetCriteriaForOrganization(); dsVouchersAmount.CriteriaParameters["VouchesId"].DefaultValue = PrivateSession.Instance.ReceiptVoucherId.ToString(); /*2013-11-24 Khoa.Truong MOD START*/ //grdVouchersAmount.DataBind(); if (!IsPostBack) { grdVouchersAmount.DataBind(); } /*2013-11-24 Khoa.Truong MOD END*/ this.InvisibleCommandColumnGridviewIfApprovedCosting(grdVouchersAmount, "CommonOperations"); if (Page.IsPostBack) { if (hReceiptViewer.Contains("print")) { XPQuery <ReceiptVouches> receiptVouches = new XPQuery <ReceiptVouches>(session); XPQuery <VouchesAmount> vouchesAmount = new XPQuery <VouchesAmount>(session); var list = from r in receiptVouches.AsEnumerable() join va in vouchesAmount.AsEnumerable() on r.VouchesId equals va.VouchesId.VouchesId where r.VouchesId == PrivateSession.Instance.ReceiptVoucherId select new C01TT { Code = r.Code, IssuedDate = r.IssuedDate, Description = r.Description, CustomerName = r.SourceOrganizationId.Name, Address = r.Address, ReceiverName = r.Payer, Debit = va.Debit, ExchangeRate = va.ExchangeRate, DebitExchange = va.Debit * va.ExchangeRate, //DebitByString = Utility.Accounting.NumberToStringFullCurrency(float.Parse(va.Debit.ToString()), va.ForeignCurrencyId.Name), //Currency = va.ForeignCurrencyId.Code DebitByString = Utility.Accounting.NumberToStringFullCurrency(float.Parse(va.Debit.ToString()), va.CurrencyId.Name), Currency = va.CurrencyId.Code }; List <C01TT> lst = new List <C01TT>(); try { if (list.Count <C01TT>() > 0) { lst = list.Cast <C01TT>().ToList(); } } catch (Exception) { lst = null; } XPQuery <ReceiptVouchesTransaction> receiptVouchesTransaction = new XPQuery <ReceiptVouchesTransaction>(session); XPQuery <GeneralJournal> generalJournal = new XPQuery <GeneralJournal>(session); var listg = from p in receiptVouchesTransaction.AsEnumerable() join g in generalJournal.AsEnumerable() on p.TransactionId equals g.TransactionId.TransactionId where p.ReceiptVouchesId.VouchesId == PrivateSession.Instance.ReceiptVoucherId orderby g.Credit, g.Debit select new { Dc = g.Debit > g.Credit ? "Nợ :" : "Có :", Account = g.AccountId.Code, Amount = Math.Max(g.Debit, g.Credit) }; grdBooking.DataSource = listg.ToList(); grdBooking.DataBind(); _01_TT report = new _01_TT(); report.DataSource = lst; report.DataMember = ""; report.pccData.PrintableComponent = new PrintableComponentLinkBase() { Component = gvDataExporter }; rptReceiptViewer.Report = report; hReceiptViewer.Remove("print"); cpReceiptViewer.JSProperties.Add("cpShowForm", "report"); } } }
protected void grdPurchase_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { string[] p = e.Parameters.Split('|'); switch (p[0]) { case "copy": Guid id = Guid.Parse(p[1].ToString()); Bill bill = session.GetObjectByKey <Bill>(id); if (bill != null) { ArtifactCodeRuleBO artifactCodeRuleBO = new ArtifactCodeRuleBO(); Bill billCopy = new Bill(session); billCopy.BillId = new Guid(); billCopy.Code = bill.Code + "_copy"; billCopy.RowStatus = 1; billCopy.TargetOrganizationId = bill.TargetOrganizationId; billCopy.SourceOrganizationId = bill.SourceOrganizationId; CriteriaOperator filter = new BinaryOperator("Code", billCopy.Code, BinaryOperatorType.Equal); Bill billTest = session.FindObject <Bill>(filter); if (billTest == null) { billCopy.Save(); } else { grdPurchase.JSProperties.Add("cpCopyFailed", billCopy.Code); return; } filter = new BinaryOperator("BillId", id, BinaryOperatorType.Equal); XPCollection <BillActor> collectBillActor = new XPCollection <BillActor>(session, filter); foreach (BillActor ba in collectBillActor) { BillActor billActor = new BillActor(session); billActor.BillId = billCopy; billActor.BillActorId = Guid.NewGuid(); billActor.BillActorTypeId = ba.BillActorTypeId; billActor.OrganizationId = ba.OrganizationId; billActor.PersonId = ba.PersonId; billActor.Save(); } filter = new BinaryOperator("BillId", id, BinaryOperatorType.Equal); XPCollection <BillItem> collectBillItem = new XPCollection <BillItem>(session, filter); foreach (BillItem bi in collectBillItem) { BillItem billItem = new BillItem(session); billItem.BillId = billCopy; billItem.RowStatus = 1; billItem.BillItemId = bi.BillItemId; billItem.LotId = bi.LotId; billItem.Price = bi.Price; billItem.PromotionInNumber = bi.PromotionInNumber; billItem.PromotionInPercentage = bi.PromotionInPercentage; billItem.Quantity = bi.Quantity; billItem.TotalPrice = bi.TotalPrice; billItem.Save(); filter = new BinaryOperator("BillItemId", id, BinaryOperatorType.Equal); XPCollection <BillItemTax> collectBillItemTax = new XPCollection <BillItemTax>(session, filter); foreach (BillItemTax bit in collectBillItemTax) { BillItemTax billItemTax = new BillItemTax(session); billItemTax.BillItemId = billItem; billItemTax.BillItemTaxId = Guid.NewGuid(); billItemTax.ItemTaxId = bit.ItemTaxId; billItemTax.TaxInNumber = bit.TaxInNumber; billItemTax.TaxInPercentage = bit.TaxInPercentage; billItemTax.Save(); } } grdPurchase.JSProperties.Add("cpRefresh", billCopy.Code); } break; default: break; } }