public string GenerateXml(Scheme scheme, LRSRecord record)
{
MemoryStream ms = new MemoryStream();
XmlWriter xw = XmlWriter.Create(ms);
xw.WriteStartDocument();
xw.WriteStartElement("item");
if (scheme != null)
{
foreach (SchemeRecord col in scheme)
{
xw.WriteStartElement(col.ColumnName);
string value = record.Columns.SingleOrDefault(x => x.Key.Equals(col.ColumnName)).Value;
xw.WriteString(value);
xw.WriteEndElement();
}
}
xw.WriteEndElement();
xw.WriteEndDocument();
xw.Flush();
Byte[] buffer = new Byte[ms.Length];
buffer = ms.ToArray();
string xmlOutput = Encoding.UTF8.GetString(buffer);
return xmlOutput;
}
public bool Contains(LRSRecord item)
{
return this.List.Contains(item);
}
public int Add(LRSRecord item)
{
return this.List.Add(item);
}
public LRSRecords GetSegmentLRSSummary(int schemeId, int segmentId)
{
LRSRecords records = new LRSRecords();
LRSRecord record;
using (SqlCommand command = new SqlCommand("[RTP].[GetSegmentLRSSummaryData]") { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@LRSSchemeId", schemeId);
command.Parameters.AddWithValue("@SegmentId", segmentId);
using (IDataReader rdr = ExecuteReader(command))
{
while (rdr.Read())
{
record = new LRSRecord() { Columns = new Dictionary<string, string>() };
record.Id = rdr["Id"].ToString().SmartParseDefault<int>(default(int));
record.Columns.Add("Routename", rdr["Routename"].ToString());
record.Columns.Add("BEGINMEASU", rdr["BEGINMEASU"].ToString());
record.Columns.Add("ENDMEASURE", rdr["ENDMEASURE"].ToString());
record.Scheme = GetLRSScheme(schemeId);
records.Add(record);
//if (record.Id.Equals(default(int))) { record.Id = rdr["Id"].ToString().SmartParseDefault<int>(default(int)); }
//record.Columns.Add(rdr["NodeName"].ToString(), rdr["Value"].ToString());
}
}
}
return records;
}
public LRSRecord GetSegmentLRSData(int schemeId, int LRSId)
{
LRSRecord record = new LRSRecord() { Columns = new Dictionary<string, string>() };
using (SqlCommand command = new SqlCommand("[RTP].[GetSegmentLRSData]") { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@LRSSchemeId", schemeId);
command.Parameters.AddWithValue("@LRSId", LRSId);
using (IDataReader rdr = ExecuteReader(command))
{
while (rdr.Read())
{
if (record.Id.Equals(default(int))) { record.Id = rdr["Id"].ToString().SmartParseDefault<int>(default(int)); }
record.Columns.Add(rdr["NodeName"].ToString(), rdr["Value"].ToString());
}
}
record.Scheme = GetLRSScheme(schemeId);
}
return record;
}