//public List<Requisition> GetRequisitionList() //{ // return requisitionList; //} /// <summary> /// Show all requisition. /// Created By:JinChengCheng /// Created Date:26-01-2012 /// Modified By:Thazin Win /// Modified Date:02-02-2012 /// Modification Reason:Get requisition list by requistion /// Modified By: /// Modified Date: /// Modification Reason: /// </summary> /// <param name=""></param> /// <returns>The return type of this method is datatable.</returns> public DataTable GetRequisitionList() { dt = new DataTable(); dt.Columns.Add("requisitionID"); dt.Columns.Add("requisitionDate"); dt.Columns.Add("status"); dt.Columns.Add("remainingQty"); dt.Columns.Add("remarks"); List <Requisition> requisitionList = requisitionBroker.GetAllRequisitionByEmployee(Util.GetEmployee().Id);// GetAllRequisitionByStatus(); foreach (Requisition temp in requisitionList) { requisitionDetail = new RequisitionDetail(); // requisitionDetail.Requisition.Id = temp.Id; requisitionDetail.Requisition = temp; //Requisition resultRequisition = requisitionBroker.GetRequisition(temp); RequisitionDetail resultRequisitionDetail = requisitionBroker.GetRequisitionDetail(requisitionDetail); dr = dt.NewRow(); dr["requisitionID"] = temp.Id; dr["requisitionDate"] = temp.CreatedDate; //dr["status"] = Converter.GetRequisitionStatusText(Converter.objToRequisitionStatus(temp.Status)); dr["status"] = temp.Status; dr["status"] = Enum.GetName(typeof(Constants.REQUISITION_STATUS), temp.Status); dr["remainingQty"] = resultRequisitionDetail.Qty - requisitionDetail.DeliveredQty; dr["remarks"] = temp.Remarks; dt.Rows.Add(dr); //dr["requsitionId"] = temp.Id; //dr["requisitionDate"] = temp.CreatedDate; //dr["status"] = temp.Status; //dr["remainingQty"] = resultRequisitionDetail.Qty-requisitionDetail.DeliveredQty; //dr["remarks"] = temp.Remarks; } return(dt); }
//private string[] columnName = new string[] { "RequisitionID", "requisitionDate", "RequisitionBy", "remarks" }; public CheckRequisitionControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.EMPLOYEE); inventory = new InventoryEntities(); requisitionBroker = new RequisitionBroker(inventory); employeeBroker = new EmployeeBroker(inventory); // itemBroker = new ItemBroker(inventory); //pendingRequisitionList = requisitionBroker.GetAllRequisition(Constants.REQUISITION_STATUS.PENDING); // pendingRequisitionList = requisitionBroker.GetAllRequisitionByStatus(Util.GetEmployee().Id); pendingRequisitionList = requisitionBroker.GetAllRequisitionByEmployee(Util.GetEmployee().Id); dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]), new DataColumn(columnName[2]), new DataColumn(columnName[3]), new DataColumn(columnName[4]) }; //requisitionList = new System.Data.Objects.DataClasses.EntityCollection<Requisition>(); //requisitionList = requisitionBroker.GetAllRequisition(); }
//private string[] columnName = new string[] { "RequisitionID", "requisitionDate", "RequisitionBy", "remarks" }; public CheckRequisitionControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.EMPLOYEE); inventory = new InventoryEntities(); requisitionBroker = new RequisitionBroker(inventory); employeeBroker = new EmployeeBroker(inventory); // itemBroker = new ItemBroker(inventory); //pendingRequisitionList = requisitionBroker.GetAllRequisition(Constants.REQUISITION_STATUS.PENDING); // pendingRequisitionList = requisitionBroker.GetAllRequisitionByStatus(Util.GetEmployee().Id); pendingRequisitionList = requisitionBroker.GetAllRequisitionByEmployee(Util.GetEmployee().Id); dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]), new DataColumn(columnName[2]), new DataColumn(columnName[3]), new DataColumn(columnName[4]) }; //requisitionList = new System.Data.Objects.DataClasses.EntityCollection<Requisition>(); //requisitionList = requisitionBroker.GetAllRequisition(); }