//public DataSet GetClientListAcclaim(clsControlReports objctrlRpt)
        //{
        //    dataAccess = new DataAccess();
        //    Object[] parameters = new Object[15] { objctrlRpt.ClientCode,
        //    objctrlRpt.PreviousClientCode,  objctrlRpt.RecordType, objctrlRpt.VIPType ,objctrlRpt.CoRelatedClient , objctrlRpt.Type,
        //    objctrlRpt.BusinessType ,objctrlRpt.CorporateGroup,  objctrlRpt.ClientSource, objctrlRpt.IndustryType,objctrlRpt.EffFromDate , objctrlRpt.EffToDate,  objctrlRpt.KeyAccountManager, objctrlRpt.Intrducer1Code ,
        //    objctrlRpt.Intrducer2Code };

        //    return dataAccess.LoadDataSet(parameters, "P_ContentReports_ClientDetails", "ClientDetails");
        //}


        public DataSet GetCoverNoteRegisterList(clsCNRegister objCNRegister)
        {
            dataAccess = new DataAccess();
            Object[] parameters = new Object[19] {
                objCNRegister.CompanyId,
                objCNRegister.BranchId,
                objCNRegister.ClientCode,
                objCNRegister.Group,
                objCNRegister.SubGroup,
                objCNRegister.BusnessNCode,
                objCNRegister.SourceCode,
                objCNRegister.DebitNoteIssue,
                objCNRegister.POIDateFrom,
                objCNRegister.POIDateTo,
                objCNRegister.ExpiryPeriodFrom,
                objCNRegister.ExpiryPeriodTo,
                objCNRegister.CoverNoteDateFrom,
                objCNRegister.CoverNoteDateTo,
                objCNRegister.Class,
                objCNRegister.CoverNoteFrom,
                objCNRegister.CoverNoteTo,
                objCNRegister.Status,
                objCNRegister.BusinessType
            };
            return(dataAccess.LoadDataSet(parameters, "P_ContentReports_CoverNoteRegisterList", "UnderWriterDetails"));
        }
 public DataSet GetSuccessionReportList(clsCNRegister objCNRegister)
 {
     dataAccess = new DataAccess();
     Object[] parameters = new Object[14] {
         objCNRegister.CompanyId,
         objCNRegister.BranchId,
         objCNRegister.PotentialClientCode,
         objCNRegister.ClientCode,
         objCNRegister.Status,
         objCNRegister.BusinessType,
         objCNRegister.POIDateFrom,
         objCNRegister.POIDateTo,
         objCNRegister.ExpiryPeriodFrom,
         objCNRegister.ExpiryPeriodTo,
         objCNRegister.QuotationDateFrom,
         objCNRegister.QuotationDateTo,
         objCNRegister.QuotationNo,
         objCNRegister.Class
     };
     return(dataAccess.LoadDataSet(parameters, "P_Pol_RPT_Succession", "Succession"));
 }
 public DataSet GetPremiumAnalysisList(clsCNRegister objCNRegister)
 {
     dataAccess = new DataAccess();
     Object[] parameters = new Object[14] {
         objCNRegister.CompanyId,
         objCNRegister.BranchId,
         objCNRegister.ClientCode,
         objCNRegister.UNCode,
         objCNRegister.Group,
         objCNRegister.SubGroup,
         objCNRegister.BusnessNCode,
         objCNRegister.SourceCode,
         objCNRegister.POIDateFrom,
         objCNRegister.POIDateTo,
         objCNRegister.ExpiryPeriodFrom,
         objCNRegister.ExpiryPeriodTo,
         objCNRegister.DNDateFrom,
         objCNRegister.DNDateTo
     };
     return(dataAccess.LoadDataSet(parameters, "P_Pol_RPT_PremiumAnalysis", "PremiumAnalysis"));
 }