/// <summary>
/// Update stationery retrieval by collection point
/// Created By:JinChengCheng
/// Created Date:28-01-2012
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// Modified By:
/// Modified Date:
/// Modification Reason:
/// </summary>
/// <param name=""></param>
/// <returns>The return type of this method is datatable.</returns>
public DataTable GetCollectionIDList()
{
if (dt == null)
{
dt = new DataTable();
dt.Columns.AddRange(dataColumn);
}
else
{
dt.Rows.Clear();
}
collectionList = requisitionCollectionBroker.GetAllRequisitionCollection();
foreach (RequisitionCollection temp in collectionList)
{
dr = dt.NewRow();
dr[columnName[0]] = temp.Id;
dr[columnName[1]] = temp.CollectionPoint == null ? "" : temp.CollectionPoint.Name;
dr[columnName[2]] = temp.CollectionPoint == null ? "" : Converter.dateTimeToString(SystemStoreInventorySystemUtil.Converter.DATE_CONVERTER.DATE, temp.CreatedDate) + " " + temp.CollectionPoint.Time;
dr[columnName[3]] = temp.Department.Representative == null ? "" : temp.Department.Representative.Name;
dr[columnName[4]] = temp.Department == null ? "" : temp.Department.Name;
dr[columnName[5]] = Converter.GetCollectionStatusText(Converter.objToCollectionStatus(temp.Status));
dt.Rows.Add(dr);
}
return(dt);
}
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;
}
}
}
}
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 UpdateCollectionDetailsByRequisitionControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.DEPARTMENT_REPRESENTATIVE);
inventory = new InventoryEntities();
requisitionCollectionBroker = new RequisitionCollectionBroker(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]) };
requisitionDetailDataColumn = new DataColumn[] { new DataColumn(requisitionDetailColumnName[0]),
new DataColumn(requisitionDetailColumnName[1]),
new DataColumn(requisitionDetailColumnName[2]),
new DataColumn(requisitionDetailColumnName[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]) };
}