/// <summary>
/// Get BoxPackage Table information sorted by BOXNUM
/// </summary>
/// <param name="BoxNumber">String Box Nuber</param>
/// <returns>BoxPackage Object </returns>
public cstBoxPackage GetSelectedByBoxNumber(String BoxNumber)
{
cstBoxPackage _return = new cstBoxPackage();
try
{
GetService.BoxPackageDTO _boxitem = Service.Get.BoxByBoxNumber(BoxNumber);
cstBoxPackage _box = new cstBoxPackage();
_box.BoxID = Guid.NewGuid();
_box.PackingID = _boxitem.PackingID;
_box.BoxType = _boxitem.BoxType;
_box.BoxWeight = Convert.ToDouble(_boxitem.BoxWeight);
_box.BoxLength = Convert.ToDouble(_boxitem.BoxLength);
_box.BoxHeight = Convert.ToDouble(_boxitem.BoxHeight);
_box.BoxWidth = Convert.ToDouble(_boxitem.BoxWidth);
_box.BoxCreatedTime = Convert.ToDateTime(_boxitem.BoxCreatedTime);
_box.BoxMeasurementTime = Convert.ToDateTime(_boxitem.BoxMeasurementTime);
_box.ROWID = _boxitem.ROWID;
_box.BOXNUM = _boxitem.BOXNUM;
_return = _box;
}
catch (Exception)
{ }
return(_return);
}
//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;
}
}
/// <summary>
/// Get all BoxPackage Table Information
/// </summary>
/// <returns>List<cstBoxPackage></returns>
public List <cstBoxPackage> GetAll()
{
List <cstBoxPackage> lsreturn = new List <cstBoxPackage>();
try
{
var allBoxInfo = from b in Service.Get.AllBox()
select b;
foreach (var _boxitem in allBoxInfo)
{
cstBoxPackage _box = new cstBoxPackage();
_box.BoxID = Guid.NewGuid();
_box.PackingID = _boxitem.PackingID;
_box.BoxType = _boxitem.BoxType;
_box.BoxWeight = Convert.ToDouble(_boxitem.BoxWeight);
_box.BoxLength = Convert.ToDouble(_boxitem.BoxLength);
_box.BoxHeight = Convert.ToDouble(_boxitem.BoxHeight);
_box.BoxWidth = Convert.ToDouble(_boxitem.BoxWidth);
_box.BoxCreatedTime = Convert.ToDateTime(_boxitem.BoxCreatedTime);
_box.BoxMeasurementTime = Convert.ToDateTime(_boxitem.BoxMeasurementTime);
_box.ROWID = _boxitem.ROWID;
_box.BOXNUM = _boxitem.BOXNUM;
lsreturn.Add(_box);
}
}
catch (Exception)
{}
return(lsreturn);
}
/// <summary>
/// Selected single Row by filter Box id
/// </summary>
/// <param name="BoxID">Guid Box ID</param>
/// <returns>cstBoxPackage Object</returns>
public cstBoxPackage GetSelectedByBoxID(Guid BoxID)
{
cstBoxPackage _return = new cstBoxPackage();
try
{
BoxPackage _boxitem = entx3v6.BoxPackages.SingleOrDefault(i => i.BoxID == BoxID);
cstBoxPackage _box = new cstBoxPackage();
_box.BoxID = Guid.NewGuid();
_box.PackingID = _boxitem.PackingID;
_box.BoxType = _boxitem.BoxType;
_box.BoxWeight = Convert.ToDouble(_boxitem.BoxWeight);
_box.BoxLength = Convert.ToDouble(_boxitem.BoxLength);
_box.BoxHeight = Convert.ToDouble(_boxitem.BoxHeight);
_box.BoxWidth = Convert.ToDouble(_boxitem.BoxWidth);
_box.BoxCreatedTime = Convert.ToDateTime(_boxitem.BoxCreatedTime);
_box.BoxMeasurementTime = Convert.ToDateTime(_boxitem.BoxMeasurementTime);
_box.ROWID = _boxitem.ROWID;
_box.BOXNUM = _boxitem.BOXNUM;
_return = _box;
}
catch (Exception)
{ }
return(_return);
}
/// <summary>
/// list of information by Packing ID
/// </summary>
/// <param name="PackingID">Guid Packing ID</param>
/// <returns>List<cstBoxPackage> </returns>
public List <cstBoxPackage> GetSelectedByPackingID(Guid PackingID)
{
List <cstBoxPackage> lsreturn = new List <cstBoxPackage>();
try
{
var allBoxInfo = from b in entx3v6.BoxPackages
where b.PackingID == PackingID
select b;
foreach (var _boxitem in allBoxInfo)
{
cstBoxPackage _box = new cstBoxPackage();
_box.BoxID = _boxitem.BoxID;
_box.PackingID = _boxitem.PackingID;
_box.BoxType = _boxitem.BoxType;
_box.BoxWeight = Convert.ToDouble(_boxitem.BoxWeight);
_box.BoxLength = Convert.ToDouble(_boxitem.BoxLength);
_box.BoxHeight = Convert.ToDouble(_boxitem.BoxHeight);
_box.BoxWidth = Convert.ToDouble(_boxitem.BoxWidth);
_box.BoxCreatedTime = Convert.ToDateTime(_boxitem.BoxCreatedTime);
_box.BoxMeasurementTime = Convert.ToDateTime(_boxitem.BoxMeasurementTime);
_box.ROWID = _boxitem.ROWID;
_box.BOXNUM = _boxitem.BOXNUM;
lsreturn.Add(_box);
}
}
catch (Exception)
{ }
return(lsreturn);
}
/// <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);
}
}
private void Window_Loaded_1(object sender, RoutedEventArgs e)
{
cstBoxPackage _boxInfo = Global.controller.GetBoxPackageByBoxID(Global.PrintBoxID);
String BoxNumber = _boxInfo.BOXNUM;
EBoxNumber = BoxNumber;
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 bitmapBox = new System.Drawing.Bitmap(sBoxNumber);
var bBoxSource = Imaging.CreateBitmapSourceFromHBitmap(bitmapBox.GetHbitmap(), IntPtr.Zero, Int32Rect.Empty, BitmapSizeOptions.FromEmptyOptions());
bitmapBox.Dispose();
imgBoxNumber.Source = bBoxSource;
lblBoxNumber.Content = BoxNumber;
imgBoxNumber.Stretch = Stretch.Fill;
}
/// <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();
}