public DataTable GetBrokerageCalculationStatus(int reqId, DateTime FromDate, DateTime ToDate)
        {
            WERPTaskRequestManagementDao requestManagementDao = new WERPTaskRequestManagementDao();

            try
            {
                return(requestManagementDao.GetBrokerageCalculationStatus(reqId, FromDate, ToDate));
            }
            catch (BaseApplicationException ex)
            {
                throw (ex);
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "WERPTaskRequestManagementBo:GetBrokerageCalculationStatus(int reqId,DateTime FromDate,DateTime ToDate)");
                object[] objects = new object[12];
                objects[0]   = reqId;
                objects[1]   = FromDate;
                objects[2]   = ToDate;
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
        }
        public DataTable GetBrokerageCalculationStatus(string product, string productCategory, int amc, int issueId, string commissionType, int month, int year)
        {
            WERPTaskRequestManagementDao requestManagementDao = new WERPTaskRequestManagementDao();

            return(requestManagementDao.GetBrokerageCalculationStatus(product, productCategory, amc, issueId, commissionType, month, year));
        }