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); }