public static void InsertSIHOT_ResStart(SIHOT value) { //Hotel Poperty SqlParameter[] param = new SqlParameter[] { new SqlParameter("@TN", value.TN), new SqlParameter("@OC", value.OC), new SqlParameter("@HN", value.HN), new SqlParameter("@RC", value.RC) }; SqlHelper.ExecuteNonQuery(Helper.ConnectionString, CommandType.StoredProcedure, "insert_tblComm_SIHOT", param); }
private void ProcessRequestXML(string strFileName) { System.Xml.XmlDocument Document = new XmlDocument(); StringBuilder sb = new StringBuilder(strFileName); sb = sb.Replace(sb.ToString(), CleanInput(sb.ToString())); Document.LoadXml(sb.ToString()); XmlNodeList dispatchs = Document.GetElementsByTagName("SIHOT-Document"); // Parse the Dispatch nodes and place data into a class for later processing SIHOT dd = new SIHOT(); foreach (XmlNode n in dispatchs) { dd.OC = n.SelectSingleNode("descendant::OC").InnerText; dd.TN = n.SelectSingleNode("descendant::TN").InnerText; dd.RC = n.SelectSingleNode("descendant::STATUS").InnerText; dd.HN = m_hn; } //Save the value SIHOT_dB.InsertSIHOT_ResStart(dd); }
private void ProcessReadXMLValue(string strFileName) { System.Xml.XmlDocument Document = new XmlDocument(); Document.LoadXml(strFileName); //For Each n As XmlNode In Document.SelectSingleNode("SIHOT-Document").ChildNodes // lblError.Text += n.InnerText + "/r/n" //Next XmlNodeList dispatchs = Document.GetElementsByTagName("SIHOT-Document"); // Parse the Dispatch nodes and place data into a class for later processing SIHOT dd = new SIHOT(); foreach (XmlNode n in dispatchs) { dd.OC = n.SelectSingleNode("descendant::OC").InnerText; dd.TN = n.SelectSingleNode("descendant::TN").InnerText; dd.RC = n.SelectSingleNode("descendant::RC").InnerText; dd.HN = m_hn; } //Save the value SIHOT_dB.InsertSIHOT_ResStart(dd); }