public void insertLog(string msgType, int msg_idnum, int EDI_idnum, int Detail_idnum, string logMsg)
{
if (dbConnectionCheck())
{
using (DBContext context = new DBContext())
{
Engines_Log dbLog = new Engines_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.Engines_Log.Add(dbLog);
context.SaveChanges();
context.Dispose();
}
}
else
{
logMsg += "\r\nValues Info:";
logMsg += "\r\nmstType: " + msgType;
if (msg_idnum != 0)
{
logMsg += "\r\nmsg_idnum: " + msg_idnum;
}
if (EDI_idnum != 0)
{
logMsg += "\r\nEDI_idnum: " + EDI_idnum;
}
if (Detail_idnum != 0)
{
logMsg += "\r\nDetail_idnum: " + Detail_idnum;
}
insertLog_TextFile(msgType, msg_idnum, EDI_idnum, Detail_idnum, logMsg);
}
}
/// <summary>
/// Insert log messages to the DB
/// </summary>
/// <param name="msgType"></param>
/// <param name="msg_idnum"></param>
/// <param name="EDI_idnum"></param>
/// <param name="Detail_idnum"></param>
/// <param name="logMsg"></param>
public void insertLog_DB(string msgType, int msg_idnum, int EDI_idnum, int Detail_idnum, string logMsg)
{
if (checkDBConnection())
{
using (DBContext context = new DBContext())
{
Engines_Log DBLog = new Engines_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.Engines_Log.Add(DBLog);
context.SaveChanges();
context.Dispose();
}
}
}
