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.insertLog("315", 0, 0, 0, logMsg);
}
}
catch (DbEntityValidationException ex)
{
string logMsg = "Function: getMessages\r\nError Message: " + ex.Message;
util.insertLog("315", 0, 0, 0, logMsg);
}
catch (Exception ex)
{
string logMsg = "Function: getMessages\r\nError Message: " + ex.ToString();
util.insertLog("315", 0, 0, 0, logMsg);
list = new List <EDI_Messages>();
}
return(list);
}
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: MeesageParsing - Table EDI315\r\n";
logMsg += "Error Message: Not able to access DB. Process rollbacked.\r\n";
util.insertLog("315", msg_idnum, dbEDI315.EDI315_idnum, 0, logMsg);
}
}
catch (Exception ex)
{
util.insertLog("315", 0, 0, 0, ex.ToString());
list = new List <EDI_Messages>();
}
return(list);
}
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
{
}
}
catch (Exception ex)
{
util.insertLog("315", 0, 0, 0, ex.ToString());
list = new List <EDI_Messages>();
}
return(list);
}
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);
}
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.insertLog("315", 0, 0, 0, logMsg);
}
}
catch (DbEntityValidationException ex)
{
string logMsg = "Function: updateMSGStatus\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";
}
}
}
catch (DbEntityValidationException ex)
{
string logMsg = "Function: getMessages\r\nError Message: " + ex.Message;
util.insertLog("315", 0, 0, 0, logMsg);
}
catch (Exception ex)
{
string logMsg = "Function: getMessages\r\nError Message: " + ex.ToString();
util.insertLog("315", 0, 0, 0, logMsg);
list = new List <EDI_Messages>();
}
return(list);
}
