public DataSet GetUploadProcessIDForSelectedFoliosANDAMC(int adviserid, int amccode, string folionum)
{
DataSet dsProcessIds;
RejectedRecordsDao rejecetedRecords = new RejectedRecordsDao();
try
{
dsProcessIds = rejecetedRecords.GetUploadProcessIDForSelectedFoliosANDAMC(adviserid, amccode, folionum);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RejectedRecordsBo.cs:GetUploadProcessIDForSelectedFoliosANDAMC()");
object[] objects = new object[3];
objects[0] = adviserid;
objects[1] = amccode;
objects[1] = folionum;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsProcessIds);
}
/// <summary>
/// To get rejected records from input table for all types of Transaction uploads
/// </summary>
/// <param name="ProcessID"></param> Process Id of the current adviser user
/// <param name="UploadExternalType"></param>The Upload file type which are Karvy, CAMS, Templeton, Dutsche and Standard
/// <param name="CurrentPage"></param>For paging purpose
/// <param name="Count"></param>No of records for paging purpose
/// <returns></returns>
public DataSet GetTransInputRejects(int ProcessId, string UploadExternalType, int CurrentPage, out int Count)
{
DataSet dsRejectedRecords;
RejectedRecordsDao rejecetedRecords = new RejectedRecordsDao();
try
{
dsRejectedRecords = rejecetedRecords.GetTransInputRejects(ProcessId, UploadExternalType, CurrentPage, out Count);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RejectedRecordsBo.cs:GetTransaInputRejects()");
object[] objects = new object[3];
objects[0] = ProcessId;
objects[1] = CurrentPage;
objects[2] = UploadExternalType;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsRejectedRecords);
}
public DataSet GetUploadMFRejectsDistinctFolios(int adviserid, int CurrentPage, out int Count)
{
DataSet dsRejectedRecords;
RejectedRecordsDao rejecetedRecords = new RejectedRecordsDao();
try
{
dsRejectedRecords = rejecetedRecords.GetUploadMFRejectsDistinctFolios(adviserid, CurrentPage, out Count);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RejectedRecordsBo.cs:GetUploadMFRejectsDistinctFolios()");
object[] objects = new object[2];
objects[0] = adviserid;
objects[1] = CurrentPage;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsRejectedRecords);
}
public bool UpdateRejectedMFTransactionStaging(int Id, string panNumber, string folio, string price, string transactionType)
{
bool result = false;
RejectedRecordsDao rejecetedRecords = new RejectedRecordsDao();
try
{
result = rejecetedRecords.UpdateRejectedMFTransactionStaging(Id, panNumber, folio, price, transactionType);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RejectedRecordsBo.cs:UpdateWERPTransactionStaging()");
object[] objects = new object[5];
objects[0] = Id;
objects[1] = panNumber;
objects[2] = folio;
objects[3] = price;
objects[4] = transactionType;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(result);
}
public bool UpdateRejectedTradeAccountStaging(int id, string TradeAccountNum, string PanNum)
{
bool result = false;
RejectedRecordsDao rejecetedRecords = new RejectedRecordsDao();
try
{
result = rejecetedRecords.UpdateRejectedTradeAccountStaging(id, TradeAccountNum, PanNum);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RejectedRecordsBo.cs:UpdateWERPTransactionStaging()");
object[] objects = new object[3];
objects[0] = id;
objects[1] = TradeAccountNum;
objects[2] = PanNum;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(result);
}
public DataSet getKarvyRejectedProfile(int processId, int CurrentPage, out int Count, string SortExpression, string IsRejectedFilter, string PANFilter, string RejectReasonFilter, string NameFilter, string FolioFilter, string DoesCustExistFilter)
{
DataSet dsKarvyRejectedProfile;
RejectedRecordsDao rejecetedRecords = new RejectedRecordsDao();
try
{
dsKarvyRejectedProfile = rejecetedRecords.getKarvyRejectedProfile(processId, CurrentPage, out Count, SortExpression, IsRejectedFilter, PANFilter, RejectReasonFilter, NameFilter, FolioFilter, DoesCustExistFilter);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RejectedRecordsBo.cs:getKarvyRejectedProfile()");
object[] objects = new object[2];
objects[0] = processId;
objects[1] = CurrentPage;
objects[2] = SortExpression;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsKarvyRejectedProfile);
}
public bool UpdateWERPTransactionStaging(int WerpStagingID, string TransactionNumber, string Folio)
{
bool result = false;
RejectedRecordsDao rejecetedRecords = new RejectedRecordsDao();
try
{
result = rejecetedRecords.UpdateWERPTransactionStaging(WerpStagingID, TransactionNumber, Folio);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RejectedRecordsBo.cs:UpdateWERPTransactionStaging()");
object[] objects = new object[3];
objects[0] = WerpStagingID;
objects[1] = TransactionNumber;
objects[2] = Folio;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(result);
}
public DataSet GetRejectedMFTransactionStaging(int adviserId, int CurrentPage, out int Count, string SortExpression, int processId, string RejectReasonFilter, string fileNameFilter, string FolioFilter, string TransactionTypeFilter, string investorNameFileter, string sourceTypeFilter, string schemeNameFilter)
{
DataSet dsWERPRejectedTransactions;
RejectedRecordsDao rejecetedRecords = new RejectedRecordsDao();
try
{
dsWERPRejectedTransactions = rejecetedRecords.GetRejectedMFTransactionStaging(adviserId, CurrentPage, out Count, SortExpression, processId, RejectReasonFilter, fileNameFilter, FolioFilter, TransactionTypeFilter, investorNameFileter, sourceTypeFilter, schemeNameFilter);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RejectedRecordsBo.cs:getWERPRejectedTransactions()");
object[] objects = new object[10];
objects[0] = processId;
objects[1] = CurrentPage;
objects[2] = SortExpression;
objects[3] = RejectReasonFilter;
objects[4] = fileNameFilter;
objects[5] = FolioFilter;
objects[6] = TransactionTypeFilter;
objects[7] = investorNameFileter;
objects[8] = sourceTypeFilter;
objects[9] = schemeNameFilter;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsWERPRejectedTransactions);
}
public DataSet GetRejectedEquityTransactionsStaging(int processId, int CurrentPage, out int Count,
string SortExpression, string RejectReasonFilter, string PanNumberFilter, string ScripFilter, string ExchangeFilter, string TransactionTypeFilter)
{
DataSet dsWERPRejectedTransactions;
RejectedRecordsDao rejecetedRecords = new RejectedRecordsDao();
try
{
dsWERPRejectedTransactions = rejecetedRecords.GetRejectedEquityTransactionsStaging(processId, CurrentPage, out Count,
SortExpression, RejectReasonFilter, PanNumberFilter, ScripFilter, ExchangeFilter, TransactionTypeFilter);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RejectedRecordsBo.cs:getWERPRejectedTransactions()");
object[] objects = new object[6];
objects[0] = processId;
objects[1] = CurrentPage;
objects[2] = SortExpression;
objects[3] = RejectReasonFilter;
objects[4] = PanNumberFilter;
objects[5] = ScripFilter;
objects[6] = ExchangeFilter;
objects[7] = TransactionTypeFilter;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsWERPRejectedTransactions);
}
public DataSet getWERPRejectedProfile(int processId, int CurrentPage, out int Count, string SortExpression, string PANFilter, string RejectReasonFilter, string BrokerFilter, string CustomerNameFilter)
{
DataSet dsWERPRejectedProfiles;
RejectedRecordsDao rejecetedRecords = new RejectedRecordsDao();
try
{
dsWERPRejectedProfiles = rejecetedRecords.getWERPRejectedProfiles(processId, CurrentPage, out Count, SortExpression, PANFilter, RejectReasonFilter, BrokerFilter, CustomerNameFilter);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RejectedRecordsBo.cs:getWERPRejectedProfile()");
object[] objects = new object[9];
objects[0] = processId;
objects[1] = CurrentPage;
objects[2] = SortExpression;
objects[3] = PANFilter;
objects[4] = RejectReasonFilter;
objects[5] = CustomerNameFilter;
objects[6] = BrokerFilter;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsWERPRejectedProfiles);
}
public DataSet getCAMSRejectedTrans(int processId, int CurrentPage, out int Count, string SortExpression, string IsRejectedFilter, string RejectReasonFilter, string FolioFilter)
{
DataSet dsCAMSRejectedTrans;
RejectedRecordsDao rejecetedRecords = new RejectedRecordsDao();
try
{
dsCAMSRejectedTrans = rejecetedRecords.getCAMSRejectedTrans(processId, CurrentPage, out Count, SortExpression, IsRejectedFilter, RejectReasonFilter, FolioFilter);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RejectedRecordsBo.cs:getCAMSRejectedTrans()");
object[] objects = new object[6];
objects[0] = processId;
objects[1] = CurrentPage;
objects[2] = SortExpression;
objects[3] = IsRejectedFilter;
objects[4] = RejectReasonFilter;
objects[5] = FolioFilter;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsCAMSRejectedTrans);
}
public void DeleteMFTransactionStaging(int StagingID)
{
RejectedRecordsDao rejecetedRecords = new RejectedRecordsDao();
rejecetedRecords.DeleteMFTransactionStaging(StagingID);
}
