public Constants.ACTION_STATUS SetCollectionStatus(Constants.COLLECTION_STATUS collectionStatus, List <string> collectionIdList) { foreach (string collectionId in collectionIdList) { RequisitionCollection requisitionCollection = new RequisitionCollection(); requisitionCollection.Id = Converter.objToInt(collectionId); requisitionCollection = requisitionCollectionBroker.GetRequisitionCollection(requisitionCollection); requisitionCollection.Status = Converter.objToInt(collectionStatus); requisitionCollectionBroker.Update(requisitionCollection); if (collectionStatus == Constants.COLLECTION_STATUS.UNCOLLECTED) { CollectionMissed collectionMissed = new CollectionMissed(); collectionMissed.Id = collectionMissedBroker.GetCollectionMissedId(); collectionMissed.Department = requisitionCollection.Department; collectionMissed.CreatedBy = Util.GetEmployee(employeeBroker); collectionMissed.CreatedDate = DateTime.Now; collectionMissed.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW); collectionMissedBroker.Insert(collectionMissed); } } return(SystemStoreInventorySystemUtil.Constants.ACTION_STATUS.UNKNOWN); }
/// <summary> /// Logically delete the status of collectionMissed table /// </summary> /// <param name="collectionMissed"></param> /// <returns> /// Return the DB_STATUS /// </returns> public Constants.DB_STATUS Delete(CollectionMissed collectionMissed) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { collectionMissedObj = inventory.CollectionMisseds.Where(c => c.Id == collectionMissed.Id).First(); collectionMissedObj.Status = 2; inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return status; }
/// <summary> /// Update the collectionMissed data to the CollectionMissed Table /// </summary> /// <param name="collectionMissed"></param> /// <returns> /// Return DB_STATUS /// </returns> public Constants.DB_STATUS Update(CollectionMissed collectionMissed) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { collectionMissedObj = inventory.CollectionMisseds.Where(c => c.Id == collectionMissed.Id).First(); if (collectionMissedObj != null) { //get the department and employee object by checking Id from collectionMissed table departmentObj = inventory.Departments.Where(d => d.Id == collectionMissed.Department.Id).First(); Employee createdBy=inventory.Employees.Where(e=>e.Id==collectionMissed.CreatedBy.Id).First(); collectionMissedObj.Id = collectionMissed.Id; collectionMissedObj.Department = departmentObj; collectionMissedObj.CreatedBy = createdBy; collectionMissedObj.CreatedDate = collectionMissed.CreatedDate; inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return status; }
/// <summary> /// Insert the collectionMissed data to the CollectionMissed Table /// </summary> /// <param name="newCollectionMissed"></param> /// <returns> /// Return DB_STATUS /// </returns> public Constants.DB_STATUS Insert(CollectionMissed newCollectionMissed) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { inventory.AddToCollectionMisseds(newCollectionMissed); inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return status; }
/// <summary> /// Get CollectionMissed from CollectionMissed Table /// </summary> /// <param name="collectionMissed"></param> /// <returns> /// CollectionMissed Object /// </returns> public CollectionMissed GetCollectionMissed(CollectionMissed collectionMissed) { try { //Get the collectionMissed Object by collectionMissed Parameter's Id collectionMissedObj = inventory.CollectionMisseds.Where(c => c.Id == collectionMissed.Id).First(); } catch (Exception e) { collectionMissedObj = null; } return collectionMissedObj; }
public Constants.ACTION_STATUS SetCollectionStatus(Constants.COLLECTION_STATUS collectionStatus, List<string> collectionIdList) { foreach (string collectionId in collectionIdList) { RequisitionCollection requisitionCollection = new RequisitionCollection(); requisitionCollection.Id = Converter.objToInt(collectionId); requisitionCollection = requisitionCollectionBroker.GetRequisitionCollection(requisitionCollection); requisitionCollection.Status = Converter.objToInt(collectionStatus); requisitionCollectionBroker.Update(requisitionCollection); if (collectionStatus == Constants.COLLECTION_STATUS.UNCOLLECTED) { CollectionMissed collectionMissed = new CollectionMissed(); collectionMissed.Id = collectionMissedBroker.GetCollectionMissedId(); collectionMissed.Department = requisitionCollection.Department; collectionMissed.CreatedBy = Util.GetEmployee(employeeBroker); collectionMissed.CreatedDate = DateTime.Now; collectionMissed.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW); collectionMissedBroker.Insert(collectionMissed); } } return SystemStoreInventorySystemUtil.Constants.ACTION_STATUS.UNKNOWN; }