/// <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); }