Пример #1
0
        public void DeleteFromRepository(WarehouseType itemType)
        {
            if (_repositoryContext.GetEntityDescriptor(itemType) != null)
            {//if it exists in the db delete it from the db
                WarehouseEntities context = new WarehouseEntities(_rootUri);
                context.MergeOption = MergeOption.AppendOnly;
                context.IgnoreResourceNotFoundException = true;
                WarehouseType deletedWarehouseType = (from q in context.WarehouseTypes
                                                      where q.WarehouseTypeID == itemType.WarehouseTypeID
                                                      select q).FirstOrDefault();
                if (deletedWarehouseType != null)
                {
                    context.DeleteObject(deletedWarehouseType);
                    context.SaveChanges();
                }
                context = null;

                _repositoryContext.MergeOption = MergeOption.AppendOnly;
                //if it is being tracked remove it...
                if (GetWarehouseTypeEntityState(itemType) != EntityStates.Detached)
                {
                    _repositoryContext.Detach(itemType);
                }
            }
        }
Пример #2
0
        public List <WarehouseLink> GetWarehouseItems(Guid?id, long?ownerId, WarehouseType warehouseType, byte?slot)
        {
            var list = new List <WarehouseLink>();

            if (id == null)
            {
                var warehouse = _warehouseDao.FirstOrDefaultAsync(s
                                                                  => s.Type == warehouseType &&
                                                                  s.CharacterId == (warehouseType == WarehouseType.FamilyWareHouse ? null : ownerId) &&
                                                                  s.FamilyId == (warehouseType == WarehouseType.FamilyWareHouse ? ownerId : null));
                if (slot == null)
                {
                    //todo add
                }
                else
                {
                    //todo add
                }
            }
            else
            {
                var warehouseLink = new WarehouseLink();
                list.Add(warehouseLink);
            }

            return(list);
        }
Пример #3
0
        public async Task <bool> DepositItemAsync(long ownerId, WarehouseType warehouseType, ItemInstanceDto?itemInstance, short slot)
        {
            var item = itemInstance as IItemInstanceDto;

            item !.Id = Guid.NewGuid();
            item      = await _itemInstanceDao.TryInsertOrUpdateAsync(item).ConfigureAwait(true);

            var warehouse = new WarehouseDto
            {
                CharacterId = warehouseType == WarehouseType.FamilyWareHouse ? null
                    : (long?)ownerId,
                Id       = Guid.NewGuid(),
                FamilyId = warehouseType == WarehouseType.FamilyWareHouse
                    ? (long?)ownerId : null,
                Type = warehouseType,
            };

            warehouse = await _warehouseDao.TryInsertOrUpdateAsync(warehouse).ConfigureAwait(true);

            var warehouseItem = new WarehouseItemDto
            {
                Slot           = slot,
                Id             = Guid.NewGuid(),
                ItemInstanceId = item !.Id,
                WarehouseId    = warehouse.Id
            };
            await _warehouseItemDao.TryInsertOrUpdateAsync(warehouseItem).ConfigureAwait(true);

            return(true);
        }
    }
