public PurchaseOrderControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK); InventoryEntities inventory = new InventoryEntities(); supplierBroker = new SupplierBroker(inventory); itemBroker = new ItemBroker(inventory); purchaseOrderBroker = new PurchaseOrderBroker(inventory); itemPriceBroker = new ItemPriceBroker(inventory); employeeBroker = new EmployeeBroker(inventory); //reorderList = GetReorderItemList(); purchaseOrder = new PurchaseOrder(); purchaseOrder.Id = purchaseOrderBroker.GetPurchaseOrderId(); purchaseOrder.CreatedBy = Util.GetEmployee(employeeBroker); purchaseOrder.CreatedDate = DateTime.Now; purchaseOrder.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW); poDetailList = new List <PurchaseOrderDetail>(); addedItemList = new Dictionary <Item, List <double> >(); //purchaseOrderDetailList = new System.Data.Objects.DataClasses.EntityCollection<PurchaseOrderDetail>(); // need to load reorder quantity // need to load unfulfilled quantity supplierColumn = new DataColumn[] { new DataColumn(supplierColumnName[0]), new DataColumn(supplierColumnName[1]) }; dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]), new DataColumn(columnName[2]), new DataColumn(columnName[3]), new DataColumn(columnName[4]) }; }
public CreateDiscrepencyReportControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK); inventory = new InventoryEntities(); discrepancyBroker = new DiscrepancyBroker(inventory); itemBroker = new ItemBroker(inventory); item = new Item(); itemPriceBroker = new ItemPriceBroker(inventory); itemprice = new ItemPrice(); discrepancy = new Discrepancy(); discrepancy.Id = discrepancyBroker.GetDiscrepancyId(); discrepancy.CreatedDate = DateTime.Now; discrepancy.CreatedBy = Util.GetEmployee(new EmployeeBroker(inventory)); discrepancy.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW); // discrepancyDetailList = new System.Data.Objects.DataClasses.EntityCollection<DiscrepancyDetail>(); dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]), new DataColumn(columnName[2]), new DataColumn(columnName[3]), new DataColumn(columnName[4]), new DataColumn(columnName[5]) }; }
public PurchaseOrderControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK); InventoryEntities inventory = new InventoryEntities(); supplierBroker = new SupplierBroker(inventory); itemBroker = new ItemBroker(inventory); purchaseOrderBroker = new PurchaseOrderBroker(inventory); itemPriceBroker = new ItemPriceBroker(inventory); employeeBroker = new EmployeeBroker(inventory); //reorderList = GetReorderItemList(); purchaseOrder = new PurchaseOrder(); purchaseOrder.Id = purchaseOrderBroker.GetPurchaseOrderId(); purchaseOrder.CreatedBy = Util.GetEmployee(employeeBroker); purchaseOrder.CreatedDate = DateTime.Now; purchaseOrder.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW); poDetailList = new List<PurchaseOrderDetail>(); addedItemList = new Dictionary<Item, List<double>>(); //purchaseOrderDetailList = new System.Data.Objects.DataClasses.EntityCollection<PurchaseOrderDetail>(); // need to load reorder quantity // need to load unfulfilled quantity supplierColumn = new DataColumn[] { new DataColumn(supplierColumnName[0]), new DataColumn(supplierColumnName[1])}; dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]), new DataColumn(columnName[2]), new DataColumn(columnName[3]), new DataColumn(columnName[4])}; }
public static Item GetItem(IItemBroker itemBroker, string itemDescription) { Item item = new Item(); item.Description = itemDescription; item = itemBroker.GetItem(item); // need to add a method to return list of item in broker return(item); }
private void init() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK); inventory = new InventoryEntities(); retrievalBroker = new RetrievalBroker(inventory); employeeBroker = new EmployeeBroker(inventory); itemBroker = new ItemBroker(inventory); departmentBroker = new DepartmentBroker(inventory); }
// private DataColumn[] discrepancyItemListColumn; public IssueAdjustmentVoucherControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_SUPERVISOR); InventoryEntities inventoryEntities = new InventoryEntities(); employeeBroker = new EmployeeBroker(inventoryEntities); discrepancyBroker = new DiscrepancyBroker(inventoryEntities); itemBroker = new ItemBroker(inventoryEntities); // discrepancyList = new System.Data.Objects.DataClasses.EntityCollection<Discrepancy>(); listColumn = new DataColumn[]{new DataColumn(listColumnName[0]),new DataColumn(listColumnName[1]),new DataColumn(listColumnName[2]),new DataColumn(listColumnName[3]) }; detailColumn = new DataColumn[] { new DataColumn(detailColumnName[0]), new DataColumn(detailColumnName[1]), new DataColumn(detailColumnName[2]), new DataColumn(detailColumnName[3]), new DataColumn(detailColumnName[4]) }; }
// private DataColumn[] discrepancyItemListColumn; public IssueAdjustmentVoucherControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_SUPERVISOR); InventoryEntities inventoryEntities = new InventoryEntities(); employeeBroker = new EmployeeBroker(inventoryEntities); discrepancyBroker = new DiscrepancyBroker(inventoryEntities); itemBroker = new ItemBroker(inventoryEntities); // discrepancyList = new System.Data.Objects.DataClasses.EntityCollection<Discrepancy>(); listColumn = new DataColumn[] { new DataColumn(listColumnName[0]), new DataColumn(listColumnName[1]), new DataColumn(listColumnName[2]), new DataColumn(listColumnName[3]) }; detailColumn = new DataColumn[] { new DataColumn(detailColumnName[0]), new DataColumn(detailColumnName[1]), new DataColumn(detailColumnName[2]), new DataColumn(detailColumnName[3]), new DataColumn(detailColumnName[4]) }; }
public ViewStockCardControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK); InventoryEntities inventory = new InventoryEntities(); itemBroker = new ItemBroker(inventory); itemPriceBroker = new ItemPriceBroker(inventory); dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]), new DataColumn(columnName[2]), new DataColumn(columnName[3]) }; }
public ViewStockCardControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK); InventoryEntities inventory = new InventoryEntities(); itemBroker = new ItemBroker(inventory); itemPriceBroker = new ItemPriceBroker(inventory); dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]), new DataColumn(columnName[2]), new DataColumn(columnName[3])}; }
public ReceiveOrderControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK); InventoryEntities inventory = new InventoryEntities(); purchaseOrderBroker = new PurchaseOrderBroker(inventory); itemBroker = new ItemBroker(inventory); employeeBroker = new EmployeeBroker(inventory); purchaseOrderList = purchaseOrderBroker.GetAllPurchaseOrder(); dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]) }; detailColumn = new DataColumn[] { new DataColumn(detail[0]), new DataColumn(detail[1]), new DataColumn(detail[2]), new DataColumn(detail[3]) }; }
public CreateStationeryRetrievalListControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK); inventory = new InventoryEntities(); retrievalBroker = new RetrievalBroker(inventory); requisitionCollectionBroker = new RequisitionCollectionBroker(inventory); itemBroker = new ItemBroker(inventory); employeeBroker = new EmployeeBroker(inventory); //retrievalList = retrievalBroker.GetAllRetrieval(); requisitionCollectionList = requisitionCollectionBroker.GetAllRequisitionCollection(Constants.COLLECTION_STATUS.NEED_TO_RETRIEVE); collectionDataColumn = new DataColumn[] { new DataColumn(collectionColumnName[0]), new DataColumn(collectionColumnName[1]), new DataColumn(collectionColumnName[2]), new DataColumn(collectionColumnName[3]) }; }
public ReceiveOrderControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK); InventoryEntities inventory = new InventoryEntities(); purchaseOrderBroker = new PurchaseOrderBroker(inventory); itemBroker = new ItemBroker(inventory); employeeBroker = new EmployeeBroker(inventory); purchaseOrderList = purchaseOrderBroker.GetAllPurchaseOrder(); dataColumn = new DataColumn[]{ new DataColumn(columnName[0]), new DataColumn(columnName[1]) }; detailColumn = new DataColumn[]{new DataColumn(detail[0]), new DataColumn(detail[1]),new DataColumn(detail[2]),new DataColumn(detail[3])}; }
//CC public static DataTable GetItemTable(IItemBroker itemBroker, string itemDescription) { Item item = GetItem(itemBroker, itemDescription); DataTable dt = new DataTable(); dt.Columns.Add("ItemNo"); dt.Columns.Add("ItemDescription"); DataRow dr; if (item != null) { dr = dt.NewRow(); dr["ItemNo"] = item.Id; dr["ItemDescription"] = item.Description; dt.Rows.Add(dr); } return(dt); }
public RequestStationeryControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.EMPLOYEE); InventoryEntities inventory = new InventoryEntities(); requisitionBroker = new RequisitionBroker(inventory); itemBroker = new ItemBroker(inventory); employeeBroker = new EmployeeBroker(inventory); requisition = new Requisition(); requisition.CreatedBy = Util.GetEmployee(employeeBroker); requisition.Department = requisition.CreatedBy.Department; requisition.Status = Converter.objToInt(Constants.REQUISITION_STATUS.PENDING); requisition.Id = requisitionBroker.GetRequisitionId(requisition); itemAdded = 0; dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]), new DataColumn(columnName[2]) }; }
public UpdateCollectionDetailsByRequisitionItemControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.DEPARTMENT_REPRESENTATIVE); inventory = new InventoryEntities(); requisitionCollectionBroker = new RequisitionCollectionBroker(inventory); requisitionCollectionItemBroker = new RequisitionCollectionItemBroker(inventory); itemBroker = new ItemBroker(inventory); employeeBroker = new EmployeeBroker(inventory); requisitionCollectionList = requisitionCollectionBroker.GetAllRequisitionCollection(currentEmployee.Department, Constants.COLLECTION_STATUS.NEED_TO_COLLECT); //collectedRequisitionCollectionList = requisitionCollectionBroker.GetAllRequisitionCollection(currentEmployee.Department, Constants.COLLECTION_STATUS.COLLECTED); collectionListDataColumn = new DataColumn[] { new DataColumn(collectionListColumnName[0]), new DataColumn(collectionListColumnName[1]), new DataColumn(collectionListColumnName[2]), new DataColumn(collectionListColumnName[3]), new DataColumn(collectionListColumnName[4]) }; itemDetailDataColumn = new DataColumn[] { new DataColumn(itemDetailColumnName[0]), new DataColumn(itemDetailColumnName[1]), new DataColumn(itemDetailColumnName[2]), new DataColumn(itemDetailColumnName[3]) }; }
public static Item GetItem(IItemBroker itemBroker, string itemDescription) { Item item = new Item(); item.Description = itemDescription; item = itemBroker.GetItem(item); // need to add a method to return list of item in broker return item; }
//CC public static DataTable GetItemTable(IItemBroker itemBroker, string itemDescription) { Item item = GetItem(itemBroker, itemDescription); DataTable dt = new DataTable(); dt.Columns.Add("ItemNo"); dt.Columns.Add("ItemDescription"); DataRow dr; if (item != null) { dr = dt.NewRow(); dr["ItemNo"] = item.Id; dr["ItemDescription"] = item.Description; dt.Rows.Add(dr); } return dt; }