private void PopulateCartonData() { List <PackingListBO> lstPackingLists = GetPolyBagData(); if (lstPackingLists.Any()) { OrderDetailBO objOrderDetail = new OrderDetailBO(); objOrderDetail.ID = lstPackingLists[0].OrderDetail; objOrderDetail.GetObject(); /* OrderBO objOrder = new OrderBO(); * objOrder.ID = objOrderDetail.Order; * objOrder.GetObject(); * * DistributorClientAddressBO objAddress = new DistributorClientAddressBO(); * objAddress.ID = (int)objOrder.DespatchToExistingClient; * objAddress.GetObject();*/ InvoiceOrderBO objInvoiceOrder = new InvoiceOrderBO(); objInvoiceOrder.OrderDetail = objOrderDetail.ID; //string state = (string.IsNullOrEmpty(objAddress.State)) ? string.Empty : objAddress.State; this.litAddress.Text = objInvoiceOrder.SearchObjects().Select(o => o.objInvoice.InvoiceNo).SingleOrDefault(); this.dvScanCarton.Attributes.Add("style", "display:block;"); this.dvScanPolyBag.Attributes.Add("style", "display:none;"); this.dvDataContent.Attributes.Add("style", "display:block;"); this.h3Carton.Attributes.Add("class", "text-info"); rptCarton.DataSource = lstPackingLists; rptCarton.DataBind(); if ((isCompleted == true) && (noRecords == lstPackingLists.Count)) { // when carton completed this.h3PolyBags.Attributes.Add("class", "text-success"); this.litPolyBags.Text = "Filling Carton is completed. There are <span class=\"badge badge-success\">" + noPolybags.ToString() + "</span> polybags in the Carton."; } } else { this.dvScanCarton.Attributes.Add("style", "display:none;"); this.dvScanPolyBag.Attributes.Add("style", "display:block;"); this.h3PolyBags.Attributes.Add("class", "text-error"); this.litPolyBags.Text = "Scanned polybag details can not find in the System."; } }
protected void btnDelete_Click(object sender, EventArgs e) { //NNM int id = int.Parse(this.hdnSelectedID.Value); int indexid = int.Parse(this.hdnIndexID.Value); int orderdetail = int.Parse(this.hdnOrderDetail.Value); try { if (id > 0) { using (TransactionScope ts = new TransactionScope()) { InvoiceOrderBO objInvoiceOrder = new InvoiceOrderBO(this.ObjContext); objInvoiceOrder.ID = id; objInvoiceOrder.GetObject(); objInvoiceOrder.Delete(); this.ObjContext.SaveChanges(); ts.Complete(); } this.populateInvoiceOrders(this.QueryID, this.DistributorClientAddress, false, this.ShipmentModeID, false); } else { if (indexid > -1) { List <ReturnInvoiceOrderDetailViewBO> lstInvoiceOrderDetailView = (List <ReturnInvoiceOrderDetailViewBO>)Session["InvoiceOrderDetails"]; lstInvoiceOrderDetailView.RemoveAt(indexid); Session["InvoiceOrderDetails"] = lstInvoiceOrderDetailView; this.RadInvoice.DataSource = lstInvoiceOrderDetailView; this.RadInvoice.DataBind(); } } // changing the orderdetail shipment date and scheduled date and delete the packing list details //this.ChangeOrderDetails(orderdetail, id); } catch (Exception ex) { IndicoLogging.log.Error("Error occured while deleting or removing order details from the AddEditInvoicePage.aspx", ex); } }
protected void btnDelete_Click(object sender, EventArgs e) { int invoiceID = int.Parse(hdnSelectedID.Value.Trim()); if (invoiceID > 0) { try { using (TransactionScope ts = new TransactionScope()) { InvoiceBO objInvoice = new InvoiceBO(this.ObjContext); objInvoice.ID = invoiceID; objInvoice.GetObject(); List <InvoiceOrderBO> lstInvoiceOrder = (new InvoiceOrderBO()).GetAllObject().Where(o => o.Invoice == objInvoice.ID).ToList(); foreach (InvoiceOrderBO objDelInvoiceOrder in lstInvoiceOrder) { InvoiceOrderBO objInvoiceOrder = new InvoiceOrderBO(this.ObjContext); objInvoiceOrder.ID = objDelInvoiceOrder.ID; objInvoiceOrder.GetObject(); objInvoiceOrder.Delete(); } objInvoice.Delete(); this.ObjContext.SaveChanges(); ts.Complete(); } } catch (Exception ex) { throw ex; } this.PopulateDataGrid(); } }
private void GenerateLabels(List <PackingList> lstPackingList, int shipto, string shipmentmode) { 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(); /* DistributorClientAddressBO objDistributorClientAddress = new DistributorClientAddressBO(); * objDistributorClientAddress.ID = shipto; * objDistributorClientAddress.GetObject();*/ InvoiceOrderBO objInvoiceOrder = new InvoiceOrderBO(); objInvoiceOrder.OrderDetail = (int)obj.ListPackingList[0].OrderDetail; string invoiceno = objInvoiceOrder.SearchObjects().Select(o => o.objInvoice.InvoiceNo).SingleOrDefault(); GenerateBarcode.GenerateCartonLabel(lblBM, obj.CartonNo.ToString(), listOrderDetails, labelText, imageLocation, invoiceno /* objDistributorClientAddress, shipmentmode*/); 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); } }
protected void rptPackingList_ItemDataBound(object sender, RepeaterItemEventArgs e) { RepeaterItem item = e.Item; if (item.ItemIndex > -1 && item.DataItem is PackingList) { PackingList objPacking = (PackingList)item.DataItem; Literal litCartonNo = (Literal)item.FindControl("litCartonNo"); HiddenField hdnPackingListID = (HiddenField)item.FindControl("hdnPackingListID"); LinkButton btnStartPackingCarton = (LinkButton)item.FindControl("btnStartPackingCarton"); LinkButton btnAutoFill = (LinkButton)item.FindControl("btnAutoFill"); Literal litTotal = (Literal)item.FindControl("litTotal"); HiddenField hdnCartonNo = (HiddenField)item.FindControl("hdnCartonNo"); HiddenField hdnShipTo = (HiddenField)item.FindControl("hdnShipTo"); HiddenField hdnShipmentMode = (HiddenField)item.FindControl("hdnShipmentMode"); HiddenField hdnWeeklyID = (HiddenField)item.FindControl("hdnWeeklyID"); LinkButton btnPrintLabel = (LinkButton)item.FindControl("btnPrintLabel"); litCartonNo.Text = "Carton #" + objPacking.CartonNo.ToString(); hdnCartonNo.Value = objPacking.CartonNo.ToString(); hdnShipTo.Value = objPacking.ListPackingList[0].ShipTo.ToString(); hdnShipmentMode.Value = objPacking.ListPackingList[0].ShipmentMode.ToString(); hdnWeeklyID.Value = objPacking.ListPackingList[0].WeeklyProductionCapacity.ToString(); InvoiceOrderBO objInvoiceOrder = new InvoiceOrderBO(); objInvoiceOrder.OrderDetail = (int)objPacking.ListPackingList[0].OrderDetail; btnPrintLabel.Visible = (objInvoiceOrder.SearchObjects().Count > 0) ? true : false; int cartonTotal = 0; int cartonFilledTotal = 0; foreach (var s in objPacking.ListPackingList) { //List<PackingListSizeQtyBO> lstPackListQtys = s.PackingListSizeQtysWhereThisIsPackingList.Where(m => m.Qty > 0).ToList(); //cartonTotal += lstPackListQtys.Select(m => m.Qty).Sum(); //List<PackingListCartonItemBO> lstPackListCartonItems = s.PackingListCartonItemsWhereThisIsPackingList.Where(m => m.Count > 0).ToList(); //cartonFilledTotal += lstPackListCartonItems.Select(m => m.Count).Sum(); cartonTotal += s.PackingTotal.Value; cartonFilledTotal += s.ScannedTotal.Value; hdnPackingListID.Value = s.PackingList.ToString(); } grandTotal += cartonTotal; if (cartonFilledTotal == 0) { //start packing btnStartPackingCarton.Text = "Start Packing"; } else if (cartonTotal > cartonFilledTotal) { //resume btnStartPackingCarton.Text = "Resume Packing"; } else if (cartonTotal == cartonFilledTotal) { //finished btnStartPackingCarton.Visible = false; btnAutoFill.Visible = false; } litTotal.Text = "Total " + cartonTotal.ToString(); DataGrid dgPackingList = (DataGrid)item.FindControl("dgPackingList"); dgPackingList.DataSource = objPacking.ListPackingList; dgPackingList.DataBind(); } }
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); } }
private void ProcessForm() { //NNM try { using (TransactionScope ts = new TransactionScope()) { #region Create InvoiceHeader InvoiceBO objInvoice = new InvoiceBO(this.ObjContext); if (QueryID > 0) { objInvoice.ID = this.QueryID; objInvoice.GetObject(); } else { objInvoice.Creator = this.LoggedUser.ID; objInvoice.CreatedDate = DateTime.Now; } objInvoice.InvoiceNo = this.txtInvoiceNo.Text; objInvoice.InvoiceDate = Convert.ToDateTime(this.txtInvoiceDate.Text); objInvoice.ShipTo = this.DistributorClientAddress; objInvoice.AWBNo = this.txtAwbNo.Text; objInvoice.WeeklyProductionCapacity = int.Parse(this.RadComboWeek.SelectedValue); objInvoice.ShipmentMode = this.ShipmentModeID; objInvoice.IndimanInvoiceNo = (this.LoggedUserRoleName == UserRole.IndimanAdministrator) ? this.txtIndimanInvoiceNo.Text : string.Empty; objInvoice.IsBillTo = this.chkIsBillTo.Checked; objInvoice.BillTo = (this.chkIsBillTo.Checked) ? int.Parse(this.ddlBillTo.SelectedValue) : 22; objInvoice.Bank = int.Parse(this.ddlBank.SelectedValue); if (this.LoggedUserRoleName == UserRole.IndimanAdministrator) { objInvoice.IndimanInvoiceDate = Convert.ToDateTime(this.txtIndimanInvoiceDate.Text); } objInvoice.Modifier = this.LoggedUser.ID; objInvoice.ModifiedDate = DateTime.Now; this.ObjContext.SaveChanges(); ViewState["InvoiceId"] = objInvoice.ID; #endregion #region InvoiceOrderDetail foreach (GridDataItem item in RadInvoice.Items) { TextBox txtRate = (TextBox)item.FindControl("txtRate"); int id = int.Parse(((System.Web.UI.WebControls.WebControl)(txtRate)).Attributes["invoiceorder"].ToString()); int orderdetail = int.Parse(((System.Web.UI.WebControls.WebControl)(txtRate)).Attributes["orderdetail"].ToString()); TextBox txtIndimanRate = (TextBox)item.FindControl("txtIndimanRate"); InvoiceOrderBO objInvoiceOrder = new InvoiceOrderBO(this.ObjContext); if (id > 0) { objInvoiceOrder.ID = id; objInvoiceOrder.GetObject(); } objInvoiceOrder.Invoice = int.Parse(ViewState["InvoiceId"].ToString()); objInvoiceOrder.OrderDetail = orderdetail; objInvoiceOrder.FactoryPrice = Convert.ToDecimal(txtRate.Text); objInvoiceOrder.IndimanPrice = (this.LoggedUserRoleName == UserRole.IndimanAdministrator) ? Convert.ToDecimal(txtIndimanRate.Text) : Convert.ToDecimal("0"); } this.ObjContext.SaveChanges(); #endregion #region Change Order Detail Status List <int> lstOrders = new List <int>(); int orderid = 0; if (this.ddlStatus.SelectedItem.Text == "Shipped") { foreach (GridDataItem item in RadInvoice.Items) { TextBox txtRate = (TextBox)item.FindControl("txtRate"); int orderdetail = int.Parse(((System.Web.UI.WebControls.WebControl)(txtRate)).Attributes["orderdetail"].ToString()); OrderDetailBO objOrderDetail = new OrderDetailBO(this.ObjContext); objOrderDetail.ID = orderdetail; objOrderDetail.GetObject(); if (objOrderDetail.Order != orderid) { lstOrders.Add(objOrderDetail.Order); orderid = objOrderDetail.Order; } objOrderDetail.Status = 16; } this.ObjContext.SaveChanges(); } #endregion #region Change Order Status if (lstOrders.Count > 0) { foreach (int order in lstOrders) { OrderBO objOrder = new OrderBO(this.ObjContext); objOrder.ID = order; objOrder.GetObject(); objOrder.Status = 21; } this.ObjContext.SaveChanges(); } #endregion ts.Complete(); } } catch (Exception ex) { // Log the error IndicoLogging.log.Error("Error occured while Adding or Updating Invoicing", ex); } }