protected void Grid_ArtifactDetail_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
try
{
session.BeginTransaction();
e.Cancel = true;
string rowstatus = Utility.Constant.ROWSTATUS_ACTIVE.ToString();
LegalInvoiceArtifactDetail detail = session.FindObject <LegalInvoiceArtifactDetail>(
CriteriaOperator.And(
new BinaryOperator("LegalInvoiceArtifactId", LegalInvoiceArtifactId, BinaryOperatorType.Equal),
new BinaryOperator("ItemId", e.NewValues["ItemId"].ToString(), BinaryOperatorType.Equal),
new BinaryOperator("UnitId", e.NewValues["UnitId"].ToString(), BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", rowstatus, BinaryOperatorType.Equal)
));
Item itemid = BO.get_ItemId(session, e.NewValues["ItemId"].ToString(), rowstatus);
NAS.DAL.Nomenclature.Item.Unit unitid = BO.get_UnitId(session, e.NewValues["UnitId"].ToString(), rowstatus);
//detail.ItemId = itemid;
detail.Price = int.Parse(e.NewValues["Price"].ToString());
detail.Amount = int.Parse(e.NewValues["Amount"].ToString());
//detail.UnitId = unitid;
detail.Total = int.Parse(e.NewValues["Total"].ToString());
session.FlushChanges();
session.CommitTransaction();
Grid_ArtifactDetail.CancelEdit();
}
catch (Exception)
{
session.RollbackTransaction();
throw;
}
}
protected void Grid_ArtifactDetail_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
try
{
session.BeginTransaction();
e.Cancel = true;
string rowstatus = Utility.Constant.ROWSTATUS_ACTIVE.ToString();
NAS.DAL.Accounting.LegalInvoice.LegalInvoiceArtifact legalInvoiceArtifactId = BO.get_LegalInvoiceArtifactId(session, LegalInvoiceArtifactId, rowstatus);
LegalInvoiceArtifactDetail detail = new LegalInvoiceArtifactDetail(session);
Item itemid = BO.get_ItemId(session, itemId, rowstatus);
NAS.DAL.Nomenclature.Item.Unit unitid = BO.get_UnitId(session, unitID, rowstatus);
//detail.ItemId = itemid;
detail.Price = int.Parse(e.NewValues["Price"].ToString());
detail.Amount = int.Parse(e.NewValues["Amount"].ToString());
//detail.UnitId = unitid;
detail.Total = int.Parse(e.NewValues["Total"].ToString());
detail.RowStatus = Utility.Constant.ROWSTATUS_ACTIVE;
detail.LegalInvoiceArtifactId = legalInvoiceArtifactId;
session.FlushChanges();
session.CommitTransaction();
Grid_ArtifactDetail.CancelEdit();
}
catch (Exception)
{
session.RollbackTransaction();
throw;
}
}
List <string> get_Unit(string item)
{
List <string> list = new List <string>();
Item item_Id = session.FindObject <Item>(
CriteriaOperator.And(
new BinaryOperator("ItemId", item, BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.Equal)
));
if (item_Id == null)
{
throw new Exception("Item is not exist system");
}
XPCollection <ItemUnit> itemUnit = BO.get_xp_ItemUnit(session, item_Id.ItemId, Utility.Constant.ROWSTATUS_ACTIVE);
if (itemUnit != null)
{
foreach (ItemUnit itu in itemUnit)
{
NAS.DAL.Nomenclature.Item.Unit unit = BO.get_UnitId_1(session, itu.UnitId.UnitId, Utility.Constant.ROWSTATUS_ACTIVE);
list.Add(unit.Code);
}
}
return(list);
}
protected void Grid_ArtifactDetail_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
try
{
string[] param = e.Parameters.Split('|');
if (param[0].Equals("Item"))
{
if (param[1] != null)
{
Item item_Id = session.FindObject <Item>(
CriteriaOperator.And(
new BinaryOperator("Code", param[1], BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.Equal)
));
if (item_Id == null)
{
throw new Exception("Item is not exist system");
}
ItemUnit itemUnitId = BO.get_ItemUnit_UnitId(session, item_Id.ItemId, Utility.Constant.ROWSTATUS_ACTIVE);
itemId = item_Id.ItemId.ToString();
Session["UnitId"] = itemUnitId.UnitId.UnitId.ToString();
}
else
{
NAS.DAL.Nomenclature.Item.Unit u = session.FindObject <NAS.DAL.Nomenclature.Item.Unit>(new BinaryOperator("Name", "NAAN_DEFAULT", BinaryOperatorType.Equal));
Session["UnitId"] = u.UnitId.ToString();
}
}
if (param[0].Equals("Unit"))
{
if (param[1] != null)
{
NAS.DAL.Nomenclature.Item.Unit Unitid = session.FindObject <NAS.DAL.Nomenclature.Item.Unit>(
CriteriaOperator.And(
new BinaryOperator("Code", param[1].ToString(), BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.Equal)
));
unitID = Unitid.UnitId.ToString();
}
}
}
catch (Exception) { throw; }
}
protected void grdProductUnit_NodeInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
collectData();
e.NewValues["RowStatus"] = Constant.ROWSTATUS_ACTIVE;
e.NewValues["ItemId"] = currentItem;
NAS.DAL.Nomenclature.Item.Unit unit = session.FindObject <NAS.DAL.Nomenclature.Item.Unit>(new BinaryOperator("Code", e.NewValues["UnitId.Code"]));
if (unit != null)
{
e.NewValues["UnitId"] = unit;
}
ItemUnitRelationType itemUnitRType = session.FindObject <ItemUnitRelationType>(new BinaryOperator("Name", "UNIT"));
if (itemUnitRType != null)
{
e.NewValues["ItemUnitRelationTypeId"] = itemUnitRType;
}
e.NewValues["RowCreationTimeStamp"] = DateTime.Now;
treelstProductUnits.CancelEdit();
}
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.
}
}
protected void gridviewBillItem_CustomColumnDisplayText(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewColumnDisplayTextEventArgs e)
{
if (e.Column.FieldName.Equals("UnitId!Key"))
{
if (e.Value == null || e.Value == DBNull.Value)
{
return;
}
NAS.DAL.Nomenclature.Item.Unit unit =
session.GetObjectByKey <NAS.DAL.Nomenclature.Item.Unit>(e.Value);
e.DisplayText = String.Format("{0} - {1}", unit.Code, unit.Name);
}
else if (e.Column.FieldName.Equals("PromotionInPercentage"))
{
var billId = gridviewBillItem.GetRowValues(e.VisibleRowIndex, "BillId!Key");
if (billId == null)
{
return;
}
Bill bill = session.GetObjectByKey <Bill>(billId);
if (bill.PromotionCalculationType.Equals(Utility.Constant.CALCULATION_TYPE_ON_ITEMS))
{
if (e.Value == null || e.Value == DBNull.Value)
{
return;
}
double promotionInPercentage = (double)e.Value;
if (promotionInPercentage == -1)
{
e.DisplayText = "N/A";
}
else
{
e.DisplayText = promotionInPercentage.ToString();
}
}
else if (bill.PromotionCalculationType.Equals(Utility.Constant.CALCULATION_TYPE_ON_BILL_BY_AMOUNT) ||
bill.PromotionCalculationType.Equals(Utility.Constant.CALCULATION_TYPE_ON_BILL_BY_PERCENTAGE))
{
e.DisplayText = "N/A";
e.Column.CellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#EFEFEF");
}
}
else if (e.Column.Name.Equals("VATInPercentage"))
{
var val = gridviewBillItem.GetRowValues(e.VisibleRowIndex, "BillItemId");
if (val == null)
{
return;
}
BillItem billItem = session.GetObjectByKey <BillItem>(val);
BillItemTax billItemTax = billItem.BillItemTaxs.FirstOrDefault();
if (billItemTax != null)
{
e.DisplayText = billItemTax.TaxInPercentage.ToString();
}
else
{
e.DisplayText = "N/A";
}
}
}
protected void Grid_ArtifactDetail_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
try
{
string[] param = e.Parameters.Split('|');
ASPxComboBox cbo = sender as ASPxComboBox;
if (param[0].Equals("Item"))
{
if (param[1] != null)
{
// Item item_Id = session.FindObject<Item>(
// CriteriaOperator.And(
// new BinaryOperator("Code", param[1], BinaryOperatorType.Equal),
// new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.Equal)
// ));
// if (item_Id == null)
// throw new Exception("Item is not exist system");
// ItemUnit itemUnitId = BO.get_ItemUnit_UnitId(session, item_Id.ItemId, Utility.Constant.ROWSTATUS_ACTIVE);
// itemId = item_Id.ItemId.ToString();
// //Session["UnitId"] = itemUnitId.UnitId.UnitId.ToString();
//}
//else
//{
// NAS.DAL.Nomenclature.Item.Unit u = session.FindObject<NAS.DAL.Nomenclature.Item.Unit>(new BinaryOperator("Name", "NAAN_DEFAULT", BinaryOperatorType.Equal));
// Session["UnitId"] = u.UnitId.ToString();
//}
Item item_Id = session.FindObject <Item>(
CriteriaOperator.And(
new BinaryOperator("Code", param[1], BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.Equal)
));
if (item_Id == null)
{
throw new Exception("Item is not exist system");
}
XPCollection <ItemUnit> itemUnit = BO.get_xp_ItemUnit(session, item_Id.ItemId, Utility.Constant.ROWSTATUS_ACTIVE);
if (itemUnit != null)
{
foreach (ItemUnit itu in itemUnit)
{
//NAS.DAL.Nomenclature.Item.Unit unit = BO.get_UnitId_1(session, itu.UnitId.UnitId, Utility.Constant.ROWSTATUS_ACTIVE);
cbo.Items.Add(itu.UnitId.Code);
}
}
}
}
if (param[0].Equals("Unit"))
{
if (param[1] != null)
{
NAS.DAL.Nomenclature.Item.Unit Unitid = session.FindObject <NAS.DAL.Nomenclature.Item.Unit>(
CriteriaOperator.And(
new BinaryOperator("Code", param[1].ToString(), BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.Equal)
));
unitID = Unitid.UnitId.ToString();
}
}
}
catch (Exception) { throw; }
}
