public DataSet GetAgentList(clsControlReports objControlReports)
 {
     dataAccess = new DataAccess();
     Object[] parameters = new Object[2] {
         objControlReports.AgentCode, objControlReports.CountryCode
     };
     return(dataAccess.LoadDataSet(parameters, "P_ContentReports_AgentDetails", "AgentDetails"));
 }
 public DataSet GetUWrList(clsControlReports objControlReports)
 {
     dataAccess = new DataAccess();
     Object[] parameters = new Object[2] {
         objControlReports.UnderwriterCode, objControlReports.CountryCode
     };
     return(dataAccess.LoadDataSet(parameters, "P_ContentReports_UWDetails", "UnderWriterDetails"));
 }
        public DataSet GetClaimsCodeList(clsControlReports objctrlRpt)
        {
            dataAccess = new DataAccess();
            Object[] parameters = new Object[11] {
                objctrlRpt.IsClaimHandler, objctrlRpt.IsAccountHandler, objctrlRpt.IsHealthCare, objctrlRpt.IsSurveyor, objctrlRpt.IsLossAdjuster, objctrlRpt.IsSolicitor, objctrlRpt.IsNatureofInjury, objctrlRpt.IsCauseofInjury, objctrlRpt.IsPartofBodyInjured, objctrlRpt.IsLossNature, objctrlRpt.IsCauseofLoss
            };

            return(dataAccess.LoadDataSet(parameters, "P_ContentReports_ClaimsCodeDetails", "ClaimsCodeDetails"));
        }
        public DataSet GetGroupandSubGroup(clsControlReports objControlReports)
        {
            dataAccess = new DataAccess();
            Object[] parameters = new Object[2] {
                objControlReports.GroupCode, objControlReports.SubGroupCode
            };

            return(dataAccess.LoadDataSet(parameters, "P_ContentReports_GroupandSubGroup", "GroupandSubGroupDetails"));
        }
        public DataSet GetAnalysisCodeList(clsControlReports objControlReports)
        {
            dataAccess = new DataAccess();
            Object[] parameters = new Object[5] {
                objControlReports.IsSourceCode, objControlReports.IsBranchCode, objControlReports.IsClassCode, objControlReports.IsNRP, objControlReports.IsBusinessNatureCode
            };

            return(dataAccess.LoadDataSet(parameters, "P_ContentReports_AnalysisCodeDetails", "AnalysisCodeDetails"));
        }
        public DataSet GetClientList(clsControlReports objctrlRpt)
        {
            dataAccess = new DataAccess();
            Object[] parameters = new Object[25] {
                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, objctrlRpt.GroupId, objctrlRpt.SubGroupId, objctrlRpt.BNCID, objctrlRpt.Lapsed, objctrlRpt.SendNote, objctrlRpt.SourceCodeId, objctrlRpt.CountryCode, objctrlRpt.IsCorprate, objctrlRpt.ISVIP, objctrlRpt.TeamId
            };

            return(dataAccess.LoadDataSet(parameters, "P_ContentReports_ClientDetails", "ClientDetails"));
        }
        //
        public DataSet GetPotentialClientListUnapproved(clsControlReports objctrlRpt)
        {
            dataAccess = new DataAccess();
            Object[] parameters = new Object[5] {
                objctrlRpt.ClientCode,
                objctrlRpt.PolClientCode,
                //objctrlRpt.GroupId,
                //objctrlRpt.SubGroupId,
                //objctrlRpt.BNCID,
                //objctrlRpt.SourceCodeId,
                objctrlRpt.CountryCode,
                objctrlRpt.IsCorprate,
                objctrlRpt.ISVIP
            };

            return(dataAccess.LoadDataSet(parameters, "P_ControlReports_PolClientDetails_UnApproved", "PolClientDetails"));
        }