private List <EDI_Messages> getMessages()
{
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 == "315" && x.process_status == "N").ToList();
context.Dispose();
}
}
else
{
string logMsg = "Function: getMessages\r\n";
logMsg += "Error Message: Not able to access DB.\r\n";
util.insetLog_TextFile("315", 0, 0, 0, logMsg);
}
}
catch (DbEntityValidationException ex)
{
string logMsg = "Function: getMessages\r\n";
logMsg += "Error Message:\r\n";
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("Error '{0}' occurred in {1} at {2}", subItem.ErrorMessage, entityTypeName, subItem.PropertyName) + "\r\n";
}
}
util.insertLog("315", 0, 0, 0, logMsg);
}
catch (Exception ex)
{
string logMsg = "Function: getMessages\r\nError Message: \r\n" + ex.ToString();
util.insertLog("315", 0, 0, 0, logMsg);
list = new List <EDI_Messages>();
}
return(list);
}
