protected void spinItemTax_Load(object sender, EventArgs e)
{
ASPxSpinEdit spin = sender as ASPxSpinEdit;
ASPxCallbackPanel panel = spin.NamingContainer as ASPxCallbackPanel;
//Set data when in edit mode
if (gridviewBillItem.IsEditing && !gridviewBillItem.IsNewRowEditing && !panel.IsCallback)
{
var billItemId = (panel.NamingContainer
as DevExpress.Web.ASPxGridView.GridViewDataItemTemplateContainer).KeyValue;
object itemId = gridviewBillItem.GetRowValuesByKeyValue(billItemId, "ItemId!Key");
if (itemId == DBNull.Value)
{
return;
}
ItemBO itemBO = new ItemBO();
ItemTax itemTax = itemBO.GetCurrentVATOfItem(session, (Guid)itemId);
if (itemTax != null)
{
spin.Number = (decimal)itemTax.TaxId.Percentage;
}
else
{
spin.Number = 0;
}
}
}
protected void panelItemVAT_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
ASPxCallbackPanel panel = sender as ASPxCallbackPanel;
ASPxSpinEdit spin = panel.FindControl("spinItemTax") as ASPxSpinEdit;
ItemBO itemBO = new ItemBO();
ItemTax itemTax = itemBO.GetCurrentVATOfItem(session, Guid.Parse(e.Parameter));
if (itemTax != null)
{
spin.Number = (decimal)itemTax.TaxId.Percentage;
}
else
{
spin.Number = 0;
}
}
private void DisplayInfo(Guid itemId, Guid unitId)
{
Item item = null;
NAS.DAL.Nomenclature.Item.Unit unit = null;
item = session.GetObjectByKey <Item>(itemId);
if (item != null)
{
lblItemCode.Text = item.Code;
lblItemName.Text = item.Name;
lblManufacturer.Text = item.ManufacturerOrgId.Name;
//Get ItemTax
ItemBO itemBO = new ItemBO();
ItemTax itemTax = itemBO.GetCurrentVATOfItem(session, itemId);
if (itemTax == null)
{
lblTax.Text = "N/A";
}
else
{
lblTax.Text = String.Format("{0}%", itemTax.TaxId.Percentage);
}
}
unit = session.GetObjectByKey <NAS.DAL.Nomenclature.Item.Unit>(unitId);
if (unit != null)
{
lblUnit.Text = unit.Code;
if (item == null)
{
return;
}
//Get ItemUnit
ItemUnit itemUnit = item.ItemUnits.Where(r => r.UnitId.UnitId == unit.UnitId).FirstOrDefault();
InventoryLedgerBO inventoryLedgerBO = new InventoryLedgerBO();
double balance = inventoryLedgerBO.GetItemUnitBalance(session, itemUnit.ItemUnitId);
lblBalance.Text = String.Format("{0:N0}", balance);
//lblConvertedBalance.Text = balance.
}
}
public bool checkTaxIsExistInItemTax(Session session, string code, out string relatedItemCode)
{
try
{
ItemTax itemtax = session.FindObject <ItemTax>(CriteriaOperator.And(
new BinaryOperator("TaxId.Code", code, BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", 0, BinaryOperatorType.Equal))
);
if (itemtax != null)
{
relatedItemCode = itemtax.ItemId.Code;
return(true);
}
relatedItemCode = string.Empty;
return(false);
}
catch (Exception)
{
throw;
}
}
//public current VAT ItemTax
public ItemTax GetCurrentVATOfItem(Session session, Guid itemId)
{
Item item = session.GetObjectByKey <Item>(itemId);
//TaxType VATTaxType = session.FindObject<TaxType>(new BinaryOperator("Code", "GTGT"));
TaxType VATTaxType = session.FindObject <TaxType>(new BinaryOperator("Code", "VAT"));
if (item.ItemTaxes != null && item.ItemTaxes.Count > 0)
{
DateTime systemDate = DateTime.Now;
ItemTax itemTax =
item.ItemTaxes.Where(r => r.TaxId.TaxTypeId == VATTaxType &&
r.RowStatus == Utility.Constant.ROWSTATUS_ACTIVE
//&& r.ValidFromDate <= systemDate
//&& systemDate <= r.ValidToDate
).FirstOrDefault();
return(itemTax);
}
else
{
return(null);
}
}
public BillItemTax BillItemTaxInit(Session session,
BillItem BillItemId,
Guid BillItemTaxId,
ItemTax ItemTaxId,
double TaxInPercentage,
double TaxInNumber
)
{
BillItemTax billItemTax = session.GetObjectByKey <BillItemTax>(BillItemTaxId);
if (billItemTax == null)
{
billItemTax = new BillItemTax(session);
billItemTax.BillItemTaxId = BillItemTaxId;
}
billItemTax.BillItemId = BillItemId;
billItemTax.TaxInNumber = TaxInNumber;
billItemTax.TaxInPercentage = TaxInPercentage;
billItemTax.ItemTaxId = ItemTaxId;
return(billItemTax);
}
public override string ToString()
{
StringBuilder result = new StringBuilder();
if (IsSetTitle())
{
result.Append("Title: ");
result.AppendLine(Title);
}
if (IsSetASIN())
{
result.Append("ASIN: ");
result.AppendLine(ASIN);
}
if (IsSetSellerSKU())
{
result.Append("SKU: ");
result.AppendLine(SellerSKU);
}
if (IsSetItemPrice())
{
result.Append("Price: ");
result.AppendLine(ItemPrice.ToString());
}
if (IsSetItemTax())
{
result.Append("Item Tax: ");
result.AppendLine(ItemTax.ToString());
}
if (IsSetPromotionDiscount())
{
result.Append("Promotions Discount: ");
result.AppendLine(PromotionDiscount.ToString());
}
if (IsSetPromotionIds())
{
if (PromotionIds.PromotionId != null)
{
foreach (string promotionId in PromotionIds.PromotionId)
{
result.Append("\tPromotion Id: ");
result.AppendLine(promotionId);
}
}
}
if (IsSetShippingDiscount())
{
result.Append("Shipping Discount: ");
result.AppendLine(ShippingDiscount.ToString());
}
if (IsSetQuantityOrdered())
{
result.Append("Quantity: ");
result.AppendLine(QuantityOrdered.ToString());
}
if (IsSetQuantityShipped())
{
result.Append("Quantity Shipped: ");
result.AppendLine(QuantityShipped.ToString());
}
if (IsSetCODFee())
{
result.Append("COD Fee: ");
result.AppendLine(CODFee.ToString());
}
if (IsSetCODFeeDiscount())
{
result.Append("COD Fee Discount: ");
result.AppendLine(CODFeeDiscount.ToString());
}
if (IsSetGiftMessageText())
{
result.Append("Gift Message Text: ");
result.AppendLine(GiftMessageText);
}
if (IsSetGiftWrapPrice())
{
result.Append("Gift Wrap Price: ");
result.AppendLine(GiftWrapPrice.ToString());
}
if (IsSetGiftWrapLevel())
{
result.Append("Gift Wrap Level: ");
result.AppendLine(GiftWrapLevel.ToString());
}
return(result.ToString());
}
public virtual void CreateBillItem(
DevExpress.Xpo.Session session,
Guid billId,
Guid itemId,
Guid unitId,
double quantity,
double price,
double promotionInPercentage,
string comment)
{
try
{
NAS.DAL.Invoice.Bill bill =
session.GetObjectByKey <NAS.DAL.Invoice.Bill>(billId);
if (bill == null)
{
throw new Exception("Could not found specific bill");
}
//Get ItemUnit
Item item = session.GetObjectByKey <Item>(itemId);
Unit unit = session.GetObjectByKey <Unit>(unitId);
ItemUnit itemUnit = session.FindObject <ItemUnit>(
CriteriaOperator.And(
new BinaryOperator("ItemId", item),
new BinaryOperator("UnitId", unit),
CriteriaOperator.Or(
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_DEFAULT)
)
));
if (itemUnit == null)
{
throw new Exception("Could not found item unit");
}
BillItem billItem = new BillItem(session)
{
BillId = bill,
Comment = comment,
//Currency
ItemUnitId = itemUnit,
Price = price,
PromotionInNumber = promotionInPercentage != -1
? (price * quantity * promotionInPercentage) / 100 : 0,
PromotionInPercentage = promotionInPercentage,
Quantity = quantity,
RowStatus = Utility.Constant.ROWSTATUS_ACTIVE,
TotalPrice = price * quantity
};
billItem.Save();
//update SumOfItemPrice
bill.SumOfItemPrice = bill.BillItems.Sum(r => r.TotalPrice);
bill.Save();
if (bill.PromotionCalculationType.Equals(Utility.Constant.CALCULATION_TYPE_ON_ITEMS))
{
UpdatePromotionOnItems(session, billId);
}
//Insert into BillItemTax...
//Get VAT TaxType of Item
ItemBO itemBO = new ItemBO();
ItemTax itemTax = itemBO.GetCurrentVATOfItem(session, itemId);
if (itemTax != null)
{
BillItemTax billItemTax = new BillItemTax(session)
{
BillItemId = billItem,
ItemTaxId = itemTax,
TaxInNumber = itemTax.TaxId.Amount,
TaxInPercentage = itemTax.TaxId.Percentage
};
billItemTax.Save();
}
UpdateSumOfTax(session, bill);
#region Update bill Total
bill.Total = bill.SumOfItemPrice - bill.SumOfPromotion + bill.SumOfTax;
bill.Save();
#endregion Update bill Total
}
catch (Exception ex)
{
throw;
}
}
