protected void ASPxGridTax_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
e.Cancel = true;
Guid ItemTaxId = (Guid)e.Keys[0];
if (ItemTaxId != null)
{
NAS.DAL.Nomenclature.Item.ItemTax itemtax = session.GetObjectByKey <NAS.DAL.Nomenclature.Item.ItemTax>(ItemTaxId);
itemtax.RowStatus = Utility.Constant.ROWSTATUS_DELETED;
itemtax.Save();
//ASPxGridTax.DataBind();
}
}
private void PopulateDefaultTaxForAllItems()
{
using (Session session = XpoHelper.GetNewSession())
{
XPCollection <Item> itemList = new XPCollection <Item>(session,
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE));
//TaxType VATTaxType = session.FindObject<TaxType>(new BinaryOperator("Code", "GTGT"));
TaxType VATTaxType = session.FindObject <TaxType>(new BinaryOperator("Code", "VAT"));
CriteriaOperator defaultTaxCriteria = CriteriaOperator.And(
new BinaryOperator("Percentage", "5"),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE),
new BinaryOperator("TaxTypeId", VATTaxType)
);
//Get default Tax
Tax defaultTax = session.FindObject <Tax>(defaultTaxCriteria);
if (defaultTax == null)
{
throw new Exception("Could not found default tax");
}
foreach (var item in itemList)
{
int countExistDefaultTax =
item.ItemTaxes.Count(r =>
(r.TaxId != null &&
r.TaxId.TaxTypeId == VATTaxType) &&
r.RowStatus == Utility.Constant.ROWSTATUS_ACTIVE);
if (countExistDefaultTax != 0)
{
continue;
}
NAS.DAL.Nomenclature.Item.ItemTax itemTax = new NAS.DAL.Nomenclature.Item.ItemTax(session)
{
ItemId = item,
RowStatus = Utility.Constant.ROWSTATUS_ACTIVE,
TaxId = defaultTax
};
itemTax.Save();
}
}
}
private bool checkIsDupplicateTax()
{
Session session = XpoHelper.GetNewSession();
if (TaxId != null && ItemId != null)
{
CriteriaOperator criteria = CriteriaOperator.And(
new BinaryOperator("TaxId!Key", TaxId.TaxId),
new BinaryOperator("ItemId!Key", ItemId.ItemId));
ItemTax obj = session.FindObject <ItemTax>(criteria);
if (obj != null)
{
return(true);
}
}
return(false);
}
