public AretLookupResponseAPI Lookup(Aretlookupcriteria aretlookupcriteria) { var result = new AretLookupResponseAPI(); var pdsaretlookup = new pdsaretlookupDataSet(); DataRow ttblaretlookupcriteriaCriteria = pdsaretlookup.ttblaretlookupcriteria.NewttblaretlookupcriteriaRow(); Aretlookupcriteria.UpdateRowFromAretlookupcriteria(ref ttblaretlookupcriteriaCriteria, aretlookupcriteria); pdsaretlookup.ttblaretlookupcriteria.AddttblaretlookupcriteriaRow((pdsaretlookupDataSet.ttblaretlookupcriteriaRow)ttblaretlookupcriteriaCriteria); string cErrorMessage = string.Empty; bool lMoreRecords = false; NLogLoggerP.Trace("Lookup - Aret - Before Call"); StopwatchUtil.Time( () => { using (var poAretproxy = this.proxyAppObject.CreatePO_aretproxy()) { this.SetRequiredContextParameters(); poAretproxy.Lookup(ref pdsContext, ref pdsaretlookup, out cErrorMessage, out lMoreRecords); } }); NLogLoggerP.Info("Lookup - Aret - After Call"); this.ReportErrors(cErrorMessage); this.ReportErrors(this.pdsContext); this.ReportErrors(pdsaretlookup); foreach (DataRow row in pdsaretlookup.ttblaretlookupresults) { result.aretlookupresults.Add(Aretlookupresults.BuildAretlookupresultsFromRow(row)); } result.lMoreRecords = lMoreRecords; return(result); }
public AretLookupResponseAPI LookupInvoiceSequence(Aretlookupcriteria aretlookupcriteria) { var arsc = new Arsc(); var arsses = new List <Arss>(); var sb = new StringBuilder(); sb.AppendFormatWithEscape("aret.cono = {0}", this.aretRepository.Cono); sb.AppendFormatWithEscape(" AND aret.invno = {0}", aretlookupcriteria.invno); sb.AppendFormatWithEscape(" AND aret.invsuf = {0}", aretlookupcriteria.invsuf); sb.AppendFormatWithEscape(" AND aret.seqno >= {0}", aretlookupcriteria.seqno); sb.AppendFormatWithEscape(" AND aret.custno = {0}", aretlookupcriteria.custno); sb.AppendFormatWithEscape(" AND aret.statustype = {0}", aretlookupcriteria.statustype); sb.AppendFormatWithEscape(" AND aret.transcd = {0}", aretlookupcriteria.transcd); var where = sb.ToString(); var resultFetchWhere = this.aretRepository.GetList(where, aretlookupcriteria.IsAutoComplete ? 10 : aretlookupcriteria.recordcountlimit, aretlookupcriteria.IsAutoComplete ? "seqno" : "seqno,amount,rowID,custno,invdt,invno,invsuf,jrnlno,notesfl,refer,shipto,statustype,transcd,notesfl").ToList(); if (resultFetchWhere.Count > 0 && !aretlookupcriteria.IsAutoComplete) { arsc = this.arscRepository.Get(0, aretlookupcriteria.custno, false, 1, "custno,name,notefl") ?? new Arsc(); } var results = new AretLookupResponseAPI(); foreach (var fwResult in resultFetchWhere) { var result = new Aretlookupresults { seqno = fwResult.seqno }; if (!aretlookupcriteria.IsAutoComplete) { var arss = arsses.FirstOrDefault(x => x.shipto == fwResult.shipto); if (arss == null) { if (string.IsNullOrEmpty(fwResult.shipto)) { arss = new Arss { shipto = "", name = string.Empty }; } else { arss = this.arssRepository.Get(0, fwResult.custno, fwResult.shipto, 1, "shipto,name") ?? new Arss { shipto = fwResult.shipto, name = string.Empty }; } arsses.Add(arss); } result.amount = fwResult.amount; result.aretRowid = fwResult.rowID; result.custno = fwResult.custno; result.invdt = fwResult.invdt; result.invno = fwResult.invno; result.invsuf = fwResult.invsuf; result.jrnlno = fwResult.jrnlno; result.notesfl = fwResult.notesfl; result.refer = fwResult.refer; result.shipto = fwResult.shipto; result.statustype = fwResult.statustype; result.transcd = fwResult.transcd; result.arscName = arsc.name; result.custnotesfl = arsc.notesfl; result.arssName = arss.name; } results.aretlookupresults.Add(result); } return(results); }