public Model.SalesOrderItem GetSOItem(int soId)
{
Model.SalesOrderItem item = (from soItem in _repository.GetQuery <Model.SalesOrderItem>().Include("Item")
where soItem.SalesOrder.ID == soId && soItem.Active_Ind == true
select soItem).FirstOrDefault();
return(item);
}
public IEnumerable <ViewModel.InvoiceItem> GetInvoiceItems(IEnumerable <Model.Container> containers)
{
List <ViewModel.InvoiceItem> busEnumeration = new List <ViewModel.InvoiceItem>();
if (containers.Count() == 0)
{
return(busEnumeration);
}
Model.SalesOrderItem soItem = GetSOItem(containers.FirstOrDefault().Booking.Sales_Order_No.ID);
if (soItem != null && soItem.Item != null)
{
foreach (var container in containers)
{
ViewModel.InvoiceItem busEntity = new VModel.InvoiceItem();
busEntity.Container_No = container.Container_No;
busEntity.Item_Name = soItem.Item.Short_Name;
busEntity.Seal_No = container.Seal1_No;
busEntity.Net_Weight = container.Net_Weight;
busEntity.Price = soItem != null ? soItem.Price : 0;
busEntity.UOM_SO = soItem != null && !string.IsNullOrWhiteSpace(soItem.Item_UOM) ? soItem.Item_UOM : "LBS";
busEntity.SO_Item_UOM_NetWeight = GetSOItemUOMWeight(container, busEntity.UOM_SO);
busEntity.Total = decimal.Round(busEntity.Price * busEntity.SO_Item_UOM_NetWeight, 2, MidpointRounding.AwayFromZero);
busEnumeration.Add(busEntity);
}
}
return(busEnumeration);
}
public Model.SalesOrderItem GetScaleSOItem(int soId, Model.ScaleDetails scaleDetails)
{
if (scaleDetails == null || scaleDetails.Apply_To_Item == null)
{
return(new Model.SalesOrderItem());
}
Model.SalesOrderItem item = (from soItem in _repository.GetQuery <Model.SalesOrderItem>()
where soItem.SalesOrder.ID == soId &&
soItem.Item.ID == scaleDetails.Apply_To_Item.ID
select soItem).FirstOrDefault();
return(item);
}
private decimal GetConvertedSOUOMNetWeight(VModel.Scale scale, int soID)
{
IEnumerable <Model.ScaleDetails> scaleDetails = _repository.Find <Model.ScaleDetails>(o => o.Scale.ID == scale.ID, new string[] { "Scale", "Item_Received", "Apply_To_Item" });
decimal UOMNetWeight = 0;
foreach (var item in scaleDetails)
{
Model.SalesOrderItem soScaleItem = GetScaleSOItem(soID, item);
string uom = soScaleItem != null && !string.IsNullOrWhiteSpace(soScaleItem.Item_UOM) ? soScaleItem.Item_UOM : "LBS";
UOMNetWeight += GetConvertedUOMWeight(item.NetWeight, uom);
}
return(UOMNetWeight);
}
public IEnumerable <ViewModel.InvoiceLocalSales> GetInvoiceItems(IEnumerable <Model.ScaleDetails> scaleDetails)
{
List <ViewModel.InvoiceLocalSales> busEnumeration = new List <ViewModel.InvoiceLocalSales>();
foreach (var item in scaleDetails)
{
Model.SalesOrderItem soScaleItem = GetScaleSOItem(item.Scale.Sales_Order.ID, item);
ViewModel.InvoiceLocalSales busEntity = new VModel.InvoiceLocalSales();
busEntity.Ticket_No = item.Scale.ID;
busEntity.Item_Name = item.Apply_To_Item.Short_Name;
busEntity.Net_Weight = item.NetWeight;
busEntity.Price = soScaleItem != null ? soScaleItem.Price : 0;
busEntity.UOM_SO = soScaleItem != null && !string.IsNullOrWhiteSpace(soScaleItem.Item_UOM) ? soScaleItem.Item_UOM : "LBS";
busEntity.SO_Item_UOM_NetWeight = GetSOItemUOMWeight(item, busEntity.UOM_SO);
busEntity.Total = decimal.Round(busEntity.Price * busEntity.SO_Item_UOM_NetWeight, 2, MidpointRounding.AwayFromZero);
busEnumeration.Add(busEntity);
}
return(busEnumeration);
}
public IEnumerable <ViewModel.InvoiceItem> GetInvoiceItems(IEnumerable <Model.ScaleDetails> scaleDetails)
{
List <ViewModel.InvoiceItem> busEnumeration = new List <ViewModel.InvoiceItem>();
foreach (var scaleDetail in scaleDetails)
{
ViewModel.InvoiceItem busEntity = new VModel.InvoiceItem();
Model.SalesOrderItem soScaleItem = GetScaleSOItem(scaleDetail.Scale.Container_No.Booking.Sales_Order_No.ID, scaleDetail);
busEntity.Container_No = scaleDetail.Scale.Container_No.Container_No;
busEntity.Item_Name = scaleDetail.Apply_To_Item.Short_Name;
busEntity.Seal_No = scaleDetail.Scale.Seal_No;
busEntity.Net_Weight = scaleDetail.NetWeight;
busEntity.Price = soScaleItem != null ? soScaleItem.Price : 0;
busEntity.UOM_SO = soScaleItem != null && !string.IsNullOrWhiteSpace(soScaleItem.Item_UOM) ? soScaleItem.Item_UOM : "LBS";
busEntity.SO_Item_UOM_NetWeight = GetSOItemUOMWeight(scaleDetail, busEntity.UOM_SO);
busEntity.Total = decimal.Round(busEntity.Price * busEntity.SO_Item_UOM_NetWeight, 2, MidpointRounding.AwayFromZero);
busEnumeration.Add(busEntity);
}
return(busEnumeration);
}