public void GetSFTPDetails()
{
var Param1 = new SqlParameter("@AdminName", SqlDbType.NVarChar)
{
Value = "MUFGCircle"
};
var Param2 = new SqlParameter("@FileType", SqlDbType.NVarChar)
{
Value = "All"
};
var prms = new List <SqlParameter> {
Param1, Param2
};
dtSFTPCred = DBRepository.FillUpDataSetFromSp(EODModel.ConnectionString, "[ExportData].[ExtractSFTPDetails]", prms).Tables[0];
_logger.LogInformation("Get SFTP Credenitals Successfully for MUFGCircle");
if (dtSFTPCred != null)
{
foreach (var details in dtSFTPCred.Select("FileType='MUFGCircleAll'"))
{
sftpServerIP = details["IPAddress"].ToString();
sftpUserID = details["UserName"].ToString();
sftpPassword = details["Password"].ToString();
Int32.TryParse(details["Port"].ToString(), out sftpPort);
stringToPath = details["DestinationPath"].ToString();
stringHostKey = details["HostKey"].ToString();
FileName = details["FileName"].ToString();
FilePath = details["FilePath"].ToString();
}
filenames = FileName.Split(";");
}
}
public void GetSFTPDetailsforverification()
{
var Param1 = new SqlParameter("@AdminName", SqlDbType.NVarChar)
{
Value = "MUFGCircle"
};
var Param2 = new SqlParameter("@FileType", SqlDbType.NVarChar)
{
Value = "All"
};
var prms = new List <SqlParameter> {
Param1, Param2
};
sftpdata = DBRepository.FillUpDataSetFromSp(EODModel.ConnectionString, "[ExportData].[ExtractSFTPDetails]", prms).Tables[0];
if (sftpdata != null)
{
_logger.LogInformation("Get SFTP Credenitals Successfully for MUFGCircle");
foreach (DataRow details in sftpdata.Select("FileType='MUFGCircleAll'"))
{
sftpServerIP = "sftp.mfsadmin.com";
sftpUserID = details["UserName"].ToString();
sftpPassword = details["Password"].ToString();
Int32.TryParse(details["Port"].ToString(), out sftpPort);
stringHostKey = details["HostKey"].ToString();
DestinationFilePath = FileDetails.DestinationFilePath;
SourcefilePath = "/confirmresponses/";
}
filenames = FileName.Split(";");
}
}
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 Counterpartyfile(ILogger <Worker> _logger)
{
this._logger = _logger;
DataSet ds = DBRepository.FillUpDataSetFromSp(EODModel.ConnectionString, "[ExportData].[counterpartylist]", 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);
string csv = String.Empty;
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";
}
string mufgCircleFileName = filenames[0] + "_" + "Bond_" + DateTime.Now.ToString("yyyyMMdd") + "_" + DateTime.Now.ToString("hhmmss") + ".csv";
File.WriteAllText(mufgCircleFileName, csv);
File.Move(mufgCircleFileName, "Z:" + "\\");
}
}
