//Import
public ActionResult Import()
{
return(View());
this.purchaseInvoiceService.UserID = this.purchaseOrderService.UserID;
this.goodsReceiptService.UserID = this.purchaseOrderService.UserID;
PurchaseOrderDTO purchaseOrderDTO = null;
CommoditiesApiController commoditiesApi = new CommoditiesApiController(this.commodityRepository);
int warehouseID = 0; int commodityCategoryID = 0; int countRow = 0;
var purchaseOrderEntity = this.purchaseOrderRepository.GetEntity();
if (purchaseOrderEntity != null)
{
return(View()); //Check to exit if not empty
}
ICollection <Inventory_30_06_33> Inventory_30_06_33s = this.purchaseOrderRepository.GetEntities <Inventory_30_06_33>().OrderBy(o => o.WarehouseID).ThenBy(ob => ob.SupplierID).ToList();
foreach (Inventory_30_06_33 Inventory_30_06_33 in Inventory_30_06_33s)
{
countRow = countRow + 1;
if (warehouseID != (int)Inventory_30_06_33.WarehouseID || commodityCategoryID != (int)Inventory_30_06_33.SupplierID || countRow > 55)
{
if (purchaseOrderDTO != null)
{
this.SaveInit3006(purchaseOrderDTO, warehouseID);
}
commodityCategoryID = (int)Inventory_30_06_33.SupplierID;
warehouseID = (int)Inventory_30_06_33.WarehouseID;
countRow = 0;
purchaseOrderDTO = new PurchaseOrderDTO();
purchaseOrderDTO.EntryDate = new DateTime(2015, 06, 30);
purchaseOrderDTO.SupplierID = 1;
purchaseOrderDTO.PriceTermID = 1;
purchaseOrderDTO.PaymentTermID = 1;
purchaseOrderDTO.PreparedPersonID = this.purchaseOrderService.UserID;
purchaseOrderDTO.ApproverID = this.purchaseOrderService.UserID;
}
PurchaseOrderDetailDTO purchaseOrderDetailDTO = new PurchaseOrderDetailDTO();
purchaseOrderDetailDTO.CommodityID = Inventory_30_06_33.CommodityID;
purchaseOrderDetailDTO.CommodityCode = Inventory_30_06_33.Description;
purchaseOrderDetailDTO.CommodityName = Inventory_30_06_33.DescriptionOfficial;
purchaseOrderDetailDTO.CommodityTypeID = (int)Inventory_30_06_33.ItemTypeID;
purchaseOrderDetailDTO.ChassisCode = Inventory_30_06_33.SerialNo.Trim() == "" ? null : Inventory_30_06_33.SerialNo.Trim();
purchaseOrderDetailDTO.EngineCode = Inventory_30_06_33.FixedAsset.Trim() == "" ? null : Inventory_30_06_33.FixedAsset.Trim();
purchaseOrderDetailDTO.ColorCode = Inventory_30_06_33.ColorCode.Trim() == "" ? null : Inventory_30_06_33.ColorCode.Trim();
purchaseOrderDetailDTO.Origin = Inventory_30_06_33.WHInputID.ToString();
purchaseOrderDetailDTO.Packing = Inventory_30_06_33.WHInputDate.ToString();
purchaseOrderDetailDTO.Quantity = (decimal)Inventory_30_06_33.QuantityEnd;
purchaseOrderDetailDTO.UnitPrice = (decimal)Inventory_30_06_33.UPriceNMDInventory;
purchaseOrderDetailDTO.VATPercent = 10;
purchaseOrderDetailDTO.GrossPrice = Math.Round(purchaseOrderDetailDTO.UnitPrice * (1 + purchaseOrderDetailDTO.VATPercent / 100), 0);
purchaseOrderDetailDTO.Amount = Math.Round(purchaseOrderDetailDTO.Quantity * purchaseOrderDetailDTO.UnitPrice, 0);
purchaseOrderDetailDTO.GrossAmount = Math.Round(purchaseOrderDetailDTO.Quantity * purchaseOrderDetailDTO.GrossPrice, 0);
purchaseOrderDetailDTO.VATAmount = Math.Round(purchaseOrderDetailDTO.GrossAmount - purchaseOrderDetailDTO.Amount, 0);
purchaseOrderDetailDTO.QuantityInvoice = 0;
purchaseOrderDTO.TotalQuantity = Math.Round(purchaseOrderDTO.TotalQuantity + purchaseOrderDetailDTO.Quantity, 0);
purchaseOrderDTO.TotalAmount = Math.Round(purchaseOrderDTO.TotalAmount + purchaseOrderDetailDTO.Amount, 0);
purchaseOrderDTO.TotalVATAmount = Math.Round(purchaseOrderDTO.TotalVATAmount + purchaseOrderDetailDTO.VATAmount, 0);
purchaseOrderDTO.TotalGrossAmount = Math.Round(purchaseOrderDTO.TotalGrossAmount + purchaseOrderDetailDTO.GrossAmount, 0);
purchaseOrderDTO.GetDetails().Add(purchaseOrderDetailDTO);
}
if (purchaseOrderDTO != null)
{
this.SaveInit3006(purchaseOrderDTO, warehouseID);
}
return(View());
}
//Import
public ActionResult Import072015()
{
return(View());
return(View());
return(View());
this.purchaseInvoiceService.UserID = this.purchaseOrderService.UserID;
this.goodsReceiptService.UserID = this.purchaseOrderService.UserID;
PurchaseOrderDTO purchaseOrderDTO = null;
CommoditiesApiController commoditiesApi = new CommoditiesApiController(this.commodityRepository);
string loHANG = ""; int countRow = 0; int warehouseID = 0;
ICollection <RAWDATA_07_2015> RAWDATA_07_2015s = this.purchaseOrderRepository.GetEntities <RAWDATA_07_2015>().Where(w => w.WarehouseID == this.purchaseOrderService.LocationID).OrderBy(o => o.LOHANG).ToList();
foreach (RAWDATA_07_2015 RAWDATA_07_2015 in RAWDATA_07_2015s)
{
countRow = countRow + 1;
if (loHANG != RAWDATA_07_2015.LOHANG || countRow > 30)
{
if (purchaseOrderDTO != null)
{
this.SaveInit3006(purchaseOrderDTO, warehouseID); //Luu y: Moi lan RUN cai foreach nay: la chi load THE SAME WarehouseID, VI VAY, CAI RAWDATA_07_2015.WarehouseID LUON GIONG NHAU
}
loHANG = RAWDATA_07_2015.LOHANG;
countRow = 0;
purchaseOrderDTO = new PurchaseOrderDTO();
purchaseOrderDTO.EntryDate = RAWDATA_07_2015.NGAYGIAO;
purchaseOrderDTO.SupplierID = 1;
purchaseOrderDTO.PriceTermID = 1;
purchaseOrderDTO.PaymentTermID = 1;
purchaseOrderDTO.PreparedPersonID = this.purchaseOrderService.UserID;
purchaseOrderDTO.ApproverID = this.purchaseOrderService.UserID;
purchaseOrderDTO.ConfirmReference = RAWDATA_07_2015.LOHANG + RAWDATA_07_2015.LOHANG != RAWDATA_07_2015.DONHANG ? " [" + RAWDATA_07_2015.DONHANG + "]" : "";
}
PurchaseOrderDetailDTO purchaseOrderDetailDTO = new PurchaseOrderDetailDTO();
warehouseID = RAWDATA_07_2015.WarehouseID;
purchaseOrderDetailDTO.CommodityID = (int)RAWDATA_07_2015.CommodityID;
purchaseOrderDetailDTO.CommodityCode = RAWDATA_07_2015.MAHANG;
purchaseOrderDetailDTO.CommodityName = RAWDATA_07_2015.TEN_VN;
purchaseOrderDetailDTO.CommodityTypeID = (int)RAWDATA_07_2015.CommodityTypeID;
purchaseOrderDetailDTO.ChassisCode = RAWDATA_07_2015.SOKHUNG == null ? null : (RAWDATA_07_2015.SOKHUNG.Trim() == "" ? null : RAWDATA_07_2015.SOKHUNG.Trim());
purchaseOrderDetailDTO.EngineCode = RAWDATA_07_2015.SOMAY == null ? null : (RAWDATA_07_2015.SOMAY.Trim() == "" ? null : RAWDATA_07_2015.SOMAY.Trim());
purchaseOrderDetailDTO.ColorCode = RAWDATA_07_2015.MAUXE == null ? null : (RAWDATA_07_2015.MAUXE.Trim() == "" ? null : RAWDATA_07_2015.MAUXE.Trim());
purchaseOrderDetailDTO.Quantity = (decimal)RAWDATA_07_2015.SOLUONG;
purchaseOrderDetailDTO.UnitPrice = (decimal)RAWDATA_07_2015.DONGIA;
purchaseOrderDetailDTO.VATPercent = 10;
purchaseOrderDetailDTO.GrossPrice = Math.Round(purchaseOrderDetailDTO.UnitPrice * (1 + purchaseOrderDetailDTO.VATPercent / 100), 0);
purchaseOrderDetailDTO.Amount = Math.Round(purchaseOrderDetailDTO.Quantity * purchaseOrderDetailDTO.UnitPrice, 0);
purchaseOrderDetailDTO.GrossAmount = Math.Round(purchaseOrderDetailDTO.Quantity * purchaseOrderDetailDTO.GrossPrice, 0);
purchaseOrderDetailDTO.VATAmount = Math.Round(purchaseOrderDetailDTO.GrossAmount - purchaseOrderDetailDTO.Amount, 0);
purchaseOrderDetailDTO.QuantityInvoice = 0;
purchaseOrderDTO.TotalQuantity = Math.Round(purchaseOrderDTO.TotalQuantity + purchaseOrderDetailDTO.Quantity, 0);
purchaseOrderDTO.TotalAmount = Math.Round(purchaseOrderDTO.TotalAmount + purchaseOrderDetailDTO.Amount, 0);
purchaseOrderDTO.TotalVATAmount = Math.Round(purchaseOrderDTO.TotalVATAmount + purchaseOrderDetailDTO.VATAmount, 0);
purchaseOrderDTO.TotalGrossAmount = Math.Round(purchaseOrderDTO.TotalGrossAmount + purchaseOrderDetailDTO.GrossAmount, 0);
purchaseOrderDTO.GetDetails().Add(purchaseOrderDetailDTO);
}
if (purchaseOrderDTO != null)
{
this.SaveInit3006(purchaseOrderDTO, warehouseID);
}
return(View());
}
