public String insert(XcustBlanketHeaderTbl b) { String sql = "", chk = ""; try { String last_update_by = "0", creation_by = "0"; //p.TAX_AMOUNT = p.TAX_AMOUNT.Equals("") ? "0" : p.TAX_AMOUNT; sql = "Insert Into " + xCBlKH.table + "(" + xCBlKH.POCUMENT_BU + "," + xCBlKH.AGREEMENT_NUMBER + "," + xCBlKH.STATUS + "," + xCBlKH.BUYER + "," + xCBlKH.SUPPLIER + "," + xCBlKH.SUPPLIER_SITE + "," + xCBlKH.SUPPLIER_CODE + "," + xCBlKH.COMUNICATION_METHOD + "," + xCBlKH.E_MAIL + "," + xCBlKH.START_DATE + "," + xCBlKH.END_DATE + "," + xCBlKH.AGREEMENT_AMT + "," + xCBlKH.MIN_RELEASE_AMT + "," + xCBlKH.RELEASE_AMT + "," + xCBlKH.DESCRIPTION + "," + xCBlKH.LAST_UPDATE_DATE + "," + xCBlKH.CREATION_DATE + "," + xCBlKH.PO_HEADER_ID + " " + ") " + "Values('" + b.POCUMENT_BU.Replace("|", ",") + "','" + b.AGREEMENT_NUMBER + "','" + b.STATUS + "','" + b.BUYER.Replace("|", ",") + "','" + b.SUPPLIER.Replace("|", ",") + "','" + b.SUPPLIER_SITE + "','" + b.SUPPLIER_CODE + "','" + b.COMUNICATION_METHOD.Replace("|", ",") + "','" + b.E_MAIL.Replace("|", ",") + "','" + b.START_DATE + "','" + b.END_DATE + "'," + b.AGREEMENT_AMT + "," + b.MIN_RELEASE_AMT + "," + b.RELEASE_AMT + ",'" + b.DESCRIPTION.Replace("|", ",") + "','" + b.LAST_UPDATE_DATE + "','" + b.CREATION_DATE + "'," + b.PO_HEADER_ID + "" + ") "; chk = conn.ExecuteNonQuery(sql, "kfc_po"); //chk = p.RowNumber; //chk = p.Code; } catch (Exception ex) { //MessageBox.Show("Error " + ex.ToString(), "insert Doctor"); } return(chk); }
private void initConfig() { xCBlKH = new XcustBlanketHeaderTbl(); xCBlKH.POCUMENT_BU = "POCUMENT_BU"; xCBlKH.AGREEMENT_NUMBER = "AGREEMENT_NUMBER"; xCBlKH.STATUS = "STATUS"; xCBlKH.BUYER = "BUYER"; xCBlKH.SUPPLIER = "SUPPLIER"; xCBlKH.SUPPLIER_SITE = "SUPPLIER_SITE"; xCBlKH.SUPPLIER_CODE = "SUPPLIER_CODE"; xCBlKH.COMUNICATION_METHOD = "COMUNICATION_METHOD"; xCBlKH.E_MAIL = "E_MAIL"; xCBlKH.START_DATE = "START_DATE"; xCBlKH.END_DATE = "END_DATE"; xCBlKH.AGREEMENT_AMT = "AGREEMENT_AMT"; xCBlKH.MIN_RELEASE_AMT = "MIN_RELEASE_AMT"; xCBlKH.RELEASE_AMT = "RELEASE_AMT"; xCBlKH.DESCRIPTION = "DESCRIPTION"; xCBlKH.LAST_UPDATE_DATE = "LAST_UPDATE_DATE"; xCBlKH.CREATION_DATE = "CREATION_DATE"; xCBlKH.PO_HEADER_ID = "PO_HEADER_ID"; xCBlKH.table = "XCUST_BLANKET_AGREEMENT_HEADER_TBL"; }
public String insertxCBlKH(XcustBlanketHeaderTbl b) { String sql = "", chk = ""; if (selectDupPk(b.POCUMENT_BU.Replace("|", ","), b.AGREEMENT_NUMBER, b.PO_HEADER_ID)) { deletexCBlKH(b.POCUMENT_BU.Replace("|", ","), b.AGREEMENT_NUMBER, b.PO_HEADER_ID); } chk = insert(b); return(chk); }
private void initConfig() { xCBHT = new XcustBlanketHeaderTbl(); xCBHT.LAST_UPDATE_DATE = "LAST_UPDATE_DATE"; xCBHT.POCUMENT_BU = ""; xCBHT.AGREEMENT_NUMBER = ""; xCBHT.STATUS = ""; xCBHT.BUYER = ""; xCBHT.SUPPLIER = ""; xCBHT.SUPPLIER_SITE = ""; xCBHT.SUPPLIER_CODE = ""; xCBHT.COMUNICATION_METHOD = ""; xCBHT.E_MAIL = ""; xCBHT.START_DATE = ""; xCBHT.END_DATE = ""; xCBHT.AGREEMENT_AMT = ""; xCBHT.MIN_RELEASE_AMT = ""; xCBHT.RELEASE_AMT = ""; xCBHT.DESCRIPTION = ""; xCBHT.LAST_UPDATE_DATE = ""; xCBHT.CREATION_DATE = ""; xCBHT.PO_HEADER_ID = ""; }
public void setXcustBlkHTbl(MaterialListView lv1, Form form1, MaterialProgressBar pB1) { String uri = "", dump = ""; //HttpWebRequest request = CreateWebRequest(); XmlDocument soapEnvelopeXml = new XmlDocument(); const Int32 BufferSize = 128; String[] filePO; addListView("setXcustBlkHTbl ", "Web Service", lv1, form1); //filePO = Cm.getFileinFolder(Cm.initC.PathZip); //String text = System.IO.File.ReadAllText(filePO[0]); //byte[] byteArraytext = Encoding.UTF8.GetBytes(text); //byte[] toEncodeAsBytestext = System.Text.ASCIIEncoding.ASCII.GetBytes(text); //String Arraytext = System.Convert.ToBase64String(toEncodeAsBytestext); //< soapenv:Envelope xmlns:soapenv = "http://schemas xmlsoap org/soap/envelope/" xmlns: v2 = "http://xmlns oracle com/oxp/service/v2" > uri = @" <soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/' xmlns:pub='http://xmlns.oracle.com/oxp/service/PublicReportService'> " + "<soapenv:Header/> " + "<soapenv:Body> " + "<v2:runReport> " + "<v2:reportRequest> " + "<v2:attributeLocale>en-US</v2:attributeLocale> " + "<v2:attributeTemplate>XCUST_BLANKET_AGREEMENT_REP</v2:attributeTemplate> " + "<v2:reportAbsolutePath>/Custom/XCUST_CUSTOM/XCUST_BLANKET_AGREEMENT_REP.xdo</v2:reportAbsolutePath> " + "<pub:parameterNameValues> " + "<pub:item>" + "<pub:multiValuesAllowed>False</pub:multiValuesAllowed> " + "<pub:name>p_update_from</pub:name> " + //PARAMETER : p_update_from "<pub:values>" + "<pub:item>" + Cm.initC.p_update_from + "</pub:item> " + "</pub:values> " + "</pub:item> " + "<pub:item> " + "<pub:multiValuesAllowed>False</pub:multiValuesAllowed> " + "<pub:name>p_update_to</pub:name> " + //PARAMETER : p_update_to "<pub:values> " + "<pub:item>" + Cm.initC.p_update_to + "</pub:item> " + "</pub:values> " + "</pub:item> " + "</pub:parameterNameValues> " + "</v2:reportRequest> " + "<v2:userID>" + Cm.initC.usercloud + "</v2:userID> " + //username "<v2:password>" + Cm.initC.passcloud + "</v2:password> " + //password "</v2:runReport> " + "</soapenv:Body> " + "</soapenv:Envelope> "; //byte[] byteArray = Encoding.UTF8.GetBytes(envelope); byte[] byteArray = Encoding.UTF8.GetBytes(uri); addListView("setXcustBlkHTbl Start", "Web Service", lv1, form1); // Construct the base 64 encoded string used as credentials for the service call byte[] toEncodeAsBytes = System.Text.ASCIIEncoding.ASCII.GetBytes(Cm.initC.usercloud + ":" + Cm.initC.passcloud); string credentials = System.Convert.ToBase64String(toEncodeAsBytes); // Create HttpWebRequest connection to the service HttpWebRequest request1 = (HttpWebRequest)WebRequest.Create("https://eglj.fa.us2.oraclecloud.com/xmlpserver/services/PublicReportService"); // Configure the request content type to be xml, HTTP method to be POST, and set the content length request1.Method = "POST"; request1.ContentType = "text/xml;charset=UTF-8"; request1.ContentLength = byteArray.Length; // Configure the request to use basic authentication, with base64 encoded user name and password, to invoke the service. request1.Headers.Add("Authorization", "Basic " + credentials); // Set the SOAP action to be invoked; while the call works without this, the value is expected to be set based as per standards request1.Headers.Add("SOAPAction", "https://eglj.fa.us2.oraclecloud.com/xmlpserver/services/PublicReportService"); // Write the xml payload to the request Stream dataStream = request1.GetRequestStream(); dataStream.Write(byteArray, 0, byteArray.Length); dataStream.Close(); addListView("setXcustBlKHTbl Request", "Web Service", lv1, form1); // Get the response and process it; In this example, we simply print out the response XDocument doc; string actNumber = ""; XDocument doc; using (WebResponse response = request1.GetResponse()) { addListView("setXcustBlKHTbl Response", "Web Service", lv1, form1); using (Stream stream = response.GetResponseStream()) { doc = XDocument.Load(stream); foreach (XNode node in doc.DescendantNodes()) { if (node is XElement) { XElement element = (XElement)node; if (element.Name.LocalName.Equals("reportBytes")) { actNumber = element.ToString().Replace(@"<ns1:reportBytes xmlns:ns1=""http://xmlns.oracle.com/oxp/service/PublicReportService"">", ""); actNumber = actNumber.Replace("</reportBytes>", "").Replace("</result>", "").Replace(@"""", "").Replace("<>", ""); actNumber = actNumber.Replace("<reportBytes>", "").Replace("</ns1:reportBytes>", ""); } } } } } actNumber = actNumber.Trim(); actNumber = actNumber.IndexOf("<reportContentType>") >= 0 ? actNumber.Substring(0, actNumber.IndexOf("<reportContentType>")) : actNumber; addListView("setXcustBlKHTbl Extract html", "Web Service", lv1, form1); byte[] data = Convert.FromBase64String(actNumber); string decodedString = Encoding.UTF8.GetString(data); //XElement html = XElement.Parse(decodedString); //string[] values = html.Descendants("table").Select(td => td.Value).ToArray(); //int row = -1; //var doc1 = new HtmlAgilityPack.HtmlDocument(); //doc1.LoadHtml(html.ToString()); //var nodesTable = doc1.DocumentNode.Descendants("tr"); String[] data1 = decodedString.Split('\n'); //foreach (var nodeTr in nodesTable) for (int row = 0; row < data1.Length; row++) { if (row == 0) { continue; } if (data1[row].Length <= 0) { continue; } String[] data2 = data1[row].Split(','); XcustBlanketHeaderTbl item = new XcustBlanketHeaderTbl(); item.POCUMENT_BU = data2[0].Trim().Replace("\"", ""); item.BUYER = data2[1].Trim().Trim().Replace("\"", ""); item.SUPPLIER_CODE = data2[2].Trim().Trim().Replace("\"", ""); item.STATUS = data2[3].Trim().Trim().Replace("\"", ""); item.LAST_UPDATE_DATE = data2[4].Trim().Trim().Replace("\"", ""); item.CREATION_DATE = data2[5].Trim().Trim().Replace("\"", ""); item.AGREEMENT_AMT = data2[6].Trim().Equals("") ? "0" : data2[6].Trim(); item.MIN_RELEASE_AMT = data2[7].Trim().Equals("") ? "0" : data2[7].Trim(); item.E_MAIL = data2[8].Trim().Trim().Replace("\"", ""); item.AGREEMENT_NUMBER = data2[9].Trim().Trim().Replace("\"", ""); item.SUPPLIER = data2[10].Trim().Trim().Replace("\"", ""); item.SUPPLIER_SITE = data2[11].Trim().Trim().Replace("\"", ""); item.COMUNICATION_METHOD = data2[12].Trim().Trim().Replace("\"", ""); item.DESCRIPTION = data2[13].Trim().Trim().Replace("\"", ""); item.START_DATE = data2[14].Trim().Trim().Replace("\"", ""); item.END_DATE = data2[15].Trim().Trim().Replace("\"", ""); item.PO_HEADER_ID = data2[16].Trim().Equals("") ? "0" : data2[16].Trim(); item.RELEASE_AMT = "0"; //item.LAST_UPDATE_DATE = xCBlkHDB.xCBlKH.dateTimeYearToDB1(data2[0].Trim()); //item.CREATION_DATE = xCBlkHDB.xCBlKH.dateTimeYearToDB1(data2[1].Trim()); xCBlkHDB.insertxCBlKH(item); } Console.WriteLine(decodedString); }