public void Dispose()
 {
     if (objectSpace != null)
     {
         objectSpace.Dispose();
         objectSpace = null;
     }
 }
Exemplo n.º 2
0
 protected override void OnDeactivated()
 {
     base.OnDeactivated();
     _objectSpace.Dispose();
     SchedulerStorage.Instance.AppointmentChanging -= SchedulerStorageAppointmentChanging;
     SchedulerStorage.Instance.ReminderAlert       -= ShowReminderAlerts;
 }
Exemplo n.º 3
0
        public bool GetCurrentUserViewPriceStatus()
        {
            bool         rtn  = false;
            IObjectSpace ios  = Application.CreateObjectSpace();
            SystemUsers  user = null;

            if (!string.IsNullOrEmpty(SecuritySystem.CurrentUserId.ToString()))
            {
                user = ios.GetObjectByKey <SystemUsers>(SecuritySystem.CurrentUserId);
            }
            if (user != null)
            {
                string   temp      = View.ObjectTypeInfo.Type.ToString();
                string[] classname = temp.Split('.');
                temp = classname[classname.Length - 1];
                //temp = temp.Replace("Ajiya.Module.BusinessObjects.", "");
                temp = temp.Replace("Detail", "");
                rtn  = user.CheckAccessVP(temp);
                //if (user.Roles.Where(p => p.Name == "C_" + temp + GeneralValues.viewpricestring).Count() > 0)
                //    rtn = true;

                //if (!rtn)
                //    rtn = user.Roles.Where(p => p.IsAdministrative).Count() > 0 ? true : false;
            }
            ios.Dispose();
            return(rtn);
        }
        private void ShowInPlaceReportAction_Execute(object sender, SingleChoiceActionExecuteEventArgs e)
        {
            if (checkObjectType())
            {
                IList <int> oids       = new List <int>();
                string      reportname = e.SelectedChoiceActionItem.Data.ToString();

                if (typeof(ClassDocument).IsAssignableFrom(View.ObjectTypeInfo.Type))
                {
                    if (View is ListView)
                    {
                        foreach (ClassDocument dtl in View.SelectedObjects)
                        {
                            oids.Add(dtl.Oid);
                        }
                    }
                    else if (View is DetailView)
                    {
                        oids.Add(((ClassDocument)View.CurrentObject).Oid);
                    }
                }
                else if (typeof(ClassStockTransferDocument).IsAssignableFrom(View.ObjectTypeInfo.Type))
                {
                    if (View is ListView)
                    {
                        foreach (ClassStockTransferDocument dtl in View.SelectedObjects)
                        {
                            oids.Add(dtl.Oid);
                        }
                    }
                    else if (View is DetailView)
                    {
                        oids.Add(((ClassStockTransferDocument)View.CurrentObject).Oid);
                    }
                }

                if (oids.Count > 0)
                {
                    string temp = "";
                    foreach (int dtl in oids)
                    {
                        if (temp == "")
                        {
                            temp = dtl.ToString();
                        }
                        else
                        {
                            temp += "," + dtl.ToString();
                        }
                    }
                    IObjectSpace  objectSpace = ReportDataProvider.ReportObjectSpaceProvider.CreateObjectSpace(typeof(ReportDataV2));
                    IReportDataV2 reportData  = objectSpace.FindObject <ReportDataV2>(CriteriaOperator.Parse("[DisplayName] = '" + reportname + "'"));
                    objectSpace.Dispose();
                    string handle = ReportDataProvider.ReportsStorage.GetReportContainerHandle(reportData);
                    Frame.GetController <ReportServiceController>().ShowPreview(handle, CriteriaOperator.Parse("Oid in (" + temp + ")"));
                }
            }
        }
 public override void TearDownSession()
 {
     if (securedObjectSpace != null)
     {
         securedObjectSpace.Dispose();
         securedObjectSpace = null;
     }
     securedObjectHelper = null;
 }
 protected override void Dispose(bool disposing)
 {
     if (disposing)
     {
         objectSpace?.Dispose();
         securityProvider?.Dispose();
     }
     base.Dispose(disposing);
 }
