private void resendToPyramid() { String sSql = " select vart_ordernr " + " from serviceHuvud " + " where SentToPyramid = false "; String errStr = ""; DataTable dt = cdb.getData(sSql, ref errStr); ExportToPyramid.CExportToPyramid expPyr = new ExportToPyramid.CExportToPyramid(); foreach (DataRow dr in dt.Rows) { ServHuvCL sh = new ServHuvCL(); sh.Vart_ordernr = dr["vart_ordernr"].ToString(); sh = getServiceHuvud(sh); ErrorCL errCl = expPyr.exportOrder(sh); } }
public OrderArtCL checkoutOrderArt(OrderArtCL oa, string id, bool acceptGodkand) { ExportToPyramid.CExportToPyramid pyExport = new ExportToPyramid.CExportToPyramid(); string exportErr = pyExport.checkPyramidAPIAvailable(); if (exportErr != "") { OrderArtCL oacl = new OrderArtCL(); oacl.ErrCode = -18250; oacl.ErrMessage = exportErr; return(oacl); } ReparatorCL rep = null; if (id == "") { rep = new ReparatorCL(); rep.AnvID = "Pyramid"; } else { CReparator cr = new CReparator(); rep = cr.getReparator(id); } // 2018-04-23 KJBO // Special handling due to gui limitations //if (oa.OrderArtId != 0 && oa.Artnr == null) //{ // oa.Artnr = getArtnrForOrderArt(oa.OrderArtId); //} if (oa.VartOrdernr == "") { OrderArtCL oaRet = new OrderArtCL(); oaRet.ErrCode = -103; oaRet.ErrMessage = "Ordernummer måste anges"; return(oaRet); } if (oa.Artnr == "") { OrderArtCL oaRet = new OrderArtCL(); oaRet.ErrCode = -104; oaRet.ErrMessage = "Artikelnummer måste anges"; return(oaRet); } string errTxt = ""; int rc = validateOa(oa, ref errTxt); if (rc == -1) { OrderArtCL oaRet = new OrderArtCL(); oaRet.ErrCode = -106; oaRet.ErrMessage = "Felaktigt ordernr"; return(oaRet); } if (rc == -2) { OrderArtCL oaRet = new OrderArtCL(); oaRet.ErrCode = -107; if (errTxt == "") { oaRet.ErrMessage = "Felaktigt ordernr"; } else { oaRet.ErrMessage = errTxt; } return(oaRet); } if (!acceptGodkand) { if (rc == -3) { OrderArtCL oaRet = new OrderArtCL(); oaRet.ErrCode = -108; if (errTxt == "") { oaRet.ErrMessage = "Ordern är godkänd. Ändringar ej tillåtna"; } else { oaRet.ErrMessage = errTxt; } return(oaRet); } } string sSql = ""; // 2018-04-30 KJBO if (oa.OrderArtId == 0) { decimal toBeAdded = 0; oa.OrderArtId = reuseOrderArtId(oa, ref toBeAdded); if (oa.OrderArtId != 0) { oa.CoAntal += toBeAdded; } } if (oa.OrderArtId == 0) { sSql = getOaInsertSql(); } else { sSql = getOaUpdateSql(); } NxParameterCollection pc = new NxParameterCollection(); setOaParameters(pc, oa, oa.OrderArtId == 0, rep.AnvID); int li_rc = cdb.updateData(sSql, ref errTxt, pc); if (errTxt != "") { OrderArtCL oaRet = new OrderArtCL(); if (errTxt.Length > 2000) { errTxt = errTxt.Substring(1, 2000); } oaRet.ErrCode = -100; oaRet.ErrMessage = errTxt; return(oaRet); } if (oa.OrderArtId == 0) { sSql = "SELECT MAX(orderArtId) orderArtId FROM orderArt "; DataTable dt = cdb.getData(sSql, ref errTxt); if (errTxt != "") { OrderArtCL oaRet = new OrderArtCL(); if (errTxt.Length > 2000) { errTxt = errTxt.Substring(1, 2000); } oaRet.ErrCode = -100; oaRet.ErrMessage = errTxt; return(oaRet); } oa.OrderArtId = Convert.ToInt32(dt.Rows[0][0]); } List <OrderArtCL> oaList = getOrderArt(oa.OrderArtId, ""); if (oaList.Count != 1) { OrderArtCL oaRet = new OrderArtCL(); if (errTxt.Length > 2000) { errTxt = errTxt.Substring(1, 2000); } oaRet.ErrCode = -110; oaRet.ErrMessage = "Error when retrieving orderArt"; return(oaRet); } ErrorCL errCl = pyExport.reserveArticle(oaList[0].OrderArtId); //pyExport.retryAllOrders(); return(oaList[0]); }
/// <summary> /// Retuns a key-value list of available selection /// for the below getExportFullList /// </summary> /// <param name="ident"></param> /// <returns></returns> /// 2018-05-31 KJBO public List <KeyValuePair <int, string> > getExportListSelection(string ident) { ExportToPyramid.CExportToPyramid pExp = new ExportToPyramid.CExportToPyramid(); return(pExp.getExportListSelection(ident)); }
/// <summary> /// Get a full export list for one order. This list can reflect all items that will be exported /// or all items that is already exported by setting the exported boolean flag. /// </summary> /// <param name="ident"></param> /// <param name="vartOrdernr"></param> /// <param name="exported"></param> /// <returns>A list of orderArtCL type</returns> /// 2018-05-30 KJBO Indentive AB public List <OrderArtCL> getExportFullList(string ident, string vartOrdernr, int listType) { ExportToPyramid.CExportToPyramid pExp = new ExportToPyramid.CExportToPyramid(); return(pExp.getExportFullList(ident, vartOrdernr, listType)); }
/// <summary> /// Exports all timerecords to Pyramid by /// aggregating on konto (=artikel) /// </summary> /// <param name="vartOrdernr"></param> /// <returns></returns> /// 2018-05-03 KJBO Indentive AB public ErrorCL exportTime(string vartOrdernr) { ExportToPyramid.CExportToPyramid cexp = new ExportToPyramid.CExportToPyramid(); return(cexp.exportTime(vartOrdernr)); }