public ActionResult ImportVCNB()
{
return(View("Import"));
this.transferOrderService.UserID = this.purchaseOrderService.UserID;
TransferOrderDTO transferOrderDTO = null;
int sourceLocationID = 0; int commodityTypeID = 0; int destinationWarehouseID = 0; DateTime ngayGIAO = DateTime.Today; int countRow = 0;
ICollection <TransferOrder> transferOrders = this.purchaseOrderRepository.GetEntities <TransferOrder>();
if (transferOrders != null && transferOrders.Count > 0)
{
return(View("Import")); //Check to exit if not empty
}
ICollection <VCNB_T07> vcnb_T07s = this.purchaseOrderRepository.GetEntities <VCNB_T07>().OrderBy(od => od.NGAYGIAO).ThenBy(o => o.SourceLocationID).ThenBy(ot => ot.CommodityTypeID).ThenBy(ob => ob.DestinationWarehouseID).ToList();
foreach (VCNB_T07 vcnb_T07 in vcnb_T07s)
{
countRow = countRow + 1;
if (sourceLocationID != (int)vcnb_T07.SourceLocationID || commodityTypeID != (int)vcnb_T07.CommodityTypeID || destinationWarehouseID != (int)vcnb_T07.DestinationWarehouseID || ngayGIAO != (DateTime)vcnb_T07.NGAYGIAO || countRow > 61)
{
if (transferOrderDTO != null)
{
this.transferOrderService.Save(transferOrderDTO);
}
commodityTypeID = (int)vcnb_T07.CommodityTypeID;
sourceLocationID = (int)vcnb_T07.SourceLocationID;
destinationWarehouseID = (int)vcnb_T07.DestinationWarehouseID;
ngayGIAO = (DateTime)vcnb_T07.NGAYGIAO;
countRow = 0;
transferOrderDTO = new TransferOrderDTO();
transferOrderDTO.EntryDate = ngayGIAO;
transferOrderDTO.SourceLocationID = sourceLocationID;
transferOrderDTO.WarehouseID = destinationWarehouseID;
transferOrderDTO.PreparedPersonID = this.purchaseOrderService.UserID;
transferOrderDTO.ApproverID = this.purchaseOrderService.UserID;
}
TransferOrderDetailDTO transferOrderDetailDTO = new TransferOrderDetailDTO();
transferOrderDetailDTO.CommodityID = (int)vcnb_T07.CommodityID;
transferOrderDetailDTO.CommodityCode = vcnb_T07.MAHANG;
transferOrderDetailDTO.CommodityName = vcnb_T07.TEN_VN;
transferOrderDetailDTO.CommodityTypeID = (int)vcnb_T07.CommodityTypeID;
transferOrderDetailDTO.WarehouseID = (int)vcnb_T07.WarehouseID;
transferOrderDetailDTO.Remarks = (vcnb_T07.SOKHUNG.Trim() == "" ? null : vcnb_T07.SOKHUNG.Trim()) + "#" + (vcnb_T07.SOMAY.Trim() == "" ? null : vcnb_T07.SOMAY.Trim());
transferOrderDetailDTO.Quantity = (decimal)vcnb_T07.SL;
transferOrderDetailDTO.QuantityTransfer = 0;
transferOrderDTO.TotalQuantity = Math.Round(transferOrderDTO.TotalQuantity + transferOrderDetailDTO.Quantity, 0);
transferOrderDTO.GetDetails().Add(transferOrderDetailDTO);
}
if (transferOrderDTO != null)
{
this.transferOrderService.Save(transferOrderDTO);
}
return(View("Import"));
}
public ActionResult ImportVCNB()
{
return View("Import");
this.transferOrderService.UserID = this.purchaseOrderService.UserID;
TransferOrderDTO transferOrderDTO = null;
int sourceLocationID = 0; int commodityTypeID = 0; int destinationWarehouseID = 0; DateTime ngayGIAO = DateTime.Today; int countRow = 0;
ICollection<TransferOrder> transferOrders = this.purchaseOrderRepository.GetEntities<TransferOrder>();
if (transferOrders != null && transferOrders.Count > 0) return View("Import"); //Check to exit if not empty
ICollection<VCNB_T07> vcnb_T07s = this.purchaseOrderRepository.GetEntities<VCNB_T07>().OrderBy(od => od.NGAYGIAO).ThenBy(o => o.SourceLocationID).ThenBy(ot => ot.CommodityTypeID).ThenBy(ob => ob.DestinationWarehouseID).ToList();
foreach (VCNB_T07 vcnb_T07 in vcnb_T07s)
{
countRow = countRow + 1;
if (sourceLocationID != (int)vcnb_T07.SourceLocationID || commodityTypeID != (int)vcnb_T07.CommodityTypeID || destinationWarehouseID != (int)vcnb_T07.DestinationWarehouseID || ngayGIAO != (DateTime)vcnb_T07.NGAYGIAO || countRow > 61)
{
if (transferOrderDTO != null) this.transferOrderService.Save(transferOrderDTO);
commodityTypeID = (int)vcnb_T07.CommodityTypeID;
sourceLocationID = (int)vcnb_T07.SourceLocationID;
destinationWarehouseID = (int)vcnb_T07.DestinationWarehouseID;
ngayGIAO = (DateTime)vcnb_T07.NGAYGIAO;
countRow = 0;
transferOrderDTO = new TransferOrderDTO();
transferOrderDTO.EntryDate = ngayGIAO;
transferOrderDTO.SourceLocationID = sourceLocationID;
transferOrderDTO.WarehouseID = destinationWarehouseID;
transferOrderDTO.PreparedPersonID = this.purchaseOrderService.UserID;
transferOrderDTO.ApproverID = this.purchaseOrderService.UserID;
}
TransferOrderDetailDTO transferOrderDetailDTO = new TransferOrderDetailDTO();
transferOrderDetailDTO.CommodityID = (int)vcnb_T07.CommodityID;
transferOrderDetailDTO.CommodityCode = vcnb_T07.MAHANG;
transferOrderDetailDTO.CommodityName = vcnb_T07.TEN_VN;
transferOrderDetailDTO.CommodityTypeID = (int)vcnb_T07.CommodityTypeID;
transferOrderDetailDTO.WarehouseID = (int)vcnb_T07.WarehouseID;
transferOrderDetailDTO.Remarks = (vcnb_T07.SOKHUNG.Trim() == "" ? null : vcnb_T07.SOKHUNG.Trim()) + "#" + (vcnb_T07.SOMAY.Trim() == "" ? null : vcnb_T07.SOMAY.Trim());
transferOrderDetailDTO.Quantity = (decimal)vcnb_T07.SL;
transferOrderDetailDTO.QuantityTransfer = 0;
transferOrderDTO.TotalQuantity = Math.Round(transferOrderDTO.TotalQuantity + transferOrderDetailDTO.Quantity, 0);
transferOrderDTO.GetDetails().Add(transferOrderDetailDTO);
}
if (transferOrderDTO != null) this.transferOrderService.Save(transferOrderDTO);
return View("Import");
}
