public IEnumerable <Returnitem> GetItemreturn(string user) { var myBorrow = BowCollection.Find(it => (it.borrower == user || it.witness == user) && it.borrower != null && it.witness != null).ToList(); //TODO: Query Items var Items = Collection.Find(it => true).ToList(); IEnumerable <Returnitem> returnitems = new List <Returnitem>(); returnitems = myBorrow.Select(it => { return(new Returnitem { Id = it.Id, borrower = it.borrower, witness = it.witness, Items = it.Items.Where(i => i.BorrowQty != i.ReturnQty).Select(x => { return new Reitem { Id = x.Id, slot = x.slot, Name = Items.FirstOrDefault(iditem => iditem.Id == x.Id).Name, BorrowQty = x.BorrowQty, ReturnQty = x.ReturnQty }; }) }); }); return(returnitems.ToList()); }
public IEnumerable <Returnitem> GetItemsReturnList(string user, string id) { var GetReitembyUser = BowCollection.Find(x => (x.witness == user || x.borrower == user) && x.borrower != null && x.witness != null).ToList(); var items = Collection.Find(it => true).ToList(); IEnumerable <Returnitem> returnitems = new List <Returnitem>(); returnitems = GetReitembyUser.Where(x => x.Id == id).Select(it => { return(new Returnitem { Id = it.Id, borrower = it.borrower, witness = it.witness, Items = it.Items.Where(i => i.BorrowQty != i.ReturnQty).Select(x => { return new Reitem { Id = x.Id, slot = x.slot, Name = items.FirstOrDefault(iditem => iditem.Id == x.Id).Name, BorrowQty = x.BorrowQty }; }) }); }); return(returnitems); }
public Borrow addBorrow([FromBody] Borrow request) { request.Id = Guid.NewGuid().ToString(); request.CreateDate = DateTime.UtcNow; request.DeleteDate = null; BowCollection.InsertOne(request); var resulte = BowCollection.Find(id => id.Id == request.Id).FirstOrDefault(); return(resulte); }
public IEnumerable <Item> GetMyBorrow(string id) { //ใช้ id ที่รับมา ดึงข้อมูลจากตาราง borrow มาเข้าobject myBorrow var myBorrow = BowCollection.Find(it => it.Id == id).FirstOrDefault(); //select จะเป็นการวน loop ของ item ที่มีทั้งหมด ในmyBorrow var items = myBorrow.Items.Select(it => { //นำข้อมูล id list items ที่อยู่ในobject myBorrow มาดึงข้อมูลตาราง items var item = Collection.Find(x => x.Id == it.Id).FirstOrDefault(); return(new Item { Id = it.Id, Name = item.Name }); }); return(items.ToList()); }
public void ReturnItemupdate([FromBody] Returnitem redata) { var findReitem = ReCollection.Find(r => r.Id == redata.Id).FirstOrDefault(); var itemBow = BowCollection.Find(x => x.Id == findReitem.bowId).ToList(); var builder = Builders <Borrow> .Update; var builderRe = Builders <Returnitem> .Update; var updateRe = builderRe .Set(x => x.returnner, redata.returnner); ReCollection.UpdateOne(x => x.Id == findReitem.Id, updateRe); var builderBowItem = Builders <BorrowItem> .Update; foreach (var BowItem in itemBow.Where(x => x.DeleteDate == null)) { var updatedItems = BowItem.Items; foreach (var item in BowItem.Items) { var itemRe = findReitem.Items.FirstOrDefault(ir => ir.Id == item.Id); var updateitem = updatedItems.FirstOrDefault(x => x.Id == itemRe.Id); updateitem.ReturnQty += itemRe.ReturnQty; var builderItem = Builders <Item> .Update; var getItemUpdate = Collection.Find(x => x.Id == item.Id).FirstOrDefault(); getItemUpdate.Amount = getItemUpdate.Amount + item.ReturnQty; var updateItemAmout = builderItem.Set(x => x.Amount, getItemUpdate.Amount); Collection.UpdateOne(x => x.Id == item.Id, updateItemAmout); } var brrowupdate = builder.Set(x => x.Items, updatedItems); if (!updatedItems.Any(x => x.ReturnQty != x.BorrowQty)) { var a = builder.Set(x => x.DeleteDate, DateTime.UtcNow); BowCollection.UpdateOne(x => x.Id == BowItem.Id, a); } BowCollection.UpdateOne(x => x.Id == BowItem.Id, brrowupdate); } }
public void updateWitness([FromBody] Borrow request) { var builderItemamount = Builders <Item> .Update; var getBorrow = BowCollection.Find(bId => bId.Id == request.Id).ToList(); foreach (var borrow in getBorrow) { foreach (var borrowItem in borrow.Items) { // ได้ Id ของ Items มาแล้ว //var getBorrowItemId = BowItemollection.Find(bId => bId.Id == borrowItem.Id).FirstOrDefault(); var findItem = Collection.Find(idItem => idItem.Id == borrowItem.Id).FirstOrDefault(); findItem.Amount = findItem.Amount - borrowItem.BorrowQty; var updateAmount = builderItemamount.Set(x => x.Amount, findItem.Amount); //updateAmount.Set(x => x.Name,""); Collection.UpdateOne(x => x.Id == borrowItem.Id, updateAmount); } } //foreach (var getItem in getItemBorrow) // { // var findItem = Collection.Find(idItem => idItem.Id == getItem.Id).FirstOrDefault(); //findItem.Amount = findItem.Amount - getItem.BorrowQty; //var updateAmount = builderItemamount.Set(x => x.Amount, findItem.Amount); //} var builder = Builders <Borrow> .Update; var update = builder .Set(x => x.witness, request.witness); BowCollection.UpdateOne(x => x.Id == request.Id, update); //BowCollection.ReplaceOne(request); //BowCollection.ReplaceOne(x => x.Id == request.Id, request); }
public Borrow GetBorrowitemList(string id) { return(BowCollection.Find(x => x.Id == id).FirstOrDefault()); }
public void deleteBorrow(string id) { BowCollection.DeleteOne(x => x.Id == id); }