/// <summary> /// Update RetrievalDetail data to RetrievalDetail Table according to the RetrievalDetail Parameter /// Return Constants.DB_STATUS /// </summary> /// <param name="retrievalDetail"></param> /// <returns></returns> public Constants.DB_STATUS Update(RetrievalDetail retrievalDetail) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { RetrievalDetail rDetail = inventory.RetrievalDetails.Where(rObj => rObj.Id == retrievalDetail.Id).First(); if (!rDetail.Equals(null)) { retrieval = inventory.Retrievals.Where(r => r.Id == retrievalDetail.Retrieval.Id).First(); Item item = inventory.Items.Where(i => i.Id == retrievalDetail.Item.Id).First(); Department department = inventory.Departments.Where(d => d.Id == retrievalDetail.Department.Id).First(); rDetail.Retrieval = retrieval; rDetail.Item = item; rDetail.Department = department; rDetail.NeededQty = retrievalDetail.NeededQty; rDetail.ActualQty = retrievalDetail.ActualQty; inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return status; }
/// <summary> /// There is no status in RetrievalTable. /// </summary> /// <param name="retrievalDetail"></param> /// <returns></returns> public Constants.DB_STATUS Delete(RetrievalDetail retrievalDetail) { throw new NotImplementedException(); }
/// <summary> /// Insert RetrievalDetail data to the RetrievalDetail Table according to the RetrievalDetail Parameter /// Return Constants.DB_STATUS /// </summary> /// <param name="newRetrievalDetail"></param> /// <returns></returns> public Constants.DB_STATUS Insert(RetrievalDetail newRetrievalDetail) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { inventory.AddToRetrievalDetails(newRetrievalDetail); inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return status; }
/// <summary> /// Retrieve the RetrievalDetail information from RetrievalDetail Table according to the RetrievalDetail Parameter /// </summary> /// <param name="retrievalDetail"></param> /// <returns></returns> public RetrievalDetail GetRetrievalDetail(RetrievalDetail retrievalDetail) { try { retrievalDetail = inventory.RetrievalDetails.Where(rObj => rObj.Id == retrievalDetail.Id).First(); } catch (Exception e) { retrievalDetail = null; } return retrievalDetail; }
/// <summary> /// Deprecated Method for adding a new object to the RetrievalDetails EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToRetrievalDetails(RetrievalDetail retrievalDetail) { base.AddObject("RetrievalDetails", retrievalDetail); }
/// <summary> /// Create a new RetrievalDetail object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="neededQty">Initial value of the NeededQty property.</param> public static RetrievalDetail CreateRetrievalDetail(global::System.Int32 id, global::System.Int32 neededQty) { RetrievalDetail retrievalDetail = new RetrievalDetail(); retrievalDetail.Id = id; retrievalDetail.NeededQty = neededQty; return retrievalDetail; }
public ManageStationeryRetrievalListControl(object obj) { if (obj is List<RequisitionCollection>) { init(); requisitionCollectionBroker = new RequisitionCollectionBroker(inventory); List<RequisitionCollection> requisitionCollectionList = (List<RequisitionCollection>)obj; retrieval = new Retrieval(retrievalBroker.GetRetrievalId(), DateTime.Now, Util.GetEmployee(employeeBroker), Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW)); retrievalList = new Dictionary<string, List<object>>(); unfulfilledRetrievalList = new Dictionary<string, List<object>>(); foreach (RequisitionCollection requisitionCollection in requisitionCollectionList) { foreach (RequisitionCollectionDetail requisitionCollectionDetail in requisitionCollection.RequisitionCollectionDetails) { foreach (RequisitionDetail requisitionDetail in requisitionCollectionDetail.Requisition.RequisitionDetails) { if (unfulfilledRetrievalList.ContainsKey(requisitionDetail.Item.Id.Trim())) { retrievalInfo = unfulfilledRetrievalList[requisitionDetail.Item.Id]; retrievalInfo[2] = Converter.objToInt(retrievalInfo[2]) + Converter.objToInt(requisitionDetail.Qty); ((RetrievalTable)retrievalInfo[4]).Add(requisitionCollectionDetail.Requisition.Department.Name, requisitionDetail.Qty, 0, requisitionCollectionDetail.Requisition.CreatedDate); // have the same total with current balance / fulfilled //if (Converter.objToInt(retrievalInfo[2]) <= Converter.objToInt(retrievalInfo[3])) //{ // ((RetrievalTable)retrievalInfo[4]).FullFill(); // retrievalList.Add(requisitionDetail.Item.Id, retrievalInfo); // unfulfilledRetrievalList.Remove(requisitionDetail.Item.Id); //} //else //{ unfulfilledRetrievalList[requisitionDetail.Item.Id] = retrievalInfo; //} } else { retrievalInfo = new List<object>(); retrievalInfo.Add(requisitionDetail.Item.Description); retrievalInfo.Add(requisitionDetail.Item.Bin); retrievalInfo.Add(requisitionDetail.Qty); int currentItemBalance = itemBroker.GetCurrentBalance(requisitionDetail.Item); retrievalInfo.Add(currentItemBalance); retrievalInfo.Add(new RetrievalTable(requisitionCollectionDetail.Requisition.Department.Name, requisitionDetail.Qty, 0, requisitionCollectionDetail.Requisition.CreatedDate)); //if (requisitionDetail.Qty <= currentItemBalance) //{ // retrievalList.Add(requisitionDetail.Item.Id, retrievalInfo); //} //else //{ unfulfilledRetrievalList.Add(requisitionDetail.Item.Id.Trim(), retrievalInfo); //} } } } requisitionCollection.Status = Converter.objToInt(Constants.COLLECTION_STATUS.NEED_TO_COLLECT); requisitionCollectionBroker.Update(requisitionCollection); } List<string> keyToBeRemoved = new List<string>(); foreach (string key in unfulfilledRetrievalList.Keys) { retrievalInfo = unfulfilledRetrievalList[key]; if (((RetrievalTable)retrievalInfo[4]).GetTotalQty("NeededQty") <= Converter.objToInt(retrievalInfo[3])) { ((RetrievalTable)retrievalInfo[4]).FullFill(); retrievalList.Add(key, retrievalInfo); keyToBeRemoved.Add(key); } } foreach (string key in keyToBeRemoved) { unfulfilledRetrievalList.Remove(key); } int addedId = 0; foreach (string key in retrievalList.Keys) { retrievalInfo = retrievalList[key]; Item item = new Item(); item.Id = key; item = itemBroker.GetItem(item); foreach(DataRow dr in ((RetrievalTable)retrievalInfo[4]).Rows) { RetrievalDetail retrievalDetail = new RetrievalDetail(); retrievalDetail.Id = retrievalBroker.GetRetrievalDetailId() + (addedId++); retrievalDetail.Item = item; Department department = new Department(); department.Name = dr["Department"].ToString(); department = departmentBroker.GetDepartment(department); retrievalDetail.Department = department; retrievalDetail.NeededQty = Converter.objToInt(dr["NeededQty"]); retrievalDetail.ActualQty = Converter.objToInt(dr["ActualQty"]); retrieval.RetrievalDetails.Add(retrievalDetail); } } foreach (string key in unfulfilledRetrievalList.Keys) { retrievalInfo = unfulfilledRetrievalList[key]; Item item = new Item(); item.Id = key; item = itemBroker.GetItem(item); foreach (DataRow dr in ((RetrievalTable)retrievalInfo[4]).Rows) { RetrievalDetail retrievalDetail = new RetrievalDetail(); retrievalDetail.Id = retrievalBroker.GetRetrievalDetailId() + (addedId++); retrievalDetail.Item = item; Department department = new Department(); department.Name = dr["Department"].ToString(); department = departmentBroker.GetDepartment(department); retrievalDetail.Department = department; retrievalDetail.NeededQty = Converter.objToInt(dr["NeededQty"]); retrievalDetail.ActualQty = Converter.objToInt(dr["ActualQty"]); retrieval.RetrievalDetails.Add(retrievalDetail); } } if (retrievalBroker.Insert(retrieval) == Constants.DB_STATUS.FAILED) { // do something } } }