private bool MFWERPSIPTransactionInsertion(int UploadProcessId)
{
bool blResult = false;
processlogVo = new UploadProcessLogVo();
uploadsCommonBo = new UploadCommonBo();
CamsUploadsBo camsUploadsBo = new CamsUploadsBo();
bool camsSIPCommonStagingChk = false;
bool camsSIPCommonStagingToWERP = false;
bool updateProcessLog = false;
string packagePath;
string fileType = "CA";
processlogVo = uploadsCommonBo.GetProcessLogInfo(UploadProcessId);
if (processlogVo.FileTypeId == 20)
{
fileType = "CA";
}
else if (processlogVo.FileTypeId == 26)
{
fileType = "WPT";
}
else if (processlogVo.FileTypeId == 27)
{
fileType = "KA";
}
packagePath = Server.MapPath("\\UploadPackages\\CAMSSystematicUploadPackageNew\\CAMSSystematicUploadPackageNew\\UploadSIPCommonStagingCheck.dtsx");
camsSIPCommonStagingChk = camsUploadsBo.CamsSIPCommonStagingChk(UploadProcessId, packagePath, configPath, fileType);
processlogVo.NoOfTransactionInserted = uploadsCommonBo.GetUploadSystematicInsertCount(UploadProcessId, fileType);
updateProcessLog = uploadsCommonBo.UpdateUploadProcessLog(processlogVo);
if (camsSIPCommonStagingChk)
{
packagePath = Server.MapPath("\\UploadPackages\\CAMSSystematicUploadPackageNew\\CAMSSystematicUploadPackageNew\\UploadSIPCommonStagingToWERP.dtsx");
camsSIPCommonStagingToWERP = camsUploadsBo.CamsSIPCommonStagingToWERP(UploadProcessId, packagePath, configPath);
if (camsSIPCommonStagingToWERP)
{
processlogVo.IsInsertionToWERPComplete = 1;
processlogVo.EndTime = DateTime.Now;
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetUploadSystematicRejectCount(UploadProcessId, fileType);
blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo);
}
}
return(blResult);
}
public bool MFTrailTransactionInsertion(int UploadProcessId)
{
bool blResult = false;
uploadProcessLogVo = new UploadProcessLogVo();
uploadsCommonBo = new UploadCommonBo();
CamsUploadsBo camsUploadsBo = new CamsUploadsBo();
bool TempletonTrailCommonStagingChk = false;
bool TempletonTrailCommonStagingToSetUp = false;
bool updateProcessLog = false;
string packagePath;
uploadProcessLogVo = uploadsCommonBo.GetProcessLogInfo(UploadProcessId);
packagePath = Server.MapPath("\\UploadPackages\\TrailCommisionUploadPackage\\TrailCommissionUpload\\TrailCommissionUpload\\callOnReprocess.dtsx");
TempletonTrailCommonStagingChk = uploadsCommonBo.TrailCommissionCommonStagingCheck(adviserId, UploadProcessId, packagePath, configPath);
uploadProcessLogVo.NoOfTransactionInserted = uploadsCommonBo.GetUploadSystematicInsertCount(UploadProcessId, "TN");
updateProcessLog = uploadsCommonBo.UpdateUploadProcessLog(uploadProcessLogVo);
if (TempletonTrailCommonStagingChk)
{
packagePath = Server.MapPath("\\UploadPackages\\TrailCommisionUploadPackage\\TrailCommissionUpload\\TrailCommissionUpload\\commonStagingToTrailSetUp.dtsx");
//TempletonTrailCommonStagingToSetUp = camsUploadsBo.CamsSIPCommonStagingToWERP(UploadProcessId, packagePath, configPath);
TempletonTrailCommonStagingToSetUp = camsUploadsBo.TempletonTrailCommissionCommonStagingChk(UploadProcessId, packagePath, configPath, "TN", adviserId);
if (TempletonTrailCommonStagingToSetUp)
{
uploadProcessLogVo.IsInsertionToWERPComplete = 1;
uploadProcessLogVo.EndTime = DateTime.Now;
uploadProcessLogVo.NoOfRejectedRecords = uploadsCommonBo.GetUploadSystematicRejectCount(UploadProcessId, "TN");
blResult = uploadsCommonBo.UpdateUploadProcessLog(uploadProcessLogVo);
}
}
return(blResult);
}