private string GetXmlHeader(OVRDataChanged changedItem, string strType) { if (changedItem == null) { return(null); } return(GetXmlHeader(changedItem.DisciplineID, changedItem.EventID , changedItem.PhaseID, changedItem.MatchID, strType)); }
public string GetXmlMessage(OVRDataChanged changedItem) { if (m_sqlCon == null || changedItem == null) { return(null); } if (changedItem.Data != null) { string strHeader = GetXmlHeader(changedItem, "DATA"); if (strHeader == null) { return(null); } string strDataMessage = strHeader.Replace("</Message>", "<Data>" + changedItem.Data + "</Data>" + "</Message>"); try { m_xmlDoc.LoadXml(strDataMessage); } catch (System.Exception ex) { return(null); } return("<!--OVR_DATA-->\n" + m_xmlDoc.InnerXml); } else { string strHeader = GetXmlHeader(changedItem, "NOTIFY"); if (strHeader == null) { return(null); } m_xmlDoc.LoadXml(strHeader); AppendDocElement(m_xmlDoc, changedItem); return("<!--OVR_NOTIFY-->\n" + m_xmlDoc.InnerXml); } }
private void AppendDocElement(XmlDocument xmlDoc, OVRDataChanged item) { this.m_cmdGetFullId.Parameters[0].Value = item.DisciplineID; this.m_cmdGetFullId.Parameters[1].Value = item.EventID; this.m_cmdGetFullId.Parameters[2].Value = item.PhaseID; this.m_cmdGetFullId.Parameters[3].Value = item.MatchID; SqlDataReader sdr = this.m_cmdGetFullId.ExecuteReader(); if (sdr.FieldCount == 4) { if (sdr.Read()) { item.DisciplineID = Convert.ToInt32(Convert.ToString(sdr[3])); item.EventID = Convert.ToInt32(Convert.ToString(sdr[2])); item.PhaseID = Convert.ToInt32(Convert.ToString(sdr[1])); item.MatchID = Convert.ToInt32(Convert.ToString(sdr[0])); } } sdr.Close(); XmlNode node = xmlDoc.CreateNode(XmlNodeType.Element, "Item", null); // If Data Changed is about a Match, Set Session ID and Court ID. int iSessionID = -1, iCourtID = -1; bool bCanGetID = Can_Get_Session_Court_ID(item.Type); if (bCanGetID && item.MatchID != -1) { Get_Session_Court_ID(item.MatchID, out iSessionID, out iCourtID); } // F_Type XmlAttribute attr = xmlDoc.CreateAttribute("NotifyType"); attr.Value = GetDataChangedType(item.Type); node.Attributes.Append(attr); // DisciplineID attr = xmlDoc.CreateAttribute("DisciplineID"); attr.Value = item.DisciplineID.ToString(); node.Attributes.Append(attr); // EventID attr = xmlDoc.CreateAttribute("EventID"); attr.Value = item.EventID.ToString(); node.Attributes.Append(attr); // PhaseID attr = xmlDoc.CreateAttribute("PhaseID"); attr.Value = item.PhaseID.ToString(); node.Attributes.Append(attr); // MatchID attr = xmlDoc.CreateAttribute("MatchID"); attr.Value = item.MatchID.ToString(); node.Attributes.Append(attr); // SessionID attr = xmlDoc.CreateAttribute("SessionID"); if (item.Type == OVRDataChangedType.emSessionAdd || item.Type == OVRDataChangedType.emSessionDel || item.Type == OVRDataChangedType.emSessionInfo || item.Type == OVRDataChangedType.emMatchSessionSet || item.Type == OVRDataChangedType.emMatchSessionReset) { attr.Value = item.ID.ToString(); } else if (bCanGetID) { attr.Value = iSessionID.ToString(); } else { attr.Value = "-1"; } node.Attributes.Append(attr); // CourtID attr = xmlDoc.CreateAttribute("CourtID"); if (item.Type == OVRDataChangedType.emCourtAdd || item.Type == OVRDataChangedType.emCourtDel || item.Type == OVRDataChangedType.emCourtInfo || item.Type == OVRDataChangedType.emMatchCourtSet || item.Type == OVRDataChangedType.emMatchCourtReset) { attr.Value = item.ID.ToString(); } else if (bCanGetID) { attr.Value = iCourtID.ToString(); } else { attr.Value = "-1"; } node.Attributes.Append(attr); // Add to XmlDocument xmlDoc.DocumentElement.AppendChild(node); }