public static void DeleteLogical(Guid customerOrgId)
{
Session session = null;
try
{
session = XpoHelper.GetNewSession();
//Finds ManufacturerOrg by Id
NAS.DAL.Nomenclature.Organization.Organization customerOrg = session.GetObjectByKey <NAS.DAL.Nomenclature.Organization.Organization>(customerOrgId);
//Check foreign key constraint with Item table
//var itemList = customerOrg.;
//if (itemList.Count() > 0)
//{
// string param0 = supplierOrg.Name;
// string param1 = itemList.First().ItemId.Name;
// throw new Exception(String.Format("Nhà cung cấp '{0}' đang được cấu hình trong hàng hóa '{1}'", param0, param1));
//}
customerOrg.RowStatus = Utility.Constant.ROWSTATUS_DELETED;
customerOrg.Save();
}
catch (Exception)
{
throw;
}
finally
{
if (session != null)
{
session.Dispose();
}
}
}
public List <Person> getAllPeopleInOrganization(Session session, Guid OrganizationId)
{
List <Person> rs = new List <Person>();
NAS.DAL.Nomenclature.Organization.Organization o = session.GetObjectByKey <NAS.DAL.Nomenclature.Organization.Organization>(OrganizationId);
if (o == null)
{
throw new Exception("The key is not exist in Organization");
}
if (o.Deparments == null || o.Deparments.Count == 0)
{
return(null);
}
foreach (Department d in o.Deparments)
{
List <Person> lst = getAllPeopleInDepartments(session, d);
foreach (Person p in lst)
{
if (!rs.Contains <Person>(p))
{
rs.Add(p);
}
}
}
return(rs);
}
protected void tList_Organization_CustomCallback(object sender, TreeListCustomCallbackEventArgs e)
{
string[] para = e.Argument.Split('|');
if (para[0] == "Delete")
{
Guid organId = Guid.Parse(para[1]);
NAS.DAL.Nomenclature.Organization.Organization organ = session.GetObjectByKey <NAS.DAL.Nomenclature.Organization.Organization>(organId);
organ.RowStatus = Constant.ROWSTATUS_DELETED;
organ.Save();
tList_Organization.JSProperties.Add("cpRefresh", "Refresh");
}
tList_Organization.DataBind();
}
protected void cboSupplierColumn_OnItemRequestedByValue_SQL(object source, ListEditItemRequestedByValueEventArgs e)
{
ASPxComboBox comboBox = (ASPxComboBox)source;
//2013-11-03 ERP-872 Khoa.Truong MOD START
//NAS.DAL.Nomenclature.Organization.SupplierOrg obj = session.GetObjectByKey<NAS.DAL.Nomenclature.Organization.SupplierOrg>(e.Value);
NAS.DAL.Nomenclature.Organization.Organization obj = session.GetObjectByKey <NAS.DAL.Nomenclature.Organization.Organization>(e.Value);
if (obj != null)
{
comboBox.DataSource = new NAS.DAL.Nomenclature.Organization.Organization[] { obj };
comboBox.DataBindItems();
}
//2013-11-03 ERP-872 Khoa.Truong MOD END
}
protected void tList_Organization_NodeValidating(object sender, DevExpress.Web.ASPxTreeList.TreeListNodeValidationEventArgs e)
{
ASPxTreeList tree = (ASPxTreeList)sender;
string organizationCode = e.NewValues["Code"].ToString();
//New mode
if (tree.IsNewNodeEditing)
{
bool isExist = Util.isExistXpoObject <NAS.DAL.Nomenclature.Organization.Organization>("Code", organizationCode,
Constant.ROWSTATUS_ACTIVE, Constant.ROWSTATUS_DEFAULT, Constant.ROWSTATUS_INACTIVE);
if (isExist)
{
CriteriaOperator criteria = new BinaryOperator("Code", organizationCode, BinaryOperatorType.Equal);
NAS.DAL.Nomenclature.Organization.Organization organ = session.FindObject <NAS.DAL.Nomenclature.Organization.Organization>(criteria);
short rowstatus = organ.RowStatus;
if (rowstatus > 0)
{
Utility.Helpers.AddErrorToTreeListNode(e.Errors, "Code", "Mã tổ chức đã tồn tại");
}
}
}
//Edit mode
else
{
if (tree.IsEditing)
{
if (e.NewValues["Code"].ToString().Trim() != e.OldValues["Code"].ToString().Trim())
{
bool isExist = Util.isExistXpoObject <NAS.DAL.Nomenclature.Organization.Organization>("Code", organizationCode,
Constant.ROWSTATUS_ACTIVE, Constant.ROWSTATUS_DEFAULT, Constant.ROWSTATUS_INACTIVE);
if (isExist)
{
CriteriaOperator criteria = new BinaryOperator("Code", organizationCode, BinaryOperatorType.Equal);
NAS.DAL.Nomenclature.Organization.Organization organ = session.FindObject <NAS.DAL.Nomenclature.Organization.Organization>(criteria);
short rowstatus = organ.RowStatus;
if (rowstatus > 0)
{
Utility.Helpers.AddErrorToTreeListNode(e.Errors, "Code", "Mã tổ chức đã tồn tại");
}
}
}
}
}
}
public NAS.DAL.Nomenclature.Organization.Organization GetAllocatedCustomerByManualTransaction(Session session, Guid manualBookingTransactionId)
{
NAS.DAL.Nomenclature.Organization.Organization ret = null;
try
{
Transaction transaction =
session.GetObjectByKey <Transaction>(manualBookingTransactionId);
TransactionObject transactionObject = transaction.TransactionObjects.First();
if (transactionObject == null)
{
return(null);
}
ObjectTypeCustomField objectTypeCustomField =
ObjectTypeCustomField.GetDefault(session, DefaultObjectTypeCustomFieldEnum.MANUAL_BOOKING_CUSTOMER);
ObjectCustomField objectCustomField = transactionObject.ObjectId.ObjectCustomFields.Where(
r => r.ObjectTypeCustomFieldId.ObjectTypeCustomFieldId ==
objectTypeCustomField.ObjectTypeCustomFieldId).FirstOrDefault();
if (objectCustomField == null)
{
return(null);
}
ObjectCustomFieldData objectCustomFieldData =
objectCustomField.ObjectCustomFieldDatas.FirstOrDefault();
if (objectCustomFieldData == null)
{
return(null);
}
PredefinitionData predefinitionData =
(PredefinitionData)objectCustomFieldData.CustomFieldDataId;
ret = session.GetObjectByKey <NAS.DAL.Nomenclature.Organization.Organization>(predefinitionData.RefId);
return(ret);
}
catch (Exception)
{
return(null);
}
}
public bool OrganizationEditting_PreTransitionCRUD(string transition)
{
switch (transition)
{
case "Save":
if (!ASPxEdit.AreEditorsValid(popup_Organization))
{
return(false);
}
// Update data
NAS.DAL.Nomenclature.Organization.Organization org = session.GetObjectByKey <NAS.DAL.Nomenclature.Organization.Organization>(OrganizationId);
//org.Name = txt_TenTo
//Chuc.Text;
org.Code = txt_MaToChuc.Text;
org.TaxNumber = txt_MaSoThue.Text;
org.Address = txt_DiaChi.Text;
org.Description = txt_MoTa.Text;
session.Save(org);
break;
}
return(true);
}
public bool OrganizationCreating_PreTransitionCRUD(string transition)
{
switch (transition)
{
case "Save":
if (!ASPxEdit.AreEditorsValid(popup_Organization))
{
return(false);
}
// Insert data
NAS.DAL.Nomenclature.Organization.Organization org = new NAS.DAL.Nomenclature.Organization.Organization(session)
{
OrganizationId = Guid.NewGuid(),
Name = txt_TenToChuc.Text,
Code = txt_MaToChuc.Text,
Address = txt_DiaChi.Text,
TaxNumber = txt_MaSoThue.Text,
Description = txt_MoTa.Text,
RowCreationTimeStamp = DateTime.Now,
RowStatus = Utility.Constant.ROWSTATUS_ACTIVE
};
org.OrganizationTypeId = Util.getXPCollection <OrganizationType>(session, "Name", OrganizationTypeConstant.NAAN_CUSTOMER_SUB_ORGANIZATION.Value).FirstOrDefault();
org.ParentOrganizationId = Util.getXPCollection <NAS.DAL.Nomenclature.Organization.Organization>(session, "OrganizationId", ParentOrganizationId).FirstOrDefault();
if (org.ParentOrganizationId == null)
{
NAS.DAL.Nomenclature.Organization.Organization Rootorg = session.FindObject <NAS.DAL.Nomenclature.Organization.Organization>(
new BinaryOperator("Code", "QUASAPHARCO", BinaryOperatorType.Equal));
org.ParentOrganizationId = Rootorg;
}
session.Save(org);
OrganizationId = org.OrganizationId;
return(true);
}
return(false);
}