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);
}
