/// <summary> /// Insert one AccDocDetail to database - Thêm mới một AccDocDetail vào cơ sở dữ liệu /// </summary> /// <param name="entity"></param> /// <returns></returns> public long Insert(AccDocDetail entity) { entity.CreatedDate = entity.ModifiedDate = DateTime.Now; entity.Status = true; db.AccDocDetails.Add(entity); db.SaveChanges(); return(entity.ID); }
public JsonResult ImportDetail(string list) { var json = new JavaScriptSerializer().Deserialize <List <Inventory> >(list); var accDocDetailDao = new AccDocDetailDao(); AccDocDetail accDocDetail = new AccDocDetail(); var inventoryDao = new InventoryDao(); Inventory inventory = new Inventory(); if (json.Count() > 0) { accDocDetailDao.RemoveDetail(json[0].DocNo); inventoryDao.RemoveDetail(json[0].DocNo); foreach (var item in json) { //Insert detail vào bảng AccDocDetail accDocDetail.DocCode = item.DocCode; accDocDetail.DocNo = item.DocNo; accDocDetail.WarehouseID = item.WarehouseID; accDocDetail.ProductID = item.ProductID; accDocDetail.Quantity = item.Quantity; if (accDocDetailDao.CheckExist(accDocDetail.DocCode, accDocDetail.DocNo, accDocDetail.WarehouseID, accDocDetail.ProductID) == true) { accDocDetailDao.UpdateQuantity(accDocDetail.DocCode, accDocDetail.DocNo, accDocDetail.WarehouseID, accDocDetail.ProductID, (int)accDocDetail.Quantity); } else { accDocDetailDao.Insert(accDocDetail); } //Insert detail vào bảng Inventory if (inventoryDao.CheckExist(accDocDetail.DocCode, accDocDetail.DocNo, accDocDetail.WarehouseID, accDocDetail.ProductID) == true) { inventoryDao.UpdateQuantity(accDocDetail.DocCode, accDocDetail.DocNo, accDocDetail.WarehouseID, accDocDetail.ProductID, (int)item.Quantity); } else { inventoryDao.Insert(item); } } } return(Json(new { status = true })); }
/// <summary> /// Update one AccDocDetail in the database - Cập nhật một AccDocDetail trong cơ sở dữ liệu /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool Update(AccDocDetail entity) { try { var accDocDetail = db.AccDocDetails.Find(entity.ID); accDocDetail.WarehouseID = entity.WarehouseID; accDocDetail.ProductID = entity.ProductID; accDocDetail.Price = entity.Price; accDocDetail.Quantity = entity.Quantity; accDocDetail.ModifiedDate = DateTime.Now; accDocDetail.Status = true; db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }