//public RequisitionDetail SelectRequisitionID(string requisitionId) //{ // //requisition = new Requisition(); // RequisitionDetail requisitionDetail = new RequisitionDetail(); // requisitionDetail.Id = requisitionId; // RequisitionDetail resultRequisitionDetail=requisitionBroker.GetRequisitionDetail(requisitionDetail); //} /// <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 SelectWithdraw(string requisitionId, string remarks) { Constants.REQUISITION_STATUS requisitionStatus = Constants.REQUISITION_STATUS.WITHDRAW; Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN; //Employee employee = new Employee(); //employee.Id = currentEmployee.Id; //employee = employeeBroker.GetEmployee(employee); requisition = new Requisition(); requisition.Id = requisitionId; requisition = requisitionBroker.GetRequisition(requisition); requisition.Remarks = (remarks == null ? String.Empty : remarks); //requisition.ApprovedBy = employee; //requisition.ApprovedDate = DateTime.Now; requisition.Status = Converter.objToInt(requisitionStatus); if (requisitionBroker.Update(requisition) == Constants.DB_STATUS.FAILED) { status = Constants.ACTION_STATUS.FAIL; } else { status = Constants.ACTION_STATUS.SUCCESS; } return(status); //Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN; //Constants.DB_STATUS dbStatus = requisitionBroker.Delete(requisition); //dbStatus = Constants.DB_STATUS.SUCCESSFULL; //if (requisitionList.Count == 1) // return null; //else // return GetRequisitionList(); }
public static string GetRequisitionStatusText(Constants.REQUISITION_STATUS requisitionStatus) { string status = null; switch (requisitionStatus) { case Constants.REQUISITION_STATUS.PENDING: status = "Pending"; break; case Constants.REQUISITION_STATUS.APPROVED: status = "Approved"; break; case Constants.REQUISITION_STATUS.REJECTED: status = "Rejected"; break; case Constants.REQUISITION_STATUS.SUBMITTED: status = "Submitted"; break; case Constants.REQUISITION_STATUS.WITHDRAW: status = "Withdraw"; break; case Constants.REQUISITION_STATUS.COMPLETE: status = "Complete"; break; } return(status); }
/// <summary> /// Converts object to Requisition Status /// </summary> /// <param name="obj"></param> /// <returns></returns> public static Constants.REQUISITION_STATUS objToRequisitionStatus(object obj) { Constants.REQUISITION_STATUS status = Constants.REQUISITION_STATUS.UNKNOWN; switch (objToShort(obj)) { case 1: status = Constants.REQUISITION_STATUS.PENDING; break; case 2: status = Constants.REQUISITION_STATUS.APPROVED; break; case 3: status = Constants.REQUISITION_STATUS.REJECTED; break; case 4: status = Constants.REQUISITION_STATUS.SUBMITTED; break; case 5: status = Constants.REQUISITION_STATUS.WITHDRAW; break; case 7: status = Constants.REQUISITION_STATUS.COMPLETE; break; } return(status); }
/// <summary> /// Retreive All of the requisition information according to status /// </summary> /// <param name="requisitionStatus"></param> /// <returns></returns> public List <Requisition> GetAllRequisition(Constants.REQUISITION_STATUS requisitionStatus) { try { int status = Converter.objToInt(requisitionStatus); requisitionList = inventory.Requisitions.Where(reqObj => reqObj.Status == status).ToList <Requisition>(); } catch (Exception e) { requisitionList = null; } return(requisitionList); }
/// <summary> /// Retreive All of the requisition information according to status /// </summary> /// <param name="requisitionStatus"></param> /// <returns></returns> public List <Requisition> GetAllRequisition(Constants.REQUISITION_STATUS requisitionStatus, Department department) { try { int status = Converter.objToInt(requisitionStatus); requisitionList = inventory.Requisitions.Where(reqObj => reqObj.Status == status && reqObj.Department.Id.Contains(department.Id)).OrderByDescending(reqObj => reqObj.CreatedDate).ToList <Requisition>(); } catch (Exception e) { requisitionList = null; } return(requisitionList); }
/// <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> /// Retrieve All of the Requisition information according to the status /// </summary> /// <returns> /// List of Requisition /// </returns> public List <Requisition> GetAllRequisitionByEmployee(int employeeID) { Constants.REQUISITION_STATUS requisitionStatus = Constants.REQUISITION_STATUS.HIDDEN; try { int status = Converter.objToInt(requisitionStatus); requisitionList = inventory.Requisitions.Where(reqObj => reqObj.CreatedBy.Id == employeeID && reqObj.Status != status).OrderByDescending(reqObj => reqObj.CreatedDate).ToList <Requisition>(); } catch (Exception e) { requisitionList = null; } return(requisitionList); }
private Constants.ACTION_STATUS SelectActionRequisition(Dictionary <string, string> remarks, Constants.REQUISITION_STATUS requisitionStatus) { Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN; if (remarks.Count > 0) { status = Constants.ACTION_STATUS.SUCCESS; Requisition requisition; Employee employee = new Employee(); employee.Id = currentEmployee.Id; employee = employeeBroker.GetEmployee(employee); int actionIndex = 0; foreach (string key in remarks.Keys) { requisition = pendingRequisitionList.ElementAt(Converter.objToInt(key) - (actionIndex++)); requisition.Status = Converter.objToInt(requisitionStatus); requisition.Remarks = remarks[key]; requisition.ApprovedBy = employee; requisition.ApprovedDate = DateTime.Now; pendingRequisitionList.Remove(requisition); if (requisitionBroker.Update(requisition) == Constants.DB_STATUS.FAILED) { status = Constants.ACTION_STATUS.FAIL; break; } } } else { status = Constants.ACTION_STATUS.FAIL; } return(status); }