static public _Recordset GetRecordsetFromXml(string xml)
{
_Stream stream = null;
try
{
stream = new ADODB.Stream();
stream.Open(Missing.Value, ConnectModeEnum.adModeUnknown, StreamOpenOptionsEnum.adOpenStreamUnspecified, "", "");
stream.WriteText(xml, StreamWriteEnum.adWriteChar);
stream.Position = 0;
var recordset = new Recordset();
recordset.Open(stream, Missing.Value, CursorTypeEnum.adOpenUnspecified, LockTypeEnum.adLockUnspecified, 0);
return(recordset);
}
catch (Exception ex)
{
ErrorLog.LogError(ex, new CallingMethod());
return(default(_Recordset));
}
finally
{
if (stream != null)
{
Marshal.ReleaseComObject(stream);
}
}
}
/// <summary>
/// Save Picture to DB
/// </summary>
/// <param name="rsFields">Data row</param>
/// <param name="sFileName">File name</param>
/// <returns>True or false</returns>
private dynamic SavePictureToDb(DataRow rsFields, string sFileName)
{
bool returnValue = false;
ADODB.Stream strStream = new ADODB.Stream();
try
{
if (!File.Exists(sFileName))
{
return(false);
}
strStream = new ADODB.Stream {
Type = StreamTypeEnum.adTypeBinary
};
strStream.Open();
strStream.LoadFromFile(sFileName);
rsFields["Signature"] = strStream.Read();
returnValue = true;
}
catch (Exception)
{
// ignored
}
finally
{
strStream.Close();
}
return(returnValue);
}
public EML()
{
msg = new CDO.Message();
stm = new ADODB.Stream();
stm.Open(System.Reflection.Missing.Value,
ADODB.ConnectModeEnum.adModeUnknown,
ADODB.StreamOpenOptionsEnum.adOpenStreamUnspecified,
"", "");
stm.Type = ADODB.StreamTypeEnum.adTypeBinary;
}
//Useless -> NON ho idea di come usarla correttamente
public static Message ReadMessage(string emlFileName)
{
Message msg = new Message();
ADODB.Stream stream = new ADODB.Stream();
stream.Open(Type.Missing, ConnectModeEnum.adModeUnknown, StreamOpenOptionsEnum.adOpenStreamUnspecified, string.Empty, string.Empty);
stream.LoadFromFile(emlFileName);
stream.Flush();
msg.DataSource.OpenObject(stream, "_Stream");
msg.DataSource.Save();
return(msg);
}
private CDO.Message GetMessage(FileInfo fileInfo)
{
CDO.Message msg = new CDO.Message();
ADODB.Stream stream = new ADODB.Stream();
stream.Type = StreamTypeEnum.adTypeBinary;
stream.Open(Type.Missing, ADODB.ConnectModeEnum.adModeUnknown, ADODB.StreamOpenOptionsEnum.adOpenStreamUnspecified, String.Empty, String.Empty);
stream.LoadFromFile(fileInfo.FullName);
stream.Flush();
msg.DataSource.OpenObject(stream, "_Stream");
msg.DataSource.Save();
return(msg);
}