public cstPackageTbl ExecutePacking(Guid PackingID) { cstPackageTbl _PC = new cstPackageTbl(); try { local_x3v6Entities _Localx3v6 = new local_x3v6Entities(); Package _Packing = _Localx3v6.Packages.SingleOrDefault(i => i.PackingId == PackingID); _PC.PackingId = _Packing.PackingId; _PC.ShippingID = (Guid)_Packing.ShippingID; _PC.ShippingNum = _Packing.ShippingNum; _PC.UserID = _Packing.UserId; _PC.StartTime = Convert.ToDateTime(_Packing.StartTime); _PC.EndTime = Convert.ToDateTime(_Packing.EndTime); _PC.StationID = (Guid)_Packing.StationID; _PC.PackingStatus = Convert.ToInt32(_Packing.PackingStatus); _PC.ShipmentLocation = _Packing.ShipmentLocation; _PC.MangerOverride = Convert.ToInt32(_Packing.ManagerOverride); _PC.PCKROWID = _Packing.PCKROWID; } catch (Exception Ex) { Error_Loger.elAction.save("GetPackingListSelcted.Execute()", Ex.Message.ToString()); } return(_PC); }
public List <cstPackageTbl> ExecuteNoLocation(String ShippingNum) { List <cstPackageTbl> _lsPacking = new List <cstPackageTbl>(); try { local_x3v6Entities _Localx3v6 = new local_x3v6Entities(); // Package _Packing = _Localx3v6.Packages.SingleOrDefault(i => i.ShippingNum == ShippingNum); var _packinglist = from _Pack in _Localx3v6.Packages where _Pack.ShippingNum == ShippingNum select _Pack; foreach (var _Packing in _packinglist) { cstPackageTbl _PC = new cstPackageTbl(); _PC.PackingId = _Packing.PackingId; _PC.ShippingID = (Guid)_Packing.ShippingID; _PC.ShippingNum = _Packing.ShippingNum; _PC.UserID = _Packing.UserId; _PC.StartTime = Convert.ToDateTime(_Packing.StartTime); _PC.EndTime = Convert.ToDateTime(_Packing.EndTime); _PC.StationID = (Guid)_Packing.StationID; _PC.PackingStatus = Convert.ToInt32(_Packing.PackingStatus); _PC.ShipmentLocation = _Packing.ShipmentLocation; _PC.MangerOverride = Convert.ToInt32(_Packing.ManagerOverride); _PC.PCKROWID = _Packing.PCKROWID; _lsPacking.Add(_PC); } } catch (Exception Ex) { Error_Loger.elAction.save("GetPackingListSelcted.ExecuteNoLocation()", Ex.Message.ToString()); } return(_lsPacking); }
/// <summary> /// All packing table /// </summary> /// <param name="UserID">long UserID</param> /// <param name="Date">DateTime Date</param> /// <returns>list < cstPackingtbl></returns> public List <cstPackageTbl> Execute(Guid UserID, DateTime Date) { List <cstPackageTbl> _lsreturn = new List <cstPackageTbl>(); try { var listPacking = from packingtbl in entx3v6.Packages where packingtbl.UserId == UserID && EntityFunctions.TruncateTime(packingtbl.EndTime.Value) == EntityFunctions.TruncateTime(Date.Date) select packingtbl; foreach (var listitem in listPacking) { cstPackageTbl _pack = new cstPackageTbl(); _pack.PackingId = listitem.PackingId; _pack.ShippingID = (Guid)listitem.ShippingID; _pack.ShippingNum = _pack.ShippingNum; _pack.PackingStatus = Convert.ToInt32(listitem.PackingStatus); _pack.UserID = listitem.UserId; _pack.ShipmentLocation = listitem.ShipmentLocation; _pack.StartTime = Convert.ToDateTime(listitem.StartTime); _pack.EndTime = Convert.ToDateTime(listitem.EndTime); _pack.StationID = (Guid)listitem.StationID; _pack.MangerOverride = Convert.ToInt32(listitem.ManagerOverride); _pack.PCKROWID = listitem.PCKROWID; _lsreturn.Add(_pack); } } catch (Exception Ex) { Error_Loger.elAction.save("GetPackingListSelcted.Execute(3)", Ex.Message.ToString()); } return(_lsreturn); }
/// <summary> /// Packing Tbl Packing Id wiht manger Override =0 /// </summary> /// <param name="ShippingNum"></param> /// <param name="Location"></param> /// <returns></returns> public List <cstPackageTbl> Execute(String ShippingNum, String Location) { List <cstPackageTbl> _lsPacking = new List <cstPackageTbl>(); try { var _Packing1 = from v in entx3v6.Packages where v.ShippingNum == ShippingNum && v.ShipmentLocation == Location select v; foreach (var _Packing in _Packing1) { cstPackageTbl _PC = new cstPackageTbl(); _PC.PackingId = _Packing.PackingId; _PC.ShippingID = (Guid)_Packing.ShippingID; _PC.ShippingNum = _Packing.ShippingNum; _PC.UserID = _Packing.UserId; _PC.StartTime = Convert.ToDateTime(_Packing.StartTime); _PC.EndTime = Convert.ToDateTime(_Packing.EndTime); _PC.StationID = (Guid)_Packing.StationID; _PC.PackingStatus = Convert.ToInt32(_Packing.PackingStatus); _PC.ShipmentLocation = _Packing.ShipmentLocation; _PC.MangerOverride = Convert.ToInt32(_Packing.ManagerOverride); _PC.PCKROWID = _Packing.PCKROWID; _lsPacking.Add(_PC); } } catch (Exception Ex) { Error_Loger.elAction.save("GetPackingListSelcted.Execute()", Ex.Message.ToString()); } return(_lsPacking); }
/// <summary> /// All packing table /// </summary> /// <returns>list < cstPackingtbl></returns> public List <cstPackageTbl> Execute() { List <cstPackageTbl> _lsreturn = new List <cstPackageTbl>(); try { var listPacking = Service.Get.PackageAllPackge(); //from packingtbl in entx3v6.Packages select packingtbl; foreach (var listitem in listPacking) { cstPackageTbl _pack = new cstPackageTbl(); _pack.PackingId = listitem.PackingId; _pack.ShippingID = (Guid)listitem.ShippingID; _pack.ShippingNum = listitem.ShippingNum; _pack.PackingStatus = Convert.ToInt32(listitem.PackingStatus); _pack.UserID = listitem.UserID; _pack.ShipmentLocation = listitem.ShipmentLocation; _pack.StartTime = Convert.ToDateTime(listitem.StartTime); _pack.EndTime = Convert.ToDateTime(listitem.EndTime); _pack.StationID = (Guid)listitem.StationID; _pack.MangerOverride = Convert.ToInt32(listitem.MangerOverride); _pack.PCKROWID = listitem.PCKROWID; _lsreturn.Add(_pack); } } catch (Exception Ex) { Error_Loger.elAction.save("GetPackingListSelcted.Execute(1)", Ex.Message.ToString()); } return(_lsreturn); }
//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; } }
public cstPackageTbl ExecutePacking(Guid PackingID) { cstPackageTbl _PC = new cstPackageTbl(); try { // local_x3v6Entities _Localx3v6 = new local_x3v6Entities(); var _Packing = Service.Get.PackageByPackageID(PackingID); //_Localx3v6.Packages.SingleOrDefault(i => i.PackingId == PackingID); foreach (var item in _Packing) { _PC = new cstPackageTbl(); _PC.PackingId = item.PackingId; _PC.ShippingID = (Guid)item.ShippingID; _PC.ShippingNum = item.ShippingNum; _PC.UserID = item.UserID; _PC.StartTime = Convert.ToDateTime(item.StartTime); _PC.EndTime = Convert.ToDateTime(item.EndTime); _PC.StationID = (Guid)item.StationID; _PC.PackingStatus = Convert.ToInt32(item.PackingStatus); _PC.ShipmentLocation = item.ShipmentLocation; _PC.MangerOverride = Convert.ToInt32(item.MangerOverride); _PC.PCKROWID = item.PCKROWID; } } catch (Exception Ex) { Error_Loger.elAction.save("GetPackingListSelcted.Execute()", Ex.Message.ToString()); } return(_PC); }
public List <cstPackageTbl> Execute(String ShippingNum, String Location, int managerOvrride) { List <cstPackageTbl> _lsPacking = new List <cstPackageTbl>(); try { // local_x3v6Entities _Localx3v6 = new local_x3v6Entities(); var _Packing = Service.Get.PackageByShippingNumAndLocation(ShippingNum, Location).SingleOrDefault(r => r.MangerOverride == managerOvrride);// _Localx3v6.Packages.SingleOrDefault(i => i.ShippingNum == ShippingNum && i.ShipmentLocation == Location && i.ManagerOverride == managerOvrride); cstPackageTbl _PC = new cstPackageTbl(); _PC.PackingId = _Packing.PackingId; _PC.ShippingID = (Guid)_Packing.ShippingID; _PC.ShippingNum = _Packing.ShippingNum; _PC.UserID = _Packing.UserID; _PC.StartTime = Convert.ToDateTime(_Packing.StartTime); _PC.EndTime = Convert.ToDateTime(_Packing.EndTime); _PC.StationID = (Guid)_Packing.StationID; _PC.PackingStatus = Convert.ToInt32(_Packing.PackingStatus); _PC.ShipmentLocation = _Packing.ShipmentLocation; _PC.MangerOverride = Convert.ToInt32(_Packing.MangerOverride); _PC.PCKROWID = _Packing.PCKROWID; _lsPacking.Add(_PC); } catch (Exception Ex) { Error_Loger.elAction.save("GetPackingListSelcted.Execute()", Ex.Message.ToString()); } return(_lsPacking); }
private void ShipmentLock(int OverrideMode) { try { //save Shipping Infromtaion. SaveShippingInformation(Global.ShippingNumber); List <cstPackageTbl> lsPacking = new List <cstPackageTbl>(); cstPackageTbl _packingCustom = new cstPackageTbl(); _packingCustom.ShippingNum = Global.ShippingNumber; _packingCustom.UserID = Global.ManagerID; _packingCustom.StartTime = DateTime.UtcNow; _packingCustom.EndTime = DateTime.UtcNow; _packingCustom.ShippingID = Global.controller.GetShippingTbl(Global.ShippingNumber).ShippingID; _packingCustom.StationID = Global.controller.GetStationMaster().SingleOrDefault(i => i.StationName == Global.StationName).StationID; _packingCustom.ShipmentLocation = Global.controller.ApplicationLocation(); //Status: 1 - Under Packing Process. //Status: 0 - Packing Complete _packingCustom.PackingStatus = 1; _packingCustom.MangerOverride = OverrideMode; lsPacking.Add(_packingCustom); Global.PackingID = Global.controller.SetPackingTable(lsPacking); } catch (Exception Ex) { ErrorLoger.save("MainWindow.ShipmentLock()", Ex.ToString()); } }
/// <summary> /// Shipment Lock is add value to the package information to the package table. with its override mode. /// </summary> /// <param name="OverrideMode">Mode of override if 1: Manager Override. 2: Self override. 0: No override.</param> /// <returns>Boolean tru or false.</returns> private Boolean _shipmentLock(int OverrideMode) { Boolean _return = false; this.Dispatcher.Invoke(new Action(() => { try { //save Shipping Infromtaion. _return = _saveShippingInformation(txtShipmentId.Text); List <cstPackageTbl> lsPacking = new List <cstPackageTbl>(); cstPackageTbl _packingCustom = new cstPackageTbl(); _packingCustom.ShippingNum = txtShipmentId.Text; _packingCustom.UserID = Global.LoggedUserModel.UserInfo.UserID; _packingCustom.StartTime = DateTime.UtcNow; _packingCustom.EndTime = DateTime.UtcNow; _packingCustom.StationID = Global.controller.GetStationMasterByName(Global.StationName).StationID; _packingCustom.ShippingID = Global.controller.GetShippingTbl(txtShipmentId.Text).ShippingID; _packingCustom.ShipmentLocation = Global.controller.ApplicationLocation(); //Status: 1 - Under Packing Process. //Status: 0 - Packing Complete _packingCustom.PackingStatus = 1; //Status: 0 - Not Manger override packing //Status: 1 - Manger Override packing //Status: 2 - Same User Repacking _packingCustom.MangerOverride = OverrideMode; lsPacking.Add(_packingCustom); if (OverrideMode == 2) { //No save No update just pass the old Packing Id to next operations. Global.PackingID = Global.SameUserpackingID; } else { Global.PackingID = Global.controller.SetPackingTable(lsPacking); } } catch (Exception Ex) { //Log the Error to the Error Log table ErrorLoger.save("wndShipmentScanPage - _shipmentLock", "[" + DateTime.UtcNow.ToString() + "]" + Ex.ToString(), DateTime.UtcNow, Global.LoggedUserId); } })); return(_return); }
/// <summary> /// Print packing slip of barcode that has packing number and its respective shipping number; /// </summary> public void PrintPckingSlip(Guid BoxID) { try { cstBoxPackage _boxInfo = Global.controller.GetBoxPackageByBoxID(BoxID); BoxNumber = _boxInfo.BOXNUM; cstPackageTbl packing = Global.controller.GetPackingTbl().SingleOrDefault(i => i.PackingId == _boxInfo.PackingID); ShippingNumber = packing.ShippingNum; BarcodeLib.Barcode b = new BarcodeLib.Barcode(); PackingNumber = packing.PCKROWID; try { imgPackingNumber = b.Encode(BarcodeLib.TYPE.CODE128, packing.PCKROWID, System.Drawing.Color.Black, System.Drawing.Color.White, 300, 60); imgShippingNumber = b.Encode(BarcodeLib.TYPE.CODE128, ShippingNumber, System.Drawing.Color.Black, System.Drawing.Color.White, 300, 60); imgBoxNumber = b.Encode(BarcodeLib.TYPE.CODE128, BoxNumber, System.Drawing.Color.Black, System.Drawing.Color.White, 300, 60); } catch (Exception Ex) { //Log the Error to the Error Log table ErrorLoger.save("wndShipmentDetailPage - PrintPckingSlip_sub1", "[" + DateTime.UtcNow.ToString() + "]" + Ex.ToString(), DateTime.UtcNow, Global.LoggedUserId); } PrintDocument pd = new PrintDocument(); pd.DefaultPageSettings.Margins = new Margins(0, 0, 0, 0); pd.OriginAtMargins = false; pd.DefaultPageSettings.Landscape = true; //Business card paper size pd.DefaultPageSettings.PaperSize = new PaperSize("BC", 330, 220); pd.PrintPage += new PrintPageEventHandler(pd_PrintPage); pd.Print(); } catch (Exception Ex) { //Log the Error to the Error Log table ErrorLoger.save("wndShipmentDetailPage - PrintPckingSlip", "[" + DateTime.UtcNow.ToString() + "]" + Ex.ToString(), DateTime.UtcNow, Global.LoggedUserId); } }
/// <summary> /// Export all data to excel file. /// </summary> /// <param name="ds">Dataset table to be export</param> /// <param name="filename"> File name of excel.</param> public static void Excel(List <String> lsPCKROWID, string filename) { List <string> Boxnumbers = new List <string>(); foreach (var item in lsPCKROWID) { List <cstBoxPackage> lsBoxInfo = Obj.call.GetBoxPackageByPackingID(Obj.call.GetPackageIDFromROWID(item)); foreach (cstBoxPackage boxitem in lsBoxInfo) { Boxnumbers.Add(boxitem.BOXNUM); } } //Find Box information from the Box Numbers List <BoxManifist> _lsBoxManifist = new List <BoxManifist>(); foreach (string item in Boxnumbers) { //Box Information cstBoxPackage _boxInfo = Obj.call.GetBoxPackageByBoxNumber(item); //Package Information cstPackageTbl packing = Obj.call.GetPackingList(_boxInfo.PackingID, true); BoxManifist manifist = new BoxManifist(); manifist.BoxNumber = _boxInfo.BOXNUM; manifist.PackingNumber = packing.PCKROWID; manifist.ShippingNumber = packing.ShippingNum; try { manifist.TrackingNumber = Obj.call.GetTrackingTbl(item).FirstOrDefault().TrackingNum.ToString(); } catch (Exception) { manifist.TrackingNumber = "N/A"; } manifist.Location = packing.ShipmentLocation; manifist.Weight = _boxInfo.BoxWeight.ToString(); manifist.Width = _boxInfo.BoxWidth.ToString(); manifist.Lenght = _boxInfo.BoxHeight.ToString(); manifist.Height = _boxInfo.BoxHeight.ToString(); manifist.UserName = Obj.call.GetSelcetedUserMaster(packing.UserID).FirstOrDefault().UserFullName; //Convet UTC time to EST Time. TimeZoneInfo EstTime = TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time"); manifist.PackedDate = TimeZoneInfo.ConvertTimeFromUtc(packing.EndTime, EstTime).ToString("MMM dd, yyyy hh:mm:ss tt"); _lsBoxManifist.Add(manifist); } HttpResponse response = HttpContext.Current.Response; // first let's clean up the response.object response.Clear(); response.Charset = ""; // set the response mime type for excel response.ContentType = "application/vnd.MS-Excel"; response.AddHeader("Content-Disposition", "attachment;filename=\"" + filename + ".xls\""); // create a string writer using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter htw = new HtmlTextWriter(sw)) { // instantiate a datagrid DataGrid dg = new DataGrid(); dg.DataSource = _lsBoxManifist; dg.DataBind(); dg.RenderControl(htw); response.Write(sw.ToString()); response.End(); } } }
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(); }