Пример #4
0
        private void Refresh()
        {//refetch current records...
            long   selectedAutoID = SelectedWarehouseType.AutoID;
            string autoIDs        = "";

            //bool isFirstItem = true;
            foreach (WarehouseType itemType in WarehouseTypeList)
            {//auto seeded starts at 1 any records at 0 or less or not valid records...
                if (itemType.AutoID > 0)
                {
                    autoIDs = autoIDs + itemType.AutoID.ToString() + ",";
                }
            }
            if (autoIDs.Length > 0)
            {
                //ditch the extra comma...
                autoIDs               = autoIDs.Remove(autoIDs.Length - 1, 1);
                WarehouseTypeList     = new BindingList <WarehouseType>(_serviceAgent.RefreshWarehouseType(autoIDs).ToList());
                SelectedWarehouseType = (from q in WarehouseTypeList
                                         where q.AutoID == selectedAutoID
                                         select q).FirstOrDefault();
                Dirty       = false;
                AllowCommit = false;
            }
        }
 public void Put(String Type, [FromBody] WarehouseType ware)
 {
     if (ModelState.IsValid)
     {
         WarehouseTypeRepository.Update(Type, ware);
     }
 }
        public static List <Temp> GetMetaData(this WarehouseType entityObject)
        {
            XERP.Server.DAL.WarehouseDAL.DALUtility dalUtility = new DALUtility();
            List <Temp> tempList = new List <Temp>();
            int         id       = 0;

            using (WarehouseEntities ctx = new WarehouseEntities(dalUtility.EntityConectionString))
            {
                var c            = ctx.WarehouseTypes.FirstOrDefault();
                var queryResults = from meta in ctx.MetadataWorkspace.GetItems(DataSpace.CSpace)
                                   .Where(m => m.BuiltInTypeKind == BuiltInTypeKind.EntityType)
                                   from query in (meta as EntityType).Properties
                                   .Where(p => p.DeclaringType.Name == entityObject.GetType().Name)
                                   select query;

                if (queryResults.Count() > 0)
                {
                    foreach (var queryResult in queryResults.ToList())
                    {
                        Temp temp = new Temp();
                        temp.ID          = id;
                        temp.Name        = queryResult.Name.ToString();
                        temp.ShortChar_1 = queryResult.TypeUsage.EdmType.Name;
                        if (queryResult.TypeUsage.EdmType.Name == "String")
                        {
                            temp.Int_1 = Convert.ToInt32(queryResult.TypeUsage.Facets["MaxLength"].Value);
                        }
                        temp.Bool_1 = false; //we use this as a error trigger false = not an error...
                        tempList.Add(temp);
                        id++;
                    }
                }
            }
            return(tempList);
        }
 public void Post([FromBody] WarehouseType Type)
 {
     if (ModelState.IsValid)
     {
         WarehouseTypeRepository.Add(Type);
     }
 }
Пример #8
0
        //WarehouseType Object Scope Validation check the entire object for validity...
        private byte WarehouseTypeIsValid(WarehouseType item, out string errorMessage)
        {   //validate key
            errorMessage = "";
            if (string.IsNullOrEmpty(item.WarehouseTypeID))
            {
                errorMessage = "ID Is Required.";
                return(1);
            }
            EntityStates entityState = GetWarehouseTypeState(item);

            if (entityState == EntityStates.Added && WarehouseTypeExists(item.WarehouseTypeID, ClientSessionSingleton.Instance.CompanyID))
            {
                errorMessage = "Item All Ready Exists.";
                return(1);
            }
            //check cached list for duplicates...
            int count = WarehouseTypeList.Count(q => q.WarehouseTypeID == item.WarehouseTypeID);

            if (count > 1)
            {
                errorMessage = "Item All Ready Exists.";
                return(1);
            }
            //validate Description
            if (string.IsNullOrEmpty(item.Description))
            {
                errorMessage = "Description Is Required.";
                return(1);
            }
            //a value of 2 is pending changes...
            //On Commit we will give it a value of 0...
            return(2);
        }
Пример #9
0
 private void ChangeKeyLogic()
 {
     if (!string.IsNullOrEmpty(SelectedWarehouseType.WarehouseTypeID))
     {//check to see if key is part of the current companylist...
         WarehouseType query = WarehouseTypeList.Where(company => company.WarehouseTypeID == SelectedWarehouseType.WarehouseTypeID &&
                                                       company.AutoID != SelectedWarehouseType.AutoID).FirstOrDefault();
         if (query != null)
         {//revert it back...
             SelectedWarehouseType.WarehouseTypeID = SelectedWarehouseTypeMirror.WarehouseTypeID;
             //change to the newly selected company...
             SelectedWarehouseType = query;
             return;
         }
         //it is not part of the existing list try to fetch it from the db...
         WarehouseTypeList = GetWarehouseTypeByID(SelectedWarehouseType.WarehouseTypeID, XERP.Client.ClientSessionSingleton.Instance.CompanyID);
         if (WarehouseTypeList.Count == 0)//it was not found do new record required logic...
         {
             NotifyNewRecordNeeded("Record " + SelectedWarehouseType.WarehouseTypeID + " Does Not Exist.  Create A New Record?");
         }
         else
         {
             SelectedWarehouseType = WarehouseTypeList.FirstOrDefault();
         }
     }
     else
     {
         string errorMessage = "ID Is Required.";
         NotifyMessage(errorMessage);
         //revert back to the value it was before it was changed...
         if (SelectedWarehouseType.WarehouseTypeID != SelectedWarehouseTypeMirror.WarehouseTypeID)
         {
             SelectedWarehouseType.WarehouseTypeID = SelectedWarehouseTypeMirror.WarehouseTypeID;
         }
     }
 }
