private List <TSCSingers> GetSingerList(SingingClub sc)
{
List <TSCSingers> list = new List <TSCSingers>();
string xml = sc.GeneralStore(TableName.TSCSingers, TableAction.GET, (new TSCSingers().GetDataXml()));
if (xml.Trim().Length > 0)
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
XmlNodeList nodes = doc.SelectNodes("/Root/Data");
foreach (XmlNode node in nodes)
{
TSCSingers singers = new TSCSingers(node);
list.Add(singers);
}
}
return(list);
}
private MvcList GetEvents(SingingClub sc)
{
MvcList list = new MvcList();
string xml = _eventsxml = sc.GeneralStore(TableName.TSCEvents, TableAction.GET, (new TSCEvents().GetDataXml()));
if (xml.Trim().Length > 0)
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
XmlNodeList nodes = doc.SelectNodes("/Root/Data");
foreach (XmlNode node in nodes)
{
TSCEvents events = new TSCEvents(node);
list.Add(events);
}
}
return(list);
}
private List <TSCQueue> GetQueueList(SingingClub sc)
{
List <TSCQueue> list = new List <TSCQueue>();
TSCQueue q = new TSCQueue();
q.QueueRound = -1;
string xml = sc.GeneralStore(TableName.TSCQueue, TableAction.GET, (new TSCQueue().GetDataXml()));
if (xml.Trim().Length > 0)
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
XmlNodeList nodes = doc.SelectNodes("/Root/Data");
foreach (XmlNode node in nodes)
{
TSCQueue queues = new TSCQueue(node);
list.Add(queues);
}
}
return(list);
}
private void DeleteQueue(TSCQueue remote, SingingClub scRemote)
{
_sb.AppendLine(string.Format("Delete: {0}.{1}.{2}", remote.EventKey, remote.SingerKey, remote.QueueRound));
scRemote.GeneralStore(TableName.TSCQueue, TableAction.DELETE, remote.GetDataXml());
}
private void InsertQueue(TSCQueue local, SingingClub scRemote)
{
_sb.AppendLine(string.Format("Insert: {0}.{1}.{2}", local.EventKey, local.SingerKey, local.QueueRound));
scRemote.GeneralStore(TableName.TSCQueue, TableAction.INSERT, local.GetDataXml());
}
private void UpdateQueue(TSCQueue local, TSCQueue remote, SingingClub scRemote)
{
_sb.AppendLine(string.Format("Update: {0}.{1}.{2}", local.EventKey, local.SingerKey, local.QueueRound));
scRemote.GeneralStore(TableName.TSCQueue, TableAction.UPDATE, local.GetDataXml());
}
private void DeleteSinger(TSCSingers remote, SingingClub scRemote)
{
_sb.AppendLine(string.Format("Delete: {0}", remote.SingerKey));
scRemote.GeneralStore(TableName.TSCSingers, TableAction.DELETE, remote.GetDataXml());
}
private void InsertSinger(TSCSingers local, SingingClub scRemote)
{
_sb.AppendLine(string.Format("Insert: {0}", local.SingerKey));
scRemote.GeneralStore(TableName.TSCSingers, TableAction.INSERT, local.GetDataXml());
}
private void UpdateSinger(TSCSingers local, TSCSingers remote, SingingClub scRemote)
{
_sb.AppendLine(string.Format("Update: {0}", local.SingerKey));
scRemote.GeneralStore(TableName.TSCSingers, TableAction.UPDATE, local.GetDataXml());
}
