private void SetCriteriaForOrganization()
{
//Get CUSTOMER trading type
TradingCategory customerTradingCategory =
NAS.DAL.Util.getXPCollection <TradingCategory>(session, "Code", "CUSTOMER").FirstOrDefault();
//Get SUPPLIER trading type
TradingCategory supplierTradingCategory =
NAS.DAL.Util.getXPCollection <TradingCategory>(session, "Code", "SUPPLIER").FirstOrDefault();
CriteriaOperator criteria = CriteriaOperator.And(
CriteriaOperator.Or(
new ContainsOperator("OrganizationCategories",
CriteriaOperator.And(
new BinaryOperator("TradingCategoryId.TradingCategoryId", customerTradingCategory.TradingCategoryId),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE)
)
),
new ContainsOperator("OrganizationCategories",
CriteriaOperator.And(
new BinaryOperator("TradingCategoryId.TradingCategoryId", supplierTradingCategory.TradingCategoryId),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE)
)
)
),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE)
);
dsSourceOrg.Criteria = criteria.ToString();
cbSourceOrganization.DataBindItems();
}
public void updateTradingCategoriesForObject <T>(Session session, Guid supplierId, List <Guid> typeList)
{
try
{
T s = session.GetObjectByKey <T>(supplierId);
if (s == null)
{
throw new Exception("Key is not Exist in Org");
}
CriteriaOperator criteria =
new BinaryOperator("OrganizationId!Key", supplierId, BinaryOperatorType.Equal);
XPCollection <OrganizationCategory> ocl = new XPCollection <OrganizationCategory>(session, criteria);
foreach (OrganizationCategory oc in ocl)
{
oc.RowStatus = Utility.Constant.ROWSTATUS_DELETED;
oc.Save();
}
foreach (Guid k in typeList)
{
TradingCategory tc = session.GetObjectByKey <TradingCategory>(k);
if (tc == null)
{
throw new Exception("Key is not Exist in TradingCategory");
}
criteria = CriteriaOperator.And(
new BinaryOperator("OrganizationId", s, BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", 0, BinaryOperatorType.Greater),
new BinaryOperator("TradingCategoryId", tc, BinaryOperatorType.Greater)
);
OrganizationCategory oc = session.FindObject <OrganizationCategory>(criteria);
if (oc == null)
{
oc = new OrganizationCategory(session);
oc.RowStatus = Utility.Constant.ROWSTATUS_ACTIVE;
oc.OrganizationId = s as DAL.Nomenclature.Organization.Organization;
oc.TradingCategoryId = tc;
oc.Save();
}
else
{
oc.TradingCategoryId = tc;
oc.RowStatus = Utility.Constant.ROWSTATUS_ACTIVE;
oc.Save();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void cboSourceOrganization_ItemsRequestedByFilterCondition(object source, DevExpress.Web.ASPxEditors.ListEditItemsRequestedByFilterConditionEventArgs e)
{
XPCollection <Organization> collection = new XPCollection <Organization>(session);
collection.SkipReturnedObjects = e.BeginIndex;
collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1;
//Get CUSTOMER trading type
TradingCategory customerTradingCategory =
session.FindObject <TradingCategory>(new BinaryOperator("Code", "CUSTOMER"));
//Get SUPPLIER trading type
TradingCategory supplierTradingCategory =
session.FindObject <TradingCategory>(new BinaryOperator("Code", "SUPPLIER"));
CriteriaOperator criteria = CriteriaOperator.And(
//row status is active
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE),
CriteriaOperator.Or(
//find code contains the filter
new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like),
//find name contains the filter
new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like)
),
//find customer and supplier
CriteriaOperator.Or(
new ContainsOperator("OrganizationCategories",
CriteriaOperator.And(
new BinaryOperator("TradingCategoryId.TradingCategoryId", customerTradingCategory.TradingCategoryId),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE)
)
),
new ContainsOperator("OrganizationCategories",
CriteriaOperator.And(
new BinaryOperator("TradingCategoryId.TradingCategoryId", supplierTradingCategory.TradingCategoryId),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE)
)
)
)
);
collection.Criteria = criteria;
collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending));
cboSourceOrganization.DataSource = collection;
cboSourceOrganization.DataBindItems();
}
public override void InitXpoDatasource(XpoDataSource datasource)
{
Session session = null;
try
{
session = XpoHelper.GetNewSession();
//Set TypeName
datasource.TypeName = typeof(NAS.DAL.Nomenclature.Organization.Organization).FullName;
//Set Criteria
//Get CUSTOMER trading type
TradingCategory customerTradingCategory =
session.FindObject <TradingCategory>(new BinaryOperator("Code", "CUSTOMER"));
CriteriaOperator criteria = CriteriaOperator.And(
//row status is active
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE),
//find customer and customer
new ContainsOperator("OrganizationCategories",
CriteriaOperator.And(
new BinaryOperator("TradingCategoryId.TradingCategoryId",
customerTradingCategory.TradingCategoryId),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE)
)
)
);
datasource.Criteria = criteria.ToString();
datasource.DefaultSorting = "Code";
}
catch (Exception)
{
throw;
}
finally
{
if (session != null)
{
session.Dispose();
}
}
}
protected void cboSupplierColumn_OnItemsRequestedByFilterCondition_SQL(object source, ListEditItemsRequestedByFilterConditionEventArgs e)
{
ASPxComboBox comboBox = (ASPxComboBox)source;
//if (comboBox.IsCallback) {
//Get SUPPLIER trading type
//2013-11-03 ERP-872 Khoa.Truong MOD START
TradingCategory supplierTradingCategory =
NAS.DAL.Util.getXPCollection <TradingCategory>(session, "Code", "SUPPLIER").FirstOrDefault();
//XPCollection<NAS.DAL.Nomenclature.Organization.SupplierOrg> collection = new XPCollection<NAS.DAL.Nomenclature.Organization.SupplierOrg>(session);
XPCollection <NAS.DAL.Nomenclature.Organization.Organization> collection = new XPCollection <NAS.DAL.Nomenclature.Organization.Organization>(session);
collection.SkipReturnedObjects = e.BeginIndex;
collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1;
//collection.Criteria = CriteriaOperator.Or(
// new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like),
// new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like)
//);
collection.Criteria = CriteriaOperator.And(
CriteriaOperator.Or(
new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like),
new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like)
),
new ContainsOperator("OrganizationCategories",
CriteriaOperator.And(
new BinaryOperator("TradingCategoryId.TradingCategoryId", supplierTradingCategory.TradingCategoryId),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE)
)
),
new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE)
);
//2013-11-03 ERP-872 Khoa.Truong MOD END
collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending));
comboBox.DataSource = collection;
comboBox.DataBindItems();
//}
}
/// <summary>
/// Populate default data to database
/// </summary>
public static void Populate()
{
try
{
////NAS.DAL.Accounting.AccountChart
NAS.DAL.BI.Accounting.Account.CorrespondFinancialAccountDim.Populate();
NAS.DAL.BI.Accounting.Account.FinancialAccountDim.Populate();
Account.Populate();
AccountType.Populate();
AccountCategory.Populate();
Currency.Populate();
////NAS.DAL.Accounting.Configure
AllocationType.Populate();
////NAS.DAL.CMS.ObjectDocument
ObjectType.Populate();
CustomFieldType.Populate();
ObjectTypeCustomField.Populate();
////NAS.DAL.Inventory.Item
RecordedType.Populate();
////NAS.DAL.Inventory.Operation
CommanderStockCartStatus.Populate();
CommanderStockCartType.Populate();
////NAS.DAL.Inventory.StockCart
StockCartActorType.Populate();
////NAS.DAL.Invoice
TaxType.Populate();
PromotionType.Populate();
////NAS.DAL.Nomenclature.Inventory
Nomenclature.Inventory.Inventory.Populate();
InventoryUnit.Populate();
////NAS.DAL.Nomenclature.Item
ItemUnitRelationType.Populate();
UnitType.Populate();
Unit.Populate();
ItemUnit.Populate();
ItemTradingType.Populate();
ItemCustomType.Populate();
////NAS.DAL.Nomenclature.Organization
TradingCategory.Populate();
AuthenticationProvider.Populate();
DepartmentType.Populate();
OrganizationType.Populate();
Person.Populate();
Organization.Populate();
OwnerOrg.Populate();
CustomerOrg.Populate();
SupplierOrg.Populate();
ManufacturerOrg.Populate();
Department.Populate();
DepartmentPerson.Populate();
//NAS.DAL.Staging.Accounting.Journal
AccountActorType.Populate();
////NAS.DAL.Vouches
VouchesType.Populate();
VouchesActorType.Populate();
ReceiptVouchesType.Populate();
PaymentVouchesType.Populate();
ForeignCurrency.Populate();
////NAS.DAL.Accounting.Journal
AccountingPeriod.Populate();
//SalesInvoicePickingStockCart.Populate();
////NAS.DAL.System.ArtifactCode
ArtifactType.Populate();
CodeRuleDataType.Populate();
CodeRuleDataFormat.Populate();
RuleRepeaterType.Populate();
//NAS.DAL.Sales.Price
PricePolicyType.Populate();
//NAS.DAL.Inventory.Lot.Lot
NAS.DAL.Inventory.Lot.Lot.Populate();
//NAS.DAL.Inventory.Command.InventoryCommandActorType
NAS.DAL.Inventory.Command.InventoryCommandActorType.Populate();
NAS.DAL.BI.Inventory.InventoryCommandDim.Populate();
#region Other populate
using (Session session = XpoHelper.GetNewSession())
{
//Insert undefined supplier
if (!Util.isExistXpoObject <SupplierOrg>("OrganizationId",
Guid.Parse("3DEF2B62-2162-46CD-8418-DEE6F8E59E21")))
{
SupplierOrg undefinedSupplierOrg = new SupplierOrg(session)
{
OrganizationId = Guid.Parse("3DEF2B62-2162-46CD-8418-DEE6F8E59E21"),
Name = "Mặc định",
Description = "Mặc định",
Code = "MACDINH",
RowCreationTimeStamp = DateTime.Now,
RowStatus = Constant.ROWSTATUS_ACTIVE,
OrganizationTypeId =
NAS.DAL.Util.getDefaultXpoObject <OrganizationType>(session)
};
undefinedSupplierOrg.Save();
}
}
#endregion
}
catch (Exception)
{
throw new Exception("Populate failed");
}
finally
{
}
}