private List <EDI_Messages> getMessages(string msgType) { List <EDI_Messages> list = new List <EDI_Messages>(); try { if (util.dbConnectionCheck()) { using (DBContext context = new DBContext()) { list = context.EDI_Messages.Where(x => x.msg_type == msgType && x.process_status == "N").ToList(); /* DB context. END. */ context.Dispose(); } } else { string logMsg = "Date: " + DateTime.Now.ToString(); logMsg += "\r\nFunction: getMessages"; logMsg += "\r\nError Message: Not able to access DB."; util.insertLog_TextFile(msgType, 0, 0, 0, logMsg); } } catch (DbEntityValidationException ex) { string logMsg = "Date: " + DateTime.Now.ToString(); logMsg += "\r\nFunction: getMessages"; 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(msgType, 0, 0, 0, logMsg); } catch (Exception ex) { string logMsg = "Date: " + DateTime.Now.ToString(); logMsg += "\r\nFunction: getMessages"; logMsg += "\r\nError Message: \r\n"; logMsg += ex.ToString(); util.insertLog(msgType, 0, 0, 0, logMsg); list = new List <EDI_Messages>(); } return(list); }