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 } }