public void insertLog(string msgType, int msg_idnum, int EDI_idnum, int Detail_idnum, string logMsg)
{
if (dbConnectionCheck())
{
using (DBContext context = new DBContext())
{
Engine_Log dbLog = new Engine_Log()
{
msg_type = msgType,
msg_idnum = (msg_idnum != 0 ? (int?)msg_idnum : null),
EDI_idnum = (EDI_idnum != 0 ? (int?)EDI_idnum : null),
Detail_idnum = (Detail_idnum != 0 ? (int?)Detail_idnum : null),
log_msg = logMsg,
created_date = DateTime.Now
};
context.Engine_Log.Add(dbLog);
context.SaveChanges();
context.Dispose();
}
}
else
{
insetLog_TextFile(msgType, msg_idnum, EDI_idnum, Detail_idnum, logMsg);
}
}
public void insertLog(string msgType, int msg_idnum, int EDI_idnum, int Detail_idnum, string logMsg)
{
if (dbConnectionCheck())
{
using (DBContext context = new DBContext())
{
Engine_Log dbLog = new Engine_Log()
{
msg_type = msgType,
msg_idnum = (msg_idnum != 0 ? (int?)msg_idnum : null),
EDI_idnum = (EDI_idnum != 0 ? (int?)EDI_idnum : null),
Detail_idnum = (Detail_idnum != 0 ? (int?)Detail_idnum : null),
log_msg = logMsg,
created_date = DateTime.Now
};
context.Engine_Log.Add(dbLog);
context.SaveChanges();
context.Dispose();
}
}
else
{
// create text file
FileName += DateTime.Today.ToString("yyyy_MM_dd") + ".txt";
string textHeader = "Date: " + DateTime.Now.ToString();
textHeader += "\r\nmstType: " + msgType;
textHeader += "\r\nmsg_idnum: ";
if (msg_idnum != 0)
{
textHeader += msg_idnum;
}
textHeader += "\r\nEDI_idnum: ";
if (EDI_idnum != 0)
{
textHeader += EDI_idnum;
}
textHeader += "\r\nDetail_idnum: ";
if (Detail_idnum != 0)
{
textHeader += Detail_idnum;
}
logMsg = textHeader + "\r\n" + "Error msg: " + logMsg + "\r\n";
logMsg += "\r\n\r\n";
string filePathName = Path.Combine(FileLocation, FileName);
if (!Directory.Exists(FileLocation))
{
Directory.CreateDirectory(FileLocation);
}
if (!File.Exists(filePathName))
{
StreamWriter sw = File.CreateText(filePathName);
sw.Close();
}
using (StreamWriter sw = new StreamWriter(filePathName, true, Encoding.GetEncoding("iso-8859-1")))
{
sw.Write(logMsg);
sw.Close();
}
}
}