public int update(sys_vendor_item_model model, sys_vendor_item_history_model modelHistory)
{
var db = _context.sys_vendor_items.Where(d => d.id == model.db.id).FirstOrDefault();
db.min_stock_order = model.db.min_stock_order;
db.delivery_time = model.db.delivery_time;
db.update_by = model.db.update_by;
db.update_date = model.db.update_date;
modelHistory.db.action = "Sửa";
_context.sys_vendor_item_historys.AddAsync(modelHistory.db);
_context.SaveChanges();
return(1);
}
public async Task <int> insert(sys_vendor_item_model model, sys_vendor_item_history_model modelHistory)
{
if ((model.db.id_specification ?? 0) != 0)
{
var specification = _context.sys_item_specifications.Where(t => t.id == model.db.id_specification).SingleOrDefault();
model.db.id_unit = specification.id_unit;
model.db.id_unit_main = _context.sys_items.Where(t => t.id == model.db.id_item).Select(t => t.id_unit).SingleOrDefault();
model.db.conversion_factor = specification.conversion_factor;
}
modelHistory.db.action = "Tạo mới";
await _context.sys_vendor_item_historys.AddAsync(modelHistory.db);
await _context.sys_vendor_items.AddAsync(model.db);
_context.SaveChanges();
return(1);
}
