private MakeNewRequestModel _updateViewModelCategory(MakeNewRequestModel model, string itemCode) { List <Stock_Inventory> stocks = Session[SESSION_STOCKS] as List <Stock_Inventory>; model.DictDescriptions = stocks.Where(w => w.cat_id == model.CurrentCategory).ToDictionary(k => k.item_code, v => v.item_description); if (itemCode == null) { var stList = stocks.Where(w => w.cat_id == model.CurrentCategory); if (stList.Count() > 0) { Stock_Inventory st = stocks.Where(w => w.cat_id == model.CurrentCategory).First(); model.CurrentItem = st.item_code; } else { model.CurrentItem = null; } } else { model.CurrentItem = itemCode; } return(_updateViewModelItem(model)); }
//chnage into Item Name to item COode public string changeItemNametoCode(string itemName) { Stock_Inventory st = context.Stock_Inventory.SingleOrDefault(x => x.item_description == itemName); string itemCode = st.item_code; return(itemCode); }
public ItemModel GetItemModel(string itemCode) { SSISEntities context = new SSISEntities(); Stock_Inventory iventory = context.Stock_Inventory.Where(x => x.item_code == itemCode).ToList().First(); ItemModel model = new ItemModel(iventory); return(model); }
public ItemModel(Stock_Inventory stock) { itemCode = stock.item_code; description = stock.item_description; category = stock.Category; catName = category.cat_name; unitOfMeasure = stock.unit_of_measure; imagePath = stock.image_path; currentQuantity = stock.current_qty; reorderLevel = stock.reorder_level; reorderQuantity = stock.reorder_qty; //Changes for dashboard var stockItems = stock.Tender_List_Details.Where(w => w.deleted != "Y" && w.Tender_List.deleted != "Y" && w.Tender_List.tender_date.Year == DateTime.Now.Year); prices = new Dictionary <Supplier, double>(); using (SSISEntities context = new SSISEntities()) { // get tender list details associated with this item code IEnumerable <Tender_List_Details> details = context.Tender_List_Details .Where(w => w.Tender_List.tender_date.Year == DateTime.Now.Year && w.Tender_List.deleted != "Y" && w.item_code == itemCode && w.deleted != "Y") // Get distinct .GroupBy(d => d.Tender_List.supplier_id) .Select(group => group.FirstOrDefault()); Supplier sup = context.Suppliers.First(); if (details.Count() == 0) { // cannot find for whatever reason prices.Add(sup, 0.0); } else { // can find foreach (var detail in details) { prices.Add(detail.Tender_List.Supplier, Convert.ToDouble(detail.price)); } } } //foreach (var stockItem in stockItems) //{ // if (! prices.ContainsKey(stockItem.Tender_List.Supplier)) // { // prices.Add(stockItem.Tender_List.Supplier, Convert.ToDouble(stockItem.price)); // } //} //prices = stockItems.ToDictionary(x => x.Tender_List.Supplier, x => Convert.ToDouble(x.price)); //prices = stock.Tender_List_Details.Where(w => w.deleted != "Y" && w.Tender_List.deleted != "Y" && w.Tender_List.tender_date.Year == DateTime.Now.Year).ToDictionary(x => x.Tender_List.Supplier, x => Convert.ToDouble(x.price)); }
public void UpdateFileDiscrepancies(List <WCF_FileDiscrepancy> fileDiscrepancies, string username) { Inventory_Adjustment invAdjustmentSup = new Inventory_Adjustment(); invAdjustmentSup.deleted = "N"; invAdjustmentSup.clerk_user = username; invAdjustmentSup.status = "Pending"; invAdjustmentSup.date = DateTime.Today; invAdjustmentSup.status_date = DateTime.Today; Inventory_Adjustment invAdjustmentMan = new Inventory_Adjustment(); invAdjustmentMan.deleted = "N"; invAdjustmentMan.clerk_user = username; invAdjustmentMan.status = "Pending"; invAdjustmentMan.date = DateTime.Today; invAdjustmentMan.status_date = DateTime.Today; foreach (WCF_FileDiscrepancy i in fileDiscrepancies) { int adjusted = int.Parse(i.adjustedQty); Stock_Inventory inventory = context.Stock_Inventory.Where(x => x.item_code == i.itemCode).ToList().First(); inventory.current_qty += adjusted; MonthlyCheckModel itemModel = new MonthlyCheckModel(inventory); double cost = Math.Abs(adjusted) * itemModel.AveragePrice; Adjustment_Details adjDetails = new Adjustment_Details(); adjDetails.deleted = "N"; adjDetails.item_code = inventory.item_code; adjDetails.quantity_adjusted = adjusted; adjDetails.reason = i.reason; if (cost < 250) { invAdjustmentSup.Adjustment_Details.Add(adjDetails); } if (cost >= 250) { invAdjustmentMan.Adjustment_Details.Add(adjDetails); } context.Adjustment_Details.Add(adjDetails); } if (invAdjustmentSup.Adjustment_Details.Count != 0) { context.Inventory_Adjustment.Add(invAdjustmentSup); context.SaveChanges(); } if (invAdjustmentMan.Adjustment_Details.Count != 0) { context.Inventory_Adjustment.Add(invAdjustmentMan); context.SaveChanges(); } }
protected void CreateOrder(object sender, EventArgs e) { Button btn = (Button)sender; GridViewRow gvr = (GridViewRow)btn.NamingContainer; bool duplicate = false; string itemcode = ((Label)gvr.FindControl("Label_ItemCode")).Text; SSISEntities context = new SSISEntities(); Stock_Inventory item = context.Stock_Inventory.Where(x => x.item_code == itemcode).First(); HashSet <Stock_Inventory> itemList = (HashSet <Stock_Inventory>)Session["item"]; if (itemList == null) { itemList = new HashSet <Stock_Inventory>(); itemList.Add(item); lblResult.Visible = true; lblduplicate.Visible = false; lblResult.Text = "Added Item Code (" + itemcode + ") Successfully"; Session["item"] = itemList; } else { foreach (Stock_Inventory s in itemList) { if (s.item_code == item.item_code) { duplicate = true; break; } } if (!duplicate) { itemList.Add(item); lblResult.Visible = true; lblduplicate.Visible = false; lblResult.Text = "Added Item Code (" + itemcode + ") Successfully"; Session["item"] = itemList; } else { lblduplicate.Visible = true; lblResult.Visible = false; lblduplicate.Text = "Duplicate item!"; Session["item"] = itemList; } } }
private void fillFields(Tender_List_Details order) { using (SSISEntities context = new SSISEntities()) { Stock_Inventory item = context.Stock_Inventory.Where(x => x.item_code == order.item_code).First();//Find(order.ISBN); itemDesc = item.item_description; supplierName = context.Suppliers.Where(x => x.supplier_id == order.Tender_List.supplier_id).Select(x => x.name).First(); price = order.price; tenderId = order.tender_id; quantity = item.reorder_qty; supplierId = order.Tender_List.supplier_id; } }
public MonthlyCheckModel(Stock_Inventory stock) { ItemModel item = new ItemModel(stock); this.category = item.Category; this.itemCode = item.ItemCode; this.catName = item.CatName; this.description = item.Description; this.unitOfMeasure = item.UnitOfMeasure; this.imagePath = item.ImagePath; this.currentQuantity = item.CurrentQuantity; this.reorderQuantity = item.ReorderQuantity; this.reorderLevel = item.ReorderLevel; this.prices = item.Prices; this.actualQuantity = item.CurrentQuantity; this.reason = ""; this.averagePrice = AveragePrice; }
public RetrievalModel findLatestRetrievingByRequestId(int requestId, string currentUser) { // For at the warehouse // Get all allocated: depending on: // Determine there's any latest retrieval // Find the difference with the previous retrieval, to see how much to fulfill //{ PENDING, APPROVED, REJECTED, DISBURSED, PART_DISBURSED, CANCELLED, UPDATED }); Request efRequest = context.Requests .Where(x => x.request_id == requestId && (x.current_status == RequestStatus.APPROVED || x.current_status == RequestStatus.PART_DISBURSED) && x.deleted != "Y" ).First(); if (efRequest == null) { throw new ItemNotFoundException("No records exist"); } Dictionary <ItemModel, int> itemsToFulfill = new Dictionary <ItemModel, int>(); List <Request_Details> details = efRequest.Request_Details.ToList(); foreach (var detail in details) { if (detail.deleted == "Y") { continue; } List <Request_Event> events = detail.Request_Event.Where(w => w.deleted != "Y").ToList(); // If there are no events for some reason, SKIP if (events.Count == 0) { continue; } Request_Event eventItem = events.First(); // If the event does not have anything allocated to it, SKIP if (eventItem.allocated == 0) { continue; } // Only add if it's retrieving AND it was by the currentUser if (eventItem.status == EventStatus.RETRIEVING && eventItem.username == currentUser && eventItem.allocated.HasValue) { Stock_Inventory s = detail.Stock_Inventory; itemsToFulfill.Add(new ItemModel(s), eventItem.allocated.Value); } } if (itemsToFulfill.Count == 0) { return(null); } RetrievalModel retrieval = new RetrievalModel(efRequest, itemsToFulfill); return(retrieval); }
private DisbursementModel _findLatestBetweenStatuses(int requestId, string fromStatus, string toStatus, string currentUser) { // For signing off forms (all disbursing ones) Request efRequest = context.Requests .Where(x => x.request_id == requestId && (x.current_status == RequestStatus.APPROVED || x.current_status == RequestStatus.PART_DISBURSED) ).First(); if (efRequest == null) { throw new ItemNotFoundException("No records exist"); } Dictionary <ItemModel, int> itemsToFulfill = new Dictionary <ItemModel, int>(); List <Request_Details> details = efRequest.Request_Details.ToList(); foreach (var detail in details) { //int itemQty = 0; if (detail.deleted == "Y") { continue; } List <Request_Event> events = detail.Request_Event.Where(w => w.deleted != "Y").ToList(); // If there are no events for some reason, SKIP if (events.Count == 0) { continue; } Request_Event eventItem = events.First(); // If the event does not have anything allocated to it, SKIP if (eventItem.allocated.HasValue && eventItem.allocated.Value == 0) { continue; } // Only add if it's retrieving AND it was by the currentUser if (eventItem.status == fromStatus && eventItem.allocated.HasValue) { // currentUser was specified, skip if it's not by them if (currentUser != null && eventItem.username != currentUser) { continue; } Stock_Inventory s = detail.Stock_Inventory; itemsToFulfill.Add(new ItemModel(s), eventItem.allocated.Value); } } if (itemsToFulfill.Count == 0) { return(null); } DisbursementModel retrieved = new DisbursementModel(efRequest, itemsToFulfill); return(retrieved); }
public RetrievalModel findLatestRetrievalsByRequestId(int requestId) { // Get all allocated: depending on: // Determine there's any latest retrieval // Find the difference with the previous retrieval, to see how much to fulfill //{ PENDING, APPROVED, REJECTED, DISBURSED, PART_DISBURSED, CANCELLED, UPDATED }); Request efRequest = context.Requests .Where(x => x.request_id == requestId && (x.current_status == RequestStatus.APPROVED || x.current_status == RequestStatus.PART_DISBURSED) ).First(); if (efRequest == null) { throw new ItemNotFoundException("No records exist"); } IEnumerable <IGrouping <string, Request_Event> > events = efRequest.Request_Details.SelectMany(x => x.Request_Event).GroupBy(g => g.Request_Details.item_code).ToList(); Dictionary <ItemModel, int> itemsToFulfill = new Dictionary <ItemModel, int>(); foreach (IGrouping <string, Request_Event> eventItem in events) { // Grouping: // A101 // - Approved, 10 // - Allocated, 9 // A102 // - Approved, 10 List <Request_Event> latestRetrieval = eventItem.Where(x => x.status == EventStatus.RETRIEVED).OrderBy(o => o.date_time).ToList(); if (latestRetrieval.Count == 0) { continue; } int quantityToFulfil = 0; if (latestRetrieval.Count > 1) { Request_Event last = latestRetrieval.Last(); Request_Event secondLast = latestRetrieval[latestRetrieval.Count - 2]; quantityToFulfil = last.quantity - secondLast.quantity; } else { quantityToFulfil = latestRetrieval.Last().quantity; } Stock_Inventory inv = context.Stock_Inventory.Find(eventItem.Key); itemsToFulfill.Add(new ItemModel(inv), quantityToFulfil); } if (itemsToFulfill.Count == 0) { return(null); } RetrievalModel retrieval = new RetrievalModel(efRequest, itemsToFulfill); return(retrieval); }
public AllocatedModel findLatestAllocatedByRequestId(int requestId) { // This NOW ALLOCATES UPON FINDING // Get all allocated: depending on: // Determine there's any latest allocation // Find the difference with the previous allocation, to see how much to fulfill //{ PENDING, APPROVED, REJECTED, DISBURSED, PART_DISBURSED, CANCELLED, UPDATED }); Request efRequest = context.Requests .Where(x => x.request_id == requestId && (x.current_status == RequestStatus.APPROVED || x.current_status == RequestStatus.PART_DISBURSED) ).First(); if (efRequest == null) { throw new ItemNotFoundException("No records exist"); } IEnumerable <IGrouping <string, Request_Event> > events = efRequest.Request_Details.SelectMany(x => x.Request_Event).GroupBy(g => g.Request_Details.item_code).ToList(); Dictionary <ItemModel, int> itemsToFulfill = new Dictionary <ItemModel, int>(); foreach (IGrouping <string, Request_Event> eventItem in events) { Request_Event item = eventItem.Where(w => w.deleted != "Y").DefaultIfEmpty(null).FirstOrDefault(); if (item == null) { continue; } // If neither approved nor disbursed, skip it. if (item.status != EventStatus.APPROVED && item.status != EventStatus.DISBURSED && item.status != EventStatus.ALLOCATED) { continue; } Stock_Inventory inv = context.Stock_Inventory.Find(eventItem.Key); ItemModel itemModel = new ItemModel(inv); // Already allocated, just add it if (item.status == EventStatus.ALLOCATED && item.allocated.HasValue) { itemsToFulfill.Add(itemModel, item.allocated.Value); continue; } // Fully allocated, can skip if (item.status == EventStatus.DISBURSED && item.not_allocated == 0) { continue; } int qtyToAllocate; if (item.status == EventStatus.APPROVED) { // Take the whole quantity qtyToAllocate = item.quantity; } else { // Disbursed. Take just the not-allocated qtyToAllocate = item.not_allocated.HasValue ? item.not_allocated.Value : 0; } // if for some reason it's still zero, just skip. if (qtyToAllocate == 0) { continue; } int canAllocateQty = 0; int availableQty = itemModel.AvailableQuantity; if (availableQty > 0) { // There is available stock if (availableQty >= qtyToAllocate) { // Lots of stock canAllocateQty = qtyToAllocate; } else { // Only some stock canAllocateQty = availableQty; } } else { // Cannot allocate at all, cannot retrieve, SKIP continue; } // At this point, there is some qtyToAllocate context.Request_Event.Find(item.request_event_id).allocated = canAllocateQty; if (item.status == EventStatus.DISBURSED) { context.Request_Event.Find(item.request_event_id).quantity = qtyToAllocate; context.Request_Event.Find(item.request_event_id).not_allocated -= canAllocateQty; } else { // Approved only // it.quantity doesn't change //context.Request_Event.Find(item.request_event_id).quantity = //doesn't change; context.Request_Event.Find(item.request_event_id).not_allocated = item.quantity - canAllocateQty; } context.Request_Event.Find(item.request_event_id).status = EventStatus.ALLOCATED; itemsToFulfill.Add(itemModel, canAllocateQty); } if (itemsToFulfill.Count == 0) { // Nothing to allocate, or cannot allocate anything at all. return(null); } AllocatedModel alloc = new AllocatedModel(efRequest, itemsToFulfill); // Save changes to update Available Qty context.SaveChanges(); return(alloc); }
public int reAllocateRequest(RequestModel toAllocate, string currentUser) { int added = 0; DateTime timestamp = DateTime.Now; using (var transaction = context.Database.BeginTransaction()) { try { // For each item: // - Get the latest status (e.g. retrieved or disbursed) // - Compare this latest status to the approved amount // - If there is a difference, try to reallocate it // Get a list of details (items) List <Request_Details> details = context.Requests.Find(toAllocate.RequestId).Request_Details.ToList(); if (details.Count == 0) { throw new ItemNotFoundException("Request could not be found"); } // For each of these, get the latest status, and approved event foreach (var detail in details) { Request_Event latest = detail.Request_Event.OrderBy(o => o.date_time).Last(); if (latest == null) { throw new ItemNotFoundException("event item could not be found"); } Request_Event approved = detail.Request_Event.Where(e => e.status == EventStatus.APPROVED).OrderBy(o => o.date_time).Last(); if (approved == null) { throw new ItemNotFoundException("event item could not be found"); } // Get the difference in quantity int difference = approved.quantity - latest.quantity; if (difference < 0) { throw new RequestDataIntegrityFailureException( string.Format("Request id ({0}) has quantities that don't match up!\n==>Request_Event id: {1}\n==>Request_Event id: {2}", toAllocate.RequestId, latest.request_event_id, approved.request_event_id) ); } if (difference > 0) { // There is a difference, so reAllocate it, using the difference quantity // Get the item model Stock_Inventory stock = context.Stock_Inventory.Find(detail.item_code); if (stock == null) { throw new ItemNotFoundException("Could not find stock_inventory for itemCode: " + detail.item_code); } ItemModel item = new ItemModel(stock); // First, make sure each item can be allocated in its entirety. If it can, allocate it. if (item.AvailableQuantity >= difference) { // For each item, add a new event that is allocated Request_Event newEvent = new Request_Event(); newEvent.request_detail_id = detail.request_detail_id; // get the quantity from the provided item quantity in the method arguments newEvent.quantity = toAllocate.Items.Where(i => i.Key.ItemCode == item.ItemCode).First().Value; newEvent.status = EventStatus.ALLOCATED; newEvent.username = currentUser; newEvent.date_time = timestamp; newEvent.deleted = "N"; context.Request_Event.Add(newEvent); added++; } } } } catch (Exception exec) { transaction.Rollback(); throw exec; } transaction.Commit(); } return(added); }
protected void Confirm(object sender, EventArgs e) { int orderID = Convert.ToInt32(Session["order"]); Delivery_Orders d = new Delivery_Orders(); d.clerk_user = User.Identity.Name; d.deleted = "N"; d.order_id = orderID; d.receive_date = DateTime.Parse(deliverydate.Text); context.Delivery_Orders.Add(d); context.SaveChanges(); List <Purchase_Order_Details> podList = context.Purchase_Order_Details.Where(x => x.order_id == orderID).ToList <Purchase_Order_Details>(); foreach (Purchase_Order_Details pod in podList) { pod.status = "Completed"; context.SaveChanges(); } //Get DeliveryOrderID Delivery_Orders order = context.Delivery_Orders.Where(x => x.clerk_user == User.Identity.Name).OrderBy(x => x.delivery_id).ToList().Last(); foreach (GridViewRow rows in GridView1.Rows) { TextBox qty = (TextBox)rows.FindControl("quantity"); TextBox r = (TextBox)rows.FindControl("remark"); Label exp_quantity = (Label)rows.FindControl("Label_quantity"); int exp_qty = Convert.ToInt32(exp_quantity.Text); Label itemdesc = (Label)rows.FindControl("Label_itemDesc"); Label orderdetailid = (Label)rows.FindControl("Label_OrderDetailId"); string itemName = itemdesc.Text; int quantity = Convert.ToInt32(qty.Text); string remarks = r.Text; int orderDetail = Convert.ToInt32(orderdetailid.Text); Stock_Inventory item = context.Stock_Inventory.Where(x => x.item_description == itemName).First(); int currentQuantity = item.current_qty; item.current_qty = currentQuantity + quantity; context.SaveChanges(); Purchase_Order_Details pod = context.Purchase_Order_Details.Where(x => x.order_details_id == orderDetail).First(); Delivery_Details dd = new Delivery_Details(); dd.delivery_id = order.delivery_id; dd.deleted = "N"; dd.tender_id = pod.tender_id; dd.quantity = quantity; dd.remarks = remarks; context.Delivery_Details.Add(dd); context.SaveChanges(); } Response.Redirect("~/views/storeclerk/viewpendingorder.aspx"); }
protected void btnSubmit_Click(object sender, EventArgs e) { _checkQtyRows(); UserModel currentUserModel; List <MakeNewRequestModel> models = _getModelsFromSession(); using (SSISEntities context = new SSISEntities()) { currentUserModel = new UserModel(User.Identity.Name); Dictionary <string, int> items = new Dictionary <string, int>(); foreach (var model in models) { // If the user didn't add a quantity, just SKIP if (model.Quantity == 0) { continue; } if (items.ContainsKey(model.CurrentItem)) { int qty = items[model.CurrentItem]; items.Remove(model.CurrentItem); items.Add(model.CurrentItem, model.Quantity + qty); } else { items.Add(model.CurrentItem, model.Quantity); } } Dictionary <ItemModel, int> itemModels = new Dictionary <ItemModel, int>(); foreach (var item in items) { Stock_Inventory stock = context.Stock_Inventory.Find(item.Key); ItemModel im = new ItemModel(stock); itemModels.Add(im, item.Value); } UserModel user = (UserModel)Session[SESSION_USER_MODEL]; RequestModel newReq = new RequestModel(); newReq.Items = itemModels; newReq.Reason = tbReason.Text; newReq.Department = user.Department; newReq.Status = RequestStatus.PENDING; newReq.UserModel = user; bool isEditing = (Session[SESSION_IS_EDITING] as bool?).Value; if (isEditing) { newReq.RequestId = (int)Session[SESSION_REQ_EDIT_ID]; FacadeFactory.getRequestService(context).updateRequestChanges(newReq); } else { FacadeFactory.getRequestService(context).saveNewRequest(newReq); } context.SaveChanges(); } /* Email logic */ string fromEmail = currentUserModel.Email; string fromName = currentUserModel.Fullname; UserModel deptHead = currentUserModel.FindDelegateOrDeptHead(); string toEmail = deptHead.Email; string toName = deptHead.Fullname; string subject = string.Format("New pending request from {0}", fromName); StringBuilder sb = new StringBuilder(); sb.AppendLine("Dear " + toName + ","); sb.AppendLine("<br />"); sb.AppendLine("<br />"); sb.AppendLine(string.Format("{0} has requested for some items, pending your approval.", fromName)); sb.AppendLine("<br />"); sb.AppendLine(string.Format("The request's reason is: {0}", tbReason.Text)); sb.AppendLine("<br />"); sb.AppendLine(string.Format("Please <a href=\"{0}\">follow this link to view the request</a>.", "https://rebrand.ly/ssis-mgr-viewpending")); sb.AppendLine("<br />"); sb.AppendLine("<br />"); sb.AppendLine("Thank you."); sb.AppendLine("<br />"); sb.AppendLine("<br />"); sb.AppendLine("<i>This message was auto-generated by the Stationery Store Inventory System.</i>"); string body = sb.ToString(); new Emailer(fromEmail, fromName).SendEmail(toEmail, toName, subject, body); /* End of email logic */ //Response.Redirect(Request.Url.ToString(), false); Response.Redirect("EmpRequestHistory.aspx", false); }
public bool UpdateMonthlyCheck(List <WCF_MonthlyCheck> monthlyChecks, string username) { Inventory_Adjustment invAdjustmentSup = new Inventory_Adjustment(); invAdjustmentSup.deleted = "N"; invAdjustmentSup.clerk_user = username; invAdjustmentSup.status = "Pending"; invAdjustmentSup.date = DateTime.Today; invAdjustmentSup.status_date = DateTime.Today; Inventory_Adjustment invAdjustmentMan = new Inventory_Adjustment(); invAdjustmentMan.deleted = "N"; invAdjustmentMan.clerk_user = username; invAdjustmentMan.status = "Pending"; invAdjustmentMan.date = DateTime.Today; invAdjustmentMan.status_date = DateTime.Today; foreach (WCF_MonthlyCheck i in monthlyChecks) { int actual = int.Parse(i.actualQuantity); int current = int.Parse(i.CurrentQuantity); int adjusted = current - actual; if (adjusted == 0) { continue; } Stock_Inventory inventory = context.Stock_Inventory.Where(x => x.item_code == i.ItemCode).ToList().First(); inventory.current_qty = actual; MonthlyCheckModel itemModel = new MonthlyCheckModel(inventory); double cost = Math.Abs(adjusted) * itemModel.AveragePrice; Adjustment_Details adjDetails = new Adjustment_Details(); adjDetails.deleted = "N"; adjDetails.item_code = i.ItemCode; adjDetails.quantity_adjusted = adjusted; adjDetails.reason = i.Reason; if (cost < 250) { invAdjustmentSup.Adjustment_Details.Add(adjDetails); } if (cost >= 250) { invAdjustmentMan.Adjustment_Details.Add(adjDetails); } context.Adjustment_Details.Add(adjDetails); } if (invAdjustmentSup.Adjustment_Details.Count != 0) { context.Inventory_Adjustment.Add(invAdjustmentSup); context.SaveChanges(); } if (invAdjustmentMan.Adjustment_Details.Count != 0) { context.Inventory_Adjustment.Add(invAdjustmentMan); context.SaveChanges(); } if (invAdjustmentSup.Adjustment_Details.Count != 0 || invAdjustmentMan.Adjustment_Details.Count != 0) { return(true); } else { return(false); } }