/// <summary> /// Update the RequisitionCollectionItem data from the parameter /// </summary> /// <param name="requisitionCollectionItem"></param> /// <returns> /// Return DB_STATUS /// </returns> public Constants.DB_STATUS Update(RequisitionCollectionItem requisitionCollectionItem) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { requisitionCollectionItemObj = inventory.RequisitionCollectionItems.Where(r => r.Id == requisitionCollectionItem.Id).First(); if (!requisitionCollectionItemObj.Equals(null)) { RequisitionCollection requisitionCollectionId = inventory.RequisitionCollections.Where(r => r.Id == requisitionCollectionItem.RequisitionCollection.Id).First(); Item item = inventory.Items.Where(i => i.Id == requisitionCollectionItem.Item.Id).First(); Employee createdBy = inventory.Employees.Where(e => e.Id == requisitionCollectionItem.CreatedBy.Id).First(); requisitionCollectionItemObj.Id = requisitionCollectionItem.Id; requisitionCollectionItemObj.RequisitionCollection = requisitionCollectionId; requisitionCollectionItemObj.Item = item; requisitionCollectionItemObj.CreatedDate = requisitionCollectionItem.CreatedDate; requisitionCollectionItemObj.CreatedBy = createdBy; requisitionCollectionItemObj.Qty = requisitionCollectionItem.Qty; inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return(status); }
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); }
public Constants.ACTION_STATUS SetDeliveryDate(int retrievalNo, DateTime deliveryDate) { Constants.ACTION_STATUS setStatus = Constants.ACTION_STATUS.UNKNOWN; Retrieval retrieval = retrievalList.Find(delegate(Retrieval r) { return(r.Id == retrievalNo); }); foreach (RetrievalDetail retrievalDetail in retrieval.RetrievalDetails) { Requisition requisition = new Requisition(); requisition.Id = retrievalDetail.Requisition.Id; requisition = requisitionBroker.GetRequisition(requisition); RequisitionCollectionDetail requisitionCollectionDetail = requisitionCollectionBroker.GetRequisitionCollectionDetail(requisition); RequisitionCollection requisitionCollection = new RequisitionCollection(); requisitionCollection.Id = requisitionCollectionDetail.RequisitionCollection.Id; requisitionCollection = requisitionCollectionBroker.GetRequisitionCollection(requisitionCollection); requisitionCollection.DeliveryDate = DateTime.Now; requisitionCollection.DeliveryBy = Util.GetEmployee(employeeBroker); requisitionCollectionBroker.Update(requisitionCollection); } return(setStatus); }
private void setRequisitionCollection(int collectionId, List <RequisitionCollection> requisitionCollectionList) { if (null != requisitionCollectionList) { foreach (RequisitionCollection requisitionCollection in requisitionCollectionList) { if (requisitionCollection.Id == collectionId) { this.requisitionCollection = requisitionCollection; break; } } } else { requisitionCollectionList = requisitionCollectionBroker.GetAllRequisitionCollection(currentEmployee.Department, Constants.COLLECTION_STATUS.NEED_TO_COLLECT); foreach (RequisitionCollection requisitionCollection in requisitionCollectionList) { if (requisitionCollection.Id == collectionId) { this.requisitionCollection = requisitionCollection; break; } } } }
/// <summary> /// Update the REquisitionCollectionDetail from the parameter /// </summary> /// <param name="requisitionCollectionDetail"></param> /// <returns> /// Returns DB_STATUS /// </returns> public Constants.DB_STATUS Update(RequisitionCollectionDetail requisitionCollectionDetail) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { requisitionCollectionDetailObj = inventory.RequisitionCollectionDetails.Where(reqObj => reqObj.Id == requisitionCollectionDetail.Id).First(); if (!requisitionCollectionDetailObj.Equals(null)) { Requisition requistionId = inventory.Requisitions.Where(r => r.Id == requisitionCollectionDetail.Requisition.Id).First(); requisitionCollectionObj = inventory.RequisitionCollections.Where(r => r.Id == requisitionCollectionDetail.RequisitionCollection.Id).First(); requisitionCollectionDetailObj.Id = requisitionCollectionDetail.Id; requisitionCollectionDetailObj.Requisition = requistionId; requisitionCollectionDetailObj.RequisitionCollection = requisitionCollectionObj; inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return(status); }
/// <summary> /// Update the Requisition Collection data to the Requisition Collection table /// </summary> /// <param name="requisitionCollection"></param> /// <returns> /// Return DB_STATUS /// </returns> public Constants.DB_STATUS Update(RequisitionCollection requisitionCollection) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { //requisitionCollectionObj = inventory.RequisitionCollections.Where(reqObj => reqObj.Id == requisitionCollection.Id).First(); //Department department = inventory.Departments.Where(d => d.Id == requisitionCollection.Department.Id).First(); //CollectionPoint collectionPoint = inventory.CollectionPoints.Where(c => c.Id == requisitionCollection.CollectionPoint.Id).First(); //Employee createdBy = inventory.Employees.Where(e => e.Id == requisitionCollection.CreatedBy.Id).First(); //requisitionCollectionObj.Id = requisitionCollection.Id; //requisitionCollectionObj.Department = department; //requisitionCollectionObj.CollectionPoint = collectionPoint; //requisitionCollectionObj.CreatedDate = requisitionCollection.CreatedDate; //requisitionCollectionObj.CreatedBy = createdBy; //foreach (RequisitionCollectionDetail rd in requisitionCollectionObj.RequisitionCollectionDetails) //{ // this.Update(rd); //} inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return(status); }
private void setRequisitionCollection(int collectionId, List <RequisitionCollection> requisitionCollectionList) { foreach (RequisitionCollection requisitionCollection in requisitionCollectionList) { if (requisitionCollection.Id == collectionId) { this.requisitionCollection = requisitionCollection; break; } } }
/// <summary> /// Get RequisitionCollection Object according to the RequisitionCollection parameter /// </summary> /// <param name="requisitionCollection"></param> /// <returns> /// Return RequisitionCollection Object /// </returns> public RequisitionCollection GetRequisitionCollection(RequisitionCollection requisitionCollection) { try { requisitionCollectionObj = inventory.RequisitionCollections.Where(reqObj => reqObj.Id == requisitionCollection.Id).First(); } catch (Exception e) { requisitionCollectionObj = null; } return(requisitionCollectionObj); }
/// <summary> /// Refresh requisition list after withdraw one requisition /// Created By:JinChengCheng /// Created Date:26-01-2012 /// Modified By: /// Modified Date: /// Modification Reason: /// Modified By: /// Modified Date: /// Modification Reason: /// </summary> /// <param name="requisitionId"></param> /// <returns>The return type of this method is datatable.</returns> public Constants.ACTION_STATUS Setstatus(string requisitionId, Constants.REQUISITION_STATUS Reqstatus, string remarks, DataTable dt) { Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN; requisition = RequisitionList.Find(delegate(Requisition req) { return(req.Id.Contains(requisitionId)); }); if (Reqstatus != Constants.REQUISITION_STATUS.REJECTED) { foreach (RequisitionDetail temp in requisition.RequisitionDetails) { DataRow[] dr = dt.Select(" ItemCode = '" + temp.Item.Id + "'"); if (dr != null && dr.Length > 0) { temp.Qty = Convert.ToInt16(dr[0][1].ToString()); temp.DeliveredQty = Convert.ToInt16(dr[0][2].ToString()); } } } requisition.Remarks = remarks; requisition.Status = (int)(Reqstatus); requisitionBroker.Update(requisition); if (Reqstatus == Constants.REQUISITION_STATUS.COMPLETE) { RequisitionCollection RC = null; //Get all submitted requisitions RequisitionCollectionDetail rcDetails = requisitionCollectionBroker.GetAllRequisitionCollectionDetail(requisitionId); if (rcDetails != null) { RC = requisitionCollectionBroker.GetAllRequisitionCollectionByRequisitionCollectionID(rcDetails.RequisitionCollection.Id.ToString()); } foreach (RequisitionCollectionDetail rcd in RC.RequisitionCollectionDetails) { if (rcd.Requisition.Status == (int)Constants.REQUISITION_STATUS.COMPLETE) { RC.Status = (int)Constants.COLLECTION_STATUS.COLLECTED; } else { RC.Status = (int)Constants.COLLECTION_STATUS.NEED_TO_COLLECT; } } requisitionCollectionBroker.Update(RC); } return(status); }
/// <summary> /// Logically Delete teh Requisition Collection Table /// </summary> /// <param name="requisitionCollection"></param> /// <returns> /// Return DB_STATUS /// </returns> public Constants.DB_STATUS Delete(RequisitionCollection requisitionCollection) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { requisitionCollectionObj = inventory.RequisitionCollections.Where(reqObj => reqObj.Id == requisitionCollection.Id).First(); requisitionCollectionObj.Status = 2; inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return(status); }
/// <summary> /// Insert the RequistionCollection data to the Requistion Table /// </summary> /// <param name="newRequisitionCollection"></param> /// <returns> /// Returns DB_STATUS /// </returns> public Constants.DB_STATUS Insert(RequisitionCollection newRequisitionCollection) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { foreach (RequisitionCollectionDetail rd in newRequisitionCollection.RequisitionCollectionDetails) { this.Insert(rd); } inventory.AddToRequisitionCollections(newRequisitionCollection); inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return(status); }
public SubmitRequestToStoreControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.DEPARTMENT_REPRESENTATIVE); inventory = new InventoryEntities(); requisitionBroker = new RequisitionBroker(inventory); requisitionCollectionBroker = new RequisitionCollectionBroker(inventory); employeeBroker = new EmployeeBroker(inventory); Employee employee = new Employee(); employee.Id = currentEmployee.Id; employee = employeeBroker.GetEmployee(employee); requisitionCollection = new RequisitionCollection(requisitionCollectionBroker.GetRequisitionCollectionId(), employee.Department, employee.Department.CollectionPoint, DateTime.Now, employee, Converter.objToInt(Constants.COLLECTION_STATUS.NEED_TO_COLLECT)); approvedRequisitionList = requisitionBroker.GetAllRequisition(Constants.REQUISITION_STATUS.APPROVED, currentEmployee.Department); dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]), new DataColumn(columnName[2]), new DataColumn(columnName[3]) }; }
public Constants.ACTION_STATUS SelectCollection(int collectionId) { Constants.ACTION_STATUS selectStatus = Constants.ACTION_STATUS.UNKNOWN; this.requisitionCollection = null; setRequisitionCollection(collectionId, requisitionCollectionList); if (this.requisitionCollection == null) { setRequisitionCollection(collectionId, collectedRequisitionCollectionList); } if (this.requisitionCollection != null) { selectStatus = Constants.ACTION_STATUS.SUCCESS; } else { selectStatus = Constants.ACTION_STATUS.FAIL; } return(selectStatus); }