public static tbl_PurchaseOrderHeader MapToModel(PurchaseOrderHeaderViewModel objectToBeMapped, int parentID)
{
var purchHeader = objectToBeMapped;
var purchHeaderTemp = new tbl_PurchaseOrderHeader
{
CreationDate = purchHeader.CreationDate,
RecieveDate = purchHeader.DocDate,
Vendor = purchHeader.VendorCode,
WareHouseID = purchHeader.WarHouseCode,
IsPosted = purchHeader.IsPosted,
PurchaseID = purchHeader.PurchId
};
if (purchHeader.TransID != null)
{
purchHeaderTemp.TransID = (int)purchHeader.TransID;
}
purchHeaderTemp.RFQTransID = parentID;
purchHeaderTemp.tbl_PurchaseOrderDetails = new ObservableCollection <tbl_PurchaseOrderDetails>();
foreach (var purchline in
from detail in purchHeader.PurchaseOrderDetails
let detail1 = detail
select new tbl_PurchaseOrderDetails
{
Color = detail1.StyleColor ?? "",
PurchasePrice = detail1.Price,
StyleCode = detail1.StyleHeader,
DelivaryDate = detail1.DelivaryDate,
tbl_PurchaseOrderSizeDetails = new ObservableCollection <tbl_PurchaseOrderSizeDetails>
(
detail.PurchaseOrderSizes
.Where(x => x.IsTextBoxEnabled)
.Select(sizeDetail => new tbl_PurchaseOrderSizeDetails
{
Size = sizeDetail.SizeCode,
Qty =
int.Parse(
sizeDetail.SizeConsumption.ToString(CultureInfo.InvariantCulture))
,
Ratio =
double.Parse(
sizeDetail.SizeRatio.ToString(CultureInfo.InvariantCulture))
})
),
tbl_PurchaseOrder_AdditionalCost =
new ObservableCollection <tbl_PurchaseOrder_AdditionalCost>(detail.AdditionalCostList)
})
{
purchHeaderTemp.tbl_PurchaseOrderDetails
.Add
(
purchline
);
}
return(purchHeaderTemp);
}
public static _proxy.tbl_PurchaseOrderHeader MapToModelObject(PurchaseOrderHeaderViewModel objectToBeMapped)
{
var temp = new _proxy.tbl_PurchaseOrderHeader
{
WareHouseID = objectToBeMapped.WareHouseItem.WarehouseID,
Vendor = objectToBeMapped.VendorCode,
RecieveDate = objectToBeMapped.RecieveDate,
CreationDate = objectToBeMapped.CreationDate,
DelivaryDate = objectToBeMapped.DelivaryDate
};
if (objectToBeMapped.TransID != null)
{
temp.TransID = (int)objectToBeMapped.TransID;
}
return(temp);
}
public IEnumerable <PurchaseOrderHeaderViewModel> GetPurchaseOrderHeader(string documentNo)
{
IEnumerable <PurchaseOrderHeaderViewModel> result = null;
using (var context = new ArtileriDataContext(ConnectionString))
{
var poHeader = context.PurchaseOrderHeaders.SingleOrDefault(po => po.DocumentNo == documentNo);
if (poHeader == null)
{
return(null);
}
var header = new PurchaseOrderHeaderViewModel();
header.DocumentNo = poHeader.DocumentNo;
header.DocumentDate = poHeader.Date;
header.ExpectedDate = poHeader.ExpectedDate.GetValueOrDefault(DateTime.Today);
header.SupplierName = poHeader.Supplier.Name;
header.SupplierNPWP = poHeader.Supplier.NPWP;
header.SupplierAddress = poHeader.Supplier.Address;
header.EmployeeName = context.Employees.Single(emp => emp.ID == poHeader.EmployeeID).Name;
header.CompanyName = CompanyName;
header.CompanyAddress1 = CompanyAddress1;
header.CompanyAddress2 = CompanyAddress2;
header.Terms = poHeader.Terms;
header.DiscountValue = poHeader.DiscountValue;
header.Notes = poHeader.Notes;
header.ApproverName = POApproverName;
header.SupplierTaxable = poHeader.Supplier.Taxable;
header.SubTotal = poHeader.PurchaseOrderDetails.Sum(pod => ((pod.Quantity * pod.UnitPrice) -
(pod.Quantity * pod.UnitPrice *
pod.DiscountRate / 100)) *
(pod.IsTaxed ? 1.1M : 1M));
header.GrandTotal = header.SubTotal - header.DiscountValue;
header.Terbilang = new Conversion().ConvertMoneyToWords(header.GrandTotal);
header.ApprovedDate = poHeader.ApprovedDate;
if (poHeader.Status == "O")
{
header.Status = "Open";
}
else if (poHeader.Status == "A")
{
header.Status = "Approved";
}
else if (poHeader.Status == "N")
{
header.Status = "Not Approved";
}
else if (poHeader.Status == "C")
{
header.Status = "Closed";
}
else if (poHeader.Status == "V")
{
header.Status = "Void";
}
result = new List <PurchaseOrderHeaderViewModel>()
{
header
};
}
return(result);
}