Exemplo n.º 7
0
 protected override void OnDeactivated()
 {
     base.OnDeactivated();
     Application.ObjectSpaceCreated -= Application_ObjectSpaceCreated;
     if (additionalObjectSpace != null)
     {
         additionalObjectSpace.Dispose();
         additionalObjectSpace = null;
     }
 }
        /// <summary>
        /// This method adds imported objects into the required ListView.
        /// </summary>
        /// <typeparam name="T">Any persistent object type supporting the IXPSimpleObject interface.</typeparam>
        /// <param name="count">The count of of objects to be imported.</param>
        /// <param name="importDataDelegate">A function of the ImportDataDelegate type that can create persistent objects.</param>
        /// <param name="customValidateDataDelegate">A function of the ValidateDataDelegate type that can be used to additionally validated created persistent objects. Note that by default, the created objects are already validated using the XAF's Validation system. So, you can set this parameter to null or Nothing in VB.NET</param>
        /// <param name="targetListView">A ListView to which objects will be imported.</param>
        /// <returns>The real count of imported objects.</returns>
        /// Dennis: This method reuses the UnitOfWork/NestedUnitOfWork classes, but it's also correct to use independent (that doesn't belong to a View) ObjectSpace/NestedObjectSpace classes here.
        public int ImportData <T>(int count, ImportDataDelegate <T> importDataDelegate, ValidateDataDelegate <T> customValidateDataDelegate, ListView targetListView) where T : IXPSimpleObject
        {
            if (targetListView == null)
            {
                throw new ArgumentNullException("targetlistView");
            }
            IObjectSpace importObjectSpace = null;
            int          countOK           = 0;

            try {
                importObjectSpace = Application.CreateObjectSpace(targetListView.CollectionSource.ObjectTypeInfo.Type);
                for (int i = 0; i < count; i++)
                {
                    using (IObjectSpace nestedImportObjectSpace = importObjectSpace.CreateNestedObjectSpace()) {
                        PropertyCollectionSource pcs = targetListView.CollectionSource as PropertyCollectionSource;
                        object masterObject          = pcs != null?nestedImportObjectSpace.GetObjectByKey(pcs.MasterObjectType, nestedImportObjectSpace.GetKeyValue(pcs.MasterObject)) : null;

                        T obj = importDataDelegate(nestedImportObjectSpace, masterObject, i);
                        if (obj != null)
                        {
                            bool isValid = false;
                            try {
                                RuleSetValidationResult validationResult = Validator.RuleSet.ValidateTarget(null, obj, new ContextIdentifiers(DefaultContexts.Save.ToString()));
                                isValid = validationResult.State != ValidationState.Invalid && (customValidateDataDelegate != null ? customValidateDataDelegate(obj, masterObject, i) : true);
                                if (isValid)
                                {
                                    nestedImportObjectSpace.CommitChanges();
                                }
                            } catch (Exception) {
                                isValid = false;
                            } finally {
                                if (isValid)
                                {
                                    countOK++;
                                }
                            }
                        }
                    }
                }
                importObjectSpace.CommitChanges();
                targetListView.ObjectSpace.Refresh();
            } catch (Exception commitException) {
                try {
                    importObjectSpace.Rollback();
                } catch (Exception rollBackException) {
                    throw new Exception(String.Format("An exception of type {0} was encountered while attempting to roll back the transaction while importing the data of the {1} type.\nError Message:{2}\nStackTrace:{3}", rollBackException.GetType(), typeof(T), rollBackException.Message, rollBackException.StackTrace), rollBackException);
                }
                throw new UserFriendlyException(String.Format("Importing can't be finished!\nAn exception of type {0} was encountered while importing the data of the {1} type.\nError message = {2}\nStackTrace:{3}\nNo records were imported.", commitException.GetType(), typeof(T), commitException.Message, commitException.StackTrace));
            } finally {
                importObjectSpace.Dispose();
                importObjectSpace = null;
            }
            return(countOK);
        }
