public override void ComboBoxItem_ItemsRequestedByFilterCondition(DevExpress.Xpo.Session session, object source, DevExpress.Web.ASPxEditors.ListEditItemsRequestedByFilterConditionEventArgs e)
{
ASPxComboBox combo = source as ASPxComboBox;
XPCollection <Item> collection = new XPCollection <Item>(session);
collection.SkipReturnedObjects = e.BeginIndex;
collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1;
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)
),
new ContainsOperator("ItemCustomTypes",
new BinaryOperator("ObjectTypeId", ObjectType.GetDefault(session, ObjectTypeEnum.FIXED_ASSETS)))
);
collection.Criteria = criteria;
collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending));
combo.DataSource = collection;
combo.DataBindItems();
}
public PaymentVouches CreateNewObject(Session session)
{
try
{
PaymentVouches paymentVouches = new PaymentVouches(session)
{
VouchesId = Guid.NewGuid(),
RowStatus = Utility.Constant.ROWSTATUS_TEMP
};
paymentVouches.Save();
ObjectBO objectBO = new ObjectBO();
NAS.DAL.CMS.ObjectDocument.Object CMSObject = objectBO.CreateCMSObject(session,
DAL.CMS.ObjectDocument.ObjectTypeEnum.VOUCHER_PAYMENT);
VoucherObject voucherObject = new VoucherObject(session)
{
ObjectId = CMSObject,
VoucherId = paymentVouches
};
voucherObject.Save();
VoucherCustomType voucherCustomType = new VoucherCustomType(session)
{
VoucherId = paymentVouches,
ObjectTypeId = ObjectType.GetDefault(session, ObjectTypeEnum.VOUCHER_PAYMENT)
};
voucherCustomType.Save();
return(paymentVouches);
}
catch (Exception ex)
{
throw;
}
finally
{
}
}
public NAS.DAL.CMS.ObjectDocument.Object CreateCMSObject(Session session,
ObjectTypeEnum type,
params ObjectCustomFieldOption[] options)
{
NAS.DAL.CMS.ObjectDocument.Object CMSObject = null;
try
{
//Get object type
NAS.DAL.CMS.ObjectDocument.ObjectType CMSObjectType = ObjectType.GetDefault(session, type);
//Create new CMS Object
CMSObject = new DAL.CMS.ObjectDocument.Object(session)
{
ObjectId = Guid.NewGuid(),
ObjectTypeId = CMSObjectType
};
CMSObject.Save();
foreach (var objectTypeCustomField in CMSObjectType.ObjectTypeCustomFields)
{
CustomFieldTypeFlag flag = CustomFieldTypeFlag.CUSTOM_FIELD_TYPE_DEFAULT;
if (options.Length > 0)
{
ObjectCustomFieldOption option =
options.Where(r => r.CustomFieldId == objectTypeCustomField.CustomFieldId.CustomFieldId).FirstOrDefault();
if (option != null)
{
flag = option.ObjectCustomFieldFlag;
}
}
AttachObjectCustomFieldWithDefaultValue(session, CMSObject, objectTypeCustomField, flag);
}
return(CMSObject);
}
catch (Exception)
{
throw;
}
}
protected void popManufacturerEdit_WindowCallback(object source, DevExpress.Web.ASPxPopupControl.PopupWindowCallbackArgs e)
{
string[] args = e.Parameter.Split('|');
switch (args[0])
{
case "new":
ManufacturerOrg tempManufacturerOrg = ManufacturerOrg.InitNewRow(session);
PrivateSession.Instance.ManufacturerOrgId = tempManufacturerOrg.OrganizationId;
frmManufacturerEdit.DataSourceID = "dsManufacturer";
dsManufacturer.CriteriaParameters["ManufacturerOrgId"].DefaultValue = PrivateSession.Instance.ManufacturerOrgId.ToString();
ClearForm();
//Get object id
//Bind data to gridview
#region add manufacturer
session.BeginTransaction();
try
{
//ObjectType
ObjectType objectType =
ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.MANUFACTURER);
// object
NAS.BO.CMS.ObjectDocument.ObjectBO objectBO = new NAS.BO.CMS.ObjectDocument.ObjectBO();
NAS.DAL.CMS.ObjectDocument.Object cmsobject =
objectBO.CreateCMSObject(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.MANUFACTURER);
// OrganizationObject
OrganizationObject organizatoinObject = new OrganizationObject(session)
{
ObjectId = cmsobject,
OrganizationId = tempManufacturerOrg
};
organizatoinObject.Save();
// OrganizationCustomType
OrganizationCustomType organizationCustomType = new OrganizationCustomType(session)
{
ObjectTypeId = objectType,
OrganizationId = tempManufacturerOrg
};
organizationCustomType.Save();
session.CommitTransaction();
}
catch
{
session.RollbackTransaction();
}
OrganizationObject organizationObject = tempManufacturerOrg.OrganizationObjects.FirstOrDefault();
grid_of_Manufacturer.CMSObjectId = organizationObject.ObjectId.ObjectId;
grid_of_Manufacturer.DataBind();
#endregion
//2013-11-22 Khoa.Truong DEL START
//gridviewCustomFields.CMSObjectId = CurrentManufacturerOrg.ObjectId.ObjectId;
//gridviewCustomFields.DataBind();
//2013-11-22 Khoa.Truong DEL END
break;
case "edit":
ClearForm();
frmManufacturerEdit.DataSourceID = "dsManufacturer";
if (args.Length > 1)
{
PrivateSession.Instance.ManufacturerOrgId = Guid.Parse(args[1]);
dsManufacturer.CriteriaParameters["ManufacturerOrgId"].DefaultValue = PrivateSession.Instance.ManufacturerOrgId.ToString();
txtCode.Text = CurrentManufacturerOrg.Code;
//Get object id
//Bind data to gridview
#region edit manufacturer
if (CurrentManufacturerOrg.OrganizationObjects.FirstOrDefault() == null)
{
session.BeginTransaction();
try
{
ObjectType objectType1 =
ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.MANUFACTURER);
// object
NAS.BO.CMS.ObjectDocument.ObjectBO objectBO1 = new NAS.BO.CMS.ObjectDocument.ObjectBO();
NAS.DAL.CMS.ObjectDocument.Object cmsobject1 =
objectBO1.CreateCMSObject(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.MANUFACTURER);
OrganizationObject organizatoinObject1 = new OrganizationObject(session)
{
ObjectId = cmsobject1,
OrganizationId = CurrentManufacturerOrg
};
organizatoinObject1.Save();
// OrganizationCustomType
OrganizationCustomType organizationCustomType1 = new OrganizationCustomType(session)
{
ObjectTypeId = objectType1,
OrganizationId = CurrentManufacturerOrg
};
organizationCustomType1.Save();
session.CommitTransaction();
}
catch (Exception)
{
session.RollbackTransaction();
throw;
}
OrganizationObject organizationObject1 = CurrentManufacturerOrg.OrganizationObjects.FirstOrDefault();
grid_of_Manufacturer.CMSObjectId = organizationObject1.ObjectId.ObjectId;
grid_of_Manufacturer.DataBind();
}
else
{
OrganizationObject organizationObject1 = CurrentManufacturerOrg.OrganizationObjects.FirstOrDefault();
grid_of_Manufacturer.CMSObjectId = organizationObject1.ObjectId.ObjectId;
grid_of_Manufacturer.DataBind();
}
#endregion
//2013-11-22 Khoa.Truong DEL START
//gridviewCustomFields.CMSObjectId = CurrentManufacturerOrg.ObjectId.ObjectId;
//gridviewCustomFields.DataBind();
//2013-11-22 Khoa.Truong DEL END
}
break;
case "save":
bool isSuccess = true;
string recordIdStr = null;
try
{
//Check validation
if (!ASPxEdit.AreEditorsValid(pagMunufacturer, true))
{
popManufacturerEdit.JSProperties.Add("cpInvalid", true);
pagMunufacturer.ActiveTabIndex = 0;
return;
}
//Logic to save data
if (args.Length > 1)
{
//Update mode
//Update general information
recordIdStr = args[1];
Guid recordId = Guid.Parse(recordIdStr);
ManufacturerOrg editManufacturerOrg =
session.GetObjectByKey <ManufacturerOrg>(PrivateSession.Instance.ManufacturerOrgId);
editManufacturerOrg.Code = txtCode.Text;
editManufacturerOrg.Name = txtName.Text;
editManufacturerOrg.RowStatus = short.Parse(cbRowStatus.SelectedItem.Value.ToString());
editManufacturerOrg.Save();
}
else
{
//Insert mode
ManufacturerOrg newManufacturerOrg =
session.GetObjectByKey <ManufacturerOrg>(PrivateSession.Instance.ManufacturerOrgId);
newManufacturerOrg.Code = txtCode.Text;
newManufacturerOrg.Name = txtName.Text;
newManufacturerOrg.RowStatus = short.Parse(cbRowStatus.SelectedItem.Value.ToString());
newManufacturerOrg.Save();
}
}
catch (Exception ex)
{
isSuccess = false;
throw;
}
finally
{
popManufacturerEdit.JSProperties.Add("cpCallbackArgs",
String.Format("{{ \"recordId\": \"{0}\", \"isSuccess\": {1} }}", recordIdStr, isSuccess.ToString().ToLower()));
}
break;
default:
break;
}
}
protected void popCustomerEdit_WindowCallback(object source, DevExpress.Web.ASPxPopupControl.PopupWindowCallbackArgs e)
{
string[] args = e.Parameter.Split('|');
switch (args[0])
{
case "new":
CustomerOrg tempCustomerOrg = CustomerOrg.InitNewRow(session);
PrivateSession.Instance.CustomerOrgId = tempCustomerOrg.OrganizationId;
dsCustomer.CriteriaParameters["CustomerOrgId"].DefaultValue = PrivateSession.Instance.CustomerOrgId.ToString();
ClearForm();
initLbCustomerTypeForAdding();
#region customer
session.BeginTransaction();
try
{
ObjectType objectType_cus =
ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.CUSTOMER);
NAS.BO.CMS.ObjectDocument.ObjectBO objectBO_cus = new NAS.BO.CMS.ObjectDocument.ObjectBO();
NAS.DAL.CMS.ObjectDocument.Object cmsObject_cus =
objectBO_cus.CreateCMSObject(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.CUSTOMER);
// OrganizationObject
OrganizationObject organizatoinObject_cus = new OrganizationObject(session)
{
ObjectId = cmsObject_cus,
OrganizationId = tempCustomerOrg
};
organizatoinObject_cus.Save();
// OrganizationCustomType
OrganizationCustomType organizationCustomType_cus = new OrganizationCustomType(session)
{
ObjectTypeId = objectType_cus,
OrganizationId = tempCustomerOrg
};
organizationCustomType_cus.Save();
session.CommitTransaction();
}
catch (Exception)
{
session.RollbackTransaction();
throw;
}
if (lbCustomerType.Items[0].Selected == true)
{
xCallbackPanel_customer.Visible = true;
ObjectType objectType_cus1 =
ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.CUSTOMER);
OrganizationObject organizationObject_sup = tempCustomerOrg.OrganizationObjects
.Where(r => r.ObjectId.ObjectTypeId == objectType_cus1).FirstOrDefault();
grid_customer.CMSObjectId = organizationObject_sup.ObjectId.ObjectId;
grid_customer.DataBind();
//grid_customer.CMSObjectId = cmsObject_cus.ObjectId;
//grid_customer.DataBind();
}
else
{
xCallbackPanel_customer.Visible = false;
}
#endregion
#region supplier
session.BeginTransaction();
try
{
ObjectType objectType_sup =
ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.SUPPLIER);
NAS.BO.CMS.ObjectDocument.ObjectBO objectBO_sup = new NAS.BO.CMS.ObjectDocument.ObjectBO();
NAS.DAL.CMS.ObjectDocument.Object cmsObject_sup =
objectBO_sup.CreateCMSObject(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.SUPPLIER);
// OrganizationObject
OrganizationObject organizatoinObject_sup = new OrganizationObject(session)
{
ObjectId = cmsObject_sup,
OrganizationId = tempCustomerOrg
};
organizatoinObject_sup.Save();
// OrganizationCustomType
OrganizationCustomType organizationCustomType_sup = new OrganizationCustomType(session)
{
ObjectTypeId = objectType_sup,
OrganizationId = tempCustomerOrg
};
organizationCustomType_sup.Save();
session.CommitTransaction();
}
catch (Exception)
{
session.RollbackTransaction();
throw;
}
if (lbCustomerType.Items[1].Selected == true)
{
xCallbackPanel_supplier.Visible = true;
ObjectType objectType_sup1 =
ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.SUPPLIER);
OrganizationObject organizationObject_sup = tempCustomerOrg.OrganizationObjects
.Where(r => r.ObjectId.ObjectTypeId == objectType_sup1).FirstOrDefault();
grid_supplier.CMSObjectId = organizationObject_sup.ObjectId.ObjectId;
grid_supplier.DataBind();
//grid_supplier.CMSObjectId = cmsObject_sup.ObjectId;
//grid_supplier.DataBind();
}
else
{
xCallbackPanel_supplier.Visible = false;
}
#endregion
break;
case "edit":
ClearForm();
if (args.Length > 1)
{
PrivateSession.Instance.CustomerOrgId = Guid.Parse(args[1]);
dsCustomer.CriteriaParameters["CustomerOrgId"].DefaultValue = PrivateSession.Instance.CustomerOrgId.ToString();
txtCode.Text = CurrentCustomerOrg.Code;
loadLbCustomerType();
if (CurrentCustomerOrg.OrganizationObjects.FirstOrDefault() == null)
{
#region customer
session.BeginTransaction();
try
{
ObjectType objectType_cus1 =
ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.CUSTOMER);
NAS.BO.CMS.ObjectDocument.ObjectBO objectBO_cus1 = new NAS.BO.CMS.ObjectDocument.ObjectBO();
NAS.DAL.CMS.ObjectDocument.Object cmsObject_cus1 =
objectBO_cus1.CreateCMSObject(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.CUSTOMER);
// OrganizationObject
OrganizationObject organizatoinObject_cus1 = new OrganizationObject(session)
{
ObjectId = cmsObject_cus1,
OrganizationId = CurrentCustomerOrg
};
organizatoinObject_cus1.Save();
// OrganizationCustomType
OrganizationCustomType organizationCustomType_cus1 = new OrganizationCustomType(session)
{
ObjectTypeId = objectType_cus1,
OrganizationId = CurrentCustomerOrg
};
organizationCustomType_cus1.Save();
session.CommitTransaction();
}
catch (Exception)
{
session.RollbackTransaction();
throw;
}
if (lbCustomerType.Items[0].Selected == true)
{
xCallbackPanel_customer.Visible = true;
ObjectType objectType_cus1 =
ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.CUSTOMER);
OrganizationObject organizationObject_sup = CurrentCustomerOrg.OrganizationObjects
.Where(r => r.ObjectId.ObjectTypeId == objectType_cus1).FirstOrDefault();
grid_customer.CMSObjectId = organizationObject_sup.ObjectId.ObjectId;
grid_customer.DataBind();
//grid_customer.CMSObjectId = cmsObject_cus1.ObjectId;
//grid_customer.DataBind();
}
else
{
xCallbackPanel_customer.Visible = false;
}
#endregion
#region supplier
session.BeginTransaction();
try
{
ObjectType objectType_sup1 =
ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.SUPPLIER);
NAS.BO.CMS.ObjectDocument.ObjectBO objectBO_sup1 = new NAS.BO.CMS.ObjectDocument.ObjectBO();
NAS.DAL.CMS.ObjectDocument.Object cmsObject_sup1 =
objectBO_sup1.CreateCMSObject(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.SUPPLIER);
// OrganizationObject
OrganizationObject organizatoinObject_sup1 = new OrganizationObject(session)
{
ObjectId = cmsObject_sup1,
OrganizationId = CurrentCustomerOrg
};
organizatoinObject_sup1.Save();
// OrganizationCustomType
OrganizationCustomType organizationCustomType_sup1 = new OrganizationCustomType(session)
{
ObjectTypeId = objectType_sup1,
OrganizationId = CurrentCustomerOrg
};
organizationCustomType_sup1.Save();
session.CommitTransaction();
}
catch (Exception)
{
session.RollbackTransaction();
throw;
}
if (lbCustomerType.Items[1].Selected == true)
{
xCallbackPanel_supplier.Visible = true;
ObjectType objectType_sup1 =
ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.SUPPLIER);
OrganizationObject organizationObject_sup = CurrentCustomerOrg.OrganizationObjects
.Where(r => r.ObjectId.ObjectTypeId == objectType_sup1).FirstOrDefault();
grid_supplier.CMSObjectId = organizationObject_sup.ObjectId.ObjectId;
grid_supplier.DataBind();
//grid_supplier.CMSObjectId = cmsObject_sup1.ObjectId;
//grid_supplier.DataBind();
}
else
{
xCallbackPanel_supplier.Visible = false;
}
#endregion
}
else
{
#region load customer data
if (lbCustomerType.Items[0].Selected == true)
{
xCallbackPanel_customer.Visible = true;
ObjectType objectType_cus1 =
ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.CUSTOMER);
OrganizationObject organizationObject_sup = CurrentCustomerOrg.OrganizationObjects
.Where(r => r.ObjectId.ObjectTypeId == objectType_cus1).FirstOrDefault();
grid_customer.CMSObjectId = organizationObject_sup.ObjectId.ObjectId;
grid_customer.DataBind();
}
else
{
xCallbackPanel_customer.Visible = false;
}
#endregion
#region load supplier data
if (lbCustomerType.Items[1].Selected == true)
{
xCallbackPanel_supplier.Visible = true;
ObjectType objectType_sup1 =
ObjectType.GetDefault(session, NAS.DAL.CMS.ObjectDocument.ObjectTypeEnum.SUPPLIER);
OrganizationObject organizationObject_sup = CurrentCustomerOrg.OrganizationObjects
.Where(r => r.ObjectId.ObjectTypeId == objectType_sup1).FirstOrDefault();
grid_supplier.CMSObjectId = organizationObject_sup.ObjectId.ObjectId;
grid_supplier.DataBind();
}
else
{
xCallbackPanel_supplier.Visible = false;
}
#endregion
}
}
break;
case "save":
bool isSuccess = true;
string recordIdStr = null;
try
{
session.BeginTransaction();
//Check validation
if (!IsSelectedLbType())
{
throw new Exception(String.Format("Phải chọn ít nhất một phân loại cho khách hàng"));
}
if (!ASPxEdit.AreEditorsValid(pagCustomer, true))
{
popCustomerEdit.JSProperties.Add("cpInvalid", true);
pagCustomer.ActiveTabIndex = 0;
return;
}
//Logic to save data
if (args.Length > 1)
{
//Update mode
//Update general information
recordIdStr = args[1];
Guid recordId = Guid.Parse(recordIdStr);
Organization editCustomerOrg =
session.GetObjectByKey <Organization>(PrivateSession.Instance.CustomerOrgId);
editCustomerOrg.Code = txtCode.Text;
editCustomerOrg.Name = txtName.Text;
editCustomerOrg.TaxNumber = txtTaxNumber.Text;
// Duc.Vo 10/09/2013 INS-START
editCustomerOrg.Address = txtAddress.Text;
// Duc.Vo 10/09/2013 INS-START
editCustomerOrg.RowStatus = short.Parse(cbRowStatus.SelectedItem.Value.ToString());
//----Duc.Vo 03/11/2013 INS -START
selectedObjectTypeId = new List <Guid>();
foreach (ListEditItem l in lbCustomerType.Items)
{
if (l.Selected)
{
selectedObjectTypeId.Add(Guid.Parse(l.Value.ToString()));
}
}
if (editCustomerOrg is SupplierOrg)
{
supplierBO.updateTradingCategoriesForObject <SupplierOrg>(session, recordId, selectedObjectTypeId);
}
else
{
supplierBO.updateTradingCategoriesForObject <CustomerOrg>(session, recordId, selectedObjectTypeId);
}
//----Duc.Vo 03/11/2013 INS -END
editCustomerOrg.Save();
session.CommitTransaction();
}
else
{
//Insert mode
CustomerOrg newCustomerOrg =
session.GetObjectByKey <CustomerOrg>(PrivateSession.Instance.CustomerOrgId);
newCustomerOrg.Code = txtCode.Text;
newCustomerOrg.Name = txtName.Text;
newCustomerOrg.TaxNumber = txtTaxNumber.Text;
// Duc.Vo 10/09/2013 INS-START
newCustomerOrg.Address = txtAddress.Text;
// Duc.Vo 10/09/2013 INS-START
newCustomerOrg.RowStatus = short.Parse(cbRowStatus.SelectedItem.Value.ToString());
newCustomerOrg.Save();
//----Duc.Vo 03/11/2013 INS -START
selectedObjectTypeId = new List <Guid>();
foreach (ListEditItem l in lbCustomerType.Items)
{
if (l.Selected)
{
selectedObjectTypeId.Add(Guid.Parse(l.Value.ToString()));
}
}
supplierBO.updateTradingCategoriesForObject <CustomerOrg>(session, newCustomerOrg.OrganizationId, selectedObjectTypeId);
//----Duc.Vo 03/11/2013 INS -END
session.CommitTransaction();
}
}
catch (Exception ex)
{
session.RollbackTransaction();
isSuccess = false;
throw;
}
finally
{
popCustomerEdit.JSProperties.Add("cpCallbackArgs",
String.Format("{{ \"recordId\": \"{0}\", \"isSuccess\": {1} }}", recordIdStr, isSuccess.ToString().ToLower()));
}
break;
default:
break;
}
}