Пример #10
0
        public IEnumerable <WarehouseType> GetWarehouseTypes(WarehouseType itemTypeQuerryObject, string companyID)
        {
            _repositoryContext             = new WarehouseEntities(_rootUri);
            _repositoryContext.MergeOption = MergeOption.AppendOnly;
            _repositoryContext.IgnoreResourceNotFoundException = true;
            var queryResult = from q in _repositoryContext.WarehouseTypes
                              where q.CompanyID == companyID
                              select q;

            if (!string.IsNullOrEmpty(itemTypeQuerryObject.Type))
            {
                queryResult = queryResult.Where(q => q.Type.StartsWith(itemTypeQuerryObject.Type.ToString()));
            }

            if (!string.IsNullOrEmpty(itemTypeQuerryObject.Description))
            {
                queryResult = queryResult.Where(q => q.Description.StartsWith(itemTypeQuerryObject.Description.ToString()));
            }

            if (!string.IsNullOrEmpty(itemTypeQuerryObject.WarehouseTypeID))
            {
                queryResult = queryResult.Where(q => q.Description.StartsWith(itemTypeQuerryObject.WarehouseTypeID.ToString()));
            }

            return(queryResult);
        }
Пример #11
0
        public void DeleteWarehouseTypeCommand()
        {
            try
            {//company is fk to 100's of tables deleting it can be tricky...
                int i  = 0;
                int ii = 0;
                for (int j = SelectedWarehouseTypeList.Count - 1; j >= 0; j--)
                {
                    WarehouseType item = (WarehouseType)SelectedWarehouseTypeList[j];
                    //get Max Index...
                    i = WarehouseTypeList.IndexOf(item);
                    if (i > ii)
                    {
                        ii = i;
                    }
                    Delete(item);
                    WarehouseTypeList.Remove(item);
                }

                if (WarehouseTypeList != null && WarehouseTypeList.Count > 0)
                {
                    //back off one index from the max index...
                    ii = ii - 1;

                    //if they delete the first row...
                    if (ii < 0)
                    {
                        ii = 0;
                    }

                    //make sure it does not exceed the list count...
                    if (ii >= WarehouseTypeList.Count())
                    {
                        ii = WarehouseTypeList.Count - 1;
                    }

                    SelectedWarehouseType = WarehouseTypeList[ii];
                    //we will only enable committ for dirty validated records...
                    if (Dirty == true)
                    {
                        AllowCommit = CommitIsAllowed();
                    }
                    else
                    {
                        AllowCommit = false;
                    }
                }
                else//only one record, deleting will result in no records...
                {
                    SetAsEmptySelection();
                }
            }//we try catch company delete as it may be used in another table as a key...
            //As well we will force a refresh to sqare up the UI after the botched delete...
            catch
            {
                NotifyMessage("WarehouseType/s Can Not Be Deleted.  Contact XERP Admin For More Details.");
                Refresh();
            }
        }
