public async Task <ActionResult> Add([FromBody] ImportStockModel _model)
{
string link = URI_API.STOCK_RECEIVE_DOCKET_ADD;
ResponseConsult <int> response = await PostAsJsonAsync <int>(link, _model);
return(Ok(response));
}
public async Task <IActionResult> Add([FromBody] ImportStockModel _model)
{
var result = await busStockReceiveDocket.Add(_model);
return(Ok(context.WrapResponse(result)));
}
public async Task <int> Add(ImportStockModel _model)
{
if (_model == null || _model.ReceiveDocket == null || _model.Suppliers == null)
{
scopeContext.AddError("Lỗi dữ liệu đầu vào");
return(0);
}
if (_model.ReceiveDocket.StockReceiveDocketTypeId <= 0)
{
scopeContext.AddError("Chưa chọn loại phiếu nhập");
return(0);
}
if (_model.ReceiveDocket.WarehouseId <= 0)
{
scopeContext.AddError("Chưa chọn kho nhập");
return(0);
}
// lấy loại phiếu chi
var receiveDocketType = await svcStockReceiveDocketType.GetDetail(_model.ReceiveDocket.StockReceiveDocketTypeId);
var paySlipType = 0;
if (receiveDocketType != null && receiveDocketType.PayslipNeeded)
{
paySlipType = receiveDocketType.PayslipTypeId;
}
// bắt đầu tạo phiếu
using (var transaction = context.Database.BeginTransaction())
{
try
{
StockReceiveDocket docket = iMapper.Map <StockReceiveDocket>(_model.ReceiveDocket);
docket.ExecutorCode = scopeContext.UserCode;
docket.ExecutedDate = DateTime.UtcNow;
if (docket.IsActuallyReceived.GetValueOrDefault(false))
{
docket.ActuallyReceivedDate = docket.ExecutedDate;
docket.ActuallyReceivedCode = docket.ExecutorCode;
}
docket.Id = await svcStockReceiveDocket.Add(docket);
decimal orderVAT = 0;
decimal orderAmount = 0;
decimal orderTotalAmount = 0;
List <ProductInstockModel> productInstock = new List <ProductInstockModel>();
foreach (ImportStockSupplierModel item in _model.Suppliers)
{
ExpenditureDocket exp = null;
if (paySlipType > 0)
{
exp = new ExpenditureDocket();
exp.StockDocketId = docket.Id;
exp.PartnerId = item.SupplierBranchId;
exp.PartnerName = item.SupplierBranchName;
exp.WarehouseId = docket.WarehouseId;
exp.BillCode = item.BillCode;
exp.BillSerial = item.BillSerial;
exp.BillTemplateCode = item.BillTemplateCode;
exp.BillDate = item.BillDate;
exp.CreatedUser = scopeContext.UserCode;
exp.IsReceipt = false;
exp.ExpendDate = docket.ExecutedDate;
exp.Amount = 0;
exp.TotalAmount = 0;
exp.Vat = 0;
exp.Id = await svcExpenditureDocket.Add(exp);
}
decimal supplierAmount = 0;
decimal supplierTotalAmount = 0;
decimal supplierVat = 0;
foreach (StockReceiveDocketDetailModel i in item.ReceiveDocketDetails)
{
StockReceiveDocketDetail docketDetail = iMapper.Map <StockReceiveDocketDetail>(i);
docketDetail.StockReceiveDocketId = docket.Id;
docketDetail.SupplierBranchId = item.SupplierBranchId;
docketDetail.SupplierBranchName = item.SupplierBranchName;
if (paySlipType > 0)
{
docketDetail.Amount = i.Quantity * i.UnitPrice;
docketDetail.Vat = docketDetail.Amount * (i.VatPercent / (decimal)100);
docketDetail.TotalAmount = docketDetail.Amount + docketDetail.Vat;
}
else
{
docketDetail.UnitPrice = 0;
docketDetail.Amount = 0;
docketDetail.Vat = 0;
docketDetail.TotalAmount = 0;
}
docketDetail.Id = await svcStockReceiveDocketDetail.Add(docketDetail);
if (paySlipType > 0)
{
ExpenditureDocketDetail eD = new ExpenditureDocketDetail();
eD.ExpenditureDocketId = exp.Id;
eD.VatPercent = docketDetail.VatPercent;
eD.Amount = docketDetail.Amount;
eD.Vat = docketDetail.Vat;
eD.TotalAmount = docketDetail.TotalAmount;
eD.ProductId = docketDetail.ProductId;
eD.ExpenditureTypeId = paySlipType;
eD.Id = await svcExpenditureDocketDetail.Add(eD);
}
supplierAmount += docketDetail.Amount;
supplierTotalAmount += docketDetail.TotalAmount;
supplierVat += docketDetail.Vat;
#region Thêm vào danh sách tồn - Tạm thời chưa chuyển đổi sang số lượng theo đơn vị tính chuẩn
var idx = productInstock.FindIndex(p => p.ProductId == i.ProductId);
if (idx >= 0)
{
productInstock[idx].Quantity += i.Quantity;
}
else
{
productInstock.Add(new ProductInstockModel()
{
ProductId = i.ProductId,
ProductName = i.ProductName,
Quantity = i.Quantity,
ProductUnitId = i.ProductUnitId
});
}
#endregion
}
if (paySlipType > 0)
{
exp.Amount += supplierAmount;
exp.TotalAmount += supplierTotalAmount;
exp.Vat += supplierVat;
await svcExpenditureDocket.Modify(exp);
}
orderVAT += supplierVat;
orderAmount += supplierAmount;
orderTotalAmount += supplierTotalAmount;
}
// nếu có chi phí phát sinh, tạo phiếu chi
if (_model.PaySlipDetails != null && _model.PaySlipDetails.Count > 0)
{
ExpenditureDocket expendDocket = new ExpenditureDocket();
expendDocket.StockDocketId = docket.Id;
expendDocket.WarehouseId = docket.WarehouseId;
expendDocket.CreatedUser = scopeContext.UserCode;
expendDocket.ExpendDate = docket.ExecutedDate;
expendDocket.Amount = 0;
expendDocket.TotalAmount = 0;
expendDocket.Vat = 0;
expendDocket.Id = await svcExpenditureDocket.Add(expendDocket);
foreach (ExpenditureDocketDetailModel item in _model.PaySlipDetails)
{
ExpenditureDocketDetail eD = iMapper.Map <ExpenditureDocketDetail>(item);
eD.ExpenditureDocketId = expendDocket.Id;
eD.Id = await svcExpenditureDocketDetail.Add(eD);
expendDocket.Amount += eD.Amount;
expendDocket.TotalAmount += eD.TotalAmount;
expendDocket.Vat += eD.Vat;
}
await svcExpenditureDocket.Modify(expendDocket);
orderVAT += expendDocket.Vat;
orderAmount += expendDocket.Amount;
orderTotalAmount += expendDocket.TotalAmount;
}
// cập nhật phiếu nhập
docket.Vat = orderVAT;
docket.Amount = orderAmount;
docket.TotalAmount = orderTotalAmount;
await svcStockReceiveDocket.Modify(docket);
#region Cập nhật vào bảng tồn
foreach (var current in productInstock)
{
var instock = await svcCurrentInStock.GetList(docket.WarehouseId, current.ProductId);
if (instock == null || instock.Count == 0)
{
CurrentInStock cis = new CurrentInStock()
{
Amount = docket.IsActuallyReceived == true ? current.Quantity : 0,
AmountExpect = current.Quantity,
ProductId = current.ProductId,
ProductUnitId = current.ProductUnitId,
WarehouseId = docket.WarehouseId
};
cis.Id = await svcCurrentInStock.Add(cis);
}
else
{
CurrentInStock cis = instock[0];
if (docket.IsActuallyReceived == true)
{
cis.Amount += current.Quantity;
}
cis.AmountExpect += current.Quantity;
await svcCurrentInStock.Modify(cis);
}
}
#endregion
transaction.Commit();
return(docket.Id);
}catch
{
transaction.Rollback();
return(0);
}
}
}
