public DayDim GetDayDim(Session session, string Name) { DayDim day = null; try { CriteriaOperator criteria = new BinaryOperator("Name", Name, BinaryOperatorType.Equal); day = session.FindObject <DayDim>(criteria); } catch (Exception) { throw; } return(day); }
public void CreatDayDim(Session session, string Name, string Description) { try { CriteriaOperator criteria = new BinaryOperator("Name", Name, BinaryOperatorType.Equal); DayDim day = session.FindObject <DayDim>(criteria); if (day == null) { day = new DayDim(session); day.Name = Name; day.Description = Description; day.RowStatus = Constant.ROWSTATUS_ACTIVE; day.Save(); } } catch (Exception) { throw; } }
public void CreateFinancialRevenueByItem(Session session, Guid _BillId, Guid _CustomerOrgId, Guid _OwnerOrgId, Item _Item, Unit _Unit, int Day, int Month, int Year, string _AssetDim) { FinancialRevenueByItem_Fact result = new FinancialRevenueByItem_Fact(session); try { SalesInvoice invoice = session.GetObjectByKey <SalesInvoice>(_BillId); if (!Util.IsExistXpoObject <InvoiceDim>(session, "RefId", _BillId)) { InvoiceDim invoiceDim = new InvoiceDim(session); invoiceDim.RefId = _BillId; invoiceDim.Code = invoice.Code; invoiceDim.Name = ""; invoiceDim.Description = ""; invoiceDim.IssueDate = invoice.IssuedDate; invoiceDim.RowStatus = Constant.ROWSTATUS_ACTIVE; invoiceDim.Save(); } if (!Util.IsExistXpoObject <DayDim>(session, "Name", Day.ToString())) { DayDim dayDim = new DayDim(session); dayDim.Description = Day.ToString(); dayDim.Name = Day.ToString(); dayDim.RowStatus = Constant.ROWSTATUS_ACTIVE; dayDim.Save(); } if (!Util.IsExistXpoObject <MonthDim>(session, "Name", Month.ToString())) { MonthDim MonthDim = new MonthDim(session); MonthDim.Description = Month.ToString(); MonthDim.Name = Month.ToString(); MonthDim.RowStatus = Constant.ROWSTATUS_ACTIVE; MonthDim.Save(); } if (!Util.IsExistXpoObject <YearDim>(session, "Name", Year.ToString())) { YearDim YearDim = new YearDim(session); YearDim.Description = Year.ToString(); YearDim.Name = Year.ToString(); YearDim.RowStatus = Constant.ROWSTATUS_ACTIVE; YearDim.Save(); } if (!Util.IsExistXpoObject <FinancialAssetDim>(session, "Name", _AssetDim)) { FinancialAssetDim assetDim = new FinancialAssetDim(session); assetDim.Name = _AssetDim; assetDim.Description = _AssetDim; assetDim.RowStatus = Constant.ROWSTATUS_ACTIVE; assetDim.Save(); } if (!Util.IsExistXpoObject <ItemDim>(session, "RefId", _Item.ItemId)) { ItemDim itemDim = new ItemDim(session); itemDim.RefId = _Item.ItemId; itemDim.Code = _Item.Code; itemDim.Name = _Item.Name; itemDim.Description = _Item.Description; itemDim.RowStatus = Constant.ROWSTATUS_ACTIVE; itemDim.Save(); } if (!Util.IsExistXpoObject <UnitDim>(session, "RefId", _Unit.UnitId)) { UnitDim unitDim = new UnitDim(session); unitDim.RefId = _Unit.UnitId; unitDim.Code = _Unit.Code; unitDim.Name = _Unit.Name; unitDim.Description = _Unit.Description; unitDim.RowStatus = Constant.ROWSTATUS_ACTIVE; unitDim.Save(); } if (!Util.IsExistXpoObject <CustomerOrgDim>(session, "RefId", _CustomerOrgId)) { Organization customerOrg = session.GetObjectByKey <Organization>(_CustomerOrgId); if (customerOrg != null) { CustomerOrgDim customerOrgDim = new CustomerOrgDim(session); customerOrgDim.RefId = _CustomerOrgId; customerOrgDim.Code = customerOrg.Code; customerOrgDim.Name = customerOrg.Name; customerOrgDim.Description = customerOrg.Description; customerOrgDim.RowStatus = Constant.ROWSTATUS_ACTIVE; customerOrgDim.Save(); } } if (!Util.IsExistXpoObject <OwnerOrgDim>(session, "RefId", _OwnerOrgId)) { Organization ownerOrg = session.GetObjectByKey <Organization>(_OwnerOrgId); if (ownerOrg != null) { OwnerOrgDim ownerOrgDim = new OwnerOrgDim(session); ownerOrgDim.RefId = _OwnerOrgId; ownerOrgDim.Code = ownerOrg.Code; ownerOrgDim.Name = ownerOrg.Name; ownerOrgDim.Description = ownerOrg.Description; ownerOrgDim.RowStatus = Constant.ROWSTATUS_ACTIVE; ownerOrgDim.Save(); } } Util util = new Util(); result.InvoiceDimId = util.GetXpoObjectByFieldName <InvoiceDim, Guid>(session, "RefId", _BillId, DevExpress.Data.Filtering.BinaryOperatorType.Equal); result.FinancialAssetDimId = Util.getXpoObjectByName <FinancialAssetDim>(session, _AssetDim); result.DayDimId = Util.getXpoObjectByName <DayDim>(session, Day.ToString()); result.MonthDimId = Util.getXpoObjectByName <MonthDim>(session, Month.ToString()); result.YearDimId = Util.getXpoObjectByName <YearDim>(session, Year.ToString()); result.ItemDimId = util.GetXpoObjectByFieldName <ItemDim, string>(session, "Code", _Item.Code, DevExpress.Data.Filtering.BinaryOperatorType.Equal); result.UnitDimId = util.GetXpoObjectByFieldName <UnitDim, string>(session, "Code", _Unit.Code, DevExpress.Data.Filtering.BinaryOperatorType.Equal); result.CustomerOrgDimId = util.GetXpoObjectByFieldName <CustomerOrgDim, Guid>(session, "RefId", _CustomerOrgId, DevExpress.Data.Filtering.BinaryOperatorType.Equal); result.OwnerOrgDimId = util.GetXpoObjectByFieldName <OwnerOrgDim, Guid>(session, "RefId", _OwnerOrgId, DevExpress.Data.Filtering.BinaryOperatorType.Equal); result.Save(); } catch (Exception) { } }
public bool CreatETLJobLog(Session session, Guid jobId, string StateName, string StatusName, DateTime date) { bool res = true; try { DateTime nowTime = date; string currentDay = nowTime.Day.ToString(); string currentMonth = nowTime.Month.ToString(); string currentYear = nowTime.Year.ToString(); string currentHour = nowTime.Hour.ToString(); string currentMinute = nowTime.Minute.ToString(); DayDim day = GetDayDim(session, currentDay); if (day == null) { return(false); } MonthDim month = GetMonthDim(session, currentMonth); if (month == null) { return(false); } YearDim year = GetYearDim(session, currentYear); if (year == null) { return(false); } HourDim hour = GetHourDim(session, currentHour); if (hour == null) { return(false); } MinuteDim minute = GetMinuteDim(session, currentMinute); if (minute == null) { return(false); } ETLJobRunningState state = GetETLJobRunningState(session, StateName); if (state == null) { return(false); } ETLJobRunningStatus status = GetETLJobRunningStatus(session, StatusName); if (status == null) { return(false); } ETLJob job = session.GetObjectByKey <ETLJob>(jobId); if (job == null) { return(false); } ETLJobLog etlJobLog = new ETLJobLog(session); etlJobLog.ETLJobId = job; etlJobLog.DayDimId = day; etlJobLog.MinuteDimId = minute; etlJobLog.MonthDimId = month; etlJobLog.YearDimId = year; etlJobLog.HourDimId = hour; etlJobLog.ETLJobRunningStateId = state; etlJobLog.ETLJobRunningStatusId = status; etlJobLog.Save(); } catch (Exception) { return(false); throw; } return(res); }