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