private void UpdateMsgStatus(int msg_idnum, string msgType, string status)
{
try
{
if (util.checkDBConnection())
{
using (DBContext context = new DBContext())
{
EDI_Messages dbEdiMsg = context.EDI_Messages.Where(x => x.msg_idnum == msg_idnum).FirstOrDefault();
if (dbEdiMsg != null && dbEdiMsg.msg_idnum != 0)
{
dbEdiMsg.process_status = status;
context.SaveChanges();
}
/* DB context. END. */
context.Dispose();
}
}
else
{
string logMsg = "Date: " + DateTime.Now.ToString();
logMsg += "\r\nFunction: updateMSGStatus";
logMsg += "\r\nError Message: Not able to access DB.";
logMsg += "\r\n\r\n=====================================================================";
logMsg += "=============================================================================";
logMsg += "=============================================================================";
util.insertLog_text(logMsg);
}
}
catch (DbEntityValidationException ex)
{
#region Exception
string logMsg = "Date: " + DateTime.Now.ToString();
logMsg += "\r\nFunction: updateMSGStatus";
logMsg += "\r\nError Message: ";
foreach (DbEntityValidationResult item in ex.EntityValidationErrors)
{
// Get entry
DbEntityEntry entry = item.Entry;
string entityTypeName = entry.Entity.GetType().Name;
foreach (DbValidationError subItem in item.ValidationErrors)
{
logMsg += string.Format("\r\nError '{0}' occurred in {1} at {2}", subItem.ErrorMessage, entityTypeName, subItem.PropertyName);
}
}
util.insertLog_DB(msgType, msg_idnum, 0, 0, logMsg);
#endregion
}
catch (Exception ex)
{
#region Exception
string logMsg = "Date: " + DateTime.Now.ToString();
logMsg += "\r\nFunction: updateMSGStatus";
logMsg += "\r\nError Message: \r\n";
logMsg += ex.ToString();
util.insertLog_DB(msgType, msg_idnum, 0, 0, logMsg);
#endregion
}
}