Пример #12
0
        public ActionResult DeleteConfirmed(long id)
        {
            WarehouseType warehouseType = db.WarehouseTypes.Find(id);

            db.WarehouseTypes.Remove(warehouseType);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Пример #13
0
        private BindingList <WarehouseType> GetWarehouseTypes(WarehouseType itemType, string companyID)
        {
            BindingList <WarehouseType> itemTypeList = new BindingList <WarehouseType>(_serviceAgent.GetWarehouseTypes(itemType, companyID).ToList());

            Dirty       = false;
            AllowCommit = false;
            return(itemTypeList);
        }
Пример #14
0
 private void SetAsEmptySelection()
 {
     SelectedWarehouseType = new WarehouseType();
     AllowEdit             = false;
     AllowDelete           = false;
     Dirty        = false;
     AllowCommit  = false;
     AllowRowCopy = false;
 }
Пример #15
0
        public static void SetPropertyValue(this WarehouseType myObj, object propertyName, object propertyValue)
        {
            var propInfo = typeof(WarehouseType).GetProperty((string)propertyName);

            if (propInfo != null)
            {
                propInfo.SetValue(myObj, propertyValue, null);
            }
        }
Пример #16
0
 /// <summary>
 /// 根据仓库类型获取仓库列表
 /// </summary>
 /// <param name="warehouseType">仓库类型</param>
 /// <returns>仓库列表</returns>
 public List<Warehouse> GetWarehousesByType(WarehouseType warehouseType)
 {
     using (IUnitOfWork unitwork = MSSqlHelper.DataContext())
     {
         IWarehouseRepository warehouseRep = new WarehouseRepository(unitwork);
         List<Warehouse> warehouses = warehouseRep.GetWarehouseByType(warehouseType);
         return warehouses;
     }
 }
Пример #17
0
        public async Task <bool> Modify(WarehouseType _model)
        {
            _model.UpdatedUser = scopeContext.UserCode;
            _model.UpdatedDate = DateTime.Now;
            context.Update(_model);
            await context.SaveChangesAsync();

            return(true);
        }
Пример #18
0
        public async Task <int> Add(WarehouseType _model)
        {
            _model.CreatedUser = scopeContext.UserCode;
            _model.CreatedDate = DateTime.Now;
            context.Add(_model);
            await context.SaveChangesAsync();

            return(_model.Id);
        }
 public void Add(WarehouseType Type)
 {
     using (IDbConnection dbConnection = Connection)
     {
         string sQuery = "INSERT INTO  WarehouseType (Type"
                         + " VALUES(@Type)";
         dbConnection.Open();
         dbConnection.Execute(sQuery, Type);
     }
 }
Пример #20
0
 public ActionResult Edit([Bind(Include = "Id,Type,Description,CreatedAt")] WarehouseType warehouseType)
 {
     if (ModelState.IsValid)
     {
         db.Entry(warehouseType).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(warehouseType));
 }
Пример #21
0
 public void UpdateRepository(WarehouseType itemType)
 {
     if (_repositoryContext.GetEntityDescriptor(itemType) != null)
     {
         itemType.LastModifiedBy        = XERP.Client.ClientSessionSingleton.Instance.SystemUserID;
         itemType.LastModifiedByDate    = DateTime.Now;
         _repositoryContext.MergeOption = MergeOption.AppendOnly;
         _repositoryContext.UpdateObject(itemType);
     }
 }
Пример #22
0
 public Task <bool> DepositItemAsync(long characterId, WarehouseType warehouse, IItemInstance itemInstance, short slot)
 {
     return(PostAsync <bool>(new WareHouseDepositRequest
     {
         OwnerId = characterId,
         WarehouseType = warehouse,
         ItemInstance = itemInstance.Adapt <ItemInstanceDto>(),
         Slot = slot
     }));
 }
        public ActionResult Create([Bind(Include = "WarehouseTypeId,WarehouseName,Description")] WarehouseType warehouseType)
        {
            if (ModelState.IsValid)
            {
                db.WarehouseTypes.Add(warehouseType);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(warehouseType));
        }
Пример #24
0
 /// <summary>
 /// 彻底删除一个仓库类别
 /// </summary>
 /// <param name="delWarehType">要彻底删除的仓库类别</param>
 public void DelFullyWarehType(WarehouseType delWarehType)
 {
     try
     {
         _warehTypeDal.Delete(delWarehType);
     }
     catch (RepositoryException ex)
     {
         throw ex;
     }
 }
        public void Update(string type, WarehouseType Type)
        {
            using (IDbConnection dbConnection = Connection)
            {
                string sQuery = " UPDATE WarehouseType SET Type = @Type "

                                + " WHERE Type = '" + type + "'";
                dbConnection.Open();
                dbConnection.Execute(sQuery, Type);
            }
        }
Пример #26
0
        public async Task <bool> Modify(int _id, WarehouseTypeModel _model)
        {
            WarehouseType entity = await svcWarehouseType.GetDetail(_id);

            if (entity == null)
            {
                return(false);
            }
            entity = iMapper.Map(_model, entity);
            return(await svcWarehouseType.Modify(entity));
        }
Пример #27
0
 private void OnSearchResult(object sender, NotificationEventArgs <BindingList <WarehouseType> > e)
 {
     if (e.Data != null && e.Data.Count > 0)
     {
         WarehouseTypeList     = e.Data;
         SelectedWarehouseType = WarehouseTypeList.FirstOrDefault();
         Dirty       = false;
         AllowCommit = false;
     }
     UnregisterToReceiveMessages <BindingList <WarehouseType> >(MessageTokens.WarehouseTypeSearchToken.ToString(), OnSearchResult);
 }
Пример #28
0
 public EntityStates GetWarehouseTypeEntityState(WarehouseType itemType)
 {
     if (_repositoryContext.GetEntityDescriptor(itemType) != null)
     {
         return(_repositoryContext.GetEntityDescriptor(itemType).State);
     }
     else
     {
         return(EntityStates.Detached);
     }
 }
Пример #29
0
 /// <summary>
 /// 增加一个仓库类别
 /// </summary>
 /// <param name="newWarehType">要增加的仓库类别</param>
 /// <returns>增加后的仓库类别</returns>
 public WarehouseType AddWarehType(WarehouseType newWarehType)
 {
     try
     {
         _warehTypeDal.Add(newWarehType);
         return(newWarehType);
     }
     catch (RepositoryException ex)
     {
         throw ex;
     }
 }
Пример #30
0
 /// <summary>
 /// 修改一个仓库类别
 /// </summary>
 /// <param name="updWarehType">要修改的仓库类别</param>
 /// <returns>修改后的仓库类别</returns>
 public WarehouseType UpdateWarehType(WarehouseType updWarehType)
 {
     try
     {
         _warehTypeDal.Update(updWarehType);
         return(updWarehType);
     }
     catch (RepositoryException ex)
     {
         throw ex;
     }
 }
Пример #31
0
 protected void Page_Load(object sender, EventArgs e)
 {
     string strCateId = Request.QueryString["id"];
     if (!string.IsNullOrEmpty(strCateId) && int.TryParse(strCateId, out id))
     {
         wh = WarehouseType.findById(id);
     }
     if (!IsPostBack)
     {
         if (wh != null)
         {
             txtWarehouseName.Value = wh.WarehouseName;
             txtCode.Value = wh.WarehouseCode;
             txtAddress.Value = wh.Address;
             txtDesc.Value = wh.Description;
         }
     }
 }
Пример #32
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            wh = new WarehouseType();
            string warehouseName = Request.Form[txtWarehouseName.ID].Trim();
            if (string.IsNullOrEmpty(warehouseName))
            {
                return;
            }
            wh.WarehouseName = warehouseName;
            wh.WarehouseCode = txtCode.Value;
            wh.Address = txtAddress.Value;
            wh.Description = txtDesc.Value;

            if (id != 0)
            {
                wh.Id = id;
                wh.update();
            }
            else
            {
                wh.insert();
            }
        }
Пример #33
0
 partial void OnWarehouseTypeChanging(WarehouseType value);
 /// <summary>
 /// 根据仓库类型获得仓库
 /// </summary>
 /// <param name="warehouseType">仓库类型</param>
 /// <returns>仓库列表</returns>
 public List<Warehouse> GetWarehouseByType(WarehouseType warehouseType)
 {
     List<Warehouse> warehouses = context.Warehouse.Where(w => w.WarehouseType == warehouseType).ToList();
     return warehouses;
 }
Пример #35
0
 /// <summary>
 /// 根据仓库类型获取仓库列表
 /// </summary>
 /// <param name="warehouseType">仓库类型</param>
 /// <returns>仓库列表</returns>
 public List<Warehouse> GetWarehousesByType(WarehouseType warehouseType)
 {
     using (IUnitOfWork unitwork = MSSqlHelper.DataContext())
     {
         IWarehouseRepository warehouseRep = new WarehouseRepository(unitwork);
         List<Warehouse> warehouses = warehouseRep.GetWarehouseByType(warehouseType);
         return warehouses;
     }
 }