private bool MFWERPTransactionWERPInsertion(int ProcessId, out int countTransactionsInserted, out int countRejectedRecords)
{
bool blResult = false;
processlogVo = new UploadProcessLogVo();
uploadsCommonBo = new UploadCommonBo();
werpUploadBo = new WerpUploadsBo();
countTransactionsInserted = 0;
countRejectedRecords = 0;
processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId);
// WERP Insertion
// WERP Equity Transation Insertion
WerpEQUploadsBo werpEQUploadsBo = new WerpEQUploadsBo();
string packagePath = Server.MapPath("\\UploadPackages\\EQTransactionUploadPackage\\EQTransactionUploadPackage\\EQTransactionUploadPackage\\UploadChecksOnEQTranStaging.dtsx");
bool WERPEQSecondStagingCheckResult = werpEQUploadsBo.WERPEQProcessDataInSecondStagingTrans(ProcessId, packagePath, configPath, adviserVo.advisorId);
if (WERPEQSecondStagingCheckResult)
{
packagePath = Server.MapPath("\\UploadPackages\\EQTransactionUploadPackage\\EQTransactionUploadPackage\\EQTransactionUploadPackage\\UploadEQTranStagingToWerp.dtsx");
bool WERPEQTranWerpResult = werpEQUploadsBo.WERPEQInsertTransDetails(ProcessId, packagePath, configPath); // EQ Trans XML File Type Id = 8);
if (WERPEQTranWerpResult)
{
processlogVo.IsInsertionToWERPComplete = 1;
processlogVo.NoOfTransactionInserted = uploadsCommonBo.GetTransUploadCount(ProcessId, "WPEQ");
processlogVo.NoOfRejectedRecords = uploadsCommonBo.GetTransUploadRejectCount(ProcessId, "WPEQ");
processlogVo.EndTime = DateTime.Now;
blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo);
}
}
return(blResult);
}
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 CommonTransChecks = false;
if (fileTypeId == 1)
{
bool camsDatatranslationCheckResult = uploadsCommonBo.UploadsCAMSDataTranslationForReprocess(ProcessId);
if (camsDatatranslationCheckResult)
{
CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserVo.advisorId, ProcessId, packagePath, configPath, "CA", "CAMS");
}
}
else if (fileTypeId == 3)
{
bool karvyDataTranslationCheck = uploadsCommonBo.UploadsKarvyDataTranslationForReprocess(ProcessId);
if (karvyDataTranslationCheck)
{
CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserVo.advisorId, ProcessId, packagePath, configPath, "KA", "Karvy");
}
}
else if (fileTypeId == 15)
{
bool TempletonDataTranslationCheck = uploadsCommonBo.UploadsTempletonDataTranslationForReprocess(ProcessId);
if (TempletonDataTranslationCheck)
{
CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserVo.advisorId, ProcessId, packagePath, configPath, "TN", "Templeton");
}
}
else if (fileTypeId == 17)
{
bool DeutscheDataTranslationCheck = uploadsCommonBo.UploadsDeutscheDataTranslationForReprocess(ProcessId);
if (DeutscheDataTranslationCheck)
{
CommonTransChecks = uploadsCommonBo.TransCommonChecks(adviserVo.advisorId, 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);
}
blResult = uploadsCommonBo.UpdateUploadProcessLog(processlogVo);
}
}
return(blResult);
}
protected void btnProbableInsert_Click(object sender, EventArgs e)
{
bool result = true;
bool blResult = true;
string gvStagingIds = "";
uploadsCommonBo = new UploadCommonBo();
processlogVo = uploadsCommonBo.GetProcessLogInfo(ProcessId);
int fileTypeId = processlogVo.FileTypeId;
rejectedRecordsBo = new RejectedRecordsBo();
foreach (GridDataItem gvRow in gvWERPTrans.MasterTableView.Items)
//foreach (GridViewRow gvRow in gvWERPTrans.Rows)
{
CheckBox ChkBxItem = (CheckBox)gvRow.FindControl("chkId");
if (ChkBxItem.Checked)
{
gvStagingIds += gvWERPTrans.MasterTableView.DataKeyValues[gvRow.RowIndex]["CMFTSId"].ToString() + ",";
}
}
result = rejectedRecordsBo.InsertProbableDuplicatesRejectedTransaction(gvStagingIds);
if (result)
{
// Success Message
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);
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Records Inserted Successfully');", true);
}
else
{
// Failure Message
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Please Select Probable Duplicate Records');", true);
}
BindEquityTransactionGrid(ProcessId);
}