Exemplo n.º 9
0
        private void ObjectSpace_Disposed(object sender, EventArgs e)
        {
            NonPersistentObjectSpace objectSpace = sender as NonPersistentObjectSpace;

            objectSpace.ObjectsGetting      -= ObjectSpace_ObjectsGetting;
            objectSpace.ObjectByKeyGetting  -= ObjectSpace_ObjectByKeyGetting;
            objectSpace.ObjectsCountGetting -= ObjectSpace_ObjectsCountGetting;
            objectSpace.ObjectGetting       -= ObjectSpace_ObjectGetting;
            objectSpace.Committing          -= ObjectSpace_Committing;
            additionalObjectSpace.Dispose();
            additionalObjectSpace = null;
        }
Exemplo n.º 10
0
 private void Application_ObjectSpaceCreated(object sender, ObjectSpaceCreatedEventArgs e)
 {
     if (e.ObjectSpace is NonPersistentObjectSpace)
     {
         IObjectSpace additionalObjectSpace = Application.CreateObjectSpace(typeof(MCategory));
         ((NonPersistentObjectSpace)e.ObjectSpace).AdditionalObjectSpaces.Add(additionalObjectSpace);
         ((NonPersistentObjectSpace)e.ObjectSpace).ObjectGetting += ObjectSpace_ObjectGetting;
         e.ObjectSpace.Disposed += (s, args) => {
             ((NonPersistentObjectSpace)s).ObjectGetting -= ObjectSpace_ObjectGetting;
             additionalObjectSpace.Dispose();
         };
     }
 }
        public HttpResponseMessage Count_NumberAccepet()
        {
            try
            {
                string        OrganizationOid = HttpContext.Current.Request.Form["OrganizationOid"].ToString();
                SqlConnection objConn         = new SqlConnection(scc);
                if (objConn.State != ConnectionState.Open)
                {
                    objConn.Open();
                }
                DataSet ds = SqlHelper.ExecuteDataset(scc, CommandType.StoredProcedure, "SP_CountNumber_Approve", new SqlParameter("@OrganizationOid", OrganizationOid));
                if (ds.Tables[0].Rows.Count > 0)
                {
                    XpoTypesInfoHelper.GetXpoTypeInfoSource();
                    XafTypesInfo.Instance.RegisterEntity(typeof(Organization));
                    XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
                    IObjectSpace          ObjectSpace    = directProvider.CreateObjectSpace();
                    Organization          Organization   = ObjectSpace.FindObject <Organization>(CriteriaOperator.Parse("GCRecord is null and Oid =?", OrganizationOid));
                    Count_Number          number         = new Count_Number();
                    number.OrganizationName = Organization.OrganizeNameTH;
                    number.CountNumber      = (int)ds.Tables[0].Rows[0]["Count_Total"];


                    directProvider.Dispose();
                    ObjectSpace.Dispose();
                    return(Request.CreateResponse(HttpStatusCode.OK, number));
                }
                else
                {
                    UserError err = new UserError();
                    err.code    = "-1"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
                    err.message = "ไม่พบข้อมูลรายการ";
                    return(Request.CreateResponse(HttpStatusCode.NotFound, err));
                }
            }
            catch (Exception ex)
            {
                UserError err = new UserError();
                err.code    = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
                err.message = ex.Message;
                return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
            }
        }
