public static UpdateResult SaveConfiguredRecords(string sourceId, string sourceLineNo, string sourceSite, string rootId, List <Advantech.Myadvantech.DataAccess.DataCore.ConfigurationHub.ConfiguredItems> selectedItems, string companyId, string currency, string reconfigData) { UpdateResult result = new UpdateResult(); try { HubConfiguredResult myEntity = new HubConfiguredResult(); myEntity.ID = sourceId; myEntity.Source = sourceSite; myEntity.ParentLineNo = int.Parse(sourceLineNo); myEntity.RootID = rootId; myEntity.Result = Convert.ToInt32(true); myEntity.SelectedItems = Newtonsoft.Json.JsonConvert.SerializeObject(selectedItems); myEntity.CompanyID = companyId; myEntity.Currency = currency; myEntity.ReConfigData = reconfigData; myEntity.CreatedTime = System.DateTime.Now; MyAdvantechDAL.AddConfigurationHubConfiguredRecords(myEntity); result.IsUpdated = true; } catch (Exception ex) { result.IsUpdated = false; result.ServerMessage = ex.ToString(); } return(result); }
public static UpdateResult Configurator2Cart(string cartId, int parentLineNo, string orgId) { UpdateResult updateResult = new UpdateResult(); List <ConfiguredItems> items = new List <ConfiguredItems>(); try { HubConfiguredResult hcr = MyAdvantechDAL.GetHubConfiguredResultsWithLineNo(cartId, parentLineNo); if (hcr != null) { // Remove all items in current cart for ACN if (orgId.StartsWith("CN")) { CartDetailHelper.RemoveCartDetailByID(cartId); } List <ConfiguredItems> toAdditems = Newtonsoft.Json.JsonConvert.DeserializeObject <List <ConfiguredItems> >(hcr.SelectedItems); if (toAdditems == null || toAdditems.Count == 0) { updateResult.IsUpdated = false; updateResult.ServerMessage = "No item was selected."; return(updateResult); } // Split pipeline items foreach (ConfiguredItems c in toAdditems) { if (c.name.Contains("|")) { foreach (var i in c.name.Split('|').ToList()) { SAP_PRODUCT sp = MyAdvantechDAL.GetSAPProduct(i); ConfiguredItems newitem = new ConfiguredItems(); newitem.name = i; newitem.desc = (sp != null && !String.IsNullOrEmpty(sp.PRODUCT_DESC)) ? sp.PRODUCT_DESC : c.desc; newitem.qty = c.qty; //newitem.isLooseItem = c.isLooseItem; items.Add(newitem); } } else { items.Add(c); } } // Get next higherlevel & next loose line no. int NextHigherLevel = hcr.ParentLineNo; var objNextHigherLevel = SqlProvider.dbExecuteScalar("MY", "select max(line_no) from cart_DETAIL_V2 where cart_id = '" + cartId + "' and (otype = 0 or otype = 1)"); if (objNextHigherLevel != null && !String.IsNullOrEmpty(objNextHigherLevel.ToString())) { NextHigherLevel = (Convert.ToInt32(objNextHigherLevel.ToString()) / 100 + 1) * 100; } int NextLooseItemLineNo = 1; var objNextLooseItemLineNo = SqlProvider.dbExecuteScalar("MY", "select max(line_no) from cart_DETAIL_V2 where cart_id = '" + cartId + "' and otype = 0 "); if (objNextLooseItemLineNo != null && !String.IsNullOrEmpty(objNextLooseItemLineNo.ToString())) { NextLooseItemLineNo = Convert.ToInt32(objNextLooseItemLineNo.ToString()) + 1; } if (items.Count > 0) { // For ACN, need to split BOTS root name with "/", ex: IPC-510-BTO/P4 items.Where(c => c.name.Contains("-BTO/")).ToList().ForEach(c => c.name = c.name.Split(new string[] { "/" }, StringSplitOptions.None)[0]); // Simulate Product List to get price Order _order = new Order(); _order.Currency = hcr.Currency; _order.OrgID = orgId; _order.DistChannel = "10"; _order.Division = "00"; if (orgId.StartsWith("CN")) { if (System.Configuration.ConfigurationManager.AppSettings["ACNTaxRate"] != null) { _order.Tax = Convert.ToDecimal(System.Configuration.ConfigurationManager.AppSettings["ACNTaxRate"]); } else { _order.Tax = (Decimal)0.16; } } foreach (ConfiguredItems c in items) { //Frank 20171222, if part's material is BTO then identify it as BTOS parent item SAP_PRODUCT sap_p = MyAdvantechDAL.GetSAPProduct(c.name); if (orgId.Equals("EU80") && c.isLooseItem) { _order.AddLooseItem(c.name, SAPDAL.GetPlantByOrg(orgId), NextLooseItemLineNo, c.qty); NextLooseItemLineNo++; } else if (sap_p != null && (sap_p.MATERIAL_GROUP.Equals("BTOS", StringComparison.InvariantCultureIgnoreCase) || c.name.EndsWith("-BTO", StringComparison.OrdinalIgnoreCase))) { _order.AddBTOSParentItem(c.name, SAPDAL.GetPlantByOrg(orgId), NextHigherLevel, c.qty); } else { _order.AddBTOSChildItem(c.name, NextHigherLevel, SAPDAL.GetPlantByOrg(orgId), c.qty); } } _order.SetOrderPartnet(new OrderPartner(hcr.CompanyID, orgId, OrderPartnerType.SoldTo)); _order.SetOrderPartnet(new OrderPartner(hcr.CompanyID, orgId, OrderPartnerType.ShipTo)); _order.SetOrderPartnet(new OrderPartner(hcr.CompanyID, orgId, OrderPartnerType.BillTo)); String _errMsg = String.Empty; Advantech.Myadvantech.DataAccess.SAPDAL.SimulateOrder(ref _order, ref _errMsg); // End order simulation if (_order != null && String.IsNullOrEmpty(_errMsg)) { foreach (Product p in _order.LineItems) { cart_DETAIL_V2 CartDetail = new cart_DETAIL_V2(); CartDetail.Cart_Id = cartId; if (p.LineItemType == LineItemType.LooseItem) { CartDetail.Line_No = p.LineNumber; CartDetail.higherLevel = 0; } else if (p.LineItemType == LineItemType.BTOSParent) { CartDetail.Line_No = NextHigherLevel; CartDetail.higherLevel = 0; } else { CartDetail.Line_No = p.LineNumber; CartDetail.higherLevel = NextHigherLevel; } CartDetail.Part_No = p.PartNumber; CartDetail.Description = items.Where(i => i.name == p.PartNumber).FirstOrDefault().desc; CartDetail.Qty = p.Quantity; CartDetail.Ew_Flag = 0; CartDetail.SatisfyFlag = 0; CartDetail.QUOTE_ID = ""; CartDetail.Category = items.Where(i => i.name == p.PartNumber).FirstOrDefault().category; CartDetail.CustMaterial = ""; CartDetail.otype = 0; CartDetail.req_date = DateTime.Now.AddDays(2); if (CartDetail.Line_No < 100) { CartDetail.otype = (int)QuoteItemType.Part; } else if (CartDetail.Line_No % 100 == 0 && CartDetail.higherLevel == 0) { CartDetail.otype = (int)QuoteItemType.BtosParent; } else if (CartDetail.Line_No % 100 > 0 && CartDetail.Line_No > 100) { CartDetail.otype = (int)QuoteItemType.BtosPart; } CartDetail.due_date = CartDetail.req_date; CartDetail.Delivery_Plant = SAPDAL.GetDeliveryPlant(hcr.CompanyID, orgId, CartDetail.Part_No, (QuoteItemType)Enum.Parse(typeof(QuoteItemType), CartDetail.otype.ToString())); // set price according to it's item type if (CartDetail.otype == (int)QuoteItemType.BtosParent) { CartDetail.List_Price = 0; CartDetail.Unit_Price = 0; CartDetail.Itp = 0; } else { CartDetail.List_Price = p.ListPrice; CartDetail.Unit_Price = p.UnitPrice; CartDetail.Itp = 0; } // Get product info from sap_product table DataTable sapproduct_dt = SqlProvider.dbGetDataTable("MY", "select * from sap_product where part_no = '" + p.PartNumber + "'"); if (sapproduct_dt != null && sapproduct_dt.Rows.Count > 0) { CartDetail.Model_No = sapproduct_dt.Rows[0]["Model_No"].ToString(); } MyAdvantechContext.Current.cart_DETAIL_V2.Add(CartDetail); } MyAdvantechContext.Current.SaveChanges(); updateResult.IsUpdated = true; } else { updateResult.IsUpdated = false; updateResult.ServerMessage = _errMsg; } } } else { updateResult.IsUpdated = false; updateResult.ServerMessage = "No matched record found."; } } catch (Exception ex) { updateResult.IsUpdated = false; updateResult.ServerMessage = ex.ToString(); } return(updateResult); }