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