Exemplo n.º 12
0
        protected override void Dispose(bool disposing)
        {
            try
            {
                if (disposing)
                {
                    if (newObjectWindowAction != null)
                    {
                        newObjectWindowAction.Execute -= new PopupWindowShowActionExecuteEventHandler(newObjectWindowAction_OnExecute);
                        newObjectWindowAction.CustomizePopupWindowParams -= new CustomizePopupWindowParamsEventHandler(newObjectWindowAction_OnCustomizePopupWindowParams);
                        DisposeAction(newObjectWindowAction);
                        newObjectWindowAction = null;
                    }
                    if (newObjectViewController != null)
                    {
                        newObjectViewController.ObjectCreating -= new EventHandler <ObjectCreatingEventArgs>(newObjectViewController_ObjectCreating);
                        newObjectViewController.ObjectCreated  -= new EventHandler <ObjectCreatedEventArgs>(newObjectViewController_ObjectCreated);
                        newObjectViewController = null;
                    }
                    if (frame != null)
                    {
                        frame.SetView(null);
                        frame.Dispose();
                        frame = null;
                    }

                    if (newObjectSpace != null && !newObjectSpace.IsDisposed)
                    {
                        newObjectSpace.Dispose();
                    }

                    newObject      = null;
                    newObjectSpace = null;
                }
            }
            finally
            {
                base.Dispose(disposing);
            }
        }
        public static IObservable <Unit> ConnectDocumentStyleManager(this ApplicationModulesManager manager)
        => manager.WhenApplication(application => application.WhenListViewCreating(typeof(DocumentStyleLinkTemplate))
                                   .SelectMany(t => {
            var nonPersistentObjectSpace  = ((NonPersistentObjectSpace)t.e.ObjectSpace);
            var objectSpaces              = nonPersistentObjectSpace.AdditionalObjectSpaces;
            var needPersistentObjectSpace = objectSpaces.Any(space => space.IsKnownType(t.e.CollectionSource.ObjectTypeInfo.Type));
            IObjectSpace objectSpace      = null;
            if (!needPersistentObjectSpace)
            {
                objectSpace = application.CreateObjectSpace(typeof(DocumentStyleLinkTemplate));
                objectSpaces.Add(objectSpace);
            }

            return(nonPersistentObjectSpace.WhenDisposed().Do(_ => {
                if (needPersistentObjectSpace)
                {
                    objectSpace?.Dispose();
                }
            }));
        }))
        .Do(tuple => {})
        .ToUnit();
