/// <summary>
/// packing detail table information with all rows.
/// </summary>
/// <returns>List<cstPackageDetails> information</returns>
public List <cstPackageDetails> GetPackingDetails()
{
//Return list.
List <cstPackageDetails> _lsReturn = new List <cstPackageDetails>();
try
{
var packingDeatils = Service.Get.PackageDetailAllPackageDetail(); //from Pack in entx3v6.PackageDetails select Pack;
//fill list object cstPackageDetails and add to return list.
//Foreach loop for all recoreds in the packageDetail table
foreach (var lsitem in packingDeatils)
{
cstPackageDetails _pd = new cstPackageDetails();
_pd.PackingDetailID = lsitem.PackagedetailID;
_pd.PackingId = lsitem.PackingId;
_pd.SKUNumber = lsitem.SKUNumber;
_pd.SKUQuantity = Convert.ToInt32(lsitem.SKUQuantity);
_pd.PackingDetailStartDateTime = Convert.ToDateTime(lsitem.SKUScanDateTime);
_pd.BoxNumber = lsitem.BoxNumber;
_pd.ShipmentLocation = lsitem.ShipmentLocation;
_pd.ItemName = lsitem.ItemName;
_pd.ProductName = lsitem.ProductName;
_pd.UnitOfMeasure = lsitem.UnitOfMeasure;
_pd.CountryOfOrigin = lsitem.CountryOfOrigin;
_pd.MAP_Price = Convert.ToDecimal(lsitem.MAP_Price);
_pd.TCLCOD_0 = lsitem.TCLCOD_0;
_pd.TarrifCode = lsitem.TarrifCode;
_lsReturn.Add(_pd);
}
}
catch (Exception)
{ }
return(_lsReturn);
}
/// <summary>
/// Filter Packing Detail Table by Box Number
/// </summary>
/// <param name="BoxNum">String Box Number</param>
/// <returns>List of Packing Detail table Information.</returns>
public List <cstPackageDetails> GetPackingDetailsByBoxNum(String BoxNum)
{
//return list.
List <cstPackageDetails> _lsReturn = new List <cstPackageDetails>();
try
{
//Filtring condition.
var packingDeatils = Service.Get.PackageDetailByBoxNumber(BoxNum);
//from Pack in entx3v6.PackageDetails
// where Pack.BoxNumber == BoxNum
// select Pack;
foreach (var lsitem in packingDeatils)
{
cstPackageDetails _pd = new cstPackageDetails();
_pd.PackingDetailID = lsitem.PackagedetailID;
_pd.PackingId = lsitem.PackingId;
_pd.SKUNumber = lsitem.SKUNumber;
_pd.SKUQuantity = Convert.ToInt32(lsitem.SKUQuantity);
_pd.PackingDetailStartDateTime = Convert.ToDateTime(lsitem.SKUScanDateTime);
_pd.BoxNumber = lsitem.BoxNumber;
_pd.ShipmentLocation = lsitem.ShipmentLocation;
_pd.ItemName = lsitem.ItemName;
_pd.ProductName = lsitem.ProductName;
_pd.UnitOfMeasure = lsitem.UnitOfMeasure;
_pd.CountryOfOrigin = lsitem.CountryOfOrigin;
_pd.MAP_Price = Convert.ToDecimal(lsitem.MAP_Price);
_pd.TCLCOD_0 = lsitem.TCLCOD_0;
_pd.TarrifCode = lsitem.TarrifCode;
_lsReturn.Add(_pd);
}
}
catch (Exception)
{ }
return(_lsReturn);
}
