protected void rptSizeQtyView_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
RepeaterItem item = e.Item;
if (item.ItemIndex > -1 && item.DataItem is PackingListSizeQtyBO)
{
Literal litHeading = (Literal)item.FindControl("litHeading");
Label lblSize = (Label)item.FindControl("lblSize");
Label lblQty = (Label)item.FindControl("lblQty");
PackingListSizeQtyBO objPackingListQty = (PackingListSizeQtyBO)item.DataItem;
litHeading.Text = objPackingListQty.objSize.SizeName;
lblSize.Text = objPackingListQty.Size.ToString();
lblQty.Text = objPackingListQty.Qty.ToString();
}
}
protected void dgPackingList_ItemDataBound(object sender, DataGridItemEventArgs e)
{
DataGridItem item = e.Item;
if (item.ItemIndex > -1 && item.DataItem is PackingListViewBO)
{
PackingListViewBO objPacking = (PackingListViewBO)item.DataItem;
Literal lblID = (Literal)item.FindControl("lblID");
lblID.Text = objPacking.PackingList.ToString();
Literal lblParentID = (Literal)item.FindControl("lblParentID");
Literal lblDistributor = (Literal)item.FindControl("lblDistributor");
lblDistributor.Text = objPacking.Distributor;
Literal lblClient = (Literal)item.FindControl("lblClient");
lblClient.Text = objPacking.Client;
Literal lblVLName = (Literal)item.FindControl("lblVLName");
lblVLName.Text = objPacking.VLName;
Literal lblDescription = (Literal)item.FindControl("lblDescription");
lblDescription.Text = objPacking.Pattern;
Literal lblPoNo = (Literal)item.FindControl("lblPoNo");
lblPoNo.Text = objPacking.OrderNumber.ToString();
LinkButton lnkSplitRow = (LinkButton)item.FindControl("lnkSplitRow");
Repeater rptSizeQtyView = (Repeater)item.FindControl("rptSizeQtyView");
PackingListSizeQtyBO objPackSizeQty = new PackingListSizeQtyBO();
objPackSizeQty.PackingList = objPacking.PackingList.Value;
List <PackingListSizeQtyBO> lstPackListQtys = objPackSizeQty.SearchObjects().Where(m => m.Qty > 0).ToList();
rptSizeQtyView.DataSource = lstPackListQtys;
rptSizeQtyView.DataBind();
int total = objPacking.PackingTotal.Value; // lstPackListQtys.Select(m => m.Qty).Sum();
Literal lblTotal = (Literal)item.FindControl("lblTotal");
lblTotal.Text = total.ToString();
}
}
private void GenerateLabels(List <PackingList> lstPackingList)
{
string imageLocation = IndicoConfiguration.AppConfiguration.PathToDataFolder + "\\Barcode\\" + Guid.NewGuid() + "\\";
Directory.CreateDirectory(imageLocation);
string tempPath = imageLocation + "temp.jpg";
foreach (PackingList obj in lstPackingList)
{
Bitmap lblBM = new Bitmap(400, 275);
using (Graphics gfx = Graphics.FromImage(lblBM))
using (SolidBrush brush = new SolidBrush(Color.White))
{
gfx.FillRectangle(brush, 0, 0, 400, 275);
}
lblBM.Save(tempPath);
string labelText = string.Empty;
string qty = string.Empty;
List <KeyValuePair <int, string> > listOrderDetails = new List <KeyValuePair <int, string> >();
foreach (PackingListViewBO objPackingList in obj.ListPackingList)
{
qty = string.Empty;
listOrderDetails.Add(new KeyValuePair <int, string>(objPackingList.PackingList.Value, objPackingList.OrderNumber.Value.ToString()));
listOrderDetails.Add(new KeyValuePair <int, string>(objPackingList.PackingList.Value, objPackingList.Client));
listOrderDetails.Add(new KeyValuePair <int, string>(objPackingList.PackingList.Value, objPackingList.VLName));
PackingListSizeQtyBO objSizeQty = new PackingListSizeQtyBO();
objSizeQty.PackingList = objPackingList.PackingList.Value;
foreach (PackingListSizeQtyBO objPackSize in objSizeQty.SearchObjects())
{
string delimeter = string.IsNullOrEmpty(qty) ? string.Empty : ", ";
qty = qty + delimeter + objPackSize.objSize.SizeName + "/" + objPackSize.Qty;
}
listOrderDetails.Add(new KeyValuePair <int, string>(objPackingList.PackingList.Value, qty));
}
labelText = obj.CartonNo + "-" + obj.ListPackingList[0].WeeklyProductionCapacity.ToString();
GenerateBarcode.GenerateCartonLabel(lblBM, obj.CartonNo.ToString(), listOrderDetails, labelText, imageLocation);
lblBM.Dispose();
File.Delete(tempPath);
}
// string excelFileName = "CartonLabels" + ".xlsx";
// CreateExcelDocument excell_app = new CreateExcelDocument(imageLocation, excelFileName, 400, 255, 255, true); //(imageLocation, excelFileName, 400, 275, 275, true); NNM
string pdfpath = GenerateOdsPdf.PrintCartonBarcode(imageLocation);
foreach (string imagePath in Directory.GetFiles(imageLocation, "*.jpg"))
{
File.Delete(imagePath);
}
//this.DownloadExcelFile(imageLocation + excelFileName);//NNM
if (File.Exists(pdfpath))
{
this.DownloadPDFFile(pdfpath);
}
}
private void ChangeOrderDetails(int orderdetail, int invoiceorder)
{
try
{
if (orderdetail > 0)
{
InvoiceOrderBO objInvoiceOrder = new InvoiceOrderBO(this.ObjContext);
objInvoiceOrder.ID = invoiceorder;
objInvoiceOrder.GetObject();
DateTime nextmonday = objInvoiceOrder.objOrderDetail.SheduledDate.AddDays(7 - objInvoiceOrder.objOrderDetail.SheduledDate.DayOfWeek == DayOfWeek.Monday ? 7 : (int)objInvoiceOrder.objOrderDetail.SheduledDate.DayOfWeek);
using (TransactionScope ts = new TransactionScope())
{
PackingListBO objPList = new PackingListBO();
objPList.OrderDetail = orderdetail;
List <PackingListBO> lstPackingLists = objPList.SearchObjects();
foreach (PackingListBO objpl in lstPackingLists)
{
PackingListSizeQtyBO objPlsq = new PackingListSizeQtyBO();
objPlsq.PackingList = objpl.ID;
List <PackingListSizeQtyBO> lstPackingListSizeQty = objPlsq.SearchObjects();
// delete the PackingListSizeQtyBO details
foreach (PackingListSizeQtyBO objplsqi in lstPackingListSizeQty)
{
PackingListSizeQtyBO objPackingListSizeQtyItem = new PackingListSizeQtyBO(this.ObjContext);
objPackingListSizeQtyItem.ID = objplsqi.ID;
objPackingListSizeQtyItem.GetObject();
objPackingListSizeQtyItem.Delete();
}
//this.ObjContext.SaveChanges();
PackingListCartonItemBO objPLCI = new PackingListCartonItemBO();
objPLCI.PackingList = objpl.ID;
List <PackingListCartonItemBO> lstPackingListCartonItems = objPLCI.SearchObjects();
// delete the PackingListCartonItemBO details
foreach (PackingListCartonItemBO objplci in lstPackingListCartonItems)
{
PackingListCartonItemBO objPackingListCartonItem = new PackingListCartonItemBO(this.ObjContext);
objPackingListCartonItem.ID = objplci.ID;
objPackingListCartonItem.GetObject();
objPackingListCartonItem.Delete();
}
//this.ObjContext.SaveChanges();
// delete the PackingListBO details
PackingListBO objPackingList = new PackingListBO(this.ObjContext);
objPackingList.ID = objpl.ID;
objPackingList.GetObject();
objPackingList.Delete();
}
//Creating new packing list record for next week
List <WeeklyProductionCapacityBO> lstwpc = (new WeeklyProductionCapacityBO()).SearchObjects().Where(o => o.WeekendDate >= nextmonday && o.WeekendDate <= nextmonday.AddDays(7)).ToList();
PackingListBO objp = new PackingListBO();
objp.WeeklyProductionCapacity = lstwpc[0].ID;
List <PackingListBO> lst = objp.SearchObjects();
if (lst.Count > 0)
{
PackingListBO objNewPl = new PackingListBO(this.ObjContext);
objNewPl.Carton = 1;
objNewPl.CartonNo = 0;
objNewPl.CreatedDate = objNewPl.ModifiedDate = DateTime.Now;
objNewPl.Creator = objNewPl.Modifier = this.LoggedUser.ID;
objNewPl.OrderDetail = orderdetail;
objNewPl.WeeklyProductionCapacity = lstwpc[0].ID;
objNewPl.PackingQty = 0;
this.ObjContext.SaveChanges();
int Newplid = objNewPl.ID;
OrderDetailQtyBO objOrderDetailqty = new OrderDetailQtyBO();
objOrderDetailqty.OrderDetail = orderdetail;
List <OrderDetailQtyBO> lstOrderDetailsQty = objOrderDetailqty.SearchObjects();
foreach (OrderDetailQtyBO objOdq in lstOrderDetailsQty)
{
if (objOdq.Qty > 0)
{
PackingListSizeQtyBO objPackingListSizeQty = new PackingListSizeQtyBO(this.ObjContext);
objPackingListSizeQty.PackingList = Newplid;
objPackingListSizeQty.Size = objOdq.Size;
}
}
}
//this.ObjContext.SaveChanges();
//change the shipment date, scheduled date
OrderDetailBO objOrderDetail = new OrderDetailBO(this.ObjContext);
objOrderDetail.ID = orderdetail;
objOrderDetail.GetObject();
objOrderDetail.SheduledDate = nextmonday;
objOrderDetail.ShipmentDate = nextmonday;
this.ObjContext.SaveChanges();
ts.Complete();
}
}
}
catch (Exception ex)
{
IndicoLogging.log.Error("Error occured while deleting or adding packing list details and changing the shipment date and scheduled date from the AddEditInvoce.aspx", ex);
}
}