Exemplo n.º 14
0
        public HttpResponseMessage ManageSubAnimalSupplierList()
        {
            List <AnimalProductDetail> animalDatail = new List <AnimalProductDetail>();
            AnimalProductDetail        animal       = new AnimalProductDetail();

            try
            {
                //    string QuotaName = HttpContext.Current.Request.Form["QuotaName"].ToString();
                string OrganizationOid = HttpContext.Current.Request.Form["OrganizationOid"].ToString();
                //string AnimalSupplieOid = HttpContext.Current.Request.Form["AnimalSupplieOid"].ToString();
                //string AnimalSupplieTypeOid = HttpContext.Current.Request.Form["AnimalSupplieTypeOid"].ToString();
                string QuotaTypeOid = HttpContext.Current.Request.Form["QuotaTypeOid"].ToString();

                List <QuotaType_Model> listquo = new List <QuotaType_Model>();
                QuotaType_Model        quota   = new QuotaType_Model();
                XpoTypesInfoHelper.GetXpoTypeInfoSource();
                XafTypesInfo.Instance.RegisterEntity(typeof(QuotaType));
                XafTypesInfo.Instance.RegisterEntity(typeof(ManageAnimalSupplier));
                XafTypesInfo.Instance.RegisterEntity(typeof(ManageSubAnimalSupplier));
                XPObjectSpaceProvider directProvider    = new XPObjectSpaceProvider(scc, null);
                List <ManageAnimalSupplier_Model2> list = new List <ManageAnimalSupplier_Model2>();
                IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
                QuotaType    quotaType;
                //  var ManageSubAnimalSupplierOid = null;
                quotaType = ObjectSpace.FindObject <QuotaType>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1 and Oid  = '" + QuotaTypeOid + "' ", null));

                ManageAnimalSupplier ObjManageAnimalSupplier = ObjectSpace.FindObject <ManageAnimalSupplier>(CriteriaOperator.Parse("[OrganizationOid]=? and Status=1", OrganizationOid));
                if (ObjManageAnimalSupplier != null)
                {
                    switch (quotaType.QuotaName)
                    {
                    case "โควตาสำนัก":
                        animal.QuotaName             = "โควตาสำนัก"; //ผิด
                        animal.AnimalSupplieTypeOid  = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString();
                        animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName;

                        break;

                    case "โควตาศูนย์ฯ":
                        animal.QuotaName             = "โควตาศูนย์ฯ";
                        animal.AnimalSupplieTypeOid  = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString();
                        animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName;
                        animal.QuotaQTY = ObjManageAnimalSupplier.CenterQTY;

                        break;

                    case "โควตาปศุสัตว์เขต":
                        animal.QuotaName             = "โควตาปศุสัตว์เขต";
                        animal.AnimalSupplieTypeOid  = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString();
                        animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName;
                        animal.QuotaQTY = ObjManageAnimalSupplier.ZoneQTY;
                        break;

                    //case "โควตาปศุสัตว์จังหวัด":
                    //    animal.QuotaName = "โควตาปศุสัตว์จังหวัด";
                    //    animal.AnimalSupplieTypeOid = ObjectSpace.FindObject<AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString();
                    //    animal.AnimalSupplieTypeName = ObjectSpace.FindObject<AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName;
                    //    animal.QuotaQTY = ObjManageAnimalSupplier.ZoneQTY;
                    //    break;
                    case "โควตาอื่นๆ":
                        animal.QuotaName             = "โควตาอื่นๆ";
                        animal.AnimalSupplieTypeOid  = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString();
                        animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName;
                        animal.QuotaQTY = ObjManageAnimalSupplier.OtherQTY;
                        break;

                    case "โควตาปศุสัตว์จังหวัด":
                        if (ObjManageAnimalSupplier != null)
                        {
                            animal.AnimalSupplieTypeOid       = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString();
                            animal.AnimalSupplieTypeName      = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName;
                            animal.manageSubAnimalSupplierOid = ObjManageAnimalSupplier.Oid.ToString();
                            List <ManageSubAnimalSupplier_Province> Detail2 = new List <ManageSubAnimalSupplier_Province>();
                            IList <ManageSubAnimalSupplier>         objmanageSubAnimalSupplier = ObjectSpace.GetObjects <ManageSubAnimalSupplier>(CriteriaOperator.Parse("[ManageAnimalSupplierOid]= '" + ObjManageAnimalSupplier.Oid + "' ", null));
                            if (objmanageSubAnimalSupplier.Count > 0)
                            {
                                foreach (ManageSubAnimalSupplier row2 in objmanageSubAnimalSupplier)
                                {
                                    ManageSubAnimalSupplier_Province subanimal = new ManageSubAnimalSupplier_Province();
                                    subanimal.ManageAnimalSupplierOid    = row2.ManageAnimalSupplierOid.Oid.ToString();
                                    subanimal.ManageSubAnimalSupplierOid = row2.Oid.ToString();
                                    subanimal.ProvinceOid  = row2.ProvinceOid.Oid.ToString();
                                    subanimal.ProvinceName = row2.ProvinceOid.ProvinceNameTH;
                                    Detail2.Add(subanimal);
                                }
                                animal.QuotaName       = quotaType.QuotaName;
                                animal.ObjProvinceName = Detail2;
                            }
                        }
                        break;
                    }
                    directProvider.Dispose();
                    ObjectSpace.Dispose();
                    return(Request.CreateResponse(HttpStatusCode.OK, animal));
                }
                else
                {
                    UserError err2 = new UserError();
                    err2.code    = "3"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
                    err2.message = "ไม่พบข้อมูล";
                    return(Request.CreateResponse(HttpStatusCode.BadRequest, err2));
                }
            }
            catch (Exception ex)
            {                   //Error case เกิดข้อผิดพลาด
                UserError err = new UserError();
                err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ

                err.message = ex.Message;
                //  Return resual
                return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
            }
        }
