//public void getSlipdata(string BoxNumber)
//{
// List<cstSlipData> slp = new List<cstSlipData>();
// try
// {
// slp = slip.SlipData(BoxNumber);
// foreach (var item in slp)
// {
// txtponumber.Text = item.CustomerPO;
// txtaddress.Text = item.ToAddressLine1 + item.ToAddressLine2 + item.ToAddressLine3 + item.ToAddressCity + item.ToAddressState + item.ToAddressZipCode;
// txtUPC.Text = item.UPCCode;
// txtvendor.Text = item.VendorName;
// }
// }
// catch (Exception)
// {}
//}
private void Window_Loaded_1(object sender, RoutedEventArgs e)
{
//Box Information
cstBoxPackage _boxInfo = Global.controller.GetBoxPackageByBoxID(Global.PrintBoxID);
String BoxNumber = _boxInfo.BOXNUM;
EBoxNumber = BoxNumber;
//Package Information
cstPackageTbl packing = Global.controller.GetPackingList(_boxInfo.PackingID, true);
String ShippingNumber = packing.ShippingNum;
//Shipping information
cstShippingTbl shippingTbl = Global.controller.GetShippingTbl(ShippingNumber);
List <cstPackageDetails> _packingDetails = Global.controller.GetPackingDetailTbl(packing.PackingId);
//List<cstShippingTbl> ship = Global.controller.GetShippingInfoFromSage(ShippingNumber);
cmdGetSlipData slip = new cmdGetSlipData();
List <string> skulist = slip.getSKUfromBoxNumber(BoxNumber);
foreach (var item in skulist)
{
String UPC_Code = _shipment.ShipmentDetailSage.FirstOrDefault(i => i.SKU == item).UPCCode;
txtaddress.Text = shippingTbl.ToAddressLine1 + " " + shippingTbl.ToAddressLine2 + " " + shippingTbl.ToAddressLine3 + " " + shippingTbl.ToAddressCity + " " + shippingTbl.ToAddressState + " " + shippingTbl.ToAddressCountry + " " + shippingTbl.ToAddressZipCode;
txtponumber.Text = shippingTbl.CustomerPO;
//txtvendor.Text = shippingTbl.VendorName;
}
}
private void Window_Loaded_1(object sender, RoutedEventArgs e)
{
cstShippingTbl lstshipping = new cstShippingTbl();
lstshipping = _Contro.GetShippingTbl(Global.ShipmentNumberforferguson);
lblFromAddress.Text = lstshipping.FromAddressLine1 + " " + lstshipping.FromAddressLine2 + " " + lstshipping.FromAddressLine3 + " " + lstshipping.FromAddressCity + " " + lstshipping.FromAddressState + " " + lstshipping.FromAddressCountry + " " + lstshipping.FromAddressZipCode;
lblCarrier.Text = lstshipping.Carrier;
lblPonumber.Text = lstshipping.CustomerPO;
lblToAddress.Text = lstshipping.CustomerName1 + " " + lstshipping.ToAddressLine1 + " " + lstshipping.ToAddressLine2 + " " + lstshipping.ToAddressLine3 + " " + lstshipping.ToAddressCity + " " + lstshipping.ToAddressState + " " + lstshipping.ToAddressCountry + " " + lstshipping.ToAddressZipCode;
}
private void Window_Loaded_1(object sender, RoutedEventArgs e)
{
//Box Information
String BoxNumber = Global.BoxNumberScanned;
EBoxNumber = Global.BoxNumberScanned;
//Package Information
String ShippingNumber = Global.ShippingNumber;
//Shipping information
cstShippingTbl shippingTbl = Global.controller.GetShippingTbl(ShippingNumber);
List <cstPackageDetails> _packingDetails = Global.controller.GetPackingDetailTbl(BoxNumber);
model_Shipment _shipment = Global.controller.getModelShipment(ShippingNumber);
string upccode = Global.controller.SKUnameToUPCCode(_packingDetails[Global.counter].SKUNumber);
//String UPC_Code = _shipment.ShipmentDetailSage.SingleOrDefault(i => i.SKU == item.UPCCode).UPCCode;
txtaddress.Text = shippingTbl.ToAddressLine1 + shippingTbl.ToAddressLine2 + shippingTbl.ToAddressLine3 + shippingTbl.ToAddressCity + shippingTbl.ToAddressState + shippingTbl.ToAddressCountry + shippingTbl.ToAddressZipCode;
txtponumber.Text = shippingTbl.CustomerPO;
// txtvendorname.Text = shippingTbl.VendorName;
txtWH.Text = Global.WH;
txtupc.Text = upccode;
txtQty.Text = _packingDetails[Global.counter].SKUQuantity.ToString();
txtPartNumber.Text = _packingDetails[Global.counter].SKUNumber.ToString();
txtCarton.Text = GetCarton(BoxNumber);
txtBoxNumber.Text = GetBox(BoxNumber);
UPCA upca = new UPCA();
if (this.txtupc.Text.Length == 12)
{
this.txtupc.Text = this.txtupc.Text.Substring(0, 11) + upca.GetCheckSum(this.txtupc.Text).ToString();
System.Drawing.Image img;
img = upca.CreateBarCode(this.txtupc.Text, 3);
var imges = new System.Drawing.Bitmap(img);
var newimag = Imaging.CreateBitmapSourceFromHBitmap(imges.GetHbitmap(), IntPtr.Zero, Int32Rect.Empty, BitmapSizeOptions.FromEmptyOptions());
image.Source = newimag;
}
else
{
this.image.Source = null;
}
}
/// <summary>
/// Check fot status and process cstpackingtbl list according to flag.
/// </summary>
/// <returns></returns>
public static List <cstPackageTbl> GetPackageTbl()
{
///Get all package table items.
List <cstPackageTbl> _lspackagetbl = Obj.call.GetPackingTbl();
try
{
if (IsShipmentNumberFilterOn)//Shipment ID filter on check
{
List <cstPackageTbl> _tempPacktbl = new List <cstPackageTbl>();
foreach (cstPackageTbl lsitem in _lspackagetbl)
{
if (lsitem.ShippingNum == _shipmentNumber)
{
_tempPacktbl.Add(lsitem);
}
}
_lspackagetbl = _tempPacktbl;
}
if (IsUserFilerOn)//User name filter ON check
{
List <cstPackageTbl> _tempPacktbl = new List <cstPackageTbl>();
foreach (cstPackageTbl lsitem in _lspackagetbl)
{
if (lsitem.UserID == _userID)
{
_tempPacktbl.Add(lsitem);
}
}
_lspackagetbl = _tempPacktbl;
}
if (IsLocationFilterOn)
{
List <cstPackageTbl> _tempPacktbl = new List <cstPackageTbl>();
foreach (cstPackageTbl lsitem in _lspackagetbl)
{
if (lsitem.ShipmentLocation == _location)
{
_tempPacktbl.Add(lsitem);
}
}
_lspackagetbl = _tempPacktbl;
}
if (IsPackingStatusFilterOn)
{
List <cstPackageTbl> _tempPacktbl = new List <cstPackageTbl>();
foreach (cstPackageTbl lsitem in _lspackagetbl)
{
if (_packingStatus <= 1)
{
if (lsitem.PackingStatus == _packingStatus)
{
_tempPacktbl.Add(lsitem);
}
}
else
{
if (lsitem.PackingStatus == 0 && _packingStatus > 1)
{
string TrackingNum = "";
//Get all Boxes From that package.
List <cstBoxPackage> boxpackage = Obj.call.GetBoxPackageByPackingID(lsitem.PackingId);
//Foreach Box look for tracking number is available if not break the loop and Return not shipped.
foreach (var box in boxpackage)
{
TrackingNum = Obj.call.IsTrackingNum(box.BOXNUM);
if (TrackingNum == "")
{
break;
}
}
//Shipped
if (TrackingNum != "" && _packingStatus == 3)
{
_tempPacktbl.Add(lsitem);
}
//Shipping and Packed
if (TrackingNum == "" && _packingStatus == 2)
{
_tempPacktbl.Add(lsitem);
}
}
}
}
_lspackagetbl = _tempPacktbl;
}
if (IsDateTimeFilterOn)
{
List <cstPackageTbl> _tempPacktbl = new List <cstPackageTbl>();
foreach (cstPackageTbl lsitem in _lspackagetbl)
{
DateTime _frmDate = lsitem.StartTime.Date;
if (lsitem.StartTime.Date >= _fromDate.Date && lsitem.StartTime.Date <= _toDate.Date)
{
_tempPacktbl.Add(lsitem);
}
}
_lspackagetbl = _tempPacktbl;
}
if (IsCuStomerPOFilterOn)
{
List <cstPackageTbl> _tempPacktbl = new List <cstPackageTbl>();
foreach (cstPackageTbl lsitem in _lspackagetbl)
{
cstShippingTbl _TblShippiing = Obj.call.GetShippingTbl().FirstOrDefault(i => i.CustomerPO == _cusTomerPo && i.ShippingNum == lsitem.ShippingNum);
if (_TblShippiing != null)
{
_tempPacktbl.Add(lsitem);
}
}
_lspackagetbl = _tempPacktbl;
}
if (IsOverrideModeFilterOn)
{
List <cstPackageTbl> _tempPacktbl = new List <cstPackageTbl>();
foreach (cstPackageTbl lsitem in _lspackagetbl)
{
if (lsitem.MangerOverride == _overrdeMode)
{
_tempPacktbl.Add(lsitem);
}
}
_lspackagetbl = _tempPacktbl;
}
}
catch (Exception)
{ }
return(_lspackagetbl);
}
/// <summary>
/// Shipping table information From sage.
/// </summary>
/// <param name="ShippingNumber">String Shippign Number</param>
/// <returns> List of cstShippingTbl information.</returns>
public List <cstShippingTbl> getShippingInfo(String ShippingNumber, string Flag)
{
List <cstShippingTbl> _lsShippingInfo = new List <cstShippingTbl>();
if (Flag == "UPSandFeDex")
{
try
{
var ShippingInfo = from ls in entx3v6.getShippingDetails
where ls.ShippingNum == ShippingNumber
select ls;
//AND [SDELIVERY].[SDHNUM_0]='" + ShippingNumber + "';").ToList();
if (ShippingInfo != null)
{
foreach (var _shippingInfo in ShippingInfo.ToList())
{
cstShippingTbl Ship = new cstShippingTbl();
// Ship.ShippingID = _shippingInfo.ShippingID;
Ship.ShippingNum = _shippingInfo.ShippingNum;
Ship.ShippingStartTime = Convert.ToDateTime(DateTime.UtcNow);
Ship.ShippingEndTime = Convert.ToDateTime(DateTime.UtcNow);
Ship.DeliveryProvider = _shippingInfo.DeliveryProvider;
Ship.DeliveryMode = _shippingInfo.DeliveryMode;
Ship.FromAddressLine1 = _shippingInfo.FromAddressLine1;
Ship.FromAddressLine2 = _shippingInfo.FromAddressLine2;
Ship.FromAddressLine3 = _shippingInfo.FromAddressLine3;
Ship.FromAddressCity = _shippingInfo.FromAddressCity;
Ship.FromAddressState = _shippingInfo.FromAddressState;
Ship.FromAddressCountry = _shippingInfo.FromAddressCountry;
Ship.FromAddressZipCode = _shippingInfo.FromAddressZipCode;
Ship.ToAddressLine1 = _shippingInfo.ToAddressLine1;
Ship.ToAddressLine2 = _shippingInfo.ToAddressLine2;
Ship.ToAddressLine3 = _shippingInfo.ToAddressLine3;
Ship.ToAddressCity = _shippingInfo.ToAddressCity;
Ship.ToAddressState = _shippingInfo.ToAddressState;
Ship.ToAddressCountry = _shippingInfo.ToAddressCountry;
Ship.ToAddressZipCode = _shippingInfo.ToAddressZipCode;
Ship.ShipmentStatus = _shippingInfo.ShipmentStatus;
Ship.OrderID = _shippingInfo.OrderID;
Ship.CustomerPO = _shippingInfo.CustomerPO;
Ship.ShipToAddress = _shippingInfo.ShipToAddress;
Ship.OurSupplierNo = _shippingInfo.OurSupplierNo;
Ship.CustomerName1 = _shippingInfo.CustomerName1;
Ship.CustomerName2 = _shippingInfo.CustomerName2;
Ship.WebAddress = _shippingInfo.WebAddress;
Ship.FreightTerms = _shippingInfo.FreightTerms;
Ship.Carrier = _shippingInfo.Carrier;
Ship.DeliveryContact = _shippingInfo.DeliveryContact;
Ship.Indexcode = Convert.ToInt16(_shippingInfo.Indexcode);
Ship.Contact = _shippingInfo.Contact;
Ship.PaymentTerms = _shippingInfo.PaymentTerms;
Ship.TotalPackages = Convert.ToInt32(_shippingInfo.TotalPackages);
Ship.Fax = _shippingInfo.Fax;
Ship.VendorName = _shippingInfo.VendorName;
Ship.MDL_0 = _shippingInfo.DeliveryMode;
Ship.XB_RESFLG_0 = Convert.ToByte(_shippingInfo.XB_RESFLG_0);
Ship.CODCHG_0 = _shippingInfo.CODCHG_0;
Ship.INSVAL_0 = Convert.ToDecimal(_shippingInfo.INSVAL_0);
Ship.ADDCODFRT_0 = Convert.ToByte(_shippingInfo.ADDCODFRT_0);
Ship.BILLOPT_0 = _shippingInfo.BILLOPT_0;
Ship.HDLCHG_0 = _shippingInfo.HDLCHG_0;
Ship.DOWNFLG_0 = Convert.ToByte(_shippingInfo.DOWNFLG_0);
Ship.BACCT_0 = _shippingInfo.BACCT_0;
Ship.TPBILL_0 = Convert.ToByte(_shippingInfo.TPBILL_0);
Ship.CUSTBILL_0 = Convert.ToByte(_shippingInfo.CUSTBILL_0);
Ship.CNTFULNAM_0 = _shippingInfo.CNTFULNAM_0;
_lsShippingInfo.Add(Ship);
}
}
}
catch (Exception)
{ }
}
else if (Flag == "LTL")
{
try
{
var ShippingInfo = from ls in entx3v6.getShippingDetails_LTL_Non_FEDEX_UPS
where ls.ShippingNum == ShippingNumber
select ls;
//AND [SDELIVERY].[SDHNUM_0]='" + ShippingNumber + "';").ToList();
if (ShippingInfo != null)
{
foreach (var _shippingInfo in ShippingInfo.ToList())
{
cstShippingTbl Ship = new cstShippingTbl();
// Ship.ShippingID = _shippingInfo.ShippingID;
Ship.ShippingNum = _shippingInfo.ShippingNum;
Ship.ShippingStartTime = Convert.ToDateTime(DateTime.UtcNow);
Ship.ShippingEndTime = Convert.ToDateTime(DateTime.UtcNow);
Ship.DeliveryProvider = _shippingInfo.DeliveryProvider;
Ship.DeliveryMode = _shippingInfo.DeliveryMode;
Ship.FromAddressLine1 = _shippingInfo.FromAddressLine1;
Ship.FromAddressLine2 = _shippingInfo.FromAddressLine2;
Ship.FromAddressLine3 = _shippingInfo.FromAddressLine3;
Ship.FromAddressCity = _shippingInfo.FromAddressCity;
Ship.FromAddressState = _shippingInfo.FromAddressState;
Ship.FromAddressCountry = _shippingInfo.FromAddressCountry;
Ship.FromAddressZipCode = _shippingInfo.FromAddressZipCode;
Ship.ToAddressLine1 = _shippingInfo.ToAddressLine1;
Ship.ToAddressLine2 = _shippingInfo.ToAddressLine2;
Ship.ToAddressLine3 = _shippingInfo.ToAddressLine3;
Ship.ToAddressCity = _shippingInfo.ToAddressCity;
Ship.ToAddressState = _shippingInfo.ToAddressState;
Ship.ToAddressCountry = _shippingInfo.ToAddressCountry;
Ship.ToAddressZipCode = _shippingInfo.ToAddressZipCode;
Ship.ShipmentStatus = _shippingInfo.ShipmentStatus;
Ship.OrderID = _shippingInfo.OrderID;
Ship.CustomerPO = _shippingInfo.CustomerPO;
Ship.ShipToAddress = _shippingInfo.ShipToAddress;
Ship.OurSupplierNo = _shippingInfo.OurSupplierNo;
Ship.CustomerName1 = _shippingInfo.CustomerName1;
Ship.CustomerName2 = _shippingInfo.CustomerName2;
Ship.WebAddress = _shippingInfo.WebAddress;
Ship.FreightTerms = _shippingInfo.FreightTerms;
Ship.Carrier = _shippingInfo.Carrier;
Ship.DeliveryContact = _shippingInfo.DeliveryContact;
Ship.Indexcode = Convert.ToInt16(_shippingInfo.Indexcode);
Ship.Contact = _shippingInfo.Contact;
Ship.PaymentTerms = _shippingInfo.PaymentTerms;
Ship.TotalPackages = Convert.ToInt32(_shippingInfo.TotalPackages);
Ship.Fax = _shippingInfo.Fax;
Ship.VendorName = _shippingInfo.VendorName;
Ship.MDL_0 = _shippingInfo.DeliveryMode;
Ship.XB_RESFLG_0 = Convert.ToByte(_shippingInfo.XB_RESFLG_0);
Ship.CODCHG_0 = _shippingInfo.CODCHG_0;
Ship.INSVAL_0 = Convert.ToDecimal(_shippingInfo.INSVAL_0);
Ship.ADDCODFRT_0 = Convert.ToByte(_shippingInfo.ADDCODFRT_0);
Ship.BILLOPT_0 = _shippingInfo.BILLOPT_0;
Ship.HDLCHG_0 = _shippingInfo.HDLCHG_0;
Ship.DOWNFLG_0 = Convert.ToByte(_shippingInfo.DOWNFLG_0);
Ship.BACCT_0 = _shippingInfo.BACCT_0;
Ship.TPBILL_0 = Convert.ToByte(_shippingInfo.TPBILL_0);
Ship.CUSTBILL_0 = Convert.ToByte(_shippingInfo.CUSTBILL_0);
Ship.CNTFULNAM_0 = _shippingInfo.CNTFULNAM_0;
_lsShippingInfo.Add(Ship);
}
}
}
catch (Exception)
{ }
}
return(_lsShippingInfo);
}
public cstShippingTbl GetShippingByShippingNumber(String ShippingNum)
{
cstShippingTbl Ship = new cstShippingTbl();
try
{
List <GetService.ShippingDTO> _shippingInfo = new List <GetService.ShippingDTO>();
var shippp = Service.Get.ShippingByShippingNum(ShippingNum);
foreach (var item in shippp)
{
_shippingInfo.Add(item);
}
//List<GetService.ShippingDTO> _shippingInfo = Service.Get.ShippingByShippingNum(ShippingNum); //entx3v6.Shippings.SingleOrDefault(i => i.ShippingNum == ShippingNum);
Ship.ShippingID = _shippingInfo[0].ShippingID;
Ship.ShippingNum = _shippingInfo[0].ShippingNum;
Ship.ShippingStartTime = Convert.ToDateTime(_shippingInfo[0].ShippingStartTime);
Ship.ShippingEndTime = Convert.ToDateTime(_shippingInfo[0].ShippingEndTime);;
Ship.DeliveryProvider = _shippingInfo[0].DeliveryProvider;
Ship.DeliveryMode = _shippingInfo[0].DeliveryMode;
Ship.FromAddressLine1 = _shippingInfo[0].FromAddressLine1;
Ship.FromAddressLine2 = _shippingInfo[0].FromAddressLine2;
Ship.FromAddressLine3 = _shippingInfo[0].FromAddressLine3;
Ship.FromAddressCity = _shippingInfo[0].FromAddressCity;
Ship.FromAddressState = _shippingInfo[0].FromAddressState;
Ship.FromAddressCountry = _shippingInfo[0].FromAddressCountry;
Ship.FromAddressZipCode = _shippingInfo[0].FromAddressZipCode;
Ship.ToAddressLine1 = _shippingInfo[0].ToAddressLine1;
Ship.ToAddressLine2 = _shippingInfo[0].ToAddressLine2;
Ship.ToAddressLine3 = _shippingInfo[0].ToAddressLine3;
Ship.ToAddressCity = _shippingInfo[0].ToAddressCity;
Ship.ToAddressState = _shippingInfo[0].ToAddressState;
Ship.ToAddressCountry = _shippingInfo[0].ToAddressCountry;
Ship.ToAddressZipCode = _shippingInfo[0].ToAddressZipCode;
Ship.ShipmentStatus = _shippingInfo[0].ShipmentStatus;
Ship.OrderID = _shippingInfo[0].OrderID;
Ship.CustomerPO = _shippingInfo[0].CustomerPO;
Ship.ShipToAddress = _shippingInfo[0].ShipToAddress;
Ship.OurSupplierNo = _shippingInfo[0].OurSupplierNo;
Ship.CustomerName1 = _shippingInfo[0].CustomerName1;
Ship.CustomerName2 = _shippingInfo[0].CustomerName2;
Ship.WebAddress = _shippingInfo[0].WebAddress;
Ship.FreightTerms = _shippingInfo[0].FreightTerms;
Ship.Carrier = _shippingInfo[0].Carrier;
Ship.DeliveryContact = _shippingInfo[0].DeliveryContact;
Ship.Indexcode = Convert.ToInt16(_shippingInfo[0].Indexcode);
Ship.Contact = _shippingInfo[0].Contact;
Ship.PaymentTerms = _shippingInfo[0].PaymentTerms;
Ship.TotalPackages = Convert.ToInt32(_shippingInfo[0].TotalPackages);
Ship.Fax = _shippingInfo[0].Fax;
Ship.VendorName = _shippingInfo[0].VendorName;
Ship.MDL_0 = _shippingInfo[0].MDL_0;
Ship.XB_RESFLG_0 = Convert.ToByte(_shippingInfo[0].XB_RESFLG_0);
Ship.CODCHG_0 = _shippingInfo[0].CODCHG_0;
Ship.INSVAL_0 = Convert.ToDecimal(_shippingInfo[0].INSVAL_0);
Ship.ADDCODFRT_0 = Convert.ToByte(_shippingInfo[0].ADDCODFRT_0);
Ship.BILLOPT_0 = _shippingInfo[0].BILLOPT_0;
Ship.HDLCHG_0 = _shippingInfo[0].HDLCHG_0;
Ship.DOWNFLG_0 = Convert.ToByte(_shippingInfo[0].DOWNFLG_0);
Ship.BACCT_0 = _shippingInfo[0].BACCT_0;
Ship.TPBILL_0 = Convert.ToByte(_shippingInfo[0].TPBILL_0);
Ship.CUSTBILL_0 = Convert.ToByte(_shippingInfo[0].CUSTBILL_0);
Ship.CNTFULNAM_0 = _shippingInfo[0].CNTFULNAM_0;
Ship.SHIPPINGROWID = _shippingInfo[0].SHIPPINGROWID;
}
catch (Exception)
{ }
return(Ship);
}
public List <cstShippingTbl> GetShipping()
{
List <cstShippingTbl> lsshippingInfo = new List <cstShippingTbl>();
try
{
var ShippingInfo = Service.Get.ShippingAllShipping();//from ls in entx3v6.Shippings select ls;
foreach (var _shippingInfo in ShippingInfo.ToList())
{
DateTime Edate = DateTime.UtcNow;
DateTime.TryParse(_shippingInfo.ShippingEndTime.ToString(), out Edate);
cstShippingTbl Ship = new cstShippingTbl();
Ship.ShippingID = _shippingInfo.ShippingID;
Ship.ShippingNum = _shippingInfo.ShippingNum;
Ship.ShippingStartTime = Convert.ToDateTime(_shippingInfo.ShippingStartTime);
Ship.ShippingEndTime = Edate;
Ship.DeliveryProvider = _shippingInfo.DeliveryProvider;
Ship.DeliveryMode = _shippingInfo.DeliveryMode;
Ship.FromAddressLine1 = _shippingInfo.FromAddressLine1;
Ship.FromAddressLine2 = _shippingInfo.FromAddressLine2;
Ship.FromAddressLine3 = _shippingInfo.FromAddressLine3;
Ship.FromAddressCity = _shippingInfo.FromAddressCity;
Ship.FromAddressState = _shippingInfo.FromAddressState;
Ship.FromAddressCountry = _shippingInfo.FromAddressCountry;
Ship.FromAddressZipCode = _shippingInfo.FromAddressZipCode;
Ship.ToAddressLine1 = _shippingInfo.ToAddressLine1;
Ship.ToAddressLine2 = _shippingInfo.ToAddressLine2;
Ship.ToAddressLine3 = _shippingInfo.ToAddressLine3;
Ship.ToAddressCity = _shippingInfo.ToAddressCity;
Ship.ToAddressState = _shippingInfo.ToAddressState;
Ship.ToAddressCountry = _shippingInfo.ToAddressCountry;
Ship.ToAddressZipCode = _shippingInfo.ToAddressZipCode;
Ship.ShipmentStatus = _shippingInfo.ShipmentStatus;
Ship.OrderID = _shippingInfo.OrderID;
Ship.CustomerPO = _shippingInfo.CustomerPO;
Ship.ShipToAddress = _shippingInfo.ShipToAddress;
Ship.OurSupplierNo = _shippingInfo.OurSupplierNo;
Ship.CustomerName1 = _shippingInfo.CustomerName1;
Ship.CustomerName2 = _shippingInfo.CustomerName2;
Ship.WebAddress = _shippingInfo.WebAddress;
Ship.FreightTerms = _shippingInfo.FreightTerms;
Ship.Carrier = _shippingInfo.Carrier;
Ship.DeliveryContact = _shippingInfo.DeliveryContact;
Ship.Indexcode = Convert.ToInt16(_shippingInfo.Indexcode);
Ship.Contact = _shippingInfo.Contact;
Ship.PaymentTerms = _shippingInfo.PaymentTerms;
Ship.TotalPackages = Convert.ToInt32(_shippingInfo.TotalPackages);
Ship.Fax = _shippingInfo.Fax;
Ship.VendorName = _shippingInfo.VendorName;
Ship.MDL_0 = _shippingInfo.MDL_0;
Ship.XB_RESFLG_0 = Convert.ToByte(_shippingInfo.XB_RESFLG_0);
Ship.CODCHG_0 = _shippingInfo.CODCHG_0;
Ship.INSVAL_0 = Convert.ToDecimal(_shippingInfo.INSVAL_0);
Ship.ADDCODFRT_0 = Convert.ToByte(_shippingInfo.ADDCODFRT_0);
Ship.BILLOPT_0 = _shippingInfo.BILLOPT_0;
Ship.HDLCHG_0 = _shippingInfo.HDLCHG_0;
Ship.DOWNFLG_0 = Convert.ToByte(_shippingInfo.DOWNFLG_0);
Ship.BACCT_0 = _shippingInfo.BACCT_0;
Ship.TPBILL_0 = Convert.ToByte(_shippingInfo.TPBILL_0);
Ship.CUSTBILL_0 = Convert.ToByte(_shippingInfo.CUSTBILL_0);
Ship.CNTFULNAM_0 = _shippingInfo.CNTFULNAM_0;
Ship.SHIPPINGROWID = _shippingInfo.SHIPPINGROWID;
lsshippingInfo.Add(Ship);
}
}
catch (Exception)
{ }
return(lsshippingInfo);
}
private void BoxSlip_Loaded(object sender, RoutedEventArgs e)
{
//Box Information
cstBoxPackage _boxInfo = Global.controller.GetBoxPackageByBoxID(Global.PrintBoxID);
String BoxNumber = _boxInfo.BOXNUM;
EBoxNumber = BoxNumber;
//Package Information
cstPackageTbl packing = Global.controller.GetPackingList(_boxInfo.PackingID, true);
String ShippingNumber = packing.ShippingNum;
//Shipping information
cstShippingTbl shippingTbl = Global.controller.GetShippingTbl(ShippingNumber);
List <cstPackageDetails> _packingDetails = Global.controller.GetPackingDetailTbl(packing.PackingId);
//Sku Quantity.
var SKUQty = from ls in _packingDetails
where ls.BoxNumber == BoxNumber
select new
{
SkuCount = ls.SKUQuantity
};
int SkuQuantity = SKUQty.Sum(i => i.SkuCount);
//User Packing Shippment
String Username = Global.controller.GetSelcetedUserMaster(packing.UserID)[0].UserName.ToString();
//Grid Fill with SKU Name and Product Name
var _packDetail = from ls in _packingDetails
where ls.BoxNumber == BoxNumber
select new
{
SKUNumber = ls.SKUNumber + " -" + ls.ProductName,
SKUQuantity = ls.SKUQuantity
};
//var _packDetail = (from ls in _packingDetails
// where ls.BoxNumber == BoxNumber &&
// ls.SKUNumber == Global.skuNamefor
// orderby ls.SKUQuantity descending //&& Max ls.SKUQuantity
// select new
// {
// SKUNumber = ls.SKUNumber + " -" + ls.ProductName,
// SKUQuantity = ls.SKUQuantity
// }).Take(1).ToList();
//var pack=_packDetail.Max(
Global.skuNamefor = "";
//Box Number(package Box Packing)
int BoxCount = (from pd in _packingDetails
group pd by pd.BoxNumber into Gpd
select Gpd).Count();
//Barcode Liabrary
BarcodeLib.Barcode b = new BarcodeLib.Barcode();
//Barcode for each label
var sBoxNumber = b.Encode(BarcodeLib.TYPE.CODE128, BoxNumber, System.Drawing.Color.Black, System.Drawing.Color.Transparent, 400, 160);
var sBoxTopNumber = b.Encode(BarcodeLib.TYPE.CODE128, BoxNumber, System.Drawing.Color.Black, System.Drawing.Color.Transparent, 380, 50);
var sSOoNumber = b.Encode(BarcodeLib.TYPE.CODE128, shippingTbl.OrderID, System.Drawing.Color.Black, System.Drawing.Color.Transparent, 380, 50);
var sPCKNumber = b.Encode(BarcodeLib.TYPE.CODE128, packing.PCKROWID, System.Drawing.Color.Black, System.Drawing.Color.Transparent, 380, 50);
var sShippingNumber = b.Encode(BarcodeLib.TYPE.CODE128, shippingTbl.ShippingNum, System.Drawing.Color.Black, System.Drawing.Color.Transparent, 380, 50);
//Image Conversion
var bitmapBox = new System.Drawing.Bitmap(sBoxNumber);
var bitmapBoxTop = new System.Drawing.Bitmap(sBoxTopNumber);
var bitmapShipping = new System.Drawing.Bitmap(sShippingNumber);
var bitmapSO = new System.Drawing.Bitmap(sSOoNumber);
var bitmapPCK = new System.Drawing.Bitmap(sPCKNumber);
var bBoxSource = Imaging.CreateBitmapSourceFromHBitmap(bitmapBox.GetHbitmap(), IntPtr.Zero, Int32Rect.Empty, BitmapSizeOptions.FromEmptyOptions());
var bBoxTopSource = Imaging.CreateBitmapSourceFromHBitmap(bitmapBoxTop.GetHbitmap(), IntPtr.Zero, Int32Rect.Empty, BitmapSizeOptions.FromEmptyOptions());
var bShippingSource = Imaging.CreateBitmapSourceFromHBitmap(bitmapShipping.GetHbitmap(), IntPtr.Zero, Int32Rect.Empty, BitmapSizeOptions.FromEmptyOptions());
var bShOSource = Imaging.CreateBitmapSourceFromHBitmap(bitmapSO.GetHbitmap(), IntPtr.Zero, Int32Rect.Empty, BitmapSizeOptions.FromEmptyOptions());
var bSPCKSource = Imaging.CreateBitmapSourceFromHBitmap(bitmapPCK.GetHbitmap(), IntPtr.Zero, Int32Rect.Empty, BitmapSizeOptions.FromEmptyOptions());
bitmapBox.Dispose();
bitmapBoxTop.Dispose();
bitmapShipping.Dispose();
bitmapSO.Dispose();
bitmapPCK.Dispose();
//assign source to images
imgBoxNumber.Source = bBoxSource;
lblBoxNumber.Content = BoxNumber;
imgBoxNumber.Stretch = Stretch.Fill;
imgBOxNumTop.Source = bBoxTopSource;
lblBoxTupNumber.Content = BoxNumber;
imgShipping.Source = bShippingSource;
lblShipment.Content = ShippingNumber;
imgSO.Source = bShOSource;
lblSoNumber.Content = shippingTbl.OrderID;
imgPackNum.Source = bSPCKSource;
lblPckNum.Content = packing.PCKROWID;
//packing Detal Info
tbPackageBox.Text = BoxCount.ToString() + " [SKU QTY: " + SkuQuantity + "]";
tbCarrier.Text = shippingTbl.Carrier + " / " + shippingTbl.MDL_0;
tbPoNum.Text = shippingTbl.CustomerPO.ToString();
tbDealer.Text = shippingTbl.VendorName.ToString();
tbWarehouse.Text = Global.controller.ApplicationLocation();
tbUserName.Text = Username;
dgSKUinfo.ItemsSource = _packDetail.ToList();
tbPackingTime.Text = packing.EndTime.ToString("MMM dd, yyyy hh:mm tt");
lblBDate.Content = DateTime.UtcNow.ToString("dd MMM, yyyy hh:mm tt").TrimStart('0').ToString();
}
