/// <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 RequisitionCollectionItem GetRequisitionCollectionItem(RequisitionCollectionItem requisitionCollectionItem) { reqCollectionItem = inventory.RequisitionCollectionItems.Where(r => r.Id == requisitionCollectionItem.Id).First(); if (!reqCollectionItem.Equals(null)) { Item item = inventory.Items.Where(i => i.Id == reqCollectionItem.Item.Id).First(); // int i=Convert.ToInt32(inventory.Items.Last().Id) + 1; reqCollectionItem.Item = item; return(reqCollectionItem); } return(null); }
/// <summary> /// Get the RequisitionCollectionItem from the RequisitionCollectionItem table /// </summary> /// <param name="requisitionCollectionItem"></param> /// <returns> /// Returns RequisitionCollectionItem /// </returns> public RequisitionCollectionItem GetRequisitionCollectionItem(RequisitionCollectionItem requisitionCollectionItem) { try { requisitionCollectionItemObj = inventory.RequisitionCollectionItems.Where(r => r.Id == requisitionCollectionItem.Id).First(); if (!requisitionCollectionItemObj.Equals(null)) { Item item = inventory.Items.Where(i => i.Id == requisitionCollectionItemObj.Item.Id).First(); // int i=Convert.ToInt32(inventory.Items.Last().Id) + 1; requisitionCollectionItemObj.Item = item; } } catch (Exception e) { requisitionCollectionItemObj = null; } return(requisitionCollectionItemObj); }