Exemplo n.º 15
0
 private void DisposeUpdatingSession(IObjectSpace objectSpace)
 {
     OnUpdatingSessionDisposing(objectSpace);
     objectSpace.Dispose();
 }
Exemplo n.º 16
0
 public void Dispose()
 {
     objectSpace?.Dispose();
     securityProvider?.Dispose();
 }
        public HttpResponseMessage GetSendOrderSeed()
        {
            try
            {
                string org_oid = HttpContext.Current.Request.Form["Org_Oid"].ToString();
                string type    = HttpContext.Current.Request.Form["type"].ToString(); //รับ=1/ส่ง=2

                if (org_oid != "" && type != "")
                {
                    XpoTypesInfoHelper.GetXpoTypeInfoSource();
                    XafTypesInfo.Instance.RegisterEntity(typeof(SendOrderSeed));

                    List <SendOrderSeedType>    SendItems    = new List <SendOrderSeedType>();
                    List <ReceiveOrderSeedType> ReceiveItems = new List <ReceiveOrderSeedType>();
                    SendOrderSeedModel          lists        = new SendOrderSeedModel();
                    lists.org_oid = org_oid;

                    XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);

                    IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();

                    if (type == "2")
                    {  //หน่วยส่ง
                        IList <SendOrderSeed> collection = ObjectSpace.GetObjects <SendOrderSeed>(CriteriaOperator.Parse("GCRecord is null and SendStatus=1 and [SendOrgOid.Oid]='" + org_oid + "'", null));
                        var query = from Q in collection orderby Q.SendNo select Q;
                        if (collection.Count > 0)
                        {
                            foreach (SendOrderSeed row in query)
                            {
                                SendOrderSeedType item = new SendOrderSeedType();
                                item.SendNo             = row.SendNo;
                                item.SendDate           = row.SendDate.ToString("dd/MM/yyyy");
                                item.SendOrgOid         = row.SendOrgOid.Oid.ToString();
                                item.SendOrgName        = row.SendOrgOid.SubOrganizeName;
                                item.SendOrgFullName    = row.SendOrgOid.OrganizeNameTH;
                                item.Remark             = row.Remark;
                                item.SendStatus         = row.SendStatus.ToString();
                                item.FinanceYear        = row.FinanceYearOid.YearName;
                                item.CancelMsg          = row.CancelMsg;
                                item.ReceiveOrgOid      = row.ReceiveOrgOid.Oid.ToString();
                                item.ReceiveOrgName     = row.ReceiveOrgOid.SubOrganizeName;
                                item.ReceiveOrgFullName = row.ReceiveOrgOid.OrganizeNameTH;
                                item.RefNo = row.SendNo + "|" + row.SendOrgOid.Oid.ToString() + "|2";

                                item.TotalWeight = row.SendOrderSeedDetails.Sum((c => c.Weight)).ToString() + " กิโลกรัม";
                                SendItems.Add(item);
                            }
                        }
                        //lists.Sender = null; //SendItems;
                        return(Request.CreateResponse(HttpStatusCode.OK, SendItems));
                    }
                    else if (type == "1")
                    {  //รับ
                        IList <SendOrderSeed> collection2 = ObjectSpace.GetObjects <SendOrderSeed>(CriteriaOperator.Parse("GCRecord is null and SendStatus = 2 and  ReceiveStatus=1 and ReceiveOrgOid.Oid='" + org_oid + "'", null));
                        var query = from Q in collection2 orderby Q.SendNo select Q;
                        if (collection2.Count > 0)
                        {
                            foreach (SendOrderSeed row in query)
                            {
                                ReceiveOrderSeedType item = new ReceiveOrderSeedType();
                                item.SendNo             = row.SendNo;
                                item.SendDate           = row.SendDate.ToString("dd/MM/yyyy");
                                item.SendOrgOid         = row.SendOrgOid.Oid.ToString();
                                item.SendOrgName        = row.SendOrgOid.SubOrganizeName;
                                item.SendOrgFullName    = row.SendOrgOid.OrganizeNameTH;
                                item.Remark             = row.Remark;
                                item.ReceiveOrderStatus = row.ReceiveStatus.ToString();
                                item.FinanceYear        = row.FinanceYearOid.YearName;
                                item.CancelMsg          = row.CancelMsg;
                                item.ReceiveOrgOid      = row.ReceiveOrgOid.Oid.ToString();
                                item.ReceiveOrgName     = row.ReceiveOrgOid.SubOrganizeName;
                                item.ReceiveOrgFullName = row.ReceiveOrgOid.OrganizeNameTH;
                                item.RefNo       = row.SendNo + "|" + row.ReceiveOrgOid.Oid.ToString() + "|1";
                                item.TotalWeight = row.SendOrderSeedDetails.Sum((c => c.Weight)).ToString() + " กิโลกรัม";
                                ReceiveItems.Add(item);
                            }
                            directProvider.Dispose();
                            ObjectSpace.Dispose();
                            //lists.Receive = ReceiveItems;
                            return(Request.CreateResponse(HttpStatusCode.OK, ReceiveItems));
                        }
                    }

                    //invalid
                    UserError err = new UserError();
                    err.status  = "false";
                    err.code    = "0";
                    err.message = "กรุณาใส่ข้อมูล Org_Oid และ type ให้เรียบร้อยก่อน";
                    return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
                }
                else
                {
                    UserError err = new UserError();
                    err.status  = "false";
                    err.code    = "0";
                    err.message = "กรุณาใส่ข้อมูล Org_Oid ให้เรียบร้อยก่อน";
                    return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
                }
            }
            catch (Exception ex)
            {
                UserError err = new UserError();
                err.status  = "false";
                err.code    = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
                err.message = "ไม่พบข้อมูล";
                return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
            }
            finally
            {
                SqlConnection.ClearAllPools();
            }
        }
