public Returnitem addRetrunItems([FromBody] Returnitem data) { data.Id = Guid.NewGuid().ToString(); data.bowId = data.bowId; data.CreateDate = DateTime.UtcNow; data.DeleteDate = null; ReCollection.InsertOne(data); return(ReCollection.Find(id => id.Id == data.Id).FirstOrDefault());; }
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); } }
private bool SaveReturnPropose(long iisID, string reason, int returnid) { IDao<Returnitem, long> dao = DaoFactory.GetDao<Returnitem, long>(); Returnitem ri = new Returnitem(); #region Fix //ri.Iteminstanceid = iisID; // nmchi IDao<Iteminstance, long> daoItemIns = DaoFactory.GetDao<Iteminstance, long>(); ri.Iteminstance = daoItemIns.GetById(iisID, false); // Fix: dungnt 04/12/2007 (Do gen lai Returnitem) #endregion if (returnid > 0) ri.Id = returnid; ri.Returnreason = reason; ri.Returnnumber = ""; ri.Vmepcomment = ""; ri.Status = (int)ReturnItemStatus.Proposed; ri.Releasedate = Convert.ToDateTime(txtReleasedate.Text); ri.Confirmdate = DateTime.Now; ri.Dealercode = UserHelper.DealerCode; ri.Branchcode = UserHelper.BranchCode; try { dao.SaveOrUpdate(ri); return true; } catch { return false; } }
//public static DataTable GetReturnItemForConfirm(string DearlerCode, string Status) //{ // DataTable res = new DataTable(); // res = new ReturnItemDao().GetReturnItemForConfirm(DearlerCode, int.Parse(Status)).Tables[0]; // //res = new ReturnItemDao().GetReturnItemForConfirm(DearlerCode, (int)ReturnItemStatus.Proposed).Tables[0]; // res.Columns.Add("STT", typeof(int)); // if (res.Rows.Count > 0) // { // for (int i = 1; i <= res.Rows.Count; i++) // { // res.Rows[i - 1]["STT"] = i; // } // } // return res; //} public static Returnitem UpdateReturnitem(Returnitem rt) { IDao<Returnitem, long> dao = DaoFactory.GetDao<Returnitem, long>(); return dao.SaveOrUpdate(rt); }