/// <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);
}
}