Exemplo n.º 18
0
 protected void Page_Unload(object sender, EventArgs e)
 {
     objectSpace.Dispose();
     security.Dispose();
     objectSpaceProvider.Dispose();
 }
Exemplo n.º 19
0
 public void TearDown()
 {
     directProvider.Dispose();
     objectSpace.Dispose();
     //  generator.Dispose();
 }
 public void DisposeObjectSpace(IObjectSpace os)
 {
     os.Dispose();
 }
Exemplo n.º 21
0
        /// <summary>
        /// Commits the object space on load.
        /// </summary>
        /// <param name="objectSpace">The object space.</param>
        /// <param name="activeObjectSpaces">The active object spaces.</param>
        private void commitObjectSpaceOnLoad(IObjectSpace objectSpace, Dictionary<Guid, IObjectSpace> activeObjectSpaces)
        {
            var children = from s in activeObjectSpaces.Values
                           where s is NestedObjectSpace && ((NestedObjectSpace) s).ParentObjectSpace == objectSpace
                           select s;
            foreach (var child in children)
                commitObjectSpaceOnLoad(child, activeObjectSpaces);

            var newMaps = from c in objectSpace.ModifiedObjects.Cast<object>()
                          where c is OidMap && ((OidMap) c).NewObject != null
                          select c as OidMap;

            objectSpace.CommitChanges();

            newMaps.ToList().ForEach(x => x.FixReference());

            objectSpace.CommitChanges();

            objectSpace.Dispose();
            var sessionId = (from a in activeObjectSpaces where a.Value == objectSpace select a.Key).FirstOrDefault();
            activeObjectSpaces.Remove(sessionId);
        }
