/// <summary>
/// Update the RequisitionCollectionItem data from the parameter
/// </summary>
/// <param name="requisitionCollectionItem"></param>
/// <returns>
/// Return DB_STATUS
/// </returns>
public Constants.DB_STATUS Update(RequisitionCollectionItem requisitionCollectionItem)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
requisitionCollectionItemObj = inventory.RequisitionCollectionItems.Where(r => r.Id == requisitionCollectionItem.Id).First();
if (!requisitionCollectionItemObj.Equals(null))
{
RequisitionCollection requisitionCollectionId = inventory.RequisitionCollections.Where(r => r.Id == requisitionCollectionItem.RequisitionCollection.Id).First();
Item item = inventory.Items.Where(i => i.Id == requisitionCollectionItem.Item.Id).First();
Employee createdBy = inventory.Employees.Where(e => e.Id == requisitionCollectionItem.CreatedBy.Id).First();
requisitionCollectionItemObj.Id = requisitionCollectionItem.Id;
requisitionCollectionItemObj.RequisitionCollection = requisitionCollectionId;
requisitionCollectionItemObj.Item = item;
requisitionCollectionItemObj.CreatedDate = requisitionCollectionItem.CreatedDate;
requisitionCollectionItemObj.CreatedBy = createdBy;
requisitionCollectionItemObj.Qty = requisitionCollectionItem.Qty;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return(status);
}
public Constants.ACTION_STATUS SetCollectionStatus(Constants.COLLECTION_STATUS collectionStatus, List <string> collectionIdList)
{
foreach (string collectionId in collectionIdList)
{
RequisitionCollection requisitionCollection = new RequisitionCollection();
requisitionCollection.Id = Converter.objToInt(collectionId);
requisitionCollection = requisitionCollectionBroker.GetRequisitionCollection(requisitionCollection);
requisitionCollection.Status = Converter.objToInt(collectionStatus);
requisitionCollectionBroker.Update(requisitionCollection);
if (collectionStatus == Constants.COLLECTION_STATUS.UNCOLLECTED)
{
CollectionMissed collectionMissed = new CollectionMissed();
collectionMissed.Id = collectionMissedBroker.GetCollectionMissedId();
collectionMissed.Department = requisitionCollection.Department;
collectionMissed.CreatedBy = Util.GetEmployee(employeeBroker);
collectionMissed.CreatedDate = DateTime.Now;
collectionMissed.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW);
collectionMissedBroker.Insert(collectionMissed);
}
}
return(SystemStoreInventorySystemUtil.Constants.ACTION_STATUS.UNKNOWN);
}
public Constants.ACTION_STATUS SetDeliveryDate(int retrievalNo, DateTime deliveryDate)
{
Constants.ACTION_STATUS setStatus = Constants.ACTION_STATUS.UNKNOWN;
Retrieval retrieval = retrievalList.Find(delegate(Retrieval r) { return(r.Id == retrievalNo); });
foreach (RetrievalDetail retrievalDetail in retrieval.RetrievalDetails)
{
Requisition requisition = new Requisition();
requisition.Id = retrievalDetail.Requisition.Id;
requisition = requisitionBroker.GetRequisition(requisition);
RequisitionCollectionDetail requisitionCollectionDetail = requisitionCollectionBroker.GetRequisitionCollectionDetail(requisition);
RequisitionCollection requisitionCollection = new RequisitionCollection();
requisitionCollection.Id = requisitionCollectionDetail.RequisitionCollection.Id;
requisitionCollection = requisitionCollectionBroker.GetRequisitionCollection(requisitionCollection);
requisitionCollection.DeliveryDate = DateTime.Now;
requisitionCollection.DeliveryBy = Util.GetEmployee(employeeBroker);
requisitionCollectionBroker.Update(requisitionCollection);
}
return(setStatus);
}
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;
}
}
}
}
/// <summary>
/// Update the REquisitionCollectionDetail from the parameter
/// </summary>
/// <param name="requisitionCollectionDetail"></param>
/// <returns>
/// Returns DB_STATUS
/// </returns>
public Constants.DB_STATUS Update(RequisitionCollectionDetail requisitionCollectionDetail)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
requisitionCollectionDetailObj = inventory.RequisitionCollectionDetails.Where(reqObj => reqObj.Id == requisitionCollectionDetail.Id).First();
if (!requisitionCollectionDetailObj.Equals(null))
{
Requisition requistionId = inventory.Requisitions.Where(r => r.Id == requisitionCollectionDetail.Requisition.Id).First();
requisitionCollectionObj = inventory.RequisitionCollections.Where(r => r.Id == requisitionCollectionDetail.RequisitionCollection.Id).First();
requisitionCollectionDetailObj.Id = requisitionCollectionDetail.Id;
requisitionCollectionDetailObj.Requisition = requistionId;
requisitionCollectionDetailObj.RequisitionCollection = requisitionCollectionObj;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return(status);
}
/// <summary>
/// Update the Requisition Collection data to the Requisition Collection table
/// </summary>
/// <param name="requisitionCollection"></param>
/// <returns>
/// Return DB_STATUS
/// </returns>
public Constants.DB_STATUS Update(RequisitionCollection requisitionCollection)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
//requisitionCollectionObj = inventory.RequisitionCollections.Where(reqObj => reqObj.Id == requisitionCollection.Id).First();
//Department department = inventory.Departments.Where(d => d.Id == requisitionCollection.Department.Id).First();
//CollectionPoint collectionPoint = inventory.CollectionPoints.Where(c => c.Id == requisitionCollection.CollectionPoint.Id).First();
//Employee createdBy = inventory.Employees.Where(e => e.Id == requisitionCollection.CreatedBy.Id).First();
//requisitionCollectionObj.Id = requisitionCollection.Id;
//requisitionCollectionObj.Department = department;
//requisitionCollectionObj.CollectionPoint = collectionPoint;
//requisitionCollectionObj.CreatedDate = requisitionCollection.CreatedDate;
//requisitionCollectionObj.CreatedBy = createdBy;
//foreach (RequisitionCollectionDetail rd in requisitionCollectionObj.RequisitionCollectionDetails)
//{
// this.Update(rd);
//}
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return(status);
}
private void setRequisitionCollection(int collectionId, List <RequisitionCollection> requisitionCollectionList)
{
foreach (RequisitionCollection requisitionCollection in requisitionCollectionList)
{
if (requisitionCollection.Id == collectionId)
{
this.requisitionCollection = requisitionCollection;
break;
}
}
}
/// <summary>
/// Get RequisitionCollection Object according to the RequisitionCollection parameter
/// </summary>
/// <param name="requisitionCollection"></param>
/// <returns>
/// Return RequisitionCollection Object
/// </returns>
public RequisitionCollection GetRequisitionCollection(RequisitionCollection requisitionCollection)
{
try
{
requisitionCollectionObj = inventory.RequisitionCollections.Where(reqObj => reqObj.Id == requisitionCollection.Id).First();
}
catch (Exception e)
{
requisitionCollectionObj = null;
}
return(requisitionCollectionObj);
}
/// <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>
/// Logically Delete teh Requisition Collection Table
/// </summary>
/// <param name="requisitionCollection"></param>
/// <returns>
/// Return DB_STATUS
/// </returns>
public Constants.DB_STATUS Delete(RequisitionCollection requisitionCollection)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
requisitionCollectionObj = inventory.RequisitionCollections.Where(reqObj => reqObj.Id == requisitionCollection.Id).First();
requisitionCollectionObj.Status = 2;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return(status);
}
/// <summary>
/// Insert the RequistionCollection data to the Requistion Table
/// </summary>
/// <param name="newRequisitionCollection"></param>
/// <returns>
/// Returns DB_STATUS
/// </returns>
public Constants.DB_STATUS Insert(RequisitionCollection newRequisitionCollection)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
foreach (RequisitionCollectionDetail rd in newRequisitionCollection.RequisitionCollectionDetails)
{
this.Insert(rd);
}
inventory.AddToRequisitionCollections(newRequisitionCollection);
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return(status);
}
public SubmitRequestToStoreControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.DEPARTMENT_REPRESENTATIVE);
inventory = new InventoryEntities();
requisitionBroker = new RequisitionBroker(inventory);
requisitionCollectionBroker = new RequisitionCollectionBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
Employee employee = new Employee();
employee.Id = currentEmployee.Id;
employee = employeeBroker.GetEmployee(employee);
requisitionCollection = new RequisitionCollection(requisitionCollectionBroker.GetRequisitionCollectionId(), employee.Department, employee.Department.CollectionPoint, DateTime.Now, employee, Converter.objToInt(Constants.COLLECTION_STATUS.NEED_TO_COLLECT));
approvedRequisitionList = requisitionBroker.GetAllRequisition(Constants.REQUISITION_STATUS.APPROVED, currentEmployee.Department);
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]) };
}
public Constants.ACTION_STATUS SelectCollection(int collectionId)
{
Constants.ACTION_STATUS selectStatus = Constants.ACTION_STATUS.UNKNOWN;
this.requisitionCollection = null;
setRequisitionCollection(collectionId, requisitionCollectionList);
if (this.requisitionCollection == null)
{
setRequisitionCollection(collectionId, collectedRequisitionCollectionList);
}
if (this.requisitionCollection != null)
{
selectStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
selectStatus = Constants.ACTION_STATUS.FAIL;
}
return(selectStatus);
}
