public bool SaveXMLToData(List <ExportRecordData> listExportData)
{
XmlDocument xmlDoc = new XmlDocument(); //Represents an XML document,
// Initializes a new instance of the XmlDocument class.
XmlSerializer xmlSerializer = new XmlSerializer(listExportData.GetType());
// Creates a stream whose backing store is memory.
using (MemoryStream xmlStream = new MemoryStream())
{
xmlSerializer.Serialize(xmlStream, listExportData);
xmlStream.Position = 0;
//Loads the XML document from the specified string.
xmlDoc.Load(xmlStream);
ExportRecordXML ERX = new ExportRecordXML();
ERX.XMLData = xmlDoc.InnerXml;//.ToString();
ERX.IsSchedular = false;
if (RecordService.SaveXMLToData(ERX))
{
return(true);
}
return(false);
//return xmlDoc.InnerXml;
}
}
/// <summary>
/// Save XML Data for record download
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static bool SaveXMLToData(ExportRecordXML xml)
{
try
{
using (var context = new TSMContext())
{
//var xmlRecordID = context.ExportRecordXML.Select(a => a.ID).FirstOrDefault();
//context.ExportRecordXML.D.Delete(w => w.ID == xmlRecordID);
var all = from c in context.ExportRecordXML select c;
context.ExportRecordXML.RemoveRange(all);
//context.Entry(xml).State = EntityState.Deleted;
context.ExportRecordXML.Add(xml);
//Save to DB
context.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public List <ExportRecordData> DataToList()
{
ExportRecordXML ERD = RecordService.GetListXML();
string XMLString = ERD.XMLData.ToString();
List <ExportRecordData> objERD = new List <ExportRecordData>();
XmlSerializer oXmlSerializer = new XmlSerializer(objERD.GetType());
//The StringReader will be the stream holder for the existing XML file
objERD = (List <ExportRecordData>)oXmlSerializer.Deserialize(new StringReader(XMLString));
//initially deserialized, the data is represented by an object without a defined type
return(objERD);
}
public static ExportRecordXML GetListXML()
{
try
{
ExportRecordXML Xmlrecord = new ExportRecordXML();
using (var context = new TSMContext())
{
Xmlrecord = context.ExportRecordXML.FirstOrDefault();
}
return(Xmlrecord);
}
catch (Exception)
{
throw;
}
}