Exemplo n.º 22
0
        public HttpResponseMessage RodBreedList()
        {
            try
            {
                string Org = HttpContext.Current.Request.Form["organizationOid"].ToString();
                //  string type = HttpContext.Current.Request.Form["type"].ToString();
                XpoTypesInfoHelper.GetXpoTypeInfoSource();
                XafTypesInfo.Instance.RegisterEntity(typeof(SupplierRodBreedUseProduct));
                XPObjectSpaceProvider directProvider          = new XPObjectSpaceProvider(scc, null);
                IObjectSpace          ObjectSpace             = directProvider.CreateObjectSpace();
                List <Rodbreed_model> Detail                  = new List <Rodbreed_model>();
                IList <SupplierRodBreedUseProduct> collection = ObjectSpace.GetObjects <SupplierRodBreedUseProduct>(CriteriaOperator.Parse(" GCRecord is null and Status = 1 and OrganizationOid = ? ", Org));
                var query = from Q in collection orderby Q.UseNo select Q;
                if (collection.Count > 0)
                {
                    foreach (SupplierRodBreedUseProduct row in query)
                    {
                        Rodbreed_model item = new Rodbreed_model();
                        item.SupplierRodBreedUseProductOid = row.Oid.ToString();
                        item.FinanceYearOid  = row.FinanceYearOid.Oid.ToString();
                        item.FinanceYear     = row.FinanceYearOid.YearName;
                        item.ActivityNameOid = row.ActivityOid.Oid.ToString();
                        item.ActivityName    = row.ActivityOid.ActivityName;
                        if (row.SubActivityLevelOid != null)
                        {
                            item.SubActivityLevelOid  = row.SubActivityLevelOid.Oid.ToString();
                            item.SubActivityLevelName = row.SubActivityLevelOid.ActivityName;
                        }

                        item.FinanceYearOid   = row.FinanceYearOid.Oid.ToString();
                        item.FinanceYear      = row.FinanceYearOid.YearName;
                        item.UseNo            = row.UseNo;
                        item.UseDate          = row.UseDate.ToString("dd/MM/yy");
                        item.OrganizationOid  = row.OrganizationOid.Oid.ToString();
                        item.OrganizationName = row.OrganizationOid.SubOrganizeName;
                        if (row.EmployeeOid != null)
                        {
                            item.EmployeeOid  = row.EmployeeOid.Oid.ToString();
                            item.EmployeeName = row.EmployeeOid.FullName;
                        }
                        if (row.RegisCusServiceOid != null)
                        {
                            item.RegisCusServiceOid = row.RegisCusServiceOid.Oid.ToString();
                            item.FullName           = row.RegisCusServiceOid.DisPlayName;
                            item.FullAddress        = row.RegisCusServiceOid.FullAddress;
                        }
                        if (row.OrgeServiceOid != null)
                        {
                            item.OrgeServiceOid = row.OrgeServiceOid.Oid.ToString();
                            item.FullName       = row.OrgeServiceOid.OrgeServiceName;
                            item.FullAddress    = row.OrgeServiceOid.FullAddress;
                        }

                        item.ServiceCount = row.ServiceCount;
                        item.TotalWeight  = row.SupplierRodBreedUseProductDetails.Sum((c => c.Weight)).ToString() + " กิโลกรัม";
                        Detail.Add(item);
                    }
                    directProvider.Dispose();
                    ObjectSpace.Dispose();
                    //lists.Receive = ReceiveItems;
                    return(Request.CreateResponse(HttpStatusCode.OK, Detail));
                }
                else
                {
                    UserError err2 = new UserError();
                    err2.status  = "false";
                    err2.code    = "-9";
                    err2.message = "ไม่มีข้อมูลรายการ การใช้ท่อนพันธุ์";
                    return(Request.CreateResponse(HttpStatusCode.BadRequest, err2));
                }
            }
            catch (Exception ex)
            {
                UserError err = new UserError();
                err.status  = "false";
                err.code    = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
                err.message = ex.ToString();
                return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
            }
        }
 protected virtual void CloseObjectSpace(IObjectSpace objectSpace, bool success)
 {
     if (objectSpace != null && !objectSpace.IsDisposed)
     {
         if (success)
         {
             objectSpace.CommitChanges();
         }
         else
         {
             objectSpace.Rollback();
         }
         objectSpace.Dispose();
     }
 }