// private bool getEmailDistributionListSendAttachment(bool isSuccessful, string fileName, string threadName, string desFilePath)
private bool getIMSEmailDistributionList(int Report,
string fileName,
string desFilePath,
string ThreadName,
System.Collections.Hashtable DetailsForIMS,
IAPL.Transport.Transactions.MessageDetails mDetails)
{
bool success = true;
IAPL.Transport.Transactions.ServerDetails emailDetails = new ServerDetails();
IAPL.Transport.Data.DbTransaction db = new IAPL.Transport.Data.DbTransaction();
db.emailDistributionList(true, mDetails.MessageCode, mDetails.ERP, Report);
System.Data.DataTable dTable = db.CommonDataTable;
string emailSMTP = IAPL.Transport.Configuration.Config.GetAppSettingsValue("emailnotificationsmtp", "");
if (dTable != null)
{
foreach (System.Data.DataRow row in dTable.Rows)
{
IAPL.Transport.Operation.Email email = new IAPL.Transport.Operation.Email(
IAPL.Transport.Util.CommonTools.ValueToString((Object)row["IMSemldIntEmailAddrFROM"]),
IAPL.Transport.Util.CommonTools.ValueToString((Object)row["IMSemldIntEmailAddrTO"]),
IAPL.Transport.Util.CommonTools.ValueToString((Object)row["IMSemldIntEmailAddrCC"]),
IAPL.Transport.Util.CommonTools.ValueToString((Object)row["IMSemldIntEmailAddrBCC"]),
IAPL.Transport.Util.CommonTools.ValueToString((Object)row["IMSemldEmailSubject"]),
2,
emailSMTP);
string mesgBody = this.IMSreadNoticationMessageBody(Report, success,
IAPL.Transport.Util.CommonTools.ValueToString((Object)row["IMSemldXSLTPath"]),
DetailsForIMS,
mDetails.IMSBatchRun);
// Email this!
//success = email.Send(true, mesgBody, list);
success = email.Send(false, mesgBody, null);
if (!success)
{
this.ErrorMessage = email.ErrorMessage;
}
}
}
else
{
success = false;
}
//return emailDetails;
return(success);
}
// ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
private static bool PerformEmailProcess(int Report,
string fileName,
string desFilePath,
string ThreadName,
System.Collections.Hashtable DetailsForIMS,
IAPL.Transport.Transactions.MessageDetails mDetails,
bool IMSNoFilesFound)
{
IAPL.Transport.Transactions.EmailTransaction emailTrans = new IAPL.Transport.Transactions.EmailTransaction();
emailTrans.IMSNoFilesFound = IMSNoFilesFound;
bool success = emailTrans.StartProcessIMS(Report, fileName, desFilePath, ThreadName, DetailsForIMS, mDetails);
return(success);
}
public bool StartProcessIMS(int Report,
string fileName,
string desFilePath,
string ThreadName,
System.Collections.Hashtable DetailsForIMS,
IAPL.Transport.Transactions.MessageDetails mDetails)
{
bool success = true;
success = getIMSEmailDistributionList(Report,
fileName,
desFilePath,
ThreadName,
DetailsForIMS,
mDetails);
return(success);
}
// ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
public static bool ProcessIMS(string ThreadName,
string IncFolder,
System.Collections.Hashtable IMSCompleteCountriesName,
System.Collections.Hashtable IMSIncompleteCountriesName,
IAPL.Transport.Transactions.MessageDetails mDetails,
System.Collections.Hashtable FTPFileFoundSentList,
out System.Collections.Hashtable DetailsForIMS)
{
bool success = true;
DetailsForIMS = new System.Collections.Hashtable();
if (mDetails.IndividualProcess.Equals(1))
{
IAPL.Transport.IMS.Process.IMSReportDetails IMSDetailsStruct = new IAPL.Transport.IMS.Process.IMSReportDetails();
System.Collections.Hashtable IMSData = new System.Collections.Hashtable();
// Get the country list from the database
IAPL.Transport.Data.DbTransaction db = new IAPL.Transport.Data.DbTransaction();
db.GetIMSCountries(IAPL.Transport.Util.ConstantVariables.SP_GetIMSDetails, "IMSCountries");
if (db.ErrorMessage.Trim().Length > 0)
{
success = false;
IAPL.Transport.Util.TextLogger.LogError("MessageTransaction-ProcessIMS()", "Database error: " + db.ErrorMessage);
}
else
{
System.Data.DataTable dTable = db.CommonDataTable;
if (dTable == null)
{
success = false;
}
else
{
// Set initial value
foreach (System.Data.DataRow row in dTable.Rows)
{
IMSDetailsStruct.CountryCode = IAPL.Transport.Util.CommonTools.ValueToString((Object)row["Code"]);
IMSDetailsStruct.Country = IAPL.Transport.Util.CommonTools.ValueToString((Object)row["CountryName"]);
IMSDetailsStruct.IMSDataSeq = "";
IMSDetailsStruct.SizeKB = 0;
IMSDetailsStruct.DateSent = System.DateTime.Now;
IMSDetailsStruct.ERS_Issue = "";
IMSDetailsStruct.IMSSR_Issue = "";
IMSDetailsStruct.CommentResolution = "";
IMSDetailsStruct.DataFileRecvd = "";
IMSDetailsStruct.TransactionDate = "";
IMSDetailsStruct.RecordCount = 0;
IMSDetailsStruct.IMSExtractionValue = 0;
IMSDetailsStruct.SendStatus = "";
IMSData.Add(IMSDetailsStruct.CountryCode, IMSDetailsStruct);
}
}
// Process CompleteCountriesName
foreach (System.Collections.DictionaryEntry file in (System.Collections.Hashtable)IMSCompleteCountriesName)
{
string filename = file.Value.ToString();
string CountryCode = filename.Substring(0, 3);
// ------------- Get Struct inside Hashtable then edit value(s) ---------------------
IMSReportDetails IMS = (IMSReportDetails)IMSData[CountryCode.ToUpper()];
// Version No. (both reports)
IMS.IMSDataSeq = filename.Substring(3);
// File size in KB (both reports)
string IMSFolderPath = mDetails.BackupFolder + @"\" + mDetails.IMSFolder;
long FileSize = IAPL.Transport.Util.Utility.GetFileSize_Local(IMSFolderPath + @"\" + filename + "." + Process.IMSFileExt);
IMS.SizeKB = IAPL.Transport.Util.Utility.ConvertByteToKB(FileSize);
// Date Sent (both reports)
IMS.DateSent = System.DateTime.Now;
// Open file and parse
string filereadbuf;
string IMSLogfile = IMSFolderPath + @"\" + filename + "." + Process.IMSLogExt;
int Size = (int)IAPL.Transport.Util.Utility.GetFileSize_Local(IMSLogfile);
char[] buf = new char[Size];
StreamReader sr = new StreamReader(new FileStream(IMSLogfile, FileMode.Open, FileAccess.Read));
int retval = sr.ReadBlock(buf, 0, Size);
filereadbuf = new string(buf);
sr.Close();
string[] ParsedData = IAPL.Transport.Util.Utility.ParseString(filereadbuf);
// Issue (both reports)
IMS.ERS_Issue = ParsedData[2].ToString();
IMS.IMSSR_Issue = ParsedData[2].ToString();
// Comment/Resolution (IMS Summary Report)
IMS.CommentResolution = ParsedData[3].ToString();
// Data File Received (IMS Summary Report)
if (FTPFileFoundSentList[CountryCode] != null)
{
IMS.DataFileRecvd = "Yes";
}
else
{
IMS.DataFileRecvd = "No File";
}
// Transaction Date (IMS Summary Report)
IMS.TransactionDate = ParsedData[4].ToString();
// Record Count (IMS Summary Report)
IMS.RecordCount = Convert.ToInt32(ParsedData[5].ToString());
// IMS Extraction Value (IMS Summary Report)
IMS.IMSExtractionValue = Convert.ToDouble(ParsedData[6].ToString());
// Send Status (Exception Report Summary)
if (IMS.ERS_Issue.Equals(string.Empty))
{
IMS.SendStatus = "SUCCESS";
}
else
{
IMS.SendStatus = IMS.ERS_Issue;
}
// ----------------------------------------------------------------------------------
// Update Hashtable with edited value(s)
IMSData[CountryCode] = IMS;
}
}
// Temp
string fileName = "";
string desFilePath = "";
// Email Exception Report Summary
success = PerformEmailProcess(1, fileName, desFilePath, ThreadName, IMSData, mDetails, false);
// Email IMS Summary Report
success = PerformEmailProcess(2, fileName, desFilePath, ThreadName, IMSData, mDetails, false);
// Delete Processed files from database
db.DeleteIMSFileProcessed(mDetails.IMSProcessId);
if (db.ErrorMessage.Trim().Length > 0)
{
success = false;
IAPL.Transport.Util.TextLogger.LogError("MessageTransaction-DeleteIMSFileProcessed()", "Database error: " + db.ErrorMessage);
}
else
{
// Delete Process from Temp table
db.DeleteIMSProcess(mDetails.IMSProcessId);
if (db.ErrorMessage.Trim().Length > 0)
{
success = false;
IAPL.Transport.Util.TextLogger.LogError("MessageTransaction-DeleteIMSFileProcessed()", "Database error: " + db.ErrorMessage);
}
}
}
return(success);
}
// ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
// **********************************************************
// Project: ISG12043
// Developer: Alrazen Estrella
// Date: Oct. 10, 2008
public static bool IMSSendEmailWhenNoFilesFound(string ThreadName,
IAPL.Transport.Transactions.MessageDetails mDetails,
bool IMSNoFilesFound)
{
bool success = true;
IAPL.Transport.IMS.Process.IMSReportDetails IMSDetailsStruct = new IAPL.Transport.IMS.Process.IMSReportDetails();
System.Collections.Hashtable IMSData = new System.Collections.Hashtable();
// Get the country list from the database
IAPL.Transport.Data.DbTransaction db = new IAPL.Transport.Data.DbTransaction();
db.GetIMSCountries(IAPL.Transport.Util.ConstantVariables.SP_GetIMSDetails, "IMSCountries");
if (db.ErrorMessage.Trim().Length > 0)
{
success = false;
IAPL.Transport.Util.TextLogger.LogError("MessageTransaction-ProcessIMS()", "Database error: " + db.ErrorMessage);
}
else
{
System.Data.DataTable dTable = db.CommonDataTable;
if (dTable == null)
{
success = false;
}
else
{
// Set initial value
foreach (System.Data.DataRow row in dTable.Rows)
{
IMSDetailsStruct.Country = IAPL.Transport.Util.CommonTools.ValueToString((Object)row["CountryName"]);
IMSDetailsStruct.CountryCode = IAPL.Transport.Util.CommonTools.ValueToString((Object)row["Code"]);
IMSDetailsStruct.ERS_Issue = "NO FILE RECEIVED";
IMSDetailsStruct.CommentResolution = "NO FILE RECEIVED";
//IMSDetailsStruct.DataFileRecvd = "";
//IMSDetailsStruct.TransactionDate = "";
//IMSDetailsStruct.RecordCount = 0;
//IMSDetailsStruct.IMSExtractionValue = 0;
IMSData.Add(IMSDetailsStruct.CountryCode, IMSDetailsStruct);
}
}
//Gerard Jan 12 2009
System.Data.DataTable _dt = db.GetLastSendDate(mDetails.MessageCode, mDetails.ERP, mDetails.Principal);
IMSMailStatus _mailStatus = new IMSMailStatus();
if (_dt.Rows.Count == 0)
{
Console.WriteLine("IMSSendEmailWhenNoFilesFound-- Initial Run -- updating tables");
//first run no entries found create an entry
db.SaveIMSMailStatus(mDetails.MessageCode, mDetails.Principal, mDetails.ERP);
_dt = db.GetLastSendDate(mDetails.MessageCode, mDetails.ERP, mDetails.Principal);
//_lastSendDate = Convert.ToDateTime(_dt.Rows[0][0]);
_mailStatus.LastSendDate = Convert.ToDateTime(_dt.Rows[0][0]);
_mailStatus.MailSent = Convert.ToBoolean(_dt.Rows[0][1]);
Console.WriteLine("IMSSendEmailWhenNoFilesFound Mail is being sent. -- Exception Report sent");
//Send both reports
//Email Summary Report
//success = PerformEmailProcess(1, "", "", ThreadName, IMSData, mDetails, true);
// Email Exception Report
success = PerformEmailProcess(2, "", "", ThreadName, IMSData, mDetails, true);
//Update mail sent
db.SaveIMSMailStatus(mDetails.MessageCode, mDetails.Principal, mDetails.ERP);
}
else
{
Console.WriteLine("IMSSendEmailWhenNoFilesFound -- Entry Found -- Proceeding with mail send logic.");
//entry found
_mailStatus.LastSendDate = Convert.ToDateTime(_dt.Rows[0][0]);
_mailStatus.MailSent = Convert.ToBoolean(_dt.Rows[0][1]);
if (_mailStatus.MailSent == false)
{
Console.WriteLine("IMSSendEmailWhenNoFilesFound Mail is being sent. -- Exception Report Sent --");
//Send both reports
//Email Summary Report
//success = PerformEmailProcess(1, "", "", ThreadName, IMSData, mDetails, true);
// Email Exception Report Summary
success = PerformEmailProcess(2, "", "", ThreadName, IMSData, mDetails, true);
//Update mail sent
db.SaveIMSMailStatus(mDetails.MessageCode, mDetails.Principal, mDetails.ERP);
}
else
{
if (_mailStatus.LastSendDate.ToShortDateString() == DateTime.Now.ToShortDateString())
{
//Do Nothing
Console.WriteLine("IMSSendEmailWhenNoFilesFound Mail already Sent today");
}
else
{
//update the mail status then send emails.
Console.WriteLine("IMSSendEmailWhenNoFilesFound - new day -- updating imsMailStatus and sending Exception Report mail");
//Email Summary Report
//success = PerformEmailProcess(1, "", "", ThreadName, IMSData, mDetails, true);
// Email Exception Report Summary
success = PerformEmailProcess(2, "", "", ThreadName, IMSData, mDetails, true);
db.SaveIMSMailStatus(mDetails.MessageCode, mDetails.Principal, mDetails.ERP);
}
}
}
//Mail hasn't been sent so send emails
// Delete Process from Temp table
db.DeleteIMSProcess(mDetails.IMSProcessId);
if (db.ErrorMessage.Trim().Length > 0)
{
success = false;
IAPL.Transport.Util.TextLogger.LogError("MessageTransaction-DeleteIMSFileProcessed()", "Database error: " + db.ErrorMessage);
}
}
return(success);
}
public EmailTransaction(IAPL.Transport.Transactions.MessageDetails messageInfo)
{
this.serverInformation = new ServerDetails();
this.messageInformation = messageInfo;
}
public EmailTransaction(IAPL.Transport.Transactions.ServerDetails transferInfo, IAPL.Transport.Transactions.MessageDetails messageInfo)
{
this.serverInformation = transferInfo;
this.messageInformation = messageInfo;
}
public void Dispose()
{
this.messageInformation = null;
this.serverInformation = null;
}
