public async Task<bool> SubmitInput(InputSubmitModel data, string updateBy) { foreach (var item in data.TransactionList) { await CreateInput(item, updateBy); } var lists = data.InputNoList; if (lists.Count > 0) { string Transac_Sheet_No; do { string num = CodeUtility.RandomNumber(3); Transac_Sheet_No = "IB" + DateTime.Now.ToString("yyyyMMdd") + num; } while (await _repoTransactionMain.CheckTranSheetNo(Transac_Sheet_No)); foreach (var item in lists) { string Missing_No; do { // Để Mising No khác nhau string num2 = CodeUtility.RandomNumber(3); Missing_No = "BTM" + DateTime.Now.ToString("yyyyMMdd") + num2; } while (await this.CheckMissingMo(Missing_No)); WMSB_Transaction_Main model = await _repoTransactionMain.GetByInputNo(item); model.Can_Move = "Y"; model.Transac_Sheet_No = Transac_Sheet_No; model.Is_Transfer_Form = "N"; model.Updated_By = updateBy; model.Updated_Time = DateTime.Now; if (model.Purchase_Qty > model.Transacted_Qty) { model.Missing_No = Missing_No; //Tạo mới record và update status record cũ trong bảng QRCode_Main và QRCode_Detail GenerateNewQrCode(model.QRCode_ID, model.QRCode_Version, item, updateBy); //Update QrCode Version cho bảng Transaction_Main model.QRCode_Version += 1; // Tạo mới record trong bảng Missing CreateMissing(model.Purchase_No, model.MO_No, model.MO_Seq, model.Material_ID, model.Transac_No, model.Missing_No, updateBy); } else { WMSB_QRCode_Main qrModel = await _repoQRCodeMain.GetByQRCodeID(model.QRCode_ID); qrModel.Is_Scanned = "Y"; _repoQRCodeMain.Update(qrModel); } _repoTransactionMain.Update(model); } return await _repoTransactionMain.SaveAll(); } return false; }
public async Task <bool> CreateInput(Transaction_Detail_Dto model) { var qrCodeModel = await _repoQRCodeMain.GetByQRCodeID(model.QrCode_Id); if (qrCodeModel != null && qrCodeModel.Valid_Status == "Y") { var listQrCodeDetails = await _repoQRCodeDetail.GetByQRCodeIDAndVersion(qrCodeModel.QRCode_ID, qrCodeModel.QRCode_Version); Random ran = new Random(); int num = ran.Next(100, 999); var packingListModel = await _repoPackingList.GetByReceiveNo(qrCodeModel.Receive_No); WMSB_Transaction_Main inputModel = new WMSB_Transaction_Main(); inputModel.Transac_Type = "I"; inputModel.Transac_No = model.Input_No; inputModel.Transac_Time = DateTime.Now; inputModel.QRCode_ID = qrCodeModel.QRCode_ID; inputModel.QRCode_Version = qrCodeModel.QRCode_Version; inputModel.MO_No = packingListModel.MO_No; inputModel.MO_Seq = packingListModel.MO_Seq; inputModel.Purchase_No = packingListModel.Purchase_No; inputModel.Material_ID = packingListModel.Material_ID; inputModel.Material_Name = packingListModel.Material_Name; inputModel.Purchase_Qty = model.Accumated_Qty; inputModel.Transacted_Qty = model.Trans_In_Qty; inputModel.Rack_Location = model.Rack_Location; inputModel.Can_Move = "Y"; inputModel.Updated_By = "Emma"; inputModel.Updated_Time = DateTime.Now; _repoTransactionMain.Add(inputModel); var i = 0; foreach (var item in model.Detail_Size) { WMSB_Transaction_Detail inputDetailModel = new WMSB_Transaction_Detail(); inputDetailModel.Transac_No = inputModel.Transac_No; inputDetailModel.Tool_Size = listQrCodeDetails[i].Tool_Size; inputDetailModel.Model_Size = listQrCodeDetails[i].Model_Size; inputDetailModel.Order_Size = listQrCodeDetails[i].Order_Size; inputDetailModel.Spec_Size = listQrCodeDetails[i].Spec_Size; inputDetailModel.Qty = listQrCodeDetails[i].Qty; inputDetailModel.Trans_Qty = item.Qty; inputDetailModel.Instock_Qty = item.Qty; inputDetailModel.Untransac_Qty = inputDetailModel.Qty - inputDetailModel.Trans_Qty; inputDetailModel.Updated_By = "Nam"; inputDetailModel.Updated_Time = DateTime.Now; _repoTransactionDetail.Add(inputDetailModel); i += 1; } return(await _repoTransactionMain.SaveAll()); } return(false); }
public async Task <bool> SubmitInput(InputSubmitModel data) { foreach (var item in data.TransactionList) { await CreateInput(item); } var lists = data.InputNoList; Random ran = new Random(); if (lists.Count > 0) { int num = ran.Next(100, 999); var Transac_Sheet_No = "IB" + DateTime.Now.ToString("yyyyMMdd") + num.ToString(); var Missing_No = "BTM" + DateTime.Now.ToString("yyyyMMdd") + num.ToString(); foreach (var item in lists) { WMSB_Transaction_Main model = await _repoTransactionMain.GetByInputNo(item); model.Can_Move = "Y"; model.Transac_Sheet_No = Transac_Sheet_No; model.Updated_By = "Nam"; model.Updated_Time = DateTime.Now; if (model.Purchase_Qty > model.Transacted_Qty) { model.Missing_No = Missing_No; //Tạo mới record và update status record cũ trong bảng QRCode_Main và QRCode_Detail GenerateNewQrCode(model.QRCode_ID, model.QRCode_Version, item); //Update QrCode Version cho bảng Transaction_Main model.QRCode_Version += 1; // Tạo mới record trong bảng Missing CreateMissing(model.Purchase_No, model.MO_No, model.MO_Seq, model.Material_ID, model.Transac_No, model.Missing_No); } else { WMSB_QRCode_Main qrModel = await _repoQRCodeMain.GetByQRCodeID(model.QRCode_ID); qrModel.Is_Scanned = "Y"; _repoQRCodeMain.Update(qrModel); } _repoTransactionMain.Update(model); } return(await _repoTransactionMain.SaveAll()); } return(false); }
public async Task<bool> IntegrationInputSubmit(List<IntegrationInputModel> data, string user) { data = data.Where(x => !string.IsNullOrEmpty(x.Rack_Location)).ToList(); foreach (var item in data) { // Update Table WMSB_QRCode_Main var qrCodeModels = await _repoQRCodeMain.FindAll(x => x.QRCode_ID.Trim() == item.QRCode_ID.Trim() && x.Is_Scanned.Trim() == "N" && x.Receive_No.Trim() == item.Receive_No.Trim()).FirstOrDefaultAsync(); if (qrCodeModels != null) { qrCodeModels.Is_Scanned = "Y"; } //---------------------------- Check TransactionMain-------------------------------// var transationMainCheck = await _repoTransactionMain.FindAll(x => x.QRCode_ID.Trim() == item.QRCode_ID.Trim() && x.MO_No.Trim() == item.MO_No.Trim() && x.Purchase_No.Trim() == item.Purchase_No.Trim() && x.Material_ID.Trim() == item.Material_ID.Trim()).FirstOrDefaultAsync(); if (transationMainCheck == null) { string Transac_Sheet_No, Transac_No; do { string num = CodeUtility.RandomNumber(3); Transac_Sheet_No = "IB" + DateTime.Now.ToString("yyyyMMdd") + num; } while (await _repoTransactionMain.CheckTranSheetNo(Transac_Sheet_No)); do { string num1 = CodeUtility.RandomNumber(3); Transac_No = "IB" + item.MO_No.Trim() + num1; } while (await _repoTransactionMain.CheckTransacNo(Transac_No)); // Tạo New Model để Add vào Table WMSB_Transaction_Main var transactionMainModel = new WMSB_Transaction_Main(); transactionMainModel.Transac_Type = "I"; transactionMainModel.Transac_No = Transac_No; transactionMainModel.Transac_Sheet_No = Transac_Sheet_No; transactionMainModel.Can_Move = "Y"; transactionMainModel.Transac_Time = DateTime.Now; transactionMainModel.QRCode_ID = item.QRCode_ID; transactionMainModel.QRCode_Version = item.QRCode_Version; transactionMainModel.MO_No = item.MO_No.Trim(); transactionMainModel.Purchase_No = item.Purchase_No.Trim(); transactionMainModel.MO_Seq = item.MO_Seq; transactionMainModel.Material_ID = item.Material_ID.Trim(); transactionMainModel.Material_Name = item.Material_Name.Trim(); transactionMainModel.Purchase_Qty = item.Receive_Qty; transactionMainModel.Transacted_Qty = item.Receive_Qty; transactionMainModel.Rack_Location = item.Rack_Location; transactionMainModel.Is_Transfer_Form = "N"; transactionMainModel.Updated_Time = DateTime.Now; transactionMainModel.Updated_By = user; _repoTransactionMain.Add(transactionMainModel); // Add vào table WMSB_Transaction_Detail foreach (var item1 in item.PackingListDetailItem) { var transactionDetailModel = new WMSB_Transaction_Detail(); transactionDetailModel.Transac_No = Transac_No.Trim(); transactionDetailModel.Tool_Size = item1.Tool_Size; transactionDetailModel.Order_Size = item1.Order_Size; transactionDetailModel.Model_Size = item1.Model_Size; transactionDetailModel.Spec_Size = item1.Spec_Size; transactionDetailModel.Qty = item1.Received_Qty; transactionDetailModel.Trans_Qty = item1.Received_Qty; transactionDetailModel.Instock_Qty = item1.Received_Qty; transactionDetailModel.Untransac_Qty = 0; transactionDetailModel.Updated_Time = DateTime.Now; transactionDetailModel.Updated_By = user; _repoTransactionDetail.Add(transactionDetailModel); } } } return await _repoTransactionDetail.SaveAll(); }
public async Task <bool> SaveListOutput(List <OutputParam> outputParam, string updateBy) { DateTime timeNow = DateTime.Now; string outputSheetNo; do { string num = CodeUtility.RandomNumber(3); outputSheetNo = "OB" + DateTime.Now.ToString("yyyyMMdd") + num;// OB + 20200421 + 001 } while (await _repoTransactionMain.CheckTranSheetNo(outputSheetNo)); foreach (var itemt in outputParam) { // Tìm ra TransactionMain theo id var transactionMain = _repoTransactionMain.FindSingle(x => x.ID == itemt.output.Id); transactionMain.Can_Move = "N"; // update transaction main cũ: Can_Move thành N _repoTransactionMain.Update(transactionMain); // thêm transaction main type O WMSB_Transaction_Main modelTypeO = new WMSB_Transaction_Main(); modelTypeO.Transac_Type = "O"; modelTypeO.Can_Move = "N"; // modelTypeO.Is_Transfer_Form = "N"; modelTypeO.Transac_No = itemt.output.TransacNo; modelTypeO.Transac_Sheet_No = outputSheetNo; modelTypeO.Transacted_Qty = itemt.output.TransOutQty; modelTypeO.Pickup_No = itemt.output.PickupNo; modelTypeO.Transac_Time = timeNow; modelTypeO.Updated_Time = timeNow; modelTypeO.Updated_By = updateBy; modelTypeO.Missing_No = transactionMain.Missing_No; modelTypeO.Material_ID = transactionMain.Material_ID; modelTypeO.Material_Name = transactionMain.Material_Name; modelTypeO.Purchase_No = transactionMain.Purchase_No; modelTypeO.Rack_Location = null;// type O: racklocation rỗng modelTypeO.Purchase_Qty = transactionMain.Purchase_Qty; modelTypeO.QRCode_Version = transactionMain.QRCode_Version; modelTypeO.QRCode_ID = transactionMain.QRCode_ID; modelTypeO.MO_No = transactionMain.MO_No; modelTypeO.MO_Seq = transactionMain.MO_Seq; _repoTransactionMain.Add(modelTypeO); // Thêm transaction detail mới theo type = o, dựa vào transaction detail của transaction main cũ foreach (var item in itemt.transactionDetail) { item.ID = 0;// ID trong db là tự tăng: dựa vào transaction detail cũ nên thêm mới gán id bằng 0, không cần phải new hết thuộc tính của đổi tượng ra item.Transac_No = itemt.output.TransacNo; item.Updated_By = updateBy; item.Updated_Time = timeNow; var itemModel = _mapper.Map <WMSB_Transaction_Detail>(item); _repoTransactionDetail.Add(itemModel); } // Nếu output ra chưa hết thì thêm transaction main type R, và transaction detail, thêm qrcode mới và update version lên if (itemt.output.RemainingQty > 0) { // thêm type R var tmpQrcodeVersion = transactionMain.QRCode_Version + 1; WMSB_Transaction_Main modelTypeR = new WMSB_Transaction_Main(); modelTypeR.Transac_Type = "R"; modelTypeR.Transac_No = "R" + transactionMain.Transac_No; modelTypeR.Transac_Sheet_No = "R" + transactionMain.Transac_Sheet_No; modelTypeR.Transacted_Qty = itemt.output.TransOutQty; modelTypeR.Updated_By = updateBy; modelTypeR.Updated_Time = timeNow; modelTypeR.Missing_No = transactionMain.Missing_No; modelTypeR.Material_ID = transactionMain.Material_ID; modelTypeR.Material_Name = transactionMain.Material_Name; modelTypeR.Purchase_No = transactionMain.Purchase_No; modelTypeR.Rack_Location = transactionMain.Rack_Location; modelTypeR.Purchase_Qty = transactionMain.Purchase_Qty; modelTypeR.QRCode_Version = tmpQrcodeVersion; modelTypeR.QRCode_ID = transactionMain.QRCode_ID; modelTypeR.MO_No = transactionMain.MO_No; modelTypeR.MO_Seq = transactionMain.MO_Seq; modelTypeR.Can_Move = "Y"; // modelTypeR.Is_Transfer_Form = "N"; modelTypeR.Transac_Time = timeNow; _repoTransactionMain.Add(modelTypeR); // thêm transaction main cũng phải thêm transaction detail foreach (var itemTypeR in itemt.transactionDetail) { itemTypeR.ID = 0;// ID trong db là tự tăng: dựa vào transaction detail cũ nên thêm mới gán id bằng 0, không cần phải new hết thuộc tính của đổi tượng ra itemTypeR.Transac_No = modelTypeR.Transac_No; itemTypeR.Updated_By = updateBy; itemTypeR.Updated_Time = timeNow; itemTypeR.Qty = itemTypeR.Instock_Qty; itemTypeR.Trans_Qty = itemTypeR.Instock_Qty; var itemModel = _mapper.Map <WMSB_Transaction_Detail>(itemTypeR); _repoTransactionDetail.Add(itemModel); } // thêm qrcode mới, nếu output ra chưa hết thì thêm qrcode main mới dựa vào cái cũ và update version lên var qrCodeMain = await _repoQRCodeMain.FindAll(x => x.QRCode_ID.Trim() == itemt.output.QrCodeId.Trim()).OrderByDescending(x => x.QRCode_Version).FirstOrDefaultAsync(); WMSB_QRCode_Main modelQrCodeMain = new WMSB_QRCode_Main(); modelQrCodeMain.QRCode_ID = qrCodeMain.QRCode_ID; modelQrCodeMain.QRCode_Type = qrCodeMain.QRCode_Type; modelQrCodeMain.Receive_No = qrCodeMain.Receive_No; modelQrCodeMain.Valid_Status = "Y"; modelQrCodeMain.Is_Scanned = "Y"; modelQrCodeMain.Invalid_Date = qrCodeMain.Invalid_Date; modelQrCodeMain.QRCode_Version = qrCodeMain.QRCode_Version + 1; modelQrCodeMain.Updated_Time = timeNow; modelQrCodeMain.Updated_By = updateBy; _repoQRCodeMain.Add(modelQrCodeMain); // Update cho QRCode cũ, Valid_Status =N, Invalid_Date = Ngày mà tạo ra version mới qrCodeMain.Valid_Status = "N"; qrCodeMain.Invalid_Date = timeNow; _repoQRCodeMain.Update(qrCodeMain); // thêm qrcodedetail của qrcode mới: thêm qrcode main cũng phải thêm qrcode detail var qrCodeDetails = await _repoQRCodeDetail.FindAll(x => x.QRCode_ID.Trim() == qrCodeMain.QRCode_ID.Trim() && x.QRCode_Version == qrCodeMain.QRCode_Version).ToListAsync(); foreach (var itemQrCodeDetail in qrCodeDetails) { itemQrCodeDetail.QID = 0; itemQrCodeDetail.Updated_By = updateBy; itemQrCodeDetail.Updated_Time = timeNow; itemQrCodeDetail.QRCode_Version = modelQrCodeMain.QRCode_Version; itemQrCodeDetail.Qty = itemt.transactionDetail.Where(x => x.Tool_Size == itemQrCodeDetail.Tool_Size && x.Order_Size == itemQrCodeDetail.Order_Size && x.Model_Size == itemQrCodeDetail.Model_Size).FirstOrDefault().Instock_Qty; _repoQRCodeDetail.Add(itemQrCodeDetail); } } // Nếu QRCode đã out hết số lượng, cần update cho nó không còn hiệu lực // ( Ở bảng WMSB_QRCode_Main: UPDATE trường Valid_Status =’N”, Invalid_Date là ngày Output hết số lượng, // đồng thời cũng update trường Update_Time & Update_By) else { var qrCodeMain = await _repoQRCodeMain.FindAll(x => x.QRCode_ID.Trim() == itemt.output.QrCodeId.Trim()).OrderByDescending(x => x.QRCode_Version).FirstOrDefaultAsync(); qrCodeMain.Valid_Status = "N"; qrCodeMain.Invalid_Date = timeNow; qrCodeMain.Updated_Time = timeNow; qrCodeMain.Updated_By = updateBy; _repoQRCodeMain.Update(qrCodeMain); } } // lưu Db return(await _repoTransactionMain.SaveAll()); }
public async Task <bool> SaveListOutput(List <OutputParam> outputParam) { DateTime timeNow = DateTime.Now; foreach (var itemt in outputParam) { Random ran = new Random(); int num = ran.Next(100, 999); // Tìm ra TransactionMain theo id var transactionMain = _repoTransactionMain.FindSingle(x => x.ID == itemt.output.Id); if (transactionMain.Transac_Type != "R") { transactionMain.Can_Move = "N"; // nếu type != R update transaction main cũ: Can_Move thành N _repoTransactionMain.Update(transactionMain); } if (transactionMain.Transac_Type == "R" && itemt.output.RemainingQty == 0) { transactionMain.Can_Move = "N"; // nếu type == R và output ra hết update : Can_Move thành N _repoTransactionMain.Update(transactionMain); } // thêm transaction main type O WMSB_Transaction_Main modelTypeO = new WMSB_Transaction_Main(); modelTypeO.Transac_Type = "O"; modelTypeO.Can_Move = "N"; modelTypeO.Transac_No = itemt.output.TransacNo; modelTypeO.Transac_Sheet_No = "OB" + DateTime.Now.ToString("yyyyMMdd") + num.ToString(); modelTypeO.Transacted_Qty = itemt.output.TransOutQty; modelTypeO.Pickup_No = itemt.output.PickupNo; modelTypeO.Transac_Time = timeNow; modelTypeO.Updated_Time = timeNow; modelTypeO.Updated_By = "Emma"; modelTypeO.Missing_No = transactionMain.Missing_No; modelTypeO.Material_ID = transactionMain.Material_ID; modelTypeO.Material_Name = transactionMain.Material_Name; modelTypeO.Purchase_No = transactionMain.Purchase_No; modelTypeO.Rack_Location = null;// type O: racklocation rỗng modelTypeO.Purchase_Qty = transactionMain.Purchase_Qty; modelTypeO.QRCode_Version = transactionMain.QRCode_Version; modelTypeO.QRCode_ID = transactionMain.QRCode_ID; modelTypeO.MO_No = transactionMain.MO_No; modelTypeO.MO_Seq = transactionMain.MO_Seq; _repoTransactionMain.Add(modelTypeO); // Thêm transaction detail mới theo type = o, dựa vào transaction detail của transaction main cũ foreach (var item in itemt.transactionDetail) { item.ID = 0;// ID trong db là tự tăng: dựa vào transaction detail cũ nên thêm mới gán id bằng 0, không cần phải new hết thuộc tính của đổi tượng ra item.Transac_No = itemt.output.TransacNo; item.Updated_By = "Emma"; item.Updated_Time = timeNow; var itemModel = _mapper.Map <WMSB_Transaction_Detail>(item); _repoTransactionDetail.Add(itemModel); } // Nếu output ra chưa hết thì thêm transaction main type R, và transaction detail, thêm qrcode mới và update version lên if (itemt.output.RemainingQty > 0) { // thêm type R // nếu type là R: thì update lại if (transactionMain.Transac_Type.Trim() == "R") { var tmpQrcodeVersion = transactionMain.QRCode_Version + 1; transactionMain.Updated_Time = timeNow; transactionMain.Updated_By = "Emma"; transactionMain.Transacted_Qty = itemt.output.TransOutQty; transactionMain.QRCode_Version = tmpQrcodeVersion; _repoTransactionMain.Update(transactionMain); // update transaction main thì cũng phải update transaction detail var transactionDetail = await _repoTransactionDetail.FindAll(x => x.Transac_No.Trim() == transactionMain.Transac_No.Trim()).ToListAsync(); foreach (var item in transactionDetail) { item.Trans_Qty = 0;// nếu transaction main là Type R là thì transaction detail của nó gán Trans_Qty = 0 item.Qty = itemt.transactionDetail.Where(x => x.Tool_Size == item.Tool_Size && x.Order_Size == item.Order_Size && x.Model_Size == item.Model_Size).FirstOrDefault().Qty; item.Instock_Qty = itemt.transactionDetail.Where(x => x.Tool_Size == item.Tool_Size && x.Order_Size == item.Order_Size && x.Model_Size == item.Model_Size).FirstOrDefault().Instock_Qty; item.Updated_By = "Emma"; item.Updated_Time = timeNow; _repoTransactionDetail.Update(item); } } // ngược lại thì thêm mới type R else { var tmpQrcodeVersion = transactionMain.QRCode_Version + 1; WMSB_Transaction_Main modelTypeR = new WMSB_Transaction_Main(); modelTypeR.Transac_Type = "R"; modelTypeR.Transac_No = "R" + transactionMain.Transac_No; modelTypeR.Transac_Sheet_No = "R" + transactionMain.Transac_Sheet_No; modelTypeR.Transacted_Qty = itemt.output.TransOutQty; modelTypeR.Updated_By = "Emma"; modelTypeR.Updated_Time = timeNow; modelTypeR.Missing_No = transactionMain.Missing_No; modelTypeR.Material_ID = transactionMain.Material_ID; modelTypeR.Material_Name = transactionMain.Material_Name; modelTypeR.Purchase_No = transactionMain.Purchase_No; modelTypeR.Rack_Location = transactionMain.Rack_Location; modelTypeR.Purchase_Qty = transactionMain.Purchase_Qty; modelTypeR.QRCode_Version = tmpQrcodeVersion; modelTypeR.QRCode_ID = transactionMain.QRCode_ID; modelTypeR.MO_No = transactionMain.MO_No; modelTypeR.MO_Seq = transactionMain.MO_Seq; modelTypeR.Can_Move = "Y"; modelTypeR.Transac_Time = transactionMain.Transac_Time; _repoTransactionMain.Add(modelTypeR); // thêm transaction main cũng phải thêm transaction detail foreach (var itemTypeR in itemt.transactionDetail) { itemTypeR.ID = 0;// ID trong db là tự tăng: dựa vào transaction detail cũ nên thêm mới gán id bằng 0, không cần phải new hết thuộc tính của đổi tượng ra itemTypeR.Transac_No = modelTypeR.Transac_No; itemTypeR.Updated_By = "Emma"; itemTypeR.Updated_Time = timeNow; itemTypeR.Trans_Qty = 0;// nếu transaction main là Type R là thì transaction detail của nó gán Trans_Qty = 0 var itemModel = _mapper.Map <WMSB_Transaction_Detail>(itemTypeR); _repoTransactionDetail.Add(itemModel); } } // thêm qrcode mới, nếu output ra chưa hết thì thêm qrcode main mới dựa vào cái cũ và update version lên var qrCodeMain = await _repoQRCodeMain.FindAll(x => x.QRCode_ID.Trim() == itemt.output.QrCodeId.Trim()).OrderByDescending(x => x.QRCode_Version).FirstOrDefaultAsync(); WMSB_QRCode_Main modelQrCodeMain = new WMSB_QRCode_Main(); modelQrCodeMain.QRCode_ID = qrCodeMain.QRCode_ID; modelQrCodeMain.QRCode_Type = qrCodeMain.QRCode_Type; modelQrCodeMain.Receive_No = qrCodeMain.Receive_No; modelQrCodeMain.Valid_Status = "Y"; modelQrCodeMain.Is_Scanned = "Y"; modelQrCodeMain.Invalid_Date = qrCodeMain.Invalid_Date; modelQrCodeMain.QRCode_Version = qrCodeMain.QRCode_Version + 1; modelQrCodeMain.Updated_Time = timeNow; modelQrCodeMain.Updated_By = "Emma"; _repoQRCodeMain.Add(modelQrCodeMain); // Update cho QRCode cũ, Valid_Status =N, Invalid_Date = Ngày mà tạo ra version mới qrCodeMain.Valid_Status = "N"; qrCodeMain.Invalid_Date = timeNow; _repoQRCodeMain.Update(qrCodeMain); // thêm qrcodedetail của qrcode mới: thêm qrcode main cũng phải thêm qrcode detail var qrCodeDetails = await _repoQRCodeDetail.FindAll(x => x.QRCode_ID.Trim() == qrCodeMain.QRCode_ID.Trim() && x.QRCode_Version == qrCodeMain.QRCode_Version).ToListAsync(); foreach (var itemQrCodeDetail in qrCodeDetails) { itemQrCodeDetail.QID = 0; itemQrCodeDetail.Updated_By = "Emma"; itemQrCodeDetail.Updated_Time = timeNow; itemQrCodeDetail.QRCode_Version = modelQrCodeMain.QRCode_Version; itemQrCodeDetail.Qty = itemt.transactionDetail.Where(x => x.Tool_Size == itemQrCodeDetail.Tool_Size && x.Order_Size == itemQrCodeDetail.Order_Size && x.Model_Size == itemQrCodeDetail.Model_Size).FirstOrDefault().Instock_Qty; _repoQRCodeDetail.Add(itemQrCodeDetail); } } } // lưu Db return(await _repoTransactionMain.SaveAll()); }