public List <int> FindTrashQtyList(CustomerTrash rowTrashQtyList) { List <int> finalQtyList = new List <int>(); List <int> qtyList = QtyListWithNullValues(rowTrashQtyList); for (int i = 0; i < qtyList.Count(); i++) { if (qtyList[i] >= 0) { finalQtyList.Add(qtyList[i]); } } return(finalQtyList); }
private List <int> QtyListWithNullValues(CustomerTrash rowTrashQtyList) { List <int> qtyList = new List <int>(); qtyList.Add(rowTrashQtyList.QtyItem1); qtyList.Add(rowTrashQtyList.QtyItem2); qtyList.Add(rowTrashQtyList.QtyItem3); qtyList.Add(rowTrashQtyList.QtyItem4); qtyList.Add(rowTrashQtyList.QtyItem5); qtyList.Add(rowTrashQtyList.QtyItem6); qtyList.Add(rowTrashQtyList.QtyItem7); qtyList.Add(rowTrashQtyList.QtyItem8); qtyList.Add(rowTrashQtyList.QtyItem9); qtyList.Add(rowTrashQtyList.QtyItem10); qtyList.Add(rowTrashQtyList.QtyItem11); qtyList.Add(rowTrashQtyList.QtyItem12); qtyList.Add(rowTrashQtyList.QtyItem13); qtyList.Add(rowTrashQtyList.QtyItem14); qtyList.Add(rowTrashQtyList.QtyItem15); return(qtyList); }
private void UpdateFinalTotalQty(string[] finalTotalQtyList, UserModel um) { var totalTrashQtyLists = db.customerTrashModel.Where(c => c.CompanyName == um.CompanyName).Where(t => t.CollectingStatus == "Requested"); var i = 0; foreach (var totalTrashQty in totalTrashQtyLists) { var customerTrash = new CustomerTrash() { TableID = totalTrashQty.TableID, TotalQty = Convert.ToDouble(finalTotalQtyList[i++]) }; using (DataContext db = new DataContext()) { db.customerTrashModel.Attach(customerTrash); db.Entry(customerTrash).Property(x => x.TotalQty).IsModified = true; db.SaveChanges(); } } }