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 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 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 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 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 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;
}
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);
}
//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;
}
