private List <PackingListBO> GetCartonData() { var PackingLists = new List <PackingListBO>(); if (Source != null) { PackingLists = Source; } else { OrderDetailQtyBO obj = new OrderDetailQtyBO(); obj.ID = this.OrderDetailQtyID; obj.GetObject(); this.SizeID = obj.Size; var objPack = new PackingListBO(); objPack.WeeklyProductionCapacity = WeekendCapacityID; // objPack.OrderDetail = obj.OrderDetail; objPack.CartonNo = CartonNo; PackingLists = objPack.SearchObjects().ToList(); } Source = PackingLists; return(PackingLists); }
protected void rptSizeQty_ItemDataBound(object sender, RepeaterItemEventArgs e) { RepeaterItem item = e.Item; if (item.ItemIndex > -1 && item.DataItem is OrderDetailQtyBO) { OrderDetailQtyBO objClientOrderQty = (OrderDetailQtyBO)item.DataItem; Literal litHeading = (Literal)item.FindControl("litHeading"); litHeading.Text = objClientOrderQty.objSize.SizeName; Label lblQty = (Label)item.FindControl("lblQty"); lblQty.Text = objClientOrderQty.Qty.ToString(); lblQty.Attributes.Add("Size", objClientOrderQty.Size.ToString()); } }
private void AddItem(int orderDetailQtyID, int cartonNo) { OrderDetailQtyBO objOrderDetailQty = new OrderDetailQtyBO(); objOrderDetailQty.ID = orderDetailQtyID; objOrderDetailQty.GetObject(); List <PackingListBO> lstPackingList = Source.Where(m => m.OrderDetail == objOrderDetailQty.OrderDetail && m.CartonNo == cartonNo).ToList(); if (lstPackingList.Any()) { using (TransactionScope ts = new TransactionScope()) { //PackingListCartonItemBO objPackListCartonItem = new PackingListCartonItemBO(); //objPackListCartonItem.PackingList = lstPackingList.SingleOrDefault().ID; //objPackListCartonItem.Size = objOrderDetailQty.Size; //List<PackingListCartonItemBO> lstCartonItem = objPackListCartonItem.SearchObjects(); ////PackingListSizeQtyBO objPackingListSizeQty = new PackingListSizeQtyBO(); ////objPackingListSizeQty.PackingList = lstPackingList.SingleOrDefault().ID; ////objPackingListSizeQty.Size = objOrderDetailQty.Size; ////List<PackingListSizeQtyBO> lstSizeQty = objPackingListSizeQty.SearchObjects(); //if (!lstCartonItem.Any()) //{ // // no records // PackingListCartonItemBO objPackListCartonItemToSave = new PackingListCartonItemBO(this.ObjContext); // objPackListCartonItemToSave.PackingList = objPackListCartonItem.PackingList; // objPackListCartonItemToSave.Size = objPackListCartonItem.Size; // objPackListCartonItemToSave.Count = 1; // objPackListCartonItem.Count + 1; // addedSizeID = objPackListCartonItem.Size; //} //else if (lstCartonItem.Any() && (lstCartonItem.SingleOrDefault().Count < objOrderDetailQty.Qty)) //{ // //update // PackingListCartonItemBO objPackListCartonItemToSave = new PackingListCartonItemBO(this.ObjContext); // objPackListCartonItemToSave.ID = lstCartonItem.SingleOrDefault().ID; // objPackListCartonItemToSave.GetObject(); // objPackListCartonItemToSave.Count++; // addedSizeID = objPackListCartonItem.Size; //} ////else if (lstCartonItem.Any() && (lstCartonItem.SingleOrDefault().Count == lstSizeQty.SingleOrDefault().Qty)) ////{ //// //filled ////} PackingListCartonItemBO objPackListCartonItem = new PackingListCartonItemBO(this.ObjContext); objPackListCartonItem.PackingList = lstPackingList.SingleOrDefault().ID; objPackListCartonItem.Size = objOrderDetailQty.Size; objPackListCartonItem.Count = this.ItemNo; // objPackListCartonItem.Count + 1; addedSizeID = objPackListCartonItem.Size; this.ObjContext.SaveChanges(); ts.Complete(); } DisplaySuccessMessage(cartonNo); } else // wrong poly bag { DisplayCartonErrorMessage("ස්කෑන් කරන ලද පොලි බෑගය මෙම පෙට්ටියට අදාළ නොවේ. <br/><br/>නැවත නිවැරදි පෙට්ටිය ස්කෑන් කරන්න.<br/><br/>Scanned Poly bag should not go to this Carton.<br/><br/>Please scan the correct Carton."); } }
private List <PackingListBO> GetPolyBagData() { List <PackingListBO> PackingLists = new List <PackingListBO>(); List <PackingListCartonItemBO> lstCartonItems = new List <PackingListCartonItemBO>(); PackingListBO objPacking = new PackingListBO(); if (Source != null) { PackingLists = Source; } else { OrderDetailQtyBO obj = new OrderDetailQtyBO(); obj.ID = this.OrderDetailQtyID; obj.GetObject(); this.SizeID = obj.Size; var objPack = new PackingListBO(); //objPack.WeeklyProductionCapacity = WeekendCapacityID; objPack.OrderDetail = obj.OrderDetail; //objPack.CartonNo = CartonNo; DateTime monday = WeekEndDate.AddDays(-(int)WeekEndDate.DayOfWeek - 6); // List<PackingListBO> loadedPackingLists = objPack.SearchObjects().Where(m => m.PackingListSizeQtysWhereThisIsPackingList.Where(o => o.Qty > 0).Select(s => s.Size).Contains(this.SizeID) && m.objWeeklyProductionCapacity.WeekendDate.Date == WeekEndDate.Date && m.CartonNo > 0).ToList(); //.Where(m => m.PackingListCartonItemsWhereThisIsPackingList.Where(k => k.Size == this.SizeID).SingleOrDefault().Count < m.PackingListSizeQtysWhereThisIsPackingList.Where(k => k.Size == this.SizeID).SingleOrDefault().Qty).ToList(); List <PackingListBO> loadedPackingLists = objPack.SearchObjects().Where(m => m.PackingListSizeQtysWhereThisIsPackingList.Where(s => s.Qty > 0).Select(s => s.Size).Contains(this.SizeID) && (DateTime.Compare(m.objWeeklyProductionCapacity.WeekendDate.Date, monday.Date) > -1) && m.CartonNo > 0).ToList(); //.Where(m => m.PackingListCartonItemsWhereThisIsPackingList.Where(k => k.Size == this.SizeID).SingleOrDefault().Count < m.PackingListSizeQtysWhereThisIsPackingList.Where(k => k.Size == this.SizeID).SingleOrDefault().Qty).ToList(); foreach (PackingListBO objPackingList in loadedPackingLists) { PackingListCartonItemBO objCartonItem = new PackingListCartonItemBO(); objCartonItem.Size = this.SizeID; objCartonItem.PackingList = objPackingList.ID; objCartonItem.Count = this.ItemNo; lstCartonItems = objCartonItem.SearchObjects(); if (lstCartonItems.Any() && lstCartonItems.Count == 1) { this.polyBagStatus = PolyBagFillingStatus.Filled; break; } else { PackingLists.Add(objPackingList); this.polyBagStatus = PolyBagFillingStatus.Available; } } } if (this.polyBagStatus == PolyBagFillingStatus.Filled) { PackingLists.Clear(); } Source = PackingLists; return(PackingLists); }
//protected void dataGridSizeSets_ItemDataBound(object sender, DataGridItemEventArgs e) //{ // DataGridItem item = e.Item; // if (item.ItemIndex > -1 && item.DataItem is SizeSetBO) // { // SizeSetBO objSizeSets = (SizeSetBO)item.DataItem; // LinkButton linkEdit = (LinkButton)item.FindControl("linkEdit"); // linkEdit.Attributes.Add("qid", objSizeSets.ID.ToString()); // } //} //protected void dataGridSizeSets_SortCommand(object source, DataGridSortCommandEventArgs e) //{ // string sortDirection = String.Empty; // if (!SortExpression.ToUpper().StartsWith(e.SortExpression) && !SortExpression.ToUpper().Trim().EndsWith("ASC")) // { // sortDirection = " asc"; // } // else // { // sortDirection = (SortExpression.ToUpper().EndsWith("DESC")) ? " asc" : " desc"; // } // this.SortExpression = e.SortExpression + sortDirection; // this.PopulateDataGrid(); // foreach (DataGridColumn col in this.dataGridSizeSets.Columns) // { // if (col.Visible && col.SortExpression == e.SortExpression) // { // col.HeaderStyle.CssClass = "selected " + ((sortDirection.ToUpper() != " DESC") ? "sortDown" : "sortUp"); // } // else // { // col.HeaderStyle.CssClass = ""; // } // } //} //protected void dataGridSizeSets_PageIndexChanged(object source, DataGridPageChangedEventArgs e) //{ // Set page index // this.dataGridSizeSets.CurrentPageIndex = e.NewPageIndex; // this.PopulateDataGrid(); //} //protected void dataGridSizeSets_ItemCommand(object sender, DataGridCommandEventArgs e) //{ // if (e.CommandName == "Edit") // { // List<SizeSetBO> lstExistingItems = (new SizeBO()).SearchObjects().GroupBy(o => o.SizeSet).Select(m => m.First().objSizeSet).ToList(); // this.ddlSizeSet.Items.Clear(); // this.ddlSizeSet.Items.Add(new ListItem("Select Size Set", "0")); // foreach (SizeSetBO item in lstExistingItems) // { // this.ddlSizeSet.Items.Add(new ListItem(item.Name, item.ID.ToString())); // } // this.ddlSizeSet.Items.FindByValue(((System.Web.UI.WebControls.TableRow)(e.Item)).Cells[0].Text).Selected = true; // this.linkAddNew.Visible = true; // this.PopulateSizeSet(false); // this.hdnIsNewSizeSet.Value = "0"; // } //} protected void dgAddEditSizes_ItemDataBound(object sender, DataGridItemEventArgs e) { DataGridItem item = e.Item; //if ((item.ItemIndex > -1 && item.DataItem is SizeBO) && (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem)) if (item.ItemIndex > -1 && item.DataItem is KeyValuePair <int, SizeBO> ) { KeyValuePair <int, SizeBO> objSize = (KeyValuePair <int, SizeBO>)item.DataItem; bool canDelete = true; if (objSize.Key > 0) { //bool canDelete = (objSize.OrderDetailQtysWhereThisIsSize.Count == 0 && objSize.SizeChartsWhereThisIsSize.Count == 0); OrderDetailQtyBO objODQ = new OrderDetailQtyBO(); objODQ.Size = objSize.Key; SizeChartBO objSC = new SizeChartBO(); objSC.Size = objSize.Key; canDelete = !(objSC.SearchObjects().Any() || objODQ.SearchObjects().Any()); } /*CheckBox chkIsDefault = (CheckBox)item.FindControl("chkIsDefault"); * chkIsDefault.Checked = objSize.IsDefault; * chkIsDefault.Enabled = false; * * Literal lblID = (Literal)item.FindControl("lblID"); * lblID.Text = objSize.ID.ToString(); * * Literal lblSeqNo = (Literal)item.FindControl("lblSeqNo"); * lblSeqNo.Text = objSize.SeqNo.ToString(); * * Literal lblSizeName = (Literal)item.FindControl("lblSizeName"); * lblSizeName.Text = objSize.SizeName; * * LinkButton linkEdit = (LinkButton)item.FindControl("linkEdit"); * linkEdit.Attributes.Add("qid", objSize.ID.ToString());*/ HyperLink linkDelete = (HyperLink)item.FindControl("linkDelete"); linkDelete.Attributes.Add("qid", objSize.Key.ToString()); linkDelete.Visible = canDelete; /*} * else if ((item.ItemIndex > -1 && item.DataItem is SizeBO) && (item.ItemType == ListItemType.EditItem)) * { * SizeBO objSize = (SizeBO)item.DataItem;*/ CheckBox chkIsDefault = (CheckBox)item.FindControl("chkIsDefault"); chkIsDefault.Checked = objSize.Value.IsDefault; chkIsDefault.Enabled = true; Literal lblID = (Literal)item.FindControl("lblID"); lblID.Text = objSize.Key.ToString(); TextBox txtSeqNo = (TextBox)item.FindControl("txtSeqNo"); txtSeqNo.Text = objSize.Value.SeqNo.ToString(); this.hdnSeqNo.Value = txtSeqNo.Text; TextBox txtSizeName = (TextBox)item.FindControl("txtSizeName"); txtSizeName.Text = objSize.Value.SizeName; this.hdnSizeName.Value = txtSizeName.Text; //LinkButton linkSave = (LinkButton)item.FindControl("linkSave"); //linkSave.Attributes.Add("qid", objSize.ID.ToString()); //linkSave.CommandName = (!string.IsNullOrEmpty(hdnSizeName.Value) || (int.Parse(this.hdnSeqNo.Value) > 0)) ? "Update" : "Save"; } }
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); } }