private bool MFWERPTransactionWERPInsertion(int ProcessId, out int countTransactionsInserted, out int countRejectedRecords, int fileTypeId)
{
bool blResult = false;
processlogVo = new UploadProcessLogVo();
uploadsCommonBo = new UploadCommonBo();
werpUploadBo = new WerpUploadsBo();
countTransactionsInserted = 0;
countRejectedRecords = 0;
processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId);
//CAMS and KARVY Reprocess
string packagePath = Server.MapPath("\\UploadPackages\\MFTransactionCommonUploadPackage\\MFTransactionCommonUploadPackage\\MFTransactionCommonUploadPackage\\ChecksCommonUploadPackage.dtsx");
bool CommonStdTransChecks = false;
bool CommonTransChecks = false;
if (fileTypeId == 1)
{
bool camsDatatranslationCheckResult = uploadsCommonBo.UploadsCAMSDataTranslationForReprocess(ProcessId);
if (camsDatatranslationCheckResult)
{
CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserId, ProcessId, packagePath, configPath, "CA", "CAMS");
}
}
else if (fileTypeId == 25)
{
bool camsDatatranslationCheckResult = uploadsCommonBo.UploadsCAMSDataTranslationForReprocess(ProcessId);
if (camsDatatranslationCheckResult)
{
CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserId, ProcessId, packagePath, configPath, "SU", "Sundaram");
}
}
//***reprocess for folioandTrnx
else if (fileTypeId == 6)
{
standardProfileUploadBo = new StandardProfileUploadBo();
string stdPackagePath = Server.MapPath("\\UploadPackages\\StandardFolioUploadPackageNew\\StandardFolioUploadPackageNew\\UploadsStandardMFTrxnStagingChk.dtsx");
CommonStdTransChecks = standardProfileUploadBo.StdCommonProfileChecks(ProcessId, adviserId, stdPackagePath, configPath);
}
else if (fileTypeId == 3)
{
bool karvyDataTranslationCheck = uploadsCommonBo.UploadsKarvyDataTranslationForReprocess(ProcessId);
if (karvyDataTranslationCheck)
{
CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserId, ProcessId, packagePath, configPath, "KA", "Karvy");
}
}
else if (fileTypeId == 15)
{
bool TempletonDataTranslationCheck = uploadsCommonBo.UploadsTempletonDataTranslationForReprocess(ProcessId);
if (TempletonDataTranslationCheck)
{
CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserId, ProcessId, packagePath, configPath, "TN", "Templeton");
}
}
else if (fileTypeId == 17)
{
bool DeutscheDataTranslationCheck = uploadsCommonBo.UploadsDeutscheDataTranslationForReprocess(ProcessId);
if (DeutscheDataTranslationCheck)
{
CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserId, ProcessId, packagePath, configPath, "DT", "Deutsche");
}
}
if (CommonTransChecks)
{
packagePath = Server.MapPath("\\UploadPackages\\MFTransactionCommonUploadPackage\\MFTransactionCommonUploadPackage\\MFTransactionCommonUploadPackage\\InsertTransactionIntoWERP.dtsx");
bool insertTransWERP = uploadsCommonBo.InsertTransToWERP(ProcessId, packagePath, configPath);
if (insertTransWERP)
{
processlogVo.IsInsertionToWERPComplete = 1;
processlogVo.NoOfTransactionInserted = uploadsCommonBo.GetTransUploadCount(ProcessId, "WPMF");
processlogVo.EndTime = DateTime.Now;
if (fileTypeId == 1)
{
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeCAMS);
}
else if (fileTypeId == 3)
{
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeKarvy);
}
else if (fileTypeId == 15)
{
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeTemp);
}
else if (fileTypeId == 17)
{
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeDeutsche);
}
else if (filetypeId == 25)
{
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, "SU");
}
blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo);
}
}
else if (CommonStdTransChecks)
{
processlogVo.IsInsertionToWERPComplete = 1;
processlogVo.NoOfTransactionInserted = uploadsCommonBo.GetTransUploadCount(ProcessId, "WP");
processlogVo.EndTime = DateTime.Now;
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, Contants.UploadExternalTypeStandard);
blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo);
}
return(blResult);
}