public static void Populate() { Session session = null; try { session = XpoHelper.GetNewSession(); //insert default data into CustomFieldType table if (!Util.isExistXpoObject <Currency>("Code", "NAAN_DEFAULT")) { Currency objectTypeBO = new Currency(session) { Code = "NAAN_DEFAULT", Name = "NAAN_DEFAULT", Description = "NAAN_DEFAULT", RowStatus = -1 }; objectTypeBO.Save(); } } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
protected void treelistCurrency_NodeDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { try { e.Cancel = true; session.BeginTransaction(); //tao session luu gia tri hien tai ASPxTreeList treelistCurrency = sender as ASPxTreeList; object keyValue = GetMasterRowKeyValue(treelistCurrency); #region Check ExchangeRate bool CanInsert = true; CurrencyType type = session.GetObjectByKey <CurrencyType>(keyValue); NAS.DAL.Accounting.Currency.Currency defaultCurrency = bo.get_Currency_true_master(session, type.CurrencyTypeId.ToString(), true, Constant.ROWSTATUS_ACTIVE); if (defaultCurrency != null) { if (bo.IsUsedInExchangeRate(session, defaultCurrency.CurrencyId)) { CanInsert = false; } } else { CanInsert = true; } if (!CanInsert) { throw new Exception(String.Format("Không được Xóa! Vì Đơn Vị Tiền Tệ {0} đã sử dụng trong Tỷ Giá", defaultCurrency.Code)); } #endregion Guid a = Guid.Parse(e.Keys[0].ToString()); NAS.DAL.Accounting.Currency.Currency curr = session.GetObjectByKey <NAS.DAL.Accounting.Currency.Currency>(a); curr.RowStatus = Utility.Constant.ROWSTATUS_DELETED; curr.Save(); session.CommitTransaction(); } catch (Exception) { session.RollbackTransaction();//loi session luu gia tri se rollback e.Cancel = true; throw; } }