public SFTPMUFGBondFiles(ILogger <Worker> _logger)
{
this._logger = _logger;
try
{
DataSet ds = DBRepository.FillUpDataSetFromSp(EODModel.ConnectionString, "[ExportData].[getMUFGCircleAdaptorTrades]", null);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
this._logger.LogInformation("DataSet is not Blank for MUFG Trade File");
CheckForSpecialCharacter(ds);
GetSFTPDetails();
ExportMUFGCircleFiles(ds);
}
else
{
this._logger.LogInformation("DataSet is Blank for MUFG Trade Files and we don't have to send them the file for now. So suppressing the File Generation");
}
}
catch (Exception ex)
{
EmailSetup.SendEmail(MUFGCircleEmailDetails.Name, MUFGCircleEmailDetails.From, MUFGCircleEmailDetails.FromPassword, MUFGCircleEmailDetails.Host, MUFGCircleEmailDetails.Port,
MUFGCircleEmailDetails.EnableSsl, MUFGCircleEmailDetails.IsBodyHtml, MUFGCircleEmailDetails.To, "AutoAlert: MUFG circle files SFTP", "Exception Occur " + ex.ToString());
_logger.LogError("Exception Occurs " + ex.ToString());
}
}
public SFTPMUFGFxFiles(ILogger <Worker> _logger)
{
this._logger = _logger;
try
{
DataSet ds = new DataSet();
_logger.LogInformation("Hitting Stored procedure: [ExportData].[getMUFGCircleAdaptorFXTradesFinal]");
ds = DBRepository.FillUpDataSetFromSp(EODModel.ConnectionString, "[ExportData].[getMUFGCircleAdaptorFXTradesFinal]", null);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
this._logger.LogInformation("DataSet is not Blank for MUFG Trade File for FX");
GetSFTPDetails();
this._logger.LogInformation("Got SFTP details for FX , calling exportfile method.");
ExportMUFGCircleFiles(ds);
}
else
{
this._logger.LogInformation("DataSet is Blank for MUFG FX Files and we don't have to send them the file for now. So suppressing the File Generation");
}
}
catch (Exception ex)
{
EmailSetup.SendEmail(MUFGCircleEmailDetails.Name, MUFGCircleEmailDetails.From, MUFGCircleEmailDetails.FromPassword, MUFGCircleEmailDetails.Host, MUFGCircleEmailDetails.Port,
MUFGCircleEmailDetails.EnableSsl, MUFGCircleEmailDetails.IsBodyHtml, MUFGCircleEmailDetails.To, "AutoAlert: MUFG circle files SFTP", "Exception Occur " + ex.ToString());
_logger.LogError("Exception Occurs " + ex.ToString());
}
}
public void ExportMUFGCircleFiles(DataSet ds)
{
string csv = String.Empty;
string errorstring = "";
DataTable dtMUFGCircle = ds.Tables[0];
int i = 0;
while (i < dtMUFGCircle.Columns.Count)
{
csv += dtMUFGCircle.Columns[i].ToString().Replace(" ", "") + ",";
i++;
}
csv += "\r\n";
for (int row = 0; row < dtMUFGCircle.Rows.Count; row++)
{
i = 0;
while (i < dtMUFGCircle.Columns.Count)
{
csv += dtMUFGCircle.Rows[row][i].ToString() + ",";
i++;
}
csv += "\r\n";
}
if (!Directory.Exists(FilePath))
{
Directory.CreateDirectory(FilePath);
}
string mufgCircleFileName = filenames[0] + "_" + DateTime.Now.ToString("yyyyMMdd") + "_" + DateTime.Now.ToString("hhmmss") + ".csv";
string completeMUFGCircleFileName = FilePath + mufgCircleFileName;
File.WriteAllText(completeMUFGCircleFileName, csv);
string filenameposted = mufgCircleFileName;
var PostPath = Path.Combine(FilePath + "\\Post");
if (!Directory.Exists(PostPath))
{
Directory.CreateDirectory(PostPath);
}
try
{
if (WinSFTP.SFTPHelper(sftpServerIP, sftpUserID, sftpPassword, sftpPort, stringHostKey, stringToPath + filenameposted, completeMUFGCircleFileName, ref errorstring))
{
UpdateMUFGCircleSFTPStatus(ds);
if (!System.IO.File.Exists(PostPath + "\\" + filenameposted))
{
_logger.LogInformation("File Transferred Successfully to Admin");
File.Move(completeMUFGCircleFileName, PostPath + "\\" + filenameposted);
_logger.LogInformation("MUFG Circle File has been moved to Posted Directory");
//EmailSetup.SendEmail(MUFGCircleEmailDetails.Name, MUFGCircleEmailDetails.From, MUFGCircleEmailDetails.FromPassword, MUFGCircleEmailDetails.Host, MUFGCircleEmailDetails.Port, MUFGCircleEmailDetails.EnableSsl, MUFGCircleEmailDetails.IsBodyHtml, MUFGCircleEmailDetails.To, "AutoAlert: MUFG Circle SFTP", "MUFG Circle File Successfully Transferred to Admin");
}
}
}
catch (Exception exError)
{
EmailSetup.SendEmail(MUFGCircleEmailDetails.Name, MUFGCircleEmailDetails.From, MUFGCircleEmailDetails.FromPassword, MUFGCircleEmailDetails.Host,
MUFGCircleEmailDetails.Port, MUFGCircleEmailDetails.EnableSsl, MUFGCircleEmailDetails.IsBodyHtml, MUFGCircleEmailDetails.To, "AutoAlert: MUFG Circle SFTP", "Exception Occur " + exError);
_logger.LogError("Exception Occur " + exError.ToString() + "MovedPath : " + PostPath + "\\" + filenameposted);
}
}