protected void btnResetPacking_Click(object sender, EventArgs e) { List <PackingListBO> lstPackingLists = GetPolyBagData(); var objPackBO = new PackingListBO(); objPackBO.WeeklyProductionCapacity = WeekendCapacityID; objPackBO.CartonNo = CartonNo; lstPackingLists = objPackBO.SearchObjects().ToList(); foreach (PackingListBO objPack in lstPackingLists) { List <int> lstPackListCartonItemQtys = objPack.PackingListCartonItemsWhereThisIsPackingList.Select(m => m.ID).ToList(); foreach (int id in lstPackListCartonItemQtys) { PackingListCartonItemBO obj = new PackingListCartonItemBO(this.ObjContext); obj.ID = id; obj.GetObject(); obj.Delete(); } } this.ObjContext.SaveChanges(); }
private void AutoFillCarton(List <PackingList> lstPackingList) { try { using (TransactionScope ts = new TransactionScope()) { //PackingListSizeQtyBO obj = new PackingListSizeQtyBO(); //obj.PackingList = PackingListID; //List<PackingListSizeQtyBO> lstPackingListSizeQty = obj.SearchObjects(); foreach (PackingList item in lstPackingList) { foreach (PackingListViewBO plv in item.ListPackingList) { List <PackingListSizeQtyBO> lstPackingListSizeQty = (new PackingListSizeQtyBO()).GetAllObject().Where(o => o.PackingList == plv.PackingList).ToList(); foreach (PackingListSizeQtyBO plsq in lstPackingListSizeQty) { PackingListCartonItemBO objPackListCartonItem = new PackingListCartonItemBO(); objPackListCartonItem.PackingList = plsq.PackingList; objPackListCartonItem.Size = plsq.Size; List <PackingListCartonItemBO> lstCartonItem = objPackListCartonItem.SearchObjects(); if (!lstCartonItem.Any()) { // no records PackingListCartonItemBO objPackListCartonItemToSave = new PackingListCartonItemBO(this.ObjContext); objPackListCartonItemToSave.PackingList = objPackListCartonItem.PackingList; objPackListCartonItemToSave.Size = objPackListCartonItem.Size; objPackListCartonItemToSave.Count = plsq.Qty; } else if (lstCartonItem.Any())// && (lstCartonItem.SingleOrDefault().Count <plsq.objPackingList.bjOrderDetailQty.Qty)) { //update PackingListCartonItemBO objPackListCartonItemToSave = new PackingListCartonItemBO(this.ObjContext); objPackListCartonItemToSave.ID = lstCartonItem.SingleOrDefault().ID; objPackListCartonItemToSave.GetObject(); objPackListCartonItemToSave.Count = plsq.Qty; } } } } this.ObjContext.SaveChanges(); ts.Complete(); } } catch (Exception ex) { IndicoLogging.log.Error("Error occured while Saving PackingListCartonItem From ViewPackingLists.aspx Page when click AutoFillCarton Function", ex); } }
protected void btnReset_Click(object sender, EventArgs e) { //NNM int carton = int.Parse(this.hdnCarton.Value); int week = int.Parse(this.hdnWeekID.Value); try { if (carton > 0 && week > 0) { List <PackingListBO> lstPackingLists = GetPolyBagData(); var objPackBO = new PackingListBO(); objPackBO.WeeklyProductionCapacity = week; objPackBO.CartonNo = carton; lstPackingLists = objPackBO.SearchObjects().ToList(); using (TransactionScope ts = new TransactionScope()) { foreach (PackingListBO objPack in lstPackingLists) { List <int> lstPackListCartonItemQtys = objPack.PackingListCartonItemsWhereThisIsPackingList.Select(m => m.ID).ToList(); foreach (int id in lstPackListCartonItemQtys) { PackingListCartonItemBO obj = new PackingListCartonItemBO(this.ObjContext); obj.ID = id; obj.GetObject(); obj.Delete(); } } this.ObjContext.SaveChanges(); ts.Complete(); } } } catch (Exception ex) { IndicoLogging.log.Error("Error occured while deleting PackingListCartonItems in PackingList.aspx", ex); } }
protected void rptPackingList_ItemCommand(object source, RepeaterCommandEventArgs e) { HiddenField hdnCartonNo = (HiddenField)e.Item.FindControl("hdnCartonNo"); int cartonNo = int.Parse(hdnCartonNo.Value.ToString()); if (Source != null) { List <PackingList> PackingList = Source.Where(m => m.CartonNo == cartonNo).ToList(); if (e.CommandName == "PrintLabel") { this.GenerateLabels(PackingList); } else if (e.CommandName == "StartPacking") { Response.Redirect("FillCarton.aspx?cartonNo=" + cartonNo + "&&weekendDate=" + WeekEndDate.ToShortDateString()); } else if (e.CommandName == "AutoFill") { //HiddenField hdnPackingListID = (HiddenField)e.Item.FindControl("hdnPackingListID"); // Auto filling the carton this.AutoFillCarton(PackingList); this.PopulateDataGrid(); } else if (e.CommandName == "ResetCarton") { HiddenField hdnWeeklyID = (HiddenField)e.Item.FindControl("hdnWeeklyID"); int weeklyid = int.Parse(hdnWeeklyID.Value); try { if (cartonNo > 0 && weeklyid > 0) { //List<PackingListBO> lstPackingLists = GetPolyBagData(); PackingListBO objPackBO = new PackingListBO(); objPackBO.WeeklyProductionCapacity = weeklyid; objPackBO.CartonNo = cartonNo; List <PackingListBO> lstPackingLists = objPackBO.SearchObjects().ToList(); using (TransactionScope ts = new TransactionScope()) { foreach (PackingListBO objPack in lstPackingLists) { List <int> lstPackListCartonItemQtys = objPack.PackingListCartonItemsWhereThisIsPackingList.Select(m => m.ID).ToList(); foreach (int id in lstPackListCartonItemQtys) { PackingListCartonItemBO obj = new PackingListCartonItemBO(this.ObjContext); obj.ID = id; obj.GetObject(); obj.Delete(); } } this.ObjContext.SaveChanges(); ts.Complete(); } } } catch (Exception ex) { IndicoLogging.log.Error("Error occured while deleting PackingListCartonItems in ViewPackingLists.aspx", ex); } this.PopulateDataGrid(); } } else { Response.Redirect(Request.RawUrl); } }
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); } }