public FinancialSupplierLiabilitySummary_Fact GetFinnancialSupplierLiabilitySummaryFact(
Session session,
Guid OwnerOrgId,
Guid SupplierOrgId,
DateTime IssueDate,
string FinancialAccountCode)
{
FinancialSupplierLiabilitySummary_Fact result = null;
try
{
Util util = new Util();
OwnerOrgDim ownerOrgDim = util.GetXpoObjectByFieldName <OwnerOrgDim, Guid>(session, "RefId", OwnerOrgId, BinaryOperatorType.Equal);
SupplierOrgDim supplierOrgDim = util.GetXpoObjectByFieldName <SupplierOrgDim, Guid>(session, "RefId", SupplierOrgId, BinaryOperatorType.Equal);
MonthDim monthDim = util.GetXpoObjectByFieldName <MonthDim, string>(session, "Name", IssueDate.Month.ToString(), BinaryOperatorType.Equal);
YearDim yearDim = util.GetXpoObjectByFieldName <YearDim, string>(session, "Name", IssueDate.Year.ToString(), BinaryOperatorType.Equal);
FinancialAccountDim financialAccountDim = util.GetXpoObjectByFieldName <FinancialAccountDim, string>(session, "Code", FinancialAccountCode, BinaryOperatorType.Equal);
if (ownerOrgDim == null || supplierOrgDim == null || monthDim == null || yearDim == null || financialAccountDim == null)
{
return(null);
}
else
{
FinancialSupplierLiabilitySummary_Fact a = null;
CriteriaOperator criteria_RowStatus = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.GreaterOrEqual);
CriteriaOperator criteria_OwnerOrg = new BinaryOperator("OwnerOrgDimId", ownerOrgDim, BinaryOperatorType.Equal);
CriteriaOperator criteria_SupplierOrg = new BinaryOperator("SupplierOrgDimId", supplierOrgDim, BinaryOperatorType.Equal);
CriteriaOperator criteria_Month = new BinaryOperator("MonthDimId", monthDim, BinaryOperatorType.Equal);
CriteriaOperator criteria_Year = new BinaryOperator("YearDimId", yearDim, BinaryOperatorType.Equal);
CriteriaOperator criteria_AccountCode = new BinaryOperator("FinancialAccountDimId", financialAccountDim, BinaryOperatorType.Equal);
CriteriaOperator criteria = CriteriaOperator.And(criteria_RowStatus, criteria_OwnerOrg, criteria_SupplierOrg, criteria_Month, criteria_Year, criteria_AccountCode);
FinancialSupplierLiabilitySummary_Fact fact = session.FindObject <FinancialSupplierLiabilitySummary_Fact>(criteria);
if (fact == null)
{
return(null);
}
{
result = fact;
}
}
}
catch (Exception)
{
return(result);
}
return(result);
}
public SupplierOrgDim GetSupplierOrgDim(Session session, Guid RefId)
{
try
{
CriteriaOperator criteria_RowStaus = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.Equal);
CriteriaOperator criteria_RefId = new BinaryOperator("RefId", RefId, BinaryOperatorType.Equal);
CriteriaOperator criteria = CriteriaOperator.And(criteria_RefId, criteria_RowStaus);
SupplierOrgDim supplierOrgDim = session.FindObject <SupplierOrgDim>(criteria);
if (supplierOrgDim == null)
{
return(CreateSupplierOrgDim(session, RefId));
}
return(supplierOrgDim);
}
catch
{
return(null);
}
}
public SupplierOrgDim CreateSupplierOrgDim(Session session, Guid RefId)
{
try
{
Organization supplierOrg = session.GetObjectByKey <Organization>(RefId);
if (supplierOrg == null)
{
return(null);
}
SupplierOrgDim supplierOrgDim = new SupplierOrgDim(session);
supplierOrgDim.Code = supplierOrg.Code;
supplierOrgDim.Description = supplierOrg.Description;
supplierOrgDim.RefId = RefId;
supplierOrgDim.Name = supplierOrg.Name;
supplierOrgDim.RowStatus = Constant.ROWSTATUS_ACTIVE;
supplierOrgDim.Save();
return(supplierOrgDim);
}
catch (Exception)
{
return(null);
